öffne die formel.php
SUCHE:
Code: Alles auswählen
//
// Get all wm points and fill Top10 teams
//
$sql = "SELECT sum(wm_points) AS total_points, wm_team FROM " . FORMEL_WM_TABLE . "
GROUP BY wm_team
ORDER BY total_points DESC LIMIT 5";
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query teams', '', __LINE__, __FILE__, $sql);
}
$rank = 0;
while ($row = $db->sql_fetchrow($result))
{
$rank++;
Code: Alles auswählen
//
// Get all wm points and fill Top10 teams
//
$sql = "SELECT sum(wm_points) AS total_points, wm_team FROM " . FORMEL_WM_TABLE . "
GROUP BY wm_team
ORDER BY total_points DESC LIMIT 5";
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query teams', '', __LINE__, __FILE__, $sql);
}
$rank = 0;
while ($row = $db->sql_fetchrow($result))
{
//FIA Urteil McLaren
if($row['wm_team'] == 1) // Die Team ID von McLaren Mercedes
{
continue; // Es wird keine Berechnung für dieses Team durchgefuehrt.
}
// ENDE FIA Urteil McLaren
$rank++;