1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / user /
Filename : signup.php
back
<?php 
require_once '../../config/conn.php';
include 'includes/functions.php';
session_start();

$referral_code = ''; // Initialize variable
if (isset($_GET) && !empty($_GET)) {
    $ref = isset($_GET['ref']) ? $_GET['ref'] : '';
    $referral_code = sanitize_input($ref);  
}

error_reporting(E_ALL);
ini_set('display_errors', 1);


// Check if the form has been submitted
if (isset($_POST['submit'])) {
    $fullname = sanitize_input($_POST['fullname']);
    $username = sanitize_input($_POST['username']);
    $email = sanitize_input($_POST['email']);
    $coupon_code = sanitize_input($_POST['coupon_code']);
    $password = sanitize_input($_POST['password']);

    $fullname = mysqli_real_escape_string($con, $fullname);
    $username = mysqli_real_escape_string($con, $username);
    $email = mysqli_real_escape_string($con, $email);
    $coupon_code = mysqli_real_escape_string($con, $coupon_code);
    $password = mysqli_real_escape_string($con, $password);

    $hashed_password = password_hash($password, PASSWORD_DEFAULT);

    // Checking if the referral is set
    if (empty($referral_code)) {
        $referral_code = "TAPNAIRE";
    }

    // Checking if the email and username already exist
    $queryCheck = "SELECT * FROM users WHERE email = ? OR username = ?";
    $stmtCheck = mysqli_prepare($con, $queryCheck);
    mysqli_stmt_bind_param($stmtCheck, "ss", $email, $username);
    mysqli_stmt_execute($stmtCheck);
    $resultCheck = mysqli_stmt_get_result($stmtCheck);

    if (mysqli_num_rows($resultCheck) > 0) {
        $msg = "Username or email already exists!";
        $type = "warning"; 
    } else {
        // Proceed with checking the coupon code
        $coupon_stmt = $con->prepare("SELECT `id`, `plan_id`, `amount`, `country_id` FROM `coupons` WHERE `coupon_code` = ? AND `status` = '0'");
        $coupon_stmt->bind_param("s", $coupon_code);
        $coupon_stmt->execute();
        $coupon_result = $coupon_stmt->get_result();

        if ($coupon_result->num_rows === 0) {
            $msg = "Invalid coupon code. Please try again.";
            $type = "warning";
        }
        
        if ($coupon_result->num_rows > 0) {
            $coupon = $coupon_result->fetch_assoc();
            $cid = $coupon['id'];
            $plan_id = $coupon['plan_id'];
            $country_id = $coupon['country_id'];

            // Fetch country-specific bonuses
            $country_stmt = $con->prepare("SELECT * FROM `plans` WHERE `pid` = ?");
            $country_stmt->bind_param("i", $plan_id);
            $country_stmt->execute();
            $country_result = $country_stmt->get_result();
            $country = $country_result->fetch_assoc();

            $plan_country_id = $country['country_id'];
            $initial_earning = $country['welcome_bonus'];
            $ref_bonus_amount = $country['affiliate_bonus'];
            $indirect_bonus_amount = $country['first_indirect_bonus'];
            $second_bonus_amount = $country['second_indirect_bonus'];
            $plan_type = $country['type'];

            // Proceed with inserting the new record
            $query = "INSERT INTO users (`fullname`, `plan_id`,`username`, `email`, `referral_code`, `earnings`, `referred_by`, `password`, `coupon_code`, `country_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            $stmt = mysqli_prepare($con, $query);
            mysqli_stmt_bind_param($stmt, "sssssssssi",$fullname, $plan_id, $username, $email, $username, $initial_earning, $referral_code, $hashed_password, $coupon_code, $country_id);

            if (mysqli_stmt_execute($stmt)) {
                $newUserId = mysqli_insert_id($con); // Get the ID of the newly inserted record
                  
                 //Set a welcome bonus message to send as a notification
                $bonus_message="You have earned a welcome bonus of $initial_earning";    
                $notificationsql="INSERT INTO `notifications` (`receiver_id`,`action_type`,`body`)
                                            VALUES  ('$newUserId','Signup','$bonus_message')";
                $result2=mysqli_query($con,$notificationsql);
                
                  // Check for direct referrer
                  $referrer_query = "SELECT users.id, users.plan_id, users.referred_by, plans.type 
                  FROM users 
                  LEFT JOIN plans ON users.plan_id = plans.pid 
                  WHERE users.username = ?";
                  $stmtReferrer = mysqli_prepare($con, $referrer_query);
                  mysqli_stmt_bind_param($stmtReferrer, "s", $referral_code);
                  mysqli_stmt_execute($stmtReferrer);
                  $referrer_result = mysqli_stmt_get_result($stmtReferrer);

                  if ($referrer_result->num_rows > 0) {
                    $referrer = $referrer_result->fetch_assoc();
                    $referrer_id = $referrer['id'];
                    $referrer_plan_id = $referrer['plan_id'];  // Fetch the referrer's plan type
                    $indirect_referrer_code = $referrer['referred_by'];
                                
                    // Fetch the referrer's affiliate bonus based on their plan type
                    $ref_country_stmt = $con->prepare("SELECT * FROM `plans` WHERE `pid` = ?");
                    $ref_country_stmt->bind_param("s", $referrer_plan_id);
                    $ref_country_stmt->execute();
                    $ref_country_result = $ref_country_stmt->get_result();
                
                    if ($ref_country_result->num_rows > 0) {
                        $ref_country = $ref_country_result->fetch_assoc();
                        $referrer_bonus_amount = $ref_country['affiliate_bonus'] ?? 0; // Use null coalescing to avoid undefined index
                        $referrer_first_indirect_bonus_amount = $ref_country['first_indirect_bonus'] ?? 0;
                        $referrer_second_indirect_bonus_amount = $ref_country['second_indirect_bonus'] ?? 0;
                    } else {
                        $referrer_bonus_amount = 0;
                        $referrer_first_indirect_bonus_amount = 0;
                        $referrer_second_indirect_bonus_amount = 0;
                    }
                
                    // Fetch the new user's plan details
                    $referred_plan_type = $plan_type; // Plan type of the new user
                    $referred_bonus_amount = $ref_bonus_amount;
                    $referred_first_indirect_bonus_amount = $indirect_bonus_amount;
                    $referred_second_indirect_bonus_amount = $second_bonus_amount;
                
                    // Check if the referrer's plan type is lower than the referred user's
                    if ($referrer_plan_id == 'Lower') { // Corrected comparison operator
                        $ref_bonus_amount = $referrer_bonus_amount; // Referrer gets their own plan bonus
                    } else {
                        $ref_bonus_amount = $referred_bonus_amount; // Referrer gets the full bonus
                    }
                
                    $bonus_type = 0;
                
                
                  // Handle direct referral bonus
                  handleReferralBonus($con, $referrer_id, $ref_bonus_amount, "You have earned a direct referral bonus of $ref_bonus_amount!", $bonus_type);

                    // Check for first indirect referrer
                    if (!empty($indirect_referrer_code)) {
                        $indirect_referrer_query = "SELECT `id`, `country_id`, `referred_by` FROM users WHERE `username` = ?";
                        $stmtIndirectReferrer = mysqli_prepare($con, $indirect_referrer_query);
                        mysqli_stmt_bind_param($stmtIndirectReferrer, "s", $indirect_referrer_code);
                        mysqli_stmt_execute($stmtIndirectReferrer);
                        $indirect_referrer_result = mysqli_stmt_get_result($stmtIndirectReferrer);

                        if ($indirect_referrer_result->num_rows > 0) {
                            $indirect_referrer = $indirect_referrer_result->fetch_assoc();
                            $indirect_referrer_id = $indirect_referrer['id'];
                            $indirect_referrer_country_id = $indirect_referrer['country_id'];
                            $second_indirect_referrer_code = $indirect_referrer['referred_by'];

                            // Fetch country-specific bonuses for the first indirect referrer
                            $indirect_country_stmt = $con->prepare("SELECT `first_indirect_bonus` FROM `plans` WHERE `pid` = ? AND `type` = ?");
                            $indirect_country_stmt->bind_param("ii", $plan_country_id, $plan_type);
                            $indirect_country_stmt->execute();
                            $indirect_country_result = $indirect_country_stmt->get_result();
                            $indirect_country = $indirect_country_result->fetch_assoc();
                            $indirect_bonus_amount = $indirect_country['first_indirect_bonus'];
                            $bonus_type = 1;

                              // Check if the referrer's plan type is lower than the referred user's
                              if ($referrer_plan_id = 'Lower') {
                                $indirect_bonus_amount = $referrer_first_indirect_bonus_amount; // Referrer gets their own plan bonus
                                } else {
                                $indirect_bonus_amount = $referred_first_indirect_bonus_amount; // Referrer gets the full bonus
                                }
                                
                            // Handle first indirect referral bonus
                            handleReferralBonus($con, $indirect_referrer_id, $indirect_bonus_amount, "You have earned a first indirect referral bonus of $indirect_bonus_amount!",$bonus_type);

                            // Check for second indirect referrer
                            if (!empty($second_indirect_referrer_code)) {
                                $second_indirect_referrer_query = "SELECT `id`, `country_id` FROM users WHERE `username` = ?";
                                $stmtSecondIndirectReferrer = mysqli_prepare($con, $second_indirect_referrer_query);
                                mysqli_stmt_bind_param($stmtSecondIndirectReferrer, "s", $second_indirect_referrer_code);
                                mysqli_stmt_execute($stmtSecondIndirectReferrer);
                                $second_indirect_referrer_result = mysqli_stmt_get_result($stmtSecondIndirectReferrer);

                               
                            }
                        }
                    }
                }


                // Update the coupon status to '1' to mark it as used
                $queryCouponStatus = "UPDATE coupons SET status = '1', used_by = ? WHERE id = ?";
                $stmtCouponStatus = mysqli_prepare($con, $queryCouponStatus);
                mysqli_stmt_bind_param($stmtCouponStatus, "si", $username, $cid);
                mysqli_stmt_execute($stmtCouponStatus);

                // Log the user in and redirect to the dashboard
                session_regenerate_id(true); // Regenerate session ID

                $_SESSION['email'] = $email;
                $_SESSION['id'] = $newUserId;
                $_SESSION['username'] = $username;

                $msg = "Registration Successful. Redirecting you ...";
                $type = "success";
                ?>
                <script>
                setTimeout(function () {
                    window.location = 'index.php';
                }, 3000);
                </script>
                <?php
            } else {
                $msg = "Invalid coupon code.";
                $type = "warning"; 
            }

            mysqli_stmt_close($stmt);
            mysqli_stmt_close($stmtCheck);
            mysqli_stmt_close($stmtCouponStatus);
            mysqli_stmt_close($country_stmt);
            mysqli_stmt_close($coupon_stmt);
        }
    }

   // Close the remaining statements safely
if (isset($stmtReferrer) && $stmtReferrer instanceof mysqli_stmt) {
    mysqli_stmt_close($stmtReferrer);
}

if (isset($stmtIndirectReferrer) && $stmtIndirectReferrer instanceof mysqli_stmt) {
    mysqli_stmt_close($stmtIndirectReferrer);
}

if (isset($stmtSecondIndirectReferrer) && $stmtSecondIndirectReferrer instanceof mysqli_stmt) {
    mysqli_stmt_close($stmtSecondIndirectReferrer);
}

}
?>

