1、炉石0CD
update item_template set spellcooldown_1=1 where entry=6948;
2、装备所有抗性X2
UPDATE item_template SET dmg_min1 = dmg_min1*2;
UPDATE item_template SET dmg_max1 = dmg_max1*2;
3、武器攻击力X2
UPDATE item_template SET dmg_min1 = dmg_min1*2;
UPDATE item_template SET dmg_max1 = dmg_max1*2;
4、所有装备无绑定
UPDATE item_template SET bonding = 0;
5、灵魂碎片可以叠加200个
update item_template set stackable = 200 where entry = 6265;
6、宠物属性强化
update pet_levelstats set hp = hp*50;
update pet_levelstats set mana = mana*2;
update pet_levelstats set armor = armor*5;
update pet_levelstats set str = str*10;
update pet_levelstats set agi = agi*10;
update pet_levelstats set sta = sta*10;
update pet_levelstats set inte = inte*10;
update pet_levelstats set spi = spi*10;
用MYSQL研究了半天没整明白,求好心的大神图解