[관리] 일정 시간이 지나면 게시물 자동 삭제하기 > 정보공유

/extend/user.config.php

<?php
/* www/extend/user.config.php */

$table_arr = array('게시판1', '게시판2', '게시판3');
 
foreach($table_arr as $val)
{
	$count_write = 0;
	$count_comment = 0;

	$delete_bo_table = $val;
	$delete_board = sql_fetch(" select * from {$g5['board_table']} where bo_table = '$delete_bo_table' ");

	$sql = " select * from {$g5['write_prefix']}{$delete_bo_table} where wr_datetime < date_add(now(), interval - 1 day) "; // 1일
	$result = sql_query($sql);
	while ($row = sql_fetch_array($result))
	{

		$write = sql_fetch(" select * from {$g5['write_prefix']}{$delete_bo_table} where wr_id = '{$row['wr_id']}' ");

		$sql2 = " select wr_id, mb_id, wr_is_comment, wr_content from {$g5['write_prefix']}{$delete_bo_table} where wr_parent = '{$write['wr_id']}' order by wr_id ";
		$result2 = sql_query($sql2);
		while ($row2 = sql_fetch_array($result2))
		{
			// 원글이라면
			if (!$row2['wr_is_comment'])
			{
				// 원글 포인트 삭제
				if (!delete_point($row2['mb_id'], $delete_bo_table, $row2['wr_id'], '쓰기'))
					insert_point($row2['mb_id'], $delete_board['bo_write_point'] * (-1), "{$delete_board['bo_subject']} {$row2['wr_id']} 글 삭제");

				// 업로드된 파일이 있다면
				$sql3 = " select * from {$g5['board_file_table']} where bo_table = '$delete_bo_table' and wr_id = '{$row2['wr_id']}' ";
				$result3 = sql_query($sql3);
				while ($row3 = sql_fetch_array($result3)) {
					// 파일삭제
					@unlink(G5_DATA_PATH.'/file/'.$delete_bo_table.'/'.str_replace('../', '',$row3['bf_file']));

					// 썸네일삭제
					if(preg_match("/\.({$config['cf_image_extension']})$/i", $row3['bf_file'])) {
						delete_board_thumbnail($delete_bo_table, $row3['bf_file']);
					}
				}

				// 에디터 썸네일 삭제
				delete_editor_thumbnail($row2['wr_content']);

				// 파일테이블 행 삭제
				sql_query(" delete from {$g5['board_file_table']} where bo_table = '$delete_bo_table' and wr_id = '{$row2['wr_id']}' ");

				$count_write++;
			}
			else
			{
				// 코멘트 포인트 삭제
				if (!delete_point($row2['mb_id'], $delete_bo_table, $row2['wr_id'], '댓글'))
					insert_point($row2['mb_id'], $delete_board['bo_comment_point'] * (-1), "{$delete_board['bo_subject']} {$write['wr_id']}-{$row2['wr_id']} 댓글삭제");

				$count_comment++;
			}
		}

		// 게시글 삭제
		sql_query(" delete from {$g5['write_prefix']}{$delete_bo_table} where wr_parent = '{$write['wr_id']}' ");

		// 최근게시물 삭제
		sql_query(" delete from {$g5['board_new_table']} where bo_table = '$delete_bo_table' and wr_parent = '{$write['wr_id']}' ");

		// 스크랩 삭제
		sql_query(" delete from {$g5['scrap_table']} where bo_table = '$delete_bo_table' and wr_id = '{$write['wr_id']}' ");

	}

	// 글숫자 감소
	if ($count_write > 0 || $count_comment > 0)
		sql_query(" update {$g5['board_table']} set bo_count_write = bo_count_write - '$count_write', bo_count_comment = bo_count_comment - '$count_comment' where bo_table = '$delete_board' ");

	delete_cache_latest($delete_board);
}
?>