Lib Hourly.inc.php:
<?php // $Revision: 2.0.2.6 $
/************************************************************************/
/* 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();
/*********************************************************/
/* Show hourly statistics */
/*********************************************************/
if ($phpAds_config['compact_stats'])
{
$result = phpAds_dbQuery("
SELECT
hour,
SUM(views) AS views,
SUM(clicks) AS clicks
FROM
".$phpAds_config['tbl_adstats']."
WHERE
day = '".date('Y-m-d', mktime(0, 0, 0, substr($day, 4, 2), substr($day, 6, 2), substr($day, 0, 4)))."'
".(isset($lib_hourly_where) ? 'AND '.$lib_hourly_where : '')."
GROUP BY
hour
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($result))
{
$views[$row['hour']] = $row['views'];
$clicks[$row['hour']] = $row['clicks'];
}
}
else
{
$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)));
$result = phpAds_dbQuery("
SELECT
HOUR(t_stamp) AS hour,
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
hour
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($result))
{
$views[$row['hour']] = $row['qnt'];
}
$result = phpAds_dbQuery("
SELECT
HOUR(t_stamp) AS hour,
COUNT(*) AS qnt
FROM
".$phpAds_config['tbl_adclicks']."
WHERE
t_stamp >= '$begin' AND t_stamp < '$end'
".(isset($lib_hourly_where) ? 'AND '.$lib_hourly_where : '')."
GROUP BY
hour
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($result))
{
$clicks[$row['hour']] = $row['qnt'];
}
}
echo "<br><br>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr bgcolor='#FFFFFF' height='25'>";
echo "<td align='".$phpAds_TextAlignLeft."' nowrap height='25'><b>$strHour</b></td>";
echo "<td align='".$phpAds_TextAlignRight."' width='25%' nowrap height='25'><b>$strViews</b></td>";
echo "<td align='".$phpAds_TextAlignRight."' width='25%' nowrap height='25'><b>$strClicks</b></td>";
echo "<td align='".$phpAds_TextAlignRight."' width='25%' nowrap height='25'><b>$strCTRShort</b> </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$totalviews = 0;
$totalclicks = 0;
for ($i=0; $i<24; $i++)
{
$bgcolor = ($i % 2 ? "#FFFFFF": "#F6F6F6");
if (!isset($views[$i])) $views[$i] = 0;
if (!isset($clicks[$i])) $clicks[$i] = 0;
$totalviews += $views[$i];
$totalclicks += $clicks[$i];
if ($views[$i] || $clicks[$i])
{
$ctr = phpAds_buildCTR($views[$i], $clicks[$i]);
$views[$i] = phpAds_formatNumber($views[$i]);
$clicks[$i] = phpAds_formatNumber($clicks[$i]);
}
else
{
$ctr = '-';
$views[$i] = '-';
$clicks[$i] = '-';
}
$basestamp = mktime ($i, 0, 0, date('m'), date('d'), date('Y'));
echo "<tr>";
echo "<td height='25' bgcolor='$bgcolor'> ";
echo "<img src='images/icon-time.gif' align='absmiddle'> ";
echo strftime ($minute_format, $basestamp)." - ". strftime ($minute_format, $basestamp + (59 * 60));
echo "</td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25' bgcolor='$bgcolor'>".$views[$i]."</td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25' bgcolor='$bgcolor'>".$clicks[$i]."</td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25' bgcolor='$bgcolor'>".$ctr." </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
if ($totalviews > 0 || $totalclicks > 0)
{
echo "<tr>";
echo "<td height='25'> </td>";
echo "<td height='25'> </td>";
echo "<td height='25'> </td>";
echo "<td height='25'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td height='25'> <b>$strTotal</b></td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25'>".phpAds_formatNumber($totalviews)."</td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25'>".phpAds_formatNumber($totalclicks)."</td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25'>".phpAds_buildCTR($totalviews, $totalclicks)." </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr>";
echo "<td height='25'> <b>$strAverage</b></td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25'>".phpAds_formatNumber($totalviews / 24)."</td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25'>".phpAds_formatNumber($totalclicks / 24)."</td>";
echo "<td align='".$phpAds_TextAlignRight."' height='25'> </td>";
echo "</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>";
?>
Other Ad Management Scripts:
