");
if ($result)
{
$rows = SQL_NUMROWS($result);
if ($rows > 0)
{
// Load all referrals
$SW = "2"; $OUT = "";
while ($row = SQL_FETCHROW($result))
{
// Check for referrals
$result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM "._MYSQL_PREFIX."_user_data WHERE refid=%s",
array(bigintval($row[0])), __FILE__, __LINE__);
$refs_cnt = SQL_RESULT($result_refs, 0, 0);
SQL_FREERESULT($result_refs);
// Prepare data for the template
$content = array(
'sw' => $SW,
'u_link' => ADMIN_USER_PROFILE_LINK($row[0]),
'gender' => TRANSLATE_GENDER($row[1]),
'refs_link' => "0",
'surname' => $row[2],
'family' => $row[3],
'email' => "".$row[4]."",
'status' => TRANSLATE_STATUS($row[5]),
'registered' => MAKE_DATETIME($row[6], "3"),
);
// Check if referral count is larger 0 and update link
if ($refs_cnt > 0) $content['refs_link'] = ADMIN_USER_PROFILE_LINK($row[0], $refs_cnt, "list_refs");
// Load row template and switch color
$OUT .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);
$SW = 3 - $SW;
}
// Free memory
SQL_FREERESULT($result);
define('__REF_ROWS', $OUT);
// Load main template
LOAD_TEMPLATE("admin_list_refs");
}
}
else
{
// No referrals made so far
LOAD_TEMPLATE("admin_settings_saved", false, USER_REF_404);
}
}
else
{
// User not found
LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2);
}
}
else
{
// Output selection form with all confirmed user accounts listed
ADD_MEMBER_SELECTION_BOX();
}
//
?>