$node_array = array(); } /*********************************************************/ /* HTML framework */ /*********************************************************/ if (isset($Session['prefs']['stats-campaign-banners.php']['listorder'])) { $navorder = $Session['prefs']['stats-campaign-banners.php']['listorder']; } else { $navorder = ''; } if (isset($Session['prefs']['stats-campaign-banners.php']['orderdirection'])) { $navdirection = $Session['prefs']['stats-campaign-banners.php']['orderdirection']; } else { $navdirection = ''; } $res = phpAds_dbQuery("\n\tSELECT\n\t\t*\n\tFROM\n\t\t" . $phpAds_config['tbl_banners'] . "\n\tWHERE\n\t\tclientid = '{$campaignid}'\n\t" . phpAds_getBannerListOrder($navorder, $navdirection) . "\n") or phpAds_sqlDie(); while ($row = phpAds_dbFetchArray($res)) { phpAds_PageContext(phpAds_buildBannerName($row['bannerid'], $row['description'], $row['alt']), "stats-banner-affiliates.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&bannerid=" . $row['bannerid'], $bannerid == $row['bannerid']); } phpAds_PageShortcut($strClientProperties, 'client-edit.php?clientid=' . $clientid, 'images/icon-client.gif'); phpAds_PageShortcut($strCampaignProperties, 'campaign-edit.php?clientid=' . $clientid . '&campaignid=' . $campaignid, 'images/icon-campaign.gif'); phpAds_PageShortcut($strBannerProperties, 'banner-edit.php?clientid=' . $clientid . '&campaignid=' . $campaignid . '&bannerid=' . $bannerid, 'images/icon-banner-stored.gif'); phpAds_PageShortcut($strModifyBannerAcl, 'banner-acl.php?clientid=' . $clientid . '&campaignid=' . $campaignid . '&bannerid=' . $bannerid, 'images/icon-acl.gif'); phpAds_PageHeader("2.1.2.2.2"); 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'> " . phpAds_getClientName($campaignid); echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> "; echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br>"; echo phpAds_buildBannerCode($bannerid) . "<br><br><br><br>"; phpAds_ShowSections(array("2.1.2.2.1", "2.1.2.2.2"));
$limit = " AND day >= " . date('Ymd', $timestamp); break; case 'm': $timestamp = mktime(0, 0, 0, date('m'), 1, date('Y')); $limit = " AND day >= " . date('Ymd', $timestamp); break; default: $limit = ''; $period = ''; break; } // Get the banners for each campaign if (phpAds_isUser(phpAds_Admin)) { $query = "SELECT bannerid" . ",campaignid" . ",alt" . ",description" . ",active" . ",storagetype" . " FROM " . $phpAds_config['tbl_banners'] . phpAds_getBannerListOrder($listorder, $orderdirection); } elseif (phpAds_isUser(phpAds_Agency)) { $query = "SELECT b.bannerid AS bannerid" . ",b.campaignid AS campaignid" . ",b.alt AS alt" . ",b.description AS description" . ",b.active AS active" . ",b.storagetype AS storagetype" . " FROM " . $phpAds_config['tbl_banners'] . " AS b" . "," . $phpAds_config['tbl_campaigns'] . " AS m" . "," . $phpAds_config['tbl_clients'] . " AS c" . " WHERE b.campaignid=m.campaignid" . " AND m.clientid=c.clientid" . " AND c.agencyid=" . phpAds_getUserID() . phpAds_getBannerListOrder($listorder, $orderdirection); } $res_banners = phpAds_dbQuery($query) or phpAds_sqlDie(); while ($row_banners = phpAds_dbFetchArray($res_banners)) { if (isset($clients[$row_banners['campaignid']])) { $clients[$row_banners['campaignid']]['count']++; } if (isset($campaigns[$row_banners['campaignid']])) { $banners[$row_banners['bannerid']] = $row_banners; $banners[$row_banners['bannerid']]['clicks'] = 0; $banners[$row_banners['bannerid']]['views'] = 0; $campaigns[$row_banners['campaignid']]['count']++; } $res_stats = phpAds_dbQuery("SELECT" . " sum(views) as views" . ",sum(clicks) as clicks" . ",sum(conversions) as conversions" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid=" . $row_banners['bannerid'] . $limit) or phpAds_sqlDie(); if ($row_stats = phpAds_dbFetchArray($res_stats)) { $banners[$row_banners['bannerid']]['clicks'] = $row_stats['clicks'];
function phpAds_getBannerStatsByCampaignID($campaignid, $name = '', $listorder = 'name', $orderdirection = 'up', $omit_arr = null, $path = '') { global $phpAds_config; $query = "SELECT" . " b.bannerid AS bannerid" . ",b.description AS description" . ",b.alt AS alt" . ",SUM(views) AS views" . ",SUM(clicks) AS clicks" . ",SUM(conversions) AS conversions" . ",FORMAT(SUM(clicks)/SUM(views),6) AS ctr" . ",FORMAT(SUM(conversions)/SUM(clicks),6) AS cnvr" . " FROM " . $phpAds_config['tbl_adstats'] . " AS s" . "," . $phpAds_config['tbl_banners'] . " AS b" . " WHERE b.bannerid=s.bannerid" . " AND b.campaignid=" . $campaignid . " GROUP BY bannerid" . phpAds_getBannerListOrder($listorder, $orderdirection); return phpAds_getBannerStats($query, $name, $omit_arr); }
$timestamp_begin = mktime(0, 0, 0, 1, 1, date('Y')); $limit = "day >= " . date('Ymd', $timestamp_begin); break; case 'x': $timestamp_begin = mktime(0, 0, 0, 1, 1, date('Y') - 1); $timestamp_end = mktime(0, 0, 0, 1, 1, date('Y')); $limit = "day >= " . date('Ymd', $timestamp_begin) . " AND day < " . date('Ymd', $timestamp_end); break; default: $limit = ''; $period = ''; break; } } // Get the banners for each campaign $res_banners = phpAds_dbQuery("\n\tSELECT \n\t\tbannerid,\n\t\tclientid,\n\t\talt,\n\t\tdescription,\n\t\tactive,\n\t\tstoragetype\n\tFROM \n\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t" . phpAds_getBannerListOrder($listorder, $orderdirection) . "\n\t") or phpAds_sqlDie(); while ($row_banners = phpAds_dbFetchArray($res_banners)) { if (isset($clients[$row_banners['clientid']])) { $clients[$row_banners['clientid']]['count']++; } if (isset($campaigns[$row_banners['clientid']])) { $banners[$row_banners['bannerid']] = $row_banners; $banners[$row_banners['bannerid']]['clicks'] = 0; $banners[$row_banners['bannerid']]['views'] = 0; $campaigns[$row_banners['clientid']]['count']++; $bannerids[] = $row_banners['bannerid']; } } if (count($bannerids)) { // Create WHERE clause $where = $limit ? "WHERE " . $limit : '';
/*********************************************************/ /* HTML framework */ /*********************************************************/ if (isset($Session['prefs']['stats-campaign-banners.php']['listorder'])) { $navorder = $Session['prefs']['stats-campaign-banners.php']['listorder']; } else { $navorder = ''; } if (isset($Session['prefs']['stats-campaign-banners.php']['orderdirection'])) { $navdirection = $Session['prefs']['stats-campaign-banners.php']['orderdirection']; } else { $navdirection = ''; } if (phpAds_isUser(phpAds_Client)) { if (phpAds_getUserID() == phpAds_getCampaignParentClientID($campaignid)) { $res = phpAds_dbQuery("SELECT *" . " FROM " . $phpAds_config['tbl_banners'] . " WHERE campaignid=" . $campaignid . phpAds_getBannerListOrder($navorder, $navdirection)) or phpAds_sqlDie(); while ($row = phpAds_dbFetchArray($res)) { phpAds_PageContext(phpAds_buildBannerName($row['bannerid'], $row['description'], $row['alt']), "stats-banner-affiliates.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&bannerid=" . $row['bannerid'], $bannerid == $row['bannerid']); } $sections[] = "1.2.2.1"; if (phpAds_isAllowed(phpAds_ModifyBanner)) { $sections[] = "1.2.2.2"; } $sections[] = "1.2.2.4"; phpAds_PageHeader("1.2.2.4"); echo "<img src='images/icon-campaign.gif' align='absmiddle'> " . phpAds_getCampaignName($campaignid); echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> "; echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br>"; echo phpAds_buildBannerCode($bannerid) . "<br><br><br><br>"; phpAds_ShowSections($sections); } else {