How Add Unique in Cave Job TEMPLE
Hi all ,
Any Query work to add a certain unique in a Free Room of temple?
IN cave Iam Want Add Daemon Shaitan in Unique room like IMG
http://s30.postimg.org/wf0rylse9/124...27002541_n.jpg
Iam Use this Query and she Execute With Sucess BUT NO WORK . Lines Will add COrrect in tactics , Nest and Hive tablet But Unique no Apear ..
Solution :?
Query:
Code:
USE SRO_VT_SHARD
DECLARE @<i><b><a href="http://forum.ragezone.com/members/2000184350.html" target="_blank">Unique</a></b></i> VARCHAR (129)
DECLARE @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME VARCHAR (64)
DECLARE @<i><b><a href="http://forum.ragezone.com/members/115761.html" target="_blank">MINDE</a></b></i>aly INT
DECLARE @<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>delay int
DECLARE @INITRADIUS INT
DECLARE @<i><b><a href="http://forum.ragezone.com/members/1333411412.html" target="_blank">Radius</a></b></i> int
DECLARE @<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>NEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>HIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @<i><b><a href="http://forum.ragezone.com/members/2000089032.html" target="_blank">maxta</a></b></i>CTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1
/* put your settings here */
SET @<i><b><a href="http://forum.ragezone.com/members/2000184350.html" target="_blank">Unique</a></b></i> = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'anjomal' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'Chaparinha' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'Seheiah' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'Camila' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'Kronnos' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'Tita' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'Reyel' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME = 'Saphira' -- Character name from _Char table to get mob position X Y Z
SET @<i><b><a href="http://forum.ragezone.com/members/115761.html" target="_blank">MINDE</a></b></i>aly = 68400 -- Minimum time before appears in seconds
SET @<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>delay = 68400 -- Maximum time before appears in seconds
SET @INITRADIUS = 75 -- Radius around spot unique can generated at
SET @<i><b><a href="http://forum.ragezone.com/members/1333411412.html" target="_blank">Radius</a></b></i> = 45 -- Radius around spot Unique can move in
/* end of settings area */
/* get ID of mob by code name */
Declare @<i><b><a href="http://forum.ragezone.com/members/1333371673.html" target="_blank">mobi</a></b></i>D int SET @<i><b><a href="http://forum.ragezone.com/members/1333371673.html" target="_blank">mobi</a></b></i>D = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @<i><b><a href="http://forum.ragezone.com/members/2000184350.html" target="_blank">Unique</a></b></i>)
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
@<i><b><a href="http://forum.ragezone.com/members/2000089032.html" target="_blank">maxta</a></b></i>CTICS @<i><b><a href="http://forum.ragezone.com/members/1333371673.html" target="_blank">mobi</a></b></i>D,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 @<i><b><a href="http://forum.ragezone.com/members/2000184350.html" target="_blank">Unique</a></b></i>)
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
@<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>HIVE,0,1,0,0,0,0,1,1 @<i><b><a href="http://forum.ragezone.com/members/2000184350.html" target="_blank">Unique</a></b></i>)
SET IDENTITY_INSERT Tab_RefHive OFF
/* get position coordinates of your character */
DECLARE @<i><b><a href="http://forum.ragezone.com/members/527330.html" target="_blank">region</a></b></i> INT SET @<i><b><a href="http://forum.ragezone.com/members/527330.html" target="_blank">region</a></b></i> = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @<i><b><a href="http://forum.ragezone.com/members/551894.html" target="_blank">Char</a></b></i>NAME)
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
@<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>NEST @<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>HIVE @<i><b><a href="http://forum.ragezone.com/members/2000089032.html" target="_blank">maxta</a></b></i>CTICS @<i><b><a href="http://forum.ragezone.com/members/527330.html" target="_blank">region</a></b></i>,@POSX,@POSY,@POSZ,0 @<i><b><a href="http://forum.ragezone.com/members/1333411412.html" target="_blank">Radius</a></b></i>,@INITRADIUS,0 @<i><b><a href="http://forum.ragezone.com/members/115761.html" target="_blank">MINDE</a></b></i>aly @<i><b><a href="http://forum.ragezone.com/members/447213.html" target="_blank">Max</a></b></i>delay,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF
print ''
print ''
print 'Done!'
/**Because query will not work as it with BR files due to the difference between tables so: **/
