الموقع العربي الاول للعبة Silkroad Online

- - مساعده صغيره (https://silkroad4arab.com/vb/showthread.php?t=477116)

مساعده صغيره

انا باستخدم الكويري ده في اضافة اليونك في مكان معين

كود PHP:


		
			
USE SRO_VT_SHARD

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 













SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique Code

SET @CHARNAME = 'Char Name HERE' -- Character Name

SET @mindealy = 60 -- Seconds before the minimum period of time appears

SET @maxdelay = 120 -- Appears seconds before the maximum time

SET @INITRADIUS = 100 -- Unique appears around the spot 

SET @RADIUS = 500 -- Unique moves up in the spot (area) around the

















Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE) 













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) 













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) 

























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) 











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)

















 

 

print 'Succesfully added. (frkn)'

الكويري شغال تمام بس انا عايز حد يعدلي علي الكويري يخليلي اليونك ينزل كل ساعه ونصف

يعني 90 دقيقه

ويخليه مايتحركش بعيد عن المكان اللي انا احددهولو

ارجو الرد بس تكون متأكد

انت هاتاخد الكويري Copy وتعدل عليه وتحوطو في رد

بس

:please:

خود ده

كود:

USE SRO_VT_SHARD



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'

SET @CHARNAME = 'CHARNAME'

SET @mindealy = 5400 

SET @maxdelay = 5400 

SET @INITRADIUS = 100 

SET @RADIUS = 500 



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



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

وى ده لو انتا عاوز
تغير اى وقت يونك

كود PHP:


		
			
Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 

(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'HERE PUT THE UNIQUE CODE'))