Mob Rate increase

[ILowe]

hello

How do I make a lot of mobs being spam

[Zodiao]

If that's what you mean:

PHP Code:

USE [SRO_VT_SHARD]

UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount * 2 
WHERE dwtacticsid = 'TACTICS ID HERE' 


[ILowe]

all rise?

[Zodiao]

If you want to double all spawns:

PHP Code:

USE [SRO_VT_SHARD]

UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount * 2 


If you want to triple it

PHP Code:

USE [SRO_VT_SHARD]

UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount * 3 


and so on..

[Syloxx]

Originally Posted by Sir*EviL

If you want to double all spawns:

PHP Code:

USE [SRO_VT_SHARD]

UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount * 2 


If you want to triple it

PHP Code:

USE [SRO_VT_SHARD]

UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount * 3 


and so on..

jup, increase the mobs for the uniques also... and u call ur self db editor ?

DECLARE @Rate INT = 1, --Set your rate here
	@Level INT = 90 --Set Max Level Here
		
UPDATE Tab_RefNest SET dwMaxTotalCount*=@Rate
FROM Tab_RefNest N
INNER JOIN Tab_RefTactics T
ON N.dwTacticsID = T.dwTacticsID
INNER JOIN _RefObjCommon C
ON C.ID = T.dwObjID
INNER JOIN _RefObjChar RC
ON RC.ID = C.Link
WHERE C.Rarity=0 AND RC.Link<=@Level

my query is better then the other queries but not perfect, this query should also increase the max count for the title quests and fgw mobs etc...

if u want a perfect query add me skype and i´ll sell u one

my skype: TheSodiku

but if u dont wanna pay dont add me

[ILowe]

PHP Code:

Update [SRO_VT_SHARD].[dbo].[Tab_RefNest]
Set dwMaxTotalCount = dwMaxTotalCount * 3  
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics] 
Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where CodeName128 LIKE '%MOB%') ) 


PHP Code:

USE SRO_VT_SHARD
UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount*10
WHERE dwTacticsID NOT BETWEEN 41000 AND 43860 
AND dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1  
WHERE dwdelaytimemax=21600;  ; 


Which of these is ideal
Two different, but the same function code
Which one should you use ?

[Syloxx]

1st is full wasted

2nd ignore some monsters dont know wich monsters

maybe some uniques but my is still better

[Zodiao]

Originally Posted by ILowe

all rise?

@Syloxx

Also want a perfect code for mobs?
here you are

PHP Code:

UPDATE Tab_refnest
set dwmaxtotalcount= dwmaxtotalcount * 2 --2 for double
where dwtacticsid in(select dwtacticsid from tab_reftactics where
dwobjid in(select ID from _refobjcommon where codename128 like '%MOB%' and Rarity ='0' and codename128 not like '%_L3' and codename128 not like '%_L2' and codename128 not like '%GOD%')) 


This should be it..

And this to check what you are disabling:

PHP Code:

SELECT * FROM  _RefObjCommon
where ID IN(select Dwobjid from Tab_RefTactics
where dwtacticsid in(select dwtacticsid from tab_reftactics where
dwobjid in(select ID from _refobjcommon where codename128 like '%MOB%' and Rarity ='0' and codename128 not like '%_L3' and codename128 not like '%_L2' and codename128 not like '%GOD%'))) 


[Syloxx]

Originally Posted by Sir*EviL

@Syloxx

Also want a perfect code for mobs?
here you are

PHP Code:

UPDATE Tab_refnest
set dwmaxtotalcount= dwmaxtotalcount * 2 --2 for double
where dwtacticsid in(select dwtacticsid from tab_reftactics where
dwobjid in(select ID from _refobjcommon where codename128 like '%MOB%' and Rarity ='0' and codename128 not like '%_L3' and codename128 not like '%_L2')) 


This should be it..

And this to check what you are disabling:

PHP Code:

SELECT * FROM  _RefObjCommon
where ID IN(select Dwobjid from Tab_RefTactics
where dwtacticsid in(select dwtacticsid from tab_reftactics where
dwobjid in(select ID from _refobjcommon where codename128 like '%MOB%' and Rarity ='0' and codename128 not like '%_L3' and codename128 not like '%_L2'))) 


ur code is shit


as u can see L2 / L3 is everytime Ratity=3 so u dont need to ignore this

and... u also increase the rates for quest mobs / fgw etc

[Zodiao]

I guess you haven't seen the code again, i edited it before you post it
also what are you trying to prove here, Mr. Pro?

[ILowe]

My head was thoroughly confused .
Which one should I use?