phpAds_PageContext(phpAds_buildClientName($row['clientid'], $row['clientname']), "campaign-edit.php?clientid=" . $clientid . "&campaignid=" . $row['clientid'], $campaignid == $row['clientid']); } phpAds_PageShortcut($strClientProperties, 'client-edit.php?clientid=' . $clientid, 'images/icon-client.gif'); phpAds_PageShortcut($strCampaignHistory, 'stats-campaign-history.php?clientid=' . $clientid . '&campaignid=' . $campaignid, 'images/icon-statistics.gif'); $extra = "<form action='campaign-modify.php'>"; $extra .= "<input type='hidden' name='campaignid' value='{$campaignid}'>"; $extra .= "<input type='hidden' name='clientid' value='{$clientid}'>"; $extra .= "<input type='hidden' name='returnurl' value='campaign-edit.php'>"; $extra .= "<br><br>"; $extra .= "<b>{$strModifyCampaign}</b><br>"; $extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>"; $extra .= "<img src='images/icon-move-campaign.gif' align='absmiddle'> {$strMoveTo}<br>"; $extra .= "<img src='images/spacer.gif' height='1' width='160' vspace='2'><br>"; $extra .= " "; $extra .= "<select name='moveto' style='width: 110px'>"; $res = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_clients'] . " WHERE parent = 0 AND clientid != " . phpAds_getParentID($campaignid)) or phpAds_sqlDie(); while ($row = phpAds_dbFetchArray($res)) { $extra .= "<option value='" . $row['clientid'] . "'>" . phpAds_buildClientName($row['clientid'], $row['clientname']) . "</option>"; } $extra .= "</select> <input type='image' src='images/" . $phpAds_TextDirection . "/go_blue.gif'><br>"; $extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>"; $extra .= "<img src='images/icon-recycle.gif' align='absmiddle'> <a href='campaign-delete.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&returnurl=client-index.php'" . phpAds_DelConfirm($strConfirmDeleteCampaign) . ">{$strDelete}</a><br>"; $extra .= "</form>"; phpAds_PageHeader("4.1.3.2", $extra); echo "<img src='images/icon-client.gif' align='absmiddle'> " . phpAds_getParentName($campaignid); echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> "; echo "<img src='images/icon-campaign.gif' align='absmiddle'> <b>" . phpAds_getClientName($campaignid) . "</b><br><br><br>"; phpAds_ShowSections(array("4.1.3.2", "4.1.3.3", "4.1.3.4")); } else { if (isset($move) && $move == 't') { // Convert client to campaign
phpAds_checkAccess(phpAds_Admin + phpAds_Client); /*********************************************************/ /* HTML framework */ /*********************************************************/ if (isset($Session['prefs']['stats-client-campaigns.php']['listorder'])) { $navorder = $Session['prefs']['stats-client-campaigns.php']['listorder']; } else { $navorder = ''; } if (isset($Session['prefs']['stats-client-campaigns.php']['orderdirection'])) { $navdirection = $Session['prefs']['stats-client-campaigns.php']['orderdirection']; } else { $navdirection = ''; } if (phpAds_isUser(phpAds_Client)) { if (phpAds_getUserID() == phpAds_getParentID($campaignid)) { $res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\t\tWHERE\n\t\t\t\tparent = " . phpAds_getUserID() . "\n\t\t\t" . phpAds_getListOrder($navorder, $navdirection) . "\n\t\t") or phpAds_sqlDie(); while ($row = phpAds_dbFetchArray($res)) { phpAds_PageContext(phpAds_buildClientName($row['clientid'], $row['clientname']), "stats-campaign-target.php?clientid=" . $clientid . "&campaignid=" . $row['clientid'], $campaignid == $row['clientid']); } phpAds_PageHeader("1.2.3"); echo "<img src='images/icon-campaign.gif' align='absmiddle'> <b>" . phpAds_getClientName($campaignid) . "</b><br><br><br>"; phpAds_ShowSections(array("1.2.1", "1.2.2", "1.2.3")); } else { phpAds_PageHeader("1"); phpAds_Die($strAccessDenied, $strNotAdmin); } } if (phpAds_isUser(phpAds_Admin)) { $res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE\n\t\t\tparent = " . $clientid . "\n\t\t" . phpAds_getListOrder($navorder, $navdirection) . "\n\t") or phpAds_sqlDie(); while ($row = phpAds_dbFetchArray($res)) {
phpAds_registerGlobal('value'); // Security check phpAds_checkAccess(phpAds_Admin + phpAds_Client); /*********************************************************/ /* Main code */ /*********************************************************/ if ($value == "t") { $value = "f"; } else { $value = "t"; } if (phpAds_isUser(phpAds_Client)) { if ($value == 'f' && phpAds_isAllowed(phpAds_DisableBanner) || $value == 't' && phpAds_isAllowed(phpAds_ActivateBanner)) { $result = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\tclientid\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\tWHERE\n\t\t\t\tbannerid = '{$bannerid}'\n\t\t\t") or phpAds_sqlDie(); $row = phpAds_dbFetchArray($result); if ($row["clientid"] == '' || phpAds_getUserID() != phpAds_getParentID($row["clientid"])) { phpAds_PageHeader("1"); phpAds_Die($strAccessDenied, $strNotAdmin); } else { $campaignid = $row["clientid"]; $res = phpAds_dbQuery("\n\t\t\t\tUPDATE\n\t\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\t\tSET\n\t\t\t\t\tactive = '{$value}'\n\t\t\t\tWHERE\n\t\t\t\t\tbannerid = '{$bannerid}'\n\t\t\t\t") or phpAds_sqlDie(); // Rebuild priorities phpAds_PriorityCalculate(); // Rebuild cache if (!defined('LIBVIEWCACHE_INCLUDED')) { include phpAds_path . '/libraries/deliverycache/cache-' . $phpAds_config['delivery_caching'] . '.inc.php'; } phpAds_cacheDelete(); Header("Location: stats-campaign-banners.php?clientid=" . $clientid . "&campaignid=" . $campaignid); } } else {
/*********************************************************/ /* Main code */ /*********************************************************/ if (isset($bannerid) && $bannerid != '') { if (isset($moveto_x) && $moveto != '') { // Move the banner $res = phpAds_dbQuery("UPDATE " . $phpAds_config['tbl_banners'] . " SET clientid = '" . $moveto . "' WHERE bannerid = '" . $bannerid . "'") or phpAds_sqlDie(); // Rebuild priorities phpAds_PriorityCalculate(); // Rebuild cache if (!defined('LIBVIEWCACHE_INCLUDED')) { include phpAds_path . '/libraries/deliverycache/cache-' . $phpAds_config['delivery_caching'] . '.inc.php'; } phpAds_cacheDelete(); // Get new clientid $clientid = phpAds_getParentID($moveto); if (strpos($returnurl, "\r\n") === false) { $url = stripslashes($returnurl); header("Location: " . $returnurl . "?clientid=" . $clientid . "&campaignid=" . $moveto . "&bannerid=" . $bannerid); } } elseif (isset($applyto_x) && $applyto != '') { // Apply display limitation to // Delete old limitations $res = phpAds_dbQuery("\n\t\t\tDELETE FROM\n\t\t\t\t" . $phpAds_config['tbl_acls'] . "\n\t\t\tWHERE\n\t\t\t\tbannerid = " . $applyto . "\n\t\t") or phpAds_sqlDie(); // Load source limitation $res = phpAds_dbQuery("\n\t\t SELECT\n\t \t *\n\t \t FROM\n\t \t " . $phpAds_config['tbl_acls'] . "\n\t \t WHERE\n\t \t bannerid = '" . $bannerid . "'\n \t ") or phpAds_sqlDie(); while ($row = phpAds_dbFetchArray($res)) { $values_fields = ''; $values = ''; $row['bannerid'] = $applyto; while (list($name, $value) = each($row)) {
echo "<img src='images/icon-banner-url.gif' align='absmiddle'> "; } else { echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> "; } echo "<a href='JavaScript:GoOpener(\"banner-edit.php?clientid=" . phpAds_getParentID($row_banners['clientid']) . "&campaignid=" . $row_banners['clientid'] . "&bannerid=" . $row_banners['bannerid'] . "\")'>" . $name . "</a>"; echo "</td>"; echo "<td height='25'>" . $row_banners['bannerid'] . "</td>"; // Empty echo "<td> </td>"; // Button 1 echo "<td height='25'>"; echo "<a href='JavaScript:GoOpener(\"banner-acl.php?clientid=" . phpAds_getParentID($row_banners['clientid']) . "&campaignid=" . $row_banners['clientid'] . "&bannerid=" . $row_banners['bannerid'] . "\")'><img src='images/icon-acl.gif' border='0' align='absmiddle' alt='{$strACL}'> {$strACL}</a> "; echo "</td>"; // Button 2 echo "<td height='25'>"; echo "<a href='JavaScript:GoOpener(\"banner-delete.php?clientid=" . phpAds_getParentID($row_banners['clientid']) . "&campaignid=" . $row_banners['clientid'] . "&bannerid=" . $row_banners['bannerid'] . "\", true)'" . phpAds_DelConfirm($strConfirmDeleteBanner) . "><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='{$strDelete}'> {$strDelete}</a> "; echo "</td></tr>"; $i++; } } if ($affiliate && phpAds_dbNumRows($res_affiliates) > 0) { while ($row_affiliates = phpAds_dbFetchArray($res_affiliates)) { $name = $row_affiliates['name']; $name = phpAds_breakString($name, '30'); 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 " "; echo "<img src='images/icon-affiliate.gif' align='absmiddle'> ";
function phpAds_showZoneBanners($zoneid) { global $phpAds_config, $phpAds_TextDirection; global $strUntitled, $strName, $strID, $strWeight, $strShowBanner; global $strCampaignWeight, $strBannerWeight, $strProbability, $phpAds_TextAlignRight; global $strRawQueryString, $strZoneProbListChain, $strZoneProbNullPri, $strZoneProbListChainLoop; $zonechain = array(); $what = ''; $infinite_loop = false; while ($zoneid || $what) { if ($zoneid) { // Get zone $zoneres = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_zones'] . " WHERE zoneid='{$zoneid}' "); if (phpAds_dbNumRows($zoneres) > 0) { $zone = phpAds_dbFetchArray($zoneres); // Set what parameter to zone settings if (isset($zone['what']) && $zone['what'] != '') { $what = $zone['what']; } else { $what = 'default'; } } else { $what = ''; } $precondition = ''; // Size preconditions if ($zone['width'] > -1) { $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".width = " . $zone['width'] . " "; } if ($zone['height'] > -1) { $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".height = " . $zone['height'] . " "; } // Text Ads preconditions if ($zone['delivery'] == phpAds_ZoneText) { $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".storagetype = 'txt' "; } else { $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".storagetype <> 'txt' "; } if (!defined('LIBVIEWQUERY_INCLUDED')) { include phpAds_path . '/libraries/lib-view-query.inc.php'; } $select = phpAds_buildQuery($what, false, $precondition); } else { // Direct selection if (!defined('LIBVIEWQUERY_INCLUDED')) { include phpAds_path . '/libraries/lib-view-query.inc.php'; } $select = phpAds_buildQuery($what, false, ''); $zone = array('what' => $what); } // Include bannertext in query $select = str_replace('SELECT', 'SELECT ' . $phpAds_config['tbl_banners'] . '.bannertext as bannertext,', $select); // Execute query $res = phpAds_dbQuery($select); $rows = array(); $prioritysum = 0; while ($tmprow = phpAds_dbFetchArray($res)) { // weight of 0 disables the banner if ($tmprow['priority']) { $prioritysum += $tmprow['priority']; $rows[$tmprow['bannerid']] = $tmprow; } } if (!count($rows) && isset($zone['chain']) && strlen($zone['chain'])) { // Follow the chain if no banner was found if (ereg('^zone:([0-9]+)$', $zone['chain'], $match)) { // Zone chain $zoneid = $match[1]; $what = ''; } else { // Raw querystring chain $zoneid = 0; $what = $zone['chain']; } if (in_array($zone, $zonechain)) { // Chain already evaluated, exit $zoneid = 0; $what = ''; $infinite_loop = true; } else { $zonechain[] = $zone; } } else { // No chain settings, exit loop $zoneid = 0; $what = ''; } } if (isset($rows) && is_array($rows)) { $i = 0; if (count($zonechain)) { // Zone Chain echo "<br><br><div class='errormessage'><img class='errormessage' src='images/info.gif' width='16' height='16' border='0' align='absmiddle'>"; echo $infinite_loop ? $strZoneProbListChainLoop : $strZoneProbListChain; echo "<br><img src='images/break-el.gif' height='1' width='100%' vspace='6'><br>"; // echo "</div>"; /* echo "<br><br><table width='100% border='0' align='center' cellspacing='0' cellpadding='0'>"; echo "<tr><td valign='top'><img src='images/info.gif' align='absmiddle'> </td>"; echo "<td width='100%'><b>".($infinite_loop ? $strZoneProbListChainLoop : $strZoneProbListChain)."</b></td></tr>"; echo "</table>"; phpAds_ShowBreak(); */ while (list(, $z) = each($zonechain)) { echo "<nobr><img src='images/icon-zone-d.gif' align='absmiddle'> " . phpAds_buildZoneName($z['zoneid'], $z['zonename']); echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'></nobr> "; } if (isset($zone['zoneid'])) { echo "<nobr><img src='images/" . ($infinite_loop ? 'errormessage.gif' : 'icon-zone.gif') . "' align='absmiddle'> <b>" . phpAds_buildZoneName($zone['zoneid'], $zone['zonename']) . "</b></nobr><br>"; } else { echo "<nobr><img src='images/icon-generatecode.gif' align='absmiddle'> <b>" . $GLOBALS['strRawQueryString'] . ":</b> " . htmlentities($zone['what']) . "</nobr><br>"; } echo "</div>"; } // Header echo "<br><br>"; echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>"; echo "<tr height='25'>"; echo "<td height='25' width='40%'><b> " . $strName . "</b></td>"; echo "<td height='25'><b>" . $strID . " </b></td>"; echo "<td height='25'><b>" . $strProbability . "</b></td>"; echo "<td height='25' align='" . $phpAds_TextAlignRight . "'> </td>"; echo "</tr>"; echo "<tr height='1'><td colspan='4' 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='4' 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'] == 'txt') { echo "<img src='images/icon-banner-text.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 if (phpAds_isUser(phpAds_Admin)) { echo "<a href='banner-edit.php?clientid=" . phpAds_getParentID($rows[$key]['clientid']) . "&campaignid=" . $rows[$key]['clientid'] . "&bannerid=" . $rows[$key]['bannerid'] . "'>" . $name . "</a>"; } else { echo $name; } echo "</td>"; echo "<td height='25'>" . $rows[$key]['bannerid'] . "</td>"; echo "<td height='25'>" . number_format($rows[$key]['priority'] / $prioritysum * 100, $phpAds_config['percentage_decimals']) . "%</td>"; // Show banner if ($rows[$key]['contenttype'] == 'txt') { $width = 300; $height = 200; } else { $width = $rows[$key]['width'] + 64; $height = $rows[$key]['bannertext'] ? $rows[$key]['height'] + 90 : $rows[$key]['height'] + 64; } echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>"; echo "<a href='banner-htmlpreview.php?bannerid=" . $rows[$key]['bannerid'] . "' target='_new' "; echo "onClick=\"return openWindow('banner-htmlpreview.php?bannerid=" . $rows[$key]['bannerid'] . "', '', 'status=no,scrollbars=no,resizable=no,width=" . $width . ",height=" . $height . "');\">"; echo "<img src='images/icon-zoom.gif' align='absmiddle' border='0'> " . $strShowBanner . "</a> "; echo "</td>"; echo "</tr>"; $i++; } if (!$i) { echo "<tr height='25' bgcolor='#F6F6F6'>"; echo "<td colspan='4'> " . $strZoneProbNullPri . "</td>"; echo "</tr>"; } // Footer echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>"; echo "</table>"; } }