Ich kämpfe seit einiger Zeit mit einem Darstellungsproblem im Formel1 Mod. Es betrifft die Statistik, welche nicht so ganz korrekt nummeriert. Aktuell sieht es so aus:
Code: Alles auswählen
Platz Top Spieler Punkte
1 User1 72
2 User2 71
3 User3 71
4 User4 69
5 User5 69
Code: Alles auswählen
Platz Top Spieler Punkte
1 User1 72
2 User2 71
User3 71
4 User4 69
User5 69
Daher meine Frage an die vielen genialen PHP Profis hier im Forum, wie müsste der folgende Code entsprechend aussehen?
Code: Alles auswählen
//
// Show users toplist
//
else {
$stat_table_title = $lang['formel_user_stats'];
//
// 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";
$secound_rank = $phpbb_root_path . "images/formel/silberpokal.gif";
$third_rank = $phpbb_root_path . "images/formel/bronzepokal.gif";
$rank = 0;
while ($row = $db->sql_fetchrow($result)) {
$rank++;
if ($rank === 1)
{
$rank_img = '<img src="' . $first_rank . '" alt="1. Platz" title="1. Platz" />';
}
elseif ($rank === 2)
{
$rank_img = '<img src="' . $secound_rank . '" alt="Platz 2" title="2. Platz" />';
}
elseif ($rank === 3)
{
$rank_img = '<img src="' . $third_rank . '" alt="Platz 3" title="3. Platz" />';
}
else
{
$rank_img = $rank;
}
$tipp_user_row = get_userdata($row['tipp_user']);
$tipp_username = $tipp_user_row['username'];
$tipp_useravatar = '';
if ( $tipp_user_row['user_avatar_type'] && $tipp_user_row['user_allowavatar'] )
{
switch( $tipp_user_row['user_avatar_type'] )
{
case USER_AVATAR_UPLOAD:
$tipp_useravatar = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $tipp_user_row['user_avatar'] . '" alt="" border="0" />' : '';
break;
case USER_AVATAR_REMOTE:
$tipp_useravatar = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $tipp_user_row['user_avatar'] . '" alt="" border="0" />' : '';
break;
case USER_AVATAR_GALLERY:
$tipp_useravatar = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $tipp_user_row['user_avatar'] . '" alt="" border="0" />' : '';
break;
}
}
$template->assign_block_vars('top_tippers', array(
'RANK' => $rank_img,
'TIPPER_NAME' => $tipp_username,
'TIPPER_AVATAR' => $tipp_useravatar,
'TIPPER_POINTS' => $row['total_points'])
);
}
$db->sql_freeresult($result);
}