?> /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); }