EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   caster school specialization (https://www.eqemulator.org/forums/showthread.php?t=42128)

GlassDeviant 10-15-2018 06:00 AM

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.

Jorin 10-15-2018 10:50 AM

I could be wrong but I dont believe there will be any issues.

GlassDeviant 10-15-2018 11:36 AM

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

Cheers,

Jorin 10-15-2018 11:59 AM

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.

GlassDeviant 10-15-2018 02:40 PM

I'm just glad I have some experience with SQL databases from way back, or I'd be pretty lost.

demonstar55 10-15-2018 02:47 PM

There is a quest to rest specializations :P


All times are GMT -4. The time now is 09:39 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.