Add new spawn area for EU & CH Characters

Hello everyone, i want add new spawn area for ch & eu character like "Muhan" Region but not same spot.
eu in spot and ch in other one can!

Please fast.

what about

Code:

---

declare @r int,@x int,@y int,@z int
IF(@RefCharID <= 1932)BEGIN
SET @r = XX SET @x = XX SET @y = XX SET @z = XX
END ELSE BEGIN
SET @r = XX SET @x = XX SET @y = XX SET @z = XX
END

---

Quote:

---

Originally Posted by Muhab Ashraf

what about

Code:

---

declare @r int,@x int,@y int,@z int
IF(@RefCharID <= 1932)BEGIN
SET @r = XX SET @x = XX SET @y = XX SET @z = XX
END ELSE BEGIN
SET @r = XX SET @x = XX SET @y = XX SET @z = XX
END

---

---

Doesn't work. If you can modify query more to work fine please do it asap i need it.

is not a query is on procedure on addlogchar.

Quote:

---

Originally Posted by RenePunik

Doesn't work. If you can modify query more to work fine please do it asap i need it.

---

isn't a query as BadFist said , just add it into _AddNewChar procedure and edit XX into your cords.

Quote:

---

Originally Posted by Muhab Ashraf

isn't a query as BadFist said , just add it into _AddNewChar procedure and edit XX into your cords.

---

I know it's not query, but i have tried to edit Addnewchar producer but i failed.!

Quote:

---

Originally Posted by RenePunik

I know it's not query, but i have tried to edit Addnewchar producer but i failed.!

---

whatever i just told you the way ,it's not my problem that you can't even add this in to your procedure at the right line with changing it's cords!

http://i.imgur.com/L5c8p9f.png

add simply this to your _AddNewChar SP ?

Quote:

---

Originally Posted by Syloxx

http://i.imgur.com/L5c8p9f.png

add simply this to your _AddNewChar SP ?

---

Worked, thank you very much + like :lol:

Quote:

---

Originally Posted by RenePunik

What's query do?!

---

it do what exactly u want

1. take ur char to the place of spawn and logoff it

then open
SRO_VT_SHARD => Programmability => Stored Procedures , find _AddNewChar and right click and press modify

add this query

Quote:

---

---------- Set New Players Place ---START---
Declare @Race TINYINT
SELECT @Race = Country
FROM _RefObjCommon
WHERE ID = @RefCharID

IF @Race = 0 -- CHINA
BEGIN
SELECT @StartRegionID = 25000,
@StartPos_X = 976,
@StartPos_Y = -0.42654,
@StartPos_Z = 118
END
IF @Race = 1 --EURO
BEGIN
SELECT @StartRegionID = 25000,
@StartPos_X = 976,
@StartPos_Y = -0.42654,
@StartPos_Z = 118
END
---------- Set New Players Place ---END---

---

thnx to Syloxx

set @StartRegionID = 25000, " to the region id of ur char at table _Char"
@StartPos_X = 976, to the x pos of ur char at table _Char
@StartPos_Y = -0.42654, to the y pos of ur char at table _Char
@StartPos_Z = 118 to the z pos of ur char at table _Char
and execute