function Plugin_AffiliatehistoryExecute($affiliateid, $delimiter = ",") { global $phpAds_config, $date_format; global $strAffiliate, $strTotal, $strDay, $strViews, $strClicks, $strCTRShort; header("Content-type: application/csv\nContent-Disposition: \"inline; filename=affiliatehistory.csv\""); $idresult = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tzoneid\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\tWHERE\n\t\t\taffiliateid = '" . $affiliateid . "'\n\t"); while ($row = phpAds_dbFetchArray($idresult)) { $zoneids[] = "zoneid = " . $row['zoneid']; } $res_query = "\n\t\tSELECT\n\t\t\tDATE_FORMAT(day, '" . $date_format . "') as day,\n\t\t\tSUM(views) AS adviews,\n\t\t\tSUM(clicks) AS adclicks\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\tWHERE\n\t\t\t(" . implode(' OR ', $zoneids) . ")\n\t\tGROUP BY\n\t\t\tday\n\t"; $res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie(); while ($row_banners = phpAds_dbFetchArray($res_banners)) { $stats[$row_banners['day']]['views'] = $row_banners['adviews']; $stats[$row_banners['day']]['clicks'] = $row_banners['adclicks']; } echo $strAffiliate . ": " . strip_tags(phpAds_getAffiliateName($affiliateid)) . "\n\n"; echo $strDay . $delimiter . $strViews . $delimiter . $strClicks . $delimiter . $strCTRShort . "\n"; $totalclicks = 0; $totalviews = 0; if (isset($stats) && is_array($stats)) { for (reset($stats); $key = key($stats); next($stats)) { $row = array(); // $key = implode('/',array_reverse(split('[-]',$key))); $row[] = $key; $row[] = $stats[$key]['views']; $row[] = $stats[$key]['clicks']; $row[] = phpAds_buildCTR($stats[$key]['views'], $stats[$key]['clicks']); echo implode($delimiter, $row) . "\n"; $totalclicks += $stats[$key]['clicks']; $totalviews += $stats[$key]['views']; } } echo "\n"; echo $strTotal . $delimiter . $totalviews . $delimiter . $totalclicks . $delimiter . phpAds_buildCTR($totalviews, $totalclicks) . "\n"; }
/* HTML framework */ /*********************************************************/ if (phpAds_isUser(phpAds_Admin)) { if ($phpAds_config['compact_stats']) { $res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\tDISTINCT bannerid\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\t\tWHERE\n\t\t\t\tzoneid = '" . $zoneid . "'\n\t\t") or phpAds_sqlDie(); } else { $res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\tDISTINCT bannerid\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_adviews'] . "\n\t\t\tWHERE\n\t\t\t\tzoneid = '" . $zoneid . "'\n\t\t") or phpAds_sqlDie(); } while ($row = phpAds_dbFetchArray($res)) { phpAds_PageContext(phpAds_getBannerName($row['bannerid']), "stats-linkedbanner-history.php?affiliateid=" . $affiliateid . "&zoneid=" . $zoneid . "&bannerid=" . $row['bannerid'], $bannerid == $row['bannerid']); } phpAds_PageShortcut($strAffiliateProperties, 'affiliate-edit.php?affiliateid=' . $affiliateid, 'images/icon-affiliate.gif'); phpAds_PageShortcut($strZoneProperties, 'zone-edit.php?affiliateid=' . $affiliateid . '&zoneid=' . $zoneid, 'images/icon-zone.gif'); phpAds_PageShortcut($strIncludedBanners, 'zone-include.php?affiliateid=' . $affiliateid . '&zoneid=' . $zoneid, 'images/icon-zone-linked.gif'); phpAds_PageHeader("2.4.2.2.1"); echo "<img src='images/icon-affiliate.gif' align='absmiddle'> " . phpAds_getAffiliateName($affiliateid); echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> "; echo "<img src='images/icon-zone.gif' align='absmiddle'> " . phpAds_getZoneName($zoneid); echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> "; echo "<img src='images/icon-zone-linked.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br><br>"; phpAds_ShowSections(array("2.4.2.2.1")); } else { phpAds_PageHeader("1.1.2.1"); echo "<img src='images/icon-zone.gif' align='absmiddle'> " . phpAds_getZoneName($zoneid); echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> "; echo "<img src='images/icon-zone-linked.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br><br>"; phpAds_ShowSections(array("1.1.2.1")); } /*********************************************************/ /* Main code */ /*********************************************************/
function Plugin_AffiliatehistoryExecute($affiliateid, $delimiter = "t", $quotes = "") { global $phpAds_config, $date_format; global $strAffiliate, $strTotal, $strDay, $strViews, $strClicks, $strCTRShort; // Expand delimiter and quotes if ($delimiter == 't') { $delimiter = "\t"; } if ($quotes == '1') { $quotes = "'"; } if ($quotes == '2') { $quotes = '"'; } header("Content-type: application/csv"); header("Content-Disposition: inline; filename=\"publisherhistory.csv\""); $idresult = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tzoneid\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\tWHERE\n\t\t\taffiliateid = '" . $affiliateid . "'\n\t"); while ($row = phpAds_dbFetchArray($idresult)) { $zoneids[] = $row['zoneid']; } if (count($zoneids)) { if ($phpAds_config['compact_stats']) { $res_query = "\n\t\t\t\tSELECT\n\t\t\t\t\tDATE_FORMAT(day, '%Y%m%d') as date,\n\t\t\t\t\tDATE_FORMAT(day, '{$date_format}') as date_formatted,\n\t\t\t\t\tSUM(views) AS adviews,\n\t\t\t\t\tSUM(clicks) AS adclicks\n\t\t\t\tFROM\n\t\t\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\t\t\tWHERE\n\t\t\t\t\tzoneid IN (" . implode(', ', $zoneids) . ")\n\t\t\t\tGROUP BY\n\t\t\t\t\tday\n\t\t\t\tORDER BY\n\t\t\t\t\tdate\n\t\t\t"; $res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie(); while ($row_banners = phpAds_dbFetchArray($res_banners)) { $stats[$row_banners['date_formatted']]['views'] = $row_banners['adviews']; $stats[$row_banners['date_formatted']]['clicks'] = $row_banners['adclicks']; } } else { $res_query = "\n\t\t\t\tSELECT\n\t\t\t\t\tDATE_FORMAT(t_stamp, '%Y%m%d') as date,\n\t\t\t\t\tDATE_FORMAT(t_stamp, '" . $date_format . "') as date_formatted,\n\t\t\t\t\tcount(bannerid) as adviews\n\t\t\t\tFROM\n\t\t\t\t\t" . $phpAds_config['tbl_adviews'] . "\n\t\t\t\tWHERE\n\t\t\t\t\tzoneid IN (" . implode(', ', $zoneids) . ")\n\t\t\t\tGROUP BY\n\t\t\t\t\tdate, date_formatted\n\t\t\t\tORDER BY\n\t\t\t\t\tdate\n\t\t\t"; $res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie(); while ($row_banners = phpAds_dbFetchArray($res_banners)) { $stats[$row_banners['date_formatted']]['views'] = $row_banners['adviews']; $stats[$row_banners['date_formatted']]['clicks'] = 0; } $res_query = "\n\t\t\t\tSELECT\n\t\t\t\t\tDATE_FORMAT(t_stamp, '%Y%m%d') as date,\n\t\t\t\t\tDATE_FORMAT(t_stamp, '" . $date_format . "') as date_formatted,\n\t\t\t\t\tcount(bannerid) as adclicks\n\t\t\t\tFROM\n\t\t\t\t\t" . $phpAds_config['tbl_adclicks'] . "\n\t\t\t\tWHERE\n\t\t\t\t\tzoneid IN (" . implode(', ', $zoneids) . ")\n\t\t\t\tGROUP BY\n\t\t\t\t\tdate, date_formatted\n\t\t\t\tORDER BY\n\t\t\t\t\tdate\n\t\t\t"; $res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie(); while ($row_banners = phpAds_dbFetchArray($res_banners)) { $stats[$row_banners['date_formatted']]['clicks'] = $row_banners['adclicks']; } } } echo $quotes . $strAffiliate . ": " . strip_tags(phpAds_getAffiliateName($affiliateid, false)) . $quotes . "\n\n"; echo $quotes . $strDay . $quotes . $delimiter . $quotes . $strViews . $quotes . $delimiter; echo $quotes . $strClicks . $quotes . $delimiter . $quotes . $strCTRShort . $quotes . "\n"; $totalclicks = 0; $totalviews = 0; if (isset($stats) && is_array($stats)) { foreach (array_keys($stats) as $key) { $row = array(); $row[] = $quotes . $key . $quotes; $row[] = $quotes . $stats[$key]['views'] . $quotes; $row[] = $quotes . $stats[$key]['clicks'] . $quotes; $row[] = $quotes . phpAds_buildCTR($stats[$key]['views'], $stats[$key]['clicks']) . $quotes; echo implode($delimiter, $row) . "\n"; $totalclicks += $stats[$key]['clicks']; $totalviews += $stats[$key]['views']; } } echo "\n"; echo $quotes . $strTotal . $quotes . $delimiter . $quotes . $totalviews . $quotes . $delimiter; echo $quotes . $totalclicks . $quotes . $delimiter . $quotes . phpAds_buildCTR($totalviews, $totalclicks) . $quotes . "\n"; }