Forum Home Enhancements - Most active user Last X (last day/last week/last month/ever) Fully controlled

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 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 .
• 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:

1. can enable/disable the mod globally.
2. can select to choose most active user for the last day or for the last 24 hours.
3. can select certain usergroups to show.
4. can do auto template change, with the ability to disable this feature & do these edits manually.
5. can choose wwhere to display it by defining Auto-Template Search Text (advanced).
6. can Collapse Display by default.
7. can enable/disable most ever active user.
8. can enable/disable most active user for the month before.
9. can enable/disable most active user for the week before.
10. can enable/disable most active user for the day before.
11. the mod hide null entries (if there is no active user for the last X it will not appear auto.)
12. this mod displays the most active user & behind his name there is the post count for the X period.
13. can exclude certain usergroups from being counted in most ative user. v1.5.0
14. can exclude certain users from being counted in most ative user. v1.5.0
15. can enable/disable showing usernames with formating tags (prefix / sufix) for usergroups. v1.5.0
16. can enable/disable display post count of most active user. v1.5.0
17. can enable/disable linking usernames with user profiles. v1.5.0
18. uses cron jop for calculations. v1.5.0
19. 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 .

[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]

Originally Posted by 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.

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

[digital3]

Cool I'll try it

[digital3]

Yup. That fixed it! Thanks

[JeffreySmith]

Cool thanks for the mod. Works perfectly. Installed!