PHP Code:
USE SRO_VT_SHARD
DECLARE [MENTION=2110853]teleport[/MENTION] VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE [MENTION=333751]Ownt[/MENTION]eleport INT
DECLARE @Fee INT
DECLARE [MENTION=1331661]Required[/MENTION]LVL INT
/* Put your settings here */
SET [MENTION=2110853]teleport[/MENTION] = 'unique_area1' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = '[GM]WildOne' -- Teleport position
SET @CHARNAME2 = 'Road' -- Spawn position after teleport
SET [MENTION=333751]Ownt[/MENTION]eleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 50000 -- Gold amount to Pass the teleport
SET [MENTION=1331661]Required[/MENTION]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_' [MENTION=2110853]teleport[/MENTION])
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1 [MENTION=2110853]teleport[/MENTION]);
RETURN;
END
DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE [MENTION=7723533]region1[/MENTION] INT SET [MENTION=7723533]region1[/MENTION] = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE [MENTION=1524007]pos[/MENTION]X1 INT SET [MENTION=1524007]pos[/MENTION]X1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE [MENTION=1837537]posy[/MENTION]1 INT SET [MENTION=1837537]posy[/MENTION]1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE [MENTION=1914174]posz[/MENTION]1 INT SET [MENTION=1914174]posz[/MENTION]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,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1,@MAXOBJ,'STORE_' [MENTION=2110853]teleport[/MENTION] [MENTION=2110853]teleport[/MENTION],'xxx','SN_STORE_' [MENTION=2110853]teleport[/MENTION],'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 [MENTION=7723533]region1[/MENTION],0 [MENTION=1524007]pos[/MENTION]X1 [MENTION=1837537]posy[/MENTION]1 [MENTION=1914174]posz[/MENTION]1,0,0,50,50,30,0,'quest\ins_quest_teleport.bsr','xxx','xxx','xxx','xxx',@link)
SET IDENTITY_INSERT _RefObjCommon OFF
print ''
print 'Add the following line to teleportbuilding.txt [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_' [MENTION=2110853]teleport[/MENTION]+' ' [MENTION=2110853]teleport[/MENTION]+' xxx '+'SN_STORE_' [MENTION=2110853]teleport[/MENTION]+' 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) [MENTION=7723533]region1[/MENTION])+' 0 '+CONVERT(varchar(max) [MENTION=1524007]pos[/MENTION]X1)+' '+CONVERT(varchar(max) [MENTION=1837537]posy[/MENTION]1)+' '+CONVERT(varchar(max) [MENTION=1914174]posz[/MENTION]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 [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
print ''
print '1 '+'SN_STORE_' [MENTION=2110853]teleport[/MENTION]+' ' [MENTION=2110853]teleport[/MENTION]
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 [MENTION=3975794]worldi[/MENTION]D INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
DECLARE [MENTION=1184112]region[/MENTION]2 INT SET [MENTION=1184112]region[/MENTION]2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE [MENTION=1524007]pos[/MENTION]X2 INT SET [MENTION=1524007]pos[/MENTION]X2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE [MENTION=1837537]posy[/MENTION]2 INT SET [MENTION=1837537]posy[/MENTION]2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE [MENTION=1914174]posz[/MENTION]2 INT SET [MENTION=1914174]posz[/MENTION]2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)
INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES
(1,@MAXTELID,'GATE_' [MENTION=2110853]teleport[/MENTION],'STORE_' [MENTION=2110853]teleport[/MENTION],@MAXOBJ,'SN_STORE_' [MENTION=2110853]teleport[/MENTION] [MENTION=1184112]region[/MENTION]2 [MENTION=1524007]pos[/MENTION]X2 [MENTION=1837537]posy[/MENTION]2 [MENTION=1914174]posz[/MENTION]2,30,0,0 [MENTION=3975794]worldi[/MENTION]D,1,0)
print ''
print 'Add the following line to teleportdata.txt [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_' [MENTION=2110853]teleport[/MENTION]+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_' [MENTION=2110853]teleport[/MENTION]+' '+CONVERT(varchar(max) [MENTION=1184112]region[/MENTION]2)+' '+CONVERT(varchar(max) [MENTION=1524007]pos[/MENTION]X2)+' '+CONVERT(varchar(max) [MENTION=1837537]posy[/MENTION]2)+' '+CONVERT(varchar(max) [MENTION=1914174]posz[/MENTION]2)+' 30 0 0 '+CONVERT(varchar(max) [MENTION=3975794]worldi[/MENTION]D)+' 1 0'
print ''
print ''
IF [MENTION=1331661]Required[/MENTION]LVL = 0
BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1 [MENTION=333751]Ownt[/MENTION]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,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1,@MAXTELID [MENTION=333751]Ownt[/MENTION]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 [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) [MENTION=333751]Ownt[/MENTION]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) [MENTION=333751]Ownt[/MENTION]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,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1 [MENTION=333751]Ownt[/MENTION]eleport,@MAXTELID,@Fee,0,0,0,1 [MENTION=1331661]Required[/MENTION]LVL,999,0,0,0,0,0,0,0,0,0,0,0,0)
print ''
print ''
print 'Add the following line to teleportlink.txt [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) [MENTION=333751]Ownt[/MENTION]eleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max) [MENTION=1331661]Required[/MENTION]LVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
print ''
print 'Done!'
