Adding spells?

[Movement]

On my server, that I am administering - a spell is not in the database "DRU- Nature's Renewal". I attempted to add this spell onto a column which did not exist in the spellsnew table. I copied an existing spell column (greater healing) or something and just edited the integers for the values, name, dmg healed, level...etc. I have checked my work 8 or so times. I have compared this "new" spell with the one I copied it with and have done many "hotfixes" in the game but the spell will not show up in the game. Which leaves me the only option of going into the character_spells table and actually editing "memmed" spells that the character (in this scenario my wifes character) has memmed. What I want to know is, what did I do wrong - if possible, and what do I need to do, to fix this. Moreover, why was "Nature's Renewal" which was introduced in Kunark, as well as another druid spell "Forest's Renewal" (or something like that) also left out? These seem to be old spells, why did they not make it into the build, and how am I supposed to add them into the spellsnew table?

Although the workaround "works" for now, I dont like having to cheat the database by manually adding spelleffects into a characters spellbook =/

Any help on this is appreciated in advance!

EDIT: The problem I am having isnt necessarily with the spell ITSELF, its getting it to appear in game as scroll form so people can add it into their spellbooks. When you search for "Spell: Nature's Renewal" it still shows 0 results, no matter how many hotfixes I do or how many times I reboot the server.

[Splose]

Is the spell level 255 for the class you're trying it on / have you updated your spell file after you edited this spell?

[Movement]

Originally Posted by Splose

Is the spell level 255 for the class you're trying it on / have you updated your spell file after you edited this spell?

Crap. I should have specified in my OP that its the spell SCROLL that isnt showing up. Not the actual spell itself. I can put the "spell" into peoples spellbook via the DB, but what I cant create in game even if I do a "#fi" (find item "itemname") it still shows 0 results.

The spell works fine when its in a spellbook, that I have to put into characters spellbooks manually, what I am trying to do is get it to appear in scroll form so people can scribe it themselves.

Sorry about the confusion and I will edit my OP for more clarification.

[Movement]

Update: Welp! It's working now. Not sure what I did (which sucks!) but I can summon a spell scroll of Spell: Nature's Renewal. Guess I wont look a gift horse in the mouth lol. Thanks for your response Splose.