| Server IP : 119.59.102.212 / Your IP : 3.15.182.56 Web Server : Apache/2 System : Linux narin 2.6.32-042stab142.1 #1 SMP Tue Jan 28 23:44:17 MSK 2020 x86_64 User : yangkam ( 1022) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/yangkam/domains/yangkam.go.th/public_html/coremain/ |
Upload File : |
<?php
session_start();
include ("function_sql_query.php");
include ("function_form.php");
echo"<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
echo"<link href='ccs/style.php' rel='stylesheet' type='text/css'>";
echo "<title>จัดการเมนู</title>";
import_request_variables('pG', 'p_');
if($p_test!="") { $test=trim($p_test); }
if($p_id_top!="") { $id_top=trim($p_id_top); }
if($p_id_pic!="") { $id_pic=trim($p_id_pic); }
if($p_id_show!="") { $id_show=trim($p_id_show); }
if($p_id_del!="") { $id_del=trim($p_id_del); }
if($p_id_order!="") { $id_order=trim($p_id_order); }
if($p_check_up!="") { $check_up=trim($p_check_up); }
if($p_name!="") { $name=trim($p_name); }
if($_SESSION[web_name]=="") $_SESSION[web_name]=$web_name;
include("../$_SESSION[web_name]/connect.php");
if($oncheck==1){
?>
<script language="JavaScript">
window.opener.location.href='../index.php';
window.close();
</script>
<?php
}
// ############################################## เมนูย่อย
// ซ่อน - แสดง ข้อมูล
if($id_pic!="" and $id_show==1){
$sql="UPDATE `cms_link_picture` SET `status` = '0' WHERE id_pic ='$id_pic'";
$result=mysql_query($sql) or die(mysql_error());
}if($id_pic!="" and $id_show==2){
$sql="UPDATE `cms_link_picture` SET `status` = '1' WHERE id_pic ='$id_pic'";
$result=mysql_query($sql) or die(mysql_error());
}
// เลื่อนตำแหน่งเมนู ขึ้น-ลง
if($id_pic!="" and $id_order!=""){
$sql="SELECT * FROM `cms_link_picture` WHERE id_pic='$id_pic'";
$re=mysql_query($sql) or die(mysql_error());
$data=mysql_fetch_array($re);
if($id_order==1){ $up=$data[position]-1; }
if($id_order==2){ $up=$data[position]+1; }
// แก้ไขเลื่อนขึ้น
$sql="UPDATE `cms_link_picture` SET position='$up' WHERE id_pic ='$data[id_pic]'";
$re=mysql_query($sql) or die(mysql_error());
// แก้ไขเลื่อนลง
$sql="UPDATE `cms_link_picture` SET position='$data[position]' WHERE id_pic!='$data[id_pic]' and position='$up'";
$re=mysql_query($sql) or die(mysql_error());
}
// ลบข้อมูลทุกอย่างใน โมดูล
if($id_del!="" and $id_top!=""){
//cms_link_picture
$sql="SELECT id_pic ,pic_name FROM cms_link_picture WHERE id_pic='$id_del'";
$re=mysql_query($sql);
while($data=mysql_fetch_array($re)){
if($data[pic_name]!="") { unlink("../$_SESSION[web_name]/module_picture/$data[pic_name]"); }
$sql = "delete from cms_link_picture where id_pic='$data[id_pic]'";
$result = mysql_query($sql) or die(mysql_error());
}
}
// ############################################# เมนูหลัก
// แก้ไขเมนูหลัก
if($id_top!="" and $check_up=='2'){
$sql="UPDATE `cms_menu_top` SET name='$name' WHERE `id_top` ='$id_top'";
$result=query($sql);
}
echo "<fieldset><legend>จัดการเมนู</legend>";
// ####################### แก้ไขชื่อเมนูหลัก #############################
echo "<br><table width='95%' border='0' align='center' cellpadding='1' cellspacing='1'>";
echo "<tr bgcolor='$datatm[color]'><td colspan='2' align=left><b>แก้ไขชื่อเมนูหลัก</b></td></tr>";
echo "<tr height=10><td colspan='2' align=center></td></tr>";
$sql="SELECT * FROM cms_menu_top WHERE id_top='$id_top'";
$result=mysql_query($sql);
$data=mysql_fetch_array($result);
echo"<FORM METHOD=POST ACTION='manage_header_piclink.php?id_top=$id_top'>";
echo " <tr>";
echo " <td width='50%' align=center> <INPUT TYPE='text' NAME='name' value='$data[name]'></td> ";
echo " <td width='20%'>";
echo" <INPUT TYPE='submit' value='แก้ไขข้อมูล' onmouseover=this.style.cursor='hand'>";
echo " <INPUT TYPE='hidden' name='check_up' value='2'>";
echo"</td>";
echo " </tr>";
echo "<tr height=10><td colspan='2' align=center></td></tr>";
echo"</FORM>";
echo "</table>";
// ############################# แสดงเมนูย่อย #############################
echo "<table width='95%' border='0' align='center' cellpadding='1' cellspacing='1' bgcolor='eeeeee'>";
echo "<tr><td colspan='2' align=left><b>แสดงรูปภาพ</b></td></tr>";
echo " <tr>";
echo " <td width='50%' align=center bgcolor='dddddd'><b>รูปภาพ</b></td> ";
echo " <td width='25%' align=center bgcolor='dddddd' colspan=2><b>จัดการ</b></td>";
echo " </tr>";
$sql="SELECT * FROM `cms_link_picture` WHERE id_top='$data[id_top]' order by position asc";
$result=mysql_query($sql);
$count_l=1;
while($data=mysql_fetch_array($result)){
echo"<FORM METHOD=POST ACTION='manage_header_piclink.php?id_top=$id_top&id_pic=$data[id_pic]&id_top=$id_top'>";
echo " <tr>";
// ประเภท
$mod_pic = select_query_data("pic_name","cms_link_picture","id_pic",$data["id_pic"]);
echo " <td align=center><img src='../$_SESSION[web_name]/module_picture/$mod_pic'></td>";
// จัดการ
echo " <td align=center>";
$sql_num="SELECT count(*) FROM `cms_link_picture` WHERE id_top='$data[id_top]' order by position asc";
$re_num=mysql_query($sql_num);
$data_num=mysql_fetch_array($re_num);
// Up
if($count_l>1) {
echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_order=1&id_top=$id_top'><img src='../coremain/images/up.gif' border='0' title='เลื่อนขึ้น'></a>";
}else {
print " ";
}
// Down
if($count_l<$data_num[0]) {
echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_order=2&id_top=$id_top'><img src='../coremain/images/down.gif' border='0' title='เลื่อนลง'></a> ";
}else {
print " ";
}
// show -hide
if($data[status]=="1")
echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_show=1&id_top=$id_top' title='ซ่อนข้อมูล'><img src='../coremain/images/show.gif' border='0'></a> ";
else
echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_show=2&id_top=$id_top' title='แสดงข้อมูล'><img src='../coremain/images/hide.gif' border='0'></a> ";
// Del
echo " <a href='manage_header_piclink.php?id_del=$data[id_pic]&id_top=$id_top'><img src='../coremain/images/del1.gif' border='0' title='ลบข้อมูล' onclick='return goURLdel();'></a><br>";
echo"</td>";
echo " </tr>";
$count_l++;
echo"</FORM>";
}
echo "</table>";
// ปิดหน้าต่าง
echo "<center><INPUT TYPE='button' value='ปิดหน้านี้' onmouseover=this.style.cursor='hand' onclick ='closed_page();'></center>";
echo "</fieldset>";
?>
<script language="javascript">
function checkadd() {
if(document.add.namemenu.value=="") {
alert("กรุณากรอก ชื่อเมนูย่อย!") ;
document.add.namemenu.focus() ;
return false ;
}
else if(document.add.module.value=="0") {
alert("กรุณาเลือกประเภทโมดูล!") ;
document.add.module.focus() ;
return false ;
}
else
return true ;
}
</script>
<script language="JavaScript">
<!--
function goURLdel() {
var blnLink
blnLink = confirm("Click OK เพื่อยืนยันการลบข้อมูล?")
if (!blnLink) { return false; }
return true;
}
//-->
</script>
<script language="javascript">
function closed_page(){
window.opener.location.href='../index.php';
window.close();
}
</script>