electrotecnia e computação!

Phoca Gallery Migrator Joomla! 1.5 1.7

Phoca Gallery é um componente de galeria de imagens para joomla CMS! As recentes alterações ao sistema Joomla fazem com que nem todos os desenvolvedores de software para esse CMS consigam acompanhar as constantes mudanças, assim são muitos os scripts que deixam de ter suporte para as novas versões. No caso da Phoca Gallery, existe uma versão para a nova versão de Joomla 1.7, no entanto não existe um script de migração capaz de tornar a galeria de imagens para joomla 1.5 compatível com joomla 1.7.

Como não é previsível que este script de migração venha a existir, deixo aqui uma das formas de conseguir que a sua Phoca Gallery para joomla 1.5 funcione em joomla 1.7.

1) Instale a última versão do componente Phoca Gallery no joomla 1.7

2) Abra o phpMyAdmin e execute a seguinte query.

(Nota: j17_ é o prefixo das tabelas em joomla 1.7, caso não seja esse o prefixo que está a utilizar altere-o no código em baixo)

DROP TABLE `j17_phocagallery`;

DROP TABLE `j17_phocagallery_categories`;

DROP TABLE `j17_phocagallery_comments`;

DROP TABLE `j17_phocagallery_img_comments`;

DROP TABLE `j17_phocagallery_img_votes`;

DROP TABLE `j17_phocagallery_img_votes_statistics`;

DROP TABLE `j17_phocagallery_user`;

DROP TABLE `j17_phocagallery_votes`;

DROP TABLE `j17_phocagallery_votes_statistics`;

CREATE TABLE `j17_phocagallery` LIKE `jos_phocagallery`;

create TABLE `j17_phocagallery_categories` LIKE `jos_phocagallery_categories`;

CREATE TABLE `j17_phocagallery_comments` LIKE `jos_phocagallery_comments`;

CREATE TABLE `j17_phocagallery_img_comments` LIKE `jos_phocagallery_img_comments`;

CREATE TABLE `j17_phocagallery_img_votes` LIKE `jos_phocagallery_img_votes`;

CREATE TABLE `j17_phocagallery_img_votes_statistics` LIKE `jos_phocagallery_img_votes_statistics`;

CREATE TABLE `j17_phocagallery_user` LIKE `jos_phocagallery_user`;

CREATE TABLE `j17_phocagallery_votes` LIKE `jos_phocagallery_votes`;

CREATE TABLE `j17_phocagallery_votes_statistics` LIKE `jos_phocagallery_votes_statistics`;

INSERT INTO `j17_phocagallery` SELECT * FROM `jos_phocagallery`;

INSERT INTO `j17_phocagallery_categories`SELECT * FROM `jos_phocagallery_categories`;

INSERT INTO `j17_phocagallery_comments` SELECT * FROM `jos_phocagallery_comments`;

INSERT INTO `j17_phocagallery_img_comments` SELECT * FROM `jos_phocagallery_img_comments`;

INSERT INTO `j17_phocagallery_img_votes` SELECT * FROM `jos_phocagallery_img_votes`;

INSERT INTO `j17_phocagallery_img_votes_statistics` SELECT * FROM `jos_phocagallery_img_votes_statistics`;

INSERT INTO `j17_phocagallery_user` SELECT * FROM `jos_phocagallery_user`;

INSERT INTO `j17_phocagallery_votes` SELECT * FROM `jos_phocagallery_votes`;

INSERT INTO `j17_phocagallery_votes_statistics` SELECT * FROM `jos_phocagallery_votes_statistics`;

ALTER TABLE `j17_phocagallery` ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`, ADD COLUMN `exttype` TINYINT(1) NOT NULL DEFAULT '0' AFTER `extid`, ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `exth`;

ALTER TABLE `j17_phocagallery_categories` ADD COLUMN `extfbuid` int(11) NOT NULL default '0' AFTER `extauth`, ADD COLUMN `extfbcatid` varchar(255) NOT NULL default '' AFTER `extfbuid`, ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`, ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `metadata`;

ALTER TABLE `j17_phocagallery_comments` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;

ALTER TABLE `j17_phocagallery_img_comments` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;

ALTER TABLE `j17_phocagallery_img_votes` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;

ALTER TABLE `j17_phocagallery_img_votes_statistics` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `average`;

ALTER TABLE `j17_phocagallery_user` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;

ALTER TABLE `j17_phocagallery_votes` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;

ALTER TABLE `j17_phocagallery_votes_statistics` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `average`;

ALTER TABLE `j17_phocagallery` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `exth`;

ALTER TABLE `j17_phocagallery_categories` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `metadata`;

ALTER TABLE `j17_phocagallery_comments` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;

ALTER TABLE `j17_phocagallery_img_comments` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;

ALTER TABLE `j17_phocagallery_img_votes` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;

ALTER TABLE `j17_phocagallery_img_votes_statistics` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `average`;

ALTER TABLE `j17_phocagallery_user` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;

ALTER TABLE `j17_phocagallery_votes` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;

ALTER TABLE `j17_phocagallery_votes_statistics` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `average`;