The Activity Hack v2.1

vB3.5 and vB3.6 users click here

There will be no additional releases of the vB3/hack version; this mod has moved on to vB3.5 as a plugin (see here)

I've been using a less-configurable version of this hack on my forum for over a year. After constant pestering from certain people, here is a version IMO fit for public consumption; consider it a Christmas gift.

Description
This hack adds an activity metric for users to your forum; this metric takes into account a variable number of weeks. Also provided is a Junior/Normal/Senior member system based on this metric, and a longevity metric (user registered time as a percent of the amount of time the first user has been registered).

See zelaron.com for an example of what can be done with this.

Visiting each day and posting the configured amount of times per day for the configured number of weeks will yeild 100% activity. Posts are checked individually for each day, so days cannot be skipped then spammed up afterwards. The weight of visiting for the day relative to posting is configurable. Weeks are weighted so the most recent has a bigger impact on the activity percent than the most distant.

When a user logs in with 50% activity, they are promoted from Junior Member to Member. When they log in 3 months from that time, they are promoted to Senior Member.

Complexity
This hack edits 6 files and 3 templates. The hack adds one table, four fields to the user table, as well as its own settings and phrases.

Technical
This hack adds 1 query to showthread for each user who posts in that page (or only 1 for the logged in user by configuration). 1 query per thread is performed to find join date of first user (this will be changed to a setting in a future version). In addition, the first time a member's post or profile is accessed during a day (GMT), 3 queries are performed to find that user's activity depending on configuration.

Notice
When you first install this hack, no user will have 100% activity because whether or not a user visited on a day is not recorded untill after installation. You may want to set the number of weeks to two at first and increase it as time passes and the visit log fills.

Support
Please click the install link if you install this hack
This hack is in beta because remaining bugs will only become evident over time due to the nature of this hack. I will support this hack in this thread.

3/30/2005
Added barsamples.zip, sample activity and longevity bar images.

Update v2.1
I have fixed the activity calculation so that it adds a fixed 3 queries instead of 16 to 48. To update, simply upload the new activity.php

[WetWired]

This is a setting in the options.
AdminCP>vBulletin Options>Activity Hack>Find today's activity for all users

If you don't put the ranktext part into the memberinfo or postbit templates, then noone will see or be affected by the ranking system.

[GrusPer]

Greetings
Has put this code
But at me the problem with date base writes that
At me date the base is with
Prefix\Table vb3_mos_ ******
That to me to do what to correct a code

================
Database error in vBulletin 3.0.5:

Invalid SQL: UPDATE user SET activity='54',activitydate='1115856000' WHERE userid=127
mysql error: Table 'grusper_ryzom.user' doesn't exist

mysql error number: 1146

[GrusPer]

Anybody help me ? pl ppl

[WetWired]

I have updated the activity.php in the original post. Redownload this file and upload it to your server, and the problem should go away.

[GrusPer]

Database error in vBulletin 3.0.5:

Invalid SQL: SELECT COUNT(*) AS num FROM vb3_mos_post LEFT JOIN thread on post.threadid=thread.threadid LEFT JOIN forum on thread.forumid=forum.forumid WHERE ((forum.options&4096))AND(post.userid=1)AND(post.d ateline>=1116028800)
mysql error: Table 'grusper_ryzom.thread' doesn't exist

mysql error number: 1146

:disappointed: :cry:

[WetWired]

Updated again. Apparently I missed the TABLE_PREFIXes on the joins. It should work now.

[GrusPer]

Cool thx - all works
big thx WetWired

[GrusPer]

no no cool
on bug here
----
At attempt of viewing of a subject where ALREADY there is YOUR answer base gives out a mistake.
----------


Database error in vBulletin 3.0.5:

Invalid SQL: SELECT COUNT(*) AS num FROM vb3_mos_post LEFT JOIN vb3_mos_thread on post.threadid=thread.threadid LEFT JOIN vb3_mos_forum on thread.forumid=forum.forumid WHERE ((forum.options&4096))AND(post.userid=117)AND(post .dateline>=1116201600)
mysql error: Unknown table 'forum' in where clause

mysql error number: 1109

[Marco van Herwaarden]

In your activity.php, find:

PHP Code:

      $visitlog=$DB_site->query_first("SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post LEFT JOIN '.TABLE_PREFIX.'thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum on thread.forumid=forum.forumid WHERE ((forum.options&$_FORUMOPTIONS[countposts]))AND(post.userid=".$userid.")AND(post.dateline>=".($checkend-($days+1)*ACTHACK_ONE_WEEK).")AND(post.dateline<".($checkend-$days*ACTHACK_ONE_WEEK).")"); 


and replace by:

PHP Code:

      $visitlog=$DB_site->query_first("SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post AS post LEFT JOIN '.TABLE_PREFIX.'thread AS thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum AS forum on thread.forumid=forum.forumid WHERE ((forum.options&$_FORUMOPTIONS[countposts]))AND(post.userid=".$userid.")AND(post.dateline>=".($checkend-($days+1)*ACTHACK_ONE_WEEK).")AND(post.dateline<".($checkend-$days*ACTHACK_ONE_WEEK).")"); 


Find:

PHP Code:

        $poststoday=$DB_site->query_first('SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post LEFT JOIN '.TABLE_PREFIX.'thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum on thread.forumid=forum.forumid WHERE ((forum.options&'.$_FORUMOPTIONS[countposts].'))AND(post.userid='.$post['userid'].')AND(post.dateline>='.$startofday.')'); 


and replace by:

PHP Code:

        $poststoday=$DB_site->query_first('SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post AS post LEFT JOIN '.TABLE_PREFIX.'thread AS thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum AS forum on thread.forumid=forum.forumid WHERE ((forum.options&'.$_FORUMOPTIONS[countposts].'))AND(post.userid='.$post['userid'].')AND(post.dateline>='.$startofday.')'); 


[GrusPer]

$poststoday=...........

And what picture should be in
today1.gif ?