hey guys i have this car system and it works fine the only problem is that when you are sent a challenge by someone when i click on accept challenge it says Invalid Usage and when i click on the decline challenge button it says Invalid Challenge. can someone help me fix this and correct it and put the right links in.
here is viewchallenge.php
<?php
include "globals.php";
$id=abs((int) $_GET['id']);
$q=$db->query("SELECT ch.*, cp.*, ct.*, u1.username as challenger, u2.username as challenged FROM challenges ch LEFT JOIN cars_playercars cp ON ch.chCHRCAR=cp.cpcID LEFT JOIN cars_types ct ON ct.carID=cp.cpcCAR LEFT JOIN users u1 ON ch.chCHR=u1.userid LEFT JOIN users u2 ON ch.chCHD=u2.userid WHERE ch.chID={$id} AND (ch.chCHR=$userid OR ch.chCHD=$userid)", $c) or die(mysql_error());
if($db->num_rows($q) == 0) { die("Invalid Challenge"); }
$r=$db->fetch_row($q);
print "<h2>Challenge From {$r['challenger']} to {$r['challenged']}</h2><hr />
Type: <h3><font color=red>{$r['chTYPE']}</font></h3><br />";
if($r['chTYPE'] == "Betted") { $bet='$'.number_format($r['chBET']); print "Bet: $bet<br />"; }
print "Challengers Car: {$r['carNAME']}<br />
Status: {$r['chSTATUS']}<br />";
if(($userid == $r['chCHD'] or $userid == 1) and $r['chSTATUS'] == "open")
{
$q=$db->query("SELECT cp.*, ct.* FROM cars_playercars cp LEFT JOIN cars_types ct ON cp.cpcCAR=ct.carID WHERE cp.cpcPLAYER=$userid", $c);
$cars=array();
while($r=$db->fetch_row($q))
{
$cars[$r['cpcID']]="{$r['carNAME']} - {$r['cpcACCLV']}/{$r['cpcHANLV']}/{$r['cpcSPDLV']}/{$r['cpcSHDLV']}";
}
print "<hr />
<h3>Manage This Challenge</h3>
<b>Accept It:</b><br />
<form action='acceptchallenge.php' method='post'>
Car To Use: <select name=car type=dropdown>";
foreach($cars as $k => $v)
{
print "<option value='$k'>$v</option>";
}
print "</select><br />
<input type='hidden' name='id' value='$id'>
<input type='submit' value='Accept Challenge' /></form><br />
<b>Decline Challenge:</b><br />
> <a href='declinechallenge.php?id={$id}'>Click Here</a>";
}
$h->endpage();
?>
here is acceptchallenge.php
<?php
include "globals.php";
if(!$id || !$car) { die("Invalid Usage"); }
$q=$db->query("SELECT ch.*, cp.*, ct.*, u1.username as challenger, u2.username as challenged FROM challenges ch LEFT JOIN cars_playercars cp ON ch.chCHRCAR=cp.cpcID LEFT JOIN cars_types ct ON ct.carID=cp.cpcCAR LEFT JOIN users u1 ON ch.chCHR=u1.userid LEFT JOIN users u2 ON ch.chCHD=u2.userid WHERE ch.chID={$id} AND (ch.chCHR=$userid OR ch.chCHD=$userid)", $c) or die(mysql_error());
if($db->num_rows($q) == 0) { die("Invalid Challenge"); }
$r=$db->fetch_row($q);
if($r['chSTATUS']=="open") {
$bet=$r['chBET'];
if($bet > $ir['money']) { die("The bet is too large."); }
$q=$db->query("SELECT cp.*,ct.* FROM cars_playercars cp LEFT JOIN cars_types ct ON ct.carID=cp.cpcCAR WHERE cp.cpcID={$car} AND cp.cpcPLAYER=$userid", $c);
if($db->num_rows($q) == 0) { die("Invalid Car"); }
$m=$db->fetch_row($q);
if($m['cpcID'] == $r['cpcID']) { die("???"); }
//kk, time to race =D
print "OK, you will receive the results of this race in an event.";
$db->query("UPDATE users SET money=money-$bet WHERE userid={$userid}", $c);
$q=$db->query("SELECT * FROM cars_tracks ORDER BY rand() LIMIT 1", $c);
$t=$db->fetch_row($q);
$stats_y=0;
$stats_y+=$m['cpcACCLV']*$m['carACC']*$t['ctrkACC'];
$stats_y+=$m['cpcHANLV']*$m['carHAN']*$t['ctrkHAN'];
$stats_y+=$m['cpcSPDLV']*$m['carSPD']*$t['ctrkSPD'];
$stats_y+=$m['cpcSHDLV']*$m['carSHD']*$t['ctrkSHD'];
$stats_o=0;
$stats_o+=$r['cpcACCLV']*$r['carACC']*$t['ctrkACC'];
$stats_o+=$r['cpcHANLV']*$r['carHAN']*$t['ctrkHAN'];
$stats_o+=$r['cpcSPDLV']*$r['carSPD']*$t['ctrkSPD'];
$stats_o+=$r['cpcSHDLV']*$r['carSHD']*$t['ctrkSHD'];
$stats_y*=rand(800,1200);
$stats_o*=rand(800,1200);
$notes="No-one won anything";
$db->query("UPDATE users SET cars_challs_accpt=cars_challs_accpt+1 WHERE userid=$userid", $c);
if($stats_y > $stats_o)
{
$winner=$ir['username'];
$winnings=$bet*2;
$db->query("UPDATE users SET money=money+$winnings, cars_races_income=cars_races_income+$bet,cars_races_won=cars_races_won+1 WHERE userid={$r['chCHD']}", $c);
$db->query("UPDATE users SET cars_races_income=cars_races_income-$bet,cars_races_lost=cars_races_lost+1 WHERE userid={$r['chCHR']}", $c);
if($bet > 0)
{
$notes="{$r['challenged']} won \$$winnings";
}
if($r['chTYPE'] == "High-Stakes")
{
$db->query("UPDATE cars_playercars SET cpcPLAYER=$userid WHERE cpcID={$r['cpcID']}", $c);
$notes="{$r['challenged']} won {$r['challenger']}\'s {$r['carNAME']}";
$db->query("UPDATE users SET cars_lost=cars_lost+1 WHERE userid={$r['chCHR']}", $c);
$db->query("UPDATE users SET cars_won=cars_won+1,cars_owned=cars_owned+1 WHERE userid={$r['chCHD']}", $c);
}
else if($r['chTYPE'] == "Betted")
{
$db->query("UPDATE users SET cars_races_betted=cars_races_betted+1 WHERE userid IN ({$r['chCHR']}, {$r['chCHD']})", $c);
}
else
{
$db->query("UPDATE users SET cars_races_friendly=cars_races_friendly+1 WHERE userid IN ({$r['chCHR']}, {$r['chCHD']})", $c);
}
}
else
{
$winner=$r['challenger'];
$winnings=$bet*2;
if($bet > 0)
{
$notes="{$r['challenger']} won \$$winnings";
}
$db->query("UPDATE users SET money=money+$winnings, cars_races_income=cars_races_income+$bet,cars_races_won=cars_races_won+1 WHERE userid={$r['chCHR']}", $c);
$db->query("UPDATE users SET cars_races_income=cars_races_income-$bet,cars_races_lost=cars_races_lost+1 WHERE userid={$r['chCHD']}", $c);
if($r['chTYPE'] == "High-Stakes")
{
$db->query("UPDATE cars_playercars SET cpcPLAYER={$r['chCHR']} WHERE cpcID={$m['cpcID']}", $c);
$notes="{$r['challenger']} won {$r['challenged']}\'s {$m['carNAME']}";
$db->query("UPDATE users SET cars_lost=cars_lost+1 WHERE userid={$r['chCHD']}", $c);
$db->query("UPDATE users SET cars_won=cars_won+1,cars_owned=cars_owned+1 WHERE userid={$r['chCHR']}", $c);
}
else if($r['chTYPE'] == "Betted")
{
$db->query("UPDATE users SET cars_races_betted=cars_races_betted+1 WHERE userid IN ({$r['chCHR']}, {$r['chCHD']})", $c);
}
else
{
$db->query("UPDATE users SET cars_races_friendly=cars_races_friendly+1 WHERE userid IN ({$r['chCHR']}, {$r['chCHD']})", $c);
}
}
$challengercar=$r['carNAME'];
$challengedcar=$m['carNAME'];
$db->query("INSERT INTO race_results VALUES('', '{$r['chTYPE']}', '{$r['chBET']}', '{$r['challenger']}', '{$r['challenged']}', '$challengercar', '$challengedcar','$winner', '$notes')", $c);
$i=mysql_insert_id($c);
event_add($r['chCHR'], "Your race with {$r['challenged']} is finished. Click <a href='viewrace.php?race={$i}'><font color='green'>here</font></a> to view the results.</a>", $c);
event_add($r['chCHD'], "Your race with {$r['challenger']} is finished. Click <a href='viewrace.php?race={$i}'><font color='green'>here</font></a> to view the results.</a>", $c);
$db->query("UPDATE challenges SET chSTATUS='accepted' WHERE chID={$id}", $c);
}
$h->endpage();
?>
and here is declinechallenge.php
<?php
include "globals.php";
$id=abs((int) $_GET['id']);
if(!$id) { die("Invalid Usage"); }
$q=$db->query("SELECT ch.*, cp.*, ct.*, u1.username as challenger, u2.username as challenged FROM challenges ch LEFT JOIN cars_playercars cp ON ch.chCHRCAR=cp.cpcID LEFT JOIN cars_types ct ON ct.carID=cp.cpcCAR LEFT JOIN users u1 ON ch.chCHR=u1.userid LEFT JOIN users u2 ON ch.chCHD=u2.userid WHERE ch.chID={$id} AND ch.chCHR=$userid AND ch.chSTATUS='open'", $c) or die(mysql_error());
if($db->num_rows($q) == 0) { die("Invalid Challenge"); }
$r=$db->fetch_row($q);
$db->query("UPDATE users SET money=money+{$r['chBET']} WHERE userid={$r['chCHR']}", $c);
event_add($r['chCHR'],"You cancelled the challenge to {$r['challenged']}", $c);
event_add($r['chCHD'],"{$ir['username']} cancelled their challenge to you.", $c);
$db->query("UPDATE challenges SET chSTATUS='cancelled' WHERE chID={$id}", $c);
print "Challenge cancelled.";
$h->endpage();
?>