<!DOCTYPE html>
<html lang="en">  
<head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    
    <!-- SEO Meta Tags -->
    <meta name="description" content="Revolutionize your earnings with Tapnaire. Experience seamless, fast, and secure tap-to-pay transactions to boost your financial potential." />
    <meta name="keywords" content="Tap to pay, digital payments, earn money, fast transactions, financial freedom, contactless payments, fintech" />
    <meta name="author" content="Tapnaire" />
    
    <!-- Open Graph Meta Tags (for social media) -->
    <meta property="og:title" content="Revolutionize Your Earnings with Tapnaire" />
    <meta property="og:description" content="Join Tapnaire and unlock seamless transactions with tap-to-pay technology, making earnings faster and easier than ever." />
    <meta property="og:image" content="https://www.tapnaire.live/assets/images/preview.jpg" />
    <meta property="og:url" content="https://www.tapnaire.live" />
    <meta property="og:type" content="website" />

    <!-- Twitter Meta Tags -->
    <meta name="twitter:card" content="summary_large_image" />
    <meta name="twitter:title" content="Revolutionize Your Earnings with Tapnaire" />
    <meta name="twitter:description" content="Join Tapnaire and unlock seamless transactions with tap-to-pay technology, making earnings faster and easier than ever." />
    <meta name="twitter:image" content="https://www.tapnaire.live/assets/images/preview.jpg" />

    <!-- Favicon -->
    <link rel="shortcut icon" href="assets/images/logo.png" type="image/x-icon" />

    <!-- Stylesheets -->
    <link rel="stylesheet" href="assets/css/swiper.min.css" />
    <link href="style.css" rel="stylesheet">
    <link href="assets/css/custom.css" rel="stylesheet">

    <!-- Scripts -->
    <script src="https://unpkg.com/@phosphor-icons/web"></script>
    <link rel="manifest" href="manifest.json" />

    <title>Tapnaire - Signup</title>
</head>

  <body class="">
    <div
      class="container min-h-dvh relative overflow-hidden py-8 px-6 dark:text-white dark:bg-color1"
    >
      <!-- Absolute Items Start -->
      <img
        src="assets/images/header-bg-2.png"
        alt=""
        class="absolute top-0 left-0 right-0 -mt-6"
      />
      <div
        class="absolute top-0 left-0 bg-[#012d30] blur-[145px] h-[174px] w-[149px]"
        ></div>
        <div
        class="absolute top-40 right-0 bg-[#FF710F] blur-[150px] h-[174px] w-[91px]"
        ></div>
        <div
        class="absolute top-80 right-40 bg-[#FF8C42] blur-[235px] h-[205px] w-[176px]"
        ></div>
        <div
        class="absolute bottom-0 right-0 bg-[#012d30] blur-[220px] h-[174px] w-[149px]"
        ></div>
      <!-- Absolute Items End -->
      <!-- Page Title Start -->
      <div class="flex justify-start items-center gap-4 relative z-10">
        <a
          href="../"
          class="bg-white p-2 rounded-full flex justify-center items-center text-xl dark:bg-color10"
        >
          <i class="ph ph-caret-left"></i>
        </a>
        <h2 class="text-2xl font-semibold text-white">Sign Up</h2>
      </div>
      <!-- Page Title End -->

      <!-- Sign In Form Start -->
      <form action="" class="relative z-10" method="post">

        <div class="bg-white py-8 px-6 rounded-xl mt-12 dark:bg-color10">
       
        <div class="flex justify-between items-center">
            <a
              href="login.php"
              class="text-center text-xl font-semibold text-bgColor18 border-b-2 pb-2 border-bgColor18 w-full dark:text-color18 dark:border-color18"
            
              >Sign In</a
            >
            <a
              href="#"
              class="text-center text-xl font-semibold text-p2 border-b-2 pb-2 border-p2 w-full dark:text-p1 dark:border-p1"
              style="color:#012d30; border-bottom:2px solid #012d30;"              >Sign Up</a
            >
          </div>
        <div class="text-center pt-2">
        
        </div>
            <?php if(isset($msg)) { ?>
                <div class="error-wrapper-<?php echo $type?> pt-2">
                <span class="message-<?php echo $type?>"><?php echo $msg; ?></span>
                </div>
            <?php }?>

          <div class="pt-6">
            <p class="text-sm font-semibold pb-2">Fullname</p>
            <div
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
            >
              <input
                type="text"
                name="fullname"
                placeholder="Enter Fullname"
                value="<?php if(isset($_POST['fullname'])) echo $_POST['fullname']; ?>"
                class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18"
                required            
                />
              <i
                class="ph ph-user text-xl text-bgColor18 !leading-none"
              ></i>
            </div>
          </div>
          <div class="pt-4">
            <p class="text-sm font-semibold pb-2">Username</p>
            <div
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
            >
              <input
                type="text"
                name="username"
                id="username"
                placeholder="Enter Username"
                onBlur="userAvailability()"  value="<?php if(isset($_POST['username'])) echo $_POST['username']; ?>"
                class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18"
                required
                />
              <i
                class="ph ph-user text-xl text-bgColor18 !leading-none"
              ></i>                            
            </div>
            <span class="" id="user-availability-status" 
                style="font-size:13px;margin-top:2px;margin-bottom:0px;">
             </span>   
          </div>
          <div class="pt-4">
            <p class="text-sm font-semibold pb-2">Email</p>
            <div
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
            >
              <input
                type="email"
                name="email"
                placeholder="Enter Email"
                class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18"
               required
                />
              <i
                class="ph ph-envelope-simple text-xl text-bgColor18 !leading-none"
              ></i>
            </div>
          </div>
          <div class="pt-4">
            <p class="text-sm font-semibold pb-2">Referral</p>
            <div
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
            >
              <input
                type="text"
                name="referrer_id"
                placeholder="Referral (optional)"
                class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18"
                value="<?php if(isset($_GET['ref'])) echo $_GET['ref']; ?>"
               disabled
                />
              <i
                class="ph ph-user text-xl text-bgColor18 !leading-none"
              ></i>
            </div>
          </div>
            <div class="pt-4">
            <p class="text-sm font-semibold pb-2">Select Country</p>
            <div
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
            >
            <select id="country" name="country" required
            class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18"
            >
                <option value="">----</option>
                <?php
                $countryQuery = "SELECT * FROM countries";
                $countryResult = mysqli_query($con, $countryQuery);
                while ($row = mysqli_fetch_assoc($countryResult)) {
                    echo "<option value='{$row['id']}'>{$row['name']}</option>";
                }
                ?>
            </select>

            </div>
          </div>
          <div class="pt-4">
            <p class="text-sm font-semibold pb-2">Select Plan</p>
            <div
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
            >
            <select name="plan" id="plan" required
            class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18"
            >
                    <option value="">--Select Plan --</option>                           
            </select>
            </div>
          </div>
          <div class="pt-4">
            <p class="text-sm font-semibold pb-2">Coupon</p>
            <div style="margin-bottom:5px;"
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
               style="font-size:12px !important;"
              >
              <input
                type="text"
                name="coupon_code"
                placeholder="Enter Coupon Code"
                value="<?php if(isset($_POST['coupon'])) echo $_POST['coupon']; ?>"
                class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18"
              />
              <i
                class="ph ph-gift text-xl text-bgColor18 !leading-none"
              ></i>
            </div>
            Don't have Coupon? <a href="../vendors.php" 
             style="color:#012d30;"
             class="terms fw-bold text-decoration-underline">Buy Now</a>
            </div>
          <div class="pt-4">
            <p class="text-sm font-semibold pb-2">Password</p>
            <div
              class="flex justify-between items-center py-3 px-4 border border-color21 rounded-xl dark:border-color18 gap-3"
            >
              <input
                type="password"
                name="password"
                placeholder="*****"
                class="outline-none bg-transparent text-n600 text-sm placeholder:text-sm w-full placeholder:text-bgColor18 dark:text-color18 dark:placeholder:text-color18 passwordField"
                   required
                />
              <i
                class="ph ph-eye-slash text-xl text-bgColor18 !leading-none passowordShow cursor-pointer dark:text-color18"
              ></i>
            </div>
          </div>
          <a
            href=""
            class="text-end text-p2 text-sm font-semibold block pt-2 dark:text-p1"
            ></a
          >
     
        <div class="pt-4">
            <label
              for="checkbox"
              class="flex justify-start items-center gap-3 text-sm cursor-pointer"
            >
              <input
                type="checkbox"
                name="agree"
                id="checkbox"
                class="peer hidden"
                required
              />
              <span
                class="border border-color21 size-7 rounded-full flex justify-center items-center !leading-none text-white peer-checked:bg-p2 dark:border-color24"
              >
                <i class="ph ph-check"></i>
              </span>
              I agree with the terms &amp; policy.
            </label>
          </div>
        </div>
        <button  
          type="submit"
          name="submit"
          style="width:100%;"
          class="bg-p2 rounded-full py-3 text-white text-sm font-semibold text-center block mt-12 dark:bg-p1"
          >Sign Up
          </button>
      </form>
      
      <!-- Sign In Form End -->
    </div>


    <!-- Javascript Dependencies -->
    <script src="assets/js/main.js"></script>
  <script defer src="index.js"></script>

  <script src="https://code.jquery.com/jquery-3.6.0.min.js" ></script>

  
<script>
$(document).ready(function() {
    function userAvailability() {
        $("#loaderIcon").show(); // Ensure #loaderIcon exists or remove this line
        $.ajax({
            url: "includes/check_availablility.php",
            data: 'username=' + $("#username").val(),
            type: "POST",
            success: function(data) {
                $("#user-availability-status").html(data);
                $("#loaderIcon").hide(); // Ensure #loaderIcon exists or remove this line
            },
            error: function() {
                $("#user-availability-status").html("An error occurred.");
                $("#loaderIcon").hide(); // Ensure #loaderIcon exists or remove this line
            }
        });
    }

    // Bind the userAvailability function to the blur event of #username
    $("#username").blur(userAvailability);
});
</script>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
    $("#country").change(function() {
        var countryId = $(this).val();
        if (countryId !== "") {
            $.ajax({
                url: "fetch-plans.php",
                type: "POST",
                data: { country_id: countryId },
                success: function(response) {
                    $("#plan").html(response);
                }
            });
        } else {
            $("#plan").html('<option value="">Select a Plan</option>');
        }
    });
});
</script>

</body>
</html>