Changing Start Location

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