Login   Register  
PHP Classes
elePHPant
Icontem

File: guide/ordit/installation.md

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Stefan Jibrail Froelich  >  Ordit Kohana ORM Audit  >  guide/ordit/installation.md  >  Download  
File: guide/ordit/installation.md
Role: Documentation
Content type: text/plain
Description: Documentation
Class: Ordit Kohana ORM Audit
Track calls to Kohana framework ORM classes
Author: By
Last change:
Date: 1 year ago
Size: 1,013 bytes
 

Contents

Class file image Download
# Setting up the database

You need to create a table in your database to hold all your logs.

A script is included in the module named `ordit_logs.sql`
The script is for a mysql database running the InnoDB engine.

The table is configured as follows:

	Table Name :: 
		`ordit_logs`
	Columns ::
		`id` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
		`model` CHAR(50) NOT NULL,
		`action` CHAR(7) NOT NULL,
		`values` TEXT NOT NULL,
		`user` CHAR(50) NOT NULL,
		`timestamp_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	
## Overriding the Ordit::get_username Method

In order to provide the current logged in user's username for auditing,
create a class in your classes folder named `Ordit` that extends the `Model_Ordit` class. 
Then override the `get_username` method to return the current logged in user's username. The example below uses
the default `Auth` module.

	class Ordit extends Model_Ordit
	{	
		protected function get_username()
		{
			return Auth::instance()->get_user()->username;
		}
	}