[9.54] The Forgotten Server v0.2.13pl1 (Mystic Spirit), updated with Patch Level 1!

[Mark]

A newer version is available:
http://otland.net/f18/9-60-9-61-forgotten-server-v0-2-14-mystic-spirit-166619/


If you still want to download 0.2.13pl1, the download links are below:

 

[Hani]

Kool!

 

[Polat Alemdar]

nice

 

[Fallen]

Approved

nice

,,),,

 

[Indenpedens]

Fallen why so mad

 

[Amiroslo]

niceee

 

[Luffy]

Yes! time to go ingame >: D

- - - Updated - - -

 

[Amiroslo]

Damnnnnn

 

[Mr.Bela]

Oo Wow ++Rep

 

[vTune]

Wow awesome! Thanks

 

[Erikas Kontenis]

Very well, good to see 0.2.13

 

[Zysen]

Thanks Talaturen

 

[Indenpedens]

dammit tfs 0.2 is the biggest shit
haha

 

[Pandarohoo]

Recently downloaded 0.2 because I heard it had some good reputation when it comes to stability, but I'm having some problems starting it up !

Once I'm done with configuring the database by using mysql and not sqlite, and then try to login this error occur and it says that my acc/pass is invalid.

Did this query to remove the error, but it doesn't remove the problem with invalid acc/pass error when trying to login, it works perfect to login to the acc manager with sqlite but not to the account you may create at him.

ALTER TABLE `accounts` ADD
`name` VARCHAR(32) NOT NULL DEFAULT '';

Any help?

 

[Evan]

@up

I don't know how to update the mysql, but I fixed the problem by editing the sql file.

Changes:

CREATE TABLE `accounts`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`password` VARCHAR(255) /* VARCHAR(32) for MD5*/ NOT NULL DEFAULT '',
	`type` INT NOT NULL DEFAULT 1,
	`premdays` INT NOT NULL DEFAULT 0,
	`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
	`key` VARCHAR(20) NOT NULL DEFAULT '0',
	`email` VARCHAR(255) NOT NULL DEFAULT '',
	`blocked` TINYINT(1) NOT NULL DEFAULT FALSE,
	`warnings` INT NOT NULL DEFAULT 0,
	`group_id` INT NOT NULL DEFAULT 1,
	PRIMARY KEY (`id`),
	FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE = InnoDB;

to:

CREATE TABLE `accounts`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(32) NOT NULL DEFAULT '',
	`password` VARCHAR(255) /* VARCHAR(32) for MD5*/ NOT NULL DEFAULT '',
	`type` INT NOT NULL DEFAULT 1,
	`premdays` INT NOT NULL DEFAULT 0,
	`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
	`key` VARCHAR(20) NOT NULL DEFAULT '0',
	`email` VARCHAR(255) NOT NULL DEFAULT '',
	`blocked` TINYINT(1) NOT NULL DEFAULT FALSE,
	`warnings` INT NOT NULL DEFAULT 0,
	`group_id` INT NOT NULL DEFAULT 1,
	PRIMARY KEY (`id`),
	FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE = InnoDB;

ALSO

INSERT INTO `accounts` VALUES (1, '1', 1, 65535, 0, '0', '', 0, 0, 1);

to:

INSERT INTO `accounts` VALUES (1, '1', '1', 1, 65535, 0, '0', '', 0, 0, 1);

 

[Pandarohoo]

@up

I don't know how to update the mysql, but I fixed the problem by editing the sql file.

Thank you, sent you some reputation =3

edit: talkactions? I do only see a few included in the talkactions.xml and when I try to say etc /b ingame it says "you can not execute this command"?

 

[demas]

one error.

[05/07/2012 01:46:17] Saving server...
[05/07/2012 01:46:17] OTS_SQLITE3_PREPARE(): SQLITE ERROR: unrecognized token: "x'010004000002" (UPDATE "players" SET "level" = 35, "group_id" = 1, "vocation" = 3, "health" = 455, "healthmax" = 455, "experience" = 603780, "lookbody" = 68, "lookfeet" = 76, "lookhead" = 78, "looklegs" = 39, "looktype" = 128, "lookaddons" = 0, "maglevel" = 0, "mana" = 440, "manamax" = 440, "manaspent" = 0, "soul" = 100, "town_id" = 1, "posx" = 32368, "posy" = 32233, "posz" = 7, "cap" = 975, "sex" = 1, "lastlogin" = 1341463507, "lastip" = 16777343, "conditions" = x'010004000002

 

[Wavoz]

Awesome! Thank you!!

 

[Nightimarez]

Changing the death loss in config doesn't work. Not even having it set to 0 or 5 with blessings.

 

[izaak]

thanks man , nice work