|
• الانـتـسـاب » May 2011
|
• رقـم العـضـويـة » 87623
|
• المشـــاركـات » 389
|
• الـدولـة » ღ♥AleXAnDrIa♥ღ
|
• الـهـوايـة » Sro , PSro And Pc Programes
|
• اسـم الـسـيـرفـر »
|
• الـجـنـس »
|
• نقـاط التقييم » 12
|
|
|
الى انا اعرقو ازاى تحت moob او Unique فى مكان معين و دة ال Query
اقتباس:
USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */
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
|
و دة علشان تجيب ال ID بتاع ال moob من ال RefObjCommon
اقتباس:
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,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
|
|