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

<?php
$navig['news']="แก้ไขข้อมูล";
navigator($navig);
echo"<br>";
bar_header("แก้ไขข้อมูล"); // Bar_Header
check_user_permission($_SESSION[admin_web]);
fieldset_top("ลิงค์");
import_request_variables('pG', 'p_');
$userfile1_name=trim($_FILES['userfile1']['name']);

$sql="SELECT * FROM cms_link_sponser WHERE id_sponser='$id_sponser'";
$re=mysql_query($sql);
$data=mysql_fetch_array($re);
$strings1=substr($data[pic_name],-4);
$strings1=strtolower($strings1); 

// เช็คไฟล์ว่าถูกต้องหรือไม่
if($p_id_sponser!="")                        {             $id_sponser=trim($p_id_sponser);                        }
if($p_pic_description!="")                {             $pic_description=trim($p_pic_description);            }
if($p_link_target!="")                        {             $link_target=trim($p_link_target);                            }

// Create_Filename
if($userfile1_name!="")    {    
        $name1=create_filename($userfile1_name);        
        $dlink="$_SESSION[web_name]/module_sponser/".$name1;
        delete_filename("cms_link_sponser","pic_name",$id_update,"$_SESSION[web_name]/module_sponser/","id_sponser");
        upload_file_to_server($dlink,$_FILES['userfile1']);        
        list($width, $height, $type, $attr) = getimagesize($_SESSION['web_name']."/module_sponser/$name1");
} 

//*******แก้ไขข้อมูลลงในฐาน*************************************************
$sql="select pic_name from cms_link_sponser where id_sponser='$id_sponser'";
$result=mysql_query($sql);
$data=mysql_fetch_row($result);
        if($userfile1_name=="")    {        
            $name1=$data[0];
            $sql="UPDATE `cms_link_sponser` SET `pic_description` = '$pic_description', `link` = '$link_target' WHERE id_sponser='$id_sponser'";
            $result = mysql_query($sql) or die(mysql_error());    
        }else{
            $sql="SELECT `pic_name` FROM `cms_link_sponser` WHERE id_sponser='$id_sponser'";
            $re=mysql_query($sql);
            $data=mysql_fetch_array($re);
            if($data[0]!=""){
                unlink("$_SESSION[web_name]/module_sponser/$data[0]");
                }
            if($strings1!=".swf"){
                        $sql="UPDATE `cms_link_sponser` SET `pic_name`='$name1',`pic_description` = '$pic_description', `link` = '$link_target' WHERE id_sponser='$id_sponser'";
            }else{
                        $sql="UPDATE `cms_link_sponser` SET `pic_name`='$name1',`pic_description` = '$width', `link` = '$height' WHERE id_sponser='$id_sponser'";
            }
            $result = mysql_query($sql) or die(mysql_error());            
        }


msg_update_data(); // ข้อความแก้ไขแล้ว
refresh_data('index.php',2);    // refresh หน้าจอ
fieldset_down();
?>