Thinking Outloud - Disabling 70+ aa's with HeidiSQL
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 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; --Will update when i figured it out for sure. |
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. |
All times are GMT -4. The time now is 10:25 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.