Untitled

<html>
<head>
<style type="text/css">

body {
    background-color: #f0f0f0;
    color: #2a2a2a;
    font-size: 12px;
    font-family: Georgia, "Times New Roman", Times, serif;
}

</style>
</head>
<body>

<h1>Hotlinkers</h1>
<?

// this is where your sql login details go.
$dbserver = 'localhost';
$dbuser = '';
$dbpass = '';
$dbname = '';

$link = mysql_connect($dbserver, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

// how many rows to show per page
$rowsPerPage = 10;

// 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;

$query = " SELECT DISTINCT referrer FROM HotlinkTracking WHERE referrer != '' ORDER BY date DESC" .
         " LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');

// print the random numbers
while($row = mysql_fetch_array($result))
{
$referal = $row['referrer'];
   echo '<a target="_blank"  href="'.$referal.'"><b>'.$referal.'</b></a><br>';


    $subquery = " SELECT date, image FROM HotlinkTracking WHERE referrer = '$referal' GROUP BY image ORDER BY date DESC";
    $subresult = mysql_query($subquery) or die('Error, query failed');
    while($subrow = mysql_fetch_array($subresult))
    {
       echo $subrow['date'] . ' - <a target="_blank" href="'.$subrow['image'] . '">'.$subrow['image'].'</a><br>';
    }
    echo "<br>";
}


// how many rows we have in database
$query   = "SELECT COUNT(DISTINCT referrer) AS numrows FROM HotlinkTracking";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   }
}

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 < $maxPage)
{
   $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 'Page: '.$first . $prev . $nav . $next . $last;


// ... and we're done!

?>
</body></html>