Log in

View Full Version : caster school specialization


GlassDeviant
10-15-2018, 06:00 AM
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