Jangan mob's : select * from _RefObjCommon where CodeName128 like '%MOB_CH%' Downhang mob's 1 : select * from _RefObjCommon where CodeName128 like '%MOB_WC%' Donwhang mob's 2 : select * from _RefObjCommon where CodeName128 like '%MOB_OA%' Hotan mob's : select * from _RefObjCommon where CodeName128 like '%MOB_KT%' Karakoram mob's : select * from _RefObjCommon where CodeName128 like '%MOB_KK%' Taklamakan mob's : select * from _RefObjCommon where CodeName128 like '%MOB_TK%' Downhang Cave mob's : select * from _RefObjCommon where CodeName128 like '%MOB_DH%' Roc Mountain mob's : select * from _RefObjCommon where CodeName128 like '%MOB_RM%' Constantinople mob's : select * from _RefObjCommon where CodeName128 like '%MOB_EU%' Samarkand mob's 1 : select * from _RefObjCommon where CodeName128 like '%MOB_AM%' Samarkand mob's 2 : select * from _RefObjCommon where CodeName128 like '%MOB_CA%' Jangan cave mob's : select * from _RefObjCommon where CodeName128 like '%MOB_TQ%' Alexandria mob's : select * from _RefObjCommon where CodeName128 like '%MOB_SD%' Jupiter mob's : select * from _RefObjCommon where CodeName128 like '%MOB_JUPITER%' Forgotten World mob's : select * from _RefObjCommon where CodeName128 like '%MOB_GOD%'
DECLARE @RARE FLOAT = 0.75 /*_#2 = 200%, 1 = 100%, 0.5 = 50%*/UPDATE TRN SET TRN.dwMaxTotalCount *= @RARE FROM Tab_RefNest TRN JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.IDWHERE ROC.CodeName128 LIKE 'MOB%'AND ROC.Rarity = 0AND dwDelayTimeMin < 600AND dwDelayTimeMin != 0AND dwMaxTotalCount != 1