phpBB.nl

Code: Selecteer alles

$sql = "SELECT * FROM phpbb_user_group WHERE group_id='8' ORDER BY group_leader DESC";
$result = $db->sql_query($sql);

while($row = $db->sql_fetchrow($result))
{
$sql2 = "SELECT * FROM phpbb_users WHERE user_id='".$row['user_id']."'";
$result2 = $db->sql_query($sql2);
$row2 = $db->sql_fetchrow($result2);

$sql3 = "SELECT * FROM phpbb_ranks WHERE rank_id='".$row2['user_rank']."'";
$result3 = $db->sql_query($sql3);
$row3 = $db->sql_fetchrow($result3);

    $template->assign_block_vars('team', array(
        'USERNAME'    => $row2['username'],
    	'USERID'    => $row2['user_id'],
    	'USERRANK'    => $row3['rank_title'],
    ));
}
$db->sql_freeresult($result);