illegalife Posted December 7, 2008 Posted December 7, 2008 Anyone can help me with making an NPC that gives out an item when he's beaten instead of money? Here's my failed attempt: $npcs=array( ); if($r['user_level']==0) { $q=$db->query("SELECT * FROM challengebots WHERE cb_npcid={$r['userid']}"); if ($db->num_rows($q)) { $cb=$db->fetch_row($q); $qk=$db->query("SELECT * FROM challengesbeaten WHERE userid=$userid AND npcid={$r['userid']}"); if(!$db->num_rows($qk)) { $m=$cb['cb_money']; $db->query("UPDATE users SET money=money+$m WHERE userid=$userid"); print " You gained \$$m for beating the challenge bot {$r['username']}"; $db->query("INSERT INTO challengesbeaten VALUES($userid, {$r['userid']})"); } else { if ($r['userid']==80) print"You beat the Evil Santa and steal his Santa's Rifle."; $db->query("INSERT INTO inventory VALUES('',32,$userid,1)"); $db->query("INSERT INTO challengesbeaten VALUES($userid, {$r['userid']})"); } } } else { print "You beat Mr. non-existant!"; } } $h->endpage(); ?> Quote
AlabamaHit Posted December 7, 2008 Posted December 7, 2008 Re: [v2] NPC item reward Try this. $npcs=array( ); if($r['user_level']==0) { $q=$db->query("SELECT * FROM challengebots WHERE cb_npcid={$r['userid']}"); if ($db->num_rows($q)) { $cb=$db->fetch_row($q); $qk=$db->query("SELECT * FROM challengesbeaten WHERE userid=$userid AND npcid={$r['userid']}"); if(!$db->num_rows($qk)) { $m=$cb['cb_money']; $db->query("UPDATE users SET money=money+$m WHERE userid=$userid"); print " You gained \$$m for beating the challenge bot {$r['username']}"; $db->query("INSERT INTO challengesbeaten VALUES($userid, {$r['userid']})"); } else if { if ($r['userid']==80) print"You beat the Evil Santa and steal his Santa's Rifle."; $db->query("INSERT INTO inventory VALUES('',32,$userid,1)"); $db->query("INSERT INTO challengesbeaten VALUES($userid, {$r['userid']})"); } } } else { print "You beat Mr. non-existant!"; } } $h->endpage(); ?> Quote
POG1 Posted December 7, 2008 Posted December 7, 2008 Re: [v2] NPC item reward alabama.. on line 14 or 15 you have an empty else if. Quote
AlabamaHit Posted December 7, 2008 Posted December 7, 2008 Re: [v2] NPC item reward $npcs=array(); if ($r['userid']==80) { print"You beat the Evil Santa and steal his Santa's Rifle."; $db->query("INSERT INTO inventory VALUES('',32,$userid,1)"); $db->query("INSERT INTO challengesbeaten VALUES($userid, {$r['userid']})"); } if($r['user_level']==0) { $q=$db->query("SELECT * FROM challengebots WHERE cb_npcid={$r['userid']}"); if ($db->num_rows($q)) { $cb=$db->fetch_row($q); $qk=$db->query("SELECT * FROM challengesbeaten WHERE userid=$userid AND npcid={$r['userid']}"); if(!$db->num_rows($qk)) { $m=$cb['cb_money']; $db->query("UPDATE users SET money=money+$m WHERE userid=$userid"); print " You gained \$$m for beating the challenge bot {$r['username']}"; $db->query("INSERT INTO challengesbeaten VALUES($userid, {$r['userid']})"); } } else { print "You beat Mr. non-existant!"; } } $h->endpage(); ?> Quote
illegalife Posted December 8, 2008 Author Posted December 8, 2008 Re: [v2] NPC item reward doesn't work ;/ Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.