$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'])))),
	));
}