Widget: Top 5 Posters this Month
 

..............................................

Worked beautifully on my site. Thanks!

It is Excellent! and I love it!

btw any chance you can make a block out of this so we can also add it to the forums? :)

Tagged, will use it after upgrades on my site. BTW, can you read my siggy please? :p

Can this be made so it will open in same window other than a new window ?

Yes, it can be done be modify the code. Just remove:
from any link (those starting with "<a")

Maria

Thanks Maria

Installed in my dev forum since im not prod yet with 4.0
The formatting for posts to user appears to be off though for me. I did remove the usergroup line in the query since in my dev site all the users are basically admin right now
See attached

https://vborg.vbsupport.ru/external/2009/12/38.jpg

Hi,
Is it possible to show the avatars of all users, the top 2 - 5 in a smaller size and also to add the online status, add as a friend and send a private message icon next to the name?

Deathly slow query on a forum with a lot of posts.

installed

Thanks Maria

Just commenting in such a topic, says nothing more other than someone wants to appear smarty. Include in your post what do you think as optimised query, and also be more specific on your meaning of "lot of posts", so the users can compare it with their forum's posts. So "Lot of posts" means 1000, 10000, 100000 or what?

And don't forget the saying: "If you don't have something good to say, is better to keep your mouth close".


Thank you and Merry Christmas to you and to your family.
Maria

In my case the forum has 2,162,154 posts and the query takes about 3-5 seconds. You could have clicked on the link to my forum to see the post total btw. I tried out the mod, found the query to be slow and removed it. I don't have time to optimize the query.

This doesn't apply in this case. People need to know the good and the bad when it comes to these mods. An inexperienced forum owner could cripple his forum from installing something without considering the negative effects it could have on performance.

Same to you :D

It's not about anount of posts my dear friend. It's about amount of users. The records in the parent table (in this case "Users"), is who takes more time and not the child table (in this case "Posts"). Simple because the child table is already indexed on userid, so the query stops running when userid is changing, unlike the parent table (users) where the query must go throughout all records.

In simple words: 1000 users X 2000 posts each, will take less time than 10000 users X 200 posts each, even if the total amount of posts is the same on both cases.

Calorie wrote it somewhere. It's American saying, and yes I also disagree with it, but only in cases when someone says his opinion explaining it, just like you did in your second post.

Maria

This is another nice little widget you've written.

Many thanks and keep up the good work!

Rather than having just usergroup 2, is there any way of having it pick up usergroup 2 AND 10?

Id rather not remove line 17. As you say, Admins would always go to the top of the list.

installed thanks

Further to my other post about it recognising multiple usergroups, my installations doesn't seem to show users avatars, even though they DO have an avatar installed.

The top posters just has the default avatar showing.

great thanks

I dont see "Choose PHP Direct Execution as Widget's Type" in the widget creation page.

Am I missing something here?

This is a vBulletin issue, so you've to contact them for support. As you can see there are lot installation which means that this option exists. Actually is the 2nd from the end. Maybe your PHP version, your server type... don't know what to say.

Maria

Not working on my site (check right side for the widget) :

http://www.pcshoptalk.com/

Any ideas?

It is posible to add this widget on forum site?

Regards
kjpp

Only if someone else takes the code and change it to work with forumhome. I don't use to code touching forumhome.

Maria

Maria,
I would also like to do this. I'd like to add 2 more usergroups to the query, but NOT include the mods, the admin, and a couple other groups.

(WHERE usergroupid=2, 18, 19) ???


That would be great!

Thanks!

@ Mikhailtech
just works fine on your page, as fare as i can see :)

@ Maria
Thanks, i like it !

You're right. I was checking posts for non-registered users, forgot this only checks that group by default.

@Maria ... is there any way to save/check this query after the month is over? Something like "last month's top posters". What would be the code syntax for that? I'm asking because I need to know the top posters for each month up to midnight and it's best to check that the following month.

Thank you!

Yes it works, but unless you can add more usergroups, I dont think it will work as good as it could. I went in to try and add other usergroups as suggested but I get a database error from where i added the usergroups! I tried it like this, (WHERE usergroupid=2, 18, 19) and like this (WHERE usergroupid=2 18 19) No work, just error on both.

My usernames and post count dont seem to line up...

Hmmm

Got this from another thread and this worked!!

Hey, lets say it picks top 5 posters of Jan, what happens when Feb 1 hits? Will it start everyones count back down to ZERO so we can see who are the top posters EACH month so some ppl dont have a head star advantage?

thanks!

Yes it restarts every month

Due to lack of free time, I must decrease the time that I'm spending here for support. By having a long thread for each of my 16 mods, most often I'm bypassing questions. That's why for urgent questions please visit my site, where it's easier to support you, by having a thread per question.

Thank you
Maria

Thanks but i have one problem.. If the avatar are big image not look fine..
How to fix....?

I would think that if you changed this line

to

this should take care of it.

Thanks very much...

Problem with FF2 and show the numbers of posts

https://vborg.vbsupport.ru/external/2010/03/66.jpg

How to fix this??

I changed limit from 5 to 10 and this poped in.

i'vw got the same problem too.