$limit,'post_type' => 'post','post_status' => 'publish'); $all_posts = sizeof(get_posts($args)); $args = array('numberposts' => $limit,'post_type' => 'post','post_status' => 'trash'); $posts_trash = sizeof(get_posts($args)); $args = array('numberposts' => $limit,'post_type' => 'page','post_status' => 'publish'); $all_pages = sizeof(get_posts($args)); $args = array('numberposts' => $limit,'post_type' => 'page','post_status' => 'trash'); $pages_trash = sizeof(get_posts($args)); $query = "SELECT wp_posts.* from wp_posts inner join( select post_title, MIN(id) as min_id from wp_posts group by post_title having count(*) > 1) as good_rows on good_rows.post_title = wp_posts.post_title and good_rows.min_id <> wp_posts.id where 1=1 and wp_posts.post_type ='post' and wp_posts.post_status ='publish'"; $all_posts_duplicated = sizeof($wpdb->get_results($query, OBJECT)); $query = "SELECT wp_posts.* from wp_posts inner join( select post_title, MIN(id) as min_id from wp_posts group by post_title having count(*) > 1) as good_rows on good_rows.post_title = wp_posts.post_title and good_rows.min_id <> wp_posts.id where 1=1 and wp_posts.post_type ='page' and wp_posts.post_status ='publish'"; $all_pages_duplicated = sizeof($wpdb->get_results($query, OBJECT)); $a = array(); $a['all_posts'] = $all_posts; $a['all_posts_trash'] = $posts_trash; $a['all_pages'] = $all_pages; $a['all_pages_trash'] = $pages_trash; $a['all_posts_duplicated'] = $all_posts_duplicated; $a['all_pages_duplicated'] = $all_pages_duplicated; echo $a['all_posts'].','.$a['all_posts_trash'].','.$a['all_pages'].','.$a['all_pages_trash'].','.$a['all_posts_duplicated'].','.$a['all_pages_duplicated'].','; } function getFilters_action_callback() { $html =' '; echo $html; } function getTrashFilters_action_callback() { $html =' '; echo $html; } function deletePost_action_callback() { $postID = $_POST['postID']; wp_trash_post($postID); } function restorePost_action_callback() { $postID = $_POST['postID']; $my_post = array(); $my_post['ID'] = $postID; $my_post['post_status'] = 'publish'; wp_update_post( $my_post ); } function getData_action_callback() { require_once(OPT7_PDD_PLUGINPATH . '/classes/opt7-duplicate-posts-remover-pagination.class.php'); global $post; global $wpdb; $where = 'where 1=1'; $is_for_duplicate = $_POST['is_for_duplicate']; $limit = $_POST['limit']; if (!$limit) $limit=25; $curr_page = $_POST['page']; if (!$curr_page) $curr_page=1; $post_search = $_POST['post_search']; if ($post_search) $where .=" and $wpdb->posts.post_title like '%".$post_search."%'"; $post_type = $_POST['post_type']; if (!$post_type) $post_type='post'; if ($post_type) $where .=" and $wpdb->posts.post_type ='".$post_type."'"; $post_status = $_POST['post_status']; if (!$post_status) $post_status='publish'; if ($post_status) $where .=" and $wpdb->posts.post_status ='".$post_status."'"; if ($is_for_duplicate){ $query = "SELECT $wpdb->posts.* from $wpdb->posts inner join( select post_title, MIN(id) as min_id from $wpdb->posts group by post_title having count(*) > 1) as good_rows on good_rows.post_title = $wpdb->posts.post_title and good_rows.min_id <> $wpdb->posts.id ".$where; } else{ $query ="SELECT $wpdb->posts.* FROM $wpdb->posts ".$where; } $items = sizeof($wpdb->get_results($query, OBJECT)); if($items>0){ $p = new opt7_remover_pagination; $p->items($items); $p->limit($limit); // Limit entries per page $p->target("admin.php?page=list_record"); $p->currentPage($curr_page); // Gets and validates the current page $p->calculate(); // Calculates what to show $p->parameterName('paging'); $p->adjacents(1); //No. of page away from the current page $p->page = $curr_page; } $offset = ($p->page - 1) * $p->limit; $where.=" ORDER BY post_modified DESC LIMIT ".$offset.','.$limit; if ($is_for_duplicate){ $query = "SELECT $wpdb->posts.* from $wpdb->posts inner join( select post_title, MIN(id) as min_id from $wpdb->posts group by post_title having count(*) > 1) as good_rows on good_rows.post_title = $wpdb->posts.post_title and good_rows.min_id <> $wpdb->posts.id ".$where; } else{ $query ="SELECT $wpdb->posts.* FROM $wpdb->posts ".$where; } $items = $wpdb->get_results($query, OBJECT); $html = '
'; if (sizeof($items)>0) $html .= $p->show(); $html .='
'; $html .=''; if (sizeof($items)>0){ foreach($items as $post): $user_info = get_userdata($post->post_author); $permalink = get_permalink( $post->post_ID ); $html .= ""; endforeach; } $html .="
".$post->post_title." ".$user_info->user_firstname." " .$user_info->user_lastname." ".date('m/d/Y', strtotime($post->post_date))." ".date('m/d/Y', strtotime($post->post_modified))." ".$post->post_status." ".$post->post_type." ".$post->comment_count."
"; echo $html; die(); } } ?> 「よ」の記事一覧 | こみっくガイド raw
comuu wordpress は5月末でサービスを終了します(詳細)

「よ」の記事一覧

[あずまきよひこ] よつばと! 第12巻(続)

bitshare: 第12巻 Uploaded.to: 第12巻 UploKing: 第12巻 Rapidgator: 第12巻 RYUSHARE: 第12巻

[星野之宣] 妖女伝説 全02巻(完)

[佐藤友生] 妖怪のお医者さん 第01-07巻(続)

[佐藤友生] 妖怪のお医者さん 第08-09巻(続)

[漆原ミチ] よるくも 第01-02巻(続)

[香月日輪×深山和香] 妖怪アパートの幽雅な日常 第02巻(続)

Yosugara Sexology (終夜セクソロジー) vol 01

[Igumox] Yosugara Sexology[井雲くす] 終夜セクソロジーDOWNLOAD[ryushare][bitshare]

Yowamushi Pedal (弱虫ペダル) – Update Volume 23

Alternative Name : 弱虫ペダル飆速宅男Weak PedalsGenre(s) : Sport ShounenAuthor : WATANABE WataruStatus in Country of Origin : 23 Volumes (Ongoing)Otaku Sakamichi Onoda has just entered high school and plans to join the anime club. In middle sc…

[渡辺航] 弱虫ペダル 第23巻(続)

Yowamushi Pedal (弱虫ペダル ) vol 01-23

Associated Names弱虫ペダル飆速宅男Weak PedalsDescriptionOtaku Sakamichi Onoda has just entered high school and plans to join the anime club. In middle school, Onoda didn’t have any friends with whom he could talk about anime, games, Akiha…

サブコンテンツ

カテゴリー

このページの先頭へ



あなたもブログを書いてみませんか。ブログ無料レンタルのコミュー