'{$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 } ?>