Em Andamento

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, [url removed, login to view], 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, [url removed, login to view], 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

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: zen cart upgrade script, version one, schema update, php script null, php version need one, latest zen cart version, int v, upgrade php, sql script , pseudo code, php script create table, one click, php script execute, sql connect remote database, display code different versions, unzip php, datetime, php script read table, loop table, custom loop, sql default values, iteration, php sql script project, wget, remote login php

Acerca do Empregador:
( 15 comentários ) Markham, Canada

ID do Projeto: #2997861

Premiar a:

webdevstuffs

See private message.

$42.5 USD em 3 dias
(34 Avaliações)
5.4

2 freelancers estão ofertando em média $49 para este trabalho

hdpamara

See private message.

$55.25 USD in 3 dias
(4 Comentários)
2.5