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:

    
  1. Re: Every other record deleted ( Donovan Brooke 2005)
  2. Re: Every other record deleted ( Peter Ostry 2005)
  3. Re: Every other record deleted ( Grant Hulbert 2005)
  4. Re: Every other record deleted ( Stuart Tremain 2005)
  5. Re: Every other record deleted ( Brian Fries 2005)
  6. Re: Every other record deleted ( Jesse Proudman 2005)
  7. Re: Every other record deleted ( Jesse Proudman 2005)
  8. Re: Every other record deleted ( "Dan Strong" 2005)
  9. Re: Every other record deleted ( Donovan Brooke 2005)
  10. Re: Every other record deleted ( "Dan Strong" 2005)
  11. Re: Every other record deleted ( Donovan Brooke 2005)
  12. Re: Every other record deleted ( "Dan Strong" 2005)
  13. Re: Every other record deleted ( "Eric Miller" 2005)
  14. Every other record deleted ( "Dan Strong" 2005)
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)