Thanks, that looks like what I am after.
On Oct 4, 7:11 am, "Meroe Kush" <whme...@gmail.com> wrote: > Have a look at this: > > http://bakery.cakephp.org/articles/alkemann/2008/10/21/logablebehavior > > > > > > > > -----Original Message----- > From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf > > Of elogic > Sent: Monday, October 03, 2011 5:07 PM > To: CakePHP > Subject: Re: history log table > > Thanks for the reply. > > Are you able to explain further or direct me to something online that > could help me out in getting this sorted? I'm just starting with > cakephp. > > Thankyou > > On Oct 3, 7:59 pm, euromark <dereurom...@googlemail.com> wrote: > > you could write a method in the model or even a behavior which will do > > that for you > > in the beforeSave() callback it can be triggered globally > > > On 3 Okt., 06:38, elogic <asymo...@elogicmedia.com.au> wrote: > > > > My client wants a listing of all actions that happen within the system > > > so they can check back and search the records at a later date. > > > > I thought the best way to handle this would be to have a histories > > > table which would be similar to below: > > > > CREATE TABLE `histories` ( > > > `id` INT(11) NULL AUTO_INCREMENT, > > > `user_id` INT(11) NOT NULL DEFAULT '0', > > > `action` VARCHAR(50) NULL DEFAULT NULL, > > > `content` VARCHAR(250) NULL DEFAULT NULL, > > > `created` DATETIME NULL DEFAULT NULL, > > > `modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON > UPDATE > > > CURRENT_TIMESTAMP, > > > PRIMARY KEY (`id`), > > > INDEX `user_id` (`user_id`) > > > ) > > > > How would I go about inserting the user_id (the logged user - using > > > Auth), action (i.e. create, edit, delete, login etc) and content > > > (added joe blogs or deleted record ID123 etc) from every section > > > within the site? > > > > Thanks > > -- > Our newest site for the community: CakePHP Video > Tutorialshttp://tv.cakephp.org > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > others with their CakePHP related questions. > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > athttp://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
