phpBB.de

Code: Alles auswählen

$top_poster = '20'; // Anzahl an Usern in der Toplist(variabel)

$sql = "SELECT username, user_id,  user_posts, 
        FROM " . USERS_TABLE . "
        WHERE user_id <> " . ANONYMOUS . "
        ORDER BY user_posts DESC LIMIT $top_poster";
if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}

while ( $row = $db->sql_fetchrow($result) )
{
                $username = $row['username'];
                $user_id = $row['user_id'];
                $posts = ( $row['user_posts'] ) ? $row['user_posts'] : 0;

                $template->assign_block_vars('topposter', array(
                        'USERNAME' => $username,
                        'POSTS' => $posts,
                        'U_TOPPOSTER' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"))
                );
}

Code: Alles auswählen

<table class="forumline">
<tr>
<th class="thTop">{L_USERNAME}</th><th class="thTop">{L_POSTS}</th>
</tr>
<!-- BEGIN topposter -->
<tr>
<td class="row1"><a href="{topposter.U_TOPPOSTER}" class="gensmall">{topposter.USERNAME}</td>
<td class="row2">{topposter.POSTS}</td>
</tr>
<!-- END topposter -->
</table>