ID;
$sql = “SELECT * FROM colors”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 9.”);
$row = mysql_fetch_array($result);
extract($row);
$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);
$S_ID = 8;
if ($admin == 1)
{
if(empty($Case))
{ $Case = 0; }
if(!empty($_POST))
{ $Case = $_POST[“Case”]; }
switch ($Case) {
case 0:
?>
Your Query: ” . $your_query . “
BError: (” . mysql_errno() . “) ” . mysql_error());
$row = mysql_fetch_array($result);
extract($row);
if ($_FILES[“file”][“error”] > 0)
{
echo “Error: ” . $_FILES[“file”][“error”] . “
“;
}
else
{
echo “Imported: ” . $_FILES[“file”][“name”] . “
“;
}
if (file_exists(“” . $_FILES[“file”][“name”]))
{
echo $_FILES[“file”][“name”] . ” already exists. ” . “
“;
}
else
{
move_uploaded_file($_FILES[“file”][“tmp_name”],
“” . $_FILES[“file”][“name”]);
}
$Results_File = $_FILES[“file”][“name”];
$E_ID = $_POST[“E_ID”];
if (($handle = fopen(“$Results_File”, “r”)) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ” “,”\\”)) !== FALSE) {
$num = count($data);
for ($c=0; $c < $num; $c++) {
$result = $data;
$str = implode(",", $result);
$slice = explode(",", $str);
$Finish = $slice[0];
$iCust_ID = $slice[1];
$iCust_ID2 = $slice[2];
$Start = $slice[3];
$Car_Num = $slice[4];
$col16 = $slice[5];
$Status = $slice[6];
$col18 = $slice[7];
$col19 = $slice[8];
$col20 = $slice[9];
$col21 = $slice[10];
$col22 = $slice[11];
$col23 = $slice[12];
$col24 = $slice[13];
$col25 = $slice[14];
$col26 = $slice[15];
$col27 = $slice[16];
// Preprocess some fields
if (strpos($col19,'L') !== false)
{
$Behind = $col18 . " " . $col19;
$Laps_Led = $col20;
$Qual_Time = $col21;
$Avg_Lap = $col22;
$Fastest_Lap = $col23;
$Fast_Lap_Num = $col24;
$Laps_Comp = $col25;
$Inc = $col26;
}
if (strpos($col19,'L') === false)
{
$Behind = $col18;
$Laps_Led = $col19;
$Qual_Time = $col20;
$Avg_Lap = $col21;
$Fastest_Lap = $col22;
$Fast_Lap_Num = $col23;
$Laps_Comp = $col24;
$Inc = $col25;
}
if ($iCust_ID != $iCust_ID2)
{
echo "Results not imported. Check iRacing Customer ID in results file!";
$query = "TRUNCATE event_results_temp";
mysql_query($query);
break;
}
// Check if Driver exists by iCust_ID
$sql = "SELECT iCust_ID as eCust_ID FROM drivers WHERE iCust_ID = $iCust_ID";
$result = mysql_query($sql) or die("A MySQL error has occurred.
Your Query: ” . $your_query . “
CError: (” . mysql_errno() . “) ” . mysql_error());
$num = mysql_num_rows($result);
if(empty($num))
{
echo “Results not imported. Driver not in database!”;
$query = “TRUNCATE event_results_temp”;
mysql_query($query);
break;
}
// Pull Driver_ID
$sql = “SELECT d.Driver_ID FROM drivers d WHERE d.iCust_ID = $iCust_ID”;
$result = mysql_query($sql) or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
142Error: (” . mysql_errno() . “) ” . mysql_error());
$row = mysql_fetch_array($result);
extract($row);
// Add driver_detail and driver_stats record
$sql = “SELECT Driver_ID FROM driver_detail WHERE Driver_ID = $Driver_ID AND Series_ID = $S_ID”;
$result = mysql_query($sql) or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
148Error: (” . mysql_errno() . “) ” . mysql_error());
$num = mysql_num_rows($result);
// SQL Query to insert data into DataBase
$query = “INSERT INTO event_results_temp(Event_ID,Finish,Driver_ID,iCust_ID,Start,Car_Num,Status,Behind,Laps_Led,Qual_Time,Avg_Lap,Fastest_Lap,Fast_Lap_Num,Laps_Comp,Inc) VALUES(‘”.$E_ID.”‘,'”.$Finish.”‘,’$Driver_ID’,'”.$iCust_ID.”‘,'”.$Start.”‘,'”.$Car_Num.”‘,'”.$Status.”‘,'”.$Behind.”‘,'”.$Laps_Led.”‘,'”.$Qual_Time.”‘,'”.$Avg_Lap.”‘,'”.$Fastest_Lap.”‘,'”.$Fast_Lap_Num.”‘,'”.$Laps_Comp.”‘,'”.$Inc.”‘)”;
mysql_query($query);
}
}
}
//
$sql = “SELECT DISTINCT * FROM event_results_temp”;
$result = mysql_query($sql) or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
DError: (” . mysql_errno() . “) ” . mysql_error());
while ($row = mysql_fetch_array($result))
{
extract($row);
$query = “INSERT INTO event_results(Event_ID,Finish,Driver_ID,iCust_ID,Start,Car_Num,Status,Behind,Laps_Led,Qual_Time,Avg_Lap,Fastest_Lap,Fast_Lap_Num,Laps_Comp,Inc) VALUES(‘$Event_ID’,’$Finish’,’$Driver_ID’,’$iCust_ID’,’$Start’,’$Car_Num’,’$Status’,’$Behind’,’$Laps_Led’,’$Qual_Time’,’$Avg_Lap’,’$Fastest_Lap’,’$Fast_Lap_Num’,’$Laps_Comp’,’$Inc’)”;
mysql_query($query);
}
echo “Race results successfully imported to database!!”;
$query = “TRUNCATE event_results_temp”;
mysql_query($query);
$Race_Pts = 40;
$Race_RPts = 40;
$sql = “SELECT * FROM drivers d INNER JOIN driver_detail dd ON d.Driver_ID = dd.Driver_ID INNER JOIN event_results er ON er.iCust_ID = d.iCust_ID WHERE er.Event_ID = $Event_ID AND dd.Series_ID = $Series_ID ORDER BY er.Finish”;
$result = mysql_query($sql) or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
DError: (” . mysql_errno() . “) ” . mysql_error());
while ($row = mysql_fetch_array($result))
{
extract($row);
if($Finish == 1)
{
$BPts_Win = 1;
$Total_Laps = $Laps_Comp;
$Half_Race= $Total_Laps / 2 ;
}
if($Laps_Led > 0)
{
$BPts_Laps = 1;
$sqlML = “SELECT MAX(Laps_Led) as LL FROM event_results WHERE Event_ID = $Event_ID”;
$resultML = mysql_query($sqlML) or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
DError: (” . mysql_errno() . “) ” . mysql_error());
$rowML = mysql_fetch_array($resultML);
extract($rowML);
if($Laps_Led == $LL)
{
$BPts_MLaps = 1;
}
}
if($Inc == 0 AND $Laps_Comp >= $Half_Race)
{
$BPts_Inc = 1;
}
if($Inc >= 8)
{
$BPts_IncN = -1;
}
if($Inc >= 16)
{
$BPts_IncN = -2;
}
if($Inc >= 24)
{
$BPts_IncN = -3;
}
if($Inc >= 32)
{
$BPts_IncN = -4;
}
if($Inc >= 40)
{
$BPts_IncN = -5;
}
$sql1 = “UPDATE event_results SET Pts=’$Race_Pts’,BPts_Win=’$BPts_Win’,BPts_Laps=’$BPts_Laps’,BPts_MLaps=’$BPts_MLaps’,BPts_Inc=’$BPts_Inc’,BPts_IncN=’$BPts_IncN’ WHERE Event_ID = $Event_ID AND iCust_ID=’$iCust_ID'”;
mysql_query($sql1);
If($Rookie==1)
{
$sql1 = “UPDATE event_results SET RPts=’$Race_RPts’ WHERE Event_ID = $Event_ID AND iCust_ID=’$iCust_ID'”;
mysql_query($sql1);
$Race_RPts–;
}
$Race_Pts–;
if($Race_Pts < 15)
{
$Race_Pts = 15;
}
### If Driver requested Provisional but showed anyway, remove from event_provisionals
$sql11 = "SELECT Driver_ID as PID FROM event_provisionals ep WHERE ep.Event_ID = $Event_ID AND ep.Driver_ID = $Driver_ID";
$result11 = mysql_query($sql11) or die("A MySQL error has occurred.
Your Query: ” . $your_query . “
DError: (” . mysql_errno() . “) ” . mysql_error());
while ($row11 = mysql_fetch_array($result11))
{
extract($row11);
if($PID == $Driver_ID)
{
$sql12 = “DELETE FROM event_provisionals WHERE Driver_ID = $Driver_ID AND Event_ID = $Event_ID”;
mysql_query($sql12);
}
}
}
$sql = “SELECT ep.Driver_ID, dd.Rookie FROM event_provisionals ep INNER JOIN driver_detail dd ON dd.Driver_ID = ep.Driver_ID AND dd.Series_ID = $S_ID WHERE ep.Event_ID = $Event_ID”;
$result = mysql_query($sql) or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
DError: (” . mysql_errno() . “) ” . mysql_error());
while ($row = mysql_fetch_array($result))
{
extract($row);
if($Rookie == 1)
{
$RPts = 33;
}
$sql1 = “INSERT INTO event_results (Driver_ID,Pts,RPts,Event_ID,Finish,Prov) VALUES (‘$Driver_ID’,’15’,’$RPts’,’$Event_ID’,’99’,’1′)”;
mysql_query($sql1);
$sql12 = “UPDATE event_provisionals SET Processed=’1′ WHERE Event_ID = $Event_ID AND Driver_ID=’$Driver_ID'”;
mysql_query($sql12);
$RPts = 0;
// Add driver_detail and driver_stats record
$sql13 = “SELECT Driver_ID FROM driver_detail WHERE Driver_ID = $Driver_ID AND Series_ID = $S_ID”;
$result13 = mysql_query($sql13) or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
CError: (” . mysql_errno() . “) ” . mysql_error());
$num13 = mysql_num_rows($result13);
if(empty($num13))
{
$query = “INSERT INTO driver_detail(Driver_ID,Series_ID,Number) VALUES(‘$Driver_ID’,’$S_ID’,’$Car_Num’)”;
mysql_query($query);
$query = “INSERT INTO driver_stats(Driver_ID,Series_ID) VALUES(‘$Driver_ID’,’$S_ID’)”;
mysql_query($query);
}
}
?>
Fin | Str | Num | Driver | Int | Laps | Led | Inc | Pts | Bns | Pen | Total | Status |