Help Add Item Restriction to a Teleport

[rodrigorkg]

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 "***",
and you will have around "***" ,
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!
*

[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 @ VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @eleport INT
DECLARE @Fee INT
DECLARE @LVL INT

/* Put your settings here */
SET @ = '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 @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 @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 @1 INT SET @1 = (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 @1,0 @X1 @1 @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 @_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) @1)+' 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 @ID 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 @ID,'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) @ID)+' '+'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 @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 @ID @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) @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) @ID)+' '+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 @ID,@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) @ID)+' '+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!'

[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

SELECT ID from _RefObjCommon where Codename128 ='CODE'

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

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

[rodrigorkg]

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 @ VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @eleport INT
DECLARE @Fee INT
DECLARE @LVL INT

/* Put your settings here */
SET @ = '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 @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 @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 @1 INT SET @1 = (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 @1,0 @X1 @1 @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 @_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) @1)+' 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 @ID 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 @ID,'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) @ID)+' '+'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 @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 @ID @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) @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) @ID)+' '+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 @ID,@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) @ID)+' '+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!'

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

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.

[Incendlary]

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.