'{$nowtime}' OR ad_date_end='0')";
// MAKE SURE AD IS NOT PAUSED
$ad_querystring .= " AND ad_paused!='1'";
// MAKE SURE AD HAS NOT REACHED ITS VIEW LIMIT
$ad_querystring .= " AND (ad_limit_views=0 OR ad_limit_views>ad_total_views)";
// MAKE SURE AD HAS NOT REACHED ITS CLICK LIMIT
$ad_querystring .= " AND (ad_limit_clicks=0 OR ad_limit_clicks>ad_total_clicks)";
// MAKE SURE AD HAS NOT REACHED ITS CTR LIMIT
$ad_querystring .= " AND (ad_limit_ctr=0 OR ad_limit_ctr<(ad_total_clicks/(ad_total_views+1))*100)";
// IF VIEWER IS NOT LOGGED-IN, ONLY SHOW PUBLIC AD CAMPAIGNS
if( !$user->user_exists )
{
$ad_querystring .= " AND ad_public='1'";
}
// IF VIEWER IS LOGGED-IN, ONLY SHOW AD IF VIEWER'S LEVEL AND SUBNETS MATCH
else
{
$level_id = $user->level_info['level_id'];
$subnet_id = $user->subnet_info['subnet_id'];
$ad_querystring .= " AND (ad_levels LIKE '%,{$level_id},%' AND ad_subnets LIKE '%,{$subnet_id},%')";
}
// RANDOMIZE QUERY RESULTS
$ad_querystring .= " ORDER BY RAND()";
// DETERMINE WHICH ADS SHOULD BE SHOWN
$ad_query = $database->database_query($ad_querystring);
// PREPARE STAT UPDATE QUERY
$stats_id_array = array();
// SET AD HTML FOR EACH POSITION
while( $ad_info = $database->database_fetch_assoc($ad_query) )
{
// CONVERT TO HTML AND ADD CLICK-TRACKING JAVASCRIPT
$ad_info['ad_html'] = htmlspecialchars_decode($ad_info['ad_html'], ENT_QUOTES);
$ad_info['ad_html'] = "
{$ad_info['ad_html']}

";
$this->ad_custom[$ad_info['ad_id']] = $ad_info['ad_html'];
if( $ad_info['ad_position'] == "top" && !$this->ad_top )
{
$this->ad_top = $ad_info['ad_html'];
$stats_id_array[] = $ad_info['ad_id'];
}
elseif( $ad_info['ad_position'] == "belowmenu" && !$this->ad_belowmenu )
{
$this->ad_belowmenu = $ad_info['ad_html'];
$stats_id_array[] = $ad_info['ad_id'];
}
elseif( $ad_info['ad_position'] == "left" && !$this->ad_left )
{
$this->ad_left = $ad_info['ad_html'];
$stats_id_array[] = $ad_info['ad_id'];
}
elseif( $ad_info['ad_position'] == "right" && !$this->ad_right )
{
$this->ad_right = $ad_info['ad_html'];
$stats_id_array[] = $ad_info['ad_id'];
}
elseif( $ad_info['ad_position'] == "feed" && !$this->ad_feed )
{
$this->ad_feed = $ad_info['ad_html'];
$stats_id_array[] = $ad_info['ad_id'];
}
elseif( $ad_info['ad_position'] == "bottom" && !$this->ad_bottom )
{
$this->ad_bottom = $ad_info['ad_html'];
$stats_id_array[] = $ad_info['ad_id'];
}
}
// UPDATE THE ADS VIEW STATS
if( !empty($stats_id_array) )
{
$database->database_query("UPDATE se_ads SET ad_total_views=ad_total_views+1 WHERE ad_id IN('".join("', '", $stats_id_array)."')");
}
}
// END se_ads() METHOD
// THIS METHOD IS DISPLAYS THE CUSTOM AD AND UPDATES THE VIEWS
// INPUT: $ad_id REPRESENTING AN AD ID
// OUTPUT: AD BANNER HTML (IF AVAILABLE) FOR GIVEN AD ID
function ads_display($ad_id)
{
global $database;
// UPDATE THE ADS VIEW STATS
$database->database_query("UPDATE se_ads SET ad_total_views=ad_total_views+1 WHERE ad_id='{$ad_id}' LIMIT 1");
// DISPLAY AD
return $this->ad_custom[$ad_id];
}
// END ads_display() METHOD
}
?>