created: 2012/01/18
by: emerson
old files are inside _Raw\2012_01_13_debug_emerson
new files are from the live site, wwwrootv2/Pines in 165
updated the files coz it seems that postoffice and live site have different files

bug fixes
1. have bug on choosing product and adding to cart if the CATEGORY is "CHOOSABLE"
      old code is looking for PRODUCT name that is the same as the CATEGORY name
      so if the customer changed the PRODUCT name or delete the product on the admin module, then products under the "choosable" CATEGORY will no longer be added to the cart
      >>fix:add a product in the products table with same name as the "choosable category", the new product is hidden by setting b_showonfrontend to false
	  >>whatever changes in the "choosable category" must reflect in the products table (rename category, delete category, add category)
2. bug when selecting "choosable" CATEGORY from the menu; adding other products from the list will not update the current list in the cart
      >>fix:check on page load if u_cart_id exist from shoppingcart,if so, populate the page according to u_product_ids column(new column), then update the u_product_detail column
	  
Database changes:
1. additional column u_product_ids in shoppingcart
2. additional column i_product_id in category (used when category is choosable)