الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**Spicoo** · 25-02-2015, 12:51 PM

عاوز qure add new Teleport بتاع داتا بيز Evolutiuon

**Hamza FiGo** · 25-02-2015, 12:56 PM

تمت الموافقة

جرب دول كدة لقيتهم عندي غير التاني ممكن يكون منهم

كود:

USE SRO_VT_SHARD


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,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_'+@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',@link)
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,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES
(1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@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,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,@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,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,@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,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,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,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!'

كود:

USE SRO_VT_SHARD 
Go 
DECLARE @UNIQUE VARCHAR (129) 
DECLARE @CHARNAME VARCHAR (64) 
DECLARE @mindealy INT 
DECLARE @maxdelay int 
DECLARE @INITRADIUS INT 
DECLARE @RADIUS int 
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1 

/* put your settings here */ 
SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table 
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z 
SET @mindealy = 60  -- Minimum time before appears in seconds 
SET @maxdelay = 120  -- Maximum time before appears in seconds 
SET @INITRADIUS = 100  -- Radius around spot unique can generated at 
SET @RADIUS = 500  -- Radius around spot Unique can move in 
/* end of settings area */ 

/* get ID of mob by code name */ 
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE) 

SET IDENTITY_INSERT Tab_RefTactics ON 
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES 
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE) 
SET IDENTITY_INSERT Tab_RefTactics OFF 

SET IDENTITY_INSERT Tab_RefHive ON 
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES 
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE) 
SET IDENTITY_INSERT Tab_RefHive OFF 

/* get position coordinates of your character */ 

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) 

SET IDENTITY_INSERT Tab_RefNest ON 
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES 
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0) 
SET IDENTITY_INSERT Tab_RefNest OFF 


print '' 
print '' 
print 'Done!'

**Spicoo** · 25-02-2015, 01:04 PM

مشكور يا استاذ حمزه وجاري التجربه والرد

**Hamza FiGo** · 25-02-2015, 01:10 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Spicoo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

مشكور يا استاذ حمزه وجاري التجربه والرد

يا مسهل

**Spicoo** · 25-02-2015, 06:36 PM

للاسف مش هوا ياريت تشوف الي كونت شغال انتا بيه انا خلصت السيرفر و مش فاضل غير التلبورت

**Hamza FiGo** · 25-02-2015, 06:49 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Spicoo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

للاسف مش هوا ياريت تشوف الي كونت شغال انتا بيه انا خلصت السيرفر و مش فاضل غير التلبورت

معلش سؤال بس هو مش شغال بمعني اية علشان مش فاكر الايرور اللي كان بيجي. لو صورة كدة ممكن نعدل علي الــ Query وانا قلبت اللاب مش لاقية للاسف غير دول

**™ EgY_KhaN ™** · 26-02-2015, 06:06 AM

جرب الكواري دي ياباشا انا مجربها وشغاله معايا تمام

#منقولة

اقتباس:

USE SRO_VT_SHARD

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!'

**Spicoo** · 26-02-2015, 03:29 PM

يا باشا هو الكويري ايلى ممكن يشتغل بس فيه erorr انا جبتلك صوره ليه
دا الكيويري

اقتباس:

USE SRO_VT_SHARD

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 = 'dd',
@refChar_2 = 'Danger',
@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);

ودي الصور

**Spicoo** · 26-02-2015, 03:31 PM

معلومه انا عملت بيه تلبورت هو وفيه erorr ودخلت الجيم ملقيتش حاجه

**gameman** · 26-02-2015, 06:36 PM

طب متشتغل manual

**Spicoo** · 26-02-2015, 07:33 PM

وضح اكتر

**Spicoo** · 27-02-2015, 12:09 AM

استاذ حمزه شوف الكويري الي انا حطتهولك فوق وتحته الصور من فضلك

**TalatSaad** · 27-02-2015, 12:12 AM

انت ليه مش راضي تقبل الموضوع بتاعي يا حمزه

**TalatSaad** · 27-02-2015, 12:12 AM

اللعبه مش راضيه تفتح بيقولي check

**Hamza FiGo** · 27-02-2015, 12:20 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة TalatSaad عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

انت ليه مش راضي تقبل الموضوع بتاعي يا حمزه

علشان اسم الموضوع مخالف يا باشا

اعمل موضوع واعمل اسم الموضوع علي حسب المشكلة تكتب اسم المشكلة يعني

واظن انك عملت اكونت جديد وعملت موضوع . وانا قبلتة علشان انبة عليك للقوانين

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Quere How To Clean Data Base ^_^	Hector_	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	8	31-07-2023 12:49 AM
Quere	Spicoo	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	4	21-06-2015 11:00 PM
طلب Quere	Spicoo	قسم المواضيع المكررة و المخالفة	0	25-02-2015 12:11 PM
طلب Quere	resident	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	8	31-08-2014 12:25 AM
طلب Quere	resident	قسم المواضيع المكررة و المخالفة	4	28-04-2014 11:58 PM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