Spell Editor + Export/Import
 

I'm told the current working version of a spell editor for my up to date database is Ailia&Bleh Spell Editor 2.0

First from command line I used the "perl export_spells.pl"

Then I load into editor, edit, save.

Then I did "perl import_spells.pl -d"

And now users complaining a lot of their spells are not working.

Good thing I made a backup of my spells table, so I just reverted back to that table.

Question. Why are the new spells I'm making not working anymore?

As I'm typing this out, I just kinda realized, maybe people were using the Titanium version of my spells_us.txt file. I think I forgot to re-export to a SoF compatiable version for my users, maybe that was it.

Anyways, going to try that. In mean time, can anyone verify which spell editor is working? If I remember, the spells table went thru minor changes in the last year? Would this affect anything with export, edit, import? Please let me know.

Thanks,

Hunter - EZ Server

Use Null's Spell editor, connect directly to your database and save only changes you make to your database, will make your life easier.

http://www.eqemulator.org/forums/sho...t=31419&page=4

Heard Nulls is broken currently.

Anyways, after importing the Titanium version, I had to export to a SoF version and reupload for my users, and seems to have worked fine.

I've used Nulls for thousands of spell edits. You can try an earlier version.

The only problem is using Null's with the most recent version of MySQL, as MySQL added 'range' as a reserved name which conflicts with the column name as the query used doesn't backtick the column names.

Or so I understand.

I use the PEQ PHP editor for spells and most other things, and phpmyadmin for everything else.