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?