<?php
include 'config.php';

// Check if the user is logged in

if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
?>
<?php require("configure.php"); 
require("function_resizethumb.php"); 

$bannerlinktc	= check_input($_POST["bannerlinktc"]);
$bannerlinken	= check_input($_POST["bannerlinken"]);
$belongpage	= check_input($_POST["belongpage"]);
$belongcatid	= check_input($_POST["belongcatid"]);
$nowdate 		= date("Y-m-d H:i:s");


$sql = "select max(bannerid) as maxid ";
$sql .= "from banner ";
$result=mysql_query($sql);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$bannerid = $row{maxid}+1;


// Upload File
$filelimit = 2 * 1048576; //Filelimit in 2MB
if ($_FILES['bannerimgtc']['name'] <> '')
{
	if ($_FILES['bannerimgtc']['size'] < $filelimit ){

			if (($_FILES["bannerimgtc"]["type"] == "image/gif") || ($_FILES["bannerimgtc"]["type"] == "image/GIF") || ($_FILES["bannerimgtc"]["type"] == "image/jpg") || ($_FILES["bannerimgtc"]["type"] == "image/JPG") || ($_FILES["bannerimgtc"]["type"] == "image/jpeg") || ($_FILES["bannerimgtc"]["type"] == "image/JPEG") || ($_FILES["bannerimgtc"]["type"] == "image/pjpeg") || ($_FILES["bannerimgtc"]["type"] == "image/PJEG") || ($_FILES["bannerimgtc"]["type"] == "image/png") || ($_FILES["bannerimgtc"]["type"] == "image/x-png") || ($_FILES["bannerimgtc"]["type"] == "image/PNG") || ($_FILES["bannerimgtc"]["type"] == "image/X-PNG"))
			{
				move_uploaded_file  ($_FILES['bannerimgtc']['tmp_name'], "../images/banner/id_tc_".$bannerid.$_FILES['bannerimgtc']['name'])
					or die ("Could not copy the file");
				
				$bannerimgtcimg = "../images/banner/id_tc_".$bannerid.$_FILES['bannerimgtc']['name'];
				//createthumb($bannerimgtcimg, $bannerimgtcimg, 980, 310);
		
				$bannerimgtc = "id_tc_".$bannerid.$_FILES['bannerimgtc']['name'];
			}
			
	  }
	else
	  {
	  // upload error
	  ?>
		<script language="javascript">
		alert("Files must be JPEG, GIF, or PNG and under 2MB in size");
		history.back();
		</script>
	 <?php
	 exit;
	 }

}
else
{
	$bannerimgtc = "";
}

if ($_FILES['bannerimgen']['name'] <> '')
{
	if ($_FILES['bannerimgen']['size'] < $filelimit ){

			if (($_FILES["bannerimgen"]["type"] == "image/gif") || ($_FILES["bannerimgen"]["type"] == "image/GIF") || ($_FILES["bannerimgen"]["type"] == "image/jpg") || ($_FILES["bannerimgen"]["type"] == "image/JPG") || ($_FILES["bannerimgen"]["type"] == "image/jpeg") || ($_FILES["bannerimgen"]["type"] == "image/JPEG") || ($_FILES["bannerimgen"]["type"] == "image/pjpeg") || ($_FILES["bannerimgen"]["type"] == "image/PJEG") || ($_FILES["bannerimgen"]["type"] == "image/png") || ($_FILES["bannerimgen"]["type"] == "image/x-png") || ($_FILES["bannerimgen"]["type"] == "image/PNG") || ($_FILES["bannerimgen"]["type"] == "image/X-PNG"))
			{
				move_uploaded_file  ($_FILES['bannerimgen']['tmp_name'], "../images/banner/id_en_".$bannerid.$_FILES['bannerimgen']['name'])
					or die ("Could not copy the file");
				
				$bannerimgenimg = "../images/banner/id_en_".$bannerid.$_FILES['bannerimgen']['name'];
				//createthumb($bannerimgenimg, $bannerimgenimg, 980, 310);
		
				$bannerimgen = "id_en_".$bannerid.$_FILES['bannerimgen']['name'];
			}
			
	  }
	else
	  {
	  // upload error
	  ?>
		<script language="javascript">
		alert("Files must be JPEG, GIF, or PNG and under 2MB in size");
		history.back();
		</script>
	 <?php
	 exit;
	 }

}
else
{
	$bannerimgen = "";
}

// Sort
//if ($sort == '' || $sort == '0') {
	$sql = "select max(sort) as maxid ";
	$sql .= "from banner where belongcatid='$belongcatid' and belongpage='$belongpage'";
	$result=mysql_query($sql);
	$row = mysql_fetch_array($result,MYSQL_ASSOC);
	$sort = $row{maxid}+1;
//}
	/*
if( mysql_num_rows(mysql_query("SELECT bannerid FROM banner WHERE sort=$sort ")) > 0){
	mysql_query("UPDATE banner SET sort= sort+1 WHERE sort >=$sort ");
}
*/

$sql = "insert into banner (belongpage, belongcatid,bannerid, bannerlinktc, bannerlinken, bannerimgtc, bannerimgen, sort, status, createdate, createby, lastupdate, lastupby) values ('$belongpage','$belongcatid','$bannerid', '$bannerlinktc', '$bannerlinken', '$bannerimgtc', '$bannerimgen', '$sort', '1', '$nowdate','".$_SESSION['cmsloginid']."', '$nowdate', '".$_SESSION['cmsloginid']."')";
mysql_query($sql);
if( mysql_errno() > 0 ){
	echo 'Add Banner Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
	exit;
}

mysql_close($dbh);

	$menuid= $belongpage;
header("Location: banner_index.php?menuid=$menuid&msg=Add Successful");
?>