ده بيقلل الوحوش من 1 ~ 50 وممكن تعدل انت فيه برحتك
كود PHP:
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%'))