1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / oxyield.live / user /
Filename : activate-account.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.php');
include('includes/checklogin.php');
include('includes/functions.php');
include('includes/mail-settings.php');

check_login();
$title = "Dashboard";
$uip = $_SERVER['REMOTE_ADDR'];
include 'includes/header.php';

$uid = $_SESSION['id'];
$sql = "SELECT * FROM `users` WHERE `id`=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);
$username = $row['username'];
$userReferrerCode = $row['referred_by'];

if (isset($_GET['activate'])) {
    // Check if the account is already activated
    if ($row['status'] == 1) {
        $msg = "Your account is already activated.";
        $type = "warning";
    } elseif ($row['funding'] >= 10) {
        // Deduct $10 from 'funding'
        $newFunding = $row['funding'] - 10;

        // Update 'funding' and 'status' columns in the database
        $updateSql = "UPDATE `users` SET `funding`=$newFunding, `status`=1 WHERE `id`=$uid";
        $updateResult = mysqli_query($con, $updateSql);

        if ($updateResult) {
          $activation_fee = 10;
          // Calculate the referral commission (40% of the capital)
          $referrer_commission = 0.40 * $activation_fee; // 40% expressed as a decimal
 
          // Get the user's referral code
 
          // Check if the user has a referrer (referral code is not empty)
          if (!empty($userReferrerCode)) {
              // Fetch the referrer's user ID using the referral code
              $referrerSql = "SELECT `id` FROM `users` WHERE `referral_code`='$userReferrerCode'";
              $referrerResult = mysqli_query($con, $referrerSql);
              $referrerRow = mysqli_fetch_assoc($referrerResult);
              $referrerID = $referrerRow['id'];
              $coin_bonus=20;
              // Update the referrer's bonus in the users table
              $updateReferrerSql = "UPDATE `users` SET `ibo`=`ibo` + '$referrer_commission',`coin`=`coin` + '$coin_bonus' WHERE `id`='$referrerID'";
              $updateReferrerResult = mysqli_query($con, $updateReferrerSql);
 
              if ($updateReferrerResult) {
                   // Enter the earning history
                   $earningsql = "INSERT INTO `earning_history` (`user_id`,`type`, `amount`) VALUES ('$referrerID','Activation', '4')";
                   $result3 = mysqli_query($con, $earningsql);
                   
                  //Set a bonus message to send as a notification
                  $bonus_message="You just received $$referrer_commission bot activation commission and 20 ZEL Token from  $username.";    
                  $notificationsql="INSERT INTO `notifications` (`receiver_id`,`action_type`,`body`)
                                              VALUES  ('$referrerID','Task','$bonus_message')";
                  $result2=mysqli_query($con,$notificationsql);
 
              } else {
                  // Failed to update the referrer's bonus
                  // Handle the error as needed
              }
          }
          
         // Send an email to notify the account activation
         $to = $row['email'];
         $subject = "Account Activation";
         // Set MIME headers to indicate HTML content
         $mailHeaders .= 'From: Zelnex Bot <' . $noreply_email . '>' . "\r\n";
         $mailHeaders .= "MIME-Version: 1.0\r\n";
         $mailHeaders .= "Content-Type: text/html; charset=UTF-8\r\n";
 
         $content = '
         <!DOCTYPE html>
         <html>
         <head>
           <meta charset="UTF-8">
           <title>Account Activation</title>
           <style>
           body {
             font-family: Arial, sans-serif;
             background-color: #f6f6f6;
             margin: 0;
             padding: 0;
           }
           .container {
             max-width: 600px;
             margin: 0 auto;
             padding: 20px;
             background-color: #ffffff;
           }
           h1 {
             font-size: 24px;
             font-weight: bold;
             color: #047ded;
             margin-top: 0;
           }
           p {
             font-size: 16px;
             line-height: 1.5;
             color: #000000;
           }
           .code {
             font-size: 32px;
             font-weight: bold;
             color: #00afe9;
             text-transform: uppercase;
           }
           .footer {
             font-size: 14px;
             color: #808080;
             margin-top: 20px;
           }
           .logo {
             text-align: center;
             margin-bottom: 20px;
           }
         </style>
         </head>
         <body>
           <div class="container">
             <div class="logo">
               <img src="https://zelnexbot.com/images/logo.png" alt="Logo" width="100" height="auto" />
             </div>
             <h1>Account Activation</h1>
             <p>
               <b>Dear '.$username.',</b><br>
               Congrats! Your Zelnex Bot account has been activated.
             </p>
             <p>
               You now have access to all our services. Happy trading
               </p>
             <p class="footer">
             If you did not activate your account, please ignore this message.
             </p>
           </div>
         </body>
         </html>
         ';
 
         $mailResult = mail($to, $subject, $content, $mailHeaders);
 
         if ($mailResult) {
    
             // Email sent successfully
             $msg = "Account activated. An email notification has been sent.";
             $type = "success";
         ?>
           <script>
           setTimeout(function () {
           window.location ='index.php';
           }, 3000);
           </script>;
          <?php
         } else {
             // Email sending failed
             $msg = "Account activated, but email notification failed to send.";
             $type = "warning";
             ?>
             <script>
             setTimeout(function () {
             window.location ='index.php';
             }, 3000);
             </script>;
            <?php
         }
         }else {
         // Database update failed
         $msg = "Failed to activate account. Please try again.";
         $type = "warning";
         }
         } else {
         // funding is less than $10
         $msg = "Your funding balance is less than $10. Account not activated.";
         $type = "warning";
         }
}
?>
<!-- Your HTML content goes here -->

