getcampaign.php

基于actionscript3.0的flashLoading控件

<?php

$bannerName = $_POST["bannerName"];

require '../banner_admin/config.php';

$connection = mysql_connect($DBhost,$DBuser,$DBpass) or die("Couldn't make connection: ". mysql_error());
$db = mysql_select_db("$DBName", $connection) or die("Couldn't select database: ". mysql_error());

$today = date("Y-m-d");
$currentMonth = date("m");
$currentYear = date("Y");


$selectCampaign1a = "	SELECT ad_images.campaign_id, ad_images.filename, ad_images.link, 
						SUM(ad_counters.impressions) as cImpressions, SUM(ad_counters.clicks) as cClicks,
						ad_campaigns.impressions, ad_campaigns.clicks, ad_banners.banner_timer, ad_banners.banner_target,
						ad_banners.banner_uimpressions, ad_banners.banner_uclicks, ad_banners.id,
						ad_campaigns.weight, ad_weight.counter
						FROM ad_images, ad_campaigns, ad_counters, ad_banners, ad_weight
						WHERE ad_images.campaign_id = ad_campaigns.id
						AND ad_counters.campaign_id = ad_campaigns.id
						AND ad_campaigns.banner_id = ad_banners.id
						AND ad_weight.banner_id = ad_banners.id
						AND ad_images.active = 'Y'
						AND ad_campaigns.active = 'Y'
						AND ad_campaigns.startdate <= '".$today."'
						AND ad_campaigns.enddate >= '".$today."'
						AND banner_name LIKE '".$bannerName."'
						AND ad_campaigns.monthly = 'N'
						GROUP BY ad_images.filename, ad_images.link, ad_images.campaign_id,
						ad_campaigns.monthly, ad_campaigns.impressions, ad_campaigns.clicks,
						ad_banners.id, ad_campaigns.weight, ad_weight.counter";


$selectCampaign1b = "	SELECT ad_images.campaign_id, ad_images.filename, ad_images.link, 						
						ad_campaigns.impressions, ad_campaigns.clicks, ad_banners.banner_timer, ad_banners.banner_target,
						ad_banners.banner_uimpressions, ad_banners.banner_uclicks, ad_banners.id,
						ad_campaigns.weight, ad_weight.counter
						FROM ad_images, ad_campaigns, ad_banners, ad_weight
						WHERE ad_images.campaign_id = ad_campaigns.id
						AND ad_campaigns.banner_id = ad_banners.id
						AND ad_weight.banner_id = ad_banners.id
						AND ad_images.active = 'Y'
						AND ad_campaigns.active = 'Y'
						AND ad_campaigns.startdate <= '".$today."'
						AND ad_campaigns.enddate >= '".$today."'
						AND banner_name LIKE '".$bannerName."'
						AND ad_campaigns.monthly = 'N'
						GROUP BY ad_images.filename, ad_images.link, ad_images.campaign_id,
						ad_campaigns.monthly, ad_campaigns.impressions, ad_campaigns.clicks,
						ad_banners.id, ad_campaigns.weight, ad_weight.counter";


$selectCampaign2a = "	SELECT ad_images.campaign_id, ad_images.filename, ad_images.link, ad_campaigns.impressions,
						ad_counters.impressions as cImpressions, ad_campaigns.clicks,
						ad_counters.clicks as cClicks, ad_banners.banner_timer, ad_banners.banner_target,
						ad_banners.banner_uimpressions, ad_banners.banner_uclicks, ad_banners.id,
						ad_campaigns.weight, ad_weight.counter
						FROM ad_images, ad_campaigns, ad_counters, ad_banners, ad_weight
						WHERE ad_images.campaign_id = ad_campaigns.id
						AND ad_counters.campaign_id = ad_campaigns.id
						AND ad_campaigns.banner_id = ad_banners.id
						AND ad_weight.banner_id = ad_banners.id
						AND ad_images.active = 'Y'
						AND ad_campaigns.active = 'Y'
						AND ad_campaigns.startdate <= '".$today."'
						AND ad_campaigns.enddate >= '".$today."'
						AND banner_name LIKE '".$bannerName."'
						AND ad_campaigns.monthly = 'Y'
						AND ad_counters.month = ".$currentMonth." AND ad_counters.year = ".$currentYear;


$selectCampaign2b = "	SELECT ad_images.campaign_id, ad_images.filename, ad_images.link,
						ad_banners.banner_timer, ad_banners.banner_target,
						ad_banners.banner_uimpressions, ad_banners.banner_uclicks, ad_banners.id,
						ad_campaigns.weight, ad_weight.counter
						FROM ad_images, ad_campaigns, ad_banners, ad_weight
						WHERE ad_images.campaign_id = ad_campaigns.id
						AND ad_campaigns.banner_id = ad_banners.id
						AND ad_weight.banner_id = ad_banners.id
						AND ad_images.active = 'Y'
						AND ad_campaigns.active = 'Y'
						AND ad_campaigns.startdate <= '".$today."'
						AND ad_campaigns.enddate >= '".$today."'
						AND banner_name LIKE '".$bannerName."'
						AND ad_campaigns.monthly = 'Y' ";


$result = mysql_query($selectCampaign1a,$connection) or die("Couldn't execute query: ". mysql_error());

$campaignArray = "";
$fileArray = "";
$linkArray = "";

$listedArray1 = array();
$fullQuotaArray1 = array();
$listedArray2 = array();
$fullQuotaArray2 = array();

