Most active user Last X (last day/last week/last month/ever) Fully controlled

[Omranic]

Please remember to click Mark as Installed if you use this modification.
Support questions from members who have not marked this as installed will be considered low priority.


Attention:
Completely new version by the way, i'm working on it now. note written: 6-10-2007


Many thanks:
Paul M (https://vborg.vbsupport.ru/member.php?u=63698) for his permission to capture pieces of code from his mods.


Name: Most active user (today/last week/last month/ever) Fully controlled

Descreption: Display most active user on the forums for the last day / last week / last month or ever over the boards, also with his post count for this period.


How it works:

During installation process it calculate & select required data, then insert it in a new table.
after that it will process the calculations through cron jops (1 cron dailly: caculates most active user for the last day & most active user ever / 1 cron caculates most active user for the last week / 1 cron caculates most active user for the last month).
So the heavy DB Queries will be done once not every page load :cool: .
This mod uses 4 queries to request already-calculated data that is stored in the database, each one query just request 1 row including 6 fields only, so there is not any DB load, or time load increase after installing this mod.



Features:

can enable/disable the mod globally.
can select to choose most active user for the last day or for the last 24 hours.
can select certain usergroups to show.
can do auto template change, with the ability to disable this feature & do these edits manually.
can choose wwhere to display it by defining Auto-Template Search Text (advanced).
can Collapse Display by default.
can enable/disable most ever active user.
can enable/disable most active user for the month before.
can enable/disable most active user for the week before.
can enable/disable most active user for the day before.
the mod hide null entries (if there is no active user for the last X it will not appear auto.)
this mod displays the most active user & behind his name there is the post count for the X period.
can exclude certain usergroups from being counted in most ative user. v1.5.0
can exclude certain users from being counted in most ative user. v1.5.0
can enable/disable showing usernames with formating tags (prefix / sufix) for usergroups. v1.5.0
can enable/disable display post count of most active user. v1.5.0
can enable/disable linking usernames with user profiles. v1.5.0
uses cron jop for calculations. v1.5.0
fully phrased.



Help Us:

Suggestions needed to develop this mod :).
Translators needed to support more users (translation credits will go to their owners).



Known Isues:
None till now.


History:
v1.0.0 10/5/2007 7:00 AM (EEST): First initial public release.
v1.0.1 10/5/2007 7:40 AM (EEST): Fixing confliction bug with other mod.
v1.5.0 11/5/2007 9:10 PM (EEST): New re-written version, contains new features & many optimizations (approx. it's faster than version 1.0.1 by 15x) [Strongly recomended to upgrade to this version].


Notes:
v1.5.0 is re-writen & totally different from 1.x, it contains many optimizations, it loads 15x faster than v1.0.1 approx., it uses cron jop.
Supported Languages till now: Arabic, English (two products supported in the package, just install one [arabic or english]).


Screen Shots:
Available down there ;) .


Technical Notes:
Plugins: 1
Phrases: 45
Template changes: 1 (AUTO)
Code Changes: 0
Templates: 1
Settings: 15
DB Tables: 1
Cron Jops: 3


Installation Procedure:

Upload the required files (just three cron files), exacly upload the folder includes with its contents to your forum root.
Install the product file from your admincp.
Done :cool: .

[digital3]

The entire forum crashed with a MySQL error after installing it. Of course, uninstall took care of it. It's possible that it conflicted with an existing mod but I doubt it. I didn't stick around long enough to read the error message as I had 50 people online at the time.

If you need the error message I'll reinstall and get it for you after I warn my members first.

[beduino]

tks 4 share
all the best
Beduino

[Omranic]

The entire forum crashed with a MySQL error after installing it. Of course, uninstall took care of it. It's possible that it conflicted with an existing mod but I doubt it. I didn't stick around long enough to read the error message as I had 50 people online at the time.

If you need the error message I'll reinstall and get it for you after I warn my members first.
what's the error message appear for you?

[jagari]

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
FROM vbulletinpost AS post
LEFT JOIN vbulletinuser AS user ON (post.userid = user.userid)
WHERE dateline >
GROUP BY userid ORDER BY postcount DESC LIMIT 1;

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 'GROUP BY userid ORDER BY postcount DESC LIMIT 1' at line 5
Error Number : 1064
Date : Wednesday, May 9th 2007 @ 11:17:33 PM
Script : http://www.gaminggutter.com/
Referrer :
IP Address : 202.138.xx.xx
Username : Ryan
Classname : vb_database


