Where and how do I put exp gain here for winning a fight

[thebobby]

$atkpage=1;

include "globals.php";

$_GET['ID']=abs((int) $_GET['ID']);

$_SESSION['attacking']=0;

$ir['attacking']=0;

$db->query("UPDATE users SET attacking=0 WHERE userid=$userid");

$od=$db->query("SELECT * FROM users WHERE userid={$_GET['ID']}");

if($_SESSION['attackwon'] != $_GET['ID'])

{

die ("Cheaters don't get anywhere.");

}

if($db->num_rows($od))

{

$r=$db->fetch_row($od);

$gq=$db->query("SELECT * FROM gangs WHERE gangID={$r['gang']}");

$ga=$db->fetch_row($gq);

if($r['hp'] == 1)

{

print "What a cheater u are.";

}

else

{

print "

<div id='mainOutput' style='text-align: center; color: white; width: 600px; border: 1px solid #222222; height: 100px;

margin: 0 auto 10px; clear: both; position: relative; left: -20px; padding: 8px'>

You beat {$r['username']}!!

You beat {$r['username']} severely on the ground. When there is lots of blood showing, you head up to the nearest 10-story building's roof and drop him over the edge. You run home silently and carefully.";

$hosptime=rand(10,20)+floor($ir['level']/2);

$db->query("UPDATE users SET hp=1,hospital=$hosptime,hospreason='Hospitalized by <a href=\'viewuser.php?u={$userid}\'>{$ir['username']}</a>' WHERE userid={$r['userid']}");

event_add($r['userid'],"{$ir['username']} beat you up.",$c);

$atklog=mysql_escape_string($_SESSION['attacklog']);

$db->query("INSERT INTO attacklogs VALUES('',$userid,{$_GET['ID']},'won',unix_timestamp(),-1,'$atklog');");

$_SESSION['attackwon']=0;

$warq=$db->query("SELECT * FROM gangwars WHERE (warDECLARER={$ir['gang']} AND warDECLARED={$r['gang']}) OR (warDECLARED={$ir['gang']} AND warDECLARER={$r['gang']})");

if ($db->num_rows($warq) > 0)

{

$war=$db->fetch_row($warq);

$db->query("UPDATE gangs SET gangRESPECT=gangRESPECT-3 WHERE gangID={$r['gang']}");

$ga['gangRESPECT']-=3;

$db->query("UPDATE gangs SET gangRESPECT=gangRESPECT+3 WHERE gangID={$ir['gang']}");

print "

You earnt 3 respect for your gang!";

}

//Gang Kill

if ($ga['gangRESPECT']<=0 && $r['gang'])

{

$db->query("UPDATE users SET gang=0 WHERE gang={$r['gang']}");

$db->query("DELETE FROM gangs WHERE gangRESPECT<='0'");

$db->query("DELETE FROM gangwars WHERE warDECLARER={$ga['gangID']} or warDECLARED={$ga['gangID']}");

}

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']})");

[chicka]

should look something like this

$qe=$r['level']*$r['level']*$r['level'];
$expgain = rand($qe/4.5, $qe/2.5);
$expperc = ($expperc > 25) ? 25 : $expperc;
$expperc=(int) ($expgain/$ir['exp_needed']*100); 

then should look something like

$db->query("UPDATE users SET exp=exp+$expgain WHERE userid=$userid");  

[thebobby]

Thanks fixed