Database from TFS 0.3 to 0.2

[siwy696]

Please help me, i use TFS 0.3 rev. 815 one month ago, i want change to versio 0.2 but i cant lost all characters;/ What can i do?

 

[EvulMastah]

If Im correct, players, accounts, playerstorage, playerspells, playerskills structure hasnt been changed, you can export them from your 0.3 DB and import to your new 0.2 DB ;p

 

[kret]

whats about houses ;-> ? i need to change from 0.3 to 02 too ;{

 

[Wasted]

What you can do is force all the house items to the players depot and then just reset all the houses. People will scavenge over all the unowned houses though.

 

[Pazzur]

I change my OT from 0.3 to 0.2 without losing houses. I suggest you check your doc/CHANGELOG for 0.3 and reverse the SQL queries found at the end.

Obviously test this before doing it on your main database, and make a backup of it first too.

These are the SQL Queries from 0.2 to 0.3 in case you couldn't find them:

	CREATE TABLE `global_storage`
	(
		`key` INT UNSIGNED NOT NULL,
		`value` INT NOT NULL,
		PRIMARY KEY  (`key`)
	) ENGINE = InnoDB;

	ALTER TABLE `accounts` DROP `type`;

	ALTER TABLE `bans` ADD `expired` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

	ALTER TABLE `houses` CHANGE `warnings` `warnings` INT NOT NULL DEFAULT 0;
	ALTER TABLE `houses` ADD `lastwarning` INT UNSIGNED NOT NULL DEFAULT 0;

	ALTER TABLE `groups` ADD `customflags` BIGINT UNSIGNED NOT NULL DEFAULT 0 AFTER `flags`;
	ALTER TABLE `groups` ADD `violationaccess` INT NOT NULL AFTER `access`;
	TRUNCATE TABLE `groups`;
	INSERT INTO `groups` VALUES (1, 'Player', 0, 0, 0, 0, 0, 0);
	INSERT INTO `groups` VALUES (2, 'Tutor', 16809984, 1, 1, 0, 0, 0);
	INSERT INTO `groups` VALUES (3, 'Senior Tutor', 68736352256, 3, 2, 1, 0, 0);
	INSERT INTO `groups` VALUES (4, 'Game Master', 492842123151, 63, 3, 2, 4000, 200);
	INSERT INTO `groups` VALUES (5, 'Community Manager', 542239465466, 1279, 4, 3, 6000, 300);
	INSERT INTO `groups` VALUES (6, 'God', 546534563834, 2047, 5, 3, 8000, 400);

	ALTER TABLE `players` ADD `balance` BIGINT UNSIGNED NOT NULL DEFAULT 0 AFTER `blessings`;
	ALTER TABLE `players` ADD `stamina` BIGINT UNSIGNED NOT NULL DEFAULT 201660000 AFTER `balance`;
	ALTER TABLE `players` CHANGE `loss_experience` `loss_experience` INT NOT NULL DEFAULT 10;
	ALTER TABLE `players` CHANGE `loss_mana` `loss_mana` INT NOT NULL DEFAULT 10;
	ALTER TABLE `players` CHANGE `loss_skills` `loss_skills` INT NOT NULL DEFAULT 10;
	ALTER TABLE `players` ADD `loss_items` INT NOT NULL DEFAULT 10 AFTER `loss_skills`;
	UPDATE `players` SET `loss_experience` = 10, `loss_mana` = 10, `loss_skills` = 10, `loss_items` = 10;

Best of luck,
Pazzur

 

[siwy696]

refre

Refresh, i dont know how do it;/ i want change server from tfs 0.3 to 0.2 and i cant loss my all characters;/

 

[Sasir]

If Im correct, players, accounts, playerstorage, playerspells, playerskills structure hasnt been changed, you can export them from your 0.3 DB and import to your new 0.2 DB ;p

heres exatcly what you need to do ^^

 

[Pazzur]

I think bans have changed to. between 0.2 and 0.3

 

[siwy696]

But how export? when i try import exported database, phpmyadmin say: table accouns is exit!

 

[exrip]

I get the same problem...

 

[Exiled Pain]

Sup everyone...

Two things:

1) @up.... how do you force house items into depot? Is there a way to do this with a command or something??

2) I'm trying to import my database into the new one, but seems to be too big, because it exceeds the 300seg time, and so I get the error and it doesn’t import anything. So the question is how to extend this time for bigger databases? or how to import bigger .sql files? I already have the ALLOW partial import selected, for bigger files, but it’s not working... really need this cause backing up my DB is getting to my nerves cause if the files get to big, I wont be able to import them anyway, so help.

Any pointers plix???

 

[kret]

Hello

Few days ago I change from TFS 0.3 to 0.2 I use DB from 0.3 but i delete 0.3 bans and player_death and create new from 0.2 and all work ! no errors in console ;-)