Spell table in database

[grimcoder]

Read this thread, should answer it and don't forget to read the readme.txt file that came with angelox's database.

http://eqemulator.net/forums/showthread.php?t=21483

[jeffpuff]

I see that Angelox updated some npc_spell_entries, but my question is the overall function of the Spells table.

I have been trying to modify some spell resists to get fear to be less of a pain and slows to be not so impossible to land, but my PEQ database that has no table at all called Spells has been working fine, with npc casters casting spells/pets. So does this table overide the information in the spells_en.txt and spells_us.txt files and a database without this table will just default to these files?

[John Adams]

It's a good question that I haven't gotten around to asking as well. table "spells" seems to get created when you setup the PEQEditor web interface (or mine was anyway). I never understood why, because as you said - EQEmu seems to run fine without it before.

Is it one of those "if it's there, I'll use it, otherwise I'm sticking to _____"?

PEQEditors README.TXT file

Step 5:

Source schema.sql (in the editor's /sql directory) into your database first, then source in allspells.sql.

[Angelox]

Originally Posted by John Adams

It's a good question that I haven't gotten around to asking as well. table "spells" seems to get created when you setup the PEQEditor web interface (or mine was anyway). I never understood why, because as you said - EQEmu seems to run fine without it before.

Is it one of those "if it's there, I'll use it, otherwise I'm sticking to _____"?

PEQEditors README.TXT file

Step 5:

Source schema.sql (in the editor's /sql directory) into your database first, then source in allspells.sql.

I *think* PEQEditor needs this table for it's own reference, If you don't have it, it will affect the PEQ editor.

Also "spells" is a great reference to what type of spell you're looking at, always good to have all the visual input you can get.