Re: ShoppingCart clearing code
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57212
interpreted = N
texte = HiI expanded Brian's suggestion a bit. I created a WebDNA page that looks in all the virtual sites in the WebSites folder, looks to see if they have a ShoppingCarts folder, and if they do, delete any carts older than 2 days.I set up a cron task to curl the page once a day in the wee small hours.I had to do a bit of fiddling with [moddate] to get it in a format I could do [math] on...........................[!] list all files in the WebSites folder[/!][listfiles path=../WebSites/][!] set variable for each file in loop[/!][text]SiteName=[FileName][/text][!] showif if there is a ShoppingCarts file inside[/!][showif [FileInfo file=[SiteName]/ShoppingCarts][Exists][/fileinfo]=T][!] look for carts to delete[/!][listfiles path=[SiteName]/ShoppingCarts/][!]check they are older than 2 days[/!][showif [math]{[getchars start=7&end=10][ModDate][/getchars]/[getchars start=4&end=5][ModDate][/getchars]/[getchars start=1&end=2][ModDate][/getchars]}[/math]<[math]{[date %Y %m %d]}-2[/math]][!]If so delete them[/!][deletefile file=[SiteName]/ShoppingCarts/[FileName]][!]/If so delete them[/!][/showif][!]/check they are older than 2 days[/!][/listfiles][!] /look for carts to delete[/!][/showif][!] /showif if there is a ShoppingCarts file inside[/!][/listfiles][!] /list all files in the WebSites folder[/!]........................PaulOn 22 Mar 2004, at 19:30, Brian Boegershausen wrote:> why not just do a listfiles and delete anything over a day old. Put it > on> the purchase page so it does not go off thousands of times a day... > unless> you get that many orders.>> [listfiles path=shoppingcarts/]> [hideif [createdate]=[date]]> [deletefile file=[filename]]> [/hideif]> [/listfiles]>> That may need to be tweaked a bit, but you get the idea.>> Brian Boegershausen> ----- Original Message -----> From: "Paul Willis"
> To: "WebDNA Talk" > Sent: Monday, March 22, 2004 1:31 PM> Subject: ShoppingCart clearing code>>>> Hi all>>>> I have given up waiting for SMSI to fix the "ShoppingCart clearing>> code" bug in v5.1 (and I am not willing to pay $500 per copy for the>> fix) so I am going to roll my own.>>>> I faintly recall someone posting some code to do this a good while >> back>> (was it Alain?) but I can't find it in the archive.>>>> Anyone remember it?>>>> Paul>>-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
HiI expanded Brian's suggestion a bit. I created a WebDNA page that looks in all the virtual sites in the WebSites folder, looks to see if they have a ShoppingCarts folder, and if they do, delete any carts older than 2 days.I set up a cron task to curl the page once a day in the wee small hours.I had to do a bit of fiddling with [moddate] to get it in a format I could do [math] on...........................[!] list all files in the WebSites folder[/!][listfiles path=../WebSites/][!] set variable for each file in loop[/!][text]SiteName=[FileName][/text][!] showif if there is a ShoppingCarts file inside[/!][showif [FileInfo file=[SiteName]/ShoppingCarts][Exists][/fileinfo]=T][!] look for carts to delete[/!][listfiles path=[SiteName]/ShoppingCarts/][!]check they are older than 2 days[/!][showif [math]{[getchars start=7&end=10][ModDate][/getchars]/[getchars start=4&end=5][ModDate][/getchars]/[getchars start=1&end=2][ModDate][/getchars]}[/math]<[math]{[date %Y %m %d]}-2[/math]][!]If so delete them[/!][deletefile file=[SiteName]/ShoppingCarts/[FileName]][!]/If so delete them[/!][/showif][!]/check they are older than 2 days[/!][/listfiles][!] /look for carts to delete[/!][/showif][!] /showif if there is a ShoppingCarts file inside[/!][/listfiles][!] /list all files in the WebSites folder[/!]........................PaulOn 22 Mar 2004, at 19:30, Brian Boegershausen wrote:> why not just do a listfiles and delete anything over a day old. Put it > on> the purchase page so it does not go off thousands of times a day... > unless> you get that many orders.>> [listfiles path=shoppingcarts/]> [hideif [createdate]=[date]]> [deletefile file=[filename]]> [/hideif]> [/listfiles]>> That may need to be tweaked a bit, but you get the idea.>> Brian Boegershausen> ----- Original Message -----> From: "Paul Willis" > To: "WebDNA Talk" > Sent: Monday, March 22, 2004 1:31 PM> Subject: ShoppingCart clearing code>>>> Hi all>>>> I have given up waiting for SMSI to fix the "ShoppingCart clearing>> code" bug in v5.1 (and I am not willing to pay $500 per copy for the>> fix) so I am going to roll my own.>>>> I faintly recall someone posting some code to do this a good while >> back>> (was it Alain?) but I can't find it in the archive.>>>> Anyone remember it?>>>> Paul>>-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
Paul Willis
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:
carriage returns in data (1997)
Problems appending to database (1997)
Protect (1997)
nesting limits? (1998)
RE: Symantec VIsual Page 1.0.3 (1997)
PLEASE REMOVE MY EMAIL ADDRESS (1997)
WebCatalog2 for NT Beta Request (1997)
Simple question (1998)
Everyone: List Traffic (was [include ...] behavior) (1997)
can you reassign loop index? (1998)
[WebDNA] Feature Request: [returnhtml] (2016)
WebDNA Running Out of RAM? (2004)
[ConvertChars] problem (1997)
[WebDNA] OSX Webdna Installer (2009)
RE: Emailer prefs in two places ... (1997)
No data - More Info (1997)
I'm tired of all this! (2000)
Has anyone used WebCatalog with CGatePro? (2000)
Attn: Bug in GeneralStore example b15 (1997)
OSX Install error (2000)