+ // Free result
+ SQL_FREERESULT($result_cnt);
+
+ // Prepare data for the template
+ $content = array(
+ 'sw' => $SW,
+ 'u_link' => ADMIN_USER_PROFILE_LINK($data['userid']),
+ 'gender' => TRANSLATE_GENDER($data['gender']),
+ 'refs_link' => "0",
+ 'surname' => $data['surname'],
+ 'family' => $data['family'],
+ 'email' => "[<a href=\"".CREATE_EMAIL_LINK($data['email'], "user_data")."\">".$data['email']."</a>]",
+ 'status' => TRANSLATE_STATUS($data['status']),
+ 'registered' => MAKE_DATETIME($data['joined'], "3"),
+ );
+
+ // Check if referal count is larger 0 and update link
+ if ($refs_cnt > 0) $content['refs_link'] = ADMIN_USER_PROFILE_LINK($data['userid'], $refs_cnt, "list_refs");
+
+ // Load template for level one
+ $OUT_REFS .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);
+ } else {
+ // No refs found
+ $OUT_REFS = LOAD_TEMPLATE("admin_list_refs_nodata", true, $content['refid']);
+ }
+
+ // Free result
+ SQL_FREERESULT($result_user);
+
+ // Add content
+ $levels['rows'] = $OUT_REFS;
+
+ // Switch colors
+ $SW = 3 - $SW;
+ } // END - while
+ } else {
+ // Output info message
+ $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($uid), "0", "0");
+
+ // No refs found
+ $levels['rows'] = LOAD_TEMPLATE("admin_list_refs_norefs", true, array('uid' => $uid));
+ }
+
+ // Free result
+ SQL_FREERESULT($result_refs);
+
+ // Load level template
+ $OUT .= LOAD_TEMPLATE("admin_list_refs_level", true, $levels);
+ } else {
+ // Check for referals
+ $result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
+ array(bigintval($levels['userid'])), __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($levels['userid']),
+ 'gender' => TRANSLATE_GENDER($levels['gender']),
+ 'refs_link' => "0",
+ 'surname' => $levels['surname'],
+ 'family' => $levels['family'],
+ 'email' => "[<a href=\"".CREATE_EMAIL_LINK($levels['email'], "user_data")."\">".$levels['email']."</a>]",
+ 'status' => TRANSLATE_STATUS($levels['status']),
+ 'registered' => MAKE_DATETIME($levels['joined'], "3"),
+ );
+
+ // Check if referal count is larger 0 and update link
+ if ($refs_cnt > 0) $content['refs_link'] = ADMIN_USER_PROFILE_LINK($levels['userid'], $refs_cnt, "list_refs");
+
+ // Load template for level one
+ $OUT .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);
+
+ // Switch colors
+ $SW = 3 - $SW;
+ }
+ } // END - while