Replacing map in the [8.54-8.57] The Forgotten Server v0.2.7 (Mystic Spirit)

[Stingy]

Hey, i recently downloaded this "server" and i have no idea what to do.. i've opened ports.. players have been able to join etc.. but i've tried a few times to replace the orignal map in the forgotten server.. and never suceeded.. please help me :/

if you had some tutorial or something it would be perfect.. thanks



Edit: i also don't have any "players" map in my data map.. so i can't make any chars gamemasters or something.

And please don't flame.. i'm new with hosting ot's

 

[picachu]

Replace the map of ots/data/world

And in config.lua
Change: mapName = "Test"
for

mapName = "Your map name in data/world"

 

[Stingy]

ok thanks, testing it out now

Edit: but wont it say like "temple position is wrong" or something like that? if i try to login

 

[Stingy]

Alright, i replaced my map for a evolution clean map.. and now i want to place my account manager in the right spot since it says "temple position is wrong" how do i do that? i got my map editor up and the map is imported

thanks



Edit: I also don't know how to create a gm since i don't have a "players" folder :/

 

[picachu]

Go to your database and change to:

Pos X = 0
Pos Y = 0
Pos Z = 0
Town_id = 1

 

[Henkos]

ok thanks, testing it out now

Edit: but wont it say like "temple position is wrong" or something like that? if i try to login

SQL Query:

UPDATE players SET posx = ---, posy = ---, posz = ---, town_id = 1;

Change the "---" to the temple position you got.(Where the new player should spawn.)

 

[Stingy]

ye, thanks bro.. but i gotta find that "update players set pozx" line first.. lol

which map should i look in ?

 

[picachu]

Man, go to your databas, and then enter in SQL Query
then put:

UPDATE players SET posx = ---, posy = ---, posz = ---, town_id = 1;

 

[Henkos]

ye, thanks bro.. but i gotta find that "update players set pozx" line first.. lol

It's a SQL Query, you "import" it to your database:blink:

 

[Stingy]

i see i see.. lets check if i can do this shit

 

[Stingy]

So.. what i gotta do is .. Enter my database, find like a document named "SQL query"? and add my temple position?

 

[Stingy]

Please guys.. keep helping me out .. i totally fucking suck at this

 

[Manimecker]

You need to execute the SQL Query, just like that.

 

[Stingy]

The thing is .. all i can find s a document named "forgottenserver" a sql-file
and this was some shit i found in it that looked almost the same as your line.
CREATE TABLE `players`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`group_id` INT NOT NULL DEFAULT 1,
`account_id` INT NOT NULL DEFAULT 0,
`level` INT NOT NULL DEFAULT 1,
`vocation` INT NOT NULL DEFAULT 0,
`health` INT NOT NULL DEFAULT 150,
`healthmax` INT NOT NULL DEFAULT 150,
`experience` BIGINT NOT NULL DEFAULT 0,
`lookbody` INT NOT NULL DEFAULT 0,
`lookfeet` INT NOT NULL DEFAULT 0,
`lookhead` INT NOT NULL DEFAULT 0,
`looklegs` INT NOT NULL DEFAULT 0,
`looktype` INT NOT NULL DEFAULT 136,
`lookaddons` INT NOT NULL DEFAULT 0,
`maglevel` INT NOT NULL DEFAULT 0,
`mana` INT NOT NULL DEFAULT 0,
`manamax` INT NOT NULL DEFAULT 0,
`manaspent` INT NOT NULL DEFAULT 0,
`soul` INT UNSIGNED NOT NULL DEFAULT 0,
`town_id` INT NOT NULL DEFAULT 0,
`posx` INT NOT NULL DEFAULT 1000,
`posy` INT NOT NULL DEFAULT 0,
`posz` INT NOT NULL DEFAULT 0,

 

[Manimecker]

No.

Just execute/import this to your database:

UPDATE players SET posx = ---, posy = ---, posz = ---, town_id = 1;

(---, your temple's position)

 

[Stingy]

Execute import??? should i just open my data folder and click ctrl V Or what? right click in the folder ...?

 

[Stingy]

Try to explain better .. please i can't just "import" that to my data folder.. wth ?

 

[Manimecker]

Did you create the database?

 

[Stingy]

I haven't created any database

 

[picachu]

Read this tutorials:

http://otland.net/f137/how-setup-mysql-otservers-80269/
http://otland.net/f137/full-tutorial-how-create-8-54-tibia-ot-77831/
http://otland.net/f137/nothing-full...niform-server-forgotten-server-0-3-6-a-77593/
http://otland.net/f137/how-setup-mysql-database-screenshots-included-last-update-16-7-2009-a-49/