Audit trail enhancements - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Development Discussion & Specification (http://www.weberp.org/forum/forumdisplay.php?fid=10) +--- Thread: Audit trail enhancements (/showthread.php?tid=2091) |
Audit trail enhancements - icedlava - 02-11-2014 Hi there, Some time ago I noticed that the audit trail only provided entries for insert, update and delete database transactions. A few other features were requested, with one main one being the ability to know when a user logs in. I was reminded of this change a few days ago and just wondered if it was of any interest here for the main repo. A small change at the moment but I intend to do further audit trail enhancements later. Cheers, RE: Audit trail enhancements - Forums - 02-11-2014 (02-11-2014, 12:20 AM)icedlava Wrote: Hi there, This could definitely use some work. As I remember I wrote this about 7 years ago in a couple of hours and apart from some changes by Ricard it hasn't been updated since. Thanks Tim RE: Audit trail enhancements - phil - 02-11-2014 The last login in date time is recorded against the www_users table ... but no log remains of user logins EDIT: Of course the update to www_users will be in the audit trail log too RE: Audit trail enhancements - Forums - 02-11-2014 Thanks for the compliments Phil, but I still feel it can be improved upon. The sql parsing is not bad, but is still only about 95%. There are dedicated open source sql parsers such as https://code.google.com/p/php-sql-parser/ which could improve the accuracy and the speed of the parsing. Tim RE: Audit trail enhancements - PakRicard - 02-12-2014 (02-11-2014, 12:20 AM)icedlava Wrote: Hi there, Hi Jo: I personally use the audit quite often, and ANY improvement on the functionality will be really welcomed. Count on me for tests :-) RE: Audit trail enhancements - kelo - 05-05-2014 hi.. i am added ip loggin script .. please see my thread http://www.weberp.org/forum/showthread.php?tid=2215 and please leave your comment or oppinion. |