Report Index.php:
<?php // $Revision: 2.0.2.7 $
/************************************************************************/
/* 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-statistics.inc.php");
// Register input variables
phpAds_registerGlobal ('selection');
// Security check
phpAds_checkAccess(phpAds_Admin+phpAds_Client+phpAds_Affiliate);
// Load translations
@include (phpAds_path.'/language/english/report.lang.php');
if ($phpAds_config['language'] != 'english' && file_exists(phpAds_path.'/language/'.$phpAds_config['language'].'/report.lang.php'))
@include (phpAds_path.'/language/'.$phpAds_config['language'].'/report.lang.php');
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageHeader("3");
/*********************************************************/
/* Get plugins list */
/*********************************************************/
function phpAds_ReportPluginList($directory)
{
$pluginDir = opendir ($directory);
while ($pluginFile = readdir ($pluginDir))
{
if (ereg ('^([a-zA-Z0-9\-]*)\.plugin\.php$', $pluginFile, $matches))
{
$plugin = phpAds_ReportGetPluginInfo($directory.$pluginFile);
if (phpAds_isUser ($plugin['plugin-authorize']))
$plugins[$matches[1]] = $plugin;
}
}
closedir ($pluginDir);
return ($plugins);
}
function phpAds_ReportGetPluginInfo($filename)
{
include ($filename);
return ($plugin_info_function());
}
/*********************************************************/
/* Functions to get plugin parameters */
/*********************************************************/
function phpAds_getCampaignArray()
{
global $phpAds_config;
if (phpAds_isUser(phpAds_Client))
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_clients']."
WHERE
parent = ".phpAds_getUserID()."
");
}
else
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_clients']."
WHERE
parent > 0
");
}
while ($row = phpAds_dbFetchArray($res))
$campaignArray[$row['clientid']] = phpAds_buildClientName ($row['clientid'], $row['clientname']);
return ($campaignArray);
}
function phpAds_getClientArray()
{
global $phpAds_config;
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_clients']."
WHERE
parent IS NULL
");
while ($row = phpAds_dbFetchArray($res))
$clientArray[$row['clientid']] = phpAds_buildClientName ($row['clientid'], $row['clientname']);
return ($clientArray);
}
function phpAds_getZoneArray()
{
global $phpAds_config;
if (phpAds_isUser(phpAds_Affiliate))
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_zones']."
WHERE
affiliateid = ".phpAds_getUserID()."
");
}
else
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_zones']."
");
}
while ($row = phpAds_dbFetchArray($res))
$zoneArray[$row['zoneid']] = phpAds_buildClientName ($row['zoneid'], $row['zonename']);
return ($zoneArray);
}
function phpAds_getAffiliateArray()
{
global $phpAds_config;
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_affiliates']."
");
while ($row = phpAds_dbFetchArray($res))
$affiliateArray[$row['affiliateid']] = phpAds_buildAffiliateName ($row['affiliateid'], $row['name']);
return ($affiliateArray);
}
/*********************************************************/
/* Main code */
/*********************************************************/
$tabindex = 1;
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25' colspan='2'><b>".$strSelectReport."</b></td></tr>";
//echo "<tr height='1'><td colspan='2' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<form name='report_selection' action='report-index.php'>";
echo "<tr><td height='35' colspan='2'>";
echo "<select name='selection' onChange='this.form.submit();' accesskey='".$keyList."' tabindex='".($tabindex++)."'>";
$plugins = phpAds_ReportPluginList ("report-plugins/");
if (!isset($selection) || $selection == '')
{
reset($plugins);
$selection = key($plugins);
}
foreach (array_keys($plugins) as $key)
{
echo "<option value='".$key."' ".($selection==$key?"selected":"").">".$plugins[$key]['plugin-name']."</option>";
}
echo "</select>";
echo " <a href='javascript:document.report_selection.submit();'><img src='images/".$phpAds_TextDirection."/go_blue.gif' border='0'></a>";
echo "</td></tr>";
echo "</form>";
echo "</table>";
phpAds_ShowBreak();
echo "<br><br>";
$plugin = $plugins[$selection];
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25' colspan='3'>";
if ($plugin['plugin-export'] == 'csv')
echo "<img src='images/excel.gif' align='absmiddle'> ";
echo "<b>".$plugin['plugin-name']."</b></td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td height='25' colspan='2'>";
echo nl2br($plugin['plugin-description']);
echo "</td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
if ($fields = $plugin['plugin-import'])
{
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<form action='report-execute.php' method='get'>";
$enabled = true;
foreach (array_keys($fields) as $key)
{
// Text field
if ($fields[$key]['type'] == 'edit')
{
echo "<tr><td width='30'> </td>";
echo "<td width='200'>".$fields[$key]['title']."</td>";
echo "<td width='370'><input type='text' name='".$key."' size='";
echo isset($fields[$key]['size']) ? $fields[$key]['size'] : "";
echo "' value='";
echo isset($fields[$key]['default']) ? $fields[$key]['default'] : "";
echo "' tabindex='".($tabindex++)."'></td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
// Delimiter
elseif ($fields[$key]['type'] == 'delimiter')
{
echo "<tr><td width='30'> </td>";
echo "<td width='200'>".$fields[$key]['title']."</td>";
echo "<td width='370'>";
echo "<select name='".$key."'>";
echo "<option value='t'>Tab</option>";
echo "<option value=', '>, </option>";
echo "<option value=';'>;</option>";
echo "</select>";
echo "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
// Quotes
elseif ($fields[$key]['type'] == 'quotes')
{
echo "<tr><td width='30'> </td>";
echo "<td width='200'>".$fields[$key]['title']."</td>";
echo "<td width='370'>";
echo "<select name='".$key."'>";
echo "<option value=''>".$strNone."</option>";
echo "<option value='1'>'</option>";
echo "<option value='2'>\"</option>";
echo "</select>";
echo "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
// CampaignID-dropdown
elseif ($fields[$key]['type'] == 'campaignid-dropdown')
{
echo "<tr><td width='30'> </td>";
echo "<td width='200'>".$fields[$key]['title']."</td>";
echo "<td width='370'><select name='".$key."' tabindex='".($tabindex++)."'>";
$campaignArray = phpAds_getCampaignArray();
if (count($campaignArray))
foreach (array_keys($campaignArray) as $ckey)
echo "<option value='".$ckey."'>".$campaignArray[$ckey]."</option>";
else
{
echo "<option value=''>".$strNone."</option>";
$enabled = false;
}
echo "</select></td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
// ClientID-dropdown
elseif ($fields[$key]['type'] == 'clientid-dropdown')
{
if (phpAds_isUser(phpAds_Client))
{
echo "<input type='hidden' name='".$key."' value='".phpAds_getUserID()."'>";
}
else
{
echo "<tr><td width='30'> </td>";
echo "<td width='200'>".$fields[$key]['title']."</td>";
echo "<td width='370'><select name='".$key."' tabindex='".($tabindex++)."'>";
$clientArray = phpAds_getClientArray();
if (count($clientArray))
foreach (array_keys($clientArray) as $ckey)
echo "<option value='".$ckey."'>".$clientArray[$ckey]."</option>";
else
{
echo "<option value=''>".$strNone."</option>";
$enabled = false;
}
echo "</select></td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
}
// AffiliateID-dropdown
elseif ($fields[$key]['type'] == 'affiliateid-dropdown')
{
if (phpAds_isUser(phpAds_Affiliate))
{
echo "<input type='hidden' name='".$key."' value='".phpAds_getUserID()."'>";
}
else
{
echo "<tr><td width='30'> </td>";
echo "<td width='200'>".$fields[$key]['title']."</td>";
echo "<td width='370'><select name='".$key."' tabindex='".($tabindex++)."'>";
$affiliateArray = phpAds_getAffiliateArray();
if (count($affiliateArray))
foreach (array_keys($affiliateArray) as $ckey)
echo "<option value='".$ckey."'>".$affiliateArray[$ckey]."</option>";
else
{
echo "<option value=''>".$strNone."</option>";
$enabled = false;
}
echo "</select></td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
}
// ZoneID-dropdown
elseif ($fields[$key]['type'] == 'zoneid-dropdown')
{
echo "<tr><td width='30'> </td>";
echo "<td width='200'>".$fields[$key]['title']."</td>";
echo "<td width='370'><select name='".$key."' tabindex='".($tabindex++)."'>";
$zoneArray = phpAds_getZoneArray();
if (count($zoneArray))
foreach (array_keys($zoneArray) as $ckey)
echo "<option value='".$ckey."'>".$zoneArray[$ckey]."</option>";
else
{
echo "<option value=''>".$strNone."</option>";
$enabled = false;
}
echo "</select></td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
}
echo "<tr><td height='25' colspan='3'>";
echo "<br><br>";
echo "<input type='hidden' name='plugin' value='".$selection."'>";
echo "<input type='submit' value='".$strGenerate."' tabindex='".($tabindex++)."'".($enabled ? '' : ' disabled').">";
echo "</td></tr>";
echo "</form>";
}
echo "</table>";
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
