Hello all
i have add (Sky Temple) in my server and i make it to Jobs only can teleport to it and everything is very good but i have problem with add mobs in it i use this query
And it worked 100% in SQL Without any error but in game mobs don't appeared i dont know why and i really want to fix it !
i have add (Sky Temple) in my server and i make it to Jobs only can teleport to it and everything is very good but i have problem with add mobs in it i use this query
PHP Code:
USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */
DECLARE [MENTION=312344]Unique[/MENTION] VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE [MENTION=315411]radius[/MENTION] 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 [MENTION=312344]Unique[/MENTION] = 'MOB_JUPITER_DEVIL_HELL' -- Unique code name from _RefobjCommon table
SET @CHARNAME = '0100' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 0 -- Minimum time before appears in seconds
SET @maxdelay = 0 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET [MENTION=315411]radius[/MENTION] = 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 = [MENTION=312344]Unique[/MENTION])
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 [MENTION=312344]Unique[/MENTION])
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 [MENTION=312344]Unique[/MENTION])
SET IDENTITY_INSERT Tab_RefHive OFF
/* get position coordinates of your character */
DECLARE [MENTION=1184112]region[/MENTION] INT SET [MENTION=1184112]region[/MENTION] = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE [MENTION=1837537]posy[/MENTION] INT SET [MENTION=1837537]posy[/MENTION] = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE [MENTION=1914174]posz[/MENTION] INT SET [MENTION=1914174]posz[/MENTION] = (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 [MENTION=1184112]region[/MENTION],@POSX [MENTION=1837537]posy[/MENTION] [MENTION=1914174]posz[/MENTION],0 [MENTION=315411]radius[/MENTION],@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF
print ''
print ''
print 'Done!'
