View file public_html/vipadz/cpspayments.php

<?php

include '../db.php';
include '../functions.php';

headtag("$SiteName - Subscriptions Payments");

if($adminlog==1){

$user=formget("user");

if(empty($user))
{
echo '<div class="title">Subscriptions Payments</div>';
}
else
{
echo '<div class="title">Subscriptions Payments Of <font color="red">'.$user.'</font></div>';
}

$result=mysql_query($sql);
$rowsPerPage = 10;
$pageNum = 1;

if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}

$offset = ($pageNum - 1) * $rowsPerPage;

if(empty($user))
{
$sql = " SELECT * FROM cpspay ORDER BY id DESC" . 
         " LIMIT $offset, $rowsPerPage ";
}
else
{
$sql = " SELECT * FROM cpspay WHERE user='$user' ORDER BY id DESC" . 
         " LIMIT $offset, $rowsPerPage ";
}
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){

echo '<div class="ua">User: '.$rows["user"].'<br/>';
echo 'Amount: '.$rows["amount"].'$<br/>';
echo 'Deduction: '.$rows["deduction"].'%<br/>';
if(!empty($rows["reason"]))
{
echo 'Reason: '.$rows["reason"].'<br/>';
}
echo 'Period: '.$rows["month"].'<br/>';
echo 'From: '.$rows["sdate"].'<br/>';
echo 'To: '.$rows["edate"].'<br/></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;';
   $first = '&nbsp;';
}

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;';
   $last = '&nbsp;';
}

// print the navigation link
echo '<div class="ad">'.$first.' '.$prev.' '.$nav.' '.$next.'</div>';
mysql_close();
 echo '<a href="index.php"><div class="ua">Home</div></a>';
 include '../foot.php';

}
else {
header('Location:login.php');
}
?>