View file public_html/vipadz/uucreports.php

<?php

/************************************

Script : Adnetwork
Website : http://facebook.com/pranto007

Script is created and provided by Pranto (http://facebook.com/pranto007)
**************************************/
include '../db.php';
include '../functions.php';

headtag("$SiteName - UC User Reports");
$rid=formget("id");
$uid=formget("uid");

if($adminlog==1){

if($_GET["act"]=="del")
{
if($_POST["yes"])

$doit1=mysql_query("DELETE FROM ucreport WHERE id='$rid'");
if($doit1){
   echo '<div class="success">Report Deleted!</div>';
}
echo '<div class="form"><form method="post">
  Do You Really Want To Delete This Report? <br/>
<table><tr><td><input type="submit" name="yes" value="Yes"/></form></td><td><form action="ucreport.php" method="post"><input type="submit" value="No"/></form></td></tr></table></div>';

}
else if($_GET["act"]=="delall") {
if($_POST["yes"])

$doit=mysql_query("DELETE FROM ucreport WHERE user='$uid'");
if($doit){
   echo '<div class="success">All Reports Deleted!</div>';
}

echo '<div class="form"><form method="post">
  Do You Really Want To Delete This User All Reports? <br/>
<table><tr><td><input type="submit" name="yes" value="Yes"/></form></td><td><form action="ucreport.php" method="post"><input type="submit" value="No"/></form></td></tr></table></div>';

}
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);

// how many rows to show per page
$rowsPerPage = 20;
// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

$sql = " SELECT * FROM ucreport WHERE user='$uid' ORDER BY id DESC" . 
         " LIMIT $offset, $rowsPerPage ";
$result=mysql_query($sql);


while($rows=mysql_fetch_array($result)){ // Start looping table row

$userz = mysql_query('SELECT * FROM userdata WHERE username="'.$rows['user'].'"');
$data = mysql_fetch_array($userz);
$userid=$data['id'];
$apps=$rows["apps"]*$appsprice;
$appsindo=$rows["appsindo"]*$appsindoprice;
$appsbd=$rows["appsbd"]*$appsbdprice;
$appspk=$rows["appspk"]*$appspkprice;
$java=$rows["java"]*$javaprice;
$in=$rows["india"]*$indiaprice;
$id=$rows["indo"]*$indoprice;
$bd=$rows["bd"]*$bdprice;
$my=$rows["my"]*$myprice;
$vn=$rows["vn"]*$vnprice;
$br=$rows["br"]*$brprice;
$ru=$rows["ru"]*$ruprice;
$other=$rows["other"]*$otherprice;
$apus=$rows["apus"]*$apusprice;
$mobilemoney=$rows["mobilemoney"]*$mobilemoneyprice;
$hotvideo=$rows["hotvideo"]*$hotvideoprice;
$aliexpress=$rows["aliexpress"]*$aliexpressprice;
$vidmate=$rows["vidmate"]*$vidmateprice;
$phonebooster=$rows["phonebooster"]*$phoneboosterprice;
$money=$apps+$appsindo+$appsbd+$appspk+$java+$in+$id+$bd+$my+$vn+$br+$ru+$other+$apus+$hotvideo+$mobilemoney+$aliexpress+$vidmate+$phonebooster;

  echo '<div class="ua">User: <a href="user.php?id='.$userid.'">'.$rows["user"].'</a><br/>Date: '.$rows["date"].'<br/>9Apps India: '.$rows["apps"].'<br/>9Apps Indonesia: '.$rows["appsindo"].'<br/>9Apps Bangladesh: '.$rows["appsbd"].'<br/>9Apps Pakistan: '.$rows["appspk"].'<br/>Java: '.$rows["java"].'<br/>India: '.$rows["india"].'<br/>Indonesia: '.$rows["indo"].'<br/>Bangladesh: '.$rows["bd"].'<br/>Malaysia: '.$rows["my"].'<br/>Vietnam: '.$rows["vn"].'<br/>Brazil: '.$rows["br"].'<br/>Russia: '.$rows["ru"].'<br/>Others: '.$rows["other"].'<br/>Apus: '.$rows["apus"].'<br/>Hot Video: '.$rows["hotvideo"].'<br/>Mobile Money: '.$rows["mobilemoney"].'<br/>Ali Express: '.$rows["aliexpress"].'<br/>Vidmate: '.$rows["vidmate"].'<br/>Phonebooster: '.$rows["phonebooster"].'<br/>Earning: '.$money.'<br/><a href="?act=del&id='.$rows["id"].'">Delete Report</a></div>';
 }
if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " || <a href=\"$self?page=$page\">Prev</a> || ";

   $first = " <a href=\"$self?page=1\">First Page</a> ";
}

else
{
   $prev  = '&nbsp;'; // we're on page one, don't print previous link
   $first = '&nbsp;'; // nor the first page link
}

if ($pageNum < 1000)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page\">Next</a> ";

   $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
   $next = '&nbsp;'; // we're on the last page, don't print next link
   $last = '&nbsp;'; // nor the last page link
}

// print the navigation link
echo '<div class="ad">'.$first.' '.$prev.' '.$nav.' '.$next.'</div>';
mysql_close();
echo '<div class="ad"><b><a href="?act=delall&uid='.$uid.'"><font align="right" color="red"><center>[Clear All]</center></font></a></b></div>';
 echo '<a href="adducreport.php?id='.$id.'"><div class="ad">Add New Report</div></a>';
 echo '<a href="ucuser.php"><div class="ad">Uc Users</div></a>';
echo '<a href="index.php?redir=unpay"><div class="ua">Home</div></a>';

include '../foot.php';

}
else {

header('Location:/login.php?error=ticket&reason=session');
}

?>