1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73

<?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"); 
?>