\n"; flush(); // Fetch all banners belonging to client $res_banners = db_query(" SELECT bannerID, clientID, URL, active FROM $phpAds_tbl_banners WHERE clientID = $row_clients[clientID] ") or die($strLogErrorBanners); $logs[$i] = ""; while($row_banners = mysql_fetch_array($res_banners)) { if($row_banners["active"] == "true") $clients[$i]["active"] = true; $logs[$i] .= "BannerID: $row_banners[bannerID] [linked to: $row_banners[URL]]\n"; print "

Processing banner $row_banners[bannerID] [linked to: $row_banners[URL]]...
\n"; flush(); $adviews = db_total_views($row_banners["bannerID"]); $clients[$i]["views_used"] = $adviews; $logs[$i] .= " $strViews (total): $adviews\n"; // Fetch all adviews belonging to banner belonging to client, grouped by day if ($phpAds_compact_stats) $res_adviews = db_query(" SELECT SUM(views) as qnt, DATE_FORMAT(day, '$date_format') as t_stamp_f, TO_DAYS(day) AS the_day FROM $phpAds_tbl_adstats WHERE bannerID = $row_banners[bannerID] AND views > 0 GROUP BY day ORDER BY day DESC LIMIT 7 ") or die($strLogErrorViews); else $res_adviews = db_query(" SELECT *, count(*) as qnt, DATE_FORMAT(t_stamp, '$date_format') as t_stamp_f, TO_DAYS(t_stamp) AS the_day FROM $phpAds_tbl_adviews WHERE bannerID = $row_banners[bannerID] GROUP BY the_day ORDER BY the_day DESC LIMIT 7 ") or die($strLogErrorViews); while($row_adviews = mysql_fetch_array($res_adviews)) $logs[$i] .= " $row_adviews[t_stamp_f]: $row_adviews[qnt]\n"; // Total adclicks $adclicks = db_total_clicks($row_banners["bannerID"]); $clients[$i]["clicks_used"] = $adclicks; $logs[$i] .= " $strClicks (total) : $adclicks\n"; // Fetch all adclicks belonging to banner belonging to client, grouped by day if ($phpAds_compact_stats) $res_adclicks = db_query(" SELECT SUM(clicks) as qnt, DATE_FORMAT(day, '$date_format') as t_stamp_f, TO_DAYS(day) AS the_day FROM $phpAds_tbl_adstats WHERE bannerID = $row_banners[bannerID] AND clicks > 0 GROUP BY day ORDER BY day DESC LIMIT 7 ") or die("$strLogErrorClicks ".mysql_error()); else $res_adclicks = db_query(" SELECT count(*) as qnt, DATE_FORMAT(t_stamp, '$date_format') as t_stamp_f, TO_DAYS(t_stamp) AS the_day FROM $phpAds_tbl_adclicks WHERE bannerID = $row_banners[bannerID] GROUP BY the_day ORDER BY the_day DESC LIMIT 7 ") or die("$strLogErrorClicks ".mysql_error()); while($row_adclicks = mysql_fetch_array($res_adclicks)) $logs[$i] .= " $row_adclicks[t_stamp_f]: $row_adclicks[qnt]\n"; $logs[$i] .= "____________________________________________________________\n"; } $i++; } for($i=0; $i