WordPress MU

Hi,

Can't find the way, i'm searching but can't find this :
HOW to show TOTAL NUMBERS of comments writed by bloggers on wordpress MU community ?

Example :
Posts : 3
Blogs (mu) : 59
Comments : ???

Thanks you so but, i'm going to have no hair at this moment.. I'm stresssseedddd

Thanks you,
Patrick

You could use the sitewide feed and snag a count from that.
You could use a paid plugin - http://premium.wpmudev.org/project/Blog-Activity

or you coudl write the SQL statement and pull it out of the db. ;)

Comments for each blog are posted in the wp_x_comments database table (with x being the blog ID). You'd have to iterate through each one of those tables and get the row count for the table. This could be done a different way, I dont know.

Haha, posted at the same time. I like Andreas idea better :P.

Well, my #3 is the same as yours. :D Great minds and all.

try this for the comment count.

Demonicum,

Your code works on my Friend Mu, not in mine We got the latest Mu version :

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/web/mysite/ftp/www/blog/wp-content/themes/theme_admin/sidebar.php on line 33

[LINE 33] : $comment_count = mysql_result($results2, 0);

Maybe conflit with plugins I have installed before..I don't know wich one...

Mr Brian and Andrea,
Thanks for your ideas, but I'm not developper ;(
Maybe I should pay developpers to make me that...Well, No money for the moment ;(

So, If somebody, have another solution, something like demonicume, simple but working differently please post here.

Thank's a lot !!

cache post counts and comments counts in wp_blogs. you won't regret it.

Hey Quenting, you have a great site, with comments numbers in header !!!

Please, be a french gentleman, give your code man ;) You'll not regret it, God is big :)
a++

Adding to what MrBrian said, if you don't want to count the number of posts on each table, you can:

1. create a table called SITEWIDECOMMENTS with a field named TOTALCOMMENTS.

2. add a sql statement that will increase the count each time a comment is posted.

3. then, just echo the value of TOTALCOMMENTS wherever you want to show the total sitewide comments.

.. A lot of developpers here. Thanks t3ch33.

Andrea, you said:
"You could use the sitewide feed and snag a count from that."

How do I grab the comments and the post count from the site wide feed ? Keeping in mind that I will be using supercache, how much of a performance hit this would cause ?