Code: Alles auswählen
// neuste User
$sql = "SELECT user_id, username, user_avatar, user_regdate, user_avatar_type, user_allow_viewonline, user_from, user_rank, user_session_time
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY user_id DESC
LIMIT 0, 10";
if(!$result = $db->sql_query($sql))
{
message_die(CRITICAL_ERROR, "Konnte neuste User nicht abrufen!", "", __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result) )
{
$neueruser = $row['username'];
$user_alter = $row['user_alter'];
if ($row[user_gender] == '1')
{
$user_gender = 'männlich';
}
else
{
$user_gender = 'weiblich';
}
$template->assign_block_vars('neueuser', array(
'USER_ALTER' => $user_gender,
'NEUERUSER' => $row['username'],
'U_ALTER' => $user_alter));
}
Code: Alles auswählen
<table cellpadding="3" cellspacing="1" border="0" width="100%" class="forumline">
<tr>
<th>neuste Mitglieder</th>
</tr>
<tr><td align="center"><b>{neueuser.NEUERUSER}</b></td></tr>
</table>
wo liegt der Fehler?