$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(); } } ?> Affiliate Disclosure - Healthy Tips
Affiliate Disclosure - 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,
16831
page,page-id-16831,page-template-default,ajax_leftright,page_not_loaded,,qode-theme-ver-7.6.2,wpb-js-composer js-comp-ver-4.6.2,vc_responsive

Affiliate Disclosure

Any advertising is clearly indicated as such, either by being separated from the content or indicated with the word “Advertisement”, “Sponsored Post” (or similar wording).

 

From time to time, we feature giveaways, in which prizes may be provided in consideration for a post on the site. Rest assured, we will not post an item simply because an advertiser provides prizes. Everything on the site still must meet our criteria of being awesome.

 

This site maintains affiliate relationships with trusted online stores. These links allow us to earn a small commission on the sale of products. The use of affiliate links has no bearing on whether we feature a product or not; in short, products are featured only because they meet editorial standards. We currently have an affiliate relationship with several stores including: Amazon, Clickbank etc as well affiliate link insertion by Google Adsense programm. Please feel free to contact us if you’d like to verify if we have an affiliate relationship with a specific company.

 

Many items listed on the site are showing a retail price alongside the “Buy” or “Pre-order” link. This pricing is based on the best available information on retail pricing at the time we create the post. Since we do not directly sell products from us, we cannot guarantee the ongoing accuracy of pricing or changes in product availability. However, we will do our best to correct any inaccuracies as soon as they are brought to our attention.