How to make new teleport spot for "Reverse Return Scroll"

[bares1993]

Hey Guys.....


does someone know how i can add new teleport spot for Reverse Return Scroll ?

hints would be nice also ...

thanks

regards

[MentaL]

[Caosfox]

_refoptionalteleport table

[thebigbody]

that's the query

USE SRO_VT_SHARD

DECLARE @Name VARCHAR (Max)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @minlv INT
DECLARE @maxlv int
/* put your settings here */
SET @Name = 'MUOI_ZONE_1' -- Name of LOL
SET @CHARNAME = 'Ric' -- Character name from _Char table to get mob position X Y Z
SET @minlv = 95 -- Minimum lvl to reverse
SET @maxlv = 999 -- Maximum lvl to reverse
/* end of settings */

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)
INSERT INTO _RefOptionalTeleport ([Service] ,[ObjName128] ,[ZoneName128] ,[RegionID] ,[Pos_X] ,[Pos_Y] ,[Pos_Z] ,[WorldID] ,[RegionIDGroup] ,[MapPoint] ,[LevelMin] ,[LevelMax] ,[Param1] ,[Param1_Desc_128] ,[Param2] ,[Param2_Desc_128] ,[Param3] ,[Param3_Desc_128])
VALUES (1,@Name ,'SN_'+ @Name , @REGION ,@POSX ,@POSY ,@POSZ, 1 ,-1 ,1 ,@minlv ,@maxlv, -1,'xxx' ,-1 ,'xxx' ,-1 ,'xxx')

PRINT 'Added Sucessfully'

then open _RefOptionalTeleport] table and copy the point line from it and put it in Media >> Server_dep >> Silkroad >> Textdata >> refoptionalteleport.txt then import

[bares1993]

thanks !