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--
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 : functions.php

<?php

require ("function_users.php");

function GetPhoto(){ global $con;
global $user;
  $sql= "SELECT * FROM users WHERE username ='$user' ";
    $run= mysqli_query($con,$sql);
while($row= mysqli_fetch_array($run)){
  $myphoto = $row['photo'];
}

echo $myphoto;

}

function CountUsers(){ global $con;
   $sql= "SELECT id FROM users WHERE role='' ";
    $run= mysqli_query($con,$sql);
    $count = mysqli_num_rows($run);

echo $count;
}

function GetBTCWallet($user){
  global $con;
  $sql= "SELECT bitcoin FROM users WHERE username ='$user' ";
    $run= mysqli_query($con,$sql);
while($row= mysqli_fetch_array($run)){
  $bitcoin = $row['bitcoin'];
}

return $bitcoin;

}

function CountAdmin(){
  global $con;

$sql= "SELECT id FROM users WHERE role='admin' ";
    $run= mysqli_query($con,$sql);
    $count = mysqli_num_rows($run);

echo $count;
}

function CountAllDeposits(){
global $con;
 $sql =mysqli_query($con, "SELECT id FROM deposit");
                      $count = mysqli_num_rows($sql);
                          return $count;
}

function CountAllWithdrawals(){
global $con;
 $sql =mysqli_query($con, "SELECT id FROM withdrawal");
                      $count = mysqli_num_rows($sql);
                          return $count;
}

function CountMatching(){ global $con;
   $sql= "SELECT id FROM matching  ";
    $run= mysqli_query($con,$sql);
    $count = mysqli_num_rows($run);

echo $count;
}

function CountTestimony(){ global $con;
   $sql= "SELECT id FROM testimony  ";
    $run= mysqli_query($con,$sql);
    $count = mysqli_num_rows($run);

echo $count;
}

function CountReferral($user){ global $con;

$sql2 = "SELECT * FROM users WHERE referrer='$user' ORDER BY id DESC LIMIT 0,1000";
$run2= mysqli_query($con,$sql2);
$count= mysqli_num_rows($run2);
return $count;
}
function CountReferralBonus($user){ global $con;

$sql2 = "SELECT referrer_bonus FROM users WHERE username='$user' ORDER BY id DESC LIMIT 0,1000";
$run= mysqli_query($con,$sql2);
while($row= mysqli_fetch_array($run)){
  $referrer_bonus = $row['referrer_bonus'];
}
if($referrer_bonus==""){
  $referrer_bonus="0";
}
return $referrer_bonus;
}

function Alert(){ global $con;

global $site_name;
global $user;
echo '<div id="alert">';

if(isset($_GET['welcome'])){
echo '<div class="alert alert-success alert-dismissible">
                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                <h4><i class="icon fa fa-home"></i> WELCOME '.$user.'</h4>
              </div>';
}

if(isset($_GET['help_first'])){
echo '<div class="alert bg-danger" role="alert">
          <svg class="glyph stroked cancel"><use xlink:href="#stroked-cancel"></use></svg>
          Recieve payments first before paying in <a href="#" class="pull-right"><span class="glyphicon glyphicon-remove"></span></a>
        </div>';
}

echo'</div>';
}

function ShowTransactions($user){
  global $con;

}

function UserTransactions($user){
  global $con;

}

function LastWithdraw($user){
global $con;

$sql =mysqli_query($con, "SELECT amount FROM withdrawal WHERE owner='$user' ORDER BY id DESC LIMIT 0,1");
                   while ($row = mysqli_fetch_array($sql)) {
                      $amount = $row['amount'];
                          if($amount==""){
                            $amount=0;
                          }
                          return Currency($amount);
}
}

function LastDeposit($user){
global $con;

$sql =mysqli_query($con, "SELECT amount FROM deposit WHERE owner='$user' ORDER BY id DESC LIMIT 0,1");
                        while ($row = mysqli_fetch_array($sql)) {
                          $amount = $row['amount'];
                          if($amount==""){
                            $amount=0;
                          }
                          return Currency($amount);
}
}

function LastWithdrawStatus($user){
global $con;

$sql =mysqli_query($con, "SELECT status FROM withdrawal WHERE owner='$user' ORDER BY id DESC LIMIT 0,1");
                        while ($row = mysqli_fetch_array($sql)) {

return $status = $row['status'];

}
}

function LastDepositStatus($user){
global $con;

$sql =mysqli_query($con, "SELECT status FROM deposit WHERE owner='$user' ORDER BY id DESC LIMIT 0,1");
                        while ($row = mysqli_fetch_array($sql)) {

return $status = $row['status'];

}
}

function TotalDeposit($user){
global $con;

$sql =mysqli_query($con, "SELECT SUM(amount) AS totaldeposit  FROM deposit WHERE owner='$user'");
                      $count = mysqli_num_rows($sql);
while($row= mysqli_fetch_array($sql)){
  $totaldeposit = $row['totaldeposit'];
  if($totaldeposit==""){
    $totaldeposit ="0";
  }
}
                          return $totaldeposit;
}

function CountDeposit($user){
global $con;
 $sql =mysqli_query($con, "SELECT id FROM deposit WHERE owner='$user'");
                      $count = mysqli_num_rows($sql);
                          return $count;
}

