$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-15,page-paged-15,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
process11.jpg
Beneficial Strategies On How To Stop Zits Scars

Zits is a skin affliction that most adolescents and even a number of older people have to contend with. It is induced when someone has dreadfully oily skin or when our hormones are altering and maximizing the generation of oils in our skin. For most...

How to Show Your Wife You Love Her
Successful Allergy Treatment

#Supplement #WeightLoss #Weight #Yoga Allergy is an abnormal, acquired sensitivity to a given substance, including pollen, drugs, or numerous environmental triggers. People who have allergies often are sensitive to more than one thing....

process41.jpg
Workout At House Without the need of Weights

House exercising is the new phenomenon in physical fitness, and the explosive advancement of residence exercising equipment is enough proof. It really is quick to see why several persons would be fascinated in residence exercising routines. You can get good results exercising at residence, as...

process21.jpg
Migraine Headaches symptoms & results in

Indications of Migraine Headaches What are you to do when a unpleasant migraine will come on all of a sudden and you are searching for a dwelling migraine treatment that offers instant aid? A lot of of us get aspirin or ibuprofen, but this cure...

team11.jpg
Duck Diseases – 20 Preventions and Controls Tips When Caring For Ducks

Ducks are most resistant to diseases than chicken and other fowls. Losses from various causes can be minimized through proper management, adequate appropriate feeding and housing, strict sanitary practices, and effective prevention medication and vaccination program. However, even with all precautionary measures, substantial losses are...

team41.jpg
How To Acquire A Retail Keep Treadmill

If you have been searching for a treadmill to invest in for any duration of time, then you know a excellent one particular is not low-cost. That usually means you need to have to just take your time and make a excellent decision. Listed here...

b-madrids-photographer-marathon-02.jpg
Cost-free Self Hypnosis Mp3 – To Adjust What&#039s on Your Head!

---> Fundamental Hypnosis Certification Review  (latest edition) The ability of hypnosis is incredible. If you believe that with the intention of the major brings about of the greatest aspect of our diseases, take spot it psychological or else corporeal, are rooted deep surrounded by our minds,...

team21.jpg
Some Tips about how to Build Muscle

Your system builds muscle in a natural way in response to intense activity. But if your each day regimen doesn't contain difficult your muscle tissue to develop, how do you induce the muscle-building procedure? It doesn't take place right away (as any bodybuilder can notify...

team11.jpg
Fish Spas and Solutions – Unusual or Wonderful?

Some thoughts take a tiny having employed to. Even so, countless spa goers will need no persuasion when it will come to being nibbled by little fish at designer spas and spa resorts in international locations these as China, Japan, South Korea and Turkey. This...

b-madrids-photographer-marathon.jpg
How to Cope With Male Menopause and Depression

For many years, people today have only linked menopause to females. Nevertheless, experiments have found that males practical experience a identical affliction. Folks frequently refer to this as a mid-lifestyle crisis. Male menopause has been found to have identical indicators that females practical experience. Male...

b-inteligent-transitions-in-ux-design.jpg
Enamel Whitening Recommendations at Home

Enamel whitening does not have to be highly-priced. There are a whole lot of tooth whitening solutions out there that cost lesser than typical toothpaste by working with typical house products like oranges and baking soda. And with the consistent mounting of the prices commodities,...

slide1.jpg
Self Hypnosis Trance Guidebook

It was back again when I was finding out for my Bachelor of Science honors degree in IT & Computing that I began to see the similarities among a pc and the unconscious intellect. A pc will only function corectly if it is functioning a perfectly...

process11.jpg
Every single Working day Tooth Treatment Strategies

Do you want to choose right care of your teeth?In this posting you will find out some suggestions which will assistance you in taking right care of your teeth. * Right after each individual food you should really thoroughly clean you teeth with a...

All_Seeing_Eye_Large.jpg
The Illuminati Secret Modern society, Its Origin and Management

The Illuminati is a name that currently is utilised to speak of several teams characterised by secrecy, all teams performing collectively, having a person single purpose, since of having one  and the similar god. Historically nevertheless, it refers particularly to the Bavarian Illuminati, founded on...

b-portugal-2013-road-trip-gallery-01.jpg
How Superstars Get rid of Pounds and Keep in Condition

This short article is heading to clarify how celeb stars constantly appear to be to glimpse in excellent shape, and expose some of their techniques to looking wonderful. Have not you noticed that whenever you observe Tv set or go to the cinema how...