Help Add Item Restriction to a Teleport

Hello gentlemen
*Presence of your help to add restriction of a specific item such as a Key to a portal
And the
*Second method is to create a time of duration within this portal after entering the zone

*Example you use the portal, it consumes your item "XXX",
and you will have around "XXX" ,
minutes within this area,
after this time you will be returned back to the city of origin!

*
Thanks for your attention !
I apologize for my bad english use google translator for this!
*:)

there is a query released
if u don't know to make it manual !

just search for it !

It's basically on _RefTeleLink
You can check the existing lines to learn from them, let's say for example the Gate of Ruler (Roc) contains the restriction to prevent entrance unless you have the required item. (That's a suggestion not related to the subject though)

Subject: Edit Restrict1 to 4 instead of 0 or whatever the number is, Data1_1 is the item ID (You can get it from _RefObjCommon), Restrict2 to 5 and Data2_1 is the same ID of Data1_1

ID Selection Query

Quote:

SELECT ID from _RefObjCommon where Codename128 ='CODE'

If you're lazy, use this query.
Teleport Restriction (ITEM) Query

Quote:

UPDATE _RefTeleLink set Restrict1='4', Data1_1='Item ID', Restrict2='5', Data2_1='Item ID' where OwnerTeleport='RefTeleport Table ID'

Quote:

