Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

User_Registered - How Does the Date Work?

Quote Reply
User_Registered - How Does the Date Work?
On the user_registered field, how is the date converted to a 10 digit format? I am trying to finalize the trigger that will autopopulate this table, but haven't figured out the date yet, is this a third party app?

Also, this HTML editor above, is that a third party app inclusion or was it custom developed? It's pretty cool, would like to do something similar for our text fields.
Quote Reply
Re: [jbit30] User_Registered - How Does the Date Work? In reply to
The conversion is actually the other way around - all of the dates/times in GForum are stored as unix times - that is, seconds since Jan 1, 1970. If you're using Perl the time() function returns the current time in unix seconds. Most languages have some similar functionality. The unix times are converted upon displayed into human-readable date strings.

The HTML editor was custom developed; there were actually two versions. The first appeared in 1.1.0, and used built-in Internet Explorer functionality called the DHTML Edit Control. This was slow, and had several problems (the most annoying of which is an occasional "Please insert your MS Office CD" popup that comes up), so 1.1.1 included a revamped editor based on contenteditable functionality.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Post deleted by agaffin In reply to
Quote Reply
Re: [jbit30] User_Registered - How Does the Date Work? In reply to
htmlArea's a nice (and free) WYSIWYG editor that can be integrated with text fields. A cross-OS version for Mozilla is in beta (the stable version works only with IE on Windows).

http://www.interactivetools.com/products/htmlarea/