$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-2,page-paged-2,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
parallax.jpg
Can You Be Aided With Remote Or Distant Healing Electricity?

Is there any evidence that distant healing operates? And just what is distant healing? Distant healing is also identified as distant healing, absent healing or distance healing. It will take put when one particular or much more healers deliver power or thought vibrations...

b-portugal-2013-road-trip-gallery-01.jpg
Famous People Who Listen to Ear Noises from Tinnitus

Back again in the 60s and 70s, medical professionals had been by now telling us that listening to loud rock audio could at some point guide to listening to ear sounds like frequent ringing in the ears from tinnitus. It seems all those medical professionals...

slide2.jpg
How to attain environmental sustainability?

The method that consists of earning choices and then actions in regard to protecting the atmosphere and to sustain human lifetime is environmental sustainability. Men and women are now acknowledging the effect of organizations on the atmosphere. It is crucial to choose choices that can...

process11.jpg
Knowing and Treating Heartburn

What is Heartburn? It commences as a burning suffering in the center of your upper body, driving the breastbone, typically following a huge meal. The burning feeling could go upward toward your neck and is typically accompanied by a emotion of food items coming back into your...

slide2.jpg
Does Tinnitus Have an impact on Your Lifetime?

An believed 10 to 20 per cent of individuals throughout the country suffer from some degree of tinnitus, a ringing or buzzing in the ears. The challenge may start off out as a smaller annoyance, but the more time it lasts the far more unbearable...

b-portugal-2013-road-trip-gallery-01.jpg
Careers in Strength Therapeutic

There are a variety of careers in electricity healing, which includes Reiki, acupuncture, chromotherapy, electromagnetic remedy, electricity medication, quantum contact, and therapeutic contact, between other people. Careers in electricity healing like therapeutic contact, for illustration, contain the practitioner sweeping the palms of his palms...

team31.jpg
Closed Rhinoplasty

Plastic surgeons complete a rhinoplasty working with possibly of two methods, closed rhinoplasty or open rhinoplasty. Browse on to know far more about the former. In a closed or endonasal rhinoplasty the incisions are built inside the nose. Just one benefit of this method...

b-inteligent-transitions-in-ux-design.jpg
Resort Administration Suggestions For Common Professionals

Regardless of other duties, and you have a good deal, the management of workers in a resort setting is the most very important and the most complicated. Recognizing how to treatment for your personnel qualified prospects to outstanding treatment of prospects, and these resort management...

process31.jpg
Do I Want Spenco Arch Supports or Insoles

Our ft have the whole bodyweight of our bodies day in and day out. It is straightforward to have an understanding of how these 26 modest bones will never constantly continue to be in alignment as they soak up the impression of your human body...

process31.jpg
Ways to Study Hypnosis

One particular of the nicest factors about hypnosis is that it is easy to master. It is a fantasy that you require to be an expert to carry it out. There are basically two sorts of hypnosis procedures: the overt and the covert. The overt...

b-madrids-photographer-marathon-02.jpg
Strategies to Look Lovely

To look attractive and younger is aspiration of just about every individual, primarily ladies aspiration to look more youthful mostly. It can be no matter how old you are you would like to look younger and smart. There are a range of beauty methods that...

Google Chrome Crashes on Windows 7 - Tips To Resolve This Problem
Barefoot Running And Blisters: 6 Things You Can Do

The good news is, most of the blisters you get with shoes will not happen when you are barefoot running. The reason for this is, most shoe-running blisters occur where the shoe is rubbing on your foot, and that simply can't happen with barefoot...

process31.jpg
Major 4 Guidelines to Deal with Bronchial asthma By Self-treatment

Bronchial asthma is a serious respiratory sickness in which airways in the lungs periodically develop into narrowed, obstructed, or even blocked. An approximated 15 million People experience from asthma, and the selection of new asthma circumstances boosts yearly. Bronchial asthma frequently develops in childhood...

3.jpg
7 Easy Tips Revealing How To Support An Alcoholic

If you are in the placement whereby you want to know how to help an alcoholic, because you are exhausted of the liquid which has offered your friend or family members member so quite a few ups and downs and additional downs. Like cigarettes, liquor...

slide1.jpg
Hand Dermatitis Remedy Suggestion

Hand dermatitis (also acknowledged as hand eczema) typically effects from a mixture of results in, including genetic makeup (constitutional elements), injury (make contact with with irritants) and allergy. This issue is commonly multi-factorial. The pores and skin can react to the irritation by forming scales....

process11.jpg
Incidence Of Eczema

If you have eczema you will know that it can start out to choose more than your lifestyle and make you extremely miserable. The incidence of eczema in both equally young children and older people throughout the world is soaring.  If you are in this...