I have to place this Missions Code in Header if($ir['mission'] != 0)
{
$mq=$db>query("SELECT * FROM missions WHERE id=".$ir['mission']."",$c);
if(mysql_num_rows($mq)== 0)
{
$db>query("UPDATE users SET mission=0 WHERE userid=".$userid."",$c);
}
$rm=mysql_fetch_row($mq);
if($rm['location_on']== 1)
{
if($rm['location_value'] != $ir['location'])
{ $db>_query("UPDATE users SET mission=0 WHERE userid=".$userid."",$c);
event_add($ir['userid'],"Your mission has been ended because you have moved city.",$c);
}
}
if($rm['item_on']== 1 && $rm['attack_on']== 0)
{
$invq=$db>query("SELECT * FROM inventory WHERE inv_userid=".$userid." AND inv_itemid=".$rm['item_value']."",$c);
if(mysql_num_rows($invq))
{
$exp=rand($ir['level'],$ir['level']*5);
$db>query("UPDATE users SET mission=0, money=money+".$rm['money'].", crystals=crystals+".$rm['crystals'].", exp=exp+".$exp.", mission_counter=mission_counter+'1' WHERE userid=".$userid."",$c);
$mission=($ir['mission']);
$db>query("INSERT INTO missdone VALUES ($userid,$mission);",$c);
$db>query("DELETE FROM inventory WHERE inv_userid=$userid AND inv_itemid=".$rm['item_value']."",$c);
event_add($ir['userid'],"You have completed the mission and you was credited your reward.",$c);
}
}
if($rm['item_on']== 0 && $rm['attack_on']== 0)
{
$db>query("UPDATE users SET mission=0 WHERE userid=".$userid."",$c);
$owner=1;
event_add($owner,"The mission $rm[name] mission ($rm[id]) is not set to a mission, Please do so.",$c);
}
if($rm['item_on']== 0 && $rm['attack_on']== 1)
{
$usa=$_SESSION['mission_attack'];
$aa=$db>query("SELECT * FROM missions WHERE id=".$ir['mission']." AND attack_value=".$_SESSION['mission_attack']."",$c);
if(mysql_num_rows($aa))
{
$exp=rand($ir['level'],$ir['level']*10);
$db>query("UPDATE users SET mission=0, money=money+".$rm['money'].", crystals=crystals+".$rm['crystals'].", exp=exp+".$exp.", mission_counter=mission_counter+'1' WHERE userid=".$userid."",$c);
$mission=($ir['mission']);
$db>query("INSERT INTO missdone VALUES ($userid,$mission);",$c);
event_add($ir['userid'],"You have completed the mission and you was credited your reward.",$c);
}
} the instructions say Find: UPDATE users SET laston=unix_timestamp(), add after... I do and end up with unexpected end, parse this parse that... I messed with adding and taking away }'s and still I cant guess or fake my way through this. Dammit I even have this in the wrong category. My apologies.