phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
###### start last_reg_users_#####
$sql = "SELECT user_id, username, user_regdate
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY user_regdate DESC
LIMIT 10";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user/online forums information', '', __LINE__, __FILE__, $sql);
}
while ($row = $db->sql_fetchrow($result))
{
$user_id=$row['user_id'];
$template->assign_block_vars("last_registrations", array(
'USERNAME' => $row['username'],
'REG_DATE' => create_date($board_config['default_dateformat'], $row['user_regdate'], $board_config['board_timezone']),
'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"))
);
}
##### end last_reg_users_#######Code: Alles auswählen
<tr>
<!-- BEGIN last_registrations -->
<td class="row1"> <span class="genmed"><a href="{last_registrations.U_VIEWPROFILE}" class="genmed">{last_registrations.USERNAME}</a></span> </td>
<td align="center" nowrap="nowrap" class="row1"> <span class="genmed">{last_registrations.REG_DATE}</span> </td>
</tr>
<!-- END last_registrations -->
</table>
