Maintenance Priority.php:
<?php // $Revision: 2.1.2.5 $
/************************************************************************/
/* 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. */
/************************************************************************/
// Include required files
require ("config.php");
require ("lib-maintenance.inc.php");
require ("lib-statistics.inc.php");
require ("lib-zones.inc.php");
require ("../libraries/lib-priority.inc.php");
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageHeader("5.3");
phpAds_ShowSections(array("5.1", "5.3", "5.4", "5.2"));
phpAds_MaintenanceSelection("priority");
/*********************************************************/
/* Main code */
/*********************************************************/
function phpAds_showBanners ()
{
global $phpAds_config;
global $strUntitled, $strName, $strID, $strWeight;
global $strProbability, $strPriority, $strRecalculatePriority;
global $phpAds_TextDirection;
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_banners']."
ORDER BY
priority DESC
");
$rows = array();
$prioritysum = 0;
while ($tmprow = phpAds_dbFetchArray($res))
{
if ($tmprow['priority'])
{
$prioritysum += $tmprow['priority'];
$rows[$tmprow['bannerid']] = $tmprow;
}
}
if (is_array($rows))
{
$i=0;
// Header
echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr height='25'>";
echo "<td height='25'><b> ".$strName."</b></td>";
echo "<td height='25'><b>".$strID." </b></td>";
echo "<td height='25'><b>".$strPriority."</b></td>";
echo "<td height='25'><b>".$strProbability."</b></td>";
echo "</tr>";
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
// Banners
foreach (array_keys($rows) as $key)
{
$name = phpAds_getBannerName ($rows[$key]['bannerid'], 60, false);
if ($i > 0) echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td></tr>";
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
echo "<td height='25'>";
echo " ";
// Banner icon
if ($rows[$key]['storagetype'] == 'html')
echo "<img src='images/icon-banner-html.gif' align='absmiddle'> ";
elseif ($rows[$key]['storagetype'] == 'url')
echo "<img src='images/icon-banner-url.gif' align='absmiddle'> ";
else
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> ";
// Name
echo $name;
echo "</td>";
echo "<td height='25'>".$rows[$key]['bannerid']."</td>";
echo "<td height='25'>".$rows[$key]['priority']."</td>";
echo "<td height='25'>".number_format($rows[$key]['priority'] / $prioritysum * 100, $phpAds_config['percentage_decimals'])."%</td>";
echo "</tr>";
$i++;
}
// Footer
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
}
}
/*********************************************************/
/* Main code */
/*********************************************************/
echo "<br>";
// Extra campaign info
$res = phpAds_dbQuery("SELECT COUNT(*) AS count, SUM(target) AS sum_target FROM ".$phpAds_config['tbl_clients']." WHERE parent > 0 AND target > 0");
$campaigns_count = phpAds_dbResult($res, 0, 'count');
$campaigns_target = phpAds_dbResult($res, 0, 'sum_target');
$res = phpAds_dbQuery("SELECT COUNT(*) AS campaigns FROM ".$phpAds_config['tbl_clients']." WHERE parent > 0 AND weight > 0");
$campaigns_weight = phpAds_dbResult($res, 0, 'campaigns');
// Get the number of days running
if ($phpAds_config['compact_stats'])
{
$res = phpAds_dbQuery("SELECT UNIX_TIMESTAMP(day) AS days_running FROM ".$phpAds_config['tbl_adstats']." ORDER BY day LIMIT 1");
$days_running = phpAds_dbResult($res, 0, 'days_running');
}
else
{
$res = phpAds_dbQuery("SELECT UNIX_TIMESTAMP(t_stamp) AS days_running FROM ".$phpAds_config['tbl_adviews']." ORDER BY t_stamp LIMIT 1");
$days_running = phpAds_dbResult($res, 0, 'days_running');
}
if ($days_running > 0)
{
$days_running = mktime (0, 0, 0, date('m'), date('d'), date('Y')) - $days_running;
$days_running = round ($days_running / (60 * 60 * 24)) - 1;
}
else
$days_running = 0;
if ($days_running >= 2)
{
echo str_replace ("{days}", $days_running, $strPriorityDaysRunning);
if ($days_running >= 8)
echo $strPriorityBasedLastWeek;
if ($days_running >= 2 && $days_running < 8)
echo $strPriorityBasedLastDays;
if ($days_running == 1)
echo $strPriorityBasedYesterday;
}
else
echo $strPriorityNoData;
$banners = phpAds_PriorityPrepareBanners();
$campaigns = phpAds_PriorityPrepareCampaigns();
$profile = array();
list($profile, $profile_correction_executed) = phpAds_PriorityPredictProfile($campaigns, $banners, $profile);
$estimated_hits = 0;
for ($p=0; $p<24; $p++)
{
$estimated_hits += $profile[$p];
}
if ($campaigns_target)
{
if ($estimated_hits > $campaigns_target)
echo $strPriorityEnoughAdViews;
else
echo $strPriorityNotEnoughAdViews;
}
else
$campaigns_target = 0;
// Show recalculate button
echo "<br><br>";
phpAds_ShowBreak();
echo "<img src='images/".$phpAds_TextDirection."/icon-undo.gif' border='0' align='absmiddle'> <a href='maintenance-priority-calculate.php'>$strRecalculatePriority</a> ";
phpAds_ShowBreak();
// Show banners
echo "<br><br>";
phpAds_showBanners();
echo "<br><br>";
echo "<br><br>";
echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr height='25'>";
echo "<td height='25'> <b>".$strOverall."</b></td>";
echo "<td height='25'> </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='2' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr height='25'>";
echo "<td height='25'> ".$strHighPriorityCampaigns.": <b>".$campaigns_count."</b></td>";
echo "<td height='25'>".$strAdViewsAssigned.": <b>".$campaigns_target."</b></td>";
echo "</tr>";
echo "<tr height='1'><td colspan='2' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td></tr>";
echo "<tr height='25'>";
echo "<td height='25'> ".$strLowPriorityCampaigns.": <b>".$campaigns_weight."</b></td>";
echo "<td height='25'> </td>";
echo "</tr>";
if ($campaigns_target > 0)
{
echo "<tr height='1'><td colspan='2' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td></tr>";
echo "<tr height='25'>";
echo "<td height='25'> ".$strPredictedAdViews.": <b>".$estimated_hits."</b></td>";
echo "<td height='25'> </td>";
echo "</tr>";
}
echo "<tr height='1'><td colspan='2' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
echo "<br><br>";
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
