?>
/gallery/avatar/<?php
echo $first['member_avatar'];
?>
') top center no-repeat;background-size:100% auto;">
<div style="position:absolute;left:0;right:0;margin:auto;top:-180px;color:#ffffff;">
<?php
if ($side == "L") {
$calculated_side = "calculated_left";
} elseif ($side == "R") {
$calculated_side = "calculated_right";
}
$calculated_pv_result = mysqli_fetch_array(mysqli_query($connect, "SELECT {$calculated_side} FROM members LEFT JOIN packages ON members.package_id=packages.package_id WHERE member_id={$first_upline}"));
$calculated_pv = $calculated_pv_result[0];
$upline = $first['member_id'];
echo number_format(SumPV($upline) - $calculated_pv) . " PV";
$package_name = mysqli_fetch_assoc(mysqli_query($connect, "SELECT package_name FROM packages WHERE package_id=" . $first['package_id']));
?>
</div>
<a href="<?php
echo $site_url;
?>
/placement/<?php
echo $first['member_username'];
?>
" title="<?php
echo $first['member_name'] . " " . $first['member_surname'] . " (" . $package_name['package_name'] . ")";
?>
">
<div style="position:relative;top:-83px;left:-2px;width:96px;height:96px;">
<span class="label label-pill label-<?php
function bonus_cycle($member_id)
{
$connect = Database();
$upline = mysqli_fetch_assoc(mysqli_query($connect, "SELECT upline FROM members WHERE member_id={$member_id};"));
$upline = $upline['upline'];
$find_cycle_next = $upline;
do {
$find_cycle = mysqli_fetch_array(mysqli_query($connect, "SELECT member_id,upline FROM members WHERE member_id={$find_cycle_next}"));
$member_cycle = $find_cycle['member_id'];
$find_cycle_next = $find_cycle['upline'];
$left_downline = mysqli_fetch_assoc(mysqli_query($connect, "SELECT member_id FROM members WHERE upline={$member_cycle} AND placement='L';"));
$left_downline = $left_downline['member_id'];
$left_calculated = mysqli_fetch_assoc(mysqli_query($connect, "SELECT calculated_left FROM members WHERE member_id={$member_cycle};"));
$left_calculated = $left_calculated['calculated_left'];
$right_downline = mysqli_fetch_assoc(mysqli_query($connect, "SELECT member_id FROM members WHERE upline={$member_cycle} AND placement='R';"));
$right_downline = $right_downline['member_id'];
$right_calculated = mysqli_fetch_assoc(mysqli_query($connect, "SELECT calculated_right FROM members WHERE member_id={$member_cycle};"));
$right_calculated = $right_calculated['calculated_right'];
$left_pv = SumPV($left_downline) - $left_calculated;
$right_pv = SumPV($right_downline) - $right_calculated;
if ($left_pv <= $right_pv) {
$calculate_pv = $left_pv;
} elseif ($right_pv < $left_pv) {
$calculate_pv = $right_pv;
}
if ($calculate_pv > 0) {
$calculated_left = $calculate_pv + $left_calculated;
$calculated_right = $calculate_pv + $right_calculated;
$calculated_pv_query = mysqli_query($connect, "UPDATE members SET calculated_left={$calculated_left},calculated_right={$calculated_right} WHERE member_id={$member_cycle}");
if ($calculated_pv_query) {
$member_cycle = mysqli_fetch_assoc(mysqli_query($connect, "SELECT member_id,jWallet,rMoney,package_id FROM members WHERE member_id={$member_cycle};"));
$jWallet = $member_cycle['jWallet'];
$rMoney = $member_cycle['rMoney'];
$member_cycle_package = $member_cycle['package_id'];
$cycle_today_amount = mysqli_fetch_assoc(mysqli_query($connect, "\n\t\t\t\t\t\tSELECT SUM(income) AS sum_income \n\t\t\t\t\t\tFROM transactions\n\t\t\t\t\t\tWHERE DATE( `transaction_date` ) = DATE( CURDATE( ) ) \n\t\t\t\t\t\tAND bonus_id =6\n\t\t\t\t\t\tAND member_id=" . $member_cycle['member_id'] . ";"));
$cycle_today_amount = $cycle_today_amount['sum_income'];
$bonus_cycle = $calculate_pv * 0.1;
if ($member_cycle_package == 1) {
$cycle_max = 50;
} elseif ($member_cycle_package == 2) {
$cycle_max = 100;
} elseif ($member_cycle_package == 3) {
$cycle_max = 200;
} elseif ($member_cycle_package == 4) {
$cycle_max = 400;
} elseif ($member_cycle_package == 5) {
$cycle_max = 1000;
} elseif ($member_cycle_package == 6) {
$cycle_max = 2000;
} elseif ($member_cycle_package == 7) {
$cycle_max = 3000;
}
if ($cycle_max > $cycle_today_amount) {
$cycle_remaining = $cycle_max - $cycle_today_amount;
$cycle_text = "received_cycle_bonus";
if ($bonus_cycle >= $cycle_remaining) {
$bonus_cycle = $cycle_remaining;
$cycle_text = "received_cycle_bonus_max";
}
}
$jWallet_received = $bonus_cycle * 0.97 * 0.7;
$rMoney_received = $bonus_cycle * 0.97 * 0.3;
$jWallet = $jWallet + $jWallet_received;
//jWallet get 70% of bonus
$rMoney = $rMoney + $rMoney_received;
//rMoney get 30% of bonus
$bonus_cycle_query = mysqli_query($connect, "UPDATE members SET jWallet={$jWallet},rMoney={$rMoney} WHERE member_id=" . $member_cycle['member_id'] . ";");
if ($bonus_cycle_query) {
mysqli_query($connect, "INSERT INTO transactions(member_id,member_refer,transaction_date,transaction,transaction_description,bonus_id,income,expend,notification_status) VALUES(" . $member_cycle['member_id'] . ",{$member_id},NOW(),'receive','{$cycle_text}',6,{$jWallet_received}+{$rMoney_received},'0','unread') ");
echo "bonus_cycle<br>";
}
}
//$bonus_mc=$bonus_cycle*0.05; //MC bonus get 5% of cycle bonus
$bonus_mc = $calculate_pv * 0.1 * 0.05;
//MC bonus get 5% of PV (edited:12/13/2015)
$jWallet_received = $bonus_mc * 0.97 * 0.7;
$rMoney_received = $bonus_mc * 0.97 * 0.3;
$mc_sponsor_next = mysqli_fetch_assoc(mysqli_query($connect, "SELECT sponsor FROM members WHERE member_id=" . $member_cycle['member_id'] . ";"));
$mc_sponsor_next = $mc_sponsor_next['sponsor'];
if (isset($mc_sponsor_next) and $mc_sponsor_next != 0) {
$level = 2;
do {
$find_mc = mysqli_fetch_assoc(mysqli_query($connect, "SELECT member_id,package_id,sponsor FROM members WHERE member_id={$mc_sponsor_next}"));
$who_mc = $find_mc['member_id'];
$mc_sponsor_next = $find_mc['sponsor'];
$who_mc_result = mysqli_fetch_assoc(mysqli_query($connect, "SELECT member_id,jWallet,rMoney FROM members WHERE member_id=" . $find_mc['member_id'] . ";"));
$jWallet = $who_mc_result['jWallet'];
$rMoney = $who_mc_result['rMoney'];
$jWallet = $jWallet + $jWallet_received;
//jWallet get 70% of bonus
$rMoney = $rMoney + $rMoney_received;
//rMoney get 30% of bonus
$bonus_mc_sql = "UPDATE members SET jWallet={$jWallet},rMoney={$rMoney} WHERE member_id=" . $who_mc_result['member_id'] . ";";
$get_matching_cyle = 'no';
if ($level == 2 and $find_mc['package_id'] >= 2) {
$get_matching_cyle = 'yes';
} elseif ($level == 3 and $find_mc['package_id'] >= 2) {
$get_matching_cyle = 'yes';
} elseif ($level == 4 and $find_mc['package_id'] >= 3) {
$get_matching_cyle = 'yes';
} elseif ($level == 5 and $find_mc['package_id'] >= 4) {
$get_matching_cyle = 'yes';
} elseif ($level == 6 and $find_mc['package_id'] >= 5) {
$get_matching_cyle = 'yes';
} elseif ($level == 7 and $find_mc['package_id'] >= 6) {
$get_matching_cyle = 'yes';
} elseif ($level == 8 and $find_mc['package_id'] == 7) {
$get_matching_cyle = 'yes';
} elseif ($level == 9 and $find_mc['package_id'] == 7) {
$get_matching_cyle = 'yes';
} elseif ($level == 10 and $find_mc['package_id'] == 7) {
$get_matching_cyle = 'yes';
} else {
}
if ($get_matching_cyle == 'yes' and $find_mc['package_id'] >= 2) {
$bonus_mc_query = mysqli_query($connect, $bonus_mc_sql);
if ($bonus_mc_query) {
mysqli_query($connect, "INSERT INTO transactions(member_id,member_refer,transaction_date,transaction,transaction_description,bonus_id,income,expend,notification_status) VALUES(" . $who_mc_result['member_id'] . "," . $member_cycle['member_id'] . ",NOW(),'receive','received_matching_cycle_bonus',7,{$jWallet_received}+{$rMoney_received},'0','unread') ");
echo "bonus_matching_cycle<br>";
}
}
$level++;
} while ($level <= 10 and $mc_sponsor_next != 0);
}
}
} while ($find_cycle_next != 0);
}
