<?php //ob_start();ini_get('display_errors');?>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<?php
date_default_timezone_set('Asia/Bangkok');
function conf(){
	$return=array();
	include "config.inc.php";
	if($objConnect = mysql_connect(DB_HOST,DB_USER,DB_PASS)){
		$return['dbhost']="Connected to server";
	}else{
		//echo DB_HOST.DB_USER.DB_PASS."<BR>";
	}
	if($db_selected = mysql_select_db(DB_NAME, $objConnect)){
		$return['dbstatus']="Connected to DB";
	}else{
		//echo DB_NAME;
	}
	mysql_query("SET NAMES UTF8");
	mysql_query("SET character_set_results=utf8");
	mysql_query("SET character_set_client=utf8");
	mysql_query("SET character_set_connection=utf8");
	ini_set('max_execution_time', 300);
	return $return;
}
function addtopic($topic_head,$topic_img,$topic_sub,$topic_detail){
	conf();
	$s="select max(topic_id) as max_id from topic_list";
	$q=mysql_query($s);
	if($f=mysql_fetch_array($q)){
		$id = intval($f['max_id'])+1;
		$target = '../assets/article/';
		mkdir($target.$id,01777);
		if(move_uploaded_file($topic_img["tmp_name"],$target.$id."/".$topic_img["name"])){
			chmod($target.$id."/".$topic_img["name"],01777);
			$s1="insert into topic_list (topic_id,topic_head,topic_sub,topic_img,topic_detail,topic_date,topic_time) value (".$id.",'".$topic_head."','".$topic_sub."','".$topic_img["name"]."','".$topic_detail."','".date('Y-m-d')."','".date('H:i:s')."')";
			if($q1=mysql_query($s1)){
				?><script>alert('Saved');</script>
				<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
			}else{
				?><script>alert('ERR:SQL1');</script>
				<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
			}
		}else{
			?><script>alert('ERR:MOVE1');</script>
			<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
		}
	}else{
		?><script>alert('ERR:SQL0');</script>
		<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
	}
	
}
function edittopic($id,$topic_head,$topic_img,$topic_sub,$topic_detail){
	if(strlen($topic_img["name"])>4){
		$target = '../assets/article/'.$id.'/';
		if(move_uploaded_file($topic_img["tmp_name"],$target.$topic_img["name"])){
			chmod($target.$topic_img["name"],01777);
			?><script>alert('UPLOAD');</script><?php
		}else{
			?><script>alert('ERR');</script><?php
		}
		$s="update topic_list set
		topic_head = '".$topic_head."',
		topic_sub = '".$topic_sub."',
		topic_detail = '".$topic_detail."',
		topic_img = '".$topic_img."'
		where topic_id = ".$id."
		";
	}else{
		$s="update topic_list set
		topic_head = '".$topic_head."',
		topic_sub = '".$topic_sub."',
		topic_detail = '".$topic_detail."'
		where topic_id = ".$id."
		";
	}
	conf();
	if($q=mysql_query($s)){
		?><script>alert('SAVED');</script>
		<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
	}else{
		?><script>alert('ERR:SQL0');</script>
		<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
	}
	
}
function deltopic($id){
	conf();
	$s='delete from topic_list where topic_id ='.$id;
	if($q=mysql_query($s)){
		$files = array_diff(scandir('../assets/article/'.$id), array('.','..')); 
		foreach ($files as $file) { 
		  (is_dir('../assets/article/'.$id."/".$file)) ? delTree('../assets/article/'.$id."/".$file) : unlink('../assets/article/'.$id."/".$file); 
		} 
		if(rmdir('../assets/article/'.$id)){
			?><script>alert('Saved');</script>
			<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
		}else{
			?><script>alert('ERR:MOVE0');</script>
			<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
		}
	}else{
		?><script>alert('ERR:SQL0');</script>
		<META HTTP-EQUIV="Refresh" CONTENT="0;URL=../admin"><?php
	}
}
?>