Warning: Cannot use a scalar value as an array in /index.php(63) : eval()'d code on line 183

Warning: Cannot use a scalar value as an array in /index.php(63) : eval()'d code on line 186

Warning: Cannot use a scalar value as an array in /index.php(63) : eval()'d code on line 187




Umm...
Help?

[Omranic]

v1.0.1 Released to fix a confliction bug with other hack.


Hey jagari, digital3.
This is a confliction bug with another hacks, I have fixed it & replaced the product file, just uninstall & re-install the new product & all will be fine.

[FreshFroot]

nice stuff man :D

[digital3]

Cool I'll try it

[digital3]

Yup. That fixed it! Thanks :)

[JeffreySmith]

Cool thanks for the mod. Works perfectly. Installed!

[BozzaJos]

Hack is looking good, nice idea!

Couple of things tho:

1. Could you make it so that we can exclude particular users? Most active user for the past month and past week is now my Newsposter which is a bot posting the latest football news on my forum.

2. Could you fix a : at the end of each sentence and before the username so it looks more organized? Also, could you make the usernames clickable like they are in Currently Active Users?

Hack is great.. if you could fix the 2 points I mentioned above it would be even better hehe. At this moment it's a no-go for me... mostly due to point 1!

[Ticinofelino]

Works great, installed, thanks! :)

[Omranic]

Hack is looking good, nice idea!

Couple of things tho:

1. Could you make it so that we can exclude particular users? Most active user for the past month and past week is now my Newsposter which is a bot posting the latest football news on my forum.

2. Could you fix a : at the end of each sentence and before the username so it looks more organized? Also, could you make the usernames clickable like they are in Currently Active Users?


Hack is great.. if you could fix the 2 points I mentioned above it would be even better hehe. At this moment it's a no-go for me... mostly due to point 1!
Yes, this is possible.
I'll include these additions in the next version, I'll release it as soon as possible.
thanks for suggestions, & waiting for more :).

[Aur-Phala.Com]

installed cheers
possiblity of adding whos posted most this week?

[Endurer]

<font color="olive">Installed</font>

Thanks for the release SolidSnake@GTI.

[rjmjr69]

Is it possible to have the usernames in color for each usergroup

[BozzaJos]

Is it possible to have the usernames in color for each usergroup

That's indeed something I would love to see. But I guess that will happen automaticly when you fix the second point I mentioned in my previous post...

[tobias_t]

Great mod! It would be cool to be able to exclude certain usergroups from being counted. On our forums the mods always make the most posts, and I am more interested in seeing numbers from regular forum members only.

Best,

Tobias

[WielerArchieven]

$tobias_t the third option in the ACP can do that

[BozzaJos]

$tobias_t the third option in the ACP can do that

Isn't the third option for groups that aren't allowed to see the mod on Forumhome??

[Omranic]

the third option in the mod's settings is for determining usergroups allowed to see the most active users in forumhome.

For those requesting excluding certain users, it will be included in the comming version. Be Happy.

Abdelrahman

[Kihon Kata]

Wow that must be a HEAVY DB query. It turns my home page loading time from 1 second to 15 seconds. This is confirmed, I tested it 5 times. Uninstalls

I dunno if this has to do with the size of a board: Almost 1 million posts

[FreshFroot]

I like the hack, but I agree with you. It will add a lot more loading time. For me, I've already got mods like who was online etc.. so I've already got many queries..

Unless we can add an option in say the usercp, where the user can select if they want it or not. I'm sure places with t1 or a fast connection don't have loading issues at all.

[Omranic]

Wow that much be a HEAVY DB query. It turns my home page loading time from 1 second to 15 seconds. This is confirmed, I tested it 5 times. Uninstalls

I dunno if this has to do with the size of a board: Almost 1 million posts
I'm working on a new version now, it will include many optimizations including that one.
approx. it will be totally re-writtem.

Just wait a while :)

[FreshFroot]

can you mabye add an option like the "who posted" hack, where we can assign usergroup Id's to which can see this hack?

[Kaleem]

Great one but its not adding all the posts like at my forum they get an increment in the post when they upload a picture in the gallery that is not added.

[Omranic]

can you mabye add an option like the "who posted" hack, where we can assign usergroup Id's to which can see this hack?

its already exist!



Great one but its not adding all the posts like at my forum they get an increment in the post when they upload a picture in the gallery that is not added.

it counts the real total posts :), may be i'll add an option to switch between the two modes later.

