APROVED
My Query's :
PHP Code:
USE [SRO_VT_SHARD] --By nukertube
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_CH_TIGERWOMAN'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_OA_URUCHI'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_KK_ISYUTARU'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TK_BONELORD'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_EU_KERBEROS'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_AM_IVY'))
PHP Code:
USE [SRO_VT_SHARD]
GO
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_TOMBGENERAL'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_TOMBGENERAL_CLON'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_TOMBGENERAL_CLON2'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_TOMBGENERAL_CLON3'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_SNAKEGENERAL'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_SNAKEGENERAL_CLON'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_SNAKEGENERAL_CLON2'))
Update Tab_RefNest Set dwmaxtotalcount = 1 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TQ_SNAKEGENERAL_CLON3'))