Changing Start Location

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? :thumbup:

.....

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

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 ^^

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 :/

yeah .....:cool::cool::cool:

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

Quote:

---

Originally Posted by 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

---

bro tell me where this file Sql Part2_Zodiac Then

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?

Quote:

---

Originally Posted by 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?

---

DB Part2_Zodiac > Stored Procedures > Properties InsertChar

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?

Quote:

---

Originally Posted by 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

---

add this.

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?

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

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

ServerID : Demonsetup.ini

hmm in what part of demonsetup?

I already give the clue please try by yourself

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

Quote:

---

Originally Posted by lluozai

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

Quote:

---

Originally Posted by WireShark

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 :cool:

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.

Quote:

---

Originally Posted by 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