View file public_html/vipadz/unpayinvo.php

<?php

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

headtag("$SiteName - Admin Panel Beta");

if($adminlog==1){
	
	
echo '<div class="title">Unpaid Payments</div>';

$result=mysql_query($sql);

$rowsPerPage = 10;
$pageNum = 1;

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

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

$sql = " SELECT * FROM invoice WHERE status='<font color=\'red\'>Pending</font>' ORDER BY id DESC" . 
         " LIMIT $offset, $rowsPerPage ";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){ 
 $rupees = $rows["amount"]*$dollarrate;

echo '<div class="ad"><b>User</b>: <a href="user.php?id='.$rows["userid"].'">'.$rows["user"].'</a><br/>';
 echo '<b>Method:</b> '.$rows["method"].'<br/>';
if($rows["method"]=='Recharge' || $rows["method"]=='DTH Recharge' || $rows["method"]=='AirtelMoney' || $rows["method"]=='Bank')
{
	echo '<b>Amount</b>: '.$rows["rs"].' Rs<br/>';
}
else if($rows["method"]=='BD Recharge')
{
	echo '<b>Amount</b>: '.$rows["rs"].' Taka<br/>';
}
else
{
	$tax=(10*$rows["amount"]/100*9);
    $total='<b>Amount With Tax</b>: '.$tax.'$<br/>';
	echo '<b>Amount</b>: '.$rows["amount"].'$ ('.$rupees.' Rs)<br/>';
	echo $total;
}
if($rows["method"]=='MoneyBookers' || $rows["method"]=='PayPal')
 {
	 echo '<b>Email:</b> '.$rows["via"].'<br/>';
 }
 else if($rows["method"]=='Recharge')
 {
 echo '<b>Mobile:</b> '.$rows["via"].'<br/>';
 echo '<b>Operator:</b> '.$rows["operator"].'<br/>';
 }
 else if($rows["method"]=='DTH Recharge')
 {
 echo '<b>Subscriber ID:</b> '.$rows["via"].'<br/>';
 echo '<b>Operator:</b> '.$rows["operator"].'<br/>';
 }
 else if($rows["method"]=='AirtelMoney')
 {
 echo '<b>Mobile:</b> '.$rows["via"].'<br/>';
 }
 else if($rows["method"]=='Bank')
 {
 echo '<b>Bank:</b> '.$rows["bankname"].'<br/>';
 echo '<b>Name:</b> '.$rows["name"].'<br/>';
 echo '<b>Acount Number:</b> '.$rows["via"].'<br/>';
 echo '<b>IFSC Code:</b> '.$rows["ifsccode"].'<br/>';
 }
 else if($rows["method"]=='BD Recharge')
 {
 echo '<b>Mobile:</b> '.$rows["via"].'<br/>';
 echo '<b>Operator:</b> '.$rows["operator"].'<br/>';
 }
 echo '<b>Requested On:</b> '.$rows["time"].'<br/>';
 echo '<a href="pay.php?id='.$rows["id"].'">Pay Now</a> - <a href="cancel.php?id='.$rows["id"].'">Cancel Now</a>';
 
if($rows["method"]=='Recharge')
{
echo ' - <a href="fail.php?id='.$rows["id"].'">Fail Now</a>';
}
echo '</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 '<a href="index.php?redir=unpay"><div class="ua">Home</div></a>';

include '../foot.php';

}
else {

header('Location:login.php');
}

?>