---------------------------------------------------

OSCommerce >= 2.2 to CE Phoenix Migration Utility

---------------------------------------------------

Released under the GNU General Public License

Copyright (c) 2021: Preston Lord - @zipurman - Intricate Networks Inc.

  Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

  1. Re-distributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.

  2. Re-distributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

  3. Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.

  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

---------------------------------------------------

Features:

    - Password protect migration utility to avoid usage from third parties
    - Link to OSCommerce MySQL Database
    - Link to CE Phoenix MySQL Database
    - Link to file structure for OSCommerce Export
    - Link to file structure for CE Phoenix Import
    - Test server to make sure PHP and MySQL are setup correctly
        - tests read/write/delete security
    - Upgrade old OSCommerce Data
        - detects OSCommerce data version by the state of what upgrades are missing.
        - applies upgrades to the database to upgrade OSCommerce to 2.3.4
    - Choose what data to migrate
        - queries the OSCommerce tables and allows you to choose any tables you want to transfer, including custom tables that your mods have created
    - Check targeted tables in CE Phoenix to make sure table is empty
        - will use the selected tables from the "Choose what data to migrate" and compare those against the target CE Phoenix tables and alert you to any required changes
    - Transfer MySQL Data Now
        - will apply any required changes based on previous alerts in previous steps
            - All targeted tables in CE Phoenix will be emptied before being populated. There are warnings beside tables in previous steps to avoid this on some tables like "configuration" table
            - Any missing tables will be created to match the OSCommerce specs for that table
            - Any missing columns will be added to tables prior to import to make sure any custom data is not lost
        - All data from OSCommerce database will be migrated to CE Phoenix database
    - Transfer Images Now
        - All image files and folders will be migrated from OSCommerce to CE Phoenix
    - English language file for all text (Language Switch functionality to come if enough interest)

Future Features:

    - Transfer of mods from old code to new code base. This is a tricky step as so much could go wrong with it and blow up the CE Phoenix install.
    - Allow for easy language switching


Instructions:

    1. Clone your OSCommerce MySQL database to a new database as the data will be upgraded during the migration.
    2. Make sure the Cloned OSCommerce MySQL database allows for connections from the server the utility is running on.
    3. Create a fresh install of CE Phoenix on a network connected server - DO NOT INSTALL TEST DATA! If you do install the test data, the utility will remove it, but it is recommended that you do not install test data to avoid any issues.
    4. Make sure the CE Phoenix MySQL database allows for connections from the server the utility is running on.
    5. Unzip this utility and load the utility in your web browser.
    6. Make sure that you have file path access from the server that the utility is running on, to both the CE Phoenix and OSCommerce installs. This can be done with mapped drives or mount points.
    7. Make sure you are running PHP >= 7.2 on the server the utility is running on.
    8. Happy Migrating


