![]() |
#4 | |||||||||||
![]() ![]()
|
اقتباس:
بص انا هاظبتلك الكويري بس اهم حاجة اتأكد من ان ال SRO_VT_ACCOUNT اسمها كده عندك ف ال sql بمعني ممكن تكون انت مغيرها و ده الكويري صح USE SRO_VT_ACCOUNT_TTablya] /* Add Unique Spot] * 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_MAXIGAME_KARA_KING_MOLE' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'Revolution' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 3600 -- Minimum time before appears in seconds SET @maxdelay = 4200 -- Maximum time before appears in seconds SET @INITRADIUS = 20 -- Radius around spot unique can generated at SET @RADIUS = 70 -- Radius around spot Unique can move in /* end of settings area */ /* get ID of mob by code name */ Declare @MOBID int SET @43994 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @51264 SET IDENTITY_INSERT Tab_RefTactics ON INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2, DiversionBasisData3,DiversionBasisData4,DiversionB asisData5,DiversionBasisData6,DiversionBasisData7, DiversionBasisData8,btDiversionKeepBasis,Diversion KeepBasisData1,DiversionKeepBasisData2,DiversionKe epBasisData3,DiversionKeepBasisData4,DiversionKeep BasisData5,DiversionKeepBasisData6,DiversionKeepBa sisData7, DiversionKeepBasisData8,btKeepDistance,KeepDistanc eData,btTraceType,btTraceBoundary,TraceData,btHomi ngType,HomingData,btAggressTypeOnHoming,btFleeType ,dwChampionTacticsID,AdditionOptionFlag,szDescStri ng128) 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,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,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,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) 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!' |
|||||||||||
![]() |
الكلمات الدليلية |
بدون |
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
أدوات الموضوع | |
انواع عرض الموضوع | تقييم هذا الموضوع |
|
|