<?php
if($_SESSION[admin_web]!="admin")	{	
	permission_fail();
}
$navig['manage_main_data']="แก้ไขข้อมูลหลัก";
navigator($navig);
print "<br>";
bar_header("แก้ไขข้อมูลหลัก"); // Bar_Header
fieldset_top("	ข้อมูลหลัก");
if($p_Submit!="")				{	     $Submit=trim($p_Submit);	}
if($p_namess!="")				{	     $namess=trim($p_namess);	}
if($p_address!="")				{	     $address=trim($p_address);	}
if($p_emailss!="")				{	     $emailss=trim($p_emailss);	}
if($p_tel!="")						{	     $tel=trim($p_tel);	}
if($p_fax!="")						{	     $fax=trim($p_fax);	}
if($p_check_footer!="")	{	     $check_footer=trim($p_check_footer);	}
if($p_dates!="")					{	     $dates=trim($p_dates);	}


		$s="SELECT * FROM cms_main_data ";
		$r=mysql_query($s);
		$d=mysql_num_fields($r);
		if($d==6){
		// update field
		 $xx="ALTER TABLE `cms_main_data` ADD `status` INT( 1 ) NOT NULL DEFAULT '1'";
		 mysql_query($xx);
		}

if($Submit!=""){
		$sql="UPDATE `cms_main_data` SET `name_web` = '$namess',`address` = '$address',`tel` = '$tel',`fax` = '$fax',`email` = '$emailss',status='$check_footer' WHERE `cms_main_data`.`id_main_data` ='1'";
		mysql_query($sql);

		$sql="UPDATE `cms_counter` SET `dates` = '$dates'";
		mysql_query($sql);

		msg_update_data(); // ข้อความแก้ไขแล้ว
		refresh_data("index.php?mod=manage_main_data","2");	// refresh หน้าจอ
}

if($Submit==""){
$sql = "SELECT * FROM cms_main_data";
$result = mysql_query($sql) or die(mysql_error());
$data = mysql_fetch_array($result);

$sqls = "SELECT * FROM cms_counter";
$results = mysql_query($sqls) or die(mysql_error());
$datas = mysql_fetch_array($results);
?>
<br><br>
<form  action="index.php?mod=manage_main_data" method="post" name="add" id="add"> 
<table width='100%' border='0' cellspacing='0' align='center' height='20'>
   <tr>
     <td valign='top'>


<table width="100%" border="0" align="center" cellspacing='0'>

	<tr height='30'>
     <td><div align="left">&nbsp;<img src='coremain/images/marker.gif'>&nbsp;<strong>ชื่อหน่วยงาน</strong></div></td> 
	 <td><div align="left"><input name="namess" type="text" size="50" value="<?echo $data[name_web]?>"></td> 
  </tr>

    <tr height='30'>
     <td><div align="left">&nbsp;<img src='coremain/images/marker.gif'>&nbsp;<strong>ที่อยู่</strong></div></td> 
	 <td><div align="left"><input name="address" type="text" size="50" value="<?echo $data[address]?>"></td> 
  </tr>

    <tr height='30'>
     <td><div align="left">&nbsp;<img src='coremain/images/marker.gif'>&nbsp;<strong>อีเมล์</strong></div></td> 
	 <td><div align="left"><input name="emailss" type="text" size="50" value="<?echo $data[email]?>"></td> 
  </tr>

    <tr height='30'>
     <td><div align="left">&nbsp;<img src='coremain/images/marker.gif'>&nbsp;<strong>โทรศัพท์</strong></div></td> 
	 <td><div align="left"><input name="tel" type="text" size="50" value="<?echo $data[tel]?>"></td> 
  </tr>

   <tr height='30'>
     <td><div align="left">&nbsp;<img src='coremain/images/marker.gif'>&nbsp;<strong>โทรสาร</strong></div></td> 
	 <td><div align="left"><input name="fax" type="text" size="50" value="<?echo $data[fax]?>"></td> 
  </tr>

    <tr height='30'>
     <td><div align="left">&nbsp;<img src='coremain/images/marker.gif'>&nbsp;<strong>วันที่จดโดเมนเนม (ปี-เดือน-วัน)</strong></div></td> 
	 <td><div align="left"><input name="dates" type="text" size="50" value="<?echo $datas[dates]?>"></td> 
  </tr>

   <tr height='30'>
     <td><div align="left">&nbsp;<img src='coremain/images/marker.gif'>&nbsp;<strong>แสดงข้อความนี้ข้างล่าง</strong></div></td> 
	 <td><div align="left">
	 <?php
		if($data[status]=="1"){
			echo"<INPUT TYPE='checkbox' NAME='check_footer' checked value=1>";
		}else{
			echo"<INPUT TYPE='checkbox' NAME='check_footer' value=1>";
		}
	?>
	</td> 
   </tr>
    
  <tr height='30'> 
    <td colspan="2"><div align="left"></div><div align="left"> 
      <center><br><input type="submit" name="Submit" value="แก้ไขข้อมูลหลัก" onmouseover="this.style.cursor='hand'"></center> 
    </td>
  </tr>
  </table><br>

  					 </td>
				   </tr>
			   </table>
</form>   
<?php }
		fieldset_down();			 
?>