Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Widget: Top 5 Posters this Week Details »
Widget: Top 5 Posters this Week
Mod Version: 1.0.0, by MaryTheG(r)eek (Member) MaryTheG(r)eek is offline
Developer Last Online: Mar 2012 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 4.0.0 Rating: (9 votes - 4.89 average) Installs: 98
Released: 22 Dec 2009 Last Update: Never Downloads: 2
Not Supported Auto-Template  

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

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Show Your Support

  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
vBulletin CMS Widgets Widget: Top 5 Posters this Month MaryTheG(r)eek Modification Graveyard 50 11 Aug 2010 11:09

Comments
  #2  
Old 22 Dec 2009, 15:16
Garamond's Avatar
Garamond Garamond is offline
 
Join Date: Jul 2004
Excellent add-on I like it!
Reply With Quote
  #3  
Old 25 Dec 2009, 00:34
kendo kendo is offline
 
Join Date: May 2004
Multiple Usergroups

Nice work!

Is it possible to include multiple usergroups in this, or just one?
Reply With Quote
  #4  
Old 25 Dec 2009, 06:01
MaryTheG(r)eek MaryTheG(r)eek is offline
 
Join Date: Oct 2006
Real name: Maria
Originally Posted by kendo View Post
Nice work!

Is it possible to include multiple usergroups in this, or just one?
Yes, sure. You can do it on 2 ways:

1.- Changing the "where" argument from WHERE usergroupid=2, to WHERE usergroupid=2 OR usergroupid=3 OR usergrooupid=7 . In this example we assume that you want to include members who belong to usergroups 2,3,7

2.- By using an array. At the top of the file add:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Then change the "where" argument from WHERE usergroupid=2, to WHERE usergroupid IN ($groupids)

Maria
Reply With Quote
  #5  
Old 26 Dec 2009, 03:15
kf4eok's Avatar
kf4eok kf4eok is offline
 
Join Date: Sep 2009
Real name: Daniel
Thanks, installed
Reply With Quote
  #6  
Old 03 Jan 2010, 02:36
Clizon Clizon is offline
 
Join Date: Oct 2008
Any way to EXCLUDE certain users? I have some newsbot users that will always win the post wars.
Reply With Quote
  #7  
Old 03 Jan 2010, 06:06
Bergler Bergler is offline
 
Join Date: Dec 2006
Originally Posted by MicroHellas View Post
Yes, sure. You can do it on 2 ways:

1.- Changing the "where" argument from WHERE usergroupid=2, to WHERE usergroupid=2 OR usergroupid=3 OR usergrooupid=7 . In this example we assume that you want to include members who belong to usergroups 2,3,7

2.- By using an array. At the top of the file add:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Then change the "where" argument from WHERE usergroupid=2, to WHERE usergroupid IN ($groupids)

Maria

Ah ha! That worked!! Was that always here, my bad Thanks for the great widget!! Happy new year!
Reply With Quote
  #8  
Old 06 Jan 2010, 18:03
microlight microlight is offline
 
Join Date: Dec 2009
Didn't work.

Broke my board

Got the following database error because I have the majority of users are imported from a previous board. The user name is REGISTERED and the user I.D. is 31. I edited the code as you said... but it didn't work. Any ideas?

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT user.userid, user.username, user.usertitle,
COUNT(post.postid) AS postcount
FROM user
LEFT JOIN post
ON post.userid=user.userid
AND dateline>'1262563200'
WHERE usergroupid=2 OR to WHERE usergroupid=31
GROUP BY user.userid
ORDER BY postcount DESC
LIMIT 5;

MySQL 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 'to WHERE usergroupid=31
GROUP BY user.userid
ORDER BY postcount DESC
LI' at line 7
Error Number : 1064
Request Date : Wednesday, January 6th 2010 @ 07:00:10 PM
Error Date : Wednesday, January 6th 2010 @ 07:00:11 PM
Script : http://www.microlightforum.com/content.php?121
Referrer : http://www.microlightforum.com/content.php?142
IP Address : 90.194.162.111
Username : VinceG
Classname : vB_Database
MySQL Version : 5.0.87-community