<div class="container-fluid main-content px-2 px-lg-4">
    <div class="row my-2 g-3 g-lg-4 promotion">
        <div class="col-12 d-flex justify-content-between align-items-center px-3 flex-wrap gap-3">
            <h4 class="text-white mb-0">Activate Account <?php echo $username;?></h4>
        </div>
        <div class="tab-content pb-3" id="pills-tabContent">

        <?php if(isset($msg)) { ?>
                <div class="alert alert-<?php echo $type?>">
               <?php echo $msg; ?>
                </div>
                <?php }?>

                
        <?php 
                if($row['funding'] == 0){?> 
                <div class="container-fluid pt-4 ">
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fa fa-exclamation-circle me-2"></i>Please kindly fund your account to proceed with activation
                                <span>
                          <a href="activate-account.php" 
                              style="font-size:12px;margin-left:10px;
                              padding-left:8px;padding-right:8px;padding-top:2px;padding-bottom:2px;"
                               class="btn btn-danger rounded-pill">Activate Account</a>
                        </span>
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>

                </div>
                
                <?php } ?> 

            <div class="tab-pane fade show active" id="pills-home" role="tabpanel" tabindex="0">
                <div class="row g-3 g-lg-4">
                  
                <div class="col-md-6 col-xl-4 col-xxl-3">
                  <div class="promotion-card">
                 
                    <div class="promo-content">
                      <p class="fw-bold text-white large">
                        Activate with wallet balance
                      </p>
                      <p><span>Already funded your account? Continue with activation</span></p>
                      
        <?php 
                if($row['funding'] >= 10){?> 
                    <a href="?activate=true" 
                       class=" d-flex align-items-center gap-2 btn btn-success">Activate Now
                       <i class="fa fa-arrow-right"></i>
                    </a>
             <?php }else{?>
                <a href="deposit.php"
                       class="outline-btn-lg d-flex align-items-center gap-2">Fund Account
                       <i class="fa fa-arrow-right"></i>
                </a>
                <?php } ?>   
                    </div>
                  </div>
                </div>

                </div>
            </div>
        </div>
    </div>
</div>
<?php include 'bottom-tabs.php' ?>
<?php include 'includes/footer.php' ?>