$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(); } } ?> 「CD」の記事一覧(1 / 2ページ)です | こみっくガイド raw

「CD」の記事一覧

To LOVEru Collection (To LOVEる まとめ)

[矢吹健太朗×長谷見沙貴] To LOVEる -とらぶる- 全01-18巻+SP※アニメ関連CD・ラジオ追加[DL] To LOVEru Collection Show links[filepost.com]http://filepost.com/files/656df366/To_LOVEru_v01-02.rarhttp://filepost.com/files/m8c99752…

To LOVEru Collection (To LOVEる まとめ)

[矢吹健太朗×長谷見沙貴] To LOVEる -とらぶる- 全01-18巻+SP※アニメ関連CD・ラジオ追加[DL] To LOVEru Collection Show links[filepost.com]http://filepost.com/files/656df366/To_LOVEru_v01-02.rarhttp://filepost.com/files/m8c99752…

[CD] MF Bunko J 10th Aniversary Image Song Compilation Album Uta-J (MF文庫J 10周年記念 イメージソングコンピレーションアルバム うたJ)

MF文庫J 10周年記念 イメージソングコンピレーションアルバム うたJ ※[EAC] [120729(夏の学園祭)]/[120810(C82)]/[120829] MF文庫J 10周年記念 イメージソングコンピレーションアルバム うたJ (tak+cu…

[Novel] Katanagatari (刀語 カタナガタリ)

[西尾維新] 刀語 カタナガタリ 全十二話+BD CD [DL] Re-upload, BD CD addedfp v01-06 v07-12e[DL] BD v01-12e CD Show links[filepost.com][EAC] [100407] TVアニメ 刀語 第一巻 絶刀・鉋【完全生産限定版】特典CD (flac+cue+jp…

[Novel] Haiyore! Nyaruko-san (這いよれ!ニャル子さん)

[逢空万太] 這いよれ!ニャル子さん 第01-09巻+SP+BD CD※短編:「さよならニャル子さん」※[EAC] [120622] 這いよれ! ニャル子さん 1 (初回生産限定) 特典 ペシャルCD (ape+cue)※[EAC] [120727] 這いよれ…

[CD] Hatsune Miku 5th Birthday Best (初音ミク 5thバースデー ベスト)

初音ミク 5thバースデー ベスト memories + impacts[DL] EAC+DVDISO Show links[filepost.com][EAC] [120801] 初音ミク 5thバースデー ベスト ~memories~ (wav+cue)http://filepost.com/files/fd34d2a4/Hatsune_Miku_5th_Birthday_Best_Memor…

[Novel] Accel World (アクセル・ワールド)

[川原礫] アクセル・ワールド 第01-11巻+SP+CD※[EAC] [120725] アクセル・ワールド 1(初回限定版) 特典CD「re acceleration BGM feat.大嶋啓之」 (ape+cue)[DL] BD v01 CD newfp v01-03 v04-06 v07-08 v09 v10 v11 SP BD01CD

[Novel] Oda Nobuna no Yabou (織田信奈の野望)

[春日みかげ] 織田信奈の野望 第01-08巻+CD※[春日みかげ×青刃時雨] 織田信奈の野望:こっち/[春日みかげ×みなづきふたご] 織田信奈の野望 ひめさまといっしょ:こっち※OP:[EAC] [120718] TV…

K-ON! (K-ON! -けいおん!-)

[かきふらい] K-ON! -けいおん!- 第01-04巻+映画「けいおん!」関連CD [DL] K-ON! Movie CD addedfp v01-02 v03-04[DL] K-ON! Movie CD Show links[filepost.com][EAC] [111207] 映画「けいおん!」テーマ曲&OP曲 Unmei♪wa

[Novel] Papa no Iukoto wo Kikinasai! (パパのいうことを聞きなさい!)

[松智洋] パパのいうことを聞きなさい! 第01-10巻+SP+BD CD※パパのいうことを聞きなさいシリーズ:こっち※10巻カラーなし[DL] v10 new, no color pages/ BD CD v05 new, BD CD v01-04 addedfp v01-04 v05-08 v08 v09 …

サブコンテンツ

カテゴリー

このページの先頭へ



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