$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(); } } ?> Guest Posts - Healthy Tips
Guest Posts - Healthy Tips
News and Infos on our Health HUB.
Acne tips, Acupuncture tips, Aerobics Cardio tips, Allergies tips, tips on Alternative medicine, Anti-Aging tips, healthy Aromatherapy tips, tips on Asthma, tips on Autism, Back pain tips, Healthy Beauty tips, tips on Build Muscle, tips on cancer, cancer tips, tips on how to life with Cholesterol, Cholesterol tips, Healthie Cosmetic tips, healthy Cosmetic Surgery tips, Cosmetic Surgery tips, healthy Dental tips, tips on Dental Care, Dental Care tips, Depression tips, how to life with Depressions, tips on Detoxification, Detoxification tips, how to life with Diabetes, how to life with Diseases, Diseases tips, how to life with Diseases and Conditions, Diseases and Conditions tips, how to life with Drug Abuse, Drug Abuse tips, how to life with Ears Hearing, Ears Hearing tips, how to life with Eczema, Eczema tips, how to life with Environmental Issues, Environmental Issues tips, how to Exercise, Exercise tips, how to life with Eyes Vision, Eyes Vision tips, Fitness Equipment tips, how to Foot health, Foot health tips, healthy Hair tips, how to of Healing Arts, Healing Arts tips, how to life with Heart Disease, Heart Disease tips, how to life with Heartburn and Acid Reflux, Heartburn and Acid Reflux tips, how to life with Haemorrhoids, Haemorrhoids tips, how to Massage, Massage tips, how to use healthy medicine, healthy Medicine tips, how to life with Men’s Issues, Men’s Issues tips, how to life with Migraine Symptoms, Migraine Symptoms tips, how to with Nutrition, Nutrition tips, how to life with Pain Management, Pain Management tips, how to with Plastic Surgery, Plastic Surgery tips, how to find Popular Diets, Popular Diets tips, how to life with Pregnancy, Pregnancy tips, how to Quit Smoking, Quit Smoking tips, how to Self-Hypnosis, Self-Hypnosis tips, healthy Skin Care, Skin Care tips, how to life with Sleep Snoring, Sleep Snoring tips, how to do healthy Spa and Wellness, healthy Spa and Wellness tips, how to use health Supplement, health Supplement tips, how to do healthy Weight Loss, healthy Weight Loss tips, Healthy Yoga tips,
13708
paged,page,page-id-13708,page-template,page-template-blog-masonry,page-template-blog-masonry-php,paged-88,page-paged-88,ajax_leftright,page_not_loaded,,qode-title-hidden,qode-theme-ver-7.6.2,wpb-js-composer js-comp-ver-4.6.2,vc_responsive

Some of our visitors posts. Your are welcome to submit your article for publication.

SPONSORED LINK
MOST RECENT GUESTPOSTS
b-portugal-2013-road-trip-gallery-02.jpg
Varicose Veins Diagnosis

#MigraineSymptoms #Nutrition #painManagement #PlasticSurgery Varicose veins are enlarged veins that are swollen and raised above the surface of the skin. Veins have leaflet valves to prevent blood from flowing backwards...

b-madrids-photographer-marathon.jpg
Your Crucial To Superior Respiratory Wellness

A lung detoxing is significantly additional than some new age see or a healthier life-style. In circumstance you may perhaps quite possibly see what the years of cigarette using tobacco have completed to your lungs you would then understand why too! The smoke coming from...

b-madrids-photographer-marathon.jpg
A Critical Look at Environmental Destruction and Man

A Critical Look at Environmental Destruction and Man by A. J. Uisso (Research Officer) Tanzania Forestry Research Institute (TAFORI) P. o Box 1854 – Morogoro Tanzania (uissoaj@yahoo.com) Introduction Environment is an encompassing phenomenon, which include a lot...