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

$SlideId 				= $_POST["SlideId"];
//$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);
 
//print_r($_POST);

// 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

$sql = "update Slideshow set DescTC='$DescTC', DescEN='$DescEN' , TitleTC='$TitleTC', TitleEN='$TitleEN' ";
if ($Sort <> '')
	$sql .= ", Sort='$Sort' ";
	
if ($GalleryDetailFileTC <> '')
	$sql .= ", ImageTC='$GalleryDetailFileTC' ";

if ($GalleryDetailFileEN <> '')
	$sql .= ", ImageEN='$GalleryDetailFileEN' ";
	
$sql .= "where SlideId=". $SlideId ." ";
echo $sql;
mysql_query($sql);
mysql_close($dbh);

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