function sipit($sipper_id, $post_id) { global $wpdb; $categories = get_the_category($post_id); $category_id = $categories[0]->term_id; $myrows = $wpdb->get_results("SELECT sip_it FROM wp_sipping WHERE sipper_id='" . $sipper_id . "' AND post_id='" . $post_id . "'"); if (count($myrows) > 0) { /*echo "<script>alert('Sorry, you can only Sip it/Spit it Once');</script>"; $sip_it=$myrows[0]->sip_it; $sip_it++; $wpdb->get_results("UPDATE wp_sipping SET sip_it='".$sip_it."' WHERE sipper_id='".$sipper_id."' and post_id='".$post_id."'"); return get_sipit($post_id);*/ return 'false'; } else { $query = "SELECT post_author FROM wp_posts WHERE id='" . $post_id . "'"; $myrows = $wpdb->get_results($query); //echo $query." ".$myrows[0]->post_author; $query = "INSERT INTO wp_sipping (sipper_id,post_id,owner_id,sip_it,category) VALUES ('" . $sipper_id . "','" . $post_id . "','" . $myrows[0]->post_author . "',1,'" . $category_id . "')"; $wpdb->get_results($query); return get_sipit($post_id); } }
?> </a> </div> <p>Post Date</p> <a><?php echo $post_date; ?> </a> </li> <?php $sip_it = get_sipit($r->ID); $spit_it = get_spitit($r->ID); $sip = $sip_it - $spit_it; ?> <li style="position:relative;"><a href="#" class="sip sip_up_<?php echo $r->ID; ?> "><?php echo $sip; ?> </a> <ul style="display:none;">
<?php } ?> </ul> </div> <!-- Sip --> </div> <!--End .top_rating_cont--> <!-- description --> <div class="normal_rating_bottom_cont"> <ul> <li style="width:375px;"> </li> <?php $sip_it = get_sipit($posts_array->ID); $spit_it = get_spitit($posts_array->ID); $sip = $sip_it - $spit_it; ?> <li style="position:relative;"><a href="#" class="sip sip_up_<?php echo $posts_array->ID; ?> "><?php echo $sip; ?> </a> <ul style="display:none;"> <li class="sip_pop"><p>Sip it</p><a href="#" class="sip_it_up_<?php echo $posts_array->ID; ?>
echo $userdata->user_login; } else { echo $userdata->Alternative_User; } } ?> </a> </div> <p>Post Date</p> <a><?php echo $post_date; ?> </a> </li> <?php $sip_it = get_sipit($post_id); $spit_it = get_spitit($post_id); $sip = $sip_it - $spit_it; ?> <li style="position:relative;"><a href="#" class="sip sip_up_<?php echo $post_id; ?> "><?php echo $sip; ?> </a> <ul style="display:none;"> <li><a href="#" class="sip_pop sip_it_up_<?php echo $post_id; ?>
function mostdiscussed_loader() { require_once get_template_directory() . '/custom_functions/sipping.php'; global $wpdb, $current_user; $id = $_POST['id']; $limit = $id + 5; if (is_user_logged_in()) { global $current_user; get_currentuserinfo(); @($moca = unserialize($current_user->Choosed_Mocha)); if ($moca == false) { $moca = array(); } $posts_array = $wpdb->get_results("select * from wp_posts where `post_type` = 'post' and `post_status` = 'publish' group by ID Order by (select count(comment_post_ID) FROM wp_comments WHERE comment_post_ID = ID ) DESC limit {$id},5"); } else { $posts_array = $wpdb->get_results("select * from wp_posts where `post_type` = 'post' and `post_status` = 'publish' group by ID Order by (select count(comment_post_ID) FROM wp_comments WHERE comment_post_ID = ID ) DESC limit {$id},5"); } foreach ($posts_array as $r) { $post_datetime = $r->post_date; $explode = explode(' ', $post_datetime); $newDate = $explode[0]; $post_date = date('M d,Y', strtotime($post_datetime)); $cat_array = wp_get_post_categories($r->ID); $cat_id = $cat_array[0]; $post_author = $r->post_author; if (is_user_logged_in()) { $moca = unserialize($current_user->Choosed_Mocha); $user_block = unserialize($current_user->blocked_users); if (count($moca) == 0) { $moca = array(); $check = !in_array($cat_id, $moca); } else { $check = in_array($cat_id, $moca); } if (count($user_block) == 0) { $user_block = array(); $check_user = !in_array($post_author, $user_block); } else { $check_user = !in_array($post_author, $user_block); } } else { $moca = array(); $user_block = array(); $check = !in_array($cat_id, $moca); $check_user = !in_array($post_author, $user_block); } if ($check & $check_user) { $meta = get_post_meta($r->ID); $args = array('post_id' => $r->ID); $comments = get_comments($args); $views = $wpdb->get_results("select SUM(views) as views from wp_views where post_id='{$r->ID}'"); $view = $views[0]->views; $term_name = get_term_by('id', $meta[mocas][0], 'category')->slug; ?> <div class="normal_post_war chima" id="<?php echo $limit; ?> "> <div class="top_rating_cont"> <!--Categori Image--> <div class="top_post_pic_cont"><?php $userdata = get_userdata($r->post_author); ?> <div class="top_cat_pic"><img src="<?php if (z_taxonomy_image_url($meta[mocas][0]) != false) { echo z_taxonomy_image_url($meta[mocas][0]); } else { echo get_site_url() . "/wp-content/themes/cafemocha/custom-images/no-image.jpg"; } ?> " height="48px" width="48px"></div> </div> <!--Categori Image--> <!-- Post Description --> <div class="top_post_des"> <a href="<?php echo get_permalink($r->ID); ?> "><?php echo $r->post_title; ?> </a> <?php if ($meta[attached_file][0] != '') { ?> <a href="<?php //echo $meta[attached_file][0]; ?> "></a> <?php } ?> </div> <!-- Post Description --> <!-- Sip --> <div class="top_post_sip"> <ul> <?php if (is_user_logged_in()) { ?> <li><a href="javascript:void(0)" class="vote_up" onclick="sip_it('<?php echo $r->ID; ?> ')"></a>Sip it</li> <li><a href="javascript:void(0)" class="vote_down" onclick="spit_it('<?php echo $r->ID; ?> ')"></a>Spit it</li> <?php } else { ?> <li><a href="javascript:void(0)" class="vote_up" onclick="login_msg()"></a>Sip it</li> <li><a href="javascript:void(0)" class="vote_down" onclick="login_msg()"></a>Spit it</li> <?php } ?> </ul> </div> <!-- Sip --> </div> <!--End .top_rating_cont--> <div class="normal_rating_bottom_cont"> <ul> <li><a href="<?php echo get_bloginfo('url') . '/category/' . $term_name; ?> "><?php echo get_term_by('id', $meta[mocas][0], 'category')->name; ?> </a></li> <li class="author"> <div class="publishby"> <p>Published By</p> <a href="<?php if ($meta[anonymous][0] == "") { echo get_bloginfo('url') . '/profile-page-template/?user_id=' . $r->post_author; } else { echo 'javascript:void();'; } ?> "><?php if ($meta[anonymous][0] != "") { echo 'Anonymous'; } else { $post_name = $userdata->post_name; if ($post_name == 1) { echo $userdata->user_login; } else { echo $userdata->Alternative_User; } } ?> </a> </div> <p>Post Date</p> <a><?php echo $post_date; ?> </a> </li> <?php $sip_it = get_sipit($r->ID); $spit_it = get_spitit($r->ID); $sip = $sip_it - $spit_it; ?> <li style="position:relative;"><a href="#" class="sip sip_up_<?php echo $r->ID; ?> "><?php echo $sip; ?> </a> <ul style="display:none;"> <li class="sip_pop"><p>Sip it</p><a href="#" class="sip_it_up_<?php echo $r->ID; ?> "><?php echo $sip_it; ?> </a></li> <li class="spit_pop"><p>Spit it</p><a href="#" class="spit_it_up_<?php echo $r->ID; ?> "><?php echo $spit_it; ?> </a></li> </ul> </li> <li><a href="#" class="view"><?php if ($view != "") { echo $view; } else { echo '0'; } ?> views</a></li> <li><a href="<?php echo get_permalink($r->ID); ?> " class="comment"><?php echo count($comments); ?> comments</a></li> </ul> </div> <!--End .top_rating_bottom_cont--> </div> <!-- Post Section --> <?php } } die; }