Thinking Outloud - Disabling 70+ aa's with HeidiSQL

[dracir]

SELECT le.* FROM aa_ranks i INNER JOIN aa_ability le on i.id = le.first_rank_id WHERE i.level_req >= 71;

I'm super new to this. Figured i would post it here in-case someone wants to speed the process along.
I'm at work, so i can't test it yet. So mostly theory crafting code.

I am looking to disable aa's that are higher than level 70.
aa_ranks has the level requirement and cost.
aa_ability has the names and aa_id's that join on aa_ranks.

Figured i would inner join them.
then

SET le.enabled - 0;

Something like that I guess?
--Will update when i figured it out for sure.

[dracir]

Well. I couldn't figure out how to set them all enabled = 0;
So i just did it manually. lmao.
The Select worked great, except it only included aa's that start at level 71+

I'll have to figure out another way to get rid of the ones that has ranks that are 71+.

From what I can tell. aa_ranks are what link the ranks together. prev_id and next_id
when next_id is set to -1, it means that it is the last rank. if -1 in the prev_id that means its the first.

I am finding a difficult time editing these fields. I was hoping to go through manually and toss -1 on next_id of aa's that go past level 70.
The auto update to what they were... foopity poopity.