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

09/18/2014 23:11 bares1993#1

Hey Guys.....

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

hints would be nice also ...

thanks

regards

09/19/2014 01:12 Exo#2

PHP Code:


			
DECLARE @Name VARCHAR (Max)

DECLARE @CHARNAME VARCHAR (64)

DECLARE @minlv INT

DECLARE @maxlv int



SET @Name = 

SET @CHARNAME =

SET @minlv = 95  

SET @maxlv = 999  





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

Then go get the new line from _RefOptionalTeleport and add it here

Quote:

Media/server_dep/silkroad/textdata/refoptionalteleport.txt

btw #wrongsection

09/19/2014 03:12 PortalDark#3

#moved to correct section

09/19/2014 08:51 bares1993#4

Thanks so much guys (Y)

and about wrong section ... i am sorry

09/24/2014 02:05 ipause#5

Quote:

Originally Posted by xExorcist

PHP Code:

DECLARE @Name VARCHAR (Max) DECLARE @CHARNAME VARCHAR (64) DECLARE @minlv INT DECLARE @maxlv int SET @Name = SET @CHARNAME = SET @minlv = 95 SET @maxlv = 999 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')

Then go get the new line from _RefOptionalTeleport and add it here

btw #wrongsection

thnx