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)

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)

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)

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)

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)

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)