Custom Teleport

[erdgtr]

Hi guys, i added a new teleporter with following query:

 Spoiler

USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */


DECLARE @ VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @eleport INT
DECLARE @Fee INT
DECLARE @LVL INT

/* Put your settings here */
SET @ = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = 'char1' -- Teleport position
SET @CHARNAME2 = 'char2' -- Spawn position after teleport
SET @eleport = 2 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 5000 -- Gold amount to Pass the teleport
SET @LVL = 0 -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport
/* settings area end here */

IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_' @)
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1 @);
RETURN;
END

DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE @ INT SET @ = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @X1 INT SET @X1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @1 INT SET @1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @1 INT SET @1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1

SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName1 28,NameStrID128,DescStrID128,CashItem,Bionic,TypeI D1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarit y,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPic k,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRe pair,CostRevive,CostBorrow,KeepingFee,SellPrice,Re qLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqL evelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCon tain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,S peed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj 128,AssocFileDrop128,AssocFileIcon128,AssocFile1_1 28,AssocFile2_128,Link) VALUES
(1,@MAXOBJ,'STORE_' @ @,'xxx','SN_STORE_' @,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,-1,0,-1,0,-1,0,-1,0,-1 @,0 @X1 @1 @1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx ','xxx','xxx',@link)
SET IDENTITY_INSERT _RefObjCommon OFF

print ''
print 'Add the following line to teleportbuilding.txt @dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_' @+' ' @+' xxx '+'SN_STORE_' @+' xxx 0 0 4 1 1 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 '+CONVERT(varchar(max) @)+' 0 '+CONVERT(varchar(max) @X1)+' '+CONVERT(varchar(max) @1)+' '+CONVERT(varchar(max) @1)+' 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx '+CONVERT(varchar(max),@link)
print ''
print 'Add the following line to textdata_object.txt @dep\silkroad\textdata folder'
print ''
print '1 '+'SN_STORE_' @+' ' @
print ''
print ''

SET IDENTITY_INSERT _RefObjStruct ON
INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES
(@LINK,0)
SET IDENTITY_INSERT _RefObjStruct OFF

DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
DECLARE @D INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
DECLARE @2 INT SET @2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @X2 INT SET @X2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @2 INT SET @2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @2 INT SET @2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)

INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,Ass ocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos _Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGot oResurrectPos,GenWorldID,BindInteractionMask,Fixed Service) VALUES
(1,@MAXTELID,'GATE_' @,'STORE_' @,@MAXOBJ,'SN_STORE_' @ @2 @X2 @2 @2,30,0,0 @D,1,0)

print ''
print 'Add the following line to teleportdata.txt @dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_' @+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_' @+' '+CONVERT(varchar(max) @2)+' '+CONVERT(varchar(max) @X2)+' '+CONVERT(varchar(max) @2)+' '+CONVERT(varchar(max) @2)+' 30 0 0 '+CONVERT(varchar(max) @D)+' 1 0'
print ''
print ''

IF @LVL = 0
BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1 @eleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@MAXTELID @eleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

print ''
print 'Add the following lines to teleportlink.txt @dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) @eleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max) @eleport)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
ELSE BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1 @eleport,@MAXTELID,@Fee,0,0,0,1 @LVL,999,0,0,0,0,0,0,0,0,0,0,0,0)

print ''
print ''
print 'Add the following line to teleportlink.txt @dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) @eleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max) @LVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0'
print ''

END

print ''
print 'Done!'

I got no errors and i added everything succesfully to the media pk2. But now i got this problem.
The new telportstone is there.
The donwhang teleporter shows the linking to my teleporter.
But i cant teleport to my teleporter, neither can i click on my new teleport stone. My cursor is changing but nothing happens when i click on it.
Is there still sth missing on my client? Like on the data or map pk2?

I appreciate every help
kind regards

UPDATE: i changed the teleporter model from: quest\teleport01.bsr to Bldg\Arabia\Bagh_City\bagh_city_portal.bsr. Now everything is working fine, but i dont get it cause quest\teleport01.bsr is working fine for other portals.