Last edited by microlight; 06 Jan 2010 at 18:10.
Reply With Quote
  #9  
Old 07 Jan 2010, 00:29
Blackhat's Avatar
Blackhat Blackhat is offline
 
Join Date: Mar 2005
this widget crashes my whole site when using it
__________________
running vBulletin 4.0.6
Reply With Quote
  #10  
Old 07 Jan 2010, 05:09
MaryTheG(r)eek MaryTheG(r)eek is offline
 
Join Date: Oct 2006
Real name: Maria
Originally Posted by microlight View Post
Didn't work.

Broke my board

Got the following database error because I have the majority of users are imported from a previous board. The user name is REGISTERED and the user I.D. is 31. I edited the code as you said... but it didn't work. Any ideas?

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT user.userid, user.username, user.usertitle,
COUNT(post.postid) AS postcount
FROM user
LEFT JOIN post
ON post.userid=user.userid
AND dateline>'1262563200'
WHERE usergroupid=2 OR to WHERE usergroupid=31
GROUP BY user.userid
ORDER BY postcount DESC
LIMIT 5;

MySQL 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 'to WHERE usergroupid=31
GROUP BY user.userid
ORDER BY postcount DESC
LI' at line 7
Error Number : 1064
Request Date : Wednesday, January 6th 2010 @ 07:00:10 PM
Error Date : Wednesday, January 6th 2010 @ 07:00:11 PM
Script : http://www.microlightforum.com/content.php?121
Referrer : http://www.microlightforum.com/content.php?142
IP Address : 90.194.162.111
Username : VinceG
Classname : vB_Database
MySQL Version : 5.0.87-community
Please, don't say so easy "didn't work" and "broke my site", before you're totally sure that you did everything correct.

In your case, you wrote "WHERE usergroupid=2 OR to WHERE usergroupid=31" while the correct is "WHERE usergroupid=2 OR usergroupid=31". Why you added more "to WHERE"?

Maria
Reply With Quote
  #11  
Old 07 Jan 2010, 05:11
MaryTheG(r)eek MaryTheG(r)eek is offline
 
Join Date: Oct 2006
Real name: Maria
Originally Posted by Blackhat View Post
this widget crashes my whole site when using it
Can you be more specific please? How is possible to crash your site, while its working fine for me and for so many others? Have you modified the code? If yes, are you sure that you modified it correct, or you need to read my previous post?

Maria
Reply With Quote
  #12  
Old 09 Jan 2010, 20:21
Juggernaut's Avatar
Juggernaut Juggernaut is offline
 
Join Date: Dec 2009
I tried changing the where, the way you show it, but it gives me
a database error no matter which of the two methods you show, I use.
Reply With Quote
  #13  
Old 09 Jan 2010, 21:23
microlight microlight is offline
 
Join Date: Dec 2009
Sorry Maria. It didn't work and I didn't put the 'to' in there.

Your other one top posters this month is now on my site. I removed completely the following line

WHERE usergroupid=2

And the other monthly mod works fine. Although I am the highest poster to my site
Reply With Quote
  #14  
Old 11 Jan 2010, 04:10
Numenorean7 Numenorean7 is offline
 
Join Date: May 2009
Works great !

The only thing to improve would be to avoid displaying old inactive members with 0 posts during the first hours of the new current week. I guess there could be a condition to allow only members who posted this week, that would work.

Thanks a lot!
Reply With Quote
  #15  
Old 11 Jan 2010, 07:28
MizzouHoopster MizzouHoopster is offline
 
Join Date: Aug 2009
I'm probably going to sound so dumb, but I am new with Vbulletin and can't even find the "VbulletinCMS" area. I know I have seen Add widget before, but I have looked for countless minutes.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:12.

Layout Options | Width: Wide Color: