Hi all -ããI've been updating the command shell on my BBS (written in JavaScript) so thatãin the message sub-board listings (i.e., when the user wants to jump to a newãsub-board), it will display the date & time of the newest message along withãthe sub-board name and number of messages for each sub-board. However, I'veãnoticed something that may complicate that a bit - The last message posted in aãsub-board might not necessarily be the newest message, according to itsãtimestamp. In QWK-networked sub-boards, I'd guess that this may be due to aãdelayed posting or because of QWK accounts being in different time zones.ããIn my command shell, I could get the dates & times for all the messages in aãsub-board, sort them, and choose the latest date & time that way, but that canãbe slow. Alternatively, I can simply get the date & time of the last messageãposted in the sub-board. Is there a better way to get the latest date & timeãof a message that is still fast?ããAs far as the message timestamps, is it true that all messages (even inãQWK-networked sub-boards) have a timestamp in the local time zone of theãoriginating BBS?ããNightfoxãã---ã þ Synchronet þ Digital Distortion BBS: digdist.bbsindex.comã

Re: Latest message timestampsã By: Nightfox to All on Mon Dec 07 2009 04:29 pmãã > Hi all -ã >ã > I've been updating the command shell on my BBS (written in JavaScript) soã > that in the message sub-board listings (i.e., when the user wants to jumpã > to a new sub-board), it will display the date & time of the newest messageã > along with the sub-board name and number of messages for each sub-board.ã > However, I've noticed something that may complicate that a bit - The lastã > message posted in a sub-board might not necessarily be the newest message,ã > according to its timestamp. In QWK-networked sub-boards, I'd guess thatã > this may be due to a delayed posting or because of QWK accounts being inã > different time zones.ã >ã > In my command shell, I could get the dates & times for all the messages inã > a sub-board, sort them, and choose the latest date & time that way, butã > that can be slow. Alternatively, I can simply get the date & time of theã > last message posted in the sub-board. Is there a better way to get theã > latest date & time of a message that is still fast?ããUse the "when_imported_time" of the last message in the sub-board. That shouldãalways be the newest date/time.ãã > As far as the message timestamps, is it true that all messages (even inã > QWK-networked sub-boards) have a timestamp in the local time zone of theã > originating BBS?ããThe times are stored in UTC. If you wish to know the time zone of when aãmessage was written, check the "when_written_zone" header property value. Theã"when_written_time" is stored in UTC, but represents the local time in the timeãzone where the message was written (not necessarily the local time zone).ãã digital manããSnapple "Real Fact" #180:ãThe first VCR was made in 1956 and was the size of a piano. ã---ã þ Synchronet þ Vertrauen þ Home of Synchronet þ [vert/cvs/bbs].synchro.netã

Re: Latest message timestampsã By: Digital Man to Nightfox on Mon Dec 07 2009 21:57:51ãã > > Use the "when_imported_time" of the last message in the sub-board. That sã > > always be the newest date/time.ã > > ãã > > The times are stored in UTC. If you wish to know the time zone of when aã > > message was written, check the "when_written_zone" header property value.ã > > "when_written_time" is stored in UTC, but represents the local time in thã > > zone where the message was written (not necessarily the local time zone).ããThanks.ããNightfoxãã---ã þ Synchronet þ Digital Distortion BBS: digdist.bbsindex.comã

On 12/7/2009 5:29 PM, Nightfox wrote:ã> As far as the message timestamps, is it true that all messages (even inã> QWK-networked sub-boards) have a timestamp in the local time zone of theã> originating BBS?ããYeah, the date-time for networked messages will be in local time from where ãthey are posted, with no reliable internationalization. Your best bet is to ãcheck the filesystem date/time for the board in question. You can then simply ãshow a "Last Update/Post: yyyy-MM-dd HH:mm" based on the FS's date time.ãã-- ãMichael J. Ryan - http://tracker1.info/ãã---ã þ Synchronet þ Roughneck BBS - telnet://roughneckbbs.com - www.roughneckbbs.comã

Re: Re: Latest message timestampsã By: Tracker1 to Nightfox on Fri Dec 11 2009 20:11:24ãã > > Yeah, the date-time for networked messages will be in local time from wheã > > they are posted, with no reliable internationalization. Your best bet isã > > check the filesystem date/time for the board in question. You can then sã > > show a "Last Update/Post: yyyy-MM-dd HH:mm" based on the FS's date time.ããThat would probably work.. Per the suggestion from Digital Man, I used theãwhen_imported_time property of the message header, which seems to workãreasonably well.ããNightfoxãã---ã þ Synchronet þ Digital Distortion BBS: digdist.bbsindex.comã