";
echo(" ";
echo "";
echo "";
echo "";
// Create new race schedule
if ($mode==2)
{
$query="SELECT racer_id FROM racers WHERE rankid=$rankid";
$result=mysql_query($query);
$max=mysql_numrows($result);
// populate racer list from the DB
for($x=0; $x<$max; $x++)
{
$racerlist[$x] = mysql_result($result, $x, "racer_id");
}
// Randomize racer list
shuffle($racerlist);
// copy racer list to each lane and shuffle
// Create 1st lane
$lane[0] = $racerlist;
// Do a 1, 2, 6 rotation
for ($x=0; $x<$max; $x++)
{
$rotation1 = $x+1;
$rotation2 = $x+2;
$rotation3 = $x+6;
if ($rotation1 > $max-1) { $rotation1 = $rotation1-$max; }
if ($rotation2 > $max-1) { $rotation2 = $rotation2-$max;}
if ($rotation3 > $max-1) { $rotation3 = $rotation3-$max;}
// lane 2 = lane 1 + rotation1
$lane[1][$x] = $lane[0][$rotation1];
$lane[2][$x] = $lane[0][$rotation2];
$lane[3][$x] = $lane[0][$rotation3];
}
// Output to DB
// Purge old race data for $rankid
$query = "DELETE FROM racedata WHERE rank_id=$rankid";
mysql_query($query);
for ($x=0; $x<$max; $x++)
{
for ($y=0; $y<4; $y++)
{
$racerid = $lane[$y][$x];
$query = "INSERT INTO racedata VALUES ($rankid, $x,$y,$racerid, 0)";
mysql_query($query);
}
}
$query="UPDATE status SET num_heats=$max WHERE rank_id=$rankid";
mysql_query($query);
$mode=1;
}
if ($mode==1)
{
$query="SELECT max(heat_num) AS max_heat from racedata where rank_id=$rankid;";
$result=mysql_query($query);
$row=mysql_fetch_row($result);
$max_heat=$row[0];
// Read data from the racedata table
$query="SELECT * from racedata where rank_id=$rankid";
$result=mysql_query($query);
$records_read = mysql_num_rows($result);
echo $records_read." records returned";
echo "