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 = 17;
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());
$num1 = mysql_num_rows($result);
if(empty($num1))
{
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
$Diff = $Start – $Finish;
$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,Diff) 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.”‘,’.$Diff.’)”;
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 = 150;
$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);
$sql1 = “UPDATE event_results SET Pts=’$Race_Pts’,BPts_Win=’$BPts_Win’,BPts_Inc=’$BPts_Inc’,BPts_IncN=’$BPts_IncN’,Diff=’$Diff’ WHERE Event_ID = $Event_ID AND iCust_ID=’$iCust_ID'”;
mysql_query($sql1);
if($Finish == 2)
{
$Race_Pts = $Race_Pts – 4;
}
if($Finish > 2)
{
$Race_Pts = $Race_Pts – 2;
if($Race_Pts < 100) { $Race_Pts = 100; } } $sql1 = "UPDATE event_results SET Pts='$Race_Pts',BPts_Win='$BPts_Win',BPts_Inc='$BPts_Inc',BPts_IncN='$BPts_IncN',Diff='$Diff',BPts_HC='$BPts_HC',BPts_Fast='$BPts_Fast' WHERE Event_ID = $Event_ID AND iCust_ID='$iCust_ID'"; mysql_query($sql1); } ?>
| Fin | Str | Num | Driver | Int | Laps | Led | Inc | Pts | Total | Status |