Lib Hourly Hosts.inc.php:
<?php // $Revision: 2.1.2.12 $
/************************************************************************/
/* phpPgAds */
/* ======== */
/* */
/* Copyright (c) 2001-2005 by the phpPgAds developers */
/* For more information visit: http://phppgads.sourceforge.net */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
// Prevent full path disclosure
if (!defined('phpAds_path')) die();
/*********************************************************/
/* Resolve ip to domainname */
/*********************************************************/
if (isset($ip))
{
header("Content-type: application/x-javascript");
while (list(, $v) = each($ip)) {
echo "setTextOfLayer('host".str_replace('.', '_', $v)."', '". <at> gethostbyadd <dot> ($v)."');\n";
}
exit;
}
// Include required files
require (phpAds_path."/libraries/resources/res-iso3166.inc.php");
require (phpAds_path."/libraries/resources/res-continent.inc.php");
/*********************************************************/
/* Show hourly statistics */
/*********************************************************/
$gethostbyaddr = array();
if (!$phpAds_config['compact_stats'])
{
$begin = date('Y-m-d H:i:s', mktime(0, 0, 0, substr($day, 4, 2), substr($day, 6, 2), substr($day, 0, 4)));
$end = date('Y-m-d H:i:s', mktime(0, 0, 0, substr($day, 4, 2), substr($day, 6, 2) + 1, substr($day, 0, 4)));
echo "<br><br>";
echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr><td height='25' colspan='2'> <b>".$strTopHosts."</b></td><td><b>".$strCountry."</b></td>";
echo "<td align='".$phpAds_TextAlignRight."'><b>".$strViews."</b> </td></tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$result = phpAds_dbQuery("
SELECT
host,
country,
COUNT(*) AS qnt,
UNIX_TIMESTAMP(MAX(t_stamp)) AS time
FROM
".$phpAds_config['tbl_adviews']."
WHERE
t_stamp >= '$begin' AND t_stamp < '$end'
".(isset($lib_hourly_where) ? 'AND '.$lib_hourly_where : '')."
GROUP BY
host, country
ORDER BY
qnt DESC
LIMIT 15
") or phpAds_sqlDie();
$i = 0;
while ($row = phpAds_dbFetchArray($result))
{
$bgcolor="#FFFFFF";
$i % 2 ? 0: $bgcolor= "#F6F6F6";
$i++;
if (ereg('[0-9]{1, 3}\.[0-9]{1, 3}\.[0-9]{1, 3}\.[0-9]{1, 3}', $row['host']))
{
$gethostbyaddr[str_replace('.', '_', $row['host'])] = $row['host'];
}
echo "<tr><td height='25' bgcolor='".$bgcolor."'> ";
echo "<img src='images/icon-time.gif' align='absmiddle'> ";
echo strftime($time_format[1], $row['time']);
echo "</td><td height='25' bgcolor='".$bgcolor."' nowrap>";
echo "<span id='host".str_replace('.', '_', $row['host'])."'>".$row['host']."</span>";
echo "</td><td height='25' bgcolor='".$bgcolor."'> ";
if ($flag = ($row["country"] == 'A1' || $row["country"] == 'A2') ? 'unknown' : strtolower($row["country"]))
echo "<img src='images/flags/".$flag.".gif' width='19' height'11'> ";
echo $row["country"] != '' ? $phpAds_ISO3166[$row["country"]] : '-';
echo "</td><td height='25' bgcolor='".$bgcolor."' align='".$phpAds_TextAlignRight."'>";
echo $row["qnt"];
echo " </td></tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
/*
echo "</table>";
echo "<br><br>";
echo "<br><br>";
*/
$begin = date('Y-m-d H:i:s', mktime(0, 0, 0, substr($day, 4, 2), substr($day, 6, 2), substr($day, 0, 4)));
$end = date('Y-m-d H:i:s', mktime(0, 0, 0, substr($day, 4, 2), substr($day, 6, 2) + 1, substr($day, 0, 4)));
//echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr><td><br><br><br><br></td></tr>";
echo "<tr><td height='25' colspan='2'> <b>".$strRecentHosts."</b></td><td><b>".$strCountry."</b></td>";
echo "<td align='".$phpAds_TextAlignRight."'><b>".$strViews."</b> </td></tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$result = phpAds_dbQuery("
SELECT
host,
country,
COUNT(*) AS qnt,
UNIX_TIMESTAMP(MAX(t_stamp)) AS time
FROM
".$phpAds_config['tbl_adviews']."
WHERE
t_stamp >= '$begin' AND t_stamp < '$end'
".(isset($lib_hourly_where) ? 'AND '.$lib_hourly_where : '')."
GROUP BY
host, country
ORDER BY
time DESC
LIMIT 15
") or phpAds_sqlDie();
$i = 0;
while ($row = phpAds_dbFetchArray($result))
{
$bgcolor="#FFFFFF";
$i % 2 ? 0: $bgcolor= "#F6F6F6";
$i++;
if (ereg('[0-9]{1, 3}\.[0-9]{1, 3}\.[0-9]{1, 3}\.[0-9]{1, 3}', $row['host']))
{
$gethostbyaddr[str_replace('.', '_', $row['host'])] = $row['host'];
}
echo "<tr><td height='25' bgcolor='".$bgcolor."'> ";
echo "<img src='images/icon-time.gif' align='absmiddle'> ";
echo strftime($time_format[1], $row['time']);
echo "</td><td height='25' bgcolor='".$bgcolor."' nowrap>";
echo "<span id='host".str_replace('.', '_', $row['host'])."'>".$row['host']."</span>";
echo "</td><td height='25' bgcolor='".$bgcolor."'> ";
if ($flag = ($row["country"] == 'A1' || $row["country"] == 'A2') ? 'unknown' : strtolower($row["country"]))
echo "<img src='images/flags/".$flag.".gif' width='19' height'11'> ";
echo $row["country"] != '' ? $phpAds_ISO3166[$row["country"]] : '-';
echo "</td><td height='25' bgcolor='".$bgcolor."' align='".$phpAds_TextAlignRight."'>";
echo $row["qnt"];
echo " </td></tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
echo "</table>";
echo "<br><br>";
echo "<br><br>";
echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr><td height='25' colspan='1'> <b>".$strTopCountries."</b></td><td><b>".$strContinent."</b></td>";
echo "<td align='".$phpAds_TextAlignRight."'><b>".$strViews."</b> </td></tr>";
echo "<tr><td height='1' colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$result = phpAds_dbQuery("
SELECT
country,
COUNT(*) AS qnt
FROM
".$phpAds_config['tbl_adviews']."
WHERE
t_stamp >= '$begin' AND t_stamp < '$end'
".(isset($lib_hourly_where) ? 'AND '.$lib_hourly_where : '')."
GROUP BY
country
ORDER BY
qnt DESC
LIMIT 15
") or phpAds_sqlDie();
$i = 0;
while ($row = phpAds_dbFetchArray($result))
{
$bgcolor="#FFFFFF";
$i % 2 ? 0: $bgcolor= "#F6F6F6";
$i++;
echo "<tr><td height='25' bgcolor='".$bgcolor."'> ";
echo $row["country"] != '' ? "<img src='images/flags/".strtolower($row["country"]).".gif' width='19' height'11'> ".$phpAds_ISO3166[$row["country"]] : $strUnknown;
echo "</td><td height='25' bgcolor='".$bgcolor."'> ";
echo $row["country"] != '' ? $phpAds_cont_name[$phpAds_continent[$row["country"]]] : '-';
echo "</td><td height='25' bgcolor='".$bgcolor."' align='".$phpAds_TextAlignRight."'>";
echo $row["qnt"];
echo " </td></tr>";
echo "<tr><td height='1' colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
echo "</table>";
echo "<br><br>";
phpAds_PageFooter();
if (count($gethostbyaddr))
{
?>
<script language='JavaScript'>
<!--
function gethostbyaddr() {
document.write ("<script language='JavaScript' src='lib-hourly-hosts.inc.php?ip[]=<?php echo implode ('&ip[]=', $gethostbyaddr); ?>'></script>");
}
gethostbyaddr();
//-->
</script>
<?php
}
exit;
}
?>
Other Ad Management Scripts:
