Die FIA Regeln besagen, das bei Punktegleichstand der Fahrer der bessere ist, der die meisten Siege errungen hat. Dies wurde bisher nicht berücksichtigt. Um dies zu ändern suche in der formel_stats.php:
Code: Alles auswählen
//
// Get all wm points and fill Top10 drivers
//
$sql = "SELECT sum(wm_points) AS total_points, wm_driver, wm_team FROM " . FORMEL_WM_TABLE . "
GROUP BY wm_driver
ORDER BY total_points DESC";
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query tipps', '', __LINE__, __FILE__, $sql);
}
Code: Alles auswählen
//Get all first place winner, count all first places, grep all gold medals... Marker for first place: 25 WM Points
$sql = 'SELECT count(wm_driver) as gold_medals, wm_driver
FROM ' . FORMEL_WM_TABLE . '
WHERE wm_points = 25
GROUP BY wm_driver
ORDER BY gold_medals DESC';
$result = $db->sql_query($sql);
// Now put the gold medals into the $drivers array
while ($row = $db->sql_fetchrow($result))
{
$drivers[$row['wm_driver']]['gold_medals'] = $row['gold_medals'];
}
Code: Alles auswählen
$recalc_drivers[$row['wm_driver']]['total_points'] = $row['total_points'] - $drivers[$row['wm_driver']]['driver_penalty'];
Code: Alles auswählen
$recalc_drivers[$row['wm_driver']]['gold_medals'] = (isset($drivers[$row['wm_driver']]['gold_medals'])) ? $drivers[$row['wm_driver']]['gold_medals'] : 0;
Code: Alles auswählen
//
// Get all data
//
$teams = get_formel_teams();
$drivers = get_formel_drivers();
Code: Alles auswählen
//Get all first place winner, count all first places, grep all gold medals... Marker for first place: 25 WM Points
$sql = 'SELECT count(wm_driver) as gold_medals, wm_driver
FROM ' . FORMEL_WM_TABLE . '
WHERE wm_points = 25
GROUP BY wm_driver
ORDER BY gold_medals DESC';
$result = $db->sql_query($sql);
// Now put the gold medals into the $drivers array
while ($row = $db->sql_fetchrow($result))
{
$drivers[$row['wm_driver']]['gold_medals'] = $row['gold_medals'];
}
Code: Alles auswählen
//
// Get all drivers
//
$drivers = get_formel_drivers();
Code: Alles auswählen
//Get all first place winner, count all first places, grep all gold medals... Marker for first place: 25 WM Points
$sql = 'SELECT count(wm_driver) as gold_medals, wm_driver
FROM ' . FORMEL_WM_TABLE . '
WHERE wm_points = 25
GROUP BY wm_driver
ORDER BY gold_medals DESC';
$result = $db->sql_query($sql);
// Now put the gold medals into the $drivers array
while ($row = $db->sql_fetchrow($result))
{
$drivers[$row['wm_driver']]['gold_medals'] = $row['gold_medals'];
}
Code: Alles auswählen
$recalc_drivers[$row['wm_driver']]['total_points'] = $row['total_points'] - $drivers[$row['wm_driver']]['driver_penalty'];
Code: Alles auswählen
$recalc_drivers[$row['wm_driver']]['gold_medals'] = (isset($drivers[$row['wm_driver']]['gold_medals'])) ? $drivers[$row['wm_driver']]['gold_medals'] : 0;
Code: Alles auswählen
//
// Get all drivers
//
$drivers = get_formel_drivers();
Code: Alles auswählen
//Get all first place winner, count all first places, grep all gold medals... Marker for first place: 25 WM Points
$sql = 'SELECT count(wm_driver) as gold_medals, wm_driver
FROM ' . FORMEL_WM_TABLE . '
WHERE wm_points = 25
GROUP BY wm_driver
ORDER BY gold_medals DESC';
$result = $db->sql_query($sql);
// Now put the gold medals into the $drivers array
while ($row = $db->sql_fetchrow($result))
{
$drivers[$row['wm_driver']]['gold_medals'] = $row['gold_medals'];
}
Danke an Dr.Death.
Bye