20081024 ~ 28

    DATA RESTRUCTURE

        -- Add remarks field in customers table
        ALTER TABLE `customers` ADD COLUMN `customers_remarks` TEXT;
        -- Add customers_basket_ebay_id field in customers_basket table
        ALTER TABLE `customers_basket` ADD COLUMN `customers_basket_ebay_id` VARCHAR(20) DEFAULT NULL;
        -- Add products_ebay_id field in orders_products table
        ALTER TABLE `orders_products` ADD COLUMN `products_ebay_id` VARCHAR(20) DEFAULT NULL;

    MODIFIED SOURCE

        // modby: Terry, 20081027, add global variable to check if the site is run at $define_domain
        // modby: Terry, 20081027, add global variable to check if the current user can buy from this domain
            /customization/header.php
            /customization/config.php

        // modby: Terry, 20081027, add "ebay transaction id" for members only.
            /shopping_cart.php                          // to input the ebay id in the shopping cart
            /checkout_confirmation.php                  // to show the ebay id for confirmation
            /checkout_process.php                       // to save the ebay id from cart to order
            /account_history_info.php                   // to view the ebay id in order history

        // modby: Terry, 20081027, add "ebay transaction id" field.
            /includes/application_top.php               // to perform server-side update/insert of ebay id to shopping cart
            /includes/classes/shopping_cart.php         // to update the ebay id inside the shopping cart page
            /includes/classes/order.php                 // to convert from cart (TABLE_CUSTOMERS_BASKET)
                                                        // to orders (TABLE_ORDERS_PRODUCTS)


        // modby: Terry, 20081027, add "ebay transaction id" to admin orders
            /admin/includes/classes/shopping_cart.php
            /admin/includes/classes/order.php           // to show the ebay id in admin order history

        // modby: Terry, 20081027, add "ebay transaction id" to admin invoice
            /admin/invoice.php

        // modby: Terry, 20081028, add "ebay transaction id" to order email for members only
            /checkout_process.php

        // modby: Terry, 20081028, enable shopping cart for members only and customers at sub domains only
            /shopping_cart.php
            /checkout_shipping.php          // if a visitor add items to cart before login,
                                            // and use the checkout button to login, it
                                            // by-passes the shopping cart page.
                                            // So we need to check this page also.

        // modby: Terry, 20081028, "ebay transaction id" is required field in member shopping cart
            /shopping_cart.php
            /checkout_shipping.php          // if any one item has empty ebay id, redirect back to the shopping cart

        // modby: Terry, 20081028, clear the shopping cart if customer logs in the main domain
                // (because the customer cannot buy in the main domain)
            /includes/application_top.php

        // modby: Terry, 20081028, shopping cart enhancement: auto-update on checkout.
            /includes/application_top.php            // added another switch (...) case 'update_checkout'
            /shopping_cart.php

    BUG FIXES

        // modby: Terry, 20081027, bug fix, duplicated definition
            /includes/filenames.php

        // modby: Terry, 20081027, commented original source, don't know what is this for, but generates error
            /includes/boxes/categories.php

        // modby: Terry, 20081027, bug fix
            /includes/functions/general.php

        // modby: Terry, 20081027, bug fix, missing 2nd argument for display_price()
            /product_info.php
            /products_new.php
            /product_reviews.php

        // modby: Terry, 20081027, bug fix, missing specified width for layout TD cell, added width="22"
        // modby: Terry, 20081027, Fix: strip_tags() and increase substr length (same fix as 200809)
            /includes/modules/also_purchased_products.php