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;
}
