eventLog Table - OrvilleChomer/PHP-mySQL-Message-Wall GitHub Wiki

This table is inserted into by the logEvent() function that resides in the pdf_connect.php file.

It logs various events that happen in the system. It (at least in my opinion) is better than your average text-based log file used on many web servers because you can do queries on it and it makes it easier to find stuff that you are looking for.

Event Type

These are codes I've made up for different types of events. Definitely something you can filter on.

Event Subject

Think of each event log entry as like an email with a Subject and a Body. The subject is basically a single line of text summarizing the event.

Event Details

This is all the details of the the event which is free-flowing text and can include HTML markup!

Event Timestamp

When the event occurred on the system. This is based on the database's current System Date at the time.

User Id

The Id of the user logged in when the event was triggered. Note that some events occur when a user is not logged in (such as a log on failure), in that case, the user id field will be set to zero (0).

IP Address

The I.P. Address of the user's device (or alleged I.P. Address)!

Alert Level

Sort of a security importance number. A level zero (0), would be for a msg post or a comment being added. A user related operation such as signing up, logging in, or updating user info (including the password) will have a higher value. Security related operations that fail will be logged with the highest alert level value.