vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Forum Home Enhancements - Most active user Last X (last day/last week/last month/ever) Fully controlled (https://vborg.vbsupport.ru/showthread.php?t=146886)

Omranic 05-09-2007 10:00 PM

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

digital3 05-10-2007 03:10 AM

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 05-10-2007 03:12 AM

tks 4 share
all the best
Beduino

Omranic 05-10-2007 03:18 AM

Quote:

Originally Posted by digital3 (Post 1244753)
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 05-10-2007 03:19 AM

Quote:

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 05-10-2007 03:45 AM

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 05-10-2007 04:00 AM

nice stuff man :D

digital3 05-10-2007 04:42 AM

Cool I'll try it

digital3 05-10-2007 04:45 AM

Yup. That fixed it! Thanks :)

JeffreySmith 05-10-2007 06:47 AM

Cool thanks for the mod. Works perfectly. Installed!


All times are GMT. The time now is 02:13 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01515 seconds
  • Memory Usage 1,751KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete