<?php
//ignore_user_abort(TRUE);
ob_start();
error_reporting(E_ERROR | E_WARNING | E_PARSE);
if ((ini_get ('session.save_handler') == "files") && (file_exists("sessions")) && (is_writable("sessions"))){ @ini_set('session.save_path', 'sessions'); }
// initialize variables
$uid = $_GET['uid'];
$bzone = $_GET['bzone'];
$btarget = (isset($_GET['btarget'])) ? $_GET['btarget'] : "_blank";
$bsize = (isset($_GET['bsize'])) ? $_GET['bsize'] : false;
$btype = (isset($_GET['btype'])) ? $_GET['btype'] : false;
$transferurl = (isset($_GET['transferurl'])) ? $_GET['transferurl'] : false;
$bfunction  = $_GET['bfunction'];
$bf = $_GET['bf'];
$bpos = (isset($_GET['bpos'])) ? $_GET['bpos'] : false;
$bborder = (isset($_GET['bborder'])) ? $_GET['bborder'] : "0";
$brefresh = (isset($_GET['brefresh'])) ? $_GET['brefresh'] : false;
$campaignid = (isset($_GET['campaignid'])) ? $_GET['campaignid'] : false;
$adno = (isset($_GET['adno'])) ? $_GET['adno'] : false;
$aid = (isset($_GET['aid'])) ? $_GET['aid'] : false;
$cid = (isset($_GET['cid'])) ? $_GET['cid'] : false;
$fid = (isset($_GET['fid'])) ? $_GET['fid'] : false;
$atype = (isset($_GET['atype'])) ? $_GET['atype'] : false;
$bstyle = (isset($_GET['bstyle'])) ? $_GET['bstyle'] : false;
$bmode = (isset($_GET['bmode'])) ? $_GET['bmode'] : false;
$gwidth = (isset($_GET['gwidth'])) ? $_GET['gwidth'] : false;
$gspacing = (isset($_GET['gspacing'])) ? $_GET['gspacing'] : "0";
$colwidth = (isset($_GET['colwidth'])) ? $_GET['colwidth'] : false;
$colheight = (isset($_GET['colheight'])) ? $_GET['colheight'] : false;
$brows = (isset($_GET['brows'])) ? $_GET['brows'] : false;
$bcolumns = (isset($_GET['bcolumns'])) ? $_GET['bcolumns'] : false;
$gheight = (isset($_GET['ghight'])) ? $_GET['gheight'] : false;
$gborder = (isset($_GET['google_border'])) ? $_GET['google_border'] : false;
$tborder = (isset($_GET['tborder'])) ? $_GET['tborder'] : "0";
$cpadding = (isset($_GET['cpadding'])) ? $_GET['cpadding'] : "5";
$bocolor = (isset($_GET['bocolor'])) ? preg_replace('/[^a-z0-9]/i', '', $_GET['bocolor']) : false;
$bocolorlight = (isset($_GET['bocolorlight'])) ? preg_replace('/[^a-z0-9]/i', '', $_GET['bocolorlight']) : false;
$bocolordark = (isset($_GET['bocolordark'])) ? preg_replace('/[^a-z0-9]/i', '', $_GET['bocolordark']) : false;
$gpos = (isset($_GET['gpos'])) ? $_GET['gpos'] : false;
$domain = (isset($_GET['domain'])) ? $_GET['domain'] : false;
$btotal = (isset($_GET['btotal'])) ? $_GET['btotal'] : false;
$bsortcolumn = (isset($_GET['bsortcolumn'])) ? $_GET['bsortcolumn'] : false;
$bexclusive = (isset($_GET['bexclusive'])) ? $_GET['bexclusive'] : false;
$tcolor = (isset($_GET['tcolor'])) ?  preg_replace('/[^a-z0-9]/i', '', $_GET['tcolor']) : "0000FF";
$textcolor = (isset($_GET['textcolor'])) ?  preg_replace('/[^a-z0-9]/i', '', $_GET['textcolor']) : "000000";
$lcolor = (isset($_GET['lcolor'])) ?  preg_replace('/[^a-z0-9]/i', '', $_GET['lcolor']) : "499f4c";
$tagline = (isset($_GET['tagline'])) ? $_GET['tagline'] : "Sponsored Ads";
$tagline_bgcolor = (isset($_GET['tagline_bgcolor'])) ?  preg_replace('/[^a-z0-9]/i', '', $_GET['tagline_bgcolor']) : "336699";
$tagline_fontcolor = (isset($_GET['tagline_fontcolor'])) ?  preg_replace('/[^a-z0-9]/i', '', $_GET['tagline_fontcolor']) : "FFFFFF";
$tagline_font = (isset($_GET['tagline_font'])) ? $_GET['tagline_font'] : "Verdana,Arial,Helvetica,sans-serif";
$HTTP_USER_AGENT = $_SERVER['HTTP_USER_AGENT'];
parse_str($_SERVER['QUERY_STRING']);
if (!empty($_SERVER[HTTP_CLIENT_IP])){
$ipaddress= "$_SERVER[HTTP_CLIENT_IP]";
}  elseif (!empty($_SERVER[HTTP_X_REAL_IP])){
$ipaddress= "$_SERVER[HTTP_X_REAL_IP]";
}  else {
$ipaddress = "$_SERVER[REMOTE_ADDR]";
}
// initialize variables
session_start();
header("Expires: Mon, 26 Jul 2024 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache");
header("Cache-Control: private, no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0, max-age=0", false);
header("Pragma: no-cache");
header('P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"');
require("mysqlauth.php");
$time = getdate(time());
$dayofweek = substr(strtolower("$time[weekday]"), 0, 3);
$hour =sprintf("%02d",$time['hours']);
$minute = sprintf("%02d",$time['minutes']);
$today = "$time[year]-" . sprintf("%02d",$time['mon']) . "-" . sprintf("%02d",$time['mday']);
$timestamp = "$today $hour:" . sprintf("%02d",$time['minutes']) . ":" . sprintf("%02d",$time['seconds']);
if (!function_exists('array_fill')) {
function array_fill($iStart, $iLen, $vValue) {
$aResult = array();
for ($iCount = $iStart; $iCount < $iLen + $iStart; $iCount++) {
$aResult[$iCount] = $vValue;
}
return $aResult;
}
}
// open database connection
$db_link = dbconnection_start ($mysqlhost, $mysqlusername, $mysqlpassword, $mysqldatabase, $persistentconnection);
// open database connection
// escape user input variables for safe use in mysql
$uid = mysqli_real_escape_string($db_link,$uid);
$bsize = mysqli_real_escape_string($db_link,$bsize);
$bzone = mysqli_real_escape_string($db_link,$bzone);
$bpos = mysqli_real_escape_string($db_link,$bpos);
$cid = mysqli_real_escape_string($db_link,$cid);
$aid = mysqli_real_escape_string($db_link,$aid);
$fid = mysqli_real_escape_string($db_link,$fid);
$campaignid = mysqli_real_escape_string($db_link,$campaignid);
$adno = mysqli_real_escape_string($db_link,$adno);
// escape user input variables for safe use in mysql
if (($bzone == "geodesic") || ($bzone == "vbulletin") || ($bzone == "68classifieds") || ($bzone == "autodetect")){
$uri_array = parse_url($_SERVER['HTTP_REFERER']);
parse_str($uri_array['query']); // Parses String into Variables
$bzone2 = "default";
//PHP ProAds
      if (!empty($parent_id)) {
      $bzone = "$parent_id";
      }
//PHP ProAds
// vbullitin
      elseif (!empty($fid)) {
      $bzone = "$fid";
      }
      elseif (!empty($f)) {
      $bzone = "$f";
      }
// vbulletin
// geodesic software
      elseif(preg_match('/category\/*\/+/i', $_SERVER['HTTP_REFERER'])) {
      $extract_bzone = explode('category/', $_SERVER['HTTP_REFERER']);
      $bzone = (is_numeric(substr("$extract_bzone[1]", 0, strpos($extract_bzone[1], '/')))) ? substr("$extract_bzone[1]", 0, strpos($extract_bzone[1], '/')) : preg_replace('/[^0-9]/i','', $extract_bzone[1]);
      }
      elseif (!empty($store)) {
      $bzone = "$store";
      }
      elseif (!empty($b)) {
      $bzone = "$b";
      }
// geodesic software
// 68 classifieds and meebo
      elseif(preg_match('/categories\/*\/+/i', $_SERVER['HTTP_REFERER'])) {
      $extract_bzone = explode('categories/', $_SERVER['HTTP_REFERER']);
      $bzone = substr("$extract_bzone[1]", 0, strpos($extract_bzone[1], '.'));
      }
      elseif ((!empty($type)) && (empty($sec)))  {
      $bzone = "$type";
      } elseif ((!empty($type)) && (!empty($sec)))  {
      $bzone = "$type";
      $bzone2 = "$sec";
      }
      elseif ((!empty($cat)) && (!empty($subcat))){
      $bzone = "$subcat";
      }
      elseif (!empty($cat)) {
      $bzone = "$cat";
      }
// 68 classifieds and meebo
// if no matches, try to extract by query
elseif (!empty($uri_array[path])) {
$extract_bzone = explode('/', ltrim($uri_array[path], '/'));
	if (is_numeric($extract_bzone[0])) {
/*
    	[0] => 356
    	[1] => Hand-Guns
    	[2] => 3582
    	[3] => Para-1911-Expert-45acp-2-12-9.html
*/
	$bzone = $extract_bzone[0];
	}
	elseif ((!is_numeric($extract_bzone[1])) && (is_numeric($extract_bzone[2]))) {
/*
    	[0] => Italy-regional-travel-tourist-resources
    	[1] => tip
    	[2] => 251
    	[3] => Weather-condition-forecast-in-Tuscany-and-Italy.html
*/
	$bzone = $extract_bzone[2];
	}
	elseif ((!is_numeric($extract_bzone[1])) && (is_numeric(preg_replace('/[^0-9]/i','', $extract_bzone[2])))) {
/*
   	[0] => trip
    	[1] => incoming-Italy
    	[2] => 206.htm
*/
	$bzone = preg_replace('/[^0-9]/i','', $extract_bzone[2]);
	}
}
}
if (empty($bzone)) { $bzone = "default"; }
$gborder = (empty($gborder))  ? "1px" : "$gborder" . "px";
$gpos = (empty($gpos)) ? "center" : "$gpos";
if     (($bf == "showad") || ($bfunction == "showad")) { searchads($db_link,$uid,$bzone,$bzone2,$bsize,$btype,$bpos,$btarget,$bborder,$brefresh,$dayofweek,$today,$ipaddress,$bmode,$bstyle,$gwidth,$gheight,$tborder,$cpadding,$bocolor,$bocolorlight,$bocolordark,$gborder,$gpos,$brows,$bcolumns,$gspacing,$colheight,$bexclusive,$btotal,$bsortcolumn,$banner_url_lb); }
elseif (($bf == "fetchad") || ($bfunction == "fetchad")) { fetchad($db_link,$uid,$cid,$aid,$bsize,$bzone,$atype); }
elseif (($bfunction == "clickad") || ($bf == "go")) { clickbanner($db_link,$uid,$bzone,$bsize,$btype,$bpos,$cid,$aid,$today,$ipaddress,$transferurl); }
elseif (($bf == "trackformad") || ($bfunction == "trackformad")) { click_rm_banner($db_link,$uid,$bzone,$bsize,$btype,$bpos,$campaignid,$adno,$ipaddress); }
exit(0);
function searchads($db_link,$uid,$bzone,$bzone2,$bsize,$btype,$bpos,$btarget,$bborder,$brefresh,$dayofweek,$today,$ipaddress,$bmode,$bstyle,$gwidth,$gheight,$tborder,$cpadding,$bocolor,$bocolorlight,$bocolordark,$gborder,$gpos,$brows,$bcolumns,$gspacing,$colheight,$bexclusive,$btotal,$bsortcolumn,$banner_url_lb) {
global $timestamp, $hour, $HTTP_USER_AGENT;
$ssl_enabled = detectssl();
$load_ad = false;
$format_zone = preg_replace('/[^A-Za-z0-9\-]/', '', $bzone);
$session_index_name   = "adpool-$uid-$format_zone-$bsize";
$session_index_seq    = "seq-$uid-$format_zone-$bsize";
$session_index_nextad = "nextad-$uid-$format_zone-$bsize";
$session_companion_ad = "companion-$uid";
if (($bmode == "order") && (!$_SESSION[$session_index_name]) && (!$_SESSION[$session_index_seq]) && (!$_SESSION[$session_index_nextad])) {
$preload_array = explode('|', preload_ads($db_link,$uid,$bsize,$bzone,$today,$dayofweek,$ipaddress,$bmode,$btotal));
list($load_ad['cid'],$load_ad['aid']) = explode(':', $preload_array[1]);
$_SESSION[$session_index_seq] = "$preload_array[0]";
$_SESSION[$session_index_nextad] = "2";
} elseif (($bmode == "order") && ($_SESSION[$session_index_name]) && ($_SESSION[$session_index_seq]) && ($_SESSION[$session_index_nextad])) {
$linearray = explode('-', $_SESSION[$session_index_name]);
$sess_seq = $_SESSION[$session_index_nextad];
foreach ($linearray as $value) {
list($seqno,$campaignid,$adno) = explode(':', $value);
if ($seqno == "$sess_seq") { $load_ad['cid'] = "$campaignid"; $load_ad['aid'] = "$adno"; }
}
$_SESSION[$session_index_nextad] = ($sess_seq >= $_SESSION[$session_index_seq]) ? "1" : $_SESSION[$session_index_nextad] + 1;
}
$cid_load = (isset($load_ad['cid'])) ? $load_ad['cid'] : false;
$aid_load = (isset($load_ad['aid'])) ? $load_ad['aid'] : false;
$result = mysqli_query($db_link,construct_query($db_link,$uid,$bsize,$bzone,$btype,$today,$dayofweek,1,$btotal,$cid_load,$aid_load)) or die(mysqli_error($db_link).__LINE__);
$matches = (mysqli_num_rows($result) > 0) ? mysqli_num_rows($result) : "0";
// if preloaded ad not available, clear session
if (($matches == "0") && (!empty($load_ad['cid'])) && (!empty($load_ad['aid']))) {
unset($_SESSION[$session_index_nextad]);
unset($_SESSION[$session_index_seq]);
unset($_SESSION[$session_index_name]);
}
if ($matches == "0") {
$ad_base_query  = ($bsize != "text") ? "SELECT SQL_NO_CACHE a.accno, a.campaignid, a.adno, a.ad_size, a.ad_title, a.ad_linkunder, a.ad_mouseover, a.ad_playsound, a.ad_weight, a.ad_autoweight, a.ad_banner, a.ad_type, a.remote_banner, a.ad_bannertext, a.ad_url, a.impressions, a.clicks, settings.banner_url, c.record_id ip_record_id, d.record_id stats_record_id" : "SELECT SQL_NO_CACHE a.accno, a.campaignid, a.adno, a.ad_title, a.ad_txtfont, a.ad_txtsize, a.ad_txtsetting, a.ad_mouseover, a.ad_playsound, a.ad_weight, a.ad_autoweight, a.ad_bannertext, a.ad_url, a.ad_keywords, a.impressions, a.clicks, settings.banner_url, c.record_id ip_record_id, d.record_id stats_record_id";
$ad_base_query .= (" FROM `adpeeps_ads` a LEFT JOIN `adpeeps_settings` AS settings ON a.accno=settings.accno");
$ad_base_query .= (" LEFT JOIN `adpeeps_statisticsiplog` AS c ON a.accno=c.accno AND a.campaignid=c.campaignid AND a.adno=c.adno AND c.showdate='$today' AND c.type = 'i' AND c.ipaddress='$ipaddress'");
$ad_base_query .= (" LEFT JOIN `adpeeps_statistics` AS d ON d.accno=a.accno AND d.campaignid=a.campaignid AND d.adno=a.adno AND d.index_date=a.index_date AND d.index_date = '$today' AND d.showdate BETWEEN '$today $hour:00:00' AND '$today $hour:59:59'");
$ad_base_query .= (" WHERE a.accno = '$uid' AND a.ad_default = '1' AND a.adstatus = '1' AND a.campaignstatus = '1'"); 
$ad_base_query .= ($bsize == "all") ? "AND a.ad_size != 'text'" : "AND a.ad_size='$bsize'";
$result = mysqli_query($db_link, "$ad_base_query") or die(mysqli_error($db_link).__LINE__);
$matches = (mysqli_num_rows($result) > 0) ? mysqli_num_rows($result) : "0";
if ($btype == "1" && $matches == "0") {
	echo chr(0x47).chr(0x49).chr(0x46).chr(0x38).chr(0x39).chr(0x61).chr(0x01).chr(0x00).
		     chr(0x01).chr(0x00).chr(0x80).chr(0x00).chr(0x00).chr(0x04).chr(0x02).chr(0x04).
		 	 chr(0x00).chr(0x00).chr(0x00).chr(0x21).chr(0xF9).chr(0x04).chr(0x01).chr(0x00).
		     chr(0x00).chr(0x00).chr(0x00).chr(0x2C).chr(0x00).chr(0x00).chr(0x00).chr(0x00).
		     chr(0x01).chr(0x00).chr(0x01).chr(0x00).chr(0x00).chr(0x02).chr(0x02).chr(0x44).
		     chr(0x01).chr(0x00).chr(0x3B);
}
}
if ((!empty($brows)) && ($brows > 0) && (!empty($bcolumns)) && ($bcolumns > 0)) { 
$btotal = (($brows * $bcolumns) >= $matches) ? "$matches" : ($brows * $bcolumns);
$brefresh = false;
}
elseif ((empty($btotal)) && ($brefresh >= 1) && ($btype != "4")) { $btotal = "$matches"; }
elseif ((empty($btotal)) && ($brefresh >= 1) && ($btype == "4")) { $btotal = "1"; }
elseif (empty($btotal)) { $btotal = "1"; }
/// fetch all eligible ads, randomly place in order, select all up to btotal limit
if ($matches > 0) {
$weight_array = "";
$weightlist = array();
$multiplier = array('200' => "5",'100' => "4",'50' => "3",'10' => "2",'1' => "1");
srand((double)microtime() * 1000000);
$rand_num = rand() % 1000000 . "$btotal" . "$bsize";
while($row = mysqli_fetch_assoc($result)) {
$banner_url = (empty($banner_url_lb)) ? "$row[banner_url]" : "$banner_url_lb";
$banner_url = ($ssl_enabled) ? preg_replace('/http:/i', 'https:', "$banner_url") : "$banner_url";
$aid = "$row[accno]";
$campaignid = "$row[campaignid]";
$adno = "$row[adno]";
$adsize = ($bsize != "text") ? "$row[ad_size]" : "text";
$ad_title = (isset($row['ad_title'])) ? htmlspecialchars(stripslashes($row['ad_title']), ENT_QUOTES) : false;
$ad_linkunder = (isset($row['ad_linkunder'])) ? $row['ad_linkunder'] : false;
$ad_banner = (isset($row['ad_banner'])) ? $row['ad_banner'] : false;
$ad_type = (isset($row['ad_type'])) ? $row['ad_type'] : false;
$remote_banner = ((!empty($row['remote_banner'])) && ($ssl_enabled) && (preg_match('/uploaded_banners\//', $row['remote_banner']))) ? preg_replace('/http:/i', 'https:', $row['remote_banner']) : "$row[remote_banner]";
$ad_bannertext = (isset($row['ad_bannertext'])) ? stripslashes($row['ad_bannertext']) : false;
if ($bsize == "text") {
$ad_bannertext = htmlspecialchars(str_replace("\n", "", $ad_bannertext), ENT_QUOTES);
$ad_bannertext = str_replace("\r", "<br>", $ad_bannertext);
}
$ad_txtfont = (isset($row['ad_txtfont'])) ? $row['ad_txtfont'] : false;
$ad_txtsize = (isset($row['ad_txtsize'])) ? $row['ad_txtsize'] : false;
$ad_txtsetting = (isset($row['ad_txtsetting'])) ? $row['ad_txtsetting'] : false;
$ad_displayurl = (isset($row['ad_keywords'])) ? $row['ad_keywords'] : false;
$ad_mouseover = (isset($row['ad_mouseover'])) ? addslashes($row['ad_mouseover']) : false;
$ad_playsound  = (isset($row['ad_playsound'])) ? $row['ad_playsound'] : false;
$ad_autoweight = (isset($row['ad_autoweight'])) ? $row['ad_autoweight'] : false;
$aux_flexfield = (isset($row['aux_flexfield'])) ? $row['aux_flexfield'] : false;
$ad_weight = "$row[ad_weight]";
$ad_url = (isset($row['ad_url'])) ? $row['ad_url'] : false;
$impressions = "$row[impressions]";
$clicks = "$row[clicks]";
$ad_transparent = "$row[ad_transparent]";
$ad_companion = "$row[ad_companion]";
$lastdateshown = "$row[index_date]";
$ip_stats_record_id = "$row[ip_record_id]";
$stats_record_id = "$row[stats_record_id]";
$filter_spider_robot = "$row[filter_spider_robot]";
$country_code = "$row[country_code2]";
$country_name = "$row[country_name]";
$city         = "$row[city]";
$state        = "$row[state]";
$zone_order = "$row[zone_order]";
$campanion_sort = "$row[campanion_sort]";
if (($bmode !="noweight") && (!in_array("$ad_weight", $weightlist))) { 
$weightlist[] = "$ad_weight";
$weight_array .= str_repeat("$ad_weight ", $multiplier[$ad_weight]);
}
// place all returned ads inside an array
$adlist[] = array('campanion_sort' => "$campanion_sort",'zone_sort' => "$zone_order",'ad_title' => "$ad_title",'aid' => "$aid",'campaignid' => "$campaignid",'adno' => "$adno",'adsize'  => "$adsize", 'ad_linkunder' => "$ad_linkunder", 'ad_banner' => "$ad_banner", 'ad_type' => "$ad_type", 'remote_banner' => "$remote_banner",'ad_bannertext' => "$ad_bannertext",'ad_txtfont' => "$ad_txtfont",'ad_txtsize'  => "$ad_txtsize",'ad_displayurl' => "$ad_displayurl",'ad_mouseover' => "$ad_mouseover",'ad_playsound' => "$ad_playsound",'ad_weight'  => "$ad_weight",'ad_autoweight' => "$ad_autoweight",'aux_flexfield' => "$aux_flexfield",'ad_url' => "$ad_url",'impressions' => "$impressions", 'clicks' => "$clicks", 'ad_transparent' => "$ad_transparent", 'ad_companion' => "$ad_companion", 'lastdateshown' => "$lastdateshown", 'country_code' => "$country_code", 'country_name' => "$country_name", 'city' => "$city", 'state' => "$state", 'ip_stats_record_id' => "$ip_stats_record_id", 'stats_record_id' => "$stats_record_id");
// place all eligible ads inside an array
} // end mysql while statement
mysqli_free_result($result); 
// more than one possible weight, start weighting functions
if (count($weightlist) > 1) {
unset($weightlist);
$array = explode(" ", trim($weight_array));
$pickweight = array_rand($array, 1);
sortBySubkey($adlist, false, $array[$pickweight]);
}
// more than one possible weight, start weighting functions
shuffle($adlist); // shuffle all eligible ads fecthed from database
// check for spider/rebot
if (($filter_spider_robot == "1") && (!empty($HTTP_USER_AGENT)) && (!isset($_SESSION['scheck']))) {
$robot_spider_check = mysqli_query($db_link, "SELECT ref_id FROM `adpeeps_excluded_robots` WHERE LOCATE(search_string,'$HTTP_USER_AGENT') > 0") or die(mysqli_error($db_link).__LINE__);
if (mysqli_num_rows($robot_spider_check) > 0) {
$norecord = 1;
$_SESSION['scheck'] = "1";
while($spider_row = mysqli_fetch_assoc($robot_spider_check)) {
mysqli_query($db_link, "UPDATE adpeeps_excluded_robots SET access_count = access_count+1, last_update_date = '$timestamp' WHERE ref_id = '$spider_row[ref_id]'") or die(mysqli_error($db_link).__LINE__);
}
} else {
$_SESSION['scheck'] = "0";
}
} elseif (($filter_spider_robot == "1") && (isset($_SESSION['scheck']))) {
$norecord = "$_SESSION[scheck]";
}
// check for spider/rebot
if ($bexclusive == "1") {
$array_count = count($adlist);
for($y=0; $y<$array_count; $y++) {
extract($adlist[$y], EXTR_OVERWRITE);
// place all eligible ads inside an array
$adlist_group[$campaignid] = array('ad_title' => "$ad_title",'aid' => "$aid",'campaignid' => "$campaignid",'adno' => "$adno",'adsize'  => "$adsize", 'ad_linkunder' => "$ad_linkunder", 'ad_banner' => "$ad_banner", 'ad_type' => "$ad_type", 'remote_banner' => "$remote_banner",'ad_bannertext' => "$ad_bannertext",'ad_txtfont' => "$ad_txtfont",'ad_txtsize'  => "$ad_txtsize",'ad_displayurl' => "$ad_displayurl",'ad_mouseover' => "$ad_mouseover",'ad_playsound' => "$ad_playsound",'ad_weight'  => "$ad_weight",'ad_autoweight' => "$ad_autoweight",'ad_autoweight' => "$ad_autoweight",'ad_url' => "$ad_url",'impressions' => "$impressions", 'clicks' => "$clicks", 'ad_transparent' => "$ad_transparent", 'ad_companion' => "$ad_companion", 'lastdateshown' => "$lastdateshown", 'country_code' => "$country_code", 'country_name' => "$country_name", 'city' => "$city", 'state' => "$state", 'ip_stats_record_id' => "$ip_stats_record_id", 'stats_record_id' => "$stats_record_id");
// place all eligible ads inside an array
}
unset($adlist); // delete orginial ad list array
$adlist = $adlist_group; // rename grouped array to name of original array
shuffle($adlist); // reshuffle array one last time
}
// sort text links A-Z if enabled or by zone order if using autodetect
if (!empty($bsortcolumn)) {
sortBySubkey($adlist, "$bsortcolumn", false);
} elseif (!empty($bzone2)) {
sortBySubkey($adlist, 'zone_sort', false);
} elseif (isset($_SESSION[$session_companion_ad])) {
sortBySubkey($adlist, 'campanion_sort', false);
}
$matches = (count($adlist) >= $btotal) ? "$btotal" : count($adlist);
static $print_once = false; 
$order = 0;
for ($i = 0; $i < $matches && $i < $btotal; ++$i) {
extract($adlist[$i], EXTR_OVERWRITE);
++$order;
if ((!isset($_SESSION[$session_companion_ad])) && ($ad_companion == "Y")) {
$_SESSION[$session_companion_ad]  = array('campaignid' => "$campaignid", 'expires' => time()+5);
} 
$ads[$order] = showbanner($db_link,$uid,$bzone,$adsize,$btype,$bpos,$btarget,$bborder,$brefresh,$dayofweek,$today,$banner_url,$ipaddress,$bmode,$bstyle,$gwidth,$gheight,$gborder,$gpos,$campaignid,$adno,$ad_title,$ad_linkunder,$ad_banner,$ad_type,$remote_banner,$ad_bannertext,$ad_url,$ad_txtfont,$ad_txtsize,$ad_txtsetting,$ad_displayurl,$ad_mouseover,$ad_playsound,$ad_transparent,$order,$matches,$rand_num,$country_code,$country_name,$city,$state);
if ($norecord != "1") { record_data($db_link,$uid,$ipaddress,$bzone,$bsize,$btype,$bpos,$campaignid,$adno,$ad_url,'impression',$ad_weight,$ad_autoweight,$impressions,$clicks,$lastdateshown,$ip_stats_record_id,$stats_record_id,$country_code,$country_name,$city,$state,$order,$matches); }
} # Close FOR Loops
unset($adlist);
$ini_adcount = 0;
// If showing ads in columns/rows this code will create the table template and store value in $html_out 
if ((!empty($brows)) && ($brows > 0) && (!empty($bcolumns)) && ($bcolumns > 0)) { 
$html_out .= "<div align=\"$gpos\"><table";
if (!empty($gwidth)) { $html_out .= " width=\"$gwidth\""; }
if (!empty($gheight)) { $html_out .= " height=\"$gheight\""; }
if (!empty($bocolor)) { $html_out .= " bordercolor=\"#$bocolor\""; }
if (!empty($bocolorlight)) { $html_out .= " bordercolorlight=\"#$bocolorlight\""; }
if (!empty($bocolordark)) { $html_out .= " bordercolordark=\"#$bocolordark\""; }
$html_out .= " border=\"$tborder\" cellspacing=\"$gspacing\" cellpadding=\"$cpadding\">";
$bcolumns = ($brows == "1") ? "$btotal" : "$bcolumns";
// Create Rows for Table
	for ($r = 1; $r <= $brows; $r++) {
	$html_out .= "<tr>";
// Create Columns for Table
		for ($c = 1; $c <= $bcolumns;$c++) {
	        ++$ini_adcount;
		$html_out .= "<td";
		if (!empty($colheight)) {
		$html_out .= " height=\"$colheight\"";
		}
		$html_out .= ">$ads[$ini_adcount]</td>";
		}     
	$html_out .= "</tr>";
	}
$html_out .= "</table></div>";
} 
// Otherwise, this section will merge the $ads array into $html_out to be used by the output_ad_html function  
else {
foreach ($ads as $htmlvalue) {
$html_out .= "$htmlvalue";
}
}
echo output_ad_html($btype,trim($html_out));
if (((!isset($_COOKIE["geolocserv"])) || ($_COOKIE[geolocserv] == "--")) && (!empty($country_code))) {
$domain = "." . preg_replace('/^[^\.]*\.([^\.]*)\.(.*)$/', '/\1.\2/',$_SERVER['HTTP_HOST']);
setcookie("geolocserv", "$country_code|$country_name|$city|$state", time()+60*60*24*90, '/', "", 0); 
} elseif (!isset($_COOKIE["geolocserv"])) {
setcookie("geolocserv", "--"); 
}
unset($html_out);
unset($ads);
} # Close If Matchs > 1 
} # Close Function
function showbanner($db_link,$uid,$bzone,$bsize,$btype,$bpos,$btarget,$bborder,$brefresh,$dayofweek,$today,$banner_url,$ipaddress,$bmode,$bstyle,$gwidth,$gheight,$gborder,$gpos,$campaignid,$adno,$ad_title,$ad_linkunder,$ad_banner,$ad_type,$remote_banner,$ad_bannertext,$ad_url,$ad_txtfont,$ad_txtsize,$ad_txtsetting,$ad_displayurl,$ad_mouseover,$ad_playsound,$ad_transparent,$order,$matches,$rand_num,$country_code,$country_name,$city,$state) {
global $theme_border, $theme_borderstyle, $theme_background, $theme_color, $tagline, $tagline_bgcolor, $tagline_fontcolor, $tagline_font, $tcolor, $textcolor, $lcolor, $colwidth, $colheight, $print_once;
if ($order == "1") {
$html_out = false;
}
// pick random theme
if (empty($theme_border) || empty($theme_borderstyle) || empty($theme_background)) {
$theme_border = array("#ffcc33","#b4b0dc","#a8dda0","#8d8d8d");
$theme_borderstyle = array("solid","solid","solid","dotted");
$theme_background = array("#fcf9d7","#ecf8ff","#FFFF66","#eeeee5");
$theme_color = array("#616161","#616161","#616161","#000000");
$theme_count = count($theme_border);
}
$themeset = rand(0,$theme_count - 1);
$google_border = $theme_border[$themeset];
$google_background = $theme_background[$themeset];
$google_color = $theme_color[$themeset];
$google_style = $theme_borderstyle[$themeset];
// pick random theme
$transparent = ($ad_transparent == "1") ? "transparent" : false;
if ($bsize != "text") { 
// ini flash link
$movie_url  = (!empty($remote_banner)) ? "$remote_banner" : "$banner_url" . "/adpeeps.php?bf=fetchad&uid=$uid&cid=$campaignid&aid=$adno&atype=1&bzone=$bzone&bsize=$bsize";
$movie_url .= (strrchr(strtolower($movie_url),'.') == ".swf") ? "?" : "&";
	if ((!empty($ad_url)) && (substr(strtolower("$ad_url"), 0, 9) == "clicktag=")) {
		$movie_url .= substr("$ad_url", 0, 9) . "$banner_url" . "/adpeeps.php" . "%3F" . "bf=go%26uid=$uid%26bzone=$bzone%26bsize=$bsize%26btype=$btype%26bpos=$bpos%26cid=$campaignid%26aid=$adno";
	} elseif (!empty($ad_url)) {
		$movie_url .=  "clickTAG=" . "$banner_url" . "/adpeeps.php" . "%3F" . "bf=go%26uid=$uid%26bzone=$bzone%26bsize=$bsize%26btype=$btype%26bpos=$bpos%26cid=$campaignid%26aid=$adno";
	}
// ini flash link
list($w,$h)  = explode('x',$bsize);
}
/////////////////////// display actual ad ///////////////
// 1 = regular banner via standard image tags
// 2 = php/ssi tags
// 3 = javascript
// 4 = iframe
# Standard Image
if ($btype == "1") {
	if (empty($remote_banner)) { 
	header("Content-type: image/gif");
	header("Content-Disposition: inline; filename=".md5(microtime()).";");
	echo "$ad_banner"; 
	} else {
	$remote_banner = (preg_match('/uploaded_banners\//', $remote_banner)) ? "uploaded_banners/" . substr($remote_banner, strrpos($remote_banner,'/')+1,strlen($remote_banner)-strrpos($remote_banner,'/')) : "$remote_banner";
	readfile("$remote_banner");
	}
} 
# All Other Types (SSI,PHP,JAVA,IFRAME)
else {
	if ($btype == "4") {
	$refresh_seconds = $brefresh * 1000;
	$randnum = rand() % 1000000;
	echo ("<html>\n<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
\n<title>Ad Peeps Banner Management Software</title>
	<link rel="canonical" href="https://www.wheelbasemag.com/adpeeps/adpeeps_bfunction-go-uid-100000-bmode-off-bzone-footer-bsize-600x100-btype-1-bpos-default-ver-2_0/" />
\n");
	if (is_numeric($brefresh)) { echo ("<script>setTimeout(\"</script>\n"); }
	echo ("</head>\n<body>\n");
	}
	if (($btype <> '4') && ($matches > 1) && ($brefresh >= 1)) {
	$num = $order - 1;
	if ($order == "1") {
	if ($btype == "2") {
	echo ("<ilayer id=\"l1_" . $rand_num . "\" align=\"$gpos\"><layer id=\"l2_" . $rand_num . "\" align=\"$gpos\"><div id=\"l1_" . $rand_num . "\" align=\"$gpos\"><div id=\"l3_" . $rand_num . "\" style=\"position:relative\" align=\"$gpos\"></div></div></layer></ilayer>\n");
print <<< END
	<script type="text/javascript">
	<!--
END;
	} else {
	echo ("document.write('<html><head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<title>Ad Peeps Ad Engine</title></head><body>');\n");
	echo ("document.write('<ilayer id=\"l1_" . $rand_num . "\" align=\"$gpos\"><layer id=\"l2_" . $rand_num . "\" align=\"$gpos\"><div id=\"l1_" . $rand_num . "\" align=\"$gpos\"><div id=\"l3_" . $rand_num . "\" style=\"position:relative\" align=\"$gpos\">.</div></div></layer></ilayer>');\n");
	}
	echo ("var bannerArray_" . $rand_num . "= new Array();");
	echo ("var myCount_" . $rand_num . "=0;");
	}
	}
    	// Text Ad
        if ($bsize == "text") {
        $html_out .= "<div align=\"$gpos\">\n";
        if ($bstyle == "yahoo") {
        $html_out .= "<li><font face=\"$ad_txtfont\" size=\"$ad_txtsize\">";
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "<strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "<em>"; }
        if (!empty($ad_url)) {
        $html_out .= "<a rel=\"nofollow\" style=\"color:$tcolor; text-decoration:underline;\" href=\"$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype\"";
        if (!empty($ad_mouseover)) {
        $html_out .= "onMouseover=\"window.status=\'$ad_mouseover\'; return true;\" onMouseout=\"window.status=\'\'; return true;\"";
        }
        $html_out .= " target=\"$btarget\">";
        }
        $html_out .= "$ad_title";
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "</strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "</em>"; }
        $html_out .= "</font>";
        if (!empty($ad_url)) { $html_out .= "</a>"; }
        if (!empty($ad_bannertext)) { $html_out .= "<br><font color=\"$textcolor\"><small>$ad_bannertext</small></font>"; }
        if (!empty($ad_url)) {
        if (!empty($ad_displayurl)) {  $displayurl = "$ad_displayurl"; }
        else { $displayurl = str_replace(" ", "+", urldecode($ad_url)); }
        $html_out .= "<br><font color=\"#$lcolor\"><small>$displayurl</small></font>";
        }
        $html_out .= "</li>";
        }
        elseif ($bstyle == "google-tall") {
        $gwidth = (empty($gwidth)) ? "120" : "$gwidth";
        $gheight = (empty($gheight)) ? "0" : "$gheight";
        if ($order == "1") {
        $html_out .= "<table border=\"$bborder\" width=\"$gwidth\" ";
        if (!empty($gheight)) {
        $html_out .= "height=\"$gheight\" ";
        }
        $html_out .= "cellspacing=\"0\" cellpadding=\"2\" bordercolordark=\"#336699\" bordercolorlight=\"#336699\">\n";
        }
        $html_out .= "<tr><td style=\"cursor:pointer;\" valign=\"top\" width=\"$gwidth\" ";
        if (!empty($colheight)) {
        $html_out .= "height=\"$colheight\" ";
        }
        if (!empty($ad_url)) {
        if ($btarget == "_blank") {
        $html_out .= " onclick=\"window.open(&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;)\"";
        }else {
        $html_out .= " onclick=\"window.location.href=&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;\"";
        }
        }
        $html_out .= " onmouseover=\"this.style.cursor=\'pointer\';window.status=\'$ad_mouseover\'; return true;\" onMouseOut=\"this.style.cursor=\'auto\';window.status=\'\';return true;\">";
        $html_out .= "<font face=\"$ad_txtfont\" size=\"$ad_txtsize\" color=\"#$tcolor\">";
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "<strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "<em>"; }
        if (!empty($ad_url)) { $html_out .= "<u>"; } 
        $html_out .= "$ad_title";
        if (!empty($ad_url)) { $html_out .= "</u>"; }
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "</strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "</em>"; }
        $html_out .= "</font><br><font face=\"Arial\" size=\"2\" color=\"$textcolor\">$ad_bannertext</font>";
        if (!empty($ad_url)) {
        if (!empty($ad_displayurl)) {  $displayurl = "$ad_displayurl"; }
        else { $displayurl = str_replace(" ", "+", urldecode($ad_url)); }
        $html_out .= "<br><font face=\"Arial\" color=\"#$lcolor\" size=\"1\">$displayurl</font>";
        }
        $html_out .= "<br></td></tr>\n";
        if ($order == "$matches") { $html_out .= "</table>\n"; }
        }
        elseif ($bstyle == "google-short") {
        $gwidth = (empty($gwidth)) ? "728" : "$gwidth";
        $gheight = (empty($gheight)) ? "76" : "$gheight";
        if ($order == "1") {
        $html_out .= "<table border=\"$bborder\" width=\"$gwidth\" height=\"$gheight\" cellspacing=\"0\" bordercolordark=\"#336699\" bordercolorlight=\"#336699\" cellpadding=\"2\"><tr valign=\"top\">\n";
        }
        $html_out .= "<td ";
        if (!empty($colwidth)) { $html_out .= "width=\"$colwidth\" "; }
        $html_out .= "height=\"$gheight\" bordercolorlight=\"#336699\" bordercolordark=\"#FFFFFF\" bordercolor=\"#336699\"";
        if (!empty($ad_url)) {
        if ($btarget == "_blank") {
        $html_out .= "onclick=\"window.open(&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;)\"";
        } else {
        $html_out .= " onclick=\"window.location.href=&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;\"";
        }
        }
        $html_out .= " onMouseOver=\"this.style.cursor=\'pointer\';window.status=\'$ad_mouseover\'; return true;\" onMouseOut=\"this.style.cursor=\'auto\';window.status=\'\';return true;\">";
        $html_out .= "<font face=\"$ad_txtfont\" size=\"$ad_txtsize\" color=\"#$tcolor\">";
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "<strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "<em>"; }
        if (!empty($ad_url)) { $html_out .= "<u>"; }
        $html_out .= "$ad_title";
        if (!empty($ad_url)) { $html_out .= "</u>"; }
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "</strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "</em>"; }
        $html_out .= "</font><br><font size=\"1\" face=\"Tahoma\" color=\"$textcolor\">$ad_bannertext";
        if ((!empty($ad_url)) && (!empty($ad_displayurl))) {
        $html_out .= "<br><font color=\"#$lcolor\"><small>$ad_displayurl</small></font>";
        }
        $html_out .= "</font></td>\n";
        if ($order == "$matches") {
        $html_out .= "</tr></table>\n";
        $html_out .= "<table width=\"$gwidth\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr valign=\"top\" bgcolor=\"#$tagline_bgcolor\"><td align=\"right\"><font color=\"#$tagline_fontcolor\" size=\"1\" face=\"$tagline_font\">$tagline</font></td></tr></table>\n";
        }
        }
        elseif ($bstyle == "google") {
        $colwidth = (empty($colwidth)) ? "100%" : "$colwidth";
        $html_out .= "<table style=\"border-width:$gborder; border-style:$google_style; color:$google_color; background-color:$google_background; border-color:$google_border; text-align:left;";
        if (!empty($colwidth)) { $html_out .= " width:$colwidth;"; }
        if (!empty($colheight)) { $html_out .= " height:$colheight;"; }
        $html_out .= "\"";
        if (!empty($colwidth)) { $html_out .= " width=\"$colwidth\""; }
        if (!empty($colheight)) { $html_out .= " height=\"$colheight\""; }
        $html_out .= " cellpadding=\"2\" cellspacing=\"0\" rules=\"none\"";
        if (getbrowser() == "3") {
        $html_out .= " frame=\"void\"";
        }
        $html_out .= ">";
        $html_out .= "<tr><td style=\"cursor:pointer; text-align:left;\">";
        $html_out .= "<font color=\"$textcolor\" face=\"$ad_txtfont\" size=\"$ad_txtsize\">";
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "<strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "<em>"; }
        if (!empty($ad_url)) {
        $html_out .= "<a rel=\"nofollow\" style=\"color:$tcolor; text-decoration:underline;\" href=\"$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype\"";
        if (!empty($ad_mouseover)){ 
        $html_out .= " onMouseOver=\"this.style.cursor=\'pointer\';window.status=\'$ad_mouseover\'; return true;\" onMouseOut=\"this.style.cursor=\'auto\';window.status=\'\'; return true;\"";
        }
        $html_out .= " target=\"$btarget\">";
        }
        $html_out .= "$ad_title";
        if (!empty($ad_url)) { $html_out .= "</a>"; }
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "</strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "</em>"; }
        $html_out .= "</font>";
        $html_out .= "</td></tr>";
        if (!empty($ad_bannertext)) {
        $html_out .= "<tr><td style=\"cursor:pointer; font:11px verdana, tahoma; text-align:left; color:$textcolor;\"";
        if (!empty($ad_mouseover)) { 
        $html_out .= " onMouseOver=\"this.style.cursor=\'pointer\';window.status=\'$ad_mouseover\'; return true;\" onMouseOut=\"this.style.cursor=\'auto\';window.status=\'\';return true;\"";
        }
        if (!empty($ad_url)) {
        if ($btarget == "_blank") {
        $html_out .= " onclick=\"window.open(&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;)\"";
        }else {
        $html_out .= " onclick=\"window.location.href=&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;\"";
        }
        }
        $html_out .= ">$ad_bannertext</td></tr>";
        }
        if (!empty($ad_url)) {
        $html_out .= "<tr><td style=\"cursor:pointer; font:11px verdana, tahoma; text-align:left; color:$lcolor;\"";
        if ($btarget == "_blank") {
        $html_out .= " onclick=\"window.open(&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;)\"";
        }else {
        $html_out .= " onclick=\"window.location.href=&#39;$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&#39;\"";
        }
        }
        if (!empty($ad_url)) {
        if (!empty($ad_mouseover)) { 
        $html_out .= " onMouseOver=\"this.style.cursor=\'pointer\';window.status=\'$ad_mouseover\'; return true;\" onMouseOut=\"this.style.cursor=\'auto\';window.status=\'\';return true;\"";
        }
        if (!empty($ad_displayurl)) {  $displayurl = "$ad_displayurl"; }
        else { $displayurl = str_replace(" ", "+", urldecode($ad_url)); }
        $html_out .= ">$displayurl";
        $html_out .= "</td></tr>";
        }
        $html_out .= "</table>";
        }
        // Standard Text Link
        else {
        $html_out .= "<font color=\"$textcolor\" face=\"$ad_txtfont\" size=\"$ad_txtsize\">";
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "<strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "<em>"; }
        if (!empty($ad_url)) {
        $html_out .= "<a rel=\"nofollow\" style=\"color:$tcolor;\" href=\"$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype\"";
        if (!empty($ad_mouseover))  { 
        $html_out .= "onMouseover=\"window.status=\'$ad_mouseover\'; return true;\" onMouseout=\"window.status=\'\'; return true;\"";
        }
        $html_out .= " target=\"$btarget\">";
        }
        $html_out .= "$ad_title";
        if (!empty($ad_url)) { $html_out .= "</a>"; }
        if (($ad_txtsetting == "1") || ($ad_txtsetting == "3")) { $html_out .= "</strong>"; }
        if (($ad_txtsetting == "2") || ($ad_txtsetting == "3")) { $html_out .= "</em>"; }
        $html_out .= "</font>\n";
        if (!empty($ad_bannertext)) { $html_out .= "<br><font color =\"$textcolor\" size=\"$ad_txtsize\">$ad_bannertext</font>\n"; }
        }
        $html_out .= "</div>\n";
        }
        // Text Ad
	// Rich-Media
	elseif (($bsize != "text") && (!empty($ad_bannertext))) {
   	$randnum = rand() % 1000000;
	$ad_bannertext = preg_replace("/<rand>/i", "$randnum", $ad_bannertext);
	$ad_bannertext = preg_replace("/<country_code>/i", "$country_code", $ad_bannertext);
	$ad_bannertext = preg_replace("/<country>/i", "$country_name", $ad_bannertext);
	$ad_bannertext = preg_replace("/<state_region>/i", "$state", $ad_bannertext);
	$ad_bannertext = preg_replace("/<city_territory>/i", "$city", $ad_bannertext);
	$ad_bannertext = preg_replace("/<ratespagelink>/i", "<url>" . urlencode("$banner_url/index.php?loc=view_adrates&uid=$uid&zone_override=$bzone"), $ad_bannertext);
	if ((($btype == "2") || ($btype == "3")) && (preg_match ("/<errorcorrect>/i", "$ad_bannertext"))) {
	$html_out .= "<IFRAME SRC=\"$banner_url/adpeeps.php?bf=fetchad&uid=$uid&cid=$campaignid&aid=$adno&atype=2&bzone=$bzone&bsize=$bsize\" WIDTH=\"$w\" HEIGHT=\"$h\" style=\"FILTER: chroma(color=#FFFFFF)\" allowtransparency=\"true\" SCROLLING=\"no\" MARGINHEIGHT=\"0\" MARGINWIDTH=\"0\" FRAMEBORDER=\"0\">\n";
	$html_out .= "<ILAYER SRC=\"$banner_url/adpeeps.php?bf=fetchad&uid=$uid&cid=$campaignid&aid=$adno&atype=2&bzone=$bzone&bsize=$bsize\" WIDTH=\"$w\" HEIGHT=\"$h\" style=\"FILTER: chroma(color=#FFFFFF)\" allowtransparency=\"true\"></ILAYER></IFRAME>\n";
	}
	elseif ((preg_match ("/<script/i", "$ad_bannertext")) && (!preg_match ("/google_ad_client/i", "$ad_bannertext"))) {
	$array = explode("\n", $ad_bannertext);
	foreach ($array as $rich_line) {
	$rich_line = trim($rich_line);
	if (!empty($rich_line)) { $html_out .= "$rich_line\n"; }
	}
	} else {
	$ad_bannertext = str_replace("<!--", "", $ad_bannertext);
	$ad_bannertext = str_replace("//-->", "", $ad_bannertext);
	$ad_bannertext = str_replace("!-->", "", $ad_bannertext);
	$ad_bannertext = str_replace("'", "\"", $ad_bannertext);
	$ad_bannertext = preg_replace('/\s+/',' ',$ad_bannertext);
	$ad_bannertext = preg_replace("/<url>/i", "$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype&transferurl=", $ad_bannertext);
	if (preg_match('/<formtrack>/', $ad_bannertext)) {
	$ad_bannertext = preg_replace("/<formtrack>/i", "onSubmit=\"Preload(\'$banner_url/adpeeps.php?bf=trackformad&uid=$uid&bzone=$bzone&bsize=$bsize&btype=$btype&bpos=$bpos&campaignid=$campaignid&adno=$adno&ran=$randnum\');\"", $ad_bannertext);
	echo ("var arImages=new Array();\n");
	echo ("function Preload() {\n");
	echo ("var temp = Preload.arguments;\n");
	echo ("for(x=0; x < temp.length; x++) {\n");
	echo ("arImages[x]=new Image();\n");
	echo ("arImages[x].src=Preload.arguments[x];\n");
	echo ("}\n");
	echo ("}\n");
	}
	$ad_bannertext = preg_replace("/<errorcorrect>/i", "", $ad_bannertext);
	$html_out .= preg_replace("/\r\n|\n|\r|\t/","",$ad_bannertext);
	}
	if ((!empty($ad_title)) && ($ad_linkunder == "1")) { 
	$html_out .= "<br>\n";
	if (!empty($ad_url)) {
	$html_out .= "<a rel=\"nofollow\" href=\"$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype\"";
       	if (!empty($ad_mouseover)) { $html_out .= " onMouseover=\"window.status=\'$ad_mouseover\'; return true\" onMouseout=\"window.status=\'\'; return true\""; }
	$html_out .= " target=\"$btarget\">";
	}
	$html_out .= "$ad_title";
	if (!empty($ad_url)) { $html_out .= "</a>"; }
	}
	}
	// Rich-Media
        // FLASH AD - Local
    elseif (($bsize != "text") && (empty($ad_bannertext)) && ($ad_type == "application/x-shockwave-flash")) {
if (($print_once == false) && ($btype <> '4')){
    // prevents IE activate activex warning
print <<< END
    objects = document.getElementsByTagName("object");
    for (var i = 0; i < objects.length; i++)
    {
    objects[i].outerHTML = objects[i].outerHTML;
    }
END;
$print_once = true;
}
    $html_out .= "<div align=\"$gpos\">";
    $html_out .= "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0\">";
    $html_out .= "<param name=\"movie\" value=\"$movie_url\">";
    $html_out .= "<param name=\"quality\" value=\"high\">";
    $html_out .= "<param name=\"allowScriptAccess\" value=\"always\">";
    if (!empty($transparent)) {
    $html_out .= "<param name=\"wmode\" value=\"$transparent\">";
    }
    $html_out .= "<embed src=\"$movie_url\" WMODE=\"$transparent\" allowScriptAccess=\"always\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" style=\"width:$w" . "px; height:" . "$h" . "px;max-width:100% !important; height: auto !important; max-height: $h" . "px; display: block !important;\"></embed></object>";
    if ((!empty($ad_title)) && ($ad_linkunder == "1")) { 
    $html_out .= "<br>";
    if (!empty($ad_url)) {
    $html_out .= "<a rel=\"nofollow\" href=\"$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype\"";
    if (!empty($ad_mouseover)) { $html_out .= " onMouseover=\"window.status=\'$ad_mouseover\'; return true;\" onMouseout=\"window.status=\'\'; return true;\""; }
    $html_out .= " target=\"$btarget\">";
    }
    $html_out .= "$ad_title";
    if (!empty($ad_url)) { $html_out .= "</a>"; }
    }
    $html_out .= "</div>";
    }
        // FLASH AD - Local
    	// Regular GIF/JPG/PNG
    else {
    $html_out .= "<div align=\"$gpos\">\n";
    if (!empty($ad_url)) {
    $html_out .= "<a rel=\"nofollow\" href=\"$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype\"";
    if (!empty($ad_mouseover)) { 
    $html_out .= " onMouseover=\"window.status=\'$ad_mouseover\'; return true;\" onMouseout=\"window.status=\'\'; return true;\"";
    }
    $html_out .= " target=\"$btarget\">\n";
    }
    if (empty($remote_banner)) {
    $html_out .= "<img src=\"$banner_url/adpeeps.php?bf=fetchad&uid=$uid&cid=$campaignid&aid=$adno&atype=1&bzone=$bzone&bsize=$bsize\"";
    if (!empty($ad_title)) { $html_out .= " alt=\"$ad_title\" title=\"$ad_title\""; }
    $html_out .= " border=\"$bborder\" style=\"width:$w" . "px; height:" . "$h" . "px;max-width:100% !important; height: auto !important; max-height: $h" . "px; display: block !important;\">\n"; 
    } else { 
    $html_out .= "<img src=\"$remote_banner\"";
    if (!empty($ad_title)) { $html_out .= " alt=\"$ad_title\" title=\"$ad_title\""; }
    $html_out .= " border=\"$bborder\" style=\"width:$w" . "px; height:" . "$h" . "px;max-width:100% !important; height: auto !important; max-height: $h" . "px; display: block !important;\">\n"; 
    }
    if (!empty($ad_url)) { $html_out .= "</a>\n"; }
    if ((!empty($ad_title)) && ($ad_linkunder == "1")) { 
    $html_out .= "<br>";
    if (!empty($ad_url)) {
    $html_out .= "<a rel=\"nofollow\" href=\"$banner_url/adpeeps.php?bf=go&uid=$uid&cid=$campaignid&aid=$adno&bzone=$bzone&btype=$btype\"";
    if (!empty($ad_mouseover)) { $html_out .= " onMouseover=\"window.status=\'$ad_mouseover\'; return true;\" onMouseout=\"window.status=\'\'; return true;\""; }
    $html_out .= " target=\"$btarget\">";
    }
    $html_out .= "$ad_title";
    if (!empty($ad_url)) { $html_out .= "</a>"; }
    }
    $html_out .= "</div>";
    }
    	// Regular GIF/JPG/PNG
if (($btype <> '4') && ($matches > 1) && ($brefresh >= 1)) {
echo "\nbannerArray_" . $rand_num . "[$num] = '" . preg_replace("/\r\n|\n|\r|\t/","",$html_out) . "';\n"; // Close javascript syntax
	if ($order == "$matches") {
	$refresh_seconds = $brefresh * 1000;
$ct_var_name = "myCount_" . "$rand_num";
$banner_var_name = "bannerArray_" . "$rand_num" . "[myCount_" . "$rand_num" . "]";
print <<< END
bannerRotate_$rand_num();
function bannerRotate_$rand_num() {
if($ct_var_name > bannerArray_$rand_num.length-1){ $ct_var_name=0;}
// Write out rotation
if (document.getElementById){ // IE or FF
document.getElementById('l3_$rand_num').innerHTML=$banner_var_name;
}
else if (document.layers){	// it is NN
document.layers.l1_$rand_num.document.layers.l2_$rand_num.document.open();
document.layers.l1_$rand_num.document.layers.l2_$rand_num.document.write($banner_var_name);
document.layers.l1_$rand_num.document.layers.l2_$rand_num.document.close();
}
setTimeout("bannerRotate_$rand_num()", $refresh_seconds);
$ct_var_name++;
}
END;
if ($btype == "2") { 
print <<< END
//-->
</script>
END;
} else {
echo ("\ndocument.write('</body></html>');");
}
}
}
// IFRAME/Flash with code to prevent IE Warning
elseif (($bsize != "text") && (empty($ad_bannertext)) && ($ad_type == "application/x-shockwave-flash") && ($btype == "4")) { 
print <<< END
<script type="text/javascript" src="iepatch.js"></script>
	<script type="text/javascript">
	var source = '$html_out';
	write(source);
	</script>
END;
if ($btype == "4") { echo ("</body></html>"); }
} 
// IFRAME/Flash with code to prevent IE Warning
else {
if ($btype == "4") { $html_out .= "</body></html>"; }
return "$html_out";
}
}
}
function output_ad_html($btype,$src_html) {
$formatted_html = FALSE;
if (($btype == "3") && (!empty($src_html))) {
$array = explode("\n", $src_html);
	foreach ($array as $js_line) {
	$js_line = addslashes(trim($js_line));
	$formatted_html .= ("document.write('$js_line');\n");
	}
} else {
$formatted_html = "$src_html";
}
return "$formatted_html";
}
function preload_ads($db_link,$uid,$bsize,$bzone,$today,$dayofweek,$ipaddress,$bmode,$btotal) {
$format_zone = preg_replace('/[^A-Za-z0-9\-]/', '', $bzone);
$session_index_name = "adpool-$uid-$format_zone-$bsize";
$result = mysqli_query($db_link, construct_query($db_link,$uid,$bsize,$bzone,$btype,$today,$dayofweek,2,$btotal,'','')) or die(mysqli_error($db_link).__LINE__);
$seq = 0;
while ($row = mysqli_fetch_array($result)) {
++$seq;
if ($seq == "1") { $startingad = "$row[campaignid]:$row[adno]"; }
$adorder .= "$seq:$row[campaignid]:$row[adno]-";
}
$adorder = substr($adorder, 0, -1);
if (!empty($adorder)) { 
$_SESSION[$session_index_name] = "$adorder";
}
return "$seq|$startingad";
}
function construct_query($db_link,$uid,$bsize,$bzone,$btype,$today,$dayofweek,$mode,$btotal,$cid,$aid) {
global $bstyle, $hour, $minute, $domain, $ipaddress, $bzone2, $timestamp;
$parsed = (isset($_SERVER['HTTP_REFERER'])) ? parse_url($_SERVER['HTTP_REFERER']) : false;
$referring_url = (isset($parsed['host'])) ? str_replace("www.", "", "$parsed[host]") : false;
$domain = (empty($domain)) ? "none" : "$domain";
$domainname = (empty($referring_url)) ? "$domain" : "$referring_url";
$btotal = (empty($btotal)) ? "1" : "$btotal";
$session_companion_ad = "companion-" . "$uid";
$session_companion = (empty($_SESSION[$session_companion_ad]["campaignid"])) ? "0" : $_SESSION[$session_companion_ad]['campaignid'];
if ((isset($_SESSION[$session_companion_ad])) && (time() >= $_SESSION[$session_companion_ad]['expires'])) {
$session_companion = "0";
unset($_SESSION[$session_companion_ad]);
}
if ($mode == "1") {
// get account-specific variables
$result = mysqli_query($db_link, "SELECT global_settings.banner_url, global_settings.geo_dbase, IF((matchgeo.ref_id IS NOT NULL AND global_settings.geo_dbase = 'Y'), 'Y', 'N') as include_geo_db, global_settings.last_optimized FROM `adpeeps_settings` AS global_settings LEFT JOIN adpeeps_matchtargeting_geo AS matchgeo ON matchgeo.accno = '$uid' WHERE global_settings.accno = '100000' LIMIT 1") or die(mysqli_error($db_link).__LINE__); 
$row = mysqli_fetch_array($result);
$banner_url = "$row[banner_url]";
$geo_dbase = "$row[geo_dbase]";
$include_geo_db = "$row[include_geo_db]";
// get account-specific variables
if (strtotime($timestamp)-strtotime("$row[last_optimized]") >= 21600) {
mysqli_query($db_link, "UPDATE adpeeps_settings SET last_optimized = '$timestamp' WHERE accno = '100000'") or die(mysqli_error($db_link).__LINE__);
include("auto_cron.php");
}
if (($geo_dbase == "Y") && (!isset($_COOKIE["geolocserv"]))) {
include("geodb/geoipcity.inc");
include("geodb/geoipregionvars.php");
	$gi = geoip_open("geodb/GeoIPCity.dat",GEOIP_STANDARD);
	$record = geoip_record_by_addr($gi,"$ipaddress");
	$country_code = strtoupper(mysqli_real_escape_string($db_link,"$record->country_code"));
	$country_name = strtoupper(mysqli_real_escape_string($db_link,"$record->country_name"));
	$state_full = $GEOIP_REGION_NAME[$record->country_code][$record->region];
	$state = strtoupper(mysqli_real_escape_string($db_link,"$state_full"));
	$city = strtoupper(mysqli_real_escape_string($db_link,"$record->city"));
	geoip_close($gi);
} 
elseif (($geo_dbase == "Y") && (isset($_COOKIE["geolocserv"])) && ($_COOKIE[geolocserv] != "--")) {
list($country_code,$country_name,$city,$state) = explode('|', $_COOKIE[geolocserv]);
$country_code = strtoupper(mysqli_real_escape_string($db_link,"$country_code"));
$country_name = strtoupper(mysqli_real_escape_string($db_link,"$country_name"));
$state = strtoupper(mysqli_real_escape_string($db_link,"$state"));
$city = strtoupper(mysqli_real_escape_string($db_link,"$city"));
} else {
$country_code = "--";
}
if ($btype == "1") { $get_ad = "a.ad_banner,"; } else { $get_ad = false; }
$ad_base_query  = ($bsize != "text") ? "select HIGH_PRIORITY SQL_NO_CACHE IF(a.campaignid = '$session_companion' AND a.ad_companion = 'Y','1','2') as campanion_sort, IF(match_targeting.targetzone = '$bzone','1','2') as zone_order, a.accno, a.campaignid, a.adno, a.ad_size, a.ad_title, a.ad_linkunder, a.ad_mouseover, a.ad_playsound, a.ad_weight, a.ad_autoweight, $get_ad a.aux_flexfield, a.ad_type, a.remote_banner, a.ad_bannertext, a.ad_url, a.impressions, a.clicks, a.ad_transparent, a.ad_companion, a.index_date, c.record_id ip_record_id, d.record_id stats_record_id, '$banner_url' as banner_url, '$country_code' as country_code2, '$country_name' as country_name, '$city' as city, '$state' as state, settings.filter_spider_robot" : "select HIGH_PRIORITY SQL_NO_CACHE IF(a.campaignid = '$session_companion' AND a.ad_companion = 'Y','1','2') as campanion_sort, IF(match_targeting.targetzone = '$bzone','1','2') as zone_order, a.accno, a.campaignid, a.adno, a.ad_title, a.ad_txtfont, a.ad_txtsize, a.ad_txtsetting, a.ad_mouseover, a.ad_playsound, a.ad_weight, a.ad_autoweight, a.aux_flexfield, a.ad_bannertext, a.ad_url, a.ad_keywords, a.impressions, a.clicks, a.ad_companion, a.index_date, c.record_id ip_record_id, d.record_id stats_record_id, '$banner_url' as banner_url, '$country_code' as country_code2, '$country_name' as country_name, '$city' as city, '$state' as state, settings.filter_spider_robot"; 
$ad_base_query .= (" FROM `adpeeps_ads` AS a LEFT JOIN adpeeps_statisticsiplog AS c ON a.accno=c.accno AND a.campaignid=c.campaignid AND a.adno=c.adno AND c.showdate='$today' AND c.type = 'i' AND c.ipaddress='$ipaddress'");
$ad_base_query .= (" LEFT JOIN `adpeeps_settings` AS settings ON a.accno=settings.accno AND settings.accno = '$uid'");
$ad_base_query .= (" LEFT JOIN `adpeeps_matchtargeting` AS match_targeting ON a.accno=match_targeting.accno AND a.campaignid=match_targeting.campaignid AND a.adno=match_targeting.adno AND match_targeting.targetzone = '$bzone'");
$ad_base_query .= (!empty($bzone2)) ? " LEFT JOIN `adpeeps_matchtargeting` AS match_targeting_default ON a.accno=match_targeting_default.accno AND a.campaignid=match_targeting_default.campaignid AND a.adno=match_targeting_default.adno AND match_targeting_default.targetzone = '$bzone2' AND match_targeting.ref_id IS NULL" : "";
$ad_base_query .= ($include_geo_db == "Y") ? " LEFT JOIN `adpeeps_matchtargeting_geo` AS match_targeting_geo ON a.accno=match_targeting_geo.accno AND a.campaignid=match_targeting_geo.campaignid AND a.adno=match_targeting_geo.adno" : "";
$ad_base_query .= (" LEFT JOIN `adpeeps_statistics` AS d ON d.accno=a.accno AND d.campaignid=a.campaignid AND d.adno=a.adno AND d.index_date=a.index_date AND d.index_date = '$today' AND d.showdate BETWEEN '$today $hour:00:00' AND '$today $hour:59:59' AND ");
$ad_base_query .= (empty($bzone2)) ? "match_targeting.targetzone = d.targetzone" : "(d.targetzone = match_targeting.targetzone OR d.targetzone=match_targeting_default.targetzone AND match_targeting.ref_id IS NULL)";
$ad_base_query .= (" WHERE a.accno = '$uid' AND a.accno=settings.accno AND (settings.blocked <> 'Y') AND (settings.expires = '0000-00-00' OR settings.expires >= '$today') AND (a.ad_cap IS NULL OR a.ad_cap IS NOT NULL AND a.display_priority = '1' AND a.index_date = '$today' AND a.ad_cap > a.dailycount OR a.ad_cap IS NOT NULL AND a.display_priority = '2' AND a.index_date = '$today' AND a.ad_cap > a.dailycount AND a.dailycount <= ROUND(((a.ad_cap / 24) * ($hour + ($minute / 60))),0) OR a.ad_cap IS NOT NULL AND a.index_date != '$today') AND (c.frequency IS NULL OR c.frequency IS NOT NULL AND a.ad_frequency = '0' OR c.frequency IS NOT NULL AND a.ad_frequency != '0' AND a.ad_frequency > c.frequency)");
$ad_base_query .= ($include_geo_db == "Y") ? " AND (match_targeting_geo.ref_id IS NULL OR (match_targeting_geo.include_exclude = 'I' AND match_targeting_geo.country_code = '$country_code' AND ((match_targeting_geo.state_region IS NULL OR match_targeting_geo.state_region = '$state') AND (match_targeting_geo.city_territory IS NULL OR match_targeting_geo.city_territory = '$city'))) OR (match_targeting_geo.include_exclude = 'E' AND match_targeting_geo.country_code <> '$country_code' AND ((match_targeting_geo.state_region IS NULL OR match_targeting_geo.state_region <> '$state') AND (match_targeting_geo.city_territory IS NULL OR match_targeting_geo.city_territory <> '$city')))) AND " : " AND ";
} else { 
$ad_base_query  = ("select SQL_NO_CACHE a.campaignid, a.adno FROM adpeeps_ads AS a LEFT JOIN adpeeps_matchtargeting AS match_targeting ON a.accno=match_targeting.accno AND a.campaignid=match_targeting.campaignid AND a.adno=match_targeting.adno WHERE a.accno = '$uid' AND ");
}
$ad_base_query .= ($bsize == "all") ? "(a.ad_size!='text' AND " : "(a.ad_size='$bsize' AND ";
$ad_base_query .= (empty($bzone2)) ? "match_targeting.targetzone = '$bzone'" : "(match_targeting.targetzone = '$bzone' OR match_targeting_default.targetzone = '$bzone2')";
$ad_base_query .= (" AND a.ad_daytarget LIKE '%$dayofweek%' AND a.sethour LIKE '%$hour%' AND a.ad_restrict NOT LIKE '%$domainname%' AND ");
$ad_base_query .= ($bsize == "text") ? "a.ad_title != '' AND " : "(a.ad_banner != '' OR a.remote_banner != '' OR a.ad_bannertext != '') AND ";
$ad_base_query .= (isset($_SESSION["$session_companion_ad"])) ? "((a.campaignid = '$session_companion' AND a.ad_companion = 'Y') OR 1=1) AND " : "";
$ad_base_query .= ($btype == "1") ? "a.ad_type != 'application/x-shockwave-flash' AND " : "";
if ((!empty($cid)) && (!empty($aid))) { $ad_base_query .= ("a.campaignid = '$cid' AND a.adno = '$aid' AND "); }
$ad_base_query .= ("a.adstatus = '1' AND a.campaignstatus = '1' AND a.ad_start <= '$today 23:59:59' AND (a.ad_expires = '1' OR a.ad_expires = '2' AND a.ad_expire2 = '1' AND a.impressions < a.ad_expire1 OR a.ad_expires = '2' AND a.ad_expire2 = '2' AND a.clicks < a.ad_expire1 OR a.ad_expires = '2' AND a.ad_expire2 = '5' AND a.impressions + a.rawimpressions < a.ad_expire1 OR a.ad_expires = '2' AND a.ad_expire2 = '6' AND a.clicks + a.rawclicks < a.ad_expire1 OR a.ad_expires = '2' AND (a.ad_expire2 = '3' OR a.ad_expire2 = '4') AND '$today 23:59:59' < a.ad_expire5))");
if ($mode == "2") {
$ad_base_query .= " ORDER BY rand(" . time() . " * " . time() . ")";
}
return "$ad_base_query";
}
function fetchad($db_link,$uid,$cid,$aid,$bsize,$bzone,$atype) {
global $banner_url_lb;
if ($atype == "1") {
$result = mysqli_fetch_row(mysqli_query($db_link, "SELECT ad_banner, ad_type FROM adpeeps_ads WHERE accno='$uid' AND campaignid = '$cid' AND adno='$aid'")) or die(mysqli_error($db_link).__LINE__);
header("Expires: Mon, 26 Jul 2024 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
$ad_type = ($result[1] == "") ? "image/gif" : $result[1];
header( "Content-type: $ad_type");
echo "$result[0]";
} elseif ($atype == "2") {
$result = mysqli_fetch_row(mysqli_query($db_link, "SELECT banner_url, ad_bannertext FROM adpeeps_ads as a LEFT JOIN adpeeps_settings AS b ON a.accno = b.accno WHERE a.accno='$uid' AND b.accno='$uid' AND a.campaignid = '$cid' AND a.adno='$aid'")) or die(mysqli_error($db_link).__LINE__);
$randnum = rand() % 1000000;
$result[0] = (empty($banner_url_lb)) ? "$result[0]" : "$banner_url_lb";
$result[1] = preg_replace("/<rand>/i", "$randnum", "$result[1]");
$result[1] = preg_replace("/<errorcorrect>/i", "", $result[1]);
echo stripslashes(preg_replace("/<url>/i", "$result[0]/adpeeps.php?bf=go&uid=$uid&bzone=$bzone&btype=$btype&bpos=link&cid=$cid&aid=$aid&transferurl=", $result[1]));
}
}
function record_data($db_link,$uid,$ipaddress,$bzone,$bsize,$btype,$bpos,$campaignid,$adno,$ad_url,$function_type,$ad_weight,$ad_autoweight,$impressions,$clicks,$lastdateshown,$ip_stats_record_id,$stats_record_id,$country_code,$country_name,$city,$state,$order,$matches) {
global $timestamp, $hour, $today;
$country_name = mysqli_real_escape_string($db_link,$country_name);
$city = mysqli_real_escape_string($db_link,$city);
$state = mysqli_real_escape_string($db_link,$state);
$referral_url = stripslashes($_SERVER[HTTP_REFERER]);
if ($function_type == "impression"){
if (empty($insert_stats_summary_unique_query)) { static $insert_stats_summary_unique_query = array(); }
if (empty($insert_stats_summary_raw_query))    { static $insert_stats_summary_raw_query    = array(); }
if (empty($insert_stats_query))                { static $insert_stats_query                = array(); }
if (empty($insert_ipstats_query))              { static $insert_ipstats_query              = array(); }
$daily_stats_update = ($lastdateshown == "$today") ? "adpeeps_ads.lastdateshown = '$timestamp', adpeeps_ads.dailycount = adpeeps_ads.dailycount+1, last_update_date = '$timestamp'" : "adpeeps_ads.lastdateshown = '$timestamp', adpeeps_ads.index_date = '$today', adpeeps_ads.dailycount = '1', last_update_date = '$timestamp'";
// Search Query found ip frequency entry for ad (user saw ad before, today)
if (!empty($ip_stats_record_id))  {
$update_impression_query = "UPDATE adpeeps_ads";
$update_impression_query .= (!empty($ip_stats_record_id)) ? ", adpeeps_statisticsiplog" : "";
$update_impression_query .= (!empty($stats_record_id)) ? ", adpeeps_statistics" : "";
# Update adpeeps_ads
$update_impression_query .= " SET adpeeps_ads.rawimpressions = adpeeps_ads.rawimpressions+1, $daily_stats_update";
# Update adpeeps_statisticsiplog
$update_impression_query .= (!empty($ip_stats_record_id)) ? ", adpeeps_statisticsiplog.frequency = adpeeps_statisticsiplog.frequency+1, adpeeps_statisticsiplog.lastsceen = '$timestamp', adpeeps_statisticsiplog.country_code = '$country_code', adpeeps_statisticsiplog.country_name = '$country_name', adpeeps_statisticsiplog.region_name = '$state', adpeeps_statisticsiplog.city_name = '$city', adpeeps_statisticsiplog.referral_url = '$referral_url'" : "";
# Update adpeeps_statistics
$update_impression_query .= (!empty($stats_record_id)) ? ", adpeeps_statistics.showdate = '$timestamp', adpeeps_statistics.rawimpressions = adpeeps_statistics.rawimpressions+1" : "";
$update_impression_query .= " WHERE adpeeps_ads.accno = '$uid' AND adpeeps_ads.campaignid='$campaignid' AND adpeeps_ads.adno='$adno' ";
$update_impression_query .= (!empty($ip_stats_record_id)) ? "AND adpeeps_statisticsiplog.accno = '$uid' AND adpeeps_statisticsiplog.campaignid = '$campaignid' AND adpeeps_statisticsiplog.adno = '$adno' AND adpeeps_statisticsiplog.record_id = '$ip_stats_record_id' " : "";
$update_impression_query .= (!empty($stats_record_id)) ? "AND adpeeps_statistics.record_id = '$stats_record_id' AND adpeeps_statistics.accno = '$uid' AND adpeeps_statistics.campaignid = '$campaignid' AND adpeeps_statistics.adno = '$adno' AND adpeeps_statistics.index_date = '$today'" : "";
mysqli_query($db_link, "$update_impression_query") or die(mysqli_error($db_link).__LINE__);
if (empty($stats_record_id)) {
$insert_stats_query[] = "(MD5('$uid.$campaignid.$adno.$timestamp.$bzone'),'$uid','$campaignid','$adno','$timestamp','$today','$bzone','0','0','1','0')";
}
# Update adpeeps_statistics_summary
$insert_stats_summary_raw_query[] = "('$uid','$campaignid','$adno',DATE_FORMAT('$today','%Y-%m-01'),'0','0','1','0','$timestamp')";
} 
// Search Query found ip frequency entry for ad (user saw ad before, today)
// Update entries where frequency was not found
else {
$browser = getbrowser(); 
$ver = getversion(); 
// insert entry into adpeeps_statisticsiplog since frequency < 1
$insert_ipstats_query[] = "(MD5('$uid.$campaignid.$timestamp.$adno.i.$ipaddress'),'$uid','$campaignid','$today','$adno','i','1','$ipaddress','$timestamp','$browser','$ver','$country_code','$country_name','$state','$city','$referral_url')";
// insert entry into adpeeps_statisticsiplog since frequency < 1
// update adpeeps_ads table with unique impression count and daily count
$update_impression_query = "UPDATE adpeeps_ads";
$update_impression_query .= (!empty($stats_record_id)) ? ", adpeeps_statistics" : "";
# Update adpeeps_ads
$update_impression_query .= " SET adpeeps_ads.impressions = adpeeps_ads.impressions+1, $daily_stats_update";
# Update adpeeps_statistics
$update_impression_query .= (!empty($stats_record_id)) ? ", adpeeps_statistics.showdate = '$timestamp', adpeeps_statistics.index_date = '$today', adpeeps_statistics.showcount = showcount+1" : "";
$update_impression_query .= " WHERE adpeeps_ads.accno = '$uid' AND adpeeps_ads.campaignid='$campaignid' AND adpeeps_ads.adno='$adno' ";
$update_impression_query .= (!empty($stats_record_id)) ? "AND adpeeps_statistics.accno = '$uid' AND adpeeps_statistics.campaignid = '$campaignid' AND adpeeps_statistics.adno = '$adno' AND adpeeps_statistics.record_id = '$stats_record_id'" : "";
mysqli_query($db_link, "$update_impression_query") or die(mysqli_error($db_link).__LINE__);
// update adpeeps_ads table with unique impression count and daily count
if (empty($stats_record_id)) {
$insert_stats_query[] = "(MD5('$uid.$campaignid.$adno.$timestamp.$bzone'),'$uid','$campaignid','$adno','$timestamp','$today','$bzone','1','0','0','0')";
}
# Update adpeeps_statistics_summary
$insert_stats_summary_unique_query[] = "('$uid','$campaignid','$adno',DATE_FORMAT('$today','%Y-%m-01'),'1','0','0','0','$timestamp')";
}
// Update entries where frequency was not found
// if bmode = 1 (standard image) add entry into database so ad peeps can know where to direct click
if ($btype == "1"){
mysqli_query($db_link, "REPLACE INTO adpeeps_adtracker VALUES (MD5('$uid.$today.$ipaddress.$bpos.$bsize.$bzone'),'$uid','$campaignid', '$adno', '$timestamp','$ipaddress','$bpos','$bsize','$ad_url','$bzone')") or die(mysqli_error($db_link).__LINE__);
}
// if bmode = 1 (standard image) add entry into database so ad peeps can know where to direct click
// auto weight feature 
if (($ad_autoweight == "1") && ($impressions >= "1000") && (round((100*($clicks/$impressions)), 1) >= "1") && ($ad_weight != "100")) { mysqli_query($db_link, "UPDATE adpeeps_ads SET ad_weight = '100' WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno'") or die(mysqli_error($db_link).__LINE__); }
elseif (($ad_autoweight == "1") && ($impressions >= "1000") && (round((100*($clicks/$impressions)), 1) < "1") && ($ad_weight == "100")) { mysqli_query($db_link, "UPDATE adpeeps_ads SET ad_weight = '50' WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno'") or die(mysqli_error($db_link).__LINE__); }
elseif (($ad_autoweight == "1") && ($impressions >= "1000") && (round((100*($clicks/$impressions)), 1) < "1") && ($ad_weight == "50")) { mysqli_query($db_link, "UPDATE adpeeps_ads SET ad_weight = '10' WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno'") or die(mysqli_error($db_link).__LINE__); }
// auto weight feature
// multiple row insert
if (($order == "$matches") && (count($insert_stats_query)) > 0){
$build_statistics_query = "INSERT INTO `adpeeps_statistics` VALUES \n";
}
if (($order == "$matches") && (count($insert_stats_summary_unique_query)) > 0){
$build_statistics_summary_unique_query = "INSERT INTO `adpeeps_statistics_summary` VALUES \n";
}
if (($order == "$matches") && (count($insert_stats_summary_raw_query)) > 0){
$build_statistics_summary_raw_query = "INSERT INTO `adpeeps_statistics_summary` VALUES \n";
}
if (($order == "$matches") && (count($insert_ipstats_query)) > 0){
$build_ipstatistics_query = "INSERT INTO adpeeps_statisticsiplog VALUES \n";
}
$stats_record_num = 0;
$ipstats_record_num = 0;
foreach ($insert_stats_query as $insert_stats_query_record) {
++$stats_record_num;
$build_statistics_query .= "$insert_stats_query_record";
if (count($insert_stats_query) != "$stats_record_num") { $build_statistics_query .= ",\n"; }
}
foreach ($insert_stats_summary_unique_query as $insert_stats_summary_unique_query_record) {
++$stats_summary_record_num_unique;
$build_statistics_summary_unique_query .= "$insert_stats_summary_unique_query_record";
if (count($insert_stats_summary_unique_query) != "$stats_summary_record_num_unique") { $build_statistics_summary_unique_query .= ",\n"; }
}
foreach ($insert_stats_summary_raw_query as $insert_stats_summary_raw_query_record) {
++$stats_summary_record_num_raw;
$build_statistics_summary_raw_query .= "$insert_stats_summary_raw_query_record";
if (count($insert_stats_summary_raw_query) != "$stats_summary_record_num_raw") { $build_statistics_summary_raw_query .= ",\n"; }
}
foreach ($insert_ipstats_query as $insert_ipstats_query_record) {
++$ipstats_record_num;
$build_ipstatistics_query .= "$insert_ipstats_query_record";
if (count($insert_ipstats_query) != "$ipstats_record_num") { $build_ipstatistics_query .= ",\n"; }
}
if (($order == "$matches") && (count($insert_stats_query)) > 0){
mysqli_query($db_link, "$build_statistics_query") or die(mysqli_error($db_link).__LINE__);
unset($build_statistics_query);
}
if (($order == "$matches") && (count($insert_stats_summary_unique_query)) > 0){
$build_statistics_summary_unique_query .= " ON DUPLICATE KEY UPDATE showcount=showcount+1";
mysqli_query($db_link, "$build_statistics_summary_unique_query") or die(mysqli_error($db_link).__LINE__);
unset($build_statistics_summary_unique_query);
}
if (($order == "$matches") && (count($insert_stats_summary_raw_query)) > 0){
$build_statistics_summary_raw_query .= " ON DUPLICATE KEY UPDATE rawimpressions=rawimpressions+1";
mysqli_query($db_link, "$build_statistics_summary_raw_query") or die(mysqli_error($db_link).__LINE__);
unset($build_statistics_summary_raw_query);
}
if (($order == "$matches") && (count($insert_ipstats_query)) > 0){
$build_ipstatistics_query .= " ON DUPLICATE KEY UPDATE frequency=frequency+1, lastsceen = '$timestamp'";
mysqli_query($db_link, "$build_ipstatistics_query") or die(mysqli_error($db_link).__LINE__);
unset($build_ipstatistics_query);
}
unset($insert_stats_summary_unique_query);
unset($insert_stats_summary_raw_query);
unset($insert_stats_query);
unset($insert_ipstats_query);
// multiple row insert
} elseif ($function_type == "click") {
// checks to see if this user has entry already in the ip logs for today
$unique_click_count = mysqli_fetch_array(mysqli_query($db_link, "SELECT count(*) FROM adpeeps_statisticsiplog WHERE accno = '$uid' AND campaignid = '$campaignid' AND showdate = '$today' AND adno = '$adno' AND type = 'c' AND ipaddress='$ipaddress'")) or die(mysqli_error($db_link).__LINE__);
// checks to see if this user has entry already in the ip logs for today
if ($unique_click_count[0] == "0") {
// if user has no entry, insert into ip statistics table
mysqli_query($db_link, "INSERT INTO adpeeps_statisticsiplog (record_id, accno, campaignid, showdate, adno, type, frequency, ipaddress, lastsceen, browser, ver, country_code, country_name, region_name, city_name, referral_url) SELECT MD5('$uid.$campaignid.$timestamp.$adno.c.$ipaddress'), accno, campaignid, '$today', adno, 'c', '1', ipaddress, '$timestamp', browser, ver, country_code, country_name, region_name, city_name, referral_url FROM adpeeps_statisticsiplog WHERE accno = '$uid' AND campaignid = '$campaignid' AND showdate = '$today' AND adno = '$adno' AND type = 'i' AND ipaddress='$ipaddress' LIMIT 1") or die(mysqli_error($db_link).__LINE__);
// if user has no entry, insert into ip statistics table
///// add/update statistics
mysqli_query($db_link, "UPDATE adpeeps_ads SET clicks = clicks+1, last_update_date = '$timestamp' WHERE accno = '$uid' AND campaignid='$campaignid' AND adno='$adno'") or die(mysqli_error($db_link).__LINE__);
$statistics_count = mysqli_fetch_array(mysqli_query($db_link, "SELECT count(*) FROM adpeeps_statistics WHERE accno = '$uid' AND campaignid = '$campaignid' AND index_date = '$today' AND showdate BETWEEN '$today $hour:00:00' AND '$today $hour:59:59' AND adno = '$adno' AND targetzone='$bzone'")) or die(mysqli_error($db_link).__LINE__);
if ($statistics_count[0] == "0") { 
mysqli_query($db_link, "INSERT INTO adpeeps_statistics VALUES (MD5('$uid.$campaignid.$adno.$timestamp.$bzone'),'$uid','$campaignid','$adno','$timestamp','$today','$bzone','0','1','0','0')") or die(mysqli_error($db_link).__LINE__);
}
else { 
mysqli_query($db_link, "UPDATE adpeeps_statistics SET showdate = '$timestamp', clickcount = clickcount+1 WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno' AND index_date = '$today' AND showdate BETWEEN '$today $hour:00:00' AND '$today $hour:59:59' AND targetzone='$bzone' LIMIT 1") or die(mysqli_error($db_link).__LINE__); 
}
$statistics_summary_count = mysqli_fetch_array(mysqli_query($db_link, "SELECT count(*) FROM `adpeeps_statistics_summary` WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno' AND period = DATE_FORMAT('$today','%Y-%m-01')")) or die(mysqli_error($db_link).__LINE__);
if ($statistics_summary_count[0] == "0") { 
mysqli_query($db_link, "INSERT INTO `adpeeps_statistics_summary` VALUES ('$uid','$campaignid','$adno',DATE_FORMAT('$today','%Y-%m-01'),'0','1','0','0','$timestamp')") or die(mysqli_error($db_link).__LINE__);
}
else { 
mysqli_query($db_link, "UPDATE `adpeeps_statistics_summary` SET clickcount = clickcount+1, last_update_date = '$timestamp' WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno' AND period = DATE_FORMAT('$today','%Y-%m-01')") or die(mysqli_error($db_link).__LINE__); 
}
///// add/update statistics
} else {
mysqli_query($db_link, "UPDATE adpeeps_statisticsiplog SET frequency = frequency+1, lastsceen = '$timestamp' WHERE accno = '$uid' AND campaignid = '$campaignid' AND showdate = '$today' AND adno = '$adno' AND type = 'c' AND ipaddress='$ipaddress' LIMIT 1") or die(mysqli_error($db_link).__LINE__);
mysqli_query($db_link, "UPDATE adpeeps_ads SET rawclicks = rawclicks+1, last_update_date = '$timestamp' WHERE accno = '$uid' AND campaignid='$campaignid' AND adno='$adno' LIMIT 1") or die(mysqli_error($db_link).__LINE__);
mysqli_query($db_link, "UPDATE adpeeps_statistics SET showdate = '$timestamp', rawclicks = rawclicks+1 WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno' AND index_date = '$today' AND showdate BETWEEN '$today $hour:00:00' AND '$today $hour:59:59' AND targetzone='$bzone' LIMIT 1") or die(mysqli_error($db_link).__LINE__);
mysqli_query($db_link, "UPDATE `adpeeps_statistics_summary` SET rawclicks = rawclicks+1, last_update_date = '$timestamp' WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno' AND period = DATE_FORMAT('$today','%Y-%m-01')") or die(mysqli_error($db_link).__LINE__);
}
///// update unique and raw clicks //////////
}
}
function click_rm_banner($db_link,$uid,$bzone,$bsize,$btype,$bpos,$campaignid,$adno,$ipaddress) {
// record hit and update stats here
if ((!empty($uid)) && (!empty($campaignid)) && (!empty($adno))) { record_data($db_link,$uid,$ipaddress,$bzone,$bsize,$btype,$bpos,$campaignid,$adno,false,click,false,false,false,false,false,false,false,false,false,false,false,false,false,false); }
// record hit and update stats here
}
function clickbanner($db_link,$uid,$bzone,$bsize,$btype,$bpos,$campaignid,$adno,$today,$ipaddress,$transferurl) {
if ($btype == "1") {
$transferurl = FALSE;
$query = ("SELECT campaignid, adno, transferurl FROM `adpeeps_adtracker` WHERE accno = '$uid' AND DATE_FORMAT(showdate, '%Y-%m-%d')= '$today' AND ipaddress='$ipaddress' AND pagename='$bpos' AND adsize = '$bsize' AND targetzone='$bzone'");
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link).__LINE__);
$number = mysqli_num_rows($result);
if (mysqli_num_rows($result) > 0) {
// Associative array
$row=mysqli_fetch_assoc($result);
$campaignid = $row['campaignid'];
$adno = $row['adno'];
$transferurl = $row['transferurl'];
}
} else {
$bzone =  ($btype == "5") ? "directlink" : "$bzone";
if (empty($transferurl)) {
$query = ("SELECT ad_size, ad_url FROM `adpeeps_ads` WHERE accno = '$uid' AND campaignid = '$campaignid' AND adno = '$adno'");
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link).__LINE__);
if (mysqli_num_rows($result) > 0) {
// Associative array
$row=mysqli_fetch_assoc($result);
$bsize = $row['ad_size'];
$transferurl = $row['ad_url'];
$transferurl = ((!empty($transferurl)) && (substr(strtolower("$transferurl"), 0, 9) == "clicktag=")) ? substr("$transferurl", 9) : "$transferurl";
}
}
}
// record hit and update stats here
if ((!empty($uid)) && (!empty($campaignid)) && (!empty($adno))) { record_data($db_link,$uid,$ipaddress,$bzone,$bsize,$btype,$bpos,$campaignid,$adno,false,click,false,false,false,false,false,false,false,false,false,false,false,false,false,false); }
// record hit and update stats here
// transfer user
header("Location: $transferurl");
// transfer user
} // close click function
function getbrowser() {
global $HTTP_USER_AGENT;
if(preg_match('/MSIE/i', "$HTTP_USER_AGENT")) { 
$browser = ("1");
} 
elseif ((preg_match('/Chrome/i', "$HTTP_USER_AGENT")) && (preg_match('/Safari/i', "$HTTP_USER_AGENT"))) { 
$browser = ("2");
} 
elseif(preg_match('/Firefox/i', "$HTTP_USER_AGENT")) { 
$browser = ("3");
}
elseif(preg_match('/Opera/i', "$HTTP_USER_AGENT")) { 
$browser = ("4");
}
elseif ((preg_match('/Safari/i', "$HTTP_USER_AGENT")) && (!preg_match('/Chrome/i', "$HTTP_USER_AGENT")))  { 
$browser = ("5");
}
else {
$browser = ("7");
}
return $browser;
}
function getversion () {
global $HTTP_USER_AGENT;
// Opera browser dectection -- Added 1/25/02
if (preg_match( '/Opera\/([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) { 
$ver= ("$version[1]"); 
}
elseif (preg_match( '/Opera ([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) { 
$ver=$version[1]; 
}
// Opera browser dectection -- Added 1/25/02
elseif ((preg_match( '/MSIE ([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) && (!preg_match('/AOL/', getenv("HTTP_USER_AGENT")))){ 
$ver= ("$version[1]"); 
}
// Google Chrome Detection-- Added 1/25/14
elseif (preg_match( '/Chrome\/([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) { 
$ver=$version[1]; 
}
// Google Chrome Detection-- Added 1/25/14
// Netscape 6 Support - Added 1/12/02
elseif (preg_match( '/Netscape6\/([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) { 
$ver= ("$version[1]");
} 
// Netscape 6 Support - Added 1/12/02
// Netscape 7 Support - Added 9/25/02
elseif (preg_match( '/Netscape\/([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) { 
$ver= ("$version[1]");
} 
// Netscape 7 Support - Added 9/25/02
elseif (preg_match( '/Firefox\/([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) { 
$ver= ("$version[1]"); 
} 
elseif (preg_match('/Mozilla\/([0-9].[0-9]{1,2})/',$HTTP_USER_AGENT,$version)) { 
$ver= ("$version[1]"); 
} 
else { 
$ver = ("0.0"); 
}
return $ver;
}
function sortBySubkey(&$data, $field, $weight) { 
// If multiple weights, this function will remove ads that did not match the random weight passed
// If companion ad found, this will be skipped.
if ($weight > 0) {
foreach ($data as $key => $value) { 
if (($value[ad_weight] != "$weight") && ($value[campanion_sort] != "1")) { 
unset($data[$key]); 
} 
}
} else {
$code = "return strnatcmp(\$a['$field'], \$b['$field']);"; 
usort($data, create_function('$a,$b', $code)); 
}
} 
function detectssl(){
if($_SERVER["HTTPS"] == "on"){
return TRUE;
} elseif ($_SERVER["HTTPS"] == 1){
return TRUE;
} elseif ($_SERVER['SERVER_PORT'] == 443) {
return TRUE;
} else {
return FALSE;
}
} 
ob_end_flush();
// close database connection
dbconnection_end ($db_link);
exit(0);
// close database connection
?>