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!

BozzaJos 05-10-2007 09:14 AM

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 05-10-2007 09:22 AM

Works great, installed, thanks! :)

Omranic 05-10-2007 02:06 PM

Quote:

Originally Posted by BozzaJos (Post 1244850)
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 05-10-2007 04:29 PM

installed cheers
possiblity of adding whos posted most this week?

Endurer 05-10-2007 05:52 PM

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

Thanks for the release SolidSnake@GTI.

rjmjr69 05-10-2007 07:05 PM

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

BozzaJos 05-10-2007 08:00 PM

Quote:

Originally Posted by rjmjr69 (Post 1245133)
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 05-10-2007 08:10 PM

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 05-10-2007 08:14 PM

$tobias_t the third option in the ACP can do that

BozzaJos 05-10-2007 08:36 PM

Quote:

Originally Posted by WielerArchieven (Post 1245177)
$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 05-10-2007 09:31 PM

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 05-10-2007 09:38 PM

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 05-10-2007 10:24 PM

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 05-10-2007 11:32 PM

Quote:

Originally Posted by Kihon Kata (Post 1245207)
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 05-11-2007 02:07 AM

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 05-11-2007 02:28 AM

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 05-11-2007 03:19 AM

Quote:

Originally Posted by FreshFroot (Post 1245354)
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!



Quote:

Originally Posted by LightInClouds (Post 1245364)
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 05-11-2007 05:58 AM

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

Paul M 05-11-2007 04:37 PM

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

Omranic 05-11-2007 04:59 PM

Quote:

Originally Posted by Paul M (Post 1245699)
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 05-11-2007 05:40 PM

I like this ;)

Paul M 05-12-2007 08:17 AM

Quote:

Originally Posted by SolidSnake@GTI (Post 1245713)
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 05-12-2007 08:20 AM

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

Omranic 05-12-2007 08:36 AM

Quote:

Originally Posted by Paul M (Post 1246097)
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 05-12-2007 09:28 PM

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

djjeffa 05-12-2007 10:32 PM

how dose this hack caculate activity?

Omranic 05-13-2007 09:40 AM

Quote:

Originally Posted by rjmjr69 (Post 1246460)
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.


Quote:

Originally Posted by djjeffa (Post 1246490)
how dose this hack caculate activity?

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

rjmjr69 05-13-2007 10:53 AM

Quote:

Originally Posted by SolidSnake@GTI (Post 1246706)
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 05-13-2007 11:41 AM

Quote:

Originally Posted by rjmjr69 (Post 1246733)
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 05-13-2007 02:15 PM

Quote:

Originally Posted by SolidSnake@GTI (Post 1246706)
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


All times are GMT. The time now is 08:35 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.01744 seconds
  • Memory Usage 1,842KB
  • 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
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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