$row = mysql_fetch_object($res); return $row; } ############ # find either a given league (by query param league_id) # or find the latest league (by created_At) $league_id = intval($_GET['league_id']); if ($league_id == 0) { $league = get_latest_league(); } else { $league = get_league($league_id); } $all_leagues = mysql_get_list("select * from leagues order by created_at desc"); $races = mysql_get_list("select * from league_races where league_id=" . $league->id . " order by race_time asc"); # get the current charts $billboard = mysql_get_list("\nselect \n\td.user_id, d.username, sum(rs.points) as sum_points, count(rs.id) as num_races\nfrom \n\tcf_users d\n\tjoin league_results rs on d.user_id=rs.driver_id\n\tjoin league_races r on rs.race_id=r.id\nwhere\n\tr.league_id={$league->id}\n\tand rs.finished_status = 'Finished Normally'\ngroup by\n\td.user_id\norder by \n\tsum_points desc"); ?> <html> <head> <title>League Results</title> <link rel="stylesheet" href="css/blueprint/screen.css" type="text/css" media="screen, projection"> <link rel="stylesheet" href="css/blueprint/print.css" type="text/css" media="print"> <!--[if lt IE 8]> <link rel="stylesheet" href="css/blueprint/ie.css" type="text/css" media="screen, projection"> <![endif]--> <style type="text/css" media="screen"> table.results { border-width: 0px; border-style: none; border-color: gray; border-collapse: collapse;
function distribute_points($race_id) { global $points; $query = sprintf("select * from league_results where race_id=%d and finish_status='Finished Normally' order by position asc", $race_id); $results = mysql_get_list($query); $ct = 1; foreach ($results as $result) { $query = sprintf("update league_results set position=%d, points=%d where id=%d", $ct, intval($points[$ct]), $result->id); $res = mysql_query($query); if (!$res) { die("update query {$query} failed: " . mysql_error()); } $ct++; } }
while ($row = mysql_fetch_object($res)) { array_push($ret, $row); } return $ret; } $seasons = mysql_get_list("select * from seasons order by id desc"); $season = $seasons[0]; $events = mysql_get_list("select * from events where season_id=" . $season->id); $stats = array(); foreach ($events as $event) { # get races for the event $races = mysql_get_list("select * from races where event_id=" . $event->id); foreach ($races as $race) { $results = mysql_get_list("select * from results where finish_status='Finished Normally' and race_id=" . $race->id); foreach ($results as $result) { $driver = mysql_get_list("select * from drivers where id=" . $result->driver_id); $driver = $driver[0]; if (!$stats[$driver->name]) { $stats[$driver->name] = array(); } if ($result->laps_completed >= $race->laps) { if ($stats[$driver->name][$event->id]) { if ($stats[$driver->name][$event->id]['race_time'] > $result->race_time) { $stats[$driver->name][$event->id]['result_id'] = $result->id; $stats[$driver->name][$event->id]['race_time'] = $result->race_time; $stats[$driver->name][$event->id]['race_date'] = $race->race_time; } if ($stats[$driver->name][$event->id]['best_lap'] > $result->best_lap) { $stats[$driver->name][$event->id]['best_lap'] = $result->best_lap; $stats[$driver->name][$event->id]['best_date'] = $race->race_time; }