[strugglegenerator]

The druid/ranger Spell: Calefaction is missing from PEQ, so I'm trying to add it (unsuccessfully). Here's what I did...

Updated the "items" data table with the following:
1) Picked a similar item (Spell: Starfire, Item ID 15671) in the "items" data table
2) Duplicated the row for Spell: Starfire
3) Found an un-used item ID 116636 in the "items" data table
4) Copied all of the data from Spell: Starfire into the un-used item ID 116636
5) Changed the name of the spell from "Starfire" to "Calefaction"
6) Changed the "scrolleffect" from 671 to 13847

Updated the "spells_new" data table with the following:
1) Picked an unused spell (ID 13847)
2) Found Starfire's ID 671 and duplicated it's row
3) Changed the ID from 671 to 13847
4) Changed the "classes6" number to 44 (Druids)
5) Changed the "classes4" number to 59 (Rangers)
6) Changed the descrnum to 13847
7) Changed the mana, damage, range, recast time to match Calefaction

Updated the "db_str" data table with the following:
ID: 13847 Type: 1 Value: Calefaction
ID: 13847 Type: 2 Value: Calefaction
ID: 13847 Type: 4 Value: Ignites your target's skin, doing between 444 and 450 damage.

Exported my server files into the "export" folder
Copied the exported "spells_us.txt" and "dbstr_us.txt" server files into my EQclients root folder

Loaded up the server
Loaded up the client

Logged in.
Targeted myself and typed #giveitem 116636
Received the scroll for Spell: Calefaction
Right clicked the Spell: Calefaction
It says RNG (255) and DRU (255)

Tried to scribe the spell using the scroll and it says "Your class can never use this item"

Tried to scribe the spell using #scribespell 13847 and received an error "Unable to scribe spell Calefaction (13847) to your spellbook.

I checked my dbstr_us.txt file and it does have Calefaction in there under the correct ID. My spells_us.txt file also has Calefaction in it under the correct ID. Everything appears to be setup correctly, even though it's not working in game.

If I switch the "scrolleffect" from 13847 to 671, it lets me scribe the spell Calefaction, but it has the same stats as Starfire. So to me, it appears as if 13847 is not being pulled from my dbstr_us.txt file properly, even though it's there.

I cannot for the life of me figure out what I'm doing wrong. I have read every post on these forums related to this topic and nothing has worked for me.

Please do not bash me. I did not write this post without spending DAYS researching and trying things myself. This post was made because I have exhausted all possible methods to fix it based on the knowledge from these forums.

Thank you in advance for your help and support. Once I get this resolved, I'm going to post a guide on exactly how to do this so nobody has to go through what I just went through again.