bbPress Support Forums Tag: count

bbPress Support Forums Tag: count http://bbpress.org/forums/ bbPress Support Forums Tag: count en Fri, 09 Jan 2009 03:26:40 +0000 _ck_ on "counting forums" http://bbpress.org/forums/topic/counting-forums#post-21338 Mon, 08 Dec 2008 13:13:36 +0000 _ck_ 21338@http://bbpress.org/forums/ Okay if you want something simple you can make this into a mini-plugin: (call it <code>forum-totals.php</code>) <pre><code><?php /* Plugin Name: Forum Totals */ function forum_totals() { global $forum_id; $forum = get_forum( $forum_id ); $topics=$forum->topics; $posts=$forum->posts; $forums=get_forums(array('child_of' => $forum_id)); $count=0; if ($forums) {foreach ($forums as $forum) {$count++; $topics+=$forum->topics; $posts+=$forum->posts;}} echo "<tr style='background:#ccc;'><td align='right'>$count total forums:</td><td class='num'>$topics</td><td class='num'>$posts</td></tr>"; } function forum_topics_including_subforums( $forum_id = 0 ) { echo apply_filters( 'forum_topics', get_forum_topics_including_subforums( $forum_id ), $forum_id ); } function forum_posts_including_subforums( $forum_id = 0 ) { echo apply_filters( 'forum_posts', get_forum_posts_including_subforums( $forum_id ), $forum_id ); } function get_forum_topics_including_subforums( $forum_id = 0 ) { $forum_id=get_forum_id( $forum_id ); $forum = get_forum( $forum_id ); $topics=$forum->topics; $forums=get_forums(array('child_of' => $forum_id)); if ($forums) {foreach ($forums as $forum) {$topics+=$forum->topics;}} return apply_filters( 'get_forum_topics', $topics, $forum_id ); } function get_forum_posts_including_subforums( $forum_id = 0 ) { $forum_id=get_forum_id( $forum_id ); $forum = get_forum( $forum_id ); $posts=$forum->posts; $forums=get_forums(array('child_of' => $forum_id)); if ($forums) {foreach ($forums as $forum) {$posts+=$forum->posts;}} return apply_filters( 'get_forum_posts', $posts, $forum_id ); } ?></code></pre> Install and activate it and then you need to put <code><?php forum_totals(); ?></code> anywhere you want to see it, on <code>front-page.php</code> or <code>forum.php</code> templates. It should go between the <code>endwhile</code> and the <code></table></code> Like this: <pre><code><?php endwhile; ?> <?php forum_totals(); ?> </table></code></pre> To use the replacement functions for <code>forum_topics()</code> and <code>forum_posts()</code> which include the totals for a forum including it's subforums, simply replace them in your templates with <code>forum_topics_including_subforums();</code> and <code>forum_posts_including_subforums();</code> clockworker on "counting forums" http://bbpress.org/forums/topic/counting-forums#post-21337 Mon, 08 Dec 2008 12:39:47 +0000 clockworker 21337@http://bbpress.org/forums/ my front-page.php <a href="http://pastebin.com/d117f4c3a" rel="nofollow">http://pastebin.com/d117f4c3a</a> i want to countig all topics & posts _ck_ on "counting forums" http://bbpress.org/forums/topic/counting-forums#post-21247 Wed, 03 Dec 2008 18:07:51 +0000 _ck_ 21247@http://bbpress.org/forums/ update: there is a better version a few posts down I had worked this out this quick and dirty routine but then I realized you might mean not to show it within the forum list. If you mean something different let me know. In front-page.php Change <pre><code><?php while ( bb_forum() ) : ?></code></pre> to <pre><code><?php forum_totals("init"); while ( bb_forum() ) : forum_totals(); ?></code></pre> and then this after the end of the forum list routine <pre><code><?php endwhile; ?></code></pre> to this <pre><code><?php endwhile; forum_totals("finish"); ?></code></pre> This is the main function you can just drop at the bottom of front-page.php <pre><code><?php function forum_totals($x="") { static $last_parent,$total_posts,$total_topics,$all_topics,$all_posts,$total_counter,$all_counter; if (function_exists('bb_get_forum_is_category')) {$category=bb_get_forum_is_category();} else {$category=false;} if ($x=="init") {$last_parent=false; $total_topics=0; $total_posts=0; $all_topics=0; $all_posts=0; $total_counter=0; $all_counter=0; return;} if ($x=="finish" || $last_parent!==$GLOBALS['forum']->forum_parent || $category) { if ($last_parent!==false && $total_counter>1) {echo "<tr><td align='right'>$total_counter subforums:</td><td class='num'>$total_topics</td><td class='num'>$total_posts</td></tr>";} $last_parent=$GLOBALS['forum']->forum_parent; $total_topics=$GLOBALS['forum']->topics; $total_posts=$GLOBALS['forum']->posts; $total_counter=0; } else {$total_topics+= (int) $GLOBALS['forum']->topics; $total_posts+=(int) $GLOBALS['forum']->posts;} $all_topics+= (int) $GLOBALS['forum']->topics; $all_posts+=(int) $GLOBALS['forum']->posts; if ($x=="finish") {echo "<tr><td align='right'>$all_counter total forums:</td><td class='num'>$all_topics</td><td class='num'>$all_posts</td></tr>";} elseif ($category) {$last_parent=false;} else {$all_counter++; $total_counter++; } } ?></code></pre> clockworker on "counting forums" http://bbpress.org/forums/topic/counting-forums#post-21239 Wed, 03 Dec 2008 12:05:27 +0000 clockworker 21239@http://bbpress.org/forums/ can anybody a solution to count the subforums and give this counting to the forum. - Forum ( Subforum+Subforum2 = 3 topics | 25 posts ) - Subforum ( 1 topic | 5 posts ) < + 2 ( 2 topics | 20 posts ) = 3 topics | 25 posts - Subforum2 ( 2 topics | 20 posts ) karaboga on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-11758 Thu, 01 Nov 2007 09:07:05 +0000 karaboga 11758@http://bbpress.org/forums/ Thanks for the replies; I've upgraded the forum to the newest version 0.8.3, and then I've apply recounting. Now the problems I've stated in my first message are solved. sambauers on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-11013 Thu, 20 Sep 2007 03:57:34 +0000 sambauers 11013@http://bbpress.org/forums/ > Support Forums 1.2 That's a really old version of Support Forums, not sure if it has anything to do with your problem, but it is really old. karaboga on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-10998 Wed, 19 Sep 2007 08:12:26 +0000 karaboga 10998@http://bbpress.org/forums/ Thank you, I've understood the un-integrating issue. For the counting problems; these are the plugins we're using: Allow Images 0.7.1 Avatar .73a Memberlist .80 Censor 0.1 Comment Quicktags for bbPress 1.1 Front Page Topics 0.8 Post Notification 1.3 Online List 1.4 Support Forums 1.2 User Timezones 0.2 mdawaffe on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-10985 Tue, 18 Sep 2007 18:41:06 +0000 mdawaffe 10985@http://bbpress.org/forums/ The bb_users table will not be created automatically. You'd have to copy it and the user meta tables from the WP ones. The counts problem is strange, and not one I've heard of before. Do you any plugins installed? karaboga on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-10889 Sun, 09 Sep 2007 08:24:33 +0000 karaboga 10889@http://bbpress.org/forums/ Hi again, We couldn't find any solution for that problem. If that's a bug; I hope it will be corrected in new versions. By the way, I'd said that we've integrated our bbPress forum to our WordPress blog. Now, forum users' data is taken from WordPress' wp_users table in database. And now, we do not have bb_users table. If we want to seperate bbPress from WordPress (cancel the integration); what can we do? If we cancel the integration; does the bb_users table created automatically? karaboga on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-10616 Thu, 30 Aug 2007 16:50:36 +0000 karaboga 10616@http://bbpress.org/forums/ Thank you. Yes, I've tried that; but nothing changed. chrishajer on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-10614 Thu, 30 Aug 2007 16:28:03 +0000 chrishajer 10614@http://bbpress.org/forums/ Did you try recounting from the admin panel? Admin > Site Management > Recount <code>"The following checkboxes allow you to recalculate various numbers stored in the database. These numbers are used for things like counting the number of pages worth of posts a particular topic has. You shouldn't need to do do any of this unless you're upgrading from one version to another or are seeing pagination oddities."</code> (sure wish blockquotes were styled here!) karaboga on "bbPress cannot count properly after upgrading" http://bbpress.org/forums/topic/bbpress-cannot-count-properly-after-upgrading#post-10603 Thu, 30 Aug 2007 13:33:37 +0000 karaboga 10603@http://bbpress.org/forums/ Hi, We're using bbPress 0.8.2.1 integrated with WordPress 2.1.3. Before upgrading to 0.8.2.1 everything was ok. But after upgrading, something has broken. bbPress cannot count these values properly: - Numbers of topic and the messages of a member in his profile. (For example, a member who had 6 pages of messages in his profile, has only 1 page now) - Number of "topics with no replies, topics with no tags, unresolved topics" values are wrong. Each has less pages now. - In admin panel, the number of members is not accurate. bbPress says there 714 members; but this value is 6109 (this is the correct one) in WordPress. What can be the problem? I can tell the plugins we use, if necessary to solve the problem. Thanks! goebelmasse on "Wrong user count" http://bbpress.org/forums/topic/wrong-user-count#post-10315 Mon, 20 Aug 2007 14:22:35 +0000 goebelmasse 10315@http://bbpress.org/forums/ Oh, thank you SamBauers - this is the information missing on this site... But as I read at the trac site, the problem is already known. It is fixed by <a href="http://trac.bbpress.org/changeset/872/branches/0.8?old_path=%2F&format=zip">changeset 867</a> - at least in my test environment. I'll upload it to the real server, it seems to be okay and of course it will be better than my quick and dirty "solution"... sambauers on "Wrong user count" http://bbpress.org/forums/topic/wrong-user-count#post-10298 Mon, 20 Aug 2007 03:36:50 +0000 sambauers 10298@http://bbpress.org/forums/ I would not have that expectation unless you report a bug in the trac site. <a href="http://trac.bbpress.org" rel="nofollow">http://trac.bbpress.org</a> Login with the same details you use here. goebelmasse on "Wrong user count" http://bbpress.org/forums/topic/wrong-user-count#post-10297 Mon, 20 Aug 2007 02:52:45 +0000 goebelmasse 10297@http://bbpress.org/forums/ Arrgh! Horrors! The problem is caused by the <code>bb_append_meta</code> invocation in line 2075 of <code>functions.php</code>. The query destroys the last <code>SQL_CALC_FOUND_ROWS</code> and so the count is wrong. A quick and dirty workaround is to change <code>'append_meta' => false</code> to <code>'append_meta' => false</code> in the <code>$defaults</code> array in line 2021 of <code>functions.php</code>. But this only works if the append_meta argument is not given in the <code>bb_user_search</code> call. Now the problem is more complicated as I suspected earlier. It is a problem for the hackers that make bbPress. No further searching for bugs from me, the problem should be clear. (It is clear enough to me after reading lots of code from other people.) I expect it to be fixed in the next release. goebelmasse on "Wrong user count" http://bbpress.org/forums/topic/wrong-user-count#post-10295 Mon, 20 Aug 2007 01:11:22 +0000 goebelmasse 10295@http://bbpress.org/forums/ I found something that can help to fix this bug. In the following I use wordpress_ as prefix for my WP tables. My wordpress_usermeta table has 65 rows, and 65 users are displayed now in the bbPress dashboard. It seems to be a wrong SQL statement for querying the number of users. Instead of the (by me assumed) <code>select count(*) from wordpress_usermeta</code> there should be used either <code>select count(*) from wordpress_users</code> or <code>select count(distinct user_id) from wordpress_usermeta</code> to get the number of users. (Oh yes, I know that there will be a where-clause...) I suspect line 2046 in <code>bb-includes/functions.php</code>, but I'm not familar with the source. goebelmasse on "Wrong user count" http://bbpress.org/forums/topic/wrong-user-count#post-10293 Mon, 20 Aug 2007 00:47:31 +0000 goebelmasse 10293@http://bbpress.org/forums/ I use bbPress 0.8.2.1 for a small forum. My user table is shared with a wordpress blog. My bbPress plugins are UseDisplayName 0.7.2, AllowImages 0.7.1, Private Forums 5.0, Forums Moderators 1.0, Google Analytics 0.68. I use the german localisation file, it is a german forum. There is a strange bug in the user list. At the moment, 8 users are registered. But the Users/Find admin panel displays a wrong number of users. It says there are 61 users. I took a screenshot a few days ago with six users, displayed as 48, if you don't understand the problem, <a href="http://www.tamagothi.de/wp-content/uploads/2007/08/bbbug.gif">take a look in my weird numbers</a>. And I thought that reckoning is something a computer can do. Is the problem caused by one of my plugins, or by another reason? And is there a workaround? It is a bug that does not harm me now, but it is a strange one I do not understand. mazdakam on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-10102 Fri, 10 Aug 2007 10:34:58 +0000 mazdakam 10102@http://bbpress.org/forums/ :D _CK_ i could not udrestand what should i do you mean i found function get_view_count ( $topic_id ) and function initialize_view_count( $topic_id ) and put this line above them? if (!$topic_id) return; _ck_ on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-10078 Thu, 09 Aug 2007 15:48:20 +0000 _ck_ 10078@http://bbpress.org/forums/ Ah I know what it is after studying the code a bit. They never planned on $topic_id being null or not set, so it's being inserted into the query as blank. mysql is getting something like <code>SELECT meta_value FROM $bbdb->topicmeta WHERE topic_id = AND meta_key='views'</code> see the blank before AND? It's unacceptable to mysql, needs to be a value. hack <code>function get_view_count ( $topic_id )</code> and <code>function initialize_view_count( $topic_id )</code> and make a new first line for each that says <code>if (!$topic_id) return;</code> Should be a dirty workaround until the author can take a look. mazdakam on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-10073 Thu, 09 Aug 2007 10:33:31 +0000 mazdakam 10073@http://bbpress.org/forums/ i got this error too outchy on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-9370 Thu, 26 Jul 2007 13:53:54 +0000 outchy 9370@http://bbpress.org/forums/ this works really well on the front page, although i'm having a slight issue with my dashboard. when this plugin is active, i get the following error text on the right-hand side: Recently Moderated * Post on bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND meta_key='views'' at line 1] SELECT meta_value FROM bb_topicmeta WHERE topic_id = AND meta_key='views' bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'views', )' at line 1] INSERT INTO bb_topicmeta ( meta_id, topic_id, meta_key, meta_value) VALUES ( NULL , , 'views', ) Welcome to SK6Fans.com by neddi. Here is a <a href="http://www.manonfire.cc/images/errortext.png">screenshot</a> Any thoughts? _ck_ on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-9276 Tue, 24 Jul 2007 16:22:30 +0000 _ck_ 9276@http://bbpress.org/forums/ I've now come up with an extremely easy/fast way to grab and display the views per forum in the forum list on the front page (or forums with sub-forums. Here's the plugin: <pre><code>function forums_views_append($forums) { global $bbdb; $sum_meta_value="SUM(meta_value)"; $forums_views = $bbdb->get_results(" SELECT $sum_meta_value,forum_id FROM $bbdb->topicmeta LEFT JOIN $bbdb->topics ON $bbdb->topicmeta.topic_id = $bbdb->topics.topic_id WHERE $bbdb->topicmeta.meta_key='views' GROUP BY $bbdb->topics.forum_id"); foreach ($forums_views as $forum_views) {$forums[$forum_views->forum_id]->views=$forum_views->$sum_meta_value; } return $forums; } add_filter('get_forums','forums_views_append');</code></pre> To display the views, edit your front-page.php template and insert a views header and views column like so: <pre><code><th><?php _e('Views'); ?></th> <th><?php _e('Topics'); ?></th> <th><?php _e('Posts'); ?></th></code></pre> . <pre><code><td><?php echo $forum->views; ?></td> <td><?php forum_topics(); ?></td> <td><?php forum_posts(); ?></td></code></pre> Since there is no clean way to store forum meta data right now in bbpress (apparently an oversight) this will run on every time the forums list is displayed. Maybe not such a good idea for very busy forums, even though it's a single mysql query (nifty eh?). Eventually I'll figure out a nice way to store this and only update upon new posts or new topics to reduce overhead (or a cron job perhaps). _ck_ on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-9220 Sun, 22 Jul 2007 13:38:51 +0000 _ck_ 9220@http://bbpress.org/forums/ Here's a plugin to extend the topic-views plugin and add a "most-views" view page (ie. view.php?view=most-views) It does it with a minimum number of mysql calls, just 10 to display an entire page on my setup. You have to hack your views.php template to add the views column, use $topic->views for the view count to use the cached data in memory instead of an extra mysql query for each topic. <pre><code>function most_views_views( $views ) { global $views; $views['most-views'] = 'Topics with the most views'; return $views; } add_filter('bb_views', 'most_views_views'); function most_views( $view ) { global $bbdb, $topics, $view_count; switch ( $view ) : case 'most-views' : $limit = bb_get_option('page_topics'); $where = apply_filters('get_latest_topics_where',''); $most_views = $bbdb->get_results("SELECT topic_id FROM $bbdb->topicmeta WHERE meta_key='views' ORDER BY cast(meta_value as UNSIGNED) DESC LIMIT $limit"); foreach (array_keys($most_views) as $i) {$trans[$most_views[$i]->topic_id] =& $most_views[$i];} $ids = join(',', array_keys($trans)); $topics ="SELECT * FROM $bbdb->topics WHERE topic_id IN ($ids) $where ORDER BY FIELD(topic_id, $ids)"; $topics = $bbdb->get_results($topics); $view_count = count($topics); $topics = bb_append_meta( $topics, 'topic' ); break; default : do_action( 'bb_custom_view', $view ); endswitch; } add_action( 'bb_custom_view', 'most_views' );</code></pre> _ck_ on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-9216 Sun, 22 Jul 2007 10:51:44 +0000 _ck_ 9216@http://bbpress.org/forums/ The topic metadata is returned with every set of topics returned to bbpress. In the front page (or any topic page) for example, in the loop it can be found as $topic->views There is no need for an extra mysql query. It's possible to make a function that's called with $topic if you don't want to do it as simple as above. cweb on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-8793 Mon, 09 Jul 2007 19:34:56 +0000 cweb 8793@http://bbpress.org/forums/ Hrmmm, I just installed the plugin, reviewed the steps a few times to make sure I was correct. My view count hasn't been incrementing at all, stays fixed at the Post count. In fact, today a few View counts have actually decremented from the Post count, weird. Seems like a simple enough plugin, did I miss some setup with the database? HowToGeek on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-8097 Fri, 15 Jun 2007 20:20:59 +0000 HowToGeek 8097@http://bbpress.org/forums/ fel64: I'd think that's the best way to handle it for normal usage. Personally, I moved that functionality into a memcached module... not entirely useful for regular installs. fel64 on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-8081 Fri, 15 Jun 2007 10:46:23 +0000 fel64 8081@http://bbpress.org/forums/ I suppose you could make the variable static, meaning it'll be the same every time that function is called, and then check if there's already something in it before you do the query again. Your query would then be selecting the thirty topics last posted in, of course. wittmania on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-8077 Fri, 15 Jun 2007 01:38:12 +0000 wittmania 8077@http://bbpress.org/forums/ I'm open to suggestions... since it's not part of the $topic global, but rather in the topicmeta table, that's the only way I could think to do it. It works as it is, but if you've got a better idea as to how it could work better, I'm all ears. HowToGeek on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-7958 Sun, 10 Jun 2007 06:06:34 +0000 HowToGeek 7958@http://bbpress.org/forums/ One issue with this plugin is that it does a separate SQL call for every single topic on the page.... that's 30 unnecessary SQL calls per topic list view. You might want to take a look at that... wittmania on "Plugin: bb-Topic-Views" http://bbpress.org/forums/topic/plugin-bb-topic-views#post-7781 Thu, 31 May 2007 22:28:06 +0000 wittmania 7781@http://bbpress.org/forums/ OK... it is now available through <a href="http://bbpress.org/plugins/topic/53">the plugin browser</a>!