[solution][snipplet] Phpbb3 code for latest users (userlist)

By.

min read

My profile

Share this:

[code:1:590dc59277] function latest_signups($limit = 8)
{
global $db;
$sql = ‘SELECT u.user_id AS id, u.username_clean AS username FROM ‘.USERS_TABLE.’ u WHERE u.user_type IN (0, 3) ORDER BY u.user_regdate DESC LIMIT ‘.intval($limit);
$result = $db->sql_query($sql);

$data = array();
while ($row = $db->sql_fetchrow($result))
{
$data[] = $row;
}
$db->sql_freeresult($result);
return $data;
}[/code:1:590dc59277]

Share this:

Leave a Reply

Your email address will not be published. Required fields are marked *