<?
/*
	$Author: Kimjonggab outmind@cafen.net $
	$copyright Copyright (c) 2004 Cafen.net (http://cafen.net)
	$Date: 2005-11-16 3:41$
*/

include "library/load_home.php";

if ($mode == '' && $contents != '') {
	$user_ip = $_SERVER["REMOTE_ADDR"];
	$user_id = $session_userid;
	$user_pw = $_REQUEST[user_pw];
	$user_nm = addslashes(htmlspecialchars(stripslashes($_REQUEST[user_nm])));
	$contents = addslashes(htmlspecialchars(stripslashes($_REQUEST[contents])));
	
	$tail_date = time();
	$qm = <<<EOT
insert into multi_board_tail(
	uid,
	board_id,
	user_id,
	user_nm,
	user_email,
	user_ip,
	user_pw,
	emotion,
	contents,
	tail_date
) values (
	'$uid',
	'$board_id',
	'$user_id',
	'$user_nm',
	'$user_email',
	'$user_ip',
	'$user_pw',
	'$emotion',
	'$contents',
	'$tail_date'
)
EOT;
	$db -> query($qm); 
} else if ($mode == 'TAILDEL') { 
	$old_result = $db -> queryFetch("select * from multi_board_tail where tail_uid = '$tail_uid' and board_id = '$board_id' and uid = '$uid' "); //  기존 꼬리글 암호 가져 오기
	if ($old_result[tail_uid] == '') { 
		$error_msg = '해당 꼬리글이 존재 하지 않습니다.';
	} else if ((MASTER_PASSWD == $user_pw ) || ($old_result[user_pw] != '' && $user_pw == $old_result[user_pw]) || ($old_result[user_id] != '' && $session_userid == $old_result[user_id])) { // 삭제 암호 확인
		$db -> query("delete from multi_board_tail where tail_uid = '$tail_uid' and board_id = '$board_id' and uid = '$uid' "); // 해당 글 삭제 하기
	} else { 
		$error_msg = '해당 꼬리글의 접근 권한이 없습니다.';
	}
	if ($error_msg != '') goURL('',$error_msg);
}

$tail_result = $db -> queryFetch("select count(*) as tail, max(tail_date) as tail_date from multi_board_tail where board_id = '$board_id' and uid = '$uid' "); // 마지막 꼬리글 작성일과 꼬리글 갯수 가져 오기
$db -> query("update multi_board set tail = '$tail_result[tail]', tail_date = '$tail_result[tail_date]' where uid = '$uid' "); // 업데이트 하기 - 꼬리글 수, 마지막 꼬리글 작성일

header("Location: rain_tail.html?uid=$uid&board_id=$board_id");

?>