custom zen-cart one-click upgrade script

Using the latest Zen-Cart

* Create a new admin page called [url removed, login to view]

* Create a link to this page in the menu under TOOLS called "One-Click Upgrade"

* When this page is opened, it will:

* display the current version from the local database "project_version" table (both entries)

* connect to a different database (login details to be provided once project is awarded), read the values in the table, and display new versions available (should only show NEWER versions available compared to the current version)

* have a button UPGRADE NOW

* The schema of the table which will have a list of newer versions and will be in a remote database, so you will need to create a connection string

* When the UPGRADE NOW button is clicked, the page should do the following for EACH new version available compared to the current version. So for example, if current version is 1.2, and new versions are 1.3, 1.4, 1.41, 1.5, then the following pseudo-code should be executed 4 times (once for each new version):

* IF "project_version_type" = "files" Then do the following:

<?php

shell_exec('wget -v **PATH_FROM_TABLE+FILENAME_FROM_TABLE**');

shell_exec('unzip **FILENAME_FROM_TABLE**');

if(file_exists("**FILENAME_FROM_TABLE**")){

unlink("**FILENAME_FROM_TABLE**");

}

?>

* The UNZIP statement SHOULD overwrite existing files

* IF "project_version_type" = "database" AND FILENAME_FROM_TABLE is .sql Then do the following:

execute the sql script to update the local database

* The version associated to each iteration of the loop should be updated in the local database "project_version" table

* Display message for every successful update

## Deliverables

FULL PROJECT SCOPE:

Using the latest Zen-Cart

* Create a new admin page called [url removed, login to view]

* Create a link to this page in the menu under TOOLS called "One-Click Upgrade"

* When this page is opened, it will:

* display the current version from the local database "project_version" table (both entries)

* connect to a different database (login details to be provided once project is awarded), read the values in the table, and display new versions available (should only show NEWER versions available compared to the current version)

* have a button UPGRADE NOW

* The schema of the table which will have a list of newer versions and will be in a remote database, so you will need to create a connection string:

* CREATE TABLE `upgrades` (

`id` int(4) NOT NULL AUTO_INCREMENT,

`project_version_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,

`project_version_major` varchar(20) COLLATE utf8_unicode_ci NOT NULL,

`project_version_minor` varchar(20) COLLATE utf8_unicode_ci NOT NULL,

`project_date_available` datetime NOT NULL,

`project_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

`project_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

* When the UPGRADE NOW button is clicked, the page should do the following for EACH new version available compared to the current version. So for example, if current version is 1.2, and new versions are 1.3, 1.4, 1.41, 1.5, then the following pseudo-code should be executed 4 times (once for each new version):

* IF "project_version_type" = "files" Then do the following:

<?php

shell_exec('wget -v **PATH_FROM_TABLE+FILENAME_FROM_TABLE**');

shell_exec('unzip **FILENAME_FROM_TABLE**');

if(file_exists("**FILENAME_FROM_TABLE**")){

unlink("**FILENAME_FROM_TABLE**");

}

?>

* The UNZIP statement SHOULD overwrite existing files

* IF "project_version_type" = "database" AND FILENAME_FROM_TABLE is .sql Then do the following:

execute the sql script to update the local database

* The version associated to each iteration of the loop should be updated in the local database "project_version" table

* Display message for every successful update

Engineering MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #2997861

About the project