Tried to edit spells on my local server - broke all my spells
Hi,
I recently managed to start my own eqemu server, and I was attempting to edit spells (trying to make certain spells castable by all classes). Short story is now I somehow broke all the spells so now no spells will cast, and trying to forget a spell returns a spellid out of range error.
I'm using the Underfoot client.
A detailed explanation of what I tried to do is
1) Downloaded GeorgeS' Spell Editor tool, imported spells_us.txt and exported it and tried to edit the spell there.
2) When I tested it out, the spells broke (all spells wouldn't cast, saying that I had to be in battle to us it). I assumed I messed up and tried to revert all my changes by dropping the spells_new table
3) Tried editing spells_us.txt manually, but now spells wouldn't cast at all (no "You need to be in battle to use this spell" message even).
4) Reverted spells_us.txt file, but same error persists.
I didn't think spells were stored in the db since I couldn't find any obvious db table named "spells" or something like that. Is there something I can do to revert my server back to a working state now without deleting all my characters/bots?
|