File size: 4.11Kb
<?php
include '../db.php';
include '../functions.php';
headtag("$SiteName - Pay Subscriptions Payments To All Users");
if($adminlog=='1'){
$lastmonth=date("F", time()-2592000);
echo '<div class="title">Pay Subscriptions Payments To All Users</div>';
$lul = mysql_query('SELECT username from userdata WHERE ucstatus="1" AND status="ACTIVE"');
while(list($user) = mysql_fetch_row($lul)){
if(isset($_POST["month"]) AND isset($_POST["sdate"]) AND isset($_POST["edate"]) AND isset($_POST["captcha"])){
$month=formpost("month");
$sdate=formpost("sdate");
$edate=formpost("edate");
$captcha=formpost("captcha");
$arshad = mysql_query("SELECT pubalance,verimobile,email FROM userdata WHERE username='$user'");
$mohd = mysql_fetch_array($arshad);
$pubalance=$mohd["pubalance"];
$mobile=$mohd["verimobile"];
$email=$mohd["email"];
$checkearning=mysql_fetch_array(mysql_query("SELECT SUM(earning) FROM cpsreport WHERE user='$user' AND status='UnPaid' AND date BETWEEN '$sdate' AND '$edate'"));
$checkearning=$checkearning[0];
$errors=array();
if(strlen($sdate)<1){
$errors[]='Enter Start Date.';
}
if(strlen($edate)<1){
$errors[]='Enter End Date.';
}
if(empty($checkearning)){
$errors[]='0 Earnings During This Period.';
}
if($_SESSION["captcha"]!=$captcha){
$errors[]='Wrong Captcha.';
}
if(empty($errors)){
$earning=mysql_fetch_array(mysql_query("SELECT SUM(earning) FROM cpsreport WHERE user='$user' AND status='UnPaid' AND date BETWEEN '$sdate' AND '$edate'"));
$earning=$earning[0];
if($mobile!='')
{
$msg = "Hello $user ,
We have paid 100% of your subscriptions earnings from $sdate To $edate subscriptions to your main account.
Thanks for using EarnBuzz.In";
Send_SMS($mobile,$msg);
}
$to = $email;
$subject = 'Payment of Subscriptions';
$body = 'Hello '.$user.'! <br/>
We have paid 100% of your subscriptions earnings from '.$sdate.' To '.$edate.' subscriptions to your main account of earnbuzz. <br/>
<br/>
Total earnings- '.$earning.' $ <br/>
<br/>
Login to earnbuzz and check your balance. <br/>
<br/>
Thanks for using EarnBuzz.In <br/>
<br/>
If you have any query contact us';
mysql_query("INSERT INTO mails (email,subject,body,status) VALUES ('$email','$subject','$body','Pending')");
mysql_query("INSERT INTO notifications (user, news , other, stat)
VALUES ('$user', 'We Have Paid 100% Of Your Subscriptions Earnings From ".$sdate." To ".$edate." Subscriptions.', 'none', 'none')");
mysql_query("INSERT INTO cpspay (user, amount , deduction, month, sdate, edate)
VALUES ('$user', '$earning', '0', '$month,2016', '$sdate', '$edate')");
$newbal=($pubalance+$earning);
mysql_query("UPDATE cpsreport SET status='Paid' WHERE user='$user' AND date BETWEEN '$sdate' AND '$edate'");
mysql_query("UPDATE userdata SET pubalance='$newbal' WHERE username='$user'");
echo '<div class="success">'.$earning.'$ Successfully Paid To User '.$user.'!</div>';
}
else {
dump_error($errors);
}
}
}
echo '<div class="form"><form method="post"Month:<br/><select name="month">
<option value="'.$lastmonth.'" selected="yes">'.$lastmonth.'</option>
<option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select><br/>Start Date:<br/><input type="text" name="sdate" placeholder="YYYY-MM-DD" /><br/>End Date:<br/><input type="text" name="edate" placeholder="YYYY-MM-DD" /><br/>Captcha:<br/><img src="/im'.md5(microtime()).'.jpg"/><br/><input type="text" name="captcha" maxlength="5" /><br/><input type="submit" value="Pay Now"/></form></div>';
}
else {
header('Location:login.php');
}
echo '<div class="page"><a href="index.php">Home</a></div>';
include '../foot.php';
?>