페이지 정보

본문
/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);
}
?>
댓글목록
등록된 댓글이 없습니다.