<?php
/*
/////////////////////////////////////////////////////////
// 제작 : 테러보이스
/////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////
// xml 셋팅
/////////////////////////////////////////////////////////
// 데이터만 출력
/////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////
header("Content-type: text/xml");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
/////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////
*/

echo "<?xml version=\"1.0\" encoding=\"euc-kr\"?>";
echo "<NEWS>";

/*
/////////////////////////////////////////////////////////
// 데이터 셋팅
/////////////////////////////////////////////////////////
*/

if(!defined("_INCLUDE_")){//페이지 자체가 url인 경우 즉 다른 페이지에 포함된페이지가 아닌경우
     include $DOCUMENT_ROOT . "/lib/include.php";
}

$que = "SELECT * FROM sessions WHERE use_flag = 'Y' AND menu_id >= '10000' AND menu_id <= '130000' AND sub_id = '0'";
$db->query($que);
global $i;
$i=0;
while($db->next_record()) {
	$data = $db->Record;
	$db2 = new $Fun->databaseclass; 
	
	$start_date = mktime(0,0,0,date("m"),date("d"),date("Y"));
	$end_date = mktime(23,59,59,date("m"),date("d"),date("Y"));	

	$que2 = "SELECT * FROM B".$data[menu_id]."_bbs_contents ORDER BY reg_date DESC LIMIT 0,4";
	$db2->query($que2);
	
	while($db2->next_record()) {
		$data2 = $db2->Record;
		$data3[$i][cno] = $data2[cno];
		$data3[$i][session] = $data[menu_id];
		$data3[$i][session_name] = $data[menu_name];
		$data3[$i][subject] = $data2[subject];
		$data3[$i][reg_date] = $data2[reg_date];
		$data3[$i][contents] = $data2[contents];
		$data3[$i][name] = $data2[name];
		$data3[$i][email] = $data2[email];
		
		$i++;
	}
}

$loop = count($data3);

for($i=0; $i < $loop; $i++) {
	for($j=0; $j < $loop-1; $j++) {
		if($data3[$j][reg_date] < $data3[$j+1][reg_date]) {
			$temp1 = $data3[$j+1][reg_date];
			$temp2 = $data3[$j+1][cno];
			$temp3 = $data3[$j+1][session];
			$temp4 = $data3[$j+1][session_name];
			$temp5 = $data3[$j+1][subject];
			$temp6 = $data3[$j+1][contents];
			$temp7 = $data3[$j+1][name];
			$temp8 = $data3[$j+1][email];

			$data3[$j+1][reg_date] = $data3[$j][reg_date];
			$data3[$j+1][cno] = $data3[$j][cno];
			$data3[$j+1][session] = $data3[$j][session];
			$data3[$j+1][session_name] = $data3[$j][session_name];	
			$data3[$j+1][subject] = $data3[$j][subject];
			$data3[$j+1][contents] = $data3[$j][contents];
			$data3[$j+1][name] = $data3[$j][name];
			$data3[$j+1][email] = $data3[$j][email];
	
			$data3[$j][reg_date] = $temp1;
			$data3[$j][cno] = $temp2;
			$data3[$j][session] = $temp3;
			$data3[$j][session_name] = $temp4;
			$data3[$j][subject] = $temp5;
			$data3[$j][contents] = $temp6;
			$data3[$j][name] = $temp7;
			$data3[$j][email] = $temp8;
		}
	}
}


for ($i=0; $i<"10"; $i++) {
echo "<DATETIME>".$Data_Time."</DATETIME>";
echo "<WRITER_LIST>";
echo "<WRITER>";
echo "<NAME>".$data3[$i][name]."</NAME>";
echo "<EMAIL>".$data3[$i][email]."</EMAIL>";
echo "</WRITER>";
echo "</WRITER_LIST>";
echo "<CATEGORY_LIST>";
echo "<CODE>culture</CODE>";
echo "</CATEGORY_LIST>";
$subject = $Fun->recoverhtml(stripslashes($data3[$i][subject])); 
$subject = $Fun->cutstr($subject,"65","...");
echo "<TITLE>".$subject."</TITLE>";
echo "<TEXT>".$contents."</TEXT>";
echo "<EXT>";
echo "<OUTLINK>http://www.newsgate.co.kr/read.php?session_id=".$data3[$i][session]."&num=".$data3[$i][cno]."</OUTLINK>";
echo "<COPYRIGHT><![CDATA[모든 저작권은 뉴스게이트에 있습니다.]]></COPYRIGHT>";
echo "</EXT>";
}
echo "</NEWS>";
?>