Tried to edit spells on my local server - broke all my spells

[e030039]

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?

[e030039]

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.

[lerxst2112]

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.

[Nagus69]

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

Same with Items, Factions etc etc.

[thepoetwarrior]

Originally Posted by Nagus69

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.