get_results("
SELECT comment_count,ID,post_title
FROM $wpdb->posts
ORDER BY comment_count DESC LIMIT 0 , $anp_num_post");
break;
case 2:
$result = $wpdb->get_results("
SELECT comment_post_ID, COUNT( comment_post_ID ) AS 'comment_count' , ID, post_title
FROM $wpdb->posts, $wpdb->comments
WHERE comment_approved =1
AND $wpdb->comments.comment_post_ID = $wpdb->posts.ID
AND comment_date > DATE_SUB( NOW( ) , INTERVAL 1 DAY )
GROUP BY comment_post_ID
ORDER BY comment_date ASC LIMIT 0 , $anp_num_post");
break;
case 3:
$result = $wpdb->get_results("
SELECT comment_post_ID, COUNT( comment_post_ID ) AS 'comment_count' , ID, post_title
FROM $wpdb->posts, $wpdb->comments
WHERE comment_approved =1
AND $wpdb->comments.comment_post_ID = $wpdb->posts.ID
AND comment_date > DATE_SUB( NOW( ) , INTERVAL 1 WEEK )
GROUP BY comment_post_ID
ORDER BY comment_date ASC LIMIT 0 , $anp_num_post");
break;
case 4:
$result = $wpdb->get_results("
SELECT comment_post_ID, COUNT( comment_post_ID ) AS 'comment_count' , ID, post_title
FROM $wpdb->posts, $wpdb->comments
WHERE comment_approved =1
AND $wpdb->comments.comment_post_ID = $wpdb->posts.ID
AND comment_date > DATE_SUB( NOW( ) , INTERVAL 15 DAY )
GROUP BY comment_post_ID
ORDER BY comment_date ASC LIMIT 0 , $anp_num_post");
break;
case 5:
$result = $wpdb->get_results("
SELECT comment_post_ID, COUNT( comment_post_ID ) AS 'comment_count' , ID, post_title
FROM $wpdb->posts, $wpdb->comments
WHERE comment_approved =1
AND $wpdb->comments.comment_post_ID = $wpdb->posts.ID
AND comment_date > DATE_SUB( NOW( ) , INTERVAL 30 DAY )
GROUP BY comment_post_ID
ORDER BY comment_date ASC LIMIT 0 , $anp_num_post");
break;
}
/**
*
* extraemos el número mayor dentro del array
* de los números de comentarios
*
*/
foreach ($result as $post) {
$anp_mayor = $post->comment_count;
break;
}
$post_nu_clas=1; //añadimos valores a la clase css de cada post
/**
*
* recorremos el query y mostramos todos los resultados
* según se eliga por comentarios o por visitas
*
*/
if ($anp_comment_view == 1){ // si es 1 mostramos los post más comentados
foreach ($result as $post) {
setup_postdata($post);
$postid = $post->ID;
$title = $post->post_title;
$commentcount = $post->comment_count;
if ($commentcount != 0) { ?>
prefix . "postview";
$result = $wpdb->get_results("
SELECT view_datetime, view, post_ID, ID, post_title
FROM $table, $wpdb->posts
WHERE $table.post_ID = $wpdb->posts.ID
ORDER BY view DESC LIMIT 0 , $anp_num_post");
break;
case 2:
$table = $wpdb->prefix . "postview";
$result = $wpdb->get_results("
SELECT view_datetime, view, post_ID, ID, post_title,
FROM $table, $wpdb->posts
WHERE $table.post_ID = $wpdb->posts.ID
AND view_datetime > DATE_SUB( NOW( ) , INTERVAL 1 DAY )
ORDER BY view DESC LIMIT 0 , $anp_num_post");
break;
case 3:
$table = $wpdb->prefix . "postview";
$result = $wpdb->get_results("
SELECT view_datetime, view, post_ID, ID, post_title
FROM $table, $wpdb->posts
WHERE $table.post_ID = $wpdb->posts.ID
AND view_datetime > DATE_SUB( NOW( ) , INTERVAL 7 DAY )
ORDER BY view DESC LIMIT 0 , $anp_num_post");
break;
case 3:
$table = $wpdb->prefix . "postview";
$result = $wpdb->get_results("
SELECT view_datetime, view, post_ID, ID, post_title
FROM $table, $wpdb->posts
WHERE $table.post_ID = $wpdb->posts.ID
AND view_datetime > DATE_SUB( NOW( ) , INTERVAL 15 DAY )
ORDER BY view DESC LIMIT 0 , $anp_num_post");
break;
case 3:
$table = $wpdb->prefix . "postview";
$result = $wpdb->get_results("
SELECT view_datetime, view, post_ID, ID, post_title
FROM $table, $wpdb->posts
WHERE $table.post_ID = $wpdb->posts.ID
AND view_datetime > DATE_SUB( NOW( ) , INTERVAL 30 DAY )
ORDER BY view DESC LIMIT 0 , $anp_num_post");
break;
}
/**
*
* extraemos el número mayor dentro del array
* de los números de comentarios
*
*/
foreach ($result as $post) {
$anp_mayor = $post->view;
break;
}
foreach ($result as $post) {
setup_postdata($post);
$postid = $post->ID;
$title = $post->post_title;
$commentcount = $post->view; //{
if ($commentcount != 0) { ?>
anpstudio.com', 'anp_text_popular_post');?>