phpBB.de

Code: Alles auswählen

//
// Get all tipps and fill Top10
//
$sql = "SELECT sum(tipp_points) AS total_points, tipp_user FROM " . FORMEL_TIPPS_TABLE . "
        GROUP BY tipp_user
        ORDER BY total_points DESC";
if (!$result = $db->sql_query($sql))
{
      message_die(GENERAL_ERROR, 'Could not query tipps', '', __LINE__, __FILE__, $sql);
}
$first_rank = $phpbb_root_path . "images/formel/goldpokal.gif";
$rank = 0;
while ($row = $db->sql_fetchrow($result)) {
      $rank++;
      $tipp_user_row = get_userdata($row['tipp_user']);
      $tipp_username = $tipp_user_row['username'];
      $template->assign_block_vars('top_tippers', array(
               'TIPPER_NAME'   => $tipp_username,
//     'RANK'          => $rank,
      'RANK'          => ($rank == 1) ? '<img src="' . $first_rank . '" alt="" />' : $rank,
               'TIPPER_POINTS' => $row['total_points'])
      );
}
$db->sql_freeresult($result);
}

Code: Alles auswählen

$first_rank = $phpbb_root_path . "images/formel/goldpokal.gif";

Code: Alles auswählen

$secound_rank = $phpbb_root_path . images/formel/silberpokal.gif";
$third_rank = $phpbb_root_path . images/formel/bronzepokal.gif";

Code: Alles auswählen

'RANK'          => ($rank == 1) ? '<img src="' . $first_rank . '" alt="" />' : $rank,

Code: Alles auswählen

($rank == 2) ? '<img src="' . $secound_rank . '" alt="" />' 
($rank == 3) ? '<img src="' . $third_rank . '" alt="" />'

Code: Alles auswählen

while ($row = $db->sql_fetchrow($result)) 
{ 
	$rank++;
	if ($rank === 1)
	{
		$rank_img = '<img src="' . $first_rank . '" alt="First" />';
	}
	elseif ($rank === 2)
	{
		$rank_img = '<img src="' . $second_rank . '" alt="Second" />';
	}
	elseif ($rank === 3)
	{
		$rank_im = '<img src="' . $third_rank . '" alt="Third" />';
	}
	else
	{
		$rank_img = $rank;
	}	
	$tipp_user_row = get_userdata($row['tipp_user']); 
	$tipp_username = $tipp_user_row['username']; 
	$template->assign_block_vars('top_tippers', array( 
			'TIPPER_NAME'   => $tipp_username,
			'RANK'			=> $rank_img,
			'TIPPER_POINTS' => $row['total_points']) 
	); 
}