Add new spawn area for EU & CH Characters

[RenePunik]

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.

[MentaL]

[Muhab Ashraf]

what about

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

[RenePunik]

what about

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.

[BadFist]

is not a query is on procedure on addlogchar.

[Muhab Ashraf]

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.

[RenePunik]

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.!

[Muhab Ashraf]

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!

[Syloxx]

add simply this to your _AddNewChar SP ?

[RenePunik]

add simply this to your _AddNewChar SP ?

Worked, thank you very much + like

[dya2]

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

---------- 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