phpBB.de

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'];
}