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?![]()
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?![]()
.....
Last edited by Terabit; 19-08-11 at 03:56 PM.
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 .....![]()
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?
Last edited by WireShark; 04-06-16 at 10:45 AM. Reason: addin something
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