To change your source to use the spells_new table instead of the spell files, just do the following:
Open /zone/spdat.h
Find this section near the top of the file around line 42:
Code:
#define NEW_LoadSPDat
//#define DB_LoadSPDat //load from DB vs spells_us.txt. for now, we're piggybacking NEW_LoadSPDat, so it will take precedence
And change it to this:
Code:
//#define NEW_LoadSPDat
#define DB_LoadSPDat //load from DB vs spells_us.txt. for now, we're piggybacking NEW_LoadSPDat, so it will take precedence
And then save the changes and recompile your source. That is all there is to it. All you are doing is commenting out the define to use the old spell file way and uncommenting out the define to use the new table way of loading spells instead.
nosfentora,
It sounds like your spells aren't being loaded at all by the server. Was it previously working with the SoF spells_us.txt file, or is this the first time you tried the SoF spell file. Can you try the Titanium spell file and see if it works? I know that the SoF spells work if you load them into the database, because of how the table is handled. But, since Titanium and SoF both have different number of fields in them, it might just be that the server doesn't know how to handle the extra fields in the SoF spell file. The database table is setup with all of the fields up to Live I believe, and is able to handle them all, so it works with either Titanium or SoF spell files if you import them in. PEQ should come with the Titanium spell file already loaded into the spells_new table, so if you enable it in the source, they should work automatically. But, if you are wanting to use the SoF spell file as your default spell file, you will need to use the import perl scripts to import the spells_us.txt from SoF into your spells_new table.
arcerean,
I believe they are referring to the #scribespells command, which does take a level argument. You are referring to the quest command quest::scribespells($level), which was changed a long time ago.