<?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(HNewsId) as maxid from HomeNews ";
$result=mysql_query($sql);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$HNewsId = $row{maxid}+1;

// copy image 
// File 1
if ($_FILES['ImageTC']['name'] <> '')
{
/* 	copy ($_FILES['ImageTC']['tmp_name'], "productimg/".$HNewsId."TC_".$_FILES['ImageTC']['name']) 
		or die ("Could not copy");		 
	$GalleryDetailFileTC = $HNewsId."TC_".$_FILES['ImageTC']['name']; */
	
	move_uploaded_file ($_FILES['ImageTC']['tmp_name'], "photos/".$HNewsId."TC_".$_FILES['ImageTC']['name']) 
		or die ("Could not copy");		 
	$GalleryDetailFileTC = "photos/".$HNewsId."TC_".$_FILES['ImageTC']['name'];
	createthumb($GalleryDetailFileTC, $GalleryDetailFileTC, 170, 170);

}
else
{	
	$GalleryDetailFileTC = "";
}

// copy image 
// File 2
if ($_FILES['ImageEN']['name'] <> '')
{
/* 	copy ($_FILES['ImageEN']['tmp_name'], "productimg/".$HNewsId."EN_".$_FILES['ImageEN']['name']) 
		or die ("Could not copy");		 
	$GalleryDetailFileEN = $HNewsId."EN_".$_FILES['ImageEN']['name']; */

	move_uploaded_file ($_FILES['ImageEN']['tmp_name'], "photos/".$HNewsId."EN_".$_FILES['ImageEN']['name']) 
		or die ("Could not copy");		 
	$GalleryDetailFileEN = "photos/".$HNewsId."EN_".$_FILES['ImageEN']['name'];
	createthumb($GalleryDetailFileEN, $GalleryDetailFileEN, 170, 170);

}
else
{	
	$GalleryDetailFileEN = "";
}

// End upload image code


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

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

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

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

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

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