/home/banprang/domains/plai.go.th/public_html/coremain/module/news_page/news_page_update_output.php


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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
<?php
if(id_sub_permission($id_sub)!=1){    
    
permission_fail();            
}
$navig['news_page']="";
$navig['news_page_update']=$msg_edit;
navigator($navig);
echo
"<br>";
bar_header("แก้ไขข้อมูล"); // Bar_Header
fieldset_top($data_name_menu_sub['name']);
check_user_permission($_SESSION['admin_web']);

//#5.3#//if($p_who!="")                                        {  $who=trim($p_who);                                                            }
$who = isset($p_who) ? $p_who '';
//#5.3#//if($p_topic!="")                                        {  $topic=trim($p_topic);                                                        }
$topic = isset($p_topic) ? $p_topic '';
//#5.3#//if($p_position_pic1!="")                        {  $position_pic1=trim($p_position_pic1);                            }
$position_pic1 = isset($p_position_pic1) ? $p_position_pic1 '';
//#5.3#//if($p_position_pic2!="")                        {  $position_pic2=trim($p_position_pic2);                            }
$position_pic2 = isset($p_position_pic2) ? $p_position_pic2 '';
//#5.3#//if($p_position_pic3!="")                        {  $position_pic3=trim($p_position_pic3);                            }
$position_pic3 = isset($p_position_pic3) ? $p_position_pic3 '';
//#5.3#//if($p_position_pic4!="")                        {  $position_pic4=trim($p_position_pic4);                            }
$position_pic4 = isset($p_position_pic4) ? $p_position_pic4 '';
//#5.3#//if($p_explain1!="")                                {  $explain1=trim($p_explain1);                                            }
$explain1 = isset($p_explain1) ? $p_explain1 '';
//#5.3#//if($p_explain2!="")                                {  $explain2=trim($p_explain2);                                            }
$explain2 = isset($p_explain2) ? $p_explain2 '';
//#5.3#//if($p_explain3!="")                                {  $explain3=trim($p_explain3);                                            }
$explain3 = isset($p_explain3) ? $p_explain3 '';
//#5.3#//if($p_explain4!="")                                {  $explain4=trim($p_explain4);                                            }
$explain4 = isset($p_explain4) ? $p_explain4 '';

$userfile1_name=trim($_FILES['userfile1']['name']);
$userfile2_name=trim($_FILES['userfile2']['name']);
$userfile3_name=trim($_FILES['userfile3']['name']);
$userfile4_name=trim($_FILES['userfile4']['name']);
$userfile5_name=trim($_FILES['userfile5']['name']);
                    
$date=date("d");
                    
$month=date("m");
                    
$year=date("Y");
                    
$date_post=$year.$month.$date;

//#5.3#//if($p_id_update!="")                                             {  $id_update=trim($p_id_update);            }
$id_update = isset($p_id_update) ? $p_id_update '';
//#5.3#//if($p_check_pic1!="")                                        {  $check_pic1=trim($p_check_pic1);        }
$check_pic1 = isset($p_check_pic1) ? $p_check_pic1 '';
//#5.3#//if($p_check_pic2!="")                                        {  $check_pic2=trim($p_check_pic2);        }
$check_pic2 = isset($p_check_pic2) ? $p_check_pic2 '';
//#5.3#//if($p_check_pic3!="")                                        {  $check_pic3=trim($p_check_pic3);        }
$check_pic3 = isset($p_check_pic3) ? $p_check_pic3 '';
//#5.3#//if($p_check_pic4!="")                                        {  $check_pic4=trim($p_check_pic4);        }
$check_pic4 = isset($p_check_pic4) ? $p_check_pic4 '';
//#5.3#//if($p_check_files!="")                                        {  $check_files=trim($p_check_files);        }
$check_files = isset($p_check_files) ? $p_check_files '';

// เช็คไฟล์ว่าถูกต้องหรือไม่
if($userfile1_name!="")            {    check_pic($userfile1_name,1);    }
if(
$userfile2_name!="")            {    check_pic($userfile2_name,2);    }
if(
$userfile3_name!="")            {    check_pic($userfile3_name,3);    }
if(
$userfile4_name!="")            {    check_pic($userfile4_name,4);    }
if(
$userfile5_name!="")            {    check_file($userfile5_name,5);    }

