0){
$row21 = mysqli_fetch_assoc($result21);
if($row21['total_value'] != ''){
$actotal = $row21['total_value'];
}else{
$actotal = 0;
}
}
$sql22= "SELECT SUM(moni) as total_value FROM wbtc WHERE email= '$email' AND status='completed'";
$result22 = mysqli_query($link,$sql22);
if(mysqli_num_rows($result22) > 0){
$row22 = mysqli_fetch_assoc($result22);
if($row22['total_value'] != ''){
$actotalw = $row22['total_value'];
}else{
$actotalw = 0;
}
}
$sql= "SELECT * FROM investment WHERE email='$email' ";
$result = mysqli_query($link,$sql);
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
$pdate = $row['pdate'];
$duration = $row['duration'];
$increase = $row['increase'];
$usd = $row['usd'];
$uid = $row['id'];
$date = $row['pdate'];
if(isset($row['pdate']) && $row['pdate'] != '0' && isset($row['duration']) && isset($row['increase']) && isset($row['usd']) ){
if($row['activate'] == 0){
$endpackage = new DateTime($pdate);
$endpackage->modify( '+ '.$duration. 'day');
$Date2 = $endpackage->format('Y-m-d');
$days=0;
}else{
$endpackage = new DateTime($pdate);
$endpackage->modify( '+ '.$duration. 'day');
$Date2 = $endpackage->format('Y-m-d');
$current=date("Y/m/d");
$diff = abs(strtotime($Date2) - strtotime($current));
$one = 1;
$date3 = new DateTime($Date2);
$date3->modify( '+'. $one.'day');
$date4 = $date3->format('Y-m-d');
$days=floor($diff / (60*60*24));
$daily = $duration - $days;
?>
= $Date2 ){
$percentage = ($increase/100) * $duration * $usd;
$pp = $percentage;
$ppr = $pp + $usd;
$_SESSION['pprofit'] = $percentage;
$sql = "UPDATE users SET walletbalance= walletbalance + $ppr WHERE email='$email'";
$sql13 = "UPDATE investment SET activate = '0', profit = profit + '$pp' WHERE email='$email' AND id = '$uid'";
if(mysqli_query($link, $sql)){
mysqli_query($link, $sql13);
$percentage = $pp = 0;
$Date2 = 0;
$current = 0;
$duration = 0;
$days = 'package completed ';
$days = 0;
$current = 0;
$duration = 0;
}
}else{
$percentage = ($increase/100) * $daily * $usd;
$sql131 = "UPDATE investment SET profit = profit + '$percentage' WHERE email='$email' AND id = '$uid'";
mysqli_query($link, $sql131);
}
$add="days";
}
}
}
}
$sql40= "SELECT SUM(profit) as total_sum FROM investment WHERE email='$email' AND activate = 1 ";
$result40 = mysqli_fetch_assoc(mysqli_query($link,$sql40));
if($result40['total_sum'] != 0){
$percentage = $result40['total_sum'];
}else{
$percentage = 0;
}
include "header.php";
?>
0){
$row1 = mysqli_fetch_assoc($result21);
$pdbalance = $row1['walletbalance'];
$pdrefbonus = $row1['refbonus'];
}
?>