1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / elevatetrader1.com / dashboard /
Filename : affiliates.php
back
<?php
session_start();
error_reporting(0);
include('../../config/econfig.php');
include('includes/checklogin.php');
check_login();
$title="Dashboard";
$uid=$_SESSION['id'];
$uname=$_SESSION['username'];
$uip=$_SERVER['REMOTE_ADDR'];
include 'includes/header.php'; 
include 'includes/sidebar.php';

$currentTime = date( 'd-m-Y h:i:s A', time () );
$uid= $_SESSION['id'];

$sql = "SELECT * FROM users WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);

function randString($length, $charset='0123456789'){
    $str = '';
    $count = strlen($charset);
    while ($length--) {
    $str .= $charset[mt_rand(0, $count-1)];
    }
    return $str;
    }
    $unique_id = randString(8);

$codequery ="SELECT * FROM `transactions` WHERE `code`='$unique_id' ";
$result = mysqli_query($con, $codequery);
$count=mysqli_num_rows($result);
if($count>0)
{
$unique_id = randString(8);
}
$code="$unique_id";

if(isset($_POST['submit']))
{
    $coin=$_POST['coin'];
    $amount=$_POST['amount'];
    $address=$_POST['address'];

    $oldbal=$row[$coin];
    $newbal=($oldbal-$amount);

    if($amount > $oldbal){ 
        $msg="Sorry your balance is lower than the entered withdrawal amount.";
        $type = "warning";
    }else{
    $sql1="INSERT INTO `transactions` (`user_id`,`coin`,`type`,`amount`,`address`,`code`)
    VALUES  ('$uid','$coin','Withdrawal','$amount','$address','$code')";
    $result1=mysqli_query($con,$sql1);
    if($result1){  
    $updateQuery="UPDATE `users` SET `$coin`='$newbal' WHERE `id`='$uid'";   
    $result2=mysqli_query($con,$updateQuery);  
    $msg="Transaction reference submitted successfully. Please Wait for confirmation.";
    $type = "success";
    echo '<script>
    setTimeout(function () {
      window.location ="dashboard.php";
  }, 3000);</script>';
    }else{
    $msg="something went wrong,please try again";
    $type = "warning";
    }  
}

}

			?>



          <div class="container-fluid pt-4 px-4">
        <div class="bg-secondary  rounded p-4">
              <div class="d-flex align-items-center justify-content-between mb-4">
                  <h4 class="card-title">Refferal Link</h4>
              </div>
              <?php if(isset($msg)) { ?>
                <div class="error-wrapper-<?php echo $type?>">
                <span class="message-<?php echo $type?>"><?php echo $msg; ?></span>
                </div>
                <?php }?>
              <p class="card-description">Copy and paste this link to send to friends or use in your articles. When users sign up using this link, 
                    your account will be credited with referral bonuses in the form of bitcoin.</p>

              <div class="">
                <?php 
                            $query2="select * from users WHERE id='$uid' ";
                            $query_run=mysqli_query($con,$query2);
                            $data = mysqli_fetch_array($query_run);
                            $rid=$data['username'];
                ?>

                <div class=" form-group mb-3" > 
                <input type="text"  class="form-control"
                value="https://elevatetrader1.com/register.php?ref=<?php echo $rid; ?>" id="myInput">
                </div>
                <button class="btn btn-primary" onclick="myFunction()">Copy Link</button>
                </div>
        </div>
        </div>

              
        <div class="container-fluid pt-4 px-4">
        <div class="bg-secondary  rounded p-4">
              <div class="d-flex align-items-center justify-content-between mb-4">
                  <h4 class="card-title">Affiliate Status</h4>
              </div>
              <p class="card-description">Your Referrals</p>

              <div class="table-responsive">
                      <table class="table table-striped">
                        <thead>
                          <tr>
                            <th> S/N </th>
                            <th> Username </th>
                            <th> Status </th>
                          </tr>
                        </thead>
                        <?php 
                  $query="SELECT * FROM `users` WHERE `ref`='$uname' ";
                  $result=mysqli_query($con,$query);
                  $cnt=1;
                  if(mysqli_num_rows($result)>0){
                    while($row=mysqli_fetch_array($result)){
                      ?>
                        <tbody>
                          <tr>
                            <td> <?php echo $cnt;?> </td>
                            <td> <?php echo $row['username'];?> </td>
                            <td><?php 
                                if($row['status'] == 1){?> 
                <label class="badge badge-success">Verified</label>
                                  <?php 
                                   }else{
                                   ?>   
                <label class="badge badge-danger">Unverified</label>
                             <?php } ?>
                            </td>
                          </tr>
                          <?php } 
                    }else{

                      echo"
                      <div class='card-body'>
                      <p style='text-align:left'> No Referral yet!</p>
                       </div>
                      ";
                    }
                    ?>
                        </tbody>
                      </table>
                    </div>
        </div>
        </div>


            
             
            
              
       
        <script>
    function myFunction() {
  /* Get the text field */
  var copyText = document.getElementById("myInput");

  /* Select the text field */
  copyText.select();
  copyText.setSelectionRange(0, 99999); /* For mobile devices */

   /* Copy the text inside the text field */
  navigator.clipboard.writeText(copyText.value);

  /* Alert the copied text */
  alert("Link copied to bash clipboard");
} 
</script>
<?php include 'includes/footer.php' ?>