Code:
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
Code:
SET le.enabled - 0;
Something like that I guess?
--Will update when i figured it out for sure.