<?php 
require("configure.php");
require("createthumb.php");

$Sort					= $_POST["Sort"];
//$Href					= $_POST["Href"];

$TitleTC	= htmlspecialchars($_POST["TitleTC"],ENT_QUOTES);
$TitleEN	= htmlspecialchars($_POST["TitleEN"],ENT_QUOTES);

$DescTC	= htmlspecialchars($_POST["DescTC"],ENT_QUOTES);
$DescEN	= htmlspecialchars($_POST["DescEN"],ENT_QUOTES);
//$ImageTC;
//$ImageEN;

print_r($_POST);

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

// copy image 
// File 1
if ($_FILES['ImageTC']['name'] <> '')
{
 	$prefix = "photos/Sideshow_TC_";
	
	$GalleryDetailFileTC = $prefix . $SlideId ."-". $_FILES['ImageTC']['name'];
	copy ($_FILES['ImageTC']['tmp_name'], $GalleryDetailFileTC) or die ("Could not copy");		 	 
	createthumb($GalleryDetailFileTC, $GalleryDetailFileTC, 450, 450);
	
	$thumb = thumbName($GalleryDetailFileTC, "t");
	move_uploaded_file ($_FILES['ImageTC']['tmp_name'], $thumb ) or die ("Could not copy");		 
	createthumb($thumb, $thumb, 65, 65);
}
else
{	
	$GalleryDetailFileTC = "";
}

// copy image 
// File 2
if ($_FILES['ImageEN']['name'] <> '')
{
 	$prefix = "photos/Sideshow_EN_";
	
	$GalleryDetailFileEN = $prefix . $SlideId ."-". $_FILES['ImageEN']['name'];
	copy ($_FILES['ImageEN']['tmp_name'], $GalleryDetailFileEN) or die ("Could not copy");		 	 
	createthumb($GalleryDetailFileEN, $GalleryDetailFileEN, 450, 450);
	
	$thumb = thumbName($GalleryDetailFileEN, "t");
	move_uploaded_file ($_FILES['ImageEN']['tmp_name'], $thumb ) or die ("Could not copy");		 
	createthumb($thumb, $thumb, 65, 65);
}
else
{	
	$GalleryDetailFileEN = "";
}

// End upload image code


// Modify 
if ($Sort == '' || $Sort == '0') {
	$sql = "select max(Sort) as maxid from Slideshow ";
	$result=mysql_query($sql);
	$row = mysql_fetch_array($result,MYSQL_ASSOC);
	$Sort = $row{maxid}+1;
}
if( mysql_num_rows(mysql_query("SELECT SlideId FROM Slideshow WHERE Sort=$Sort ")) > 0){
	mysql_query("UPDATE Slideshow SET Sort= Sort+1 WHERE Sort >=$Sort ");
}

mysql_query("insert into Slideshow (SlideId, Sort, DescTC, DescEN, TitleTC, TitleEN) 
						values ('$SlideId', '$Sort', '$DescTC', '$DescEN', '$TitleTC', '$TitleEN')");
	
// update images path						
if ($GalleryDetailFileTC <> '') {
	// Modify 
	$sql = "update Slideshow set ImageTC='$GalleryDetailFileTC' where SlideId = '$SlideId' ";
	mysql_query($sql);
}

if( mysql_errno() > 0 ){
	echo 'Home Item Modify Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
	exit;
}

if ($GalleryDetailFileEN <> '') {
	// Modify 
	$sql = "update Slideshow set ImageEN='$GalleryDetailFileEN' where SlideId = '$SlideId' ";
	mysql_query($sql);
}

if( mysql_errno() > 0 ){
	echo 'Home Item Modify Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
	exit;
}
						
mysql_close($dbh);

header("Location: slideshow_index.php?msg=Update Successful");
?>