Re: Every other record deleted
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63659
interpreted = N
texte = USER ADD:--------------------[append db=listings_UNAPPROVED.db][!][/!]LISTING_ID=[random][cart][random][!][/!]&LAST_IP=[ipaddress][!][/!]&LAST_UPDATE_DATE=[date][!][/!]&LAST_UPDATE_TIME=[format seconds_to_time %I:%M %p][math]{[time]}+{01:00:00}[/math][/format][!][/!]&PASS_WORD=[include file=pass_gen.txt][!][/!]&PAID_LISTING=N[!][/!]&VERIFIED=N[!][/!]&VISIBLE=Y[!][/!]&NAME=[url][NAME][/url][!][/!]&CONTACT_PERSON=[url][CONTACT_PERSON][/url][!][/!]&ADDRESS=[url][ADDRESS][/url][!][/!]&CITY=[url][CITY][/url][!][/!]&STATE=ID[!][/!]&ZIP=[ZIP][!][/!]&EMAIL=[url][EMAIL][/url][!][/!]&EMAIL_VISIBLE=Y[!][/!]&WEBSITE=[url][WEBSITE][/url][!][/!]&SUBCAT=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=SUBCAT][!][/!]&LISTING_CATEGORY=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=PARENT][!][/!]&SUBCAT_ID=[SUBCAT_ID][!][/!]&PHONE=([url][PHONE_A][/url]) [url][PHONE_B][/url]-[url][PHONE_C][/url][!][/!][hideif [url][FAX_B][/url]=]&FAX=([url][FAX_A][/url]) [url][FAX_B][/url]-[url][FAX_C][/url][/hideif][!][/!]&KEYWORDS=[loop start=1&end=6][hideif [KEYWORD_[index]]=][interpret][KEYWORD_[index]][/interpret]|[/hideif][/loop][!][/!]&DESCRIPTION=[url][getchars start=1&end=2000][DESCRIPTION][/getchars][/url][!][/!]&LISTING_RANK=0[!][/!][/append]ONCE USER IS VERIFIED:---------------------------[search db=listings_UNAPPROVED.db&eqLISTING_IDdata=[LISTING_ID]][founditems][append db=listings.db][!][/!]LISTING_ID=[LISTING_ID][!][/!]&LAST_IP=[LAST_IP][!][/!]&LAST_UPDATE_DATE=[LAST_UPDATE_DATE][!][/!]&LAST_UPDATE_TIME=[LAST_UPDATE_TIME][!][/!]&PASS_WORD=[PASS_WORD][!][/!]&PAID_LISTING=N[!][/!]&VERIFIED=Y[!][/!]&VISIBLE=Y[!][/!]&NAME=[url][NAME][/url][!][/!]&CONTACT_PERSON=[url][CONTACT_PERSON][/url][!][/!]&ADDRESS=[url][ADDRESS][/url][!][/!]&CITY=[url][CITY][/url][!][/!]&STATE=ID[!][/!]&ZIP=[ZIP][!][/!]&EMAIL=[url][EMAIL][/url][!][/!]&EMAIL_VISIBLE=Y[!][/!]&WEBSITE=[url][WEBSITE][/url][!][/!]&SUBCAT=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=SUBCAT][!][/!]&LISTING_CATEGORY=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=PARENT][!][/!]&SUBCAT_ID=[SUBCAT_ID][!][/!]&PHONE=[PHONE][!][/!]&FAX=[FAX][!][/!]&KEYWORDS=[KEYWORDS][!][/!]&DESCRIPTION=[DESCRIPTION][!][/!]&LISTING_RANK=0[!][/!]&APPROVED=Y[!][/!][/append][/founditems][/search][delete db=listings_UNAPPROVED.db&eqLISTING_IDdata=[LISTING_ID]]USER EDIT:--------------------[replace db=listings.db&eqLISTING_IDdata=[LISTING_ID]][!][/!]LAST_IP=[ipaddress][!][/!]&LAST_UPDATE_DATE=[date][!][/!]&LAST_UPDATE_TIME=[format seconds_to_time %I:%M %p][math]{[time]}+{01:00:00}[/math][/format][!][/!]&NAME=[url][NAME][/url][!][/!]&CONTACT_PERSON=[url][CONTACT_PERSON][/url][!][/!]&ADDRESS=[url][ADDRESS][/url][!][/!]&CITY=[url][CITY][/url][!][/!]&ZIP=[ZIP][!][/!]&WEBSITE=[url][WEBSITE][/url][!][/!]&SUBCAT=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=SUBCAT][!][/!]&SUBCAT_ID=[SUBCAT_ID][!][/!]&VERIFIED=Y[!][/!]&EMAIL_VISIBLE=[EMAIL_VISIBLE][!][/!]&PHONE=([url][PHONE_A][/url]) [url][PHONE_B][/url]-[url][PHONE_C][/url][!][/!][hideif [url][FAX_B][/url]=]&FAX=([url][FAX_A][/url]) [url][FAX_B][/url]-[url][FAX_C][/url][/hideif][!][/!]&KEYWORDS=[loop start=1&end=6][hideif [KEYWORD_[index]]=][interpret][KEYWORD_[index]][/interpret]|[/hideif][/loop][!][/!]&DESCRIPTION=[url][getchars start=1&end=2000][DESCRIPTION][/getchars][/url][!][/!][/replace]pass_gen.txt--------------------[text]tPasswordLength=8[/text][text]tChars=abcdefghijkmpqrstuvwxyz23456789ABCDEFGHJKLMNPQRSTUVWXYZ23456789[/text][text]tMax=[countchars][tChars][/countchars][/text][text]tPass=[/text][loop start=1&end=[tPasswordLength]][text]tX=[math]ceil([random format=float]*[tMax])[/math][/text][text]tPass=[tPass][getchars start=[tX]&end=[tX]][tChars][/getchars][/text][/loop][tPass]On Thu, 22 Dec 2005 10:10:54 -0600 Donovan Brooke
wrote:> Dan Strong wrote:> >> I am on a shared server (not clustered), but maybe a similar issue. I've >> also noticed that letters in records get screwed up at random too >> (Communications becomes Communjication). I've double-checked that I have >> all my user-inputs [url]'ed, that my code is working as expected and I'm >> reasonably sure that I haven't been hacked or that the server has a >> virus... just weird.>> -Dan> > > 99% sure that it is code. Post *all* (and only webdna) of your database> editing code to that database.> > Donovan-------------------------------------------------------------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:
USER ADD:--------------------[append db=listings_UNAPPROVED.db][!][/!]LISTING_ID=[random][cart][random][!][/!]&LAST_IP=[ipaddress][!][/!]&LAST_UPDATE_DATE=[date][!][/!]&LAST_UPDATE_TIME=[format seconds_to_time %I:%M %p][math]{[time]}+{01:00:00}[/math][/format][!][/!]&PASS_WORD=[include file=pass_gen.txt][!][/!]&PAID_LISTING=N[!][/!]&VERIFIED=N[!][/!]&VISIBLE=Y[!][/!]&NAME=[url][NAME][/url][!][/!]&CONTACT_PERSON=[url][CONTACT_PERSON][/url][!][/!]&ADDRESS=[url][ADDRESS][/url][!][/!]&CITY=[url][CITY][/url][!][/!]&STATE=ID[!][/!]&ZIP=[ZIP][!][/!]&EMAIL=[url][EMAIL][/url][!][/!]&EMAIL_VISIBLE=Y[!][/!]&WEBSITE=[url][WEBSITE][/url][!][/!]&SUBCAT=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=SUBCAT][!][/!]&LISTING_CATEGORY=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=PARENT][!][/!]&SUBCAT_ID=[SUBCAT_ID][!][/!]&PHONE=([url][PHONE_A][/url]) [url][PHONE_B][/url]-[url][PHONE_C][/url][!][/!][hideif [url][FAX_B][/url]=]&FAX=([url][FAX_A][/url]) [url][FAX_B][/url]-[url][FAX_C][/url][/hideif][!][/!]&KEYWORDS=[loop start=1&end=6][hideif [KEYWORD_[index]]=][interpret][KEYWORD_[index]][/interpret]|[/hideif][/loop][!][/!]&DESCRIPTION=[url][getchars start=1&end=2000][DESCRIPTION][/getchars][/url][!][/!]&LISTING_RANK=0[!][/!][/append]ONCE USER IS VERIFIED:---------------------------[search db=listings_UNAPPROVED.db&eqLISTING_IDdata=[LISTING_ID]][founditems][append db=listings.db][!][/!]LISTING_ID=[LISTING_ID][!][/!]&LAST_IP=[LAST_IP][!][/!]&LAST_UPDATE_DATE=[LAST_UPDATE_DATE][!][/!]&LAST_UPDATE_TIME=[LAST_UPDATE_TIME][!][/!]&PASS_WORD=[PASS_WORD][!][/!]&PAID_LISTING=N[!][/!]&VERIFIED=Y[!][/!]&VISIBLE=Y[!][/!]&NAME=[url][NAME][/url][!][/!]&CONTACT_PERSON=[url][CONTACT_PERSON][/url][!][/!]&ADDRESS=[url][ADDRESS][/url][!][/!]&CITY=[url][CITY][/url][!][/!]&STATE=ID[!][/!]&ZIP=[ZIP][!][/!]&EMAIL=[url][EMAIL][/url][!][/!]&EMAIL_VISIBLE=Y[!][/!]&WEBSITE=[url][WEBSITE][/url][!][/!]&SUBCAT=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=SUBCAT][!][/!]&LISTING_CATEGORY=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=PARENT][!][/!]&SUBCAT_ID=[SUBCAT_ID][!][/!]&PHONE=[PHONE][!][/!]&FAX=[FAX][!][/!]&KEYWORDS=[KEYWORDS][!][/!]&DESCRIPTION=[DESCRIPTION][!][/!]&LISTING_RANK=0[!][/!]&APPROVED=Y[!][/!][/append][/founditems][/search][delete db=listings_UNAPPROVED.db&eqLISTING_IDdata=[LISTING_ID]]USER EDIT:--------------------[replace db=listings.db&eqLISTING_IDdata=[LISTING_ID]][!][/!]LAST_IP=[ipaddress][!][/!]&LAST_UPDATE_DATE=[date][!][/!]&LAST_UPDATE_TIME=[format seconds_to_time %I:%M %p][math]{[time]}+{01:00:00}[/math][/format][!][/!]&NAME=[url][NAME][/url][!][/!]&CONTACT_PERSON=[url][CONTACT_PERSON][/url][!][/!]&ADDRESS=[url][ADDRESS][/url][!][/!]&CITY=[url][CITY][/url][!][/!]&ZIP=[ZIP][!][/!]&WEBSITE=[url][WEBSITE][/url][!][/!]&SUBCAT=[lookup db=subcat.db&lookinfield=SUBCAT_ID&value=[SUBCAT_ID]&returnfield=SUBCAT][!][/!]&SUBCAT_ID=[SUBCAT_ID][!][/!]&VERIFIED=Y[!][/!]&EMAIL_VISIBLE=[EMAIL_VISIBLE][!][/!]&PHONE=([url][PHONE_A][/url]) [url][PHONE_B][/url]-[url][PHONE_C][/url][!][/!][hideif [url][FAX_B][/url]=]&FAX=([url][FAX_A][/url]) [url][FAX_B][/url]-[url][FAX_C][/url][/hideif][!][/!]&KEYWORDS=[loop start=1&end=6][hideif [KEYWORD_[index]]=][interpret][KEYWORD_[index]][/interpret]|[/hideif][/loop][!][/!]&DESCRIPTION=[url][getchars start=1&end=2000][DESCRIPTION][/getchars][/url][!][/!][/replace]pass_gen.txt--------------------[text]tPasswordLength=8[/text][text]tChars=abcdefghijkmpqrstuvwxyz23456789ABCDEFGHJKLMNPQRSTUVWXYZ23456789[/text][text]tMax=[countchars][tChars][/countchars][/text][text]tPass=[/text][loop start=1&end=[tPasswordLength]][text]tX=[math]ceil([random format=float]*[tMax])[/math][/text][text]tPass=[tPass][getchars start=[tX]&end=[tX]][tChars][/getchars][/text][/loop][tPass]On Thu, 22 Dec 2005 10:10:54 -0600 Donovan Brooke wrote:> Dan Strong wrote:> >> I am on a shared server (not clustered), but maybe a similar issue. I've >> also noticed that letters in records get screwed up at random too >> (Communications becomes Communjication). I've double-checked that I have >> all my user-inputs [url]'ed, that my code is working as expected and I'm >> reasonably sure that I haven't been hacked or that the server has a >> virus... just weird.>> -Dan> > > 99% sure that it is code. Post *all* (and only webdna) of your database> editing code to that database.> > Donovan-------------------------------------------------------------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/
"Dan Strong"
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:
show all problem (1997)
Re:Comments Convertion (1998)
quick GREP question (2001)
PCS Customer submissions ? (1997)
Attn iTools / WebCat users.... (2004)
Bug alert! (1997)
Sorting error (1997)
Only charge card when product shipped ? (1997)
WebCat2b15MacPlugin - showing [math] (1997)
AmEx, shipping (2000)
Listfiles & writefile (2001)
Coding Technique (2000)
AccountAuthorizer doesn't seem to work (1997)
Nesting format tags (1997)
GuestBook example (1997)
counting characters and/or words (1997)
Caching [include] files ... (1997)
Setting up WebCatalog with Retail Pro data (1996)
Emailer choke (1997)
[WebDNA] WebDNA on a cPanel server? Maybe not ... (2019)