Administrative and Maintenance Tools - User Activity Logging

USER ACTIVITY LOGGING.

Description:
This Mod will (eventually) allow you to track a users activity from any script within vB or its addons ... well at least those that make use of the Hook features.

Background:
I have seen various requests around for some form of user logging but never been able to find an actual Mod. As we had a need for this on our site I decided to write my own.
I have been working with vB for a couple of years now (and a php coder for a lot more) and made use of a number of other coders Mods, both as they had been released or customized to suit our own purposes. Although not a very active poster here at vBorg, it is one of my regular visits.

Installation:
Standard Product Import using the AdminCP.
No template changes.
Optional (for AdminCP Log Viewer):
- Upload contents of zip file

Upgrade:
Will be as above, but select 'Overwrite'

Features:
Database and/or Thread notification of activity
Selectable Forum for Thread notification
Selectable posting User for Thread notification
On/Off for each logging area
AdminCP Log Viewer/Pruner
Additional thread option for logging all Log-ins and outs

Current Logging Areas:
showthread - logs when a user views a thread (this is currently the only one I am using and I am actually happy with)
forumdisplay - logs when a user views the forumdisplay script
search - logs when a user makes a search
editpost - logs when a user edits a post
log-ins/log-outs - logs successful and unsuccessful log-ins and log-outs
profile views - logs when a user views the 'member profile' page

ChangeLog:
v1.0.6 (28 Nov,2007) - incorporated IPAddress tracking as provided by dartho (thanks )
v1.0.5 (16 May,2007) - added profile viewing both for 'logged users' and 'all user to a separate thread'. No admincp file update required. NB: Check options after upgrading.
v1.0.4 (07 May,2007) - added log-in/out logging both for 'logged users' and 'all user to a separate thread'. No admincp file update required.
v1.0.3 (27 April, 2007) - Corrected 1 thread per logged user issue, added 'editpost' logging area
v1.0.2 (25 April, 2007) - Check for deleted thread & added AdminCP Log Viewer
v1.0.1 (24 April, 2007) - Error in XML
v1.0.0 (24 April, 2007) - Initial release

Future Enhancements?:
Additional logging areas (just ask and I'll look in to it)
[S]Viewable log transcripts taken from database entries[/S] - completed
Usergroup logging

Thanks To:
All those other coders whose Mods I have installed and learned from

Note: This is the first Mod I have actually released here (or anywhere), so please go easy on me
Hopefully I have the Product URL and Version Checking URL links right.

[dartho]

do you reckon this could log user activity from a specific IP address as opposed to a user name?

Thanks

[citroenar]

Every time script write a log I get SQL error:

Database error in vBulletin 3.6.7:

Invalid SQL:

UPDATE forumuser
SET logging_thread = 1205
WHERE userid =;

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 '' at line 3
Error Number : 1064

[Noonster]

Any screenshots of how the forum will look and how it will post a person's activities?

Thanks

[chatzworld]

works great is their anyway you can track them when using stuff like the arcade, blogs, gallerys etc?

[David Lama]

installed and marked as installed. thanks

but what do you mean by "Record logging details in the database" ?

[pictureboarduk]

Does this log the search queries made by users at all (the words they search for)?

[Zelda-King]

Handy hack! I'm getting a bug with the logging profile viewing: If logging profile views is enabled and the user views a profile, they get this error;

Fatal error: Cannot redeclare vbflush() (previously declared in /home/etcetc/inferno/engine/system_handlers/vBulletin/global.php:516) in /home/etcetc/forums/httpdocs/includes/adminfunctions.php on line 3383

I realise that's clashing with the RPG Inferno hack so I make no comment about that but you might want to check with the adminfunctions.php script.

[Hornstar]

just wondering, how much extra load could this put onto a already fairly heavy server?

Does it use many queries? is it optimized to be suitable for big boards?

Thanks.

[Kaycee123]

These are probably dumb questions since everyone else seems to have figured it out, but I've installed this, set it to log everything and set up a new forum for the logging threads to be created in.

What do I put under Posting User ID - what does that mean?

And where it says Record all log-outs to thread ID# - what do I put there (same for Record Profile views?)

No threads have been created in the forum even though the members we want to watch have been on and off our forum all day, so I obviously don't have something set correctly!!

Any help would be appreciated, thanks!!

[mooky]

GREAT mod.

MOTM