require("../config_inc.php"); require("../func_inc.php"); require("login_inc.php"); require("level.php"); $query = "SELECT * FROM members WHERE (parent1='$userid') OR (parent2='$userid') OR (parent3='$userid') ORDER BY joindate DESC"; $dbres1 = mysql_query($query) or show_error(mysql_error()); $rb = 0; if (mysql_num_rows($dbres1)) { while ($row = mysql_fetch_array($dbres1)) { if ($row['parent1'] == $userid and $row['pay_parent1'] == 1 ) $rb++; if ($row['parent2'] == $userid and $row['pay_parent2'] == 1 ) $rb++; if ($row['parent3'] == $userid and $row['pay_parent3'] == 1 ) $rb++; } } $ref_total = mysql_num_rows($dbres1); $total_active = $rb; $sponsorship_money = $total_active ; // Jumlah maksimum downline yang ditampilkan dalam 1 halaman // default 10 $max_show = 40 ; if (!IsSet($page)){$page=1;} if (!IsSet($level)){$level="Semua Level";} $start_num = ($page-1)* $max_show ; $end_num = $start_num + $max_show ; switch($level) { case 1 : $query = "SELECT * FROM members WHERE parent1='$userid' ORDER BY joindate DESC"; break; case 2 : $query = "SELECT * FROM members WHERE parent2='$userid' ORDER BY joindate DESC"; break; case 3 : $query = "SELECT * FROM members WHERE parent3='$userid' ORDER BY joindate DESC"; break; } $dbres = mysql_query($query) or show_error(mysql_error()); if (isset($search)){ $dbres = mysql_query("SELECT * FROM members WHERE (parent1 = '$userid' OR parent2 = '$userid' OR parent3 = '$userid') AND (userid LIKE '%$search%' OR name LIKE '%$search%' OR email LIKE '%$search%') ") or show_error(mysql_error()); } $ref_show_total = mysql_num_rows($dbres); //-******************** Perhitungan komisi recruiting *******-// $db1 = mysql_query("SELECT pay_admin FROM members WHERE parent1='$userid'"); $rb =0; while ($row = mysql_fetch_array($db1)) { if ($row['pay_admin'] == 1) $rb++; } $recruiting_money = $rb * $conf['recruiting_bonus']; //-******************** Perhitungan komisi sponsorship *******-// $db2 = mysql_query("SELECT payment,userid,pay_parent1,pay_parent2,pay_parent3 FROM members WHERE parent1='$userid' or parent2='$userid' or parent3='$userid'"); while ($row = mysql_fetch_array($db2)) { $lev = ceklevel($userid,$row['userid']); $levstr = "pay_parent".$lev; $pstr = "parent".$lev."_amount"; $lp = strlen($conf[$pstr]); $pamount = $conf[$pstr]+$row['payment']; if ($row[$levstr]==1) $sponsorship_money = $sponsorship_money+ $pamount; } //**********************DOWNLINE************************// //$sponsorship_money = 0; $n = 1 ; $it=$start_num; $pp = 0; $ref_str =""; //Kalau punya direct downline, mempersiapkan tampilan if ($ref_show_total >0) { while ($row = mysql_fetch_array($dbres)) { if ($row['parent1'] == $userid and $row['pay_parent1'] == 1 ) $pp++; if ($row['parent2'] == $userid and $row['pay_parent2'] == 1 ) $pp++; if ($row['parent3'] == $userid and $row['pay_parent3'] == 1 ) $pp++; if ( $n>$start_num and $n<=$end_num){ $it++; $ref_str .="