ID;

$sql = “SELECT admin FROM wp_users WHERE ID = $Member_ID”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 9.”);
$row = mysql_fetch_array($result);
extract($row);

$S_ID = 14;

if ($admin == 1)
{

$sql = “SELECT Series_Name, Series_Year FROM series WHERE Series_ID = $S_ID”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 79.”);
$row = mysql_fetch_array($result);
extract($row);

if(!empty($_POST))

{
$Case = $_POST[“Case”];
$Declined = $_POST[“Declined”];
$Approved = $_POST[“Approved”];
$Duplicate = $_POST[“Duplicate”];
}

if(empty($_POST))

{
$Case= 0;
$Declined = 0;
$Approved= 0;
}

if($Declined == 1)
{

$Count = $_POST[“Count”];

for ($x = 1; $x <= $Count; $x++) { $Sel_DID = $_POST["Driver_$x"]; if($Sel_DID > 0)
{

$sql = “SELECT Name FROM drivers WHERE Driver_ID = $Sel_DID”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 54.”);
$row = mysql_fetch_array($result);
extract($row);

?>

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

$emess= “$Name, your application for $Series_Name has been approved! You have been assigned number $Number. Please visit http://paypal.me/UpstateRacingLeague/5 to pay your entry fee. We look forward to racing with you!”;
$ehead=”From: URL Administration\r\n”;
$subj = “URL Application Approved”;
$mailsend=mail(“$Email”,”$subj”,”$emess”,”$ehead”);

?>

Active Series –


0)
{
?>

“;
echo “

\n”;
echo “

\n”;
?>

0)
{

}
}

$sql = “SELECT * FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Driver_ID = $Sel_DID AND Series_ID = $S_ID”;
$result = mysql_query($sql)
or die(“A MySQL error has occurred.
Your Query: ” . $your_query . “
AError: (” . mysql_errno() . “) ” . mysql_error());
$row = mysql_fetch_array($result);
extract($row);

?>

Approve Decline Driver Email Team Sponsor Numbers Nickname DOB Hometown

“;
echo “

\n”;
echo “

\n”;
?>

\n”;
echo “

\n”;

break;

}

}

?>

Driver

00\n”;
}

### Determine if 01 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9901′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 02 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9902′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 03 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9903′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 04 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9904′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 05 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9905′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 06 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9906′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 07 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9907′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 08 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9908′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 09 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9909′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);

if ($num == 0)
{
echo “\n”;
}

### Determine if 0-999 are taken
for ($x = 0; $x <= 999; $x++) { $sql = "SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE dd.App_Approved = 1 AND dd.Series_ID = $S_ID AND Number=$x"; $result = mysql_query($sql) or die("Couldn't execute query 139."); $num = mysql_num_rows($result); if ($num == 0) { ?>
Nickname

“;
echo “

Return to League Management