Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2018, 06:00 AM
GlassDeviant's Avatar
GlassDeviant
Sarnak
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 66
Default caster school specialization

I had forgotten about the school specs, and let my Enchanter go over 50 in Spec Evocation. I've determined that the character id is 6 and that Spec Evocation is skill_id 47 (because it's the only skill at level 74 in the table), so I have put together this SQL statement:

update character_skills set value = 45 where id = 6 and skill_id = 47;

I'm pretty sure the SQL is valid, but I am wondering what adverse effects there might be on this character, like not being able to level a different spec due to some flag or value elsewhere in the db that I am unaware of.

Edit: This is on a solo server btw.
__________________
-GD
Reply With Quote
  #2  
Old 10-15-2018, 10:50 AM
Jorin
Sarnak
 
Join Date: Aug 2018
Posts: 48
Default

I could be wrong but I dont believe there will be any issues.
Reply With Quote
  #3  
Old 10-15-2018, 11:36 AM
GlassDeviant's Avatar
GlassDeviant
Sarnak
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 66
Default

Thanks, it's been working so far but I'm new at this whole "running an EQ server" thing.

Cheers,
__________________
-GD
Reply With Quote
  #4  
Old 10-15-2018, 11:59 AM
Jorin
Sarnak
 
Join Date: Aug 2018
Posts: 48
Default

No worries. Im learning as I go also, but i encountered a similiar problem, i just reset my specializations and never noticed an issue from doing so.
Reply With Quote
  #5  
Old 10-15-2018, 02:40 PM
GlassDeviant's Avatar
GlassDeviant
Sarnak
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 66
Default

I'm just glad I have some experience with SQL databases from way back, or I'd be pretty lost.
__________________
-GD
Reply With Quote
  #6  
Old 10-15-2018, 02:47 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,165
Default

There is a quest to rest specializations :P
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 10:58 AM.


 

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