fetch_all("SELECT u.userid, u.firstname, u.lastname, (SELECT count( userid ) AS total_downline FROM user WHERE parentid = u.userid) total_downline FROM user u WHERE parentid = '".$db->clean($id)."'");
if(sizeof($next_downline_db) > 0){
foreach($next_downline_db as $row){
$next_downline .= '
'.($row['total_downline'] > 0?' ':'').'
'.$row['firstname'].' '.$row['lastname'].'
';
}
}
if(!empty($next_downline)){
$next_downline = '';
}
}
echo json_encode(array("downline" => $next_downline));
exit;
}
$pagelink = '';
$listr = '';
$listaction = '';
$show_table_list = false;
$first_level_downline = '';
$first_level_downline_db = $db->fetch_all("SELECT u.userid, u.firstname, u.lastname, (SELECT count( userid ) AS total_downline FROM user WHERE parentid = u.userid) total_downline FROM user u WHERE parentid = '".$db->clean($userid)."'");
if(sizeof($first_level_downline_db) > 0){
foreach($first_level_downline_db as $row){
$first_level_downline .= '
'.($row['total_downline'] > 0?' ':'').'
'.$row['firstname'].' '.$row['lastname'].'
';
}
}
if(!empty($first_level_downline)){
$first_level_downline = ''.$first_level_downline.'