[Spicoo]

دا اول كيوري

USE SRO_VT_SHARD /* Add new Teleport By Marwan Abbas */


DECLARE @Teleport VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @OwnTeleport INT
DECLARE @Fee INT
DECLARE @RequiredLVL INT

/* Put your settings here */
SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport
SET @OwnTeleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 50000 -- Gold amount to Pass the teleport
SET @RequiredLVL = 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_'+@Teleport)
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport);
RETURN;
END

DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSZ1 INT SET @POSZ1 = (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_'+@Teleport,@Teleport,'xxx','SN_ STORE_'+@Teleport,'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,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,' quest\teleport01.bsr','xxx','xxx','xxx','xxx',@lin k)
SET IDENTITY_INSERT _RefObjCommon OFF

print ''
print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_'+@Teleport+' '+@Teleport+' xxx '+'SN_STORE_'+@Teleport+' 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),@REGION1)+' 0 '+CONVERT(varchar(max),@POSX1)+' '+CONVERT(varchar(max),@POSY1)+' '+CONVERT(varchar(max),@POSZ1)+' 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 @server_dep\silkroad\textdata folder'
print ''
print '1 '+'SN_STORE_'+@Teleport+'
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 @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSZ2 INT SET @POSZ2 = (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_'+@Teleport,'STORE_'+@Teleport, @MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POS Y2,@POSZ2,30,0,0,@WORLDID,1,0)

print ''
print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_'+@Teleport+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_'+@Teleport+' '+CONVERT(varchar(max),@REGION2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max),@WORLDID)+' 1 0'
print ''
print ''

IF @RequiredLVL = 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,@OwnTeleport,@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,@OwnTeleport,@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 @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+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),@OwnTeleport)+' '+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,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLV L,999,0,0,0,0,0,0,0,0,0,0,0,0)

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

END

print ''
print 'Done!'

ود بيجبلي كدا
والتاني بتاع الاستاز حمزه بيجبلي كدا


ودا كان عندي انا

SET NOCOUNT ON;

Declare @Tel_NAME varchar(128),
@refChar_1 varchar(32),
@refChar_2 varchar(32),
@OwnTeleport int,
@Fee int,
@req_Level int,
@ObjID int,
@RegionID smallint,
@Pos_X real,
@Pos_Y real,
@Pos_Z real,
@ObjLink int,
@TelID int,
@WorldID smallint;
SELECT @Tel_NAME = 'PVP_ZONE5',
@refChar_1 = 'Melrin',
@refChar_2 = 'ALO',
@OwnTeleport = 1,
@Fee = 500,
@req_Level = 0;


IF exists (SELECT 1 FROM dbo._RefObjCommon with(NOLOCK) WHERE CodeName128 = 'STORE_' + @Tel_NAME)
BEGIN
RAISERROR('Stated teleportname %s already exists!', 11, 1, @Tel_NAME);
RETURN;
END


SELECT @RegionID = LatestRegion,
@Pos_X = PosX,
@Pos_Y = PosY,
@Pos_Z = PosZ FROM dbo._Char WHERE CharName16 = @refChar_1;


INSERT INTO dbo._RefObjStruct SELECT 0;
SELECT @ObjLink = @@IDENTITY;


INSERT INTO dbo._RefObjCommon ([Service],CodeName128,ObjName128,OrgObjCodeName128,NameStrI D128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2, TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade, CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair ,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRe vive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1 ,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,R eqLevel3,ReqLevelType4,ReqLevel4,MaxContain,Region ID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale ,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFi leDrop128,AssocFileIcon128,AssocFile1_128,AssocFil e2_128,Link)
VALUES (1,'STORE_'+@Tel_NAME,@Tel_NAME,'xxx','SN_STORE_' + @Tel_NAME,'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,@RegionID,0,@Pos_X,@Pos_Y,@Pos_Z,0,0,50,50,30,0, 'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@Ob jLink)
SELECT @ObjID = @@IDENTITY;


SELECT 'server_dep\silkroad\textdata\teleportbuilding.txt »' 'Destination file', * FROM dbo._RefObjCommon with(NOLOCK) WHERE ID = @ObjID;
SELECT 'server_dep\silkroad\textdata\textdata_object.txt »' 'Destination file', 1, 'SN_STORE_' + @Tel_NAME, '', '', '', '', '', '', '', @Tel_NAME;