while($row = mysql_fetch_array($result)){
	$banner_id = $row['id'];
	$campaign_id = $row['campaign_id'];
	$filename = $row['filename'];
	$link = $row['link'];
	$impCount = $row['cImpressions'];
	$clickCount = $row['cClicks'];
	$impressions = $row['impressions'];
	$clicks = $row['clicks'];
	$timer = $row['banner_timer'];
	$targetWindow = $row['banner_target'];
	$uImpressions = $row['banner_uimpressions'];
	$uClicks = $row['banner_uclicks'];
	$campaignWeight = $row['weight'];
	$bannerCounter = $row['counter'];

	if($campaignWeight == null || $campaignWeight == "") {
		$campaignWeight = 1;
	}

	if($bannerCounter%$campaignWeight == 0) {	
		if(($impressions > 0 && $impressions > $impCount) ||
			($clicks > 0 && $clicks > $clickCount) || ($impressions==0 && $clicks==0)) {

			array_push($listedArray1, $campaign_id);

			if($campaignArray == "")
				$campaignArray = $campaign_id;
			else
				$campaignArray .= ",".$campaign_id;
			if($fileArray == "")
				$fileArray = $filename;
			else
				$fileArray .= ",".$filename;
			if($linkArray == "")
				$linkArray = $link;
			else
				$linkArray .= ",".$link;
		} else {
			array_push($fullQuotaArray1, $campaign_id);
		}
	}
}


$result = mysql_query($selectCampaign1b,$connection) or die("Couldn't execute query: ". mysql_error());

while($row = mysql_fetch_array($result)){
	$banner_id = $row['id'];
	$campaign_id = $row['campaign_id'];
	$filename = $row['filename'];
	$link = $row['link'];
	$timer = $row['banner_timer'];
	$targetWindow = $row['banner_target'];
	$uImpressions = $row['banner_uimpressions'];
	$uClicks = $row['banner_uclicks'];
	$campaignWeight = $row['weight'];
	$bannerCounter = $row['counter'];

	if($campaignWeight == null || $campaignWeight == "") {
		$campaignWeight = 1;
	}

	if($bannerCounter%$campaignWeight == 0) {
		$place = array_search($campaign_id, $listedArray1);		
		if($place === false || $place == null) {
			$place = array_search($campaign_id, $fullQuotaArray1);
		}
		if($place === false || $place == null) {
			if($campaignArray == "")
				$campaignArray = $campaign_id;
			else
				$campaignArray .= ",".$campaign_id;
			if($fileArray == "")
				$fileArray = $filename;
			else
				$fileArray .= ",".$filename;
			if($linkArray == "")
				$linkArray = $link;
			else
				$linkArray .= ",".$link;
		}
	}
}



$result = mysql_query($selectCampaign2a,$connection) or die("Couldn't execute query: ". mysql_error());

while($row = mysql_fetch_array($result)){
	$banner_id = $row['id'];
	$campaign_id = $row['campaign_id'];
	$filename = $row['filename'];
	$link = $row['link'];
	$impCount = $row['cImpressions'];
	$clickCount = $row['cClicks'];
	$impressions = $row['impressions'];
	$clicks = $row['clicks'];
	$timer = $row['banner_timer'];
	$targetWindow = $row['banner_target'];
	$uImpressions = $row['banner_uimpressions'];
	$uClicks = $row['banner_uclicks'];
	$campaignWeight = $row['weight'];
	$bannerCounter = $row['counter'];

	if($campaignWeight == null || $campaignWeight == "") {
		$campaignWeight = 1;
	}

	if($bannerCounter%$campaignWeight == 0) {
		if(($impressions > 0 && $impressions > $impCount) || ($clicks > 0 && $clicks > $clickCount)
			|| ($impressions==0 && $clicks==0)) {

			array_push($listedArray2, $campaign_id);
			
			if($campaignArray == "")
				$campaignArray = $campaign_id;
			else
				$campaignArray .= ",".$campaign_id;
			if($fileArray == "")
				$fileArray = $filename;
			else
				$fileArray .= ",".$filename;
			if($linkArray == "")
				$linkArray = $link;
			else
				$linkArray .= ",".$link;
		} else {
			array_push($fullQuotaArray2, $campaign_id);
		}
	}
}

$result = mysql_query($selectCampaign2b,$connection) or die("Couldn't execute query: ". mysql_error());

while($row = mysql_fetch_array($result)){
	$banner_id = $row['id'];
	$campaign_id = $row['campaign_id'];
	$filename = $row['filename'];
	$link = $row['link'];
	$timer = $row['banner_timer'];
	$targetWindow = $row['banner_target'];
	$uImpressions = $row['banner_uimpressions'];
	$uClicks = $row['banner_uclicks'];
	$campaignWeight = $row['weight'];
	$bannerCounter = $row['counter'];

	if($campaignWeight == null || $campaignWeight == "") {
		$campaignWeight = 1;
	}

	if($bannerCounter%$campaignWeight == 0) {
		$place = array_search ($campaign_id, $listedArray2);
		if($place === false || $place == null) {
			$place = array_search ($campaign_id, $fullQuotaArray2);
		}
		if($place === false || $place == null) {
			if($campaignArray == "")
				$campaignArray = $campaign_id;
			else
				$campaignArray .= ",".$campaign_id;
			if($fileArray == "")
				$fileArray = $filename;
			else
				$fileArray .= ",".$filename;
			if($linkArray == "")
				$linkArray = $link;
			else
				$linkArray .= ",".$link;
		}
	}
}

print "&campaignArray=$campaignArray&fileArray=$fileArray&linkArray=$linkArray&timer=$timer&targetWindow=$targetWindow&uImpressions=$uImpressions&uClicks=$uClicks&bannerGroupID=$banner_id";

mysql_close($connection);

?>