Beispiel #1
0
        }
    }
    // 에디터 썸네일 삭제
    delete_editor_thumbnail($row['qa_content']);
    // 에디터 이미지 삭제
    apms_editor_image($row['qa_content']);
    // 답변이 있는 질문글이라면 답변글 삭제
    if (!$row['qa_type'] && $row['qa_status']) {
        $row2 = sql_fetch(" select qa_content, qa_file1, qa_file2 from {$g5['qa_content_table']} where qa_parent = '{$qa_id}' ");
        // 첨부파일 삭제
        for ($k = 1; $k <= 2; $k++) {
            @unlink(G5_DATA_PATH . '/qa/' . $row2['qa_file' . $k]);
            // 썸네일삭제
            if (preg_match("/\\.({$config['cf_image_extension']})\$/i", $row2['qa_file' . $k])) {
                delete_qa_thumbnail($row2['qa_file' . $k]);
            }
        }
        // 에디터 썸네일 삭제
        delete_editor_thumbnail($row2['qa_content']);
        // 에디터 이미지 삭제
        apms_editor_image($row2['qa_content']);
        sql_query(" delete from {$g5['qa_content_table']} where qa_type = '1' and qa_parent = '{$qa_id}' ");
    }
    // 답변글 삭제시 질문글의 상태변경
    if ($row['qa_type']) {
        sql_query(" update {$g5['qa_content_table']} set qa_status = '0' where qa_id = '{$row['qa_parent']}' ");
    }
    // 글삭제
    sql_query(" delete from {$g5['qa_content_table']} where qa_id = '{$qa_id}' ");
}
goto_url(G5_BBS_URL . '/qalist.php' . preg_replace('/^&amp;/', '?', $qstr));
Beispiel #2
0
         }
         // 업로드된 파일이 있다면
         $sql2 = " select * from {$g5['board_file_table']} where bo_table = '{$bo_table}' and wr_id = '{$row['wr_id']}' ";
         $result2 = sql_query($sql2);
         while ($row2 = sql_fetch_array($result2)) {
             // 파일삭제
             @unlink(G5_DATA_PATH . '/file/' . $bo_table . '/' . $row2['bf_file']);
             // 썸네일삭제
             if (preg_match("/\\.({$config['cf_image_extension']})\$/i", $row2['bf_file'])) {
                 delete_board_thumbnail($bo_table, $row2['bf_file']);
             }
         }
         // 에디터 썸네일 삭제
         delete_editor_thumbnail($row['wr_content']);
         // 에디터 이미지 삭제
         apms_editor_image($row['wr_content']);
         // 파일테이블 행 삭제
         sql_query(" delete from {$g5['board_file_table']} where bo_table = '{$bo_table}' and wr_id = '{$row['wr_id']}' ");
         $count_write++;
     } else {
         // 코멘트 포인트 삭제
         if (!delete_point($row['mb_id'], $bo_table, $row['wr_id'], '댓글')) {
             insert_point($row['mb_id'], $board['bo_comment_point'] * -1, "{$board['bo_subject']} {$write['wr_id']}-{$row['wr_id']} 댓글삭제");
         }
         $count_comment++;
     }
     // 신고글
     sql_query(" delete from {$g5['apms_shingo']} where bo_table = '{$bo_table}' and wr_id = '{$row['wr_id']}' ", false);
 }
 // 게시글 삭제
 sql_query(" delete from {$write_table} where wr_parent = '{$write['wr_id']}' ");
Beispiel #3
0
     if (strstr($row2['wr_option'], 'html')) {
         $log_tag1 = '<div class="content_' . $sw . '">';
         $log_tag2 = '</div>';
     } else {
         $log_tag1 = "\n";
         $log_tag2 = '';
     }
     //$row2['wr_content'] .= "\n".$log_tag1.'[이 게시물은 '.$nick.'님에 의해 '.G5_TIME_YMDHIS.' '.$board['bo_subject'].'에서 '.($sw == 'copy' ? '복사' : '이동').' 됨]'.$log_tag2;
 }
 // 분류
 $row2['ca_name'] = $ca_name ? $ca_name : $row2['ca_name'];
 // 에디터 이미지 복사
 if ($sw == "move" && $bo_table == $move_bo_table) {
     $tmp_content = $row2['wr_content'];
 } else {
     $tmp_content = $row2['wr_is_comment'] ? $row2['wr_content'] : apms_editor_image($row2['wr_content'], $sw);
 }
 $sql = " insert into {$move_write_table}\n                        set wr_num = '{$next_wr_num}',\n                             wr_reply = '{$row2['wr_reply']}',\n                             wr_is_comment = '{$row2['wr_is_comment']}',\n                             wr_comment = '{$row2['wr_comment']}',\n                             wr_comment_reply = '{$row2['wr_comment_reply']}',\n                             ca_name = '" . addslashes($row2['ca_name']) . "',\n                             wr_option = '{$row2['wr_option']}',\n                             wr_subject = '" . addslashes($row2['wr_subject']) . "',\n                             wr_content = '" . addslashes($tmp_content) . "',\n                             wr_link1 = '" . addslashes($row2['wr_link1']) . "',\n                             wr_link2 = '" . addslashes($row2['wr_link2']) . "',\n                             wr_link1_hit = '{$row2['wr_link1_hit']}',\n                             wr_link2_hit = '{$row2['wr_link2_hit']}',\n                             wr_hit = '{$row2['wr_hit']}',\n                             wr_good = '{$row2['wr_good']}',\n                             wr_nogood = '{$row2['wr_nogood']}',\n                             mb_id = '{$row2['mb_id']}',\n                             wr_password = '******'wr_password']}',\n                             wr_name = '" . addslashes($row2['wr_name']) . "',\n                             wr_email = '" . addslashes($row2['wr_email']) . "',\n                             wr_homepage = '" . addslashes($row2['wr_homepage']) . "',\n                             wr_datetime = '{$row2['wr_datetime']}',\n                             wr_file = '{$row2['wr_file']}',\n                             wr_last = '{$row2['wr_last']}',\n                             wr_ip = '{$row2['wr_ip']}',\n                             as_type = '{$row2['as_type']}',\n\t\t\t\t\t\t\t as_img = '{$row2['as_img']}',\n                             as_list = '{$row2['as_list']}',\n                             as_publish = '{$row2['as_publish']}',\n\t\t\t\t\t\t\t as_extra = '{$row2['as_extra']}',\n\t\t\t\t\t\t\t as_download = '{$row2['as_download']}',\n\t\t\t\t\t\t\t as_down = '{$row2['as_down']}',\n\t\t\t\t\t\t\t as_view = '{$row2['as_view']}',\n\t\t\t\t\t\t\t as_level = '{$row2['as_level']}',\n\t\t\t\t\t\t\t as_lucky = '{$row2['as_lucky']}',\n\t\t\t\t\t\t\t as_poll = '{$row2['as_poll']}',\n\t\t\t\t\t\t\t as_star_score = '{$row2['as_star_score']}',\n\t\t\t\t\t\t\t as_star_cnt = '{$row2['as_star_cnt']}',\n\t\t\t\t\t\t\t as_re_mb = '{$row2['as_re_mb']}',\n\t\t\t\t\t\t\t as_re_name = '{$row2['as_re_name']}',\n                             as_tag = '" . addslashes($row2['as_tag']) . "',\n                             as_icon = '" . addslashes($row2['as_icon']) . "',\n                             as_update = '{$row2['as_update']}',\n                             wr_1 = '" . addslashes($row2['wr_1']) . "',\n                             wr_2 = '" . addslashes($row2['wr_2']) . "',\n                             wr_3 = '" . addslashes($row2['wr_3']) . "',\n                             wr_4 = '" . addslashes($row2['wr_4']) . "',\n                             wr_5 = '" . addslashes($row2['wr_5']) . "',\n                             wr_6 = '" . addslashes($row2['wr_6']) . "',\n                             wr_7 = '" . addslashes($row2['wr_7']) . "',\n                             wr_8 = '" . addslashes($row2['wr_8']) . "',\n                             wr_9 = '" . addslashes($row2['wr_9']) . "',\n                             wr_10 = '" . addslashes($row2['wr_10']) . "' ";
 sql_query($sql);
 $insert_id = sql_insert_id();
 // 코멘트가 아니라면
 if (!$row2['wr_is_comment']) {
     $save_parent = $insert_id;
     $sql3 = " select * from {$g5['board_file_table']} where bo_table = '{$bo_table}' and wr_id = '{$row2['wr_id']}' order by bf_no ";
     $result3 = sql_query($sql3);
     for ($k = 0; $row3 = sql_fetch_array($result3); $k++) {
         $tmp_file = $row3['bf_file'];
         if ($tmp_file) {
             if ($is_same_board) {
                 // 동일 게시판
                 shuffle($chars_array);