Go Back   EQEmulator Home > EQEmulator Forums > General > General::General Discussion

General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2017, 05:45 PM
dracir
Sarnak
 
Join Date: Dec 2017
Location: US
Posts: 43
Default 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 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.
Reply With Quote
  #2  
Old 12-12-2017, 10:00 PM
dracir
Sarnak
 
Join Date: Dec 2017
Location: US
Posts: 43
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:27 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3