• Dynamic COntent and Database

    From ALEXANDRE FREIRE@1:124/5013 to All on Thu Jan 31 19:10:44 2019
    Date: Sun, 06 Mar 2005 16:40:25 -0400
    From: ALEXANDRE FREIRE
    To: ALL
    Subject: Dynamic COntent and Database
    Newsgroups: win.server.wish.list
    Message-ID: <1110145225.33.0@winserver.com>
    X-Mailer: Wildcat! Interactive Net Server v7.0.454.5
    Lines: 18

    Hello all,

    I would like to know if Santronics plans some kind of dynamic content to be used with WINS.. something like posting article with possibility to send article contents to user's e-mail and also a printed version of the article. Features like scheduling the article to be published on specific date / times. I think It would not be so hard for Santronics to implement this kind of feature to WINS. it would be nice to have this kind of feature implemented on the public default web page of WINS Server.

    Another question : How can I use WINS to work with Mysql or SQL Server database ? Is there any possibility to record, for example, the user database on a relational database system ?

    Thanks very much.
    Best Regards

    Alexandre Freire
    --- Platinum Xpress/Win/WINServer v3.1
    * Origin: Prison Board BBS Mesquite Tx //telnet.RDFIG.NET www. (1:124/5013)
  • From HECTOR SANTOS@1:124/5013 to All on Thu Jan 31 19:10:44 2019
    Date: Mon, 07 Mar 2005 12:22:22 -0400
    From: HECTOR SANTOS
    To: ALEXANDRE FREIRE
    Subject: Re: Dynamic COntent and Database
    Newsgroups: win.server.wish.list
    Message-ID: <1110216396.33.1110145225@winserver.com>
    References: <1110145225.33.0@winserver.com>
    X-WcMsg-Attr: Rcvd
    X-Mailer: Wildcat! Interactive Net Server v7.0.454.5
    Lines: 136

    Dynamic Content? Like Microsoft IIS's ASP?

    That is what WCT (Wildcat Templates) is all about.

    WCT is to Wildcat! Web Server what ASP is to Microsoft IIS Web Server.

    Very powerful stuff that helps you integrate the Wildcat! Macro and wcBASIC programmability.

    Your HTTP\TEMPLATE folder contains Wildcat HTML template files used for creating dynamic context for all the clients in Wildcat!, mail, file, chat, personal properties, etc.

    Outside the template folder, simply rename any HTM extension page to WCT,
    like:

    default.htm ---> default.wct

    and you have dynamic content.

    Of course, nothing is done until you actually add some WCT programmable
    stuff inside of it.

    See the WCT reference stuff at the Santronics Online Developer's Corner.

    Here is an example for what you are looking for:

    Note I am using the # character instead of the @ character so that they
    don't get processed in this message and I will be able to illustrate the
    logic:

    Using WCT Macros:

    #if DATE = "03/05/2005"#
    #include articles/article-2005-03-05.htm#
    #elseif DATE = "03/06/2005"#
    #include articles/article-2005-03-06.htm#
    #endif#

    Put this where you want a "dynamic insert" of your dynamic content.

    This allows you to use the IF command with the DATE macro to check for
    specific dated files.

    The date format mm/dd/yyyy above happens to be the default format on my
    Windows machine (Regional Settings in Windows Control Panel).

    If I changed the Windows default date format to yyyy-mm-dd, then the above
    WCT code can be changed one single line:

    #existinclude "articles\article-"+DATE+".htm"#

    The ExistInclude macro means

    "If the file exist, include in the display, otherwise continue with no warning message"

    if you used the INCLUDE macro, then you will see a "warning" in the display saying the file does not exist, if not found.

    I can see now that we should improve the DATE macro so that a WCT programmer can specify which part of the date or time he wants.

    For example, if we had:

    DATE.YEAR
    DATE.MONTH
    DATE.DAY
    TIME.HOUR
    TIME.MINUTE
    TIME.SECOND

    Then you have more flexibility to do various date and/or time formatted file names.

    We currently don't have the above so I will consider it for an update.

    But if you wanted to have the full power and flexibility than you will use
    WCX progamming which is what most people do to add custom dynamic content specific to their likens

    For example:

    #RunWCX html-MyArticles#

    Put this where you want a "dynamic insert" of your dynamic content. This
    will run a server-side program called html-MyArticles.wcx

    Since its a WCX you have the full programming power of the wcBASIC language
    and you can have the WCX spit out anything you like.

    For SQL related stuff, WCODBC is used using the standard SQL ODBC interface. There is an full working "Shopping cart" example demo of this in the Developer's corner

    Finally, the Wildcat! User Database is internal to Wildcat! and it is accessable via WCT Macros and WCX programming.. It is not 3rd party based
    for good reason:

    We can't depend on anyone but ourselves:

    - For controlling the market place (you don't need SQL),
    - For controlling the future of the product,
    - For controlling the security and the integrity of the system, and
    - For speed and scalability reasons.

    Hope this helps :-)




    <ALEXANDRE FREIRE> wrote in message news:1110145225.33.0@winserver.com...
    Hello all,

    I would like to know if Santronics plans some kind of dynamic content to
    be
    used with WINS.. something like posting article with possibility to send article contents to user's e-mail and also a printed version of the
    article.
    Features like scheduling the article to be published on specific date /
    times.
    I think It would not be so hard for Santronics to implement this kind of feature to WINS. it would be nice to have this kind of feature
    implemented on
    the public default web page of WINS Server.

    Another question : How can I use WINS to work with Mysql or SQL Server database ? Is there any possibility to record, for example, the user
    database
    on a relational database system ?

    Thanks very much.
    Best Regards

    Alexandre Freire
    --- Platinum Xpress/Win/WINServer v3.1
    * Origin: Prison Board BBS Mesquite Tx //telnet.RDFIG.NET www. (1:124/5013)
  • From SHANNON TALLEY@1:124/5013 to All on Thu Jan 31 19:10:44 2019
    Date: Mon, 07 Mar 2005 17:32:12 -0400
    From: SHANNON TALLEY
    To: ALEXANDRE FREIRE
    Subject: Re: Dynamic COntent and Database
    Newsgroups: win.server.wish.list
    Message-ID: <1110234718.33.1110145225@winserver.com>
    References: <1110145225.33.0@winserver.com>
    X-WcMsg-Attr: Rcvd
    X-Mailer: Wildcat! Interactive Net Server v7.0.454.5
    Lines: 35

    Hi Alexandre,

    The "only" thing I use MySQL for is to run external (canned) applications -- mostly just games. Legend of the green dragon is one of them (www.fidotel.com/lotgd). It utilizes a MySQL database to run (as well as PHP).

    Shannon

    <ALEXANDRE FREIRE> wrote in message news:1110145225.33.0@winserver.com...
    Hello all,

    I would like to know if Santronics plans some kind of dynamic content to
    be
    used with WINS.. something like posting article with possibility to send article contents to user's e-mail and also a printed version of the
    article.
    Features like scheduling the article to be published on specific date / times.
    I think It would not be so hard for Santronics to implement this kind of feature to WINS. it would be nice to have this kind of feature
    implemented on
    the public default web page of WINS Server.

    Another question : How can I use WINS to work with Mysql or SQL Server database ? Is there any possibility to record, for example, the user database
    on a relational database system ?

    Thanks very much.
    Best Regards

    Alexandre Freire

    --- Platinum Xpress/Win/WINServer v3.1
    * Origin: Prison Board BBS Mesquite Tx //telnet.RDFIG.NET www. (1:124/5013)
  • From hector.santos@winserver.com@1:124/5013 to All on Thu Jan 31 19:10:44 2019
    Date: Tue, 08 Mar 2005 02:42:16 -0400
    From: "HECTOR SANTOS" <hector.santos@winserver.com>
    To: ALEXANDRE FREIRE
    Subject: Re: Dynamic COntent and Database
    Newsgroups: win.server.wish.list
    Message-ID: <1110267990.33.1110145225@winserver.com>
    References: <1110145225.33.0@winserver.com>
    X-WcMsg-Attr: Rcvd
    X-Mailer: Wildcat! Interactive Net Server v7.0.454.5
    Lines: 59

    Alexandre:

    This is a follow up to announce the next pending update (AUP 451.4) will now support new DATE.XXXX sub values for the WCT DATE macro:

    New DATE sub value macros

    DATE.YEAR
    DATE.MONTH
    DATE.DAY
    DATE.HOUR
    DATE.MINUTE
    DATE.SECOND
    DATE.MILLISECONDS
    DATE.DAYNUMBER # of days since 1970
    DATE.TIMENUMBER # of seconds in the current day
    DATE.DAYOFWEEK Sun=0, Mon=1,,, SAT=6

    This takes the same layout as the wcBASIC DATETIME structure which allows
    you to extract the same sub fields like above.

    Note: We already had a DAYOFWEEK macro, but this macro spits out the literal i.e, "Monday" rather than the index number DATE.DAYOFWEEK spits out.

    Although already possible, I think this will allow for a easier set of new poweful WCT programming capabilities to produce intelligent scheduled base dynamic content.

    Thanks for creating the synergy to make it happen in the wish-list forum.
    :-)

    Hector


    <ALEXANDRE FREIRE> wrote in message news:1110145225.33.0@winserver.com...
    Hello all,

    I would like to know if Santronics plans some kind of dynamic content to
    be
    used with WINS.. something like posting article with possibility to send article contents to user's e-mail and also a printed version of the
    article.
    Features like scheduling the article to be published on specific date /
    times.
    I think It would not be so hard for Santronics to implement this kind of feature to WINS. it would be nice to have this kind of feature
    implemented on
    the public default web page of WINS Server.

    Another question : How can I use WINS to work with Mysql or SQL Server database ? Is there any possibility to record, for example, the user
    database
    on a relational database system ?

    Thanks very much.
    Best Regards

    Alexandre Freire
    --- Platinum Xpress/Win/WINServer v3.1
    * Origin: Prison Board BBS Mesquite Tx //telnet.RDFIG.NET www. (1:124/5013)
  • From CHRIS CRANFORD@1:124/5013 to All on Thu Jan 31 19:10:44 2019
    Date: Fri, 11 Mar 2005 03:41:24 -0400
    From: CHRIS CRANFORD
    To: HECTOR SANTOS
    Subject: Re: Dynamic COntent and Database
    Newsgroups: win.server.wish.list
    Message-ID: <1110530484.33.1110267990@winserver.com>
    References: <1110267990.33.1110145225@winserver.com>
    X-WcMsg-Attr: Rcvd
    X-Mailer: Wildcat! Interactive Net Server v7.0.454.5
    Lines: 26

    This is a follow up to announce the next pending update (AUP 451.4) will now support new DATE.XXXX sub values for the WCT DATE macro:

    New DATE sub value macros

    DATE.YEAR
    DATE.MONTH
    DATE.DAY
    DATE.HOUR
    DATE.MINUTE
    DATE.SECOND
    DATE.MILLISECONDS
    DATE.DAYNUMBER # of days since 1970
    DATE.TIMENUMBER # of seconds in the current day
    DATE.DAYOFWEEK Sun=0, Mon=1,,, SAT=6

    Hey man, these are great to now have. Just saw the post and wanted to
    comment. I know we had some discussion in the past about timezone.
    Since the date macro is returning date and time elements, would it be
    helpful to have it return the timezone abbreviation in some manor such
    as either 'EST' or 'EDT' too ?? Just a thought. I know you are
    planning to release this to pre-gamma monday. Just wanted to put this
    on the plate for a future consideration if so.

    Thanks
    Chris
    --- Platinum Xpress/Win/WINServer v3.1
    * Origin: Prison Board BBS Mesquite Tx //telnet.RDFIG.NET www. (1:124/5013)
  • From HECTOR SANTOS@1:124/5013 to All on Thu Jan 31 19:10:44 2019
    Date: Sat, 12 Mar 2005 20:45:24 -0400
    From: HECTOR SANTOS
    To: CHRIS CRANFORD
    Subject: Re: Dynamic COntent and Database
    Newsgroups: win.server.wish.list
    Message-ID: <1110678681.33.1110530484@winserver.com>
    References: <1110530484.33.1110267990@winserver.com>
    X-WcMsg-Attr: Rcvd
    X-Mailer: Wildcat! Interactive Net Server v7.0.454.5
    Lines: 65

    Since the dates are 100% on server-side locality and all functionality that
    I can see would based on local time, I don't think GMT applies or is
    necessary.

    Based on experience across the board, for something like this, it would make
    it more "difficult" for you (sysop, web master) to develop time logic based
    on GMT.

    There only place I see GMT would be required is where you are doing some logical time comparison based on the user's side.

    Do you have an example where GMT applies?

    In any case, there is GMT based macros in WCT. The #GETTIME# macro (see
    new WCT macros added for 451.3 in AUP.CHM) is the same used by the
    JavaScript "getTime()" function. It was added so you can get the GMT
    timestamp on the server side. Not the local side which the JavaScript
    function provides.

    Which brings up a very important point. Using Javascript is another way to
    do this of this related work, in both GMT and in the non-GMT local side (browser) time reference.

    Just remember this very important distinction:

    Client vs Server-Side Scripting.

    JavaScript is run on the browser (Client Side Scripting), after the WEB
    Server sends the page.

    WCT is run on the web server (Server Side Scripting) as the server reads, processes, and generates the page from the template and pushes the final
    output to the browser.


    <CHRIS CRANFORD> wrote in message news:1110530484.33.1110267990@winserver.com...
    This is a follow up to announce the next pending update (AUP 451.4)
    will now
    support new DATE.XXXX sub values for the WCT DATE macro:

    New DATE sub value macros

    DATE.YEAR
    DATE.MONTH
    DATE.DAY
    DATE.HOUR
    DATE.MINUTE
    DATE.SECOND
    DATE.MILLISECONDS
    DATE.DAYNUMBER # of days since 1970
    DATE.TIMENUMBER # of seconds in the current day
    DATE.DAYOFWEEK Sun=0, Mon=1,,, SAT=6

    Hey man, these are great to now have. Just saw the post and wanted to comment. I know we had some discussion in the past about timezone.
    Since the date macro is returning date and time elements, would it be
    helpful to have it return the timezone abbreviation in some manor such
    as either 'EST' or 'EDT' too ?? Just a thought. I know you are
    planning to release this to pre-gamma monday. Just wanted to put this
    on the plate for a future consideration if so.

    Thanks
    Chris
    --- Platinum Xpress/Win/WINServer v3.1
    * Origin: Prison Board BBS Mesquite Tx //telnet.RDFIG.NET www. (1:124/5013)