".$last_sortID." limit 1";
}
else {
$query = "select adID, sortID, imgurl, adtext, adtype, refresh from adspace
where show_ID = ".$show_ID." and loc_ID = ".$loc_ID." and '".$game_date."' between start_date and end_date and adID > ".$last_ID." limit 1";
}
if ($gamehost=="localhost") { $result = mysqli_query($my_conn_local, $query); } else { $result = mysqli_query($my_conn, $query); }
$num = mysqli_num_rows($result);
$row = mysqli_fetch_assoc($result);
if ($num > 0) {
$adID = $row['adID'];
$sortID = $row['sortID'];
$imgurl = $row['imgurl'];
$imgurl = str_replace("game/", "", $imgurl);
$adtext = $row['adtext'];
$adtype = $row['adtype'];
$refresh = $row['refresh'];
if ($adtype=="image") {
if ($gamehost=="localhost") {
$url = $_SERVER['HTTP_HOST'];
}
else {
$url = $_SERVER['HTTP_HOST']."/game";
}
$adspace = "![](http://".$url."/".$imgurl.")
";
}
elseif ($adtype="text") {
$adspace = $adtext;
}
//set cookie for adID w/o loc, show
$expire = time() + 60*10;
if ($gamehost=="www.triviocity.com") {
$chost = "triviocity.com";
}
setcookie("last_ID", $adID, $expire, "/", $chost);
}
elseif ($num==0) {
header('Location: adspace.php');
}
?>
Adspace