[Hornstar]

Awesome, waits for the updated version which will be more optimized, as my board is under enough load already ^^

[Paul M]

Hmm, when using big lumps of other peoples code it's usually polite to ask ..........

[Omranic]

Hmm, when using big lumps of other peoples code it's usually polite to ask ..........
Sir, perhaps you mean you modification "users visited/posted today"; I Admitted that i have taken some ideas from your Distinct mods, but i didn't take the code it self.
knowing that this mod i have released for 3.5 & now i have re-writen it from scratch.

Any way, i'm sorry if that Behavior make any Inconvenience to you.

[Aimee1969]

I like this ;)

[Paul M]

I Admitted that i have taken some ideas from your Distinct mods, but i didn't take the code it self.
knowing that this mod i have released for 3.5 & now i have re-writen it from scratch.
You took a bit more than just ideas. This has now been restored following our discussions.

[FreshFroot]

Glad that it's back up :D I'll try out the newer version and see how it goes :)

[Omranic]

You took a bit more than just ideas. This has now been restored following our discussions.

Sorry, you are right.
Many thanks paul, I appreciate your kindly permission.

[rjmjr69]

Works great thanks for the update. Can you make it so we can adjust the users colors?

[djjeffa]

how dose this hack caculate activity?

[Omranic]

Works great thanks for the update. Can you make it so we can adjust the users colors?

the user colors depends on tags pre-defined for usergroups.


how dose this hack caculate activity?

it calculates the activity upon the real post count on the forums.

[rjmjr69]

the user colors depends on tags pre-defined for usergroups.




it calculates the activity upon the real post count on the forums.



Well it doesnt seem to be working for me. I of course have the usergroups coded properly. Other than that I love it.

[Omranic]

Well it doesnt seem to be working for me. I of course have the usergroups coded properly. Other than that I love it.
this mod tested on many boards & works fine, check for the option of "showing usernames with formating tags (prefix / sufix) for usergroups" in your admincp (should be on).
also check if the usergroup that the certain user related to it has formating tags.

[djjeffa]

the user colors depends on tags pre-defined for usergroups.




it calculates the activity upon the real post count on the forums.

what exactly do you mean by real post count?
I have the most on my site but yet it shows someone else as most active?
and yes I have all groupes enabled

[Omranic]

what exactly do you mean by real post count?
I have the most on my site but yet it shows someone else as most active?
and yes I have all groupes enabled
as you know: you as an admin can edit some one's post count by editing his user acount from admincp, this modification doesn't depend on that value & it counts the posts of that user to get the real post count of him/her. so i said "real post count".

regarding to the rest: i see the mod works fine in your forums (that in your signature).


interest ;)

[Aimee1969]

I have this installed...but the one for the past day is stuck on the same person with (31) and has been for several days...since I installed this...what can I do?

This is what it looks like:

Most active user for the last day Yvette (31)
Most active user for the last week *~Aimee~* (285)
Most active user for the last month *~Aimee~* (1758)
Most active user ever is *~Aimee~* (1758)

[Pearl]

good job.
most easy thing i'v ever installed.

[djjeffa]

as you know: you as an admin can edit some one's post count by editing his user acount from admincp, this modification doesn't depend on that value & it counts the posts of that user to get the real post count of him/her. so i said "real post count".

regarding to the rest: i see the mod works fine in your forums (that in your signature).


interest ;)
so if we hard delete post they still count twards post?

[PinkDaisy]

I get a database error that says:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT * FROM phpkd_maus
WHERE mausid = '4'
LIMIT 1;

MySQL Error : Table 'belliesb_board.phpkd_maus' doesn't exist
Error Number : 1146
Date : Monday, May 28th 2007 @ 09:35:45 AM
Script : http://belliesbabiesnbeyond.com/forums/index.php
Referrer : http://belliesbabiesnbeyond.com/forums/forumdisplay.php?f=146
IP Address : 75.75.70.111
Username : Jenn
Classname : vb_database

