• possible datestr() bug in a47

    From Clive Reuben@2:250/6 to g00r00 on Sun Jan 9 20:55:21 2022
    Hey g00r00, Admittedly, I'm only a few months into Mystic dev, but I did confirm with another sysop that DateSTR(UserLastOn,1) does produce some odd results... can you possibly take a look when you get a chance? Thanks!

    btw really love the flexibility of Mystic... I looked at a few others and it was definitely the best of the lot...

    --- Mystic BBS v1.12 A46 2020/08/26 (Windows/32)
    * Origin: TALIADON BBS (2:250/6)
  • From Shaun Buzza@1:229/110 to Clive Reuben on Sun Jan 9 16:05:49 2022
    btw really love the flexibility of Mystic... I looked at a few others
    and it was definitely the best of the lot...

    I feel you there, TALIDON! For me, working on a Pi, there were very few
    options for BBS systems. And, as you said, Mystic was the best choice.

    Easy to install, easy to get up and running. And I am so very happy that my Pascal training won't go to waste, as MPL is almost the same!

    McDoob
    SysOp, PiBBS
    pibbs.sytes.net

    --- Mystic BBS v1.12 A46 2020/08/26 (Raspberry Pi/32)
    * Origin: PiBBS (1:229/110)
  • From g00r00@1:129/215 to Clive Reuben on Mon Jan 10 11:23:01 2022
    Hey g00r00, Admittedly, I'm only a few months into Mystic dev, but I did confirm with another sysop that DateSTR(UserLastOn,1) does produce some odd results... can you possibly take a look when you get a chance?

    DateStr uses a DOS format timestamp. Are you sending it a DOS format or Unix format?

    ... Oxymoron: Race walking

    --- Mystic BBS v1.12 A48 2022/01/07 (Windows/32)
    * Origin: Sector 7 * Mystic WHQ (1:129/215)
  • From Clive Reuben@2:250/6 to g00r00 on Tue Jan 11 02:56:48 2022
    On 10 Jan 2022, g00r00 said the following...

    DateStr uses a DOS format timestamp. Are you sending it a DOS format or Unix format?

    This is actually just from the 'bulls' mod for bulletins that's floating around:

    if UserLastOn <= GetFileDate(Entry.Bullfile) then S:='[NEW]'
    if UserLastOn > GetFileDate(Entry.Bullfile) then S:=' '

    I'm just putting the DateStr() around the UserLastOn to see why it's not working... I am running Mystic on linux/rpi... is there something I need to configure? Thanks, for your help!

    --- Mystic BBS v1.12 A46 2020/08/26 (Windows/32)
    * Origin: TALIADON BBS (2:250/6)
  • From LEE WESTLAKE@2:250/6 to g00r00 on Tue Jan 11 15:49:41 2022
    DateStr uses a DOS format timestamp. Are you sending it a DOS format or Unix format?

    I could be wrong, but I'm sure 'USERLASTON' returned a unix timestamp when I tested it on A46 (Win32) recently.

    o-----------o------------o-------------------------o
    TALIADON | 2:250/6 | 21:3/138 | TALIADON-BBS@MAIL.COM | o-----------o-----------o------------o-------------------------o
    | "Error is a great teacher, and humility its hardest lesson." | o--------------------------------------------------------------o

    --- Mystic BBS v1.12 A46 2020/08/26 (Windows/32)
    * Origin: TALIADON BBS (2:250/6)
  • From g00r00@1:129/215 to Clive Reuben on Tue Jan 11 11:39:07 2022
    This is actually just from the 'bulls' mod for bulletins that's floating around:

    if UserLastOn <= GetFileDate(Entry.Bullfile) then S:='[NEW]'
    if UserLastOn > GetFileDate(Entry.Bullfile) then S:=' '

    I'm just putting the DateStr() around the UserLastOn to see why it's not working... I am running Mystic on linux/rpi... is there something I need to configure? Thanks, for your help!

    UserLastOn is a Unix format date and DateStr is for DOS format dates. You could convert it from a Unix DOS though using the DateU2D conversion function:

    DateStr(DateU2D(UserLastOn)...

    ... If you choose not to decide, you still have made a choice

    --- Mystic BBS v1.12 A48 2022/01/10 (Windows/64)
    * Origin: Sector 7 * Mystic WHQ (1:129/215)
  • From LEE WESTLAKE@2:250/6 to g00r00 on Tue Jan 11 18:46:25 2022
    UserLastOn is a Unix format date and DateStr is for DOS format dates.
    You could convert it from a Unix DOS though using the DateU2D conversion function:

    DateStr(DateU2D(UserLastOn)...

    In fairness to Clive, the version of documentation (mpl_112a36.doc) he and I are working from explicitly state 'DateStr' & 'TimeStr' should be used to decode/format both USERFIRSTON & USERLASTON timestamps.

    Perhaps later revisions of this document have updated information regarding these functions?

    o-----------o------------o-------------------------o
    TALIADON | 2:250/6 | 21:3/138 | TALIADON-BBS@MAIL.COM | o-----------o-----------o------------o-------------------------o
    | "Error is a great teacher, and humility its hardest lesson." | o--------------------------------------------------------------o

    --- Mystic BBS v1.12 A46 2020/08/26 (Windows/32)
    * Origin: TALIADON BBS (2:250/6)
  • From g00r00@1:129/215 to LEE WESTLAKE on Tue Jan 11 14:06:58 2022
    In fairness to Clive, the version of documentation (mpl_112a36.doc) he
    and I are working from explicitly state 'DateStr' & 'TimeStr' should be used to decode/format both USERFIRSTON & USERLASTON timestamps.

    Its noted in the whatsnew file for 1.12 (A39) release but probably not anywhere else at the moment:

    + Record data changes for user database:
    - First on and last on dates are now stored in Unix timestamp format.
    - Expire, last password change, and last e-mail validation dates now use julian day number

    In general the idea is to remove the old DOS format date stamps whenever any structural changes are done to records that still use them. They are still all over the place though, as the structures change rarely.

    --- Mystic BBS v1.12 A48 2022/01/10 (Windows/64)
    * Origin: Sector 7 * Mystic WHQ (1:129/215)
  • From Clive Reuben@2:250/6 to g00r00 on Tue Jan 11 20:45:38 2022
    On 11 Jan 2022, g00r00 said the following...
    UserLastOn is a Unix format date and DateStr is for DOS format dates.
    You could convert it from a Unix DOS though using the DateU2D conversion function:

    DateStr(DateU2D(UserLastOn)...

    Thanks, g00r00! will give that a try...

    --- Mystic BBS v1.12 A46 2020/08/26 (Windows/32)
    * Origin: TALIADON BBS (2:250/6)
  • From LEE WESTLAKE@2:250/6 to g00r00 on Wed Jan 12 13:20:05 2022
    Its noted in the whatsnew file for 1.12 (A39) release but probably not anywhere

    else at the moment:

    + Record data changes for user database:
    - First on and last on dates are now stored in Unix timestamp format.
    - Expire, last password change, and last e-mail validation dates now
    use

    julian day number

    In general the idea is to remove the old DOS format date stamps whenever any structural changes are done to records that still use them. They
    are still all over the place though, as the structures change rarely.

    Thanks g00r00. I appreciate your taking the time to clarify.

    o-----------o------------o-------------------------o
    TALIADON | 2:250/6 | 21:3/138 | TALIADON-BBS@MAIL.COM | o-----------o-----------o------------o-------------------------o
    | "Error is a great teacher, and humility its hardest lesson." | o--------------------------------------------------------------o

    --- Mystic BBS v1.12 A46 2020/08/26 (Windows/32)
    * Origin: TALIADON BBS (2:250/6)