SELECT @WorldID = WorldID,
@RegionID = LatestRegion,
@Pos_X = PosX,
@Pos_Y = PosY,
@Pos_Z = PosZ FROM dbo._Char WHERE CharName16 = @refChar_1;


INSERT INTO dbo._RefTeleport ([Service],CodeName128,AssocRefObjCodeName128,AssocRefObjID, ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z ,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectP os,GenWorldID,BindInteractionMask,FixedService)
VALUES (1,'GATE_'+@Tel_NAME,'STORE_'+@Tel_NAME,@ObjID,'SN _STORE_'+@Tel_NAME,@RegionID,@Pos_X,@Pos_Y,@Pos_Z, 30,0,0,@WorldID,1,0);
SELECT @TelID = @@IDENTITY;


SELECT 'server_dep\silkroad\textdata\teleportdata.txt »' 'Destination file', [Service], ID, CodeName128, AssocRefObjID, ZoneName128, GenRegionID, GenPos_X, GenPos_Y, GenPos_Z, GenAreaRadius, CanBeResurrectPos, CanGotoResurrectPos, GenWorldID FROM dbo._RefTeleport with(NOLOCK) WHERE ID = @TelID;


INSERT INTO dbo._RefTeleLink ([Service],OwnerTeleport,TargetTeleport,Fee,RestrictBindMeth od,RunTimeTeleportMethod,CheckResult,Restrict1,Dat a1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,D ata3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5 ,Data5_1,Data5_2)
VALUES (1,@OwnTeleport,@TelID,@Fee,0,0,0,CASE WHEN @req_Level > 0 THEN 1 ELSE 0 END,@req_Level,CASE WHEN @req_Level > 0 THEN 999 ELSE 0 END,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO dbo._RefTeleLink ([Service],OwnerTeleport,TargetTeleport,Fee,RestrictBindMeth od,RunTimeTeleportMethod,CheckResult,Restrict1,Dat a1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,D ata3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5 ,Data5_1,Data5_2)
VALUES (1,@TelID,@OwnTeleport,@Fee,0,0,0,CASE WHEN @req_Level > 0 THEN 1 ELSE 0 END,@req_Level,CASE WHEN @req_Level > 0 THEN 999 ELSE 0 END,0,0,0,0,0,0,0,0,0,0,0,0);

SELECT 'server_dep\silkroad\textdata\teleportlink.txt »' 'Destination file', 1, @OwnTeleport, @TelID, @Fee, 0, 0, 0, CASE WHEN @req_Level > 0 THEN 1 ELSE 0 END, @req_Level, CASE WHEN @req_Level > 0 THEN 999 ELSE 0 END, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 UNION ALL
SELECT 'server_dep\silkroad\textdata\teleportlink.txt »' 'Destination file', 1, @TelID, @OwnTeleport, @Fee, 0, 0, 0, CASE WHEN @req_Level > 0 THEN 1 ELSE 0 END, @req_Level, CASE WHEN @req_Level > 0 THEN 999 ELSE 0 END, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0;


SET NOCOUNT OFF;

RAISERROR('Transaction for teleport %s successfully completed!', 10, 1, @Tel_NAME);

ودا بيجبلي كدا


ودا ال Results

server_dep\silkroad\textdata\teleportbuilding.txt » 1 130 ITEM_CH_BLADE_08_C ?? ???? xxx SN_ITEM_CH_BLADE_08_C SN_ITEM_CH_BLADE_08_C_TT_DESC 0 0 3 1 6 3 180000 0 0 1 1 1 255 3 1 1 1 0 0 3260000 5350 8025 0 9000 1141000 1 72 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\blade_08.bsr item\etc\drop_ch_equip.bsr item\china\weapon\blade_08.ddj xxx xxx 130

server_dep\silkroad\textdata\textdata_object.txt » 1 SN_STORE_Thif Thif

server_dep\silkroad\textdata\teleportdata.txt » 1 130 GATE_JINSI_03x05 0 SN_ZONE_26003 -32763 -15711 549 19794 70 0 0 1

server_dep\silkroad\textdata\teleportlink.txt » 1 1 130 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

server_dep\silkroad\textdata\teleportlink.txt » 1 130 1 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

علي ما اعتقد كدا كل حاجه واظحه يا استاز حمزه