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:
Printable View
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
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?
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?
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?
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