/* $Id: banneradd.php,v 1.4 2001/02/15 01:18:15 phord Exp $ */ require ("config.php"); require("kcsm.php"); kc_auth_admin(); if (!empty($bannerID)) { $Session["bannerID"] = "$bannerID"; } // If the form is being submitted, add a new record to banners if (isset($submit)) { switch($bannertype) { case "mysql": if (!empty($mysql_banner) && $mysql_banner != "none") { $size = GetImageSize($mysql_banner); $final["width"] = $size[0]; $final["height"] = $size[1]; $ext = substr($mysql_banner_name, strrpos($mysql_banner_name, ".")+1); switch (strtoupper($ext)) { case "JPEG": $final["format"] = "jpeg"; break; case "JPG": $final["format"] = "jpeg"; break; case "HTML": $final["format"] = "html"; break; case "PNG": $final["format"] = "png"; break; case "GIF": $final["format"] = "gif"; break; } $final["banner"] = addslashes(fread(fopen($mysql_banner, "rb"), filesize($mysql_banner))); } $final["alt"] = $mysql_alt; $final["bannertext"] = $mysql_bannertext; $final["url"] = $mysql_url; break; case "url": $final["width"] = $url_width; $final["height"] = $url_height; $final["format"] = "url"; $final["banner"] = $url_banner; $final["alt"] = $url_alt; $final["bannertext"] = $url_bannertext; $final["url"] = $url_url; break; case "html"; $final["format"] = "html"; $final["banner"] = $html_banner; $final["width"] = ""; $final["height"] = ""; $final["alt"] = ""; $final["bannertext"] = ""; $final["url"] = $html_url; break; } $final["clientID"] = (IsSet($Session["clientID"]) ? $Session["clientID"] : "0"); if (!empty($Session["bannerID"])) $final["bannerID"] = $Session["bannerID"]; $final["active"] = "true"; $final["keyword"] = $keyword; $final["weight"] = $weight; // Don't add an empty banner if (empty($final["banner"]) || $final["banner"] == "none") unset($final["banner"]); $message = empty($Session["bannerID"]) ? $strBannerAdded : $strBannerModified; // Construct appropiate SQL query // If bannerID==null, then this is an INSERT, else it's an UPDATE if (!isset($final["bannerID"])) { //INSERT $values_fields = ""; $values = ""; while (list($name, $value) = each($final)) { $values_fields .= "$name, "; $values .= "'$value', "; } // Cut trailing commas $values_fields = ereg_replace(", $", "", $values_fields); $values = ereg_replace(", $", "", $values); // Execute query $sql_query = " INSERT INTO $phpAds_tbl_banners ($values_fields) VALUES ($values)"; $res = db_query($sql_query) or mysql_die(); } else { // UPDATE $set = ""; while (list($name, $value) = each($final)) { $set .= "$name = '$value', "; } // Cut trailing commas $set = ereg_replace(", $", "", $set); // Execute query $sql_query = " UPDATE $phpAds_tbl_banners SET $set WHERE bannerID = $final[bannerID]"; $res = db_query($sql_query) or mysql_die(); } unset($Session["bannerID"]); if ($return == "stats") { Header("Location: clientstats.php$fncpageid&message=".urlencode($message)); } elseif ($return == "close") { echo "
"; } else { Header("Location: banner.php$fncpageid&message=".urlencode($message)); } exit; } page_header("$strBannerAdmin"); // If we find an ID, means that we're in update mode if (isset($bannerID)) { show_nav("1.3.2"); $res = db_query(" SELECT * FROM $phpAds_tbl_banners WHERE bannerID = $bannerID ") or mysql_die(); $row = mysql_fetch_array($res); if (ereg("gif|png|jpeg", $row["format"])) $type = "mysql"; else $type = $row["format"]; } else { show_nav("1.3.1"); } // determine if we're running IE $isiepos = strpos($HTTP_USER_AGENT,"MSIE"); $isie = ( $isiepos>0 ? substr($HTTP_USER_AGENT,$isiepos+5,3) : 0 ); ?> if ($isie) { ?> } ?> page_footer(); ?>