Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 8:09 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
PostPosted: Sun Sep 13, 2009 5:42 am 
Offline
Contributor

Joined: Fri Jul 04, 2008 6:46 am
Posts: 153
Location: USA - WI
I've created several custom tables in my OA database. Some have a timestamp field, as it's convenient to reference the creation date of that row. One kinda annoying thing though is having to edit the ConvertSpecialField function to add that field name so that it formats it properly if I ever want to use a view definition on that table.

I think an easy way to fix this would be to be able to add an array value to that field to specify it's a timestamp, such as ...

[code]
"80"=>array("name"=>"system_timestamp",
"timestamp"=>"y",
"head"=>__("Date Audited"),
"show"=>$show_date_audited,
),
[/code]

This would remove quite a bit from the switch in ConvertSpecialField, and it would allow people easier customization. Of course, it probably wouldn't be very fun to go back and change every view definition if a change like this was made :p

Anyways, just a suggestion.

_________________
OA Server: Debian Squeeze w/ Apache2
Auditing: 700 Workstations, 250 or so Retail Terminals, about 75 Servers
OS's: Windows XP/2003/2008/2008 R2/Vista/7, Debian
LDAP: Active Directory 2008 R2


Top
 Profile  
Reply with quote  
PostPosted: Mon Sep 14, 2009 7:59 pm 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Perhaps a better fix would be to ensure that all times are kept in the same format, (see.. http://dev.mysql.com/doc/refman/5.1/en/ ... tions.html) regarless of where they come from. This would require a little more work, since there are several different sources. It would however make date/time comparisons a whole lot easier. We would also need to set a timezone and date format in the setup, or (less flexibly) set it from the web host settings.

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group