ID;

$S_ID = 16;

$sql = “SELECT admin FROM wp_users WHERE ID = $Member_ID”;
$result = mysql_query($sql) or die(“A MySQL error has occurred.
Your Query: ” . $sql . “
10 – Error: (” . mysql_errno() . “) ” . mysql_error());
$row = mysql_fetch_array($result);
extract($row);

if ($admin == 1)
{

if(empty($Case))

{ $Case = 0; }

if(!empty($_POST))

{ $Case = $_POST[“Case”]; }

switch ($Case) {

case 0:
?>

Your Query: ” . $sql . “
34 – AError: (” . mysql_errno() . “) ” . mysql_error());
$row = mysql_fetch_array($result);
extract($row);

$sql1 = “SELECT Event_ID, Event_Name, Event_Date FROM events WHERE Results_Uploaded = 1 AND Results_Processed = 0 AND Series_ID = $S_ID”;
$result1 = mysql_query($sql1) or die(“A MySQL error has occurred.
Your Query: ” . $sql1 . “
39 – Error: (” . mysql_errno() . “) ” . mysql_error());
$row1 = mysql_fetch_array($result1);
extract($row1);

echo “

“;
echo “

“;

echo “

“;
echo “

$Series_Name – $Series_Year
Last Race – $Event_Date – $Event_Name

“;

?>


Fin Str Num Driver Int Laps Led Inc Pts Bns Pen Total Status


Your Query: ” . $your_query . “
AError: (” . mysql_errno() . “) ” . mysql_error());
while ($row = mysql_fetch_array($result))
{
extract($row);

$ds_Starts = $ds_Starts + 1;
$ds_Laps_Led = $ds_Laps_Led + $Laps_Led;
$ds_Race_Pts = $ds_Race_Pts + $Pts;
$ds_Rookie_Pts = $ds_Rookie_Pts + $Rpts;
$ds_BPts_Win = $ds_BPts_Win + $BPts_Win;
$ds_BPts_Laps = $ds_BPts_Laps + $BPts_Laps;
$ds_BPts_MLaps = $ds_BPts_MLaps + $BPts_MLaps;
$ds_BPts_HC = $ds_BPts_HC + $BPts_HC;
$ds_BPts_Fast = $ds_BPts_Fast + $BPts_Fast;
$ds_BPts_Inc = $ds_BPts_Inc + $BPts_Inc;
$ds_BPts_IncN = $ds_BPts_IncN + $BPts_IncN;
$ds_Prov = $ds_Prov + $Prov;
$ds_Inc = $ds_Inc + $Inc;
$ds_Rookie_Pts = $ds_Rookie_Pts + $RPts;
$ds_Total_Pts = $ds_Total_Pts + $Pts + $BPts_Win + $BPts_Laps + $BPts_MLaps + $BPts_Inc + $BPts_IncN + $BPts_HC + $BPts_Fast;

if($Finish == 1)
{
$ds_Wins++;
}

if($Finish <= 5) { $ds_T5++; } if($Finish <= 10) { $ds_T10++; } $sql1="UPDATE driver_stats SET ds_Starts='$ds_Starts',ds_Wins='$ds_Wins',ds_T5='$ds_T5',ds_T10='$ds_T10',ds_Laps_Led='$ds_Laps_Led',ds_Total_Pts='$ds_Total_Pts',ds_Race_Pts='$ds_Race_Pts',ds_Rookie_Pts='$ds_Rookie_Pts',ds_BPts_Win='$ds_BPts_Win',ds_BPts_Laps='$ds_BPts_Laps',ds_BPts_MLaps='$ds_BPts_MLaps',ds_BPts_Inc='$ds_BPts_Inc',ds_BPts_IncN='$ds_BPts_IncN',ds_Prov='$ds_Prov',ds_Inc='$ds_Inc',ds_BPts_HC='$ds_BPts_HC',ds_BPts_Fast='$ds_BPts_Fast' WHERE Driver_ID = '$Driver_ID' and Series_ID = '$Series_ID'"; mysql_query($sql1); } ########################################## $sql = "SELECT * FROM driver_stats ds INNER JOIN drivers d ON d.Driver_ID = ds.Driver_ID INNER JOIN driver_detail dd ON dd.Driver_ID = ds.Driver_ID WHERE ds.Series_ID = $S_ID AND ds.ds_Total_Pts > 0 AND dd.Series_ID = $S_ID ORDER BY ds.ds_Total_Pts DESC, ds.ds_Wins DESC, ds.ds_T5 DESC, ds.ds_T10 DESC, ds.ds_Laps_Led DESC”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 147.”);
while ($row = mysql_fetch_array($result))
{
extract($row);

$Pos++;

if($Prev_Pts==$ds_Total_Pts)
{
$DPos = $Prev_Pos;
}
else
{
$DPos = $Pos;
}

$Prev_Pos = $DPos;
$Prev_Pts = $ds_Total_Pts;

$sql = “UPDATE driver_stats SET ds_Current=’$DPos’,ds_Prev=’$ds_Current’ WHERE Driver_ID = $Driver_ID”;
mysql_query($sql);

}

##########################################

$sql = “UPDATE events SET Results_Processed=’1′ WHERE Event_ID = $Event_ID”;
mysql_query($sql);

?>

0 AND dd.Series_ID = $S_ID ORDER BY ds.ds_Total_Pts DESC, ds.ds_Wins DESC, ds.ds_T5 DESC, ds.ds_T10 DESC, ds.ds_Laps_Led DESC”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 147.”);
while ($row = mysql_fetch_array($result))
{
extract($row);

$BPts = $ds_BPts_Win + $ds_BPts_Laps + $ds_BPts_MLaps + $ds_BPts_Inc;
$PPts = $ds_BPts_IncN + $ds_PPts;
$Pos++;

$Behind = $ds_Total_Pts – $Leader;
$BChase = $ds_Total_Pts – $Chase_Cut;

$Change = $ds_Prev – $ds_Current;

if($Pos==”1″)
{
$Leader = $ds_Total_Pts;
$Behind = “-“;
}

if($Prev_Pts==$ds_Total_Pts)
{
$DPos = “-“;
}
else
{
$DPos = $Pos;
}

$Prev_Pos = $DPos;
$Prev_Pts = $ds_Total_Pts;

if($Number>1000)
{
$Number = ltrim($Number,’99’);
}

?>

Pos Num Driver Starts Wins Top 5 Top 10 Pts Bns Pen Led Inc Bh Ldr Chg
“> Return to League Management

↑