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.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 


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 11:33 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