分享一个魔兽世界服务器给装备增加镶嵌孔和嘉奖的语句

分享一个魔兽世界服务器给装备增加镶嵌孔和嘉奖的语句
UPDATE item_template SET socketcolor_1 = 8 WHERE class = 2 and socketcolor_1 = 0;
UPDATE item_template SET socketcolor_2 = 2 WHERE class = 2 and socketcolor_2 = 0;
UPDATE item_template SET socketcolor_3 = 4 WHERE class = 2 and socketcolor_3 = 0;
UPDATE item_template SET socketcolor_1 = 8 WHERE class = 4 and socketcolor_1 = 0;
UPDATE item_template SET socketcolor_2 = 2 WHERE class = 4 and socketcolor_2 = 0;
UPDATE item_template SET socketcolor_3 = 4 WHERE class = 4 and socketcolor_3 = 0;
UPDATE item_template SET socketbonus = 3621 WHERE class = 2 and socketbonus = 0;
UPDATE item_template SET socketbonus = 3696 WHERE class = 4 and socketbonus = 0;

正文:感化是给一切孔不敷3个的装备都增加改成3个镶嵌孔，并有镶嵌嘉奖。