quest::targlobal problem

Charmy · #1 05-17-2004, 11:28 AM

Hi all trying to get this funtion to work, here is the code i am using

Code:

sub EVENT_ITEM
{
checkitem ( )
}

sub CheckItem
{
 if($itemcount{18700} &amp;&amp; $itemcount{18700} == 1) #Finsihed Class Combined Bag
{
quest::targlobal("NecroCMP","2","D5",$mobid,$charid,$zoneln);
quest::emote("Opens the bag and peers inside");
quest::say("Hmm looks like everthing is here, well i suppose your good enough to study the art of necromancy. Just tell me when you are [Ready] and I shall being your lessons");
}
}
...

NOTE: i left alot out of the quest its several hundred lines long so i am only posting the part that doesn't work.

Code:

if($NecroCMP == "2")
{
quest::say("So Be it.");
quest::delglobal("NecroCMP");
#&lt;events happen here>
}
else
{
quest::say("How dare you ask to begin studying with me before you have completed my quest.");
}
}
...

My problem is this, when i hand in the item i get the text like i have finished but then i say "ready" and it goes to the else action, i get an error in zone.exe

Code:

error inserting necroCMP:DBcore::RunQuery: No Result

this i beleive is telling me its having a problem posting the value of "2" into the database, however i don't understand why. if you have any ideas on a fix for this, that would be great thanks in advanced.