SearchSearch   ProfileProfile   Log inLog in   RegisterRegister 

Database: fsusr table - reserved2 field

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    FirstSpot Forum Index -> Pre-sales Support Forum
View previous topic :: View next topic  
Author Message
TRACSYSTEMS



Joined: 13 Feb 2007
Posts: 22
Location: Dallas, TX

PostPosted: Wed Mar 14, 2007 3:04 am    
Post subject: Database: fsusr table - reserved2 field

It appears that a user login time is stored in the fsusr table, in the reserved2 field. In my testing this seems to consistently be a 10 digit number. I need to know how to convert this to a readable date format so that I can calculate via database queries and logic how long a user has been logged in. I realize this functionality is included/visible in the Status section of the FirstSpot Configuration Manager, but the features that my clients require (primarily libraries, higher education, as well as corporations) currently necessitate additional programming and development on my part.
_________________
Steven E.
TRACSYSTEMS, inc.
Back to top
alan
Forum facilitator


Joined: 26 Sep 2003
Posts: 4435

PostPosted: Thu Mar 15, 2007 3:18 am    
Post subject:

Please check out http://www.patronsoft.com/forum/viewtopic.php?t=1192
_________________
~ Patronsoft Limited ~
Back to top
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.    FirstSpot Forum Index -> Pre-sales Support Forum All times are GMT
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group