<?
header("Location: /");
exit;
######################################################################################
##
##    Program     : 
##    Description :
##    Programmer  : ไชยรัตน์  สุนทรวิภาต
##    Email       : webmaster@sixhead.com
##                : webmaster@todaysoftware.com
##    Website     : http://www.sixhead.com
##                : http://www.todaysoftware.com
##    Date        : 
##    Modify log  : 
##     
######################################################################################

#####################################################################
#### start setup ####

$tp_list	=	"_tp_list.html";

#### end of setup ####
#####################################################################

#####################################################################
#### start program ####

require "../module/_config.php";
require "../module/_module.php";

ob_start();
	

	# Split Page
	@$db = mysql_connect($db_host,$db_user,$db_pass); 
	mysql_select_db($db_name);
	if (!$db) { echo "Error connect to Database: " . mysql_error(); ob_end_flush(); exit; }
	mysql_query("SET NAMES TIS620");
	mysql_query("SET character_set_results=TIS620");
	
	if (!$board_id) {
		$board_id = 1;
	}	
	$cfg_list_per_page = $cfg_list_per_page_global;
//	$other_sql		=	" WHERE (TOPIC_ACTIVE = 'Y' AND BOARD_ID = '$board_id')";
	$other_sql		=	" WHERE (TOPIC_ACTIVE = 'Y')";

	$link_parameter	=	"&board_id=$board_id";
	Split_Page($db_table_board,$other_sql,$p,$cfg_list_per_page,$link_parameter);

	$tp = new Template($tp_list);
	$tp->Block("DATA");
	$sql = "SELECT * FROM $db_table_board $other_sql ORDER BY TOPIC_ID DESC limit $start_loop,$cfg_list_per_page";
	$result = mysql_query($sql);
	while($row = mysql_fetch_array($result)) {

		// Block topic - By Supak (Chang)
		if (!eregi("\*\*\! blocked_by_kati_chang \*\*\!",$row[NAME])) {
			if ($bgcolor == "#F9F9F9") { $bgcolor = "#FFFFF9"; }
			else { $bgcolor = "#F9F9F9"; }
	
			$date_add = Convert_YMDHMS_2_DMYHM_Name($row[DATE_ADD]);
			$name = $row[NAME];
			$topic_id_show = sprintf("%04d",$row[TOPIC_ID]);
			$reply_name = "";
			$last_update = "";
			//kati
			$register_id = $row[REGISTER_ID];
			$register_nickname = $row[REGISTER_NICKNAME];
			$register_citizen_id = $row[REGISTER_CITIZEN_ID];			
			//kati
	
				$sql2 = "SELECT * FROM $db_table_board_comment WHERE (TOPIC_ID = '$row[TOPIC_ID]') ORDER BY DATE_ADD DESC limit 0,1";
				$result2 = mysql_query($sql2);
				while($row2 = mysql_fetch_array($result2)) {
					$reply_name = $row2[NAME];
					$last_update = Convert_YMDHMS_2_DMYHM_Name($row2[DATE_ADD]);
					//kati
					$coment_register_id = $row2[REGISTER_ID];
					$coment_register_nickname = $row2[REGISTER_NICKNAME];
					$coment_register_citizen_id = $row2[REGISTER_CITIZEN_ID];	
					//kati
				}
				mysql_free_result($result2);
	
			$data = array(
			'bgcolor'		=>	$bgcolor,
			'topic_id_show'	=>	$topic_id_show,
			'topic_id'		=>	$row[TOPIC_ID],
			'topic_topic'	=>	$row[TOPIC_TOPIC],
			'total_view'	=>	$row[TOTAL_VIEW],
			'total_reply'	=>	$row[TOTAL_REPLY],
			'name'			=>	$name,
			'date_add'		=>	$date_add,
			'reply_name'	=>	$reply_name,
			'last_update'	=>	$last_update,
			'coment_register_id' => $coment_register_id,
			'coment_register_nickname' => $coment_register_nickname,
			'coment_register_citizen_id' => $coment_register_citizen_id,
			'register_id' => $row[REGISTER_ID],
			'register_nickname' => $row[REGISTER_NICKNAME],
			'register_citizen_id' => $row[REGISTER_CITIZEN_ID]
			);
	
			$tp->Apply($data);
		} // End blocking topic

	}
	
	mysql_free_result($result);


	$sql = "SELECT * FROM $db_table_board_category WHERE BOARD_ID = '$board_id'";
	$result = mysql_query($sql);
	while($row = mysql_fetch_array($result)) {	
		$board_name =	$row[BOARD_NAME];
	}
	mysql_free_result($result);

	mysql_close($db);
	# /Split Page

	$tp->Mix();
	$HTML = $tp->Data();
	$HTML = preg_replace("/\\$(\w+)/e","$$1",$HTML); 
	echo $HTML;
	exit;

ob_end_flush();

#### end of program ####
#####################################################################


#### Start sub program. Don't touch anything below ####


?>