• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Database from TFS 0.3 to 0.2

siwy696

New Member
Joined
Jul 28, 2008
Messages
59
Reaction score
0
Location
Poland
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?
 
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
 
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:

Code:
	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
 
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???
 
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 :D! no errors in console ;-)
 
Back
Top