Affiliate Index.php:
<?php // $Revision: 2.0.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-statistics.inc.php");
require ("lib-size.inc.php");
require ("lib-zones.inc.php");
// Register input variables
phpAds_registerGlobal ('expand', 'collapse', 'hideinactive', 'listorder', 'orderdirection');
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageHeader("4.2");
phpAds_ShowSections(array("4.1", "4.2", "4.3"));
/*********************************************************/
/* Get preferences */
/*********************************************************/
if (!isset($listorder))
{
if (isset($Session['prefs']['affiliate-index.php']['listorder']))
$listorder = $Session['prefs']['affiliate-index.php']['listorder'];
else
$listorder = '';
}
if (!isset($orderdirection))
{
if (isset($Session['prefs']['affiliate-index.php']['orderdirection']))
$orderdirection = $Session['prefs']['affiliate-index.php']['orderdirection'];
else
$orderdirection = '';
}
if (isset($Session['prefs']['affiliate-index.php']['nodes']))
$node_array = explode (", ", $Session['prefs']['affiliate-index.php']['nodes']);
else
$node_array = array();
/*********************************************************/
/* Main code */
/*********************************************************/
$loosezones = false;
// Get affiliates and build the tree
$res_affiliates = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_affiliates']."
".phpAds_getAffiliateListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
while ($row_affiliates = phpAds_dbFetchArray($res_affiliates))
{
$affiliates[$row_affiliates['affiliateid']] = $row_affiliates;
$affiliates[$row_affiliates['affiliateid']]['expand'] = 0;
$affiliates[$row_affiliates['affiliateid']]['count'] = 0;
}
// Get the zones for each affiliate
$res_zones = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_zones']."
".phpAds_getZoneListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
while ($row_zones = phpAds_dbFetchArray($res_zones))
{
if (isset($affiliates[$row_zones['affiliateid']]))
{
$zones[$row_zones['zoneid']] = $row_zones;
$affiliates[$row_zones['affiliateid']]['count']++;
}
else
$loosezones = true;
}
// Add ID found in expand to expanded nodes
if (isset($expand) && $expand != '')
{
switch ($expand)
{
case 'all' : $node_array = array();
if (isset($affiliates)) foreach (array_keys($affiliates) as $key) $node_array[] = $key;
break;
case 'none': $node_array = array();
break;
default: $node_array[] = $expand;
break;
}
}
$node_array_size = sizeof($node_array);
for ($i=0; $i < $node_array_size; $i++)
{
if (isset($collapse) && $collapse == $node_array[$i])
unset ($node_array[$i]);
else
{
if (isset($affiliates[$node_array[$i]]))
$affiliates[$node_array[$i]]['expand'] = 1;
}
}
// Build Tree
if (isset($zones) && is_array($zones) && count($zones) > 0)
{
// Add banner to campaigns
foreach (array_keys($zones) as $zkey)
{
$affiliates[$zones[$zkey]['affiliateid']]['zones'][$zkey] = $zones[$zkey];
}
unset ($zones);
}
echo "<img src='images/icon-affiliate-new.gif' border='0' align='absmiddle'> ";
echo "<a href='affiliate-edit.php' accesskey=".$keyAddNew.">".$strAddNewAffiliate_Key."</a> ";
phpAds_ShowBreak();
echo "<br><br>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr height='25'>";
echo '<td height="25" width="40%"><b> <a href="affiliate-index.php?listorder=name">'.$GLOBALS['strName'].'</a>';
if (($listorder == "name") || ($listorder == ""))
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="affiliate-index.php?orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="affiliate-index.php?orderdirection=down">';
echo '<img src="images/caret-u.gif" border="0" alt="" title="">';
}
echo '</a>';
}
echo '</b></td>';
echo '<td height="25"><b><a href="affiliate-index.php?listorder=id">'.$GLOBALS['strID'].'</a>';
if ($listorder == "id")
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="affiliate-index.php?orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="affiliate-index.php?orderdirection=down">';
echo '<img src="images/caret-u.gif" border="0" alt="" title="">';
}
echo '</a>';
}
echo '</b> </td>';
echo "<td height='25'> </td>";
echo "<td height='25'> </td>";
echo "<td height='25'> </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
if (!isset($affiliates) || !is_array($affiliates) || count($affiliates) == 0)
{
echo "<tr height='25' bgcolor='#F6F6F6'><td height='25' colspan='5'>";
echo " ".$strNoAffiliates;
echo "</td></tr>";
echo "<td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>";
}
else
{
$i=0;
foreach (array_keys($affiliates) as $key)
{
$affiliate = $affiliates[$key];
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
// Icon & name
echo "<td height='25'>";
if (isset($affiliate['zones']))
{
if ($affiliate['expand'] == '1')
echo " <a href='affiliate-index.php?collapse=".$affiliate['affiliateid']."'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
else
echo " <a href='affiliate-index.php?expand=".$affiliate['affiliateid']."'><img src='images/".$phpAds_TextDirection."/triangle-l.gif' align='absmiddle' border='0'></a> ";
}
else
echo " <img src='images/spacer.gif' height='16' width='16'> ";
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> ";
echo "<a href='affiliate-edit.php?affiliateid=".$affiliate['affiliateid']."'>".$affiliate['name']."</a>";
echo "</td>";
// ID
echo "<td height='25'>".$affiliate['affiliateid']."</td>";
// Button 1
echo "<td height='25'>";
if ($affiliate['expand'] == '1' || !isset($affiliate['zones']))
echo "<a href='zone-edit.php?affiliateid=".$affiliate['affiliateid']."'><img src='images/icon-zone-new.gif' border='0' align='absmiddle' alt='$strCreate'> $strCreate</a> ";
else
echo " ";
echo "</td>";
// Button 2
echo "<td height='25'>";
echo "<a href='affiliate-zones.php?affiliateid=".$affiliate['affiliateid']."'><img src='images/icon-overview.gif' border='0' align='absmiddle' alt='$strOverview'> $strOverview</a> ";
echo "</td>";
// Button 3
echo "<td height='25'>";
echo "<a href='affiliate-delete.php?affiliateid=".$affiliate['affiliateid']."&returnurl=affiliate-index.php'".phpAds_DelConfirm($strConfirmDeleteAffiliate)."><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='$strDelete'> $strDelete</a> ";
echo "</td></tr>";
if (isset($affiliate['zones']) && sizeof ($affiliate['zones']) > 0 && $affiliate['expand'] == '1')
{
$zones = $affiliate['zones'];
foreach (array_keys($zones) as $zkey)
{
// Divider
echo "<tr height='1'>";
echo "<td ".($i%2==0?"bgcolor='#F6F6F6'":"")."><img src='images/spacer.gif' width='1' height='1'></td>";
echo "<td colspan='5' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td>";
echo "</tr>";
// Icon & name
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"")."><td height='25'>";
echo " ";
echo "<img src='images/spacer.gif' height='16' width='16' align='absmiddle'> ";
if ($zones[$zkey]['what'] != '')
{
if ($zones[$zkey]['delivery'] == phpAds_ZoneBanner)
echo "<img src='images/icon-zone.gif' align='absmiddle'> ";
elseif ($zones[$zkey]['delivery'] == phpAds_ZoneInterstitial)
echo "<img src='images/icon-interstitial.gif' align='absmiddle'> ";
elseif ($zones[$zkey]['delivery'] == phpAds_ZonePopup)
echo "<img src='images/icon-popup.gif' align='absmiddle'> ";
elseif ($zones[$zkey]['delivery'] == phpAds_ZoneText)
echo "<img src='images/icon-textzone.gif' align='absmiddle'> ";
}
else
{
if ($zones[$zkey]['delivery'] == phpAds_ZoneBanner)
echo "<img src='images/icon-zone-d.gif' align='absmiddle'> ";
elseif ($zones[$zkey]['delivery'] == phpAds_ZoneInterstitial)
echo "<img src='images/icon-interstitial-d.gif' align='absmiddle'> ";
elseif ($zones[$zkey]['delivery'] == phpAds_ZonePopup)
echo "<img src='images/icon-popup-d.gif' align='absmiddle'> ";
elseif ($zones[$zkey]['delivery'] == phpAds_ZoneText)
echo "<img src='images/icon-textzone-d.gif' align='absmiddle'> ";
}
echo "<a href='zone-edit.php?affiliateid=".$affiliate['affiliateid']."&zoneid=".$zones[$zkey]['zoneid']."'>".$zones[$zkey]['zonename']."</td>";
echo "</td>";
// ID
echo "<td height='25'>".$zones[$zkey]['zoneid']."</td>";
// Button 1
echo "<td height='25'>";
echo " ";
echo "</td>";
// Button 2
echo "<td height='25'>";
echo "<a href='zone-include.php?affiliateid=".$affiliate['affiliateid']."&zoneid=".$zones[$zkey]['zoneid']."'><img src='images/icon-zone-linked.gif' border='0' align='absmiddle' alt='$strIncludedBanners'> $strIncludedBanners</a> ";
echo "</td>";
// Button 3
echo "<td height='25'>";
echo "<a href='zone-delete.php?affiliateid=".$affiliate['affiliateid']."&zoneid=".$zones[$zkey]['zoneid']."&returnurl=affiliate-index.php'".phpAds_DelConfirm($strConfirmDeleteZone)."><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='$strDelete'> $strDelete</a> ";
echo "</td></tr>";
}
}
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$i++;
}
}
if ($loosezones)
{
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
echo "<td height='25'> ";
echo "<img src='images/icon-zone.gif' align='absmiddle'> ";
echo $strZonesWithoutAffiliate."</td>";
echo "<td height='25'> - </td>";
echo "<td height='25' colspan='3'>";
echo "<a href='affiliate-edit.php?move=t'>";
echo "<img src='images/".$phpAds_TextDirection."/icon-update.gif' border='0' align='absmiddle' alt='$strMoveToNewAffiliate'> $strMoveToNewAffiliate</a> ";
echo "</td>";
echo "</tr>";
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
echo "<tr><td height='25' colspan='5' align='".$phpAds_TextAlignRight."'>";
echo "<img src='images/triangle-d.gif' align='absmiddle' border='0'>";
echo " <a href='affiliate-index.php?expand=all' accesskey='".$keyExpandAll."'>".$strExpandAll."</a>";
echo " | ";
echo "<img src='images/".$phpAds_TextDirection."/triangle-l.gif' align='absmiddle' border='0'>";
echo " <a href='affiliate-index.php?expand=none' accesskey='".$keyCollapseAll."'>".$strCollapseAll."</a>";
echo "</td></tr>";
echo "</table>";
echo "<br><br>";
/*********************************************************/
/* Store preferences */
/*********************************************************/
$Session['prefs']['affiliate-index.php']['listorder'] = $listorder;
$Session['prefs']['affiliate-index.php']['orderdirection'] = $orderdirection;
$Session['prefs']['affiliate-index.php']['nodes'] = implode (", ", $node_array);
phpAds_SessionDataStore();
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
