Changing Start Location

[sperati]

Hello all, im developing a 2240 server, and i changed some maps zones, but i have a problem, i dont know how to change the start location of a character when he login before the character has been created. Can any help me please?

[MentaL]

[Terabit]

.....

[sperati]

in RespawnScript.txt you can change the area you will respaw if u die, not if the character is created. :/

[riksk]

try databases :D

sorry i dont know what one, soon ill look here if its fixed

look databases with your spawn coords, so u can change and see what happens ^^

[sperati]

at part2_zodiac exist a table named CHARPOS, yeah if i change the value there the character will change his pos, but that initial value i must change, i dont know with part of the server side or game side put that information there :/

[vitorex]

yeah .....

[ryllady]

INSERT INTO CharPos (CID, LastPointX, LastPointY, LastPointZ, SavePointX, SavePointY, SavePointZ) VALUES (@CID, @PointX, @PointY, @PointZ, @PointX, @PointY, @PointZ)

change position xyz on start


INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 134217730)


change zone

[gmryl2stone]

INSERT INTO CharPos (CID, LastPointX, LastPointY, LastPointZ, SavePointX, SavePointY, SavePointZ) VALUES (@CID, @PointX, @PointY, @PointZ, @PointX, @PointY, @PointZ)

change position xyz on start


INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 134217730)


change zone

bro tell me where this file Sql Part2_Zodiac Then

[RonaldinhoR9]

Terabit, i found hre, but that lines that ryllady said, we need to add them, or need to modify exixsting ones? Where to find them? zodiac part?

[Terabit]

Terabit, i found hre, but that lines that ryllady said, we need to add them, or need to modify exixsting ones? Where to find them? zodiac part?

DB Part2_Zodiac > Stored Procedures > Properties InsertChar

[RonaldinhoR9]

I found the table dbo.InsertChar, but dont have nothing like that thing ryllady wrote. So, i suppose that need to be add that lines into the INSERTCHAR table, right?

[Terabit]

INSERT INTO CharPos (CID, LastPointX, LastPointY, LastPointZ, SavePointX, SavePointY, SavePointZ) VALUES (@CID, @PointX, @PointY, @PointZ, @PointX, @PointY, @PointZ)

change position xyz on start


INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 134217730)


change zone

add this.

[RonaldinhoR9]

Hmm so, if i want game start in zone 5, for example, with 2 spots, 1 for human, and 1 for akkans, wha i need to to? where you see in red ServerID, put 5? and about the xyz, positios, wereh i put the values i want to the char log in the map?

[Terabit]

Check at your demonsetup you will see there... and for respawn position at respawnscript

[RonaldinhoR9]

where at demonsetup? the normal respawns, i see at respawnscript, but the first login, that coordinates, are in the respawnscript too?