Esempio n. 1
0
/**
 * Executes comments changes made in HiveQueen 0.0.1.
 *
 * @since 0.0.1
 *
 * @global int  $hq_current_db_version Current version.
 * @global hqdb $hqdb                  HiveQueen database abstraction object.
 */
function upgrade_430_fix_comments()
{
    global $hq_current_db_version, $hqdb;
    $content_length = $hqdb->get_col_length($hqdb->comments, 'comment_content');
    if (is_hq_error($content_length)) {
        return;
    }
    if (false === $content_length) {
        $content_length = array('type' => 'byte', 'length' => 65535);
    } elseif (!is_array($content_length)) {
        $length = (int) $content_length > 0 ? (int) $content_length : 65535;
        $content_length = array('type' => 'byte', 'length' => $length);
    }
    if ('byte' !== $content_length['type'] || 0 === $content_length['length']) {
        // Sites with malformed DB schemas are on their own.
        return;
    }
    $allowed_length = intval($content_length['length']) - 10;
    $comments = $hqdb->get_results("SELECT `comment_ID` FROM `{$hqdb->comments}`\n\t\t\tWHERE `comment_date_gmt` > '2015-04-26'\n\t\t\tAND LENGTH( `comment_content` ) >= {$allowed_length}\n\t\t\tAND ( `comment_content` LIKE '%<%' OR `comment_content` LIKE '%>%' )");
    foreach ($comments as $comment) {
        hq_delete_comment($comment->comment_ID, true);
    }
}
Esempio n. 2
0
/**
 * Moves a comment to the Trash
 *
 * If trash is disabled, comment is permanently deleted.
 *
 * @since 0.0.1
 *
 * @param int $comment_id Comment ID.
 * @return bool True on success, false on failure.
 */
function hq_trash_comment($comment_id)
{
    if (!EMPTY_TRASH_DAYS) {
        return hq_delete_comment($comment_id, true);
    }
    if (!($comment = get_comment($comment_id))) {
        return false;
    }
    /**
     * Fires immediately before a comment is sent to the Trash.
     *
     * @since 0.0.1
     *
     * @param int $comment_id The comment ID.
     */
    do_action('trash_comment', $comment_id);
    if (hq_set_comment_status($comment_id, 'trash')) {
        add_comment_meta($comment_id, '_hq_trash_meta_status', $comment->comment_approved);
        add_comment_meta($comment_id, '_hq_trash_meta_time', time());
        /**
         * Fires immediately after a comment is sent to Trash.
         *
         * @since 0.0.1
         *
         * @param int $comment_id The comment ID.
         */
        do_action('trashed_comment', $comment_id);
        return true;
    }
    return false;
}
Esempio n. 3
0
/**
 * Trash or delete an attachment.
 *
 * When an attachment is permanently deleted, the file will also be removed.
 * Deletion removes all post meta fields, taxonomy, comments, etc. associated
 * with the attachment (except the main post).
 *
 * The attachment is moved to the trash instead of permanently deleted unless trash
 * for media is disabled, item is already in the trash, or $force_delete is true.
 *
 * @since 0.0.1
 *
 * @global hqdb $hqdb HiveQueen database abstraction object.
 *
 * @param int  $post_id      Attachment ID.
 * @param bool $force_delete Optional. Whether to bypass trash and force deletion.
 *                           Default false.
 * @return mixed False on failure. Post data on success.
 */
function hq_delete_attachment($post_id, $force_delete = false)
{
    global $hqdb;
    if (!($post = $hqdb->get_row($hqdb->prepare("SELECT * FROM {$hqdb->posts} WHERE ID = %d", $post_id)))) {
        return $post;
    }
    if ('attachment' != $post->post_type) {
        return false;
    }
    if (!$force_delete && EMPTY_TRASH_DAYS && MEDIA_TRASH && 'trash' != $post->post_status) {
        return hq_trash_post($post_id);
    }
    delete_post_meta($post_id, '_hq_trash_meta_status');
    delete_post_meta($post_id, '_hq_trash_meta_time');
    $meta = hq_get_attachment_metadata($post_id);
    $backup_sizes = get_post_meta($post->ID, '_hq_attachment_backup_sizes', true);
    $file = get_attached_file($post_id);
    if (is_multisite()) {
        delete_transient('dirsize_cache');
    }
    /**
     * Fires before an attachment is deleted, at the start of hq_delete_attachment().
     *
     * @since 0.0.1
     *
     * @param int $post_id Attachment ID.
     */
    do_action('delete_attachment', $post_id);
    hq_delete_object_term_relationships($post_id, array('category', 'post_tag'));
    hq_delete_object_term_relationships($post_id, get_object_taxonomies($post->post_type));
    // Delete all for any posts.
    delete_metadata('post', null, '_thumbnail_id', $post_id, true);
    $comment_ids = $hqdb->get_col($hqdb->prepare("SELECT comment_ID FROM {$hqdb->comments} WHERE comment_post_ID = %d", $post_id));
    foreach ($comment_ids as $comment_id) {
        hq_delete_comment($comment_id, true);
    }
    $post_meta_ids = $hqdb->get_col($hqdb->prepare("SELECT meta_id FROM {$hqdb->postmeta} WHERE post_id = %d ", $post_id));
    foreach ($post_meta_ids as $mid) {
        delete_metadata_by_mid('post', $mid);
    }
    /** This action is documented in hq-includes/post.php */
    do_action('delete_post', $post_id);
    $result = $hqdb->delete($hqdb->posts, array('ID' => $post_id));
    if (!$result) {
        return false;
    }
    /** This action is documented in hq-includes/post.php */
    do_action('deleted_post', $post_id);
    $uploadpath = hq_upload_dir();
    if (!empty($meta['thumb'])) {
        // Don't delete the thumb if another attachment uses it.
        if (!$hqdb->get_row($hqdb->prepare("SELECT meta_id FROM {$hqdb->postmeta} WHERE meta_key = '_hq_attachment_metadata' AND meta_value LIKE %s AND post_id <> %d", '%' . $hqdb->esc_like($meta['thumb']) . '%', $post_id))) {
            $thumbfile = str_replace(basename($file), $meta['thumb'], $file);
            /** This filter is documented in hq-includes/functions.php */
            $thumbfile = apply_filters('hq_delete_file', $thumbfile);
            @unlink(path_join($uploadpath['basedir'], $thumbfile));
        }
    }
    // Remove intermediate and backup images if there are any.
    if (isset($meta['sizes']) && is_array($meta['sizes'])) {
        foreach ($meta['sizes'] as $size => $sizeinfo) {
            $intermediate_file = str_replace(basename($file), $sizeinfo['file'], $file);
            /** This filter is documented in hq-includes/functions.php */
            $intermediate_file = apply_filters('hq_delete_file', $intermediate_file);
            @unlink(path_join($uploadpath['basedir'], $intermediate_file));
        }
    }
    if (is_array($backup_sizes)) {
        foreach ($backup_sizes as $size) {
            $del_file = path_join(dirname($meta['file']), $size['file']);
            /** This filter is documented in hq-includes/functions.php */
            $del_file = apply_filters('hq_delete_file', $del_file);
            @unlink(path_join($uploadpath['basedir'], $del_file));
        }
    }
    hq_delete_file($file);
    clean_post_cache($post);
    return $post;
}