Originally Posted by Dracula Untold there is a query released if u don't know to make it manual ! just search for it !  Spoiler USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */ DECLARE @[Only registered and activated users can see links. Click Here To Register...] VARCHAR (64) DECLARE @CHARNAME1 VARCHAR (30) DECLARE @CHARNAME2 VARCHAR (30) DECLARE @[Only registered and activated users can see links. Click Here To Register...]eleport INT DECLARE @Fee INT DECLARE @[Only registered and activated users can see links. Click Here To Register...]LVL INT /* Put your settings here */ SET @[Only registered and activated users can see links. Click Here To Register...] = '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 @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]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_' @[Only registered and activated users can see links. Click Here To Register...]) BEGIN raiserror('The stated teleportname of %s is already exist!',11,1 @[Only registered and activated users can see links. Click Here To Register...]); RETURN; END DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1 DECLARE @[Only registered and activated users can see links. Click Here To Register...]1 INT SET @[Only registered and activated users can see links. Click Here To Register...]1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @[Only registered and activated users can see links. Click Here To Register...]X1 INT SET @[Only registered and activated users can see links. Click Here To Register...]X1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @[Only registered and activated users can see links. Click Here To Register...]1 INT SET @[Only registered and activated users can see links. Click Here To Register...]1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @[Only registered and activated users can see links. Click Here To Register...]1 INT SET @[Only registered and activated users can see links. Click Here To Register...]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_' @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...],'xxx','SN_STORE_' @[Only registered and activated users can see links. Click Here To Register...],'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 @[Only registered and activated users can see links. Click Here To Register...]1,0 @[Only registered and activated users can see links. Click Here To Register...]X1 @[Only registered and activated users can see links. Click Here To Register...]1 @[Only registered and activated users can see links. Click Here To Register...]1,0,0,50,50,30,0,'quest\ins_quest_teleport.bsr','x xx','xxx','xxx','xxx',@link) SET IDENTITY_INSERT _RefObjCommon OFF print '' print 'Add the following line to teleportbuilding.txt @[Only registered and activated users can see links. Click Here To Register...]_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_' @[Only registered and activated users can see links. Click Here To Register...]+' ' @[Only registered and activated users can see links. Click Here To Register...]+' xxx '+'SN_STORE_' @[Only registered and activated users can see links. Click Here To Register...]+' 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) @[Only registered and activated users can see links. Click Here To Register...]1)+' 0 '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]X1)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]1)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]_dep\silkroad\textdata folder' print '' print '1 '+'SN_STORE_' @[Only registered and activated users can see links. Click Here To Register...]+' ' @[Only registered and activated users can see links. Click Here To Register...] print '' print '' SET IDENTITY_INSERT _RefObjStruct ON INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES (@LINK,0) SET IDENTITY_INSERT _RefObjStruct OFF DECLARE @[Only registered and activated users can see links. Click Here To Register...]ID INT = (SELECT MAX (ID) FROM _RefTeleport)+1 DECLARE @[Only registered and activated users can see links. Click Here To Register...]D INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2) DECLARE @[Only registered and activated users can see links. Click Here To Register...]2 INT SET @[Only registered and activated users can see links. Click Here To Register...]2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @[Only registered and activated users can see links. Click Here To Register...]X2 INT SET @[Only registered and activated users can see links. Click Here To Register...]X2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @[Only registered and activated users can see links. Click Here To Register...]2 INT SET @[Only registered and activated users can see links. Click Here To Register...]2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @[Only registered and activated users can see links. Click Here To Register...]2 INT SET @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]ID,'GATE_' @[Only registered and activated users can see links. Click Here To Register...],'STORE_' @[Only registered and activated users can see links. Click Here To Register...],@MAXOBJ,'SN_STORE_' @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]2 @[Only registered and activated users can see links. Click Here To Register...]X2 @[Only registered and activated users can see links. Click Here To Register...]2 @[Only registered and activated users can see links. Click Here To Register...]2,30,0,0 @[Only registered and activated users can see links. Click Here To Register...]D,1,0) print '' print 'Add the following line to teleportdata.txt @[Only registered and activated users can see links. Click Here To Register...]_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]ID)+' '+'GATE_' @[Only registered and activated users can see links. Click Here To Register...]+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_' @[Only registered and activated users can see links. Click Here To Register...]+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]2)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]X2)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]2)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]2)+' 30 0 0 '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]D)+' 1 0' print '' print '' IF @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]eleport @[Only registered and activated users can see links. Click Here To Register...]ID,@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 @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]eleport)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]ID)+' '+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) @[Only registered and activated users can see links. Click Here To Register...]ID)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]eleport @[Only registered and activated users can see links. Click Here To Register...]ID,@Fee,0,0,0,1 @[Only registered and activated users can see links. Click Here To Register...]LVL,999,0,0,0,0,0,0,0,0,0,0,0,0) print '' print '' print 'Add the following line to teleportlink.txt @[Only registered and activated users can see links. Click Here To Register...]_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]eleport)+' '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]ID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max) @[Only registered and activated users can see links. Click Here To Register...]LVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0' print '' END print '' print 'Done!'

Thank you for trying to help me more. This was not my problem.

Quote:

Originally Posted by Incendlary It's basically on _RefTeleLink You can check the existing lines to learn from them, let's say for example the Gate of Ruler (Roc) contains the restriction to prevent entrance unless you have the required item. (That's a suggestion not related to the subject though) Subject: Edit Restrict1 to 4 instead of 0 or whatever the number is, Data1_1 is the item ID (You can get it from _RefObjCommon), Restrict2 to 5 and Data2_1 is the same ID of Data1_1 ID Selection Query If you're lazy, use this query. Teleport Restriction (ITEM) Query

thank you sir you helped me a lot,
besides this solution wanted to know also how to add a maximum time within the zone
for example after entering the zone
the system count a maximum time of 5 minutes
and then expel me from inside it to the starting point
Thank you again so far.

Quote:

Originally Posted by rodrigorkg Thank you for trying to help me more. This was not my problem. thank you sir you helped me a lot, besides this solution wanted to know also how to add a maximum time within the zone for example after entering the zone the system count a maximum time of 5 minutes and then expel me from inside it to the starting point Thank you again so far.

That, I can't help you on it.. It's based on filter packets which will require the region ID and packets necessary after teleportation, sadly, these features won't be free so you either search for a filter and ask its creator to implement the features you want.