very simple, wear Job. go to your Job Area and kill NPCs and get Coins. go in PTs because it's your lvl and it's hard bla bla bla
the problem here is I can't add the spawn
I'm using 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 [MENTION=353480]minde[/MENTION]aly INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE [MENTION=315411]radius[/MENTION] int
DECLARE [MENTION=298261]maxn[/MENTION]EST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE [MENTION=2570090]maxta[/MENTION]CTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1
/* put your settings here */
SET [MENTION=312344]Unique[/MENTION] = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'asdfasgxc' -- Character name from _Char table to get mob position X Y Z
SET [MENTION=353480]minde[/MENTION]aly = 30 -- Minimum time before appears in seconds
SET @maxdelay = 60 -- Maximum time before appears in seconds
SET @INITRADIUS = 30 -- 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 [MENTION=784159]mobid[/MENTION] int SET [MENTION=784159]mobid[/MENTION] = (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
[MENTION=2570090]maxta[/MENTION]CTICS [MENTION=784159]mobid[/MENTION],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 [MENTION=1524007]pos[/MENTION]X INT SET [MENTION=1524007]pos[/MENTION]X = (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
[MENTION=298261]maxn[/MENTION]EST,@MAXHIVE [MENTION=2570090]maxta[/MENTION]CTICS [MENTION=1184112]region[/MENTION] [MENTION=1524007]pos[/MENTION]X [MENTION=1837537]posy[/MENTION] [MENTION=1914174]posz[/MENTION],0 [MENTION=315411]radius[/MENTION],@INITRADIUS,0 [MENTION=353480]minde[/MENTION]aly,@maxdelay,20,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF
print ''
print ''
print 'Done!'
The Yuno just to prove to myself that it's not the query. so any idea what to do ? and thanks in advance, sorry for my english