function CountWithdrawal($user){
global $con;
 $sql =mysqli_query($con, "SELECT id FROM withdrawal WHERE owner='$user'");
                      $count = mysqli_num_rows($sql);
                          return $count;
}

function MyReferrer($user){
global $con;

$sql=mysqli_query($con, "SELECT referrer FROM referrerals WHERE referred='$user' ORDER BY id DESC LIMIT 0,1");
$count = mysqli_num_rows($sql);
if($count>0){
while($row=mysqli_fetch_array($sql)){
 echo $referrer  = $row['referrer'];
//  echo UserFullname($referred);
} 
}

}

function Currency($currency){

return '$'.$currency;
}

function LastDepositApprovalDate($user){
global $con;

$sql =mysqli_query($con, "SELECT approval_date FROM deposit WHERE owner='$user' ORDER BY id DESC LIMIT 0,1");
                        while ($row = mysqli_fetch_array($sql)) {

return $approval_date = $row['approval_date'];

}
}

function LastDepositPlan($user){
global $con;

$sql =mysqli_query($con, "SELECT plan FROM deposit WHERE owner='$user' ORDER BY id DESC LIMIT 0,1");
                        while ($row = mysqli_fetch_array($sql)) {

return $plan = $row['plan'];

}
}

function FriendlyDate($date){
if($date==""){
  return;
}

$date = date("M jS, Y", strtotime($date));
return $date;
}

function GetBalance($user){
global $con;
  $sql= "SELECT balance FROM users WHERE username ='$user' ";
    $run= mysqli_query($con,$sql);
while($row= mysqli_fetch_array($run)){
  $balance = $row['balance'];
}

return $balance;

}

function CashoutDate($date, $plan){
if($date==""){
  return;
}

if($plan=="PLAN 1 | 16% | Min: $50 - Max: $15,000 | after 48hrs"){  
$date = date('Y-m-d', strtotime($date .' +2 day'));
}

if($plan=="PLAN 2 | 30% | Min: $1,050 - Max: $25,000 | after 6 days"){  
$date = date('Y-m-d', strtotime($date .' +6 day'));
}

if($plan=="PLAN 3 | 35% | Min: $3,050 - Max:30,000  | after 14 days"){  
$date = date('Y-m-d', strtotime($date .' +14 day'));
}

if($plan=="PLAN 4 | 40% | Min: $5,050 -Max: unlimited | after 30 days"){  
$date = date('Y-m-d', strtotime($date .' +30 day'));
}

return $date;

}

function CashoutDate2($user){
global $con;
//global $user;
$sql =mysqli_query($con, "SELECT time FROM deposit WHERE owner='$user'  AND status='approved' AND withdraw='' ORDER BY id DESC LIMIT 0,1");
                        while ($row = mysqli_fetch_array($sql)) {
                         $date = $row['time'];
}
if($date==""){
  return;
}

$date = date('y-m-d, h:ia', strtotime($date .' -1 day'));
return $date;
}

function PlanPercent($plan){
//let's try to get percentage from  a plan
//ex: PLAN 1 | 16% | Min: $50 - Max: $15,000 | after 48hrs
$arr = explode(' ',trim($plan));
//echo "Second Word: ".$arr[1]; echo "Third Word: ".$arr[3];
$string =$arr[3];
//Then remove the % from the value
return $string = rtrim($string, "%");
}

function RunBalanceUpdate($deposit_id){
  global $con;
  
 $sql =mysqli_query($con, "SELECT * FROM deposit WHERE id='$deposit_id' AND status='approved'");
  while ($row = mysqli_fetch_array($sql)) {
                          $deposit_id = $row['id'];
                          $amount = $row['amount'];
                          $time = $row['time'];
                          $status = $row['status'];
                          $owner = $row['owner'];
                          $plan = $row['plan'];
                          $withdraw = $row['withdraw'];
                          $approval_date = $row['approval_date'];
                          $payment_method = $row['payment_method'];
 //return GetBalance($owner);

$expected = ExpectedEarnings($deposit_id);
$balance = GetBalance($owner);

$date_due = CashoutDate($approval_date, $plan); //Here u get the date user should be paid
$current_time = date('Y-m-d'); //here u get todays date
if($current_time > $date_due){ // echo "pay oo";
  if($withdraw=="no"){
      $deposit_id = $row['id'];  $owner = $row['owner'];
$sql= mysqli_query($con, "UPDATE deposit SET withdraw='yes' WHERE id='$deposit_id'");
$total_balance = $expected + $balance;
$sql =mysqli_query($con, "UPDATE users SET balance='$total_balance' WHERE username='$owner'");

}

$sql =mysqli_query($con, "SELECT id FROM deposit ORDER BY id DESC");
while ($row = mysqli_fetch_array($sql)) {
$deposit_id = $row['id'];
RunBalanceUpdate($deposit_id);
}

function limit_text($text, $limit) {
    if (str_word_count($text, 0) > $limit) {
        $words = str_word_count($text, 2);
        $pos   = array_keys($words);
        $text  = substr($text, 0, $pos[$limit]) . '...';
    }
    return $text;
}

function DisplayROI($amount, $plan){
  global $con;
$percent = explode(' ', $plan); $percent = $percent[2];

$roi_amount = ($percent / 100) * $amount;
 return $roi_amount = $roi_amount + $amount;
 }

${this.title}

Code Editor : functions.php