WordPress › Support Tag: most-commented

WordPress › Support Tag: most-commented http://wordpress.org/support/ WordPress › Support Tag: most-commented en Wed, 25 Nov 2009 22:47:41 +0000 tydende on "[Plugin: Most Commented] 2 lists in sidebar?" http://wordpress.org/support/topic/326333#post-1264845 Fri, 30 Oct 2009 21:54:51 +0000 tydende 1264845@http://wordpress.org/support/ Wow. Thanks tugbucket! I'll check this out as soon as I can and post my results. Thank you for the help! Cheers, Ty tugbucket on "[Plugin: Most Commented] 2 lists in sidebar?" http://wordpress.org/support/topic/326333#post-1264771 Fri, 30 Oct 2009 20:41:20 +0000 tugbucket 1264771@http://wordpress.org/support/ well it looks like you'll need to hack the plugin to include an offset for example you have: <code><?php mdv_most_commented(10, '', '', true, 1000, true); ?></code> and <code><?php mdv_most_commented(10, '', '', true, 7, true); ?></code> the "10" is the number to show. So if you call the plugin the same way twice both having 10 results, you'll get the same 10 results both times. So if you're showing the top 10 out of each of the date ranges you're asking for you are basically saying: <code><?php mdv_most_commented(20, '', '', true, 1000, true); ?></code> so basically you need a way to add another option to the string like: <code><?php mdv_most_commented(10, '', '', true, 1000, 30, true); ?></code> Where "30" in the back end would be an offset on days. I'm using a popular post code myself not sure if it's the same as your's but here some hacked code to achiebve what you want: Put this where you want the result to display: <pre><code><h2>past 30 days</h2> <ul> <?php most_popular_posts_past30(); ?> </ul> <h2>past 1000 days</h2> <ul> <?php most_popular_posts_past1000(); ?> </ul></code></pre> Put this in your functions.php: <pre><code>/* most_popular_posts_past30 */ function most_popular_posts_past30($no_posts = 5, $before = '<li>', $after = '</li>', $show_pass_post = false, $duration='') { global $wpdb; $date = date('Y-m-d', strtotime('-1 months')); $days = (strtotime($date) - strtotime(date("Y-m-d"))) / (60 * 60 * 24); $days = str_replace("-", "", $days); $duration = $days; $request = "SELECT ID, post_title, COUNT($wpdb->comments.comment_post_ID) AS 'comment_count' FROM $wpdb->posts, $wpdb->comments"; $request .= " WHERE comment_approved = '1' AND $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status = 'publish'"; if(!$show_pass_post) $request .= " AND post_password =''"; if($duration !="") { $request .= " AND DATE_SUB(CURDATE(),INTERVAL ".$duration." DAY) < post_date "; } $request .= " GROUP BY $wpdb->comments.comment_post_ID ORDER BY comment_count DESC LIMIT $no_posts"; $posts = $wpdb->get_results($request); $output = ''; if ($posts) { foreach ($posts as $post) { $post_title = stripslashes($post->post_title); $comment_count = $post->comment_count; $permalink = get_permalink($post->ID); if (($comment_count)>1){ $numcoms = "&nbsp;comments"; } else{ $numcoms = "&nbsp;comment"; }; $output .= $before . '<a href="' . $permalink . '" title="' . $post_title.'">' . $post_title . ' (' . $comment_count. $numcoms .')</a>' . $after . "\n"; } } else { $output .= $before . "None found" . $after; } echo $output; } /* end most_popular_posts_past30 */ /* most_popular_posts_past1000 */ function most_popular_posts_past1000($no_posts = 5, $before = '<li>', $after = '</li>', $show_pass_post = false, $duration='') { global $wpdb; $date = date('Y-m-d', strtotime('-1 months')); $date2 = date('Y-m-d', strtotime('-1000 days')); $days = (strtotime($date2) - strtotime($date)) / (60 * 60 * 24); $days = str_replace("-", "", $days); $duration = $days; $request = "SELECT ID, post_title, COUNT($wpdb->comments.comment_post_ID) AS 'comment_count' FROM $wpdb->posts, $wpdb->comments"; $request .= " WHERE comment_approved = '1' AND $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status = 'publish'"; if(!$show_pass_post) $request .= " AND post_password =''"; if($duration !="") { $request .= " AND DATE_SUB(CURDATE(),INTERVAL ".$duration." DAY) < post_date "; } $request .= " GROUP BY $wpdb->comments.comment_post_ID ORDER BY comment_count DESC LIMIT $no_posts"; $posts = $wpdb->get_results($request); $output = ''; if ($posts) { foreach ($posts as $post) { $post_title = stripslashes($post->post_title); $comment_count = $post->comment_count; $permalink = get_permalink($post->ID); if (($comment_count)>1){ $numcoms = "&nbsp;comments"; } else{ $numcoms = "&nbsp;comment"; }; $output .= $before . '<a href="' . $permalink . '" title="' . $post_title.'">' . $post_title . ' (' . $comment_count. $numcoms .')</a>' . $after . "\n"; } } else { $output .= $before . "None found" . $after; } echo $output; } /* end most_popular_posts_past1000 */</code></pre> and here it is working on my test page: <a href="http://tugbucket.net/list-sample/#mostComm" rel="nofollow">http://tugbucket.net/list-sample/#mostComm</a> tydende on "[Plugin: Most Commented] 2 lists in sidebar?" http://wordpress.org/support/topic/326333#post-1264701 Fri, 30 Oct 2009 19:20:15 +0000 tydende 1264701@http://wordpress.org/support/ Hey tugbucket, Thanks for the response! But, actually all we're trying to do is show the most commented posts (as the plugin is designed to work), but show 2 lists based on 2 date ranges. One for the posts that were written in the last 30 days that have the most comments, and one for the psts that were written in the last 1000 days that have the most comments. it seems pretty straightforward but will not show the two lists, only the first one queried in the sidebar. Does this make sense? Thanks again for the response, Ty tugbucket on "[Plugin: Most Commented] 2 lists in sidebar?" http://wordpress.org/support/topic/326333#post-1264600 Fri, 30 Oct 2009 17:30:48 +0000 tugbucket 1264600@http://wordpress.org/support/ Okay this might be better to some extent, it will show the number of comments for the week off to the side. <pre><code><h2>Most commented posts from the last 7 days</h2> <ul> <?php $date1 = date('Y-m-d', strtotime('+1 days')); $date2 = date('Y-m-d', strtotime('-8 days')); $result = $wpdb->get_results("SELECT comment_date, comment_post_ID, comment_approved, COUNT($wpdb->comments.comment_post_ID) AS 'comment_count' FROM $wpdb->posts, $wpdb->comments WHERE comment_date BETWEEN '". $date2 ."' AND '" . $date1 . "' AND $wpdb->posts.ID=$wpdb->comments.comment_post_ID GROUP BY comment_post_ID ORDER BY comment_count DESC LIMIT 0 , 10"); foreach ($result as $topten) { $postid = $topten->comment_post_ID; $commentapproved = $topten->comment_approved; $commentcount = $topten->comment_count; if ($commentapproved != 0) { ?> <li><a href="<?php echo get_permalink($postid); ?>"><?php echo get_the_title($postid); ?></a> (<?php echo $commentcount.' this week'; ?>)</li> <?php } } ?> </ul></code></pre> tugbucket on "[Plugin: Most Commented] 2 lists in sidebar?" http://wordpress.org/support/topic/326333#post-1264440 Fri, 30 Oct 2009 15:23:34 +0000 tugbucket 1264440@http://wordpress.org/support/ Just to make sure I know what you're wanting. You want to get the most commented posts where the comment occurred in the last week right? If that's right, you can't use the same plug-in your using. That plugin is looking at the posts in the database not the comments. It is looking for the date in which a post was actually posted and then seeing if it had comments. The info you want to check is in a different table in the database so you need a totally different connection. Try this: <pre><code><h2>Most commented posts from the last 7 days</h2> <ul> <?php $date1 = date('Y-m-d', strtotime('+1 day')); $date2 = date('Y-m-d', strtotime('-8 days')); $result = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_date BETWEEN '". $date2 ."' AND '" . $date1 . "' GROUP BY comment_post_ID ORDER BY comment_date DESC LIMIT 0 , 10"); foreach ($result as $topten) { $postid = $topten->comment_post_ID; $commentapproved = $topten->comment_approved; if ($commentapproved != 0) { ?> <li><a href="<?php echo get_permalink($postid); ?>"><?php echo get_the_title($postid); ?></a></li> <?php } } ?> </ul></code></pre> This appears to list the 10 most commented posts based on if the comment it self was made in the last 7 days (well 8 days actually or it won't count today). tydende on "[Plugin: Most Commented] 2 lists in sidebar?" http://wordpress.org/support/topic/326333#post-1263719 Thu, 29 Oct 2009 21:25:40 +0000 tydende 1263719@http://wordpress.org/support/ Hi, I'm trying to add two most commented lists to our sidebar, Most Commented This Week, and Most Commented All-Time. However, whichever list is second in the sidebar code automatically displays the same results as the first. In other words, the secodn list does not show the most commented posts for the number of days stated in the code, but rather the number of days stated in the first bit of code. I'm using <?php mdv_most_commented(10, '', ' ', true, 1000, true); ?> for Most Commented All-Time and <?php mdv_most_commented(10, '', ' ', true, 7, true); ?> fr Most Commented This Week Has anyone else been able to show two Most Commented lists or have an idea how to get around this? Thanks! dimitryz on "[Plugin: Most Commented] Notice about $mdv_most_commented" http://wordpress.org/support/topic/313921#post-1221562 Wed, 23 Sep 2009 05:04:22 +0000 dimitryz 1221562@http://wordpress.org/support/ Please initialize $mdv_most_commented before use: if ( $echo ) { $mdv_most_commented = ''; if ( !empty($posts) ) { ... Thanks <a href="http://wordpress.org/extend/plugins/most-commented/" rel="nofollow">http://wordpress.org/extend/plugins/most-commented/</a> EllipsisAeon on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1139925 Thu, 16 Jul 2009 05:09:15 +0000 EllipsisAeon 1139925@http://wordpress.org/support/ ok, stuck again. I basically want to sort the categories by name then group the posts below the category name/link in a semi-forum layout fashion: <blockquote> <ul> Category 1: <li> posts (#of comments)</li> <li> posts (#of comments)</li> <li> posts (#of comments)</li> </ul> <ul> Category 2: <li> posts (#of comments)</li> <li> posts (#of comments)</li> </ul> </blockquote> I'm thinking this would be done with something like "foreach $category_id" but am stuck on the implementation; I think my caffiene levels are low. Any tips/links/help is greatly appreciated. EllipsisAeon on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1139718 Thu, 16 Jul 2009 00:15:55 +0000 EllipsisAeon 1139718@http://wordpress.org/support/ Back with an update on this. If you would like to turn that category name into an actual link to the category from the comment, here's the code: <pre><code>$permalink = get_permalink($post->ID); $category = get_the_category($post->ID); $first_category = $category[0]->cat_name; $category_id = get_cat_ID($first_category); $category_link = get_category_link($category_id); $mdv_most_commented .= $before . '<a href="' . $category_link . '" title="' . $first_category .'">' . $first_category . '</a>:&nbsp;<a href="' . $permalink . '" title="' . $post_title.'">' . $post_title . '</a> (' . $comment_count . ')' . $after;</code></pre> EllipsisAeon on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1138213 Tue, 14 Jul 2009 22:20:01 +0000 EllipsisAeon 1138213@http://wordpress.org/support/ Another thanks to Michael for the code, very helpful in getting one step closer to what I'm trying to do :) carblanco on "[Pulgin: Most Commented] How to translate strings" http://wordpress.org/support/topic/284230#post-1117464 Fri, 26 Jun 2009 14:46:04 +0000 carblanco 1117464@http://wordpress.org/support/ Hi all, A stupid question: I need to translate "Most Commented" to "lo más Comentado" but I can't find the string. Could please tell where to change it? Thanks. Miroslav on "[Plugin: Most Commented] which i could pick which category it gets them from" http://wordpress.org/support/topic/209139#post-1031246 Mon, 30 Mar 2009 13:27:35 +0000 Miroslav 1031246@http://wordpress.org/support/ I just came across this thread in search of the same solution: ability to pick/exclude categories to be used by the plugin. Any help would be greatly appreciated! Thanks! ex272 on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1002565 Mon, 02 Mar 2009 05:52:09 +0000 ex272 1002565@http://wordpress.org/support/ Worked like a charm, thanks Michael. MichaelH on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1002029 Sun, 01 Mar 2009 17:14:41 +0000 MichaelH 1002029@http://wordpress.org/support/ Best thing to do is install and activate <a href="http://wordpress.org/extend/plugins/most-commented" rel="nofollow">http://wordpress.org/extend/plugins/most-commented</a> then just put this in your sidebar: <pre><code><?php mdv_most_commented(); ?></code></pre> If you insist on the category displaying then in <code>most-commented.php</code> change <pre><code>$permalink = get_permalink($post->ID); $mdv_most_commented .= $before . '<a href="' . $permalink . '" title="' . $post_title.'">' . $post_title . '</a> (' . $comment_count.')' . $after;</code></pre> to <pre><code>$permalink = get_permalink($post->ID); $category = get_the_category($post->ID); $first_category = $category[0]->cat_name; $mdv_most_commented .= $before . '<a href="' . $permalink . '" title="' . $post_title.'">' . $post_title . '</a> (' . $comment_count . ' in ' . $first_category . ')' . $after;</code></pre> ex272 on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1001376 Sat, 28 Feb 2009 21:05:26 +0000 ex272 1001376@http://wordpress.org/support/ Hi Michael, So since this is a sidebar function, it seems that rather than using a wpdb query, I'd have to execute The Loop in the sidebar as well as the content area, in order to call get_the_category() from the sidebar, correct? Then how would I grab the top 5 posts ordered by comment count within this sidebar Loop? I looked into query_posts(), but did not see comment_count as an option for its orderby parameter. Sorry, this is only my second day at this. Thanks again! MichaelH on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1001075 Sat, 28 Feb 2009 14:24:51 +0000 MichaelH 1001075@http://wordpress.org/support/ Look at using <a href="http://codex.wordpress.org/Template_Tags/get_the_category">get_the_category()</a>. ex272 on "Popular Posts by Comments with Categories" http://wordpress.org/support/topic/248350#post-1000961 Sat, 28 Feb 2009 10:26:07 +0000 ex272 1000961@http://wordpress.org/support/ Hi, I am trying to place on my sidebar an area listing the most commented, i.e. popular, posts, which I was able to do with a basic wpdb query. But I am having the problem of getting the category names for those posts, arising from the obsoleteness of "post_category." Here is the code I currently have: <pre><code>global $wpdb ; $result = $wpdb->get_results ( "SELECT comment_count, ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' ORDER BY comment_count DESC LIMIT 0 , 5" ) ; foreach ( $result as $post ) { setup_postdata ( $post ) ; $postid = $post->ID ; $title = $post->post_title ; $category = $post->post_category ; $commentcount = $post->comment_count ; echo '<li><a href="' . get_permalink($postid) . '">in ' . $category . ': ' . $title . ' (' . $commentcount . ')</a></li>' ; }</code></pre> I know category information is now stored in separate tables. How can I retrieve that information in the same query? Thanks ember on "[Plugin: Most Commented] How To: Exclude Pages" http://wordpress.org/support/topic/219165#post-958299 Sat, 17 Jan 2009 02:41:42 +0000 ember 958299@http://wordpress.org/support/ Wow that actually works! I was looking all over for a Most comments plugin that doesn't show pages until I found this post. Cheers fhamilton! fhamilton on "[Plugin: Most Commented] How To: Exclude Pages" http://wordpress.org/support/topic/219165#post-904245 Fri, 21 Nov 2008 02:08:24 +0000 fhamilton 904245@http://wordpress.org/support/ It doesn't exclude pages by default but if you add to the query it will. look for the first line, then add the second. cheers! 1) $request .= " WHERE post_status = 'publish'"; 2) $request .= " AND post_type = 'post'"; <a href="http://wordpress.org/extend/plugins/most-commented/" rel="nofollow">http://wordpress.org/extend/plugins/most-commented/</a> netbuddy34 on "[Plugin: Most Commented] which i could pick which category it gets them from" http://wordpress.org/support/topic/209139#post-871816 Wed, 08 Oct 2008 12:14:45 +0000 netbuddy34 871816@http://wordpress.org/support/ any chance of getting this plugin modified to allow you to select which post category comments are selected from? <a href="http://wordpress.org/extend/plugins/most-commented/" rel="nofollow">http://wordpress.org/extend/plugins/most-commented/</a> Kafkaesqui on "hard to find" http://wordpress.org/support/topic/146849#post-660000 Sat, 08 Dec 2007 23:14:12 +0000 Kafkaesqui 660000@http://wordpress.org/support/ <a href="http://wordpress.org/extend/plugins/most-commented/" rel="nofollow">http://wordpress.org/extend/plugins/most-commented/</a> There is a Download Plugin button on that page. (LenK, check the tags above...) LenK on "hard to find" http://wordpress.org/support/topic/146849#post-659872 Sat, 08 Dec 2007 17:03:13 +0000 LenK 659872@http://wordpress.org/support/ Huh? What plugin? kimranrar on "hard to find" http://wordpress.org/support/topic/146849#post-659868 Sat, 08 Dec 2007 16:51:55 +0000 kimranrar 659868@http://wordpress.org/support/ Well it is hard to fint this plugin when the authors page not are working :(