PDA

View Full Version : Statistics Modifications - VSa - Top Posters of the Month/Year


Valter
02-24-2010, 10:00 PM
Info:
-Top posters of the month/year statistics

Installation:
-Import XML file (as product) through AdminCP: Plugin System > Manage Products > [Add/Import Product]

To set options:
-Go to: vBulletin Options > VSa - Top Posters of the Month/Year/Year

Versions:
v1.0 - Dec 09. 2006.
-Initial release
v1.6 - Apr 30. 2008.
-Latest vB 3.x version
v2.0 - Feb 25. 2010.
-Updated for vB 4
v2.1 - Jun 09. 2012.
-Fixed: QL Link in vB 4.2
-Fixed: User post search links
-Fixed: Style issues

LuckyNeo
02-25-2010, 12:44 AM
Nice! Very good! Take this FIVE, install.....and THANK YOU!!!:up:

War.Frog
02-25-2010, 03:43 AM
Very nice! Thanks ONCE AGAIN!

Alecsmith
02-25-2010, 04:13 AM
very nice and thank u so much :)

Jonluci
02-25-2010, 09:49 AM
Thanks for this mod :)
Awesome

COL NIL SATIS
02-25-2010, 12:38 PM
Awesome Valter..your on a roll lately man ..Rated 5 and HITS install :D

AzzidReign
02-25-2010, 10:04 PM
Thanks bro.

tahrim
02-26-2010, 01:28 PM
Installed....thnxxx

furst
03-03-2010, 07:23 AM
This is good. Thanks.

If all of these stats hacks had graphs to provide a visual representation of the data it would make them far more valuable.

hydn
03-30-2010, 08:41 PM
why do you need "starting year"?

betts02
03-30-2010, 08:45 PM
any chance to make this for top poster of the week ?

cheers and will keep an eye on this

nkumaran
05-10-2010, 06:32 PM
Thank you.

ProFifaLeagues
05-10-2010, 06:34 PM
nice work thanks

Peter Lo
05-15-2010, 03:34 AM
Could this be adapted for Top Thread Starters?

ArchAngelz
05-20-2010, 04:37 AM
A Top Thread of the Month/Year would be cool.

Veer
05-20-2010, 09:33 AM
A Top Thread of the Month/Year would be cool.
Yes, agreed. It would be great.

domi681
05-28-2010, 06:14 PM
hello all,

I just installed VSA - Top Posters of the Month / Year, I need your help to make it public, only accessible to registered users.

How to make so that everyone has access to lists of VSA - Top Posters of the Month / Year?

Thank you.

leeman
06-17-2010, 11:49 AM
GREAT!!

Nice work.

ArchAngelz
08-05-2010, 05:40 AM
Valter would you be able to do this for Top Threads as well? We are trying to run a contest and having a top thread will help us with this!

DAMINK
08-08-2010, 07:30 AM
Damn works for everyone but me.
I get a blank page when i got to misc.php?do=vsatpomy ?

asus78
08-15-2010, 07:08 PM
I would love to have a nomination mod for certain topics. They have been very popular in the earlier vb versions. Would be the best thing to have one now again.

ArchAngelz
08-30-2010, 02:31 AM
Repeating the call to include the ability to also have Top Threads started in this mod.

Am willing to pay for it if necessary; hope to hear your good news!

Valter would you be able to do this for Top Threads as well? We are trying to run a contest and having a top thread will help us with this!

audis3
10-03-2010, 02:29 PM
Can this be done to work in sidebar as a block?

And if yes how?

persianpros
10-27-2010, 07:02 AM
Persian Translation :cool:

By Persian Prince

pom
11-05-2010, 10:24 PM
hey any one can help me to have weekly basis post count or from perticular date to end date....

as i am having contest on place weekly basis so i need this solutions...

regards

pom
11-08-2010, 04:43 AM
hey anyone can help me in this matter plz...

i need some modification to be added...

thanks

phoelapyae
11-25-2010, 11:23 PM
Great. Thanks for your kindness.
It's still working for version 4.0.8.

Munkholm
03-04-2011, 02:53 PM
Anyone up for "merging" this and the helpful answers mod (https://vborg.vbsupport.ru/showpost.php?p=2169435&postcount=850) into a "post of the month/year" system ?

Seems pretty straight forward, if only I understood the mySQL query/join coding...

XiTCLUB
03-04-2011, 09:31 PM
Thanks, Installed

FTDave
03-08-2011, 12:56 AM
This is exactly what I have been looking for.
Thank you

Lord. Dela
07-19-2011, 11:54 PM
Thanks :)

dypsisdean
08-17-2011, 05:31 AM
Is anyone aware of any similar mod, or has anymore work been done on this one, such as weekly top posters, or thread starters, etc?

mjfan227
08-18-2011, 01:35 AM
Installed, thank you very much.

pankajguptag
08-22-2011, 09:55 AM
Installed Thank you.. WOrking on my 4.1.5. Here is the link: http://www.wedost.com/misc.php?do=vsatpomy


Can you modify it to short the top posters based on date range and also top topic starters?

Or Is their any mod?

Bisha
02-14-2012, 04:48 PM
As a module will be perfect!

