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?

[Terabit]

ServerID : Demonsetup.ini

[RonaldinhoR9]

hmm in what part of demonsetup?

[Terabit]

I already give the clue please try by yourself

[lluozai]

INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 134217730) <--- can make a Ex for me see?

[WireShark]

INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 134217730) <--- can make a Ex for me see?

for example you have a value of ServerID = 123456 then

change the script for your config
INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 123456) -- this is it

+rep or likes if help

[lluozai]

for example you have a value of ServerID = 123456 then

change the script for your config
INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 123456) -- this is it

thanks you WireShark

[sdprust]

kickass newbie,
old thread, but only noticed now that he has ressurrected.
If anyone still interested on doing this, with some knowledge about SQL it is pretty easy:
Just use a trigger to automate the process of changing the user's position once it is filled for the first time with a valid value.
( There is already a sql instruction to do that in the above posts, just implement it on a trigger ).
Ps: This should be done on MS-SQL Server... no changes in server/cliente files are needed.

[sdprust]

kickass newbie,
old thread, but only noticed now that he has ressurrected.
If anyone still interested on doing this, with some knowledge about SQL it is pretty easy:
Just use a trigger to automate the process of changing the user's position once it is filled for the first time with a valid value.
( There is already a sql instruction to do that in the above posts, just implement it on a trigger ).
Ps: This should be done on MS-SQL Server... no changes in server/cliente files are needed.

Well, I had to do it last week and it is actually easier than what I proposed, cause there is already a stored procedure that you just have to modify. If anyone still interested:
Modify the InsertChar (or something like that) Stored Procedure, adding the ServerID (Zone) in the following line, like already stated by some people here:
INSERT INTO CharInfoEx (UID, ServerID) VALUES (@UID, 134217730)

Now, to set a different spawn location for Human and Akkan, set a condition for the Character Nation before adding it to the database (INSERT command), where Nation 0 is Human and Nation 1 is Akkan:
IF Nation = 0
BEGIN
PointX = <The X Coordinate for Humans goes here>
PointY = ...
PointZ = ...
END
ELSE
BEGIN
PointX = <The X Coordinate for Akkan goes here>
PointY = ...
PointZ = ...
END