// Create_Filename
if($userfile1_name!="")    {    
        
$name1=create_filename($userfile1_name);        
        
$dlink="$_SESSION[web_name]/mainfile/".$name1;
        
delete_filename("cms_news_page","pic1",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
upload_file_to_server($dlink,$_FILES['userfile1']);        

if(
$userfile2_name!="")    {    
        
$name2=create_filename($userfile2_name);        
        
$dlink="$_SESSION[web_name]/mainfile/".$name2;
        
delete_filename("cms_news_page","pic2",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
upload_file_to_server($dlink,$_FILES['userfile2']);        
}
if(
$userfile3_name!="")    {    
        
$name3=create_filename($userfile3_name);        
        
$dlink="$_SESSION[web_name]/mainfile/".$name3;
        
delete_filename("cms_news_page","pic3",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
upload_file_to_server($dlink,$_FILES['userfile3']);        
}
if(
$userfile4_name!="")    {    
        
$name4=create_filename($userfile4_name);        
        
$dlink="$_SESSION[web_name]/mainfile/".$name4;
        
delete_filename("cms_news_page","pic4",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
upload_file_to_server($dlink,$_FILES['userfile4']);        
}
if(
$userfile5_name!="")    {    
        
$name5=create_filename($userfile5_name);        
        
$dlink="$_SESSION[web_name]/mainfile/".$name5;
        
delete_filename("cms_news_page","files",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
upload_file_to_server($dlink,$_FILES['userfile5']);        
}

//*******แก้ไขข้อมูลลงในฐาน*************************************************
$sql="select pic1,pic2,pic3,pic4,files from cms_news_page where id_sub='$_SESSION[id_sub]'";
$result=mysql_query($sql);
$data=mysql_fetch_row($result);
        if(
$userfile1_name=="")    {        $name1=$data[0];    }
        if(
$userfile2_name=="")    {        $name2=$data[1];    }
        if(
$userfile3_name=="")    {        $name3=$data[2];    }
        if(
$userfile4_name=="")    {        $name4=$data[3];    }
        if(
$userfile5_name=="")    {        $name5=$data[4];    }

// ######## เอาไฟล์ออกจากระบบ #######
if($check_pic1=="1" and $userfile1_name==""){
        
check_pic_out("cms_news_page","pic1",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
$name1="";
}
if(
$check_pic2=="1" and $userfile2_name==""){
        
check_pic_out("cms_news_page","pic2",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
$name2="";
}
if(
$check_pic3=="1" and $userfile3_name==""){
        
check_pic_out("cms_news_page","pic3",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
$name3="";
}
if(
$check_pic4=="1" and $userfile4_name==""){
        
check_pic_out("cms_news_page","pic4",$id_update,"$_SESSION[web_name]/mainfile/","id_sub");
        
$name4="";
}
if(
$check_files=="1" and $userfile5_name==""){
        
check_pic_out("cms_news_page","files",$_SESSION['id_sub'],"$_SESSION[web_name]/mainfile/","id_sub");
        
$name5="";
}

    
$sql="UPDATE `cms_news_page` SET `topic` = '$topic', `fulltexts` = '$fulltexts', `date_post` = '$date_post', `date_line` = '$date_line', `who` = '$_SESSION[name_post]',`pic1` = '$name1', `position_pic1` = '$position_pic1',`explain1` = '$explain1',`pic2` = '$name2', `position_pic2` = '$position_pic2',`explain2` = '$explain2',`pic3` = '$name3', `position_pic3` = '$position_pic3',`explain3` = '$explain3',`pic4` = '$name4', `position_pic4` = '$position_pic4',`explain4` = '$explain4',`files` = '$name5'  WHERE id_sub='$_SESSION[id_sub]' and id_type='$_SESSION[id_type]'";
    
$result mysql_query($sql) or die(mysql_error());

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

?>