phpBB.de

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++;