phpBB.de

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>

Code: Alles auswählen

<!-- BEGIN neueuser -->
<tr><td align="center"><b>{neueuser.NEUERUSER}</b></td></tr>
<!-- END neueuser -->