Mob Rate increase

06/28/2014 00:38 ILowe#1
hello

How do I make a lot of mobs being spam
06/28/2014 10:38 Zodiao#2
If that's what you mean:
PHP Code:
USE [SRO_VT_SHARD]

UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount * 2 
WHERE dwtacticsid = 'TACTICS ID HERE' 
06/28/2014 10:56 ILowe#3
all rise?
06/28/2014 12:24 Zodiao#4
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..
06/28/2014 13:37 Syloxx#5
Quote:
Originally Posted by Sir*EviL View Post
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 ?

Code:
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
06/28/2014 13:47 ILowe#6
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 ?
06/28/2014 13:50 Syloxx#7
1st is full wasted

2nd ignore some monsters dont know wich monsters

maybe some uniques but my is still better
06/28/2014 15:21 Zodiao#8
Quote:
Originally Posted by ILowe View Post
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%'))) 
06/28/2014 15:35 Syloxx#9
Quote:
Originally Posted by Sir*EviL View Post
@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

[Only registered and activated users can see links. Click Here To Register...]
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 ;)
06/28/2014 15:39 Zodiao#10
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? :)
06/28/2014 15:52 ILowe#11
My head was thoroughly confused .
Which one should I use?