:( Had to unactivate it right now! When I have it off, it works fine.

[Aimee1969]

I just uninstalled it too. It isn't moving from day to day. It has said the same post count since I installed it. :(

[djjeffa]

I just uninstalled it too. It isn't moving from day to day. It has said the same post count since I installed it. :(


same problem for me :(

[SDB]

Hi

Great mod, thank you.

Can this be limited to a certain forum(s)?

Is there a way to grab this information from within the postbit template so I can use a conditional like $is_todays_top_poster[.... to display a badge under the user's name in the postbit?

Thanks in advance

[Omranic]

I have this installed...but the one for the past day is stuck on the same person with (31) and has been for several days...since I installed this...what can I do?

This is what it looks like:

Most active user for the last day Yvette (31)
Most active user for the last week *~Aimee~* (285)
Most active user for the last month *~Aimee~* (1758)
Most active user ever is *~Aimee~* (1758)

It might do this only in case of that this user (Yvette) is the Most active user for the last day & has 31 posts in each day, otherwise it shouldn't do that. (Be sure you have the latest version of the hack).



good job.
most easy thing i'v ever installed.

proud to hear that :).



so if we hard delete post they still count twards post?

Yes, if you notice the features & technical notes you will observe that the hack uses cron jops to calculate the stats, thats means that these stats updated daily (you can edit the cron jop to be runned at a different time interval if you wish).



I get a database error that says:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT * FROM phpkd_maus
WHERE mausid = '4'
LIMIT 1;

MySQL Error : Table 'belliesb_board.phpkd_maus' doesn't exist
Error Number : 1146
Date : Monday, May 28th 2007 @ 09:35:45 AM
Script : http://belliesbabiesnbeyond.com/forums/index.php
Referrer : http://belliesbabiesnbeyond.com/foru...play.php?f=146
IP Address : 75.75.70.111
Username : Jenn
Classname : vb_database


:( Had to unactivate it right now! When I have it off, it works fine.

Uninstall then re-install it again.



Hope you all interest that mod.

[djjeffa]

it seems to be working but not the Most active user for the last day
it changes each day but it keep showing members who made like 1 post when there ar members who have made like 5 to 10 post each day and I dont have any set to exclude.

[hotwheels]

very nice, thank you.........

[Invalid ID]

Jazak Allah

[lazytown]

Nice mod. It would be nice if it could list the X most active users per time period (like 5 instead of 1).

-vissa

[hotwheels]

It isn't moving from day to day, as matter of fact, the poster from the day before isn't even working........It worked one time and only counted that user's first post, not all the post's he made that day..........

Is there a fix for this or is there something those of us that are having this problem can do?

[djjeffa]

it seems to be a bit buggy it would be nice if there was a fix.

[djjeffa]

any fix for this yet?

[AcidX]

Uninstalled too. Not working properly...
"Most active user ever" - doesn't change.
"Most active user for the last day" is not correct. It always brings up some user with 7-9 posts, while there are other users with 100+ posts per day.

[djjeffa]

great I deal for a hack shame its buggy are ther any other hacks simullar to this one?

[djjeffa]

Uninstalled too. Not working properly...
"Most active user ever" - doesn't change.
"Most active user for the last day" is not correct. It always brings up some user with 7-9 posts, while there are other users with 100+ posts per day.

same here, uninstalling as we speak.
is there any working hack simular to this?

[hotwheels]

I would think a mod would change the supported status of this mod to Not Supported.

[Foxtrotelite]

not working for me either. It shows the users but it doesnt update and the post amount is not correct

[Omranic]

I'm working now on a completely new version, it has many fixes/optimizations.
Just wait few days for it :)


This mod will still supported ;)

[Mazinger]

What variable to manually add instead of automatically modify templates?

[GhoHan]

nice ones.
but seems that excludes user groups not working properly.
i still have my junior mods being displayed.
any ideas ?

INSTALLED though :)

[SNATCH3R]

I been looking for this mod for a long time...will this support 3.7.... expect to get a reply soon......

[Raptor]

sql errors with 3.7.2

[Raptor]

I'm working now on a completely new version, it has many fixes/optimizations.
Just wait few days for it :)


This mod will still supported ;)

a year later........ ;)

[PHILIPS-08]

thanx alot for the great mod i was looking for this

[g00gl3r]

Is there a 3.7 & 3.8 version or will this work on both?

[TFEX]

My coder and I have made a significant update to this mod for my own forum's purposes that I hope is ok to share with all of you here. If not, please feel free to remove the attached file.

This version will allow admins to exclude forum id's from the counts along with users and usergroups. The postcount numbers will accurately report the changes on the forumhome.

Once you have re-uploaded and installed, simply set the forums you want to exclude in "vBulletin Options -> Most Active User Last X" and then run the three related cron jobs again from your scheduled tasks area to see the results immediately.


Installed and working on vb 3.8

[temsamane]

i want this mod for vb 4.1x