The way in which it is possible to determine who changed a record is very dependant upon the structure of the specific table. Some Joomla tables possess specific fields to hold this information. These fields are typically named 'created_by' and 'modified_by'. If a table has these fields, which can be determined from inspection of the drop down columns when the trigger is created, it is advantageous to select these columns along with other monitors columns to capture the information they contain.
Another mechanism used by some Joomla table is the 'checked_out' field. When present, when a table is modified the table is first 'checked out' when the record is changed and then 'checked in' when the record is saved.
Note | |
---|---|
When a Joomla table makes use of the checkin/checkout feature additional records will be created in the change history table if these columns are monitored. The reason is that immediately before an record is edited, the record is 'checked out' from the database this triggering a record change. The user then edits the record and saves the result, triggering another database change record being created. Then Joomla itself performs a 'check in' operation in turn triggering another record being created in the change history table. |
Important | |
---|---|
Some Joomla tables do not contain any information that enables an easy way to determine who has made a change. Attempts to determine whether a link exists between the information contained within the Joomla session table and the database (MySQL) session information has not indicated that the information is stored in a conveniently accessible manner. |