custom zen-cart one-click upgrade script

Fertiggestellt Veröffentlicht Dec 1, 2009 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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

Ingenieurwesen MySQL PHP Softwarearchitektur Testen von Software Web Hosting Website-Management Testen von Webseiten

Projekt-ID: #2997861

Über das Projekt

2 Vorschläge Remote Projekt Aktiv Dec 2, 2009

Vergeben an:

webdevstuffs

See private message.

$42.5 USD in 3 Tagen
(34 Bewertungen)
5.4

2 Freelancer bieten im Durchschnitt $49 für diesen Job

hdpamara

See private message.

$55.25 USD in 3 Tagen
(4 Bewertungen)
2.5