Can someone make an Activity Log hack?

[mtha]

Originally Posted by Isotope

You know what I miss from the old-style BBS's? The activity logs! I would love it if someone made a Log system for vB 3.01!!!

I'm talking about something that would be completely date and time stamped and show the following stuff:


1. Logins

Username
User ID
Date
Time
IP Address
Alternate IP, if behind a proxy that indicates the IP behind it


2. Logoffs

Username
User ID
Date
Time
IP Address
Alternate IP, if behind a proxy that indicates the IP behind it
Indicate whether this was a Manual Logoff, or a Timed Out Session.


3. New Threads

Username
User ID
Date
Time
IP Address
Alternate IP, if behind a proxy that indicates the IP behind it
Thread ID
Thread Name
SubForum ID it was posted in
SubForum Name it was posted in


4. New Posts

Username
User ID
Date
Time
IP Address
Alternate IP, if behind a proxy that indicates the IP behind it
Thread ID
Thread Name
SubForum ID it was posted in
SubForum Name it was posted in
Post ID


5. Edited Posts

Username
User ID
Date
Time
IP Address
Alternate IP, if behind a proxy that indicates the IP behind it
Thread ID
Thread Name
SubForum ID it was posted in
SubForum Name it was posted in
Post ID

I'd love to see this hack to be released.

database structure would be:

TABLE activitylog

FIELD
activitylogid int(10)
userid int(10)
dateline int(10)
script varchar(250)
action varchar(250)
forumid int(10)
threadid int(10)
postid int(10)
extrainfo varchar(250)
ipaddress  varchar(25)
proxyipaddress varchar(25)
useragenr varchar(250)

This can work like adminlog, moderatorlog, or sessions

I sometime want to suspect some "to be watched" one, so if the log is too big (for big forums), I just want to log activity for some given userid (that given in config or somewhere)