mostafa10601
06-08-2012, 05:11 PM
hi, this mod must update for vb 4.2.X

plz update mod...

tnx

Valter
06-09-2012, 09:19 AM
why do you need "starting year"?
To know where to start. This is usually year when your forums came online.

You won't 1970 as an option to view year stats for, do you? :D

I need your help to make it public, only accessible to registered users.
There is an option in AdminCP to set groups able to view stats.

Valter
06-09-2012, 09:27 AM
v2.1 - Jun 09. 2012.
-Fixed: QL Link in vB 4.2
-Fixed: User post search links
-Fixed: Style issues

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

Bisha
06-13-2012, 03:23 PM
Thank you for the update!

I think I have an issue with forums excluded from counts.

The Rocketeer
07-02-2012, 09:51 AM
anyway to make it show the top poster of the month (person with the most post counts for the current month) or most posts in the forum index Whats Going On?

voter
08-20-2012, 03:19 PM
I don't see the link in Quck Links.
Adding IDs of into "USERGROUPS can see Stats (comma separated ID list)" dosn't help.

lilow
09-02-2012, 08:22 PM
Thanks

TheSupportForum
09-09-2012, 07:00 PM
Forum Block would be nice for this, this is what i need for my forum but as forum block

is this possible developer ?

tinhlt
10-08-2012, 01:13 PM
A Top Thread of the Month/Year would be cool.

+1 :up:

usefee
11-09-2012, 07:58 PM
i have find a issue!
deleted post not remove from user post count in rating...
plz fix it...

M.C.
05-13-2013, 08:51 AM
great hack but can be modifyed to TOP Thread Starter of Month or new hack?

I believe this is where we need to do changes:
SELECT COUNT(post.dateline) AS vsapcount, post.userid, post.visible, post.dateline, thread.forumid, user.usergroupid, thread.forumid
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
WHERE user.username != '' AND post.visible = '1' AND post.userid > 0 AND post.dateline > $fromtime AND post.dateline < $totime $vsattsomy_exclgroups $vsattsomy_exclusers $vsattsomy_exclforums
GROUP BY userid

and this
SELECT COUNT(post.dateline) AS vsapcount, post.userid, user.username, user.usergroupid, post.visible, user.posts, user.joindate, thread.forumid
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
WHERE user.username != '' AND post.visible = '1' AND post.userid > 0 AND post.dateline > $fromtime AND post.dateline < $totime $vsattsomy_exclgroups $vsattsomy_exclusers $vsattsomy_exclforums
GROUP BY userid
ORDER BY vsapcount DESC
LIMIT " . ($limitlower - 1) . ", $perpage

BGObsession
06-16-2013, 06:43 PM
I like this mod - only thing I'd like to see is an option under the year for 'All' - so I get top poster list since site opened. It does show total posts for members, but doesn't sort them. It would also be nice to be able to set it to default either to current year or 'All'.

john7911
06-28-2013, 09:57 AM
Thank you ;)

BGObsession
08-21-2013, 11:35 PM
I don't understand why the mod creator coded the option to filter for 'Top Posters' by 'all months' but not 'all years'.

Isn't being able to show all-time top posters likely one of the most desired pieces of information?

Any ideas on how to add the drop-down option for 'All' for years???

BGObsession
09-21-2013, 03:04 PM
Bumping this question - any chance this mod will be updated to include 'Top Poster' for 'all years'?

nima6
12-03-2013, 05:56 PM
I've added this mod but don't see a link to go to a page to see the actual top posters of the month. I don't see it under "Quick Links"

any ideas why?

BGObsession
01-26-2014, 12:38 AM
Any update on this - it would seem like a 'no brainer' to have an 'all' option under the years drop-down so that you could view lifetime top posters on a site, yet that is not an option. Help anybody?

BGObsession
01-26-2014, 12:42 AM
I've added this mod but don't see a link to go to a page to see the actual top posters of the month. I don't see it under "Quick Links"

any ideas why?

I think you have to manually add it to the quick links drop-down. The url should be your site url followed by /misc.php?do=vsatpomy

It works great on my site.

dobberhockey
03-20-2014, 08:09 PM
Fantastic. As advertised. Quick and easy. A+

dobberhockey
03-20-2014, 08:10 PM
Any update on this - it would seem like a 'no brainer' to have an 'all' option under the years drop-down so that you could view lifetime top posters on a site, yet that is not an option. Help anybody?
Lifetime stats are already a part of vbulletin, just by going to the 'view members' link, or do I misunderstand you?

BGObsession
03-21-2014, 12:26 AM
I get you, but very few members know that, and they would have to filter by posts once looking at the Member List. The whole point of this mod (or what I like about it) is that it gives a much more obvious method/tool to see the top posters.

You can view ALL months in a single year, I'm just wondering why it wasn't set up so you can filter by ALL months in ALL years?

ka81
12-19-2016, 04:30 PM
Is it possible to get such an update:
to choose exact forumid where i'd like to see stat about most active users?
I know there's EXCLUDE FORUMS option, but it's long enough to write down there all not-interesting forumids.

ka81
10-10-2018, 10:20 AM
Seems like mod not actualy working on my 4.1.8
((

Is there any similar working mod?