/** * 댓글을 삭제한다. * @param int $uid */ public function delete($uid) { global $wpdb; $uid = intval($uid); //댓글 삭제 액션 훅 실행 do_action('kboard_comments_delete', $uid); if (empty($this->content_uid)) { $comment = new KBComment(); $comment->initWithUID($uid); $content_uid = $comment->content_uid; } else { $content_uid = $this->content_uid; } $wpdb->query("DELETE FROM `" . KBOARD_DB_PREFIX . "kboard_comments` WHERE `uid`='{$uid}'"); // 댓글 숫자를 게시물에 등록한다. $wpdb->query("UPDATE `" . KBOARD_DB_PREFIX . "kboard_board_content` SET `comment`=`comment`-1 WHERE `uid`='" . $content_uid . "'"); }
/** * 자식 댓글을 삭제한다. * @param int $parent_uid */ public function deleteChildren($parent_uid) { global $wpdb; $parent_uid = intval($parent_uid); if ($this->content_uid) { $content_uid = $this->content_uid; } else { $comment = new KBComment(); $comment->initWithUID($uid); $content_uid = $comment->content_uid; $this->setContentUID($content_uid); } $resource = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}kboard_comments` WHERE `parent_uid`='{$parent_uid}'"); foreach ($resource as $key => $child) { $wpdb->query("DELETE FROM `{$wpdb->prefix}kboard_comments` WHERE `uid`='{$child->uid}'"); // 게시물의 댓글 숫자를 변경한다. $wpdb->query("UPDATE `{$wpdb->prefix}kboard_board_content` SET `comment`=`comment`-1 WHERE `uid`='" . $content_uid . "'"); // 자식 댓글을 삭제한다. $this->deleteChildren($child->uid); } }
public function kboard_comments_delete($comment_uid, $board_id) { $comment = new KBComment(); $comment->initWithUID($comment_uid); if ($comment->user_uid) { $this->core->add_creds('kboard_comments_delete', $comment->user_uid, $this->prefs['delete']['creds'], $this->prefs['delete']['log'], 0, '', $this->mycred_type); } }