NOW() AND ';
$sql .= '(ac.adcampaign_maxview=0 OR (ac.adcampaign_maxview > 0 AND ac.adcampaign_maxview >= ac.adcampaign_curview)) AND ';
$sql .= '(ac.adcampaign_maxclick=0 OR (ac.adcampaign_maxclick > 0 AND ac.adcampaign_maxclick >= ac.adcampaign_curclick))';
$ads = _dbQuery($sql);
if(is_array($ads) && count($ads) ) {
if(empty($_COOKIE['phpwcmsAdsUserId'])) {
$ad = $ads[array_rand($ads)];
} else {
$ads_userid = $_COOKIE['phpwcmsAdsUserId'];
$ads_viewed = 0;
while(count($ads)) {
$ad_index = array_rand($ads);
$ad = $ads[$ad_index];
if($ad['adcampaign_maxviewuser']) {
//check how often selected ad was viewed by user
$sql = 'SELECT COUNT(*) FROM '.DB_PREPEND.'phpwcms_ads_tracking WHERE ';
$sql .= 'adtracking_campaignid='.$ad['adcampaign_id'].' AND ';
$sql .= "adtracking_cookieid='".mysql_escape_string($ads_userid)."'";
$ads_viewed = _dbQuery($sql, 'COUNT');
if($ads_viewed <= $ad['adcampaign_maxviewuser']) {
break;
} else {
unset($ads[$ad_index]);
}
} else {
break;
}
}
if(!count($ads)) {
return '';
}
}
} else {
return '';
}
$ad['adcampaign_data'] = @unserialize($ad['adcampaign_data']);
$ad['dir'] = PHPWCMS_CONTENT.'ads/'.$ad['adcampaign_id'];
$ad['content_dir'] = CONTENT_PATH.'ads/'.$ad['adcampaign_id'].'/';
if($ad['adcampaign_type']!=2 && $ad['adcampaign_type']!=4 && !is_dir($ad['dir'])) {
return '';
}
$ad['dir'] .= '/';
if(!empty($ad['adcampaign_data']['css']) && is_file($ad['dir'].$ad['adcampaign_data']['css'])) {
$GLOBALS['block']['custom_htmlhead'][] = ' ';
break;
case 1: //Flash
$ad['adcampaign_data']['url'] = urlencode($ad['adcampaign_data']['url']);
$ad_flashID = 'adsBannerFlash'.$adID;
$ad_so = 'adsInnerFlash'.$ad['adcampaign_id'];
$ad_media .= '';
if(is_file($ad['dir'].$ad['adcampaign_data']['image'])) {
$ad_media .= ''.$ad_media.'';
if(!empty($ad['adcampaign_data']['flash']) && is_file($ad['dir'].$ad['adcampaign_data']['flash'])) {
initSwfObject();
$ad_urldata = urldecode(str_replace('&', '&', $ad_urldata));
$ad_flash = ' ';
$GLOBALS['block']['custom_htmlhead'][$ad_so] = $ad_flash;
}
break;
case 2: //HTML
if(!empty($ad['adcampaign_data']['html'])) {
if($ad['adcampaign_data']['bordercolor']) {
$ad_wxh = ' style="width:'.($ad['adplace_width']-2).'px;height:'.($ad['adplace_height']-2).'px;';
$ad_wxh .= 'border:1px solid '.$ad['adcampaign_data']['bordercolor'].';';
} else {
$ad_wxh = ' style="width:'.$ad['adplace_width'].'px;height:'.$ad['adplace_height'].'px;';
}
if($ad['adcampaign_data']['bgcolor']) {
$ad_wxh .= 'background-color:'.$ad['adcampaign_data']['bgcolor'].';';
}
$ad_media .= '';
}
break;
case 3: //Flash Layer
$ad['adcampaign_data']['url'] = urlencode($ad['adcampaign_data']['url']);
$ad_flashID = 'adsBannerFL'.$adID;
$ad_so = 'adsInnerFlash'.$ad['adcampaign_id'];
if(!empty($ad['adcampaign_data']['flash']) && is_file($ad['dir'].$ad['adcampaign_data']['flash'])) {
$ad_media = '';
initSwfObject();
$ad_urldata = urldecode(str_replace('&', '&', $ad_urldata));
$ad_flash = ' '.LF;
$ad_flash .= ' ';
$GLOBALS['block']['custom_htmlhead'][$ad_so] = $ad_flash;
}
break;
case 4: //Remote HTML Code
if(!empty($ad['adcampaign_data']['html'])) {
$ad_media .= $ad['adcampaign_data']['html'];
}
break;
}
//set ads tracking image here.
$GLOBALS['content']['ADS_ALL'][] = $ad['adcampaign_id'];
return $ad['adplace_prefix'].$ad_media.$ad['adplace_suffix'];
}
?>