I have two questions

[roguesownu]

First question is:

I have an item that worked back with Ascent that when you died you would right click it then left click your body and you would resurrect yourself. I executed this query into my new OA server's DB and it no longer works. When you perform the action it says "You are dead" You can however use it to resurrect another player on your faction. How do you think I would get this to work like it did before? I've tried just about everything I could think of, from changing the resurrection spell to the type of item it is.

Second question, I have Global melee, caster, and weapons trainers that when I execute their SQL's give me this error

Error occured at:2008-06-04 19:36:03
Line no.:12
Error Code: 1364 - Field 'learn_spell' doesn't have a default value

Looking through the SQL code for the trainers I found that

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)

There isn't a "learn_spell" in there. What do I add for learn spell to make this work?

(I noticed that in the DB most if not all of the "cast_spell" are '0' while it is the "learn_spell" that has the numbers in them, do this have anything to do with it?)

Thanks in advanced!

[Toxik the Spammer]

Question 1: I'm not really sure, be RE-EXECUTING the file and refreshing your tables may do something

Question 2: Add it after `entry` and/or `cast_spell` . Make the value 0, 1, 2, or 3.