Decrease your server mobs from lv 1 to lv 50 only ! by Project X team

[Divnto]

use SRO_VT_SHARD

update Tab_RefNest
set dwMaxTotalCount = dwMaxTotalCount /2
where dwTacticsID in
(select dwTacticsID from Tab_RefTactics where dwObjID in
(select ID from _RefObjCommon where CodeName128 like '%mob_eu%' and Service = '1' and Link in ( select ID from _RefObjChar where Lvl between '3' and '50') and
CodeName128 not like '%NPC%'
or CodeName128 like '%mob_CH%'and Service = '1' and Link in ( select ID from _RefObjChar where Lvl between '2' and '50')
and CodeName128 not like '%NPC%'
or CodeName128 like '%mob_ca%'and Service = '1' and Link in ( select ID from _RefObjChar where Lvl between '2' and '50')
and CodeName128 not like '%NPC%'
or CodeName128 like '%mob_wc%'and Service = '1' and Link in ( select ID from _RefObjChar where Lvl between '2' and '50')
and CodeName128 not like '%NPC%'
or CodeName128 like '%mob_kt%'and Service = '1' and Link in ( select ID from _RefObjChar where Lvl between '2' and '50')
and CodeName128 not like '%NPC%'))

[MentaL]

[hos00]

well , if it works then it`s would be of a great value at least for me ...

thanks , keep sharing

[catalystr]

if i changed "2" "50" to >> "2" "100"
it will decrease mobs spawn for level 2 to 100 ? :/