Hi Marcus,
Thank you for showing interest in our plugin.
If I am not mistaken, WordPress does not provide such functionality and we get the time from WordPress. Will double check to be sure and if it is available we will add it to the feature list.
If I may ask, why do you need such an accurate time stamp?
Looking forward to hearing from you.
We’re looking at the possibility of using your plugin to satisfy some UK government requirements for audit logging on a site. The logs of important events like logins will be collected straight from the database.
Having spoken to the company providing the log collection software, millisecond accuracy isn’t as necessary as I thought, since they can use the EventNumber field to guarantee no log messages are missed by their collector. So it isn’t a strict requirement for us after all.
Still, an event time stored in date/time format is potentially subject to issues with time zones, incorrectly set clocks etc. So for reliable timekeeping, a raw timestamp seems like a good idea. You can get PHP’s highest accuracy with the microtime function. On my machine here it’s only accurate down to about 0.1 milliseconds rather than the promised microseconds, but that’s as good as it gets. It’s well supported across platforms since PHP 4.
Hi Marcus,
First of all I am really happy to hear that you might be using our plugin in such scenarios. As regards your requirement though I will definitely look into it and I already added it to the feature list.
In the meantime, if you have any further queries etc, do not hesitate to drop us an email on plugins@wpwhitesecurity.com.
Thank you and have a great day.
Hi Marcus,
It has been quite some time since you posted this feature request though thought of letting you know that WP Security Audit Log is now reporting milliseconds for each alert.
Should you have any further queries or suggestions, do not hesitate to get in touch!
That’s good to know, thanks. Has it changed the database format?
I noticed that the database format changed a few times since we started using this plugin. Are there plans to change it further? It would be good to stabilise, so that external tools can read the database reliably.
Hi Marcus,
Yes the database structure changed again in version 1. I know we changed the database structure a couple of times and the reason is because we were still learning about the plugin and how it will work on large websites. Sorry if this created any inconvenience.
Now we are very confident with the existing database structure and we do not see ourselves changing the database structure again.
In the meantime if you integrated our plugin with other third party tools we would love to hear about such scenarios, maybe we can document them for others to learn from. If you need any further information on the existing database structure do not hesitate to get in touch by dropping us an email on plugins@wpwhitesecurity.com.
As for the rest, thank you for using our plugin and we would appreciate if you can rate and review WP Security Audit Log.
Thanks a lot.
