Upgrade Instructions

[blank]

With every release you should upload/overwrite EVERY file except config.php to make sure you have the very latest files.

Some versions have some DB changes while some others do not. We try our best to only have DB changes in the 1.X releases and not any of the 1.X.X releases. Occasionally there is a bug fix that may require the DB to be modified.

If you are using V1.3x and want to upgrade to V1.5.5 you will have to follow ALL of the instructions for upgrading to V1.4 THEN to V1.5

Upgrading From 1.6.5 to 1.7
ALTER TABLE `config` ADD `link_tracker` TEXT NOT NULL ;
ALTER TABLE `config` ADD `search_log` TINYINT( 1 ) NOT NULL ;

ALTER TABLE `config`
DROP `number_of_latest_game`,
DROP `number_of_most_popular_games`,
DROP `games_per_row`,
DROP `games_per_category`,
DROP `category_games_per_row`;

CREATE TABLE `admin_settings` (
`add_game` TINYINT NOT NULL DEFAULT '1',
`add_movie` TINYINT NOT NULL DEFAULT '1',
`add_plug` TINYINT NOT NULL DEFAULT '1',
`add_custom` TINYINT NOT NULL DEFAULT '1'
) ENGINE = MYISAM

CREATE TABLE `search_log` (
`if` INT NOT NULL AUTO_INCREMENT ,
`term` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `if` ) ,
UNIQUE (
`if`
)
) ENGINE = MYISAM


Upgrading From 1.6 to 1.6.5
UPDATE `config` SET `template_folder` = '1'
ALTER TABLE `config` CHANGE `template_folder` `template_folder` TINYINT NOT NULL DEFAULT '1'
ALTER TABLE `config` ADD `ref_log` TINYINT( 1 ) NOT NULL ;

Upgrading From 1.5.6 to V1.6
ALTER TABLE `templates` ADD `timestamp` INT NOT NULL ;
ALTER TABLE `templates` ADD `styleid` tinyint(1) NOT NULL default '1',
ALTER TABLE `config` ADD `page_list` MEDIUMINT NOT NULL ;
ALTER TABLE `config` ADD `flash_uploader` TINYINT NOT NULL DEFAULT '1';
ALTER TABLE `config` ADD `adult_check` TINYINT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `config` ADD `ffmpeg` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `ads` ADD `video` tinyint(4) NOT NULL default '0';
ALTER TABLE `media` ADD `duration` BIGINT NOT NULL DEFAULT '0';

Upgrading to 1.5.5
UPDATE `ads` SET `size` = '300x250' WHERE `size` = '250';
UPDATE `ads` SET `size` = '468x60' WHERE `size` = '468';
UPDATE `ads` SET `size` = '120x600' WHERE `size` = '160';
INSERT INTO `ads` VALUES(15, '120x120', 1, '<img src=templates/images/120x120.gif>', 0);
INSERT INTO `ads` VALUES(16, '120x120', 0, '<img src=templates/images/120x120.gif>', 0);

Upgrading to 1.5
you can either run upgrade.php?action=upgrade2 or you can use phpmyadmin to import upgrade.sql

Upgrading to V1.4:
ALTER TABLE `config` ADD `color` VARCHAR( 15 ) NOT NULL DEFAULT 'blue',
ADD `addthis` TEXT NOT NULL ,
ADD `useruploads` TINYINT( 1 ) NOT NULL DEFAULT '1';

Upgrading to V1.3:
ALTER TABLE `ratings` CHANGE `gid` `id` MEDIUMINT( 7 ) NOT NULL DEFAULT '0'
ALTER TABLE `ratings` CHANGE `votes` `total_votes` MEDIUMINT( 10 ) NOT NULL DEFAULT '0'
ALTER TABLE `ratings` CHANGE `total` `total_value` MEDIUMINT( 10 ) NOT NULL DEFAULT '0'
ALTER TABLE `ratings` DROP `rating`;
ALTER TABLE `ratings` ADD `used_ips` LONGTEXT NOT NULL ;
ALTER TABLE `ratings` ADD `rating` DECIMAL( 2, 1 ) NOT NULL DEFAULT '0.0';
ALTER TABLE `links` ADD `used_ips` LONGTEXT NOT NULL ;


Upgrading to V1.2 you will need to run this SQL Query:

ALTER TABLE `config`
ADD `box_1` TINYINT NOT NULL DEFAULT '1',
ADD `box_2` TINYINT NOT NULL DEFAULT '1',
ADD `box_3` TINYINT NOT NULL DEFAULT '1',
ADD `box_4` TINYINT NOT NULL DEFAULT '1',
ADD `box_5` TINYINT NOT NULL DEFAULT '1',
ADD `box_6` TINYINT NOT NULL DEFAULT '1',
ADD `box_7` TINYINT NOT NULL DEFAULT '1';