Gecko [ midwest-tb.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
functions	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
.htaccess	4.65 KB	-rw-r--r--
.mad-root	0 B	-rw-r--r--
01admin.zip	112.24 KB	-rw-r--r--
add_user.php	11.21 KB	-rw-r--r--
banner.php	1.41 KB	-rw-r--r--
db.php	30 B	-rw-r--r--
delete.php	357 B	-rw-r--r--
delete_banner.php	736 B	-rw-r--r--
delete_post.php	960 B	-rw-r--r--
delete_user.php	991 B	-rw-r--r--
edit_banner.php	3.38 KB	-rw-r--r--
edit_post.php	11.55 KB	-rw-r--r--
edit_post2.php	5.62 KB	-rw-r--r--
edit_user.php	13.09 KB	-rw-r--r--
editsettings.php	2.61 KB	-rw-r--r--
error_log	54.03 KB	-rw-r--r--
function_users.php	6.8 KB	-rw-r--r--
functions.php	10.92 KB	-rw-r--r--
home.php	6.62 KB	-rw-r--r--
index.php	56 B	-rw-r--r--
insert_banners.php	3.07 KB	-rw-r--r--
insert_post.php	9.63 KB	-rw-r--r--
login.php	1.57 KB	-rw-r--r--
login_admin.php	3.11 KB	-rw-r--r--
logout.php	164 B	-rw-r--r--
member.php	17.64 KB	-rw-r--r--
payment_setting.php	2.97 KB	-rw-r--r--
picupload.php	2.12 KB	-rw-r--r--
post.php	2.02 KB	-rw-r--r--
posts.php	2.94 KB	-rw-r--r--
print_shipment.php	1.91 KB	-rw-r--r--
register_admin.php	8.45 KB	-rw-r--r--
remove_amount.php	1.01 KB	-rw-r--r--
searchmembers.php	2.94 KB	-rw-r--r--
send_email.php	5.02 KB	-rw-r--r--
testimony.php	3.15 KB	-rw-r--r--
upload_files.php	2.59 KB	-rw-r--r--
user_error.php	188 B	-rw-r--r--
user_withdrawal.php	4.99 KB	-rw-r--r--
view_admin.php	2.84 KB	-rw-r--r--
view_banners.php	2.4 KB	-rw-r--r--
view_posts.php	2.85 KB	-rw-r--r--
view_referrals_bonus.php	2.83 KB	-rw-r--r--
view_users.php	4.78 KB	-rw-r--r--
viewconversation.php	5.37 KB	-rw-r--r--
viewmessage.php	2.4 KB	-rw-r--r--
viewmessages.php	4.24 KB	-rw-r--r--
website_setting.php	3.09 KB	-rw-r--r--

Code Editor : view_referrals_bonus.php

<?php include("includes/header.php");
include("includes/navbar.php");
?>

<head>
<title>USERS REFERRALS</title>
<head>

<div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">User Referral Bonus</h4>
                  </div>

<?php

$offset= 0;
$page_result= 100;
				
				if(isset($_GET['pageno'])){

$page_value = $_GET['pageno'];

if($page_value > 1){
						$offset= ($page_value - 1) * $page_result;
					}
				}
	
$sql ="SELECT id FROM users WHERE referrer>'0' ";

$run= mysqli_query($con, $sql);
$count = mysqli_num_rows($run);

function StatName2($user){
global $con;

$query2 =mysqli_query($con, "SELECT id FROM users WHERE username='$user'"); 
$numrows2=mysqli_num_rows($query2);
if($numrows2==0){ $sql2="UPDATE users SET referrer =''  WHERE referrer='$user' ";$run2 =mysqli_query($con, $sql2);
}

$sql= "SELECT fullname FROM users WHERE username ='$user' ";
    $run= mysqli_query($con, $sql);
while($row= mysqli_fetch_assoc($run)){
  $fullname = $row['fullname'];
}
return '<a href="'.$user.'">'.$fullname. ' (@'.$user.') </a>';
}

//$sql ="SELECT referrer, username, COUNT(referrer) AS num FROM users WHERE referrer!='' ORDER BY num DESC LIMIT 4000";

$sql ="SELECT referrer, username, referrer_bonus, COUNT(referrer) AS num FROM users INNER JOIN last_login on last_login.owner = users.username 
WHERE referrer!='' and fullname!='' GROUP BY referrer ORDER BY num DESC LIMIT 4000";
$run= mysqli_query($con, $sql);
 $count = mysqli_num_rows($run);
while ($row = mysqli_fetch_assoc($run)) {
$referrer = $row['referrer']; $num = $row['num']; $referrer_bonus = $row['referrer_bonus'];
//echo StatName2($referrer). " has (".$num. ") referrals<br/> Referral Bonus: ".Currency($referrer_bonus);
               ?>   <?php
  $sql2 = "SELECT * FROM users ORDER BY id DESC LIMIT 0,400";
$run2= mysqli_query($con,$sql2);
$count= mysqli_num_rows($run2);
?>
  <div class="table-responsive">
                    <table class="table table-bordered table-striped">
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Bonus</th>
</tr>
</thead>
<tbody>

<?php
while($row= mysqli_fetch_array($run2)){
  $username = $row['username'];
  $active = $row['active'];
  $email = $row['email'];
    if($active==""){
    $active = "Inactive";
  }
  else{
    $active = "Active";
  }
  ?>
<tr>
<td><a href="<?php echo $username?>"><?php echo $username?></a> </td>
<td><?php echo $email?></td>
<td><?php echo Currency(CountReferralBonus($username))?></td>
</tr>
<?php
if($count==0){
  echo "<p style='color:red'>No Referral yet</p>";
}

}

?></tr>

</tbody>
</table>          
</div><hr/><?php
}
echo'</center><hr/>';
?>

</h4>
</div>

<?php
include("includes/footer.php");

${this.title}

Code Editor : view_referrals_bonus.php