Re: Databases.tpl
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30860
interpreted = N
texte = Here is a page from my OSX server, it will not work with NT, and I have never tested it on Webten / Webstar. Though I have adapted it for NT and I am sure it can be adapted for Webten / WebStar as well.BTW my folder names are the same as the domain names, that is essential to this script.******************Begin WebDNA Page ******************** [!]Use of this page or any code herein constitutes acceptance of Cybermill Copyright of such code. This page and code are free to use and alter provided this comment is not removed. ©2000 Cybermill Communications, St. Louis, Missouri[/!][!]this page has been tested on MacOSX, running webcatalog v3.05[/!][!]Protected for admin only[/!] [protect admin][showif [dbupdate]=T] [!]Showif you wish to update the status of this db[/!] [showif [commit]=T] [!]commit this database[/!] [commitdatabase [db]] [/showif] [closedatabase [db]] [/showif][!]Set Math Variables[/!] [math show=f]dbtotal=0;dbcount=0[/math][!]Set Text Variables[/!] [text multi=T]domain=[ListWords words=[GETMIMEHEADER HOST]&delimiters=.][hideif [word]=com][hideif [word]=www][word][/hideif][/hideif][/ListWords]&fulldomain=[GETMIMEHEADER HOST][/text]
[domain] WebCatalog Administration Currently-Open Databases on [fulldomain]
[!]Count up the databases and set the math variable[/!] [LISTDATABASES][showif [name]^[domain]][math show=f]dbtotal=dbtotal+1[/math][/showif][/LISTDATABASES]
Total Databases open:[dbtotal]
| Database Specs | Field Names |
|---|
[LISTDATABASES][!]Set math variables for this found set[/!] [math show=f]startval=0[/math][!]Set text variables for this found set[/!] [text]dbpath=[/text][!]Showif this db is in this domain[/!] [showif [name]^[domain]][!]Parse the path to the database[/!] [Listwords words=[name]&delimiters=/][showif [word]^[domain]][math show=f]startval=[index][/math][/showif][/Listwords] [Listwords words=[name]&delimiters=/][showif [index]>[startval]][text]dbpath=[dbpath][word]/[/text][/showif][/Listwords] [text]dbpath=[getchars start=2&from=end][dbpath][/getchars][/text]| [index] | [dbpath]
Flush Commit/Flush
[NUMRECORDS] records
[NUMFIELDS] fields | [ListFields path=[name]][FIELDNAME], [/ListFields] |
[!]/ showif this db is in this domain[/!] [/showif] [/LISTDATABASES]
©2000 Cybermill Communications
1-877-962-4024 ******************** End WebDNA Page ********************** Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.> From: Bob Minor
> Reply-To: (WebCatalog Talk) > Date: Tue, 25 Apr 2000 09:55:35 > To: (WebCatalog Talk) > Subject: Re: Databases.tpl > > Its fairly simple > > [showif [dbupdate]=T] > [commitdatabase [yourdb]] > [closedatabase [yourdb]] > [/showif] > > You could also do a list of all the db's that contain a sample of your > directory structure. I build this for local users so they can flush just > there own domains. ie > > > [text]thisdomain=mydomain.db[/text] > [!]Webcat can figure this out automatically[/!] > > [math show=f]dbcount=0[/math] > [LISTDATABASES][math show=f]dbtotal=[index][/math][/LISTDATABASES] > There are [dbtotal] databases closing. > [LISTDATABASES] > [!]depending on your platform you may have to parse the name to get the > database path correctly. Play with it, just displaying the path, to get what > you are looking for.[/!] > [showif [name]^[thisdomain]] > [commitdatabase [name]] > [closedatabase [name]] > [name] closed > [/showif] > [/LISTDATABASES] > > Robert Minor > Director of Internet Services > ------------------------------------------------------------ > Cybermill Communications > http://www.cybermill.com http://www.merchantmaker.com > > Providing Ecommerce and interactive website development and > hosting services on Macintosh, Windows NT, Unix, and AS/400. > >> From: Jesse Proudman >> Reply-To: (WebCatalog Talk) >> Date: Tue, 25 Apr 2000 07:29:25 >> To: (WebCatalog Talk) >> Subject: Databases.tpl >> >> It would be cool if on the administration database page, you could flush >> individual databases instead of them all. I tired to change the code to do >> that but I couldn't get it to work. :( > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Here is a page from my OSX server, it will not work with NT, and I have never tested it on Webten / Webstar. Though I have adapted it for NT and I am sure it can be adapted for Webten / WebStar as well.BTW my folder names are the same as the domain names, that is essential to this script.******************Begin WebDNA Page ******************** [!]Use of this page or any code herein constitutes acceptance of Cybermill Copyright of such code. This page and code are free to use and alter provided this comment is not removed. ©2000 Cybermill Communications, St. Louis, Missouri[/!][!]this page has been tested on MacOSX, running webcatalog v3.05[/!][!]Protected for admin only[/!] [protect admin][showif [dbupdate]=T] [!]Showif you wish to update the status of this db[/!] [showif [commit]=T] [!]commit this database[/!] [commitdatabase [db]] [/showif] [closedatabase [db]] [/showif][!]Set Math Variables[/!] [math show=f]dbtotal=0;dbcount=0[/math][!]Set Text Variables[/!] [text multi=T]domain=[ListWords words=[GETMIMEHEADER HOST]&delimiters=.][hideif [word]=com][hideif [word]=www][word][/hideif][/hideif][/ListWords]&fulldomain=[GETMIMEHEADER HOST][/text] [domain] WebCatalog Administration Currently-Open Databases on [fulldomain]
[!]Count up the databases and set the math variable[/!] [listdatabases][showif [name]^[domain]][math show=f]dbtotal=dbtotal+1[/math][/showif][/LISTDATABASES]
Total Databases open:[dbtotal] | Database Specs | Field Names |
|---|
[listdatabases][!]Set math variables for this found set[/!] [math show=f]startval=0[/math][!]Set text variables for this found set[/!] [text]dbpath=[/text][!]Showif this db is in this domain[/!] [showif [name]^[domain]][!]Parse the path to the database[/!] [Listwords words=[name]&delimiters=/][showif [word]^[domain]][math show=f]startval=[index][/math][/showif][/Listwords] [Listwords words=[name]&delimiters=/][showif [index]>[startval]][text]dbpath=[dbpath][word]/[/text][/showif][/Listwords] [text]dbpath=[getchars start=2&from=end][dbpath][/getchars][/text]| [index] | [dbpath]
[url][dbpath][/URL]&dbupdate=T>Flush [url][dbpath][/URL]&dbupdate=T&commit=T>Commit/Flush
[NUMRECORDS] records
[NUMFIELDS] fields | [ListFields path=[name]][FIELDNAME], [/ListFields] |
[!]/ showif this db is in this domain[/!] [/showif] [/LISTDATABASES]
©2000 Cybermill Communications
1-877-962-4024 ******************** End WebDNA Page ********************** Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.> From: Bob Minor > Reply-To: (WebCatalog Talk) > Date: Tue, 25 Apr 2000 09:55:35 > To: (WebCatalog Talk) > Subject: Re: Databases.tpl > > Its fairly simple > > [showif [dbupdate]=T] > [commitdatabase [yourdb]] > [closedatabase [yourdb]] > [/showif] > > You could also do a list of all the db's that contain a sample of your > directory structure. I build this for local users so they can flush just > there own domains. ie > > > [text]thisdomain=mydomain.db[/text] > [!]Webcat can figure this out automatically[/!] > > [math show=f]dbcount=0[/math] > [listdatabases][math show=f]dbtotal=[index][/math][/LISTDATABASES] > There are [dbtotal] databases closing. > [listdatabases] > [!]depending on your platform you may have to parse the name to get the > database path correctly. Play with it, just displaying the path, to get what > you are looking for.[/!] > [showif [name]^[thisdomain]] > [commitdatabase [name]] > [closedatabase [name]] > [name] closed > [/showif] > [/LISTDATABASES] > > Robert Minor > Director of Internet Services > ------------------------------------------------------------ > Cybermill Communications > http://www.cybermill.com http://www.merchantmaker.com > > Providing Ecommerce and interactive website development and > hosting services on Macintosh, Windows NT, Unix, and AS/400. > >> From: Jesse Proudman >> Reply-To: (WebCatalog Talk) >> Date: Tue, 25 Apr 2000 07:29:25 >> To: (WebCatalog Talk) >> Subject: Databases.tpl >> >> It would be cool if on the administration database page, you could flush >> individual databases instead of them all. I tired to change the code to do >> that but I couldn't get it to work. :( > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Bob Minor
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Ruby on Rails (was Looping Search) (2006)
WebCat2 - [format thousands] (1997)
WebTen? (1997)
Location of Webcat site in folder hierarchy (1997)
Sitebuilder (2004)
New Plug-in and Type 11 errors (1997)
WebCatalog Serial Number (1998)
Show if not working in version 4 (2002)
ThreadMem ignored? (1998)
Server replication (1998)
refreshing IE with posted .tmpl (1997)
Color options for items (1999)
Quick Question About Sorting (1997)
Fax Broadcast (1998)
Authenticate (1999)
Fwd: HTML encoding in URLs (1997)
Re:no [search] with NT (1997)
What am I doing wrong? (2000)
Fulfillment emails not emailing after upgrade (2002)
Nested tags count question (1997)