TrinityCore 采集量增加及可叠加物品叠加量增加SQL语句

UPDATE item_template SET stackable = 9999 where stackable > 1 ;      /*所有堆叠数大于1的改为9999*/

UPDATE item_template SET stackable ='9999' WHERE ( entry ='6265') ;         /*灵魂碎片堆叠数改为9999*/

UPDATE skinning_loot_template SET maxcount = 20 ;        /*剥皮最大产量为20单位*/

UPDATE fishing_loot_template SET maxcount = 20 ;      /* 钓鱼*/

UPDATE prospecting_loot_template SET maxcount = 20 ;         /*采矿附产品（孔雀石、虎眼石、等）最大产量为20单位*/

UPDATE creature_loot_template SET maxcount ='20' WHERE item ='2589' ;         /*亚麻布最大产量为20*/
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='2592' ;         /*毛料*/
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='4306' ;         /*丝绸*/
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='4338' ;        /*