Upgrade
From Travsync
Contents
|
Upgrading travsync
Administrators with access to web and database account can upgrade to newer version of travsync. Usually it can be done by coping some php files via ftp client, but some times database need to be changed To make it easier here are instruction how to switch to newer version About versions check Changelog page
Before upgrade make copy of travsync directory and your current mysql database!
to 2010.03 from 2009.11
the same instruction as upgrade to 2010.02_dev version:
manually:
- add new line to inc_config.php: define('INSTANCE_ID', 'TS_4b1d22111test'); - Upgrade database: ALTER TABLE `travsync_spieler_ip` CHANGE `sip` `sip` INT UNSIGNED NOT NULL; (NOTICE: all IP already stored in table will be unreadable)
After that replace all files (but not inc_config.php)
to 2010.03 from 2009.12_dev, 2010_01_dev 2010_02_dev
Just replace all files (but not inc_config.php)
to 2009.12_dev, 2010_01_dev 2010_02_dev from 2009.11
Those three version were for developing some functionality. To upgrade from 2009.11 instructions please check link:
manually:
- add new line to inc_config.php: define('INSTANCE_ID', 'TS_4b1d22111test'); Upgrade database: Code:
ALTER TABLE `travsync_spieler_ip` CHANGE `sip` `sip` INT UNSIGNED NOT NULL; (NOTICE: all IP already stored in table will be unreadable)
After that replace all files (but not inc_config.php)
to 2009.11 from 2009.06 or 2009.06
as next version after 2009.06 is 2009.11 with different privileges system there is some more work to be done when upgrading from working installation
There are two version of 2009.11:
1) version with extra code for automatic upgrade from 2009.06 and any 2009.09 to 2009.11
2) pure 2009.11
Both works the same way
ad. 1) This is version with extra code to upgrade database and definitions to 2009.11
http://travsync.byethost17.com/data/test_upgrade_to_travsync200911 (testing version)
Upgrading instruction (http://travsync.byethost17.com/wiki/index.php/Upgrade)
- Backup database and php files from existing installation - replace all files with new from test_upgrade_to_travsync200911 !!! DON'T replace inc_config.php !!! - log in as travsync administrator - will be redirected to upgrade_to_travsync200911.php module
- chose upgrade
- in case of script execution error ask on forum for help
after upgrade you can use upgrade_to_travsync200911 version or replace it with pure 2009.11
ad. 2) pure 2009.11
Get installation files http://travsync.byethost17.com/data/travsync2009.11.zip and install as always ;)
to 2009.09 from 2009.06
2009.09 is developing version as it has changed privileges system. Don't do upgrade if you not sure what are you doing!!!
there is no upgrade script, script will be done for 2009.11 version
import users to travsync 2009.09 from 2009.06
This can be done if you have access to phpmyadmin
I. One way - on working database - Upgrade using the same database you are working on now
You can copy files from 2009.09 to new directory and after altering database use both version at the same time - but remove older version as soon as new will work good enough
1) make database backup - there are many tutorials how to do it, i.e.: http://fragments.turtlemeat.com/mysql-database-backup-restore-phpmyadmin.php
2. Alter database tables: run this sql code on your database, change prefix to fit your installation
2.1)
ALTER TABLE `travsync_spieler` ADD `rights` VARCHAR( 120 ) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0' COMMENT 'entry for rights system' AFTER `rechte`
2.2)
ALTER TABLE `travsync_teams` ADD `teamVisible` INT NOT NULL DEFAULT '0' COMMENT 'troops summary visible to members' AFTER `teamName` , ADD `teamDescription` VARCHAR( 240 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'description' AFTER `teamVisible`
3) create at least one administrator
edit administrator record from spielers table and change `rights` to '3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0'
4) add to file inc_config.php copied from 2009.06 version this definitions
define('DISABLE_TRAVMAP', 0); define('DEBUG_TRANSLATION',1); define('DISABLE_SITTER_VISIBILTY', 0);
II. Second Way - working on copy of database - your databases limit on web hosting must allow it
1) make database backup 2) make database copy to new name using phpmyadmin
all steps the same as above - don't forget that file inc_config.php copied from 2009.06 must have new database name declared!
after some time you can remove 'rechte' field and 2009.06 installation
to 2009.06 from 2009.03
In 2009.06 some PHP files were changed
1. Replace files
- Get version 2009.06 of travsync
- Replace all changed files in main directory (BUT NOT inc_config.php !!)
to 2009.03 from 2009.02
In 2009.03 some PHP files were changed
1. Replace files
- Get version 2009.03 of travsync
- Replace all changed files in main directory (BUT NOT inc_config.php !!)
to 2009.02 from 2009.01
In 2009.02 database was changed, almost all PHP files were changed and some new images added. For upgrade database there is upgrade_200901_to_200902.php file.
1. Replace files
- Get version 2009.02 of travsync
- Replace all changed files in main directory
- And new image files to img subdirectory
2. Changes to database
- Log in as an administrator into travsync.
- Manually use address: http://youttravsyncwebaddress/upgrade_200901_to_200902.php
- Remove upgrade_200901_to_200902.php file
- Only if script doesn't work - change database manually (prefix: trooptool_):
Create new table: reservation
CREATE TABLE IF NOT EXISTS `trooptool_reservation` ( `rid` int(11) NOT NULL auto_increment, `sid` int(11) NOT NULL, `x` int(11) NOT NULL default '0', `y` int(11) NOT NULL default '0', `created` datetime NOT NULL, `description` varchar(240) NOT NULL, `type` varchar(2) NOT NULL, `status` int(11) NOT NULL, `adminChangeSid` int(11) NOT NULL COMMENT 'who changed status', `adminChangeDate` datetime NOT NULL COMMENT 'last status change', PRIMARY KEY (`rid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
Create new table: notices
CREATE TABLE IF NOT EXISTS `trooptool_notices` ( `noticeID` int(11) NOT NULL auto_increment, `noticeDetails` varchar(480) NOT NULL, `sid` int(11) NOT NULL, `noticeLastChange` datetime NOT NULL, `noticeOrder` int(11) NOT NULL COMMENT 'dispalying order ', PRIMARY KEY (`noticeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Alter table spieler
ALTER TABLE `trooptool_spieler` ADD `imType` VARCHAR(12) CHARACTER SET utf8 NOT NULL COMMENT \'IM type\' AFTER `im`;
