=======================================================
数据库批量修改命令
UPDATE item_template SET stackable = 99999999 where stackable > 1 ; 这个是改物品叠加数量的 9999999这个可以随意修改
UPDATE gameobject SET spawntimesecs = 5 ; 矿 草药 箱子 刷新时间 单位是秒 5可以随意修改
UPDATE skinning_loot_template SET maxcount = 200 ; 剥皮最大产量为200 数值可以修改
UPDATE fishing_loot_template SET maxcount = 200 ; 钓鱼
下面的是采集产出数量 最高可改为255 中间数值200可以修改
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='2589' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='2592' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='4306' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='4338' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='14047' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='14256' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='21877' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='33470' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='3182' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='4337' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='10285' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='14227' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='21881' ;
UPDATE creature_loot_template SET maxcount ='200' WHERE item ='42253' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2770' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2771' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2772' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2775' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2776' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3858' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='7911' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='10620' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='23424' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='23425' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='23426' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='23427' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='23446' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36909' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36910' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36912' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='765' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2447' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2449' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='785' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2452' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2450' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3820' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='2453' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3369' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3355' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3356' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3357' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3818' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3821' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3358' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='3819' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='8153' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='4625' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='8831' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='8836' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='8838' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='8845' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='8839' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='8846' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='13464' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='13463' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='13465' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='13466' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='13467' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22789' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22785' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22786' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='19726' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='13468' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='19727' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22787' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22788' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22790' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22797' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22793' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22792' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22791' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='22794' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='37921' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36907' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36904' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36901' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36902' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36903' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36906' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36905' ;
UPDATE gameobject_loot_template SET maxcount ='200' WHERE item ='36908' ;