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?

Okay, I think I solved this. I'm a dummy
 

Alright, it turns out that spells_new was not some sort of intermediate table only used by the tools, which was what I thought based on some google results.

In case anyone else runs into the same issues I have, this is the following fix.

1) Recreate the spells table from the original SQL dump (in my case peqdb_rev2142.sql)
2) Shut down the server and restart it. The db appears to be cached, so if you try logging in and out again spells still won't work.

Yes, spells are only loaded on the server once when it starts. Changing the table requires a server restart. If you change the database table you also need to export it to a spell file for your clients. There are two formats for the client file, Titanium and SoF+. If you have both types of clients you'll need to export twice.

When you get the "you must be in combat" message it generally means you're using a Titanium style spell file on a non-Titanium client.

Would rock if that would be more modular, so you could issue a #spellfile reload.

Same with Items, Factions etc etc.

I would like that too.