Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: Log / Free Host?

Quote Reply
Re: Log / Free Host? In reply to
1) For "logging", you can create another table called "Loggin" within your DBMAN database. This table should contain the following fields/columns:

In Reply To:

UserID (from the Users table or your main DBMAN table)
Action (record last query string or action)
IPAddress (IP Address of User)
HTTP_Referer (Log the last page visited)


And you can, of course, add other columns.

Then you can add a sub within the db.cgi that logs users. Shouldn't be hard to do...use the sub add_record routine as a model.

Then to keep the table clean, you could write a shell file to be executed by Crontab that deletes the table every few hours.

2) If all you want to do is develop an internal database for your own purposes, you can simply download DBI, MySQL, Perl for Win32 (ActiveState), and also a web server (apache, preferrably). For more info on "off-line" editing, search the support forums for offline editing.

Regards,

Eliot Lee
Subject Author Views Date
Thread Log / Free Host? Philip_Clark 2664 May 14, 2001, 2:30 PM
Thread Re: Log / Free Host?
Stealth 2563 May 14, 2001, 3:10 PM
Thread Re: Log / Free Host?
Philip_Clark 2539 May 14, 2001, 3:15 PM
Thread Re: Log / Free Host?
Stealth 2550 May 14, 2001, 6:45 PM
Post Re: Log / Free Host?
Philip_Clark 2549 May 14, 2001, 6:50 PM