User contributions for Woozle

1 April 2008

• 19:3519:35, 1 April 2008 diff hist +54 North Carolina added link to home schooling; moved internal links to top; some reorg
• 19:2919:29, 1 April 2008 diff hist +363 N home schooling/US/NC New page: ==Overview== category:US.NCThis page is about home schooling in North Carolina.{{seed}} ==Directory== ===Reference=== * [http://www.ncdnpe.org/hhh103.htm State of North Caro...
• 19:2719:27, 1 April 2008 diff hist +695 N home schooling New page: ==Overview== Home schooling is the practice of schooling one's own children, typically at home.{{seed}} ==Related Pages== * /US/NC: home schooling in [[North Carolin...

31 March 2008

• 13:0213:02, 31 March 2008 diff hist −34 m nslookup can't remember what that template was supposed to do

30 March 2008

• 15:3815:38, 30 March 2008 diff hist +208 VbzCart/queries →qryTitles_ItTyps_grpItems: removed filtering for in-stock only
• 15:3415:34, 30 March 2008 diff hist +14 VbzCart/tables →cat_pages: updated _cat_pages to use non-cached data only
• 02:0202:02, 30 March 2008 diff hist +68 VbzCart/queries →qryCat_Titles: +CatWeb so we can use this to update cat_pages
• 01:5901:59, 30 March 2008 diff hist +107 VbzCart/queries →qryCat_Depts: more fields so we can use this to update cat_pages

28 March 2008

• 21:3321:33, 28 March 2008 diff hist +17 VbzCart/queries →qryTitles_ItTyps_grpItems: only isForSale items, otherwise price range includes items not available
• 20:5620:56, 28 March 2008 diff hist +2,050 VbzCart/queries →v_titles: several queries for generating page displays (gradually replacing data management/caching system cuz it's a PitB); +ID_Dept in v_titles
• 04:0504:05, 28 March 2008 diff hist −145 autism/US/NC →Assisted Living: moved GHA info to new Gha Inc. page
• 04:0304:03, 28 March 2008 diff hist +81 m GHA Inc. acronym
• 04:0104:01, 28 March 2008 diff hist +36 m GHA Inc. →Overview: only 9 facilities listed on web site; link to facilities page
• 03:5903:59, 28 March 2008 diff hist +910 N GHA Inc. New page: ==Overview== category:US.NCGHA Inc. is "a private, non-profit organization offering residential, day and community services for residents of North Carolina with a primary diagn...

27 March 2008

• 14:5714:57, 27 March 2008 diff hist +71 VbzCart/tables →cat_images: +isActive field
• 11:4111:41, 27 March 2008 diff hist +2,813 VbzCart/pieces/catalog/building →ctg_upd* data building: working now?

26 March 2008

• 15:1115:11, 26 March 2008 diff hist +21 VbzCart/pieces/catalog/building →qryCtg_Items_forUpdJoin: +!isDumped -- otherwise we get unnecessary duplicate keys
• 13:4913:49, 26 March 2008 diff hist −25 VbzCart/tables →ctg_upd1: cntDups isn't needed here; any duplicates indicate a problem with the source data
• 12:5712:57, 26 March 2008 diff hist +7 VbzCart/tables →ctg_upd2: don't preserve CatNum
• 12:5112:51, 26 March 2008 diff hist +75 VbzCart/pieces/catalog/building →qryCtg_Items_forUpdJoin: no, we don't need to save CatNum; it should always get set
• 12:4312:43, 26 March 2008 diff hist +8 VbzCart/pieces/catalog/building →qryCtg_Upd_join: no, qtyInStock has now been recalculated; preserve it
• 12:3212:32, 26 March 2008 diff hist +137 VbzCart/pieces/catalog/building →qryCtg_Upd_join: we shouldn't be trying to preserve so much data from cat_items

23 March 2008

• 23:0623:06, 23 March 2008 diff hist +409 VbzCart/pieces/catalog/building →qryCtg_Items_forUpdJoin: +isForSale; outdented other queries (probably indented accidentally)
• 22:5822:58, 23 March 2008 diff hist +25 VbzCart/tables →ctg_upd2: ID_Item needs to be a key too, for the last join to cat_items
• 22:0722:07, 23 March 2008 diff hist +39 VbzCart/pieces/catalog/building →ctg_upd* data building: SQL to drop procedure before creating
• 21:4421:44, 23 March 2008 diff hist +100 VbzCart/tables →ctg_upd2: +isForSale
• 20:2520:25, 23 March 2008 diff hist +93 VbzCart/pieces/catalog/building →ctg_upd* data building: delimiter unnecessary; declaration syntax not quite right (don't need "AS")
• 20:1920:19, 23 March 2008 diff hist +35 VbzCart/pieces/catalog/building →qryCtg_src_sub: more filtering: qryCtg_Items_active has only *active* CTG items
• 20:1520:15, 23 March 2008 diff hist +1 m VbzCart/queries →qryCtg_Items_active: put in missing semicolon
• 20:1420:14, 23 March 2008 diff hist +428 VbzCart/queries →qryCtg_Titles_active: qryCtg_Items_active
• 16:5616:56, 23 March 2008 diff hist −16,808 m MediaWiki/archive/user-group security Reverted edits by AceldArcro (Talk); changed back to last version by Woozle
• 00:3900:39, 23 March 2008 diff hist +168 VbzCart/pieces/catalog/building →ctg_upd* data building: part 3: housekeeping - update timestamp

22 March 2008

• 22:0422:04, 22 March 2008 diff hist +4 VbzCart/tables →ctg_upd2: CatNum is sometimes NULL in cat_items because old items may get returned to use
• 21:5721:57, 22 March 2008 diff hist +483 VbzCart/pieces/catalog/building →qryCtg_Items_forUpdJoin: CatNum never overwritten with NULL
• 21:5121:51, 22 March 2008 diff hist +7 VbzCart/pieces/catalog/building →ctg_upd* data building: +CatNum in ctg_upd2
• 21:5021:50, 22 March 2008 diff hist +82 VbzCart/tables →stk_history: Qty -> QtyDone, +QtyLeft so we have an ongoing record of whether the stock qty was being correctly adjusted
• 21:4821:48, 22 March 2008 diff hist −2 VbzCart/tables →ctg_upd2: CatNum NOT NULL
• 21:4521:45, 22 March 2008 diff hist +94 VbzCart/tables →ctg_upd2: +CatNum
• 15:0815:08, 22 March 2008 diff hist +239 technology →Progress: kite-assisted cargo ship
• 14:4714:47, 22 March 2008 diff hist +404 sustainability/US →Links: Warren Buffett plays with railroads

21 March 2008

• 13:0813:08, 21 March 2008 diff hist +213 WINE →User Notes: Links: WINE 1.0
• 02:4802:48, 21 March 2008 diff hist +63 VbzCart/pieces/catalog/building →SQL - queries - 2008: qryCtg_Items_forUpdJoin revised to match ctg_upd2; SQL revised to insert new fields

20 March 2008

• 20:0620:06, 20 March 2008 diff hist +113 autism/US/NC →Assisted Living: email address for GHA
• 19:3519:35, 20 March 2008 diff hist +78 VbzCart/pieces/catalog/building →qryCtg_Upd_join: more careful matching of fields; need some new fields in ctg_upd2
• 19:3519:35, 20 March 2008 diff hist −20 VbzCart/tables →ctg_upd2: some fields in cat_items need to be preserved, so we have to save them here
• 18:2818:28, 20 March 2008 diff hist +225 800-927-2291 →Encounters: 3/20
• 13:2513:25, 20 March 2008 diff hist −388 VbzCart/pieces/catalog/building →ctg_upd* data building: simplified due to explicit columns in qryCtg_Upd_join (but not working yet)
• 13:1913:19, 20 March 2008 diff hist +309 VbzCart/pieces/catalog/building →qryCtg_Upd_join: now selects fields to match cat_items
• 13:1313:13, 20 March 2008 diff hist −691 m VbzCart/pieces/catalog/building →ctg_upd* data building: moved disused code to talkpage
• 13:0413:04, 20 March 2008 diff hist +981 N Talk:VbzCart/pieces/catalog/building New page: A disused query from doCtgUpdate(): <mysql>UPDATE cat_items AS i LEFT JOIN qryCtg_Upd_join AS u ON i.ID=u.ID_Item SET i.CatNum = u.CatNum, i.isForSale = TRUE, i.isInPrint = N...