Trace and log user actions...

This hack was requested by ossi69 and John Mac.

This is a pretty simple hack that allows you to track and document a user's
actions while they are logged into your board. Every click made by the user
makes a brand new entry in a log file. The log file entries include, username,
IP address, date and time, and the URL clicked on. The user actions are
documented even before the user has a chance to see the page he clicked on.

Templates affected by this hack: none
Tables affected by this hack: user
Files affected by this hack: global.php, admin/user.php

Execute the following query to create a new field in the user table:

alter table user add trace smallint(5) unsigned DEFAULT 0 NOT NULL;

You also need to create a brand new directory in your forums directory by
the name of tracelog. You need to make sure that your give the appropriate\
read/write permissions to this directory so that the http server on your
host can create files in there.

Here is a sample output:

Zed, 192.168.1.101 , 2003-04-28 18:31:30, /forums/index.php
Zed, 192.168.1.101 , 2003-04-28 18:31:36, /forums/forumdisplay.php?forumid=9
Zed, 192.168.1.101 , 2003-04-28 18:31:42, /forums/showthread.php?threadid=143901
Zed, 192.168.1.101 , 2003-04-28 18:31:51, /forums/rules.php
Zed, 192.168.1.101 , 2003-04-28 18:31:53, /forums/forumdisplay.php?forumid=9
Zed, 192.168.1.101 , 2003-04-28 18:32:07, /forums/showthread.php?threadid=143901
Zed, 192.168.1.101 , 2003-04-28 18:32:11, /forums/index.php
Zed, 192.168.1.101 , 2003-04-28 18:32:15, /forums/forumdisplay.php?forumid=103
Zed, 192.168.1.101 , 2003-04-28 18:32:28, /forums/showthread.php?threadid=225576
Zed, 192.168.1.101 , 2003-04-28 18:32:38, /forums/member.php?action=getinfo&userid=4112

Note:Go to this post to download the directory protection file for this hack.

[subu1]

hi very nice hack but i have a error in my global.php

Warning: Unable to access ./admin/config.php in /home/virtual/site1/fst/var/www/html/board/admin/global.php on line 116

on Line 116 is:

require('./admin/config.php');

what can i do, just i don't have permission to ACP Control,too

[subu1]

ups, i must have forum/global.php, but now ich have this if i click on my link "No users found matching those criteria.
"

ok i have 2.2.8 and on my ftp i gave tracelog 777

[owc]

Hi, I need your help MAN I downloaded the trace hack but I could not get the logs .. all I got was this table from the index.php


I have done every thing

I alted user table
1-`trace` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL
2- I created a dirctoy tracelog and and changed the mode t0 777
3-made the changes to global.php and admin/user.php
4-and the only thing I got when acess the tracelog dirctory is

Filename Size Last Modified Last Accessed
. 4096 May 15, 2003, 18:09 May 15, 2003, 18:09
.. 4096 May 15, 2003, 16:44 May 15, 2003, 18:02
index.php 1082 May 15, 2003, 18:09 May 15, 2003, 18:09

when I type

forums/tracelog/username.log
I have this page is not found error


Can you help getting the user logs work with vb 2.3.0 becuse this hack would help me in a study I am condcuting .. thanks in advance

[Zzed]

I sent you a PM.

[gwhooooey]

Execute the following query to create a new field in the user table:

alter table user add trace smallint(5) unsigned DEFAULT 0 NOT NULL;

I couldn't get that to work, any help?

[zefman]

05-18-03 at 06:07 PM gwhooooey said this in Post #45
Execute the following query to create a new field in the user table:

alter table user add trace smallint(5) unsigned DEFAULT 0 NOT NULL;


I couldn't get that to work, any help?

hello !

try this

alter table `user` add `trace` smallint(5) unsigned DEFAULT "0" NOT NULL;

great hack thanks

[gwhooooey]

Thanks, that worked

[paratek]

I have one glitch. If i am adding a user manually from the admin CP, the trace user option is there for me to select. If i edit a current user to try and select this particular user to trace, the option isn't there.

Any ideas?

[Zzed]

You installed the hack in the wrong section. The add user and edit user code look almost identical.

The values for new users is set to 0 (No) by default.

[Intex]

Nice hack. Works great !

/me clicks install.