$sql = "SELECT *
FROM " . USER_GROUP_TABLE . " AS user_group_table
LEFT JOIN " . USERS_TABLE . " AS users_table ON users_table.user_id = user_group_table.user_id
LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " AS fields_table ON fields_table.user_id = user_group_table.user_id
WHERE user_group_table.group_id = '{$group_id}'
ORDER BY users_table.user_klubikaart ASC";
$result = $db->sql_query($sql);
while($row = $db->sql_fetchrow($result))
{
$uid = $bitfield = $options = '';
$allow_bbcode = $allow_urls = $allow_smilies = true;
generate_text_for_storage($row['pf_auto'], $uid, $bitfield, $options, $allow_bbcode, $allow_urls, $allow_smilies);
$relv = generate_text_for_display($row['pf_auto'], $uid, $bitfield, $options);
$template->
assign_block_vars('row',
array( 'NR' => $row['user_klubikaart'],
'USERNAME' => $row['username'],
'AUTO' => $relv,
'ASUKOHT' => $row['user_from'],
'U_USERNAME' => append_sid($phpbb_root_path.'memberlist.'.$phpEx, 'mode=viewprofile&u='.$row['user_id']),
'U_EDIT' => append_sid
($phpbb_root_path.
'ct.'.
$phpEx,
'edit='.
base64_encode(serialize(array($row['username'],
$row['user_klubikaart'])))),
));
}