[CLUB]
[/CLUB]
SQL:
USE [SRO_VT_SHARD]
UPDATE _RefDropClassSel_Alchemy_ATTRStone SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0, ProbGroup8 = 0, ProbGroup9 = 0, ProbGroup10 = 0, ProbGroup11 = 0 , ProbGroup12 = 0, ProbGroup13 = 0, ProbGroup14 = 0, ProbGroup15 = 0, ProbGroup16 = 0, ProbGroup17 = 0, ProbGroup18 = 0, ProbGroup19 = 0, ProbGroup20 = 0
UPDATE _RefDropClassSel_Alchemy_MagicStone SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0, ProbGroup8 = 0, ProbGroup9 = 0, ProbGroup10 = 0, ProbGroup11 = 0 , ProbGroup12 = 0, ProbGroup13 = 0, ProbGroup14 = 0, ProbGroup15 = 0, ProbGroup16 = 0, ProbGroup17 = 0, ProbGroup18 = 0, ProbGroup19 = 0, ProbGroup20 = 0
UPDATE _RefDropClassSel_Alchemy_Tablet SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0, ProbGroup8 = 0, ProbGroup9 = 0, ProbGroup10 = 0, ProbGroup11 = 0 , ProbGroup12 = 0
UPDATE _RefDropClassSel_Ammo SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0
UPDATE _RefDropClassSel_Cure SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0, ProbGroup8 = 0, ProbGroup9 = 0, ProbGroup10 = 0, ProbGroup11 = 0 , ProbGroup12 = 0,ProbGroup13 = 0, ProbGroup14 = 0
UPDATE _RefDropClassSel_Equip SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0, ProbGroup8 = 0, ProbGroup9 = 0, ProbGroup10 = 0, ProbGroup11 = 0 , ProbGroup12 = 0, ProbGroup13 = 0, ProbGroup14 = 0, ProbGroup15 = 0, ProbGroup16 = 0, ProbGroup17 = 0, ProbGroup18 = 0, ProbGroup19 = 0, ProbGroup20 = 0, ProbGroup21 = 0, ProbGroup22 = 0, ProbGroup23 = 0, ProbGroup24 = 0, ProbGroup25 = 0 , ProbGroup26 = 0 , ProbGroup27 = 0, ProbGroup28 = 0, ProbGroup29 = 0, ProbGroup30 = 0, ProbGroup31 = 0, ProbGroup32 = 0, ProbGroup33 = 0, ProbGroup34 = 0, ProbGroup35 = 0, ProbGroup36 = 0
UPDATE _RefDropClassSel_RareEquip SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0, ProbGroup8 = 0, ProbGroup9 = 0, ProbGroup10 = 0, ProbGroup11 = 0 , ProbGroup12 = 0, ProbGroup13 = 0, ProbGroup14 = 0, ProbGroup15 = 0, ProbGroup16 = 0, ProbGroup17 = 0, ProbGroup18 = 0, ProbGroup19 = 0, ProbGroup20 = 0, ProbGroup21 = 0, ProbGroup22 = 0, ProbGroup23 = 0, ProbGroup24 = 0, ProbGroup25 = 0 , ProbGroup26 = 0 , ProbGroup27 = 0, ProbGroup28 = 0, ProbGroup29 = 0, ProbGroup30 = 0, ProbGroup31 = 0, ProbGroup32 = 0, ProbGroup33 = 0, ProbGroup34 = 0, ProbGroup35 = 0, ProbGroup36 = 0
UPDATE _RefDropClassSel_Recover SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0
UPDATE _RefDropClassSel_Reinforce SET ProbGroup1 = 0, ProbGroup2 = 0
UPDATE _RefDropClassSel_Scroll SET ProbGroup1 = 0, ProbGroup2 = 0,ProbGroup3 = 0
update _RefDropGold SET DropProb=0,GoldMin=0,GoldMax=0
update _RefMonster_AssignedItemDrop SET DropRatio='0'
update _RefDropItemAssign SET Prob_Relative=0,Prob_Absolute=0,DropCount=0
UPDATE _RefObjCommon SET DecayTime=0 WHERE CodeName128='ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ARMOR_B'
UPDATE _RefObjCommon SET DecayTime=0 WHERE CodeName128='ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B'
UPDATE _RefObjCommon SET DecayTime=0 WHERE CodeName128='ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_SHIELD_B' UPDATE _RefObjCommon SET DecayTime=0 WHERE CodeName128='ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ACCESSARY_B'
UPDATE _RefObjCommon SET DecayTime=0 WHERE CodeName128='ITEM_ETC_SCROLL_RETURN_02'
Truncate Table _RefMonster_AssignedItemRndDrop
Truncate Table _RefDropItemGroup