[巫妖王之怒] 分享一个给装备增加镶嵌孔和奖励的语句!!

琴声忧忧

1. 
   
2. UPDATE item_template SET socketcolor_1 = 8 WHERE class = 2 and socketcolor_1 = 0;
   
3. UPDATE item_template SET socketcolor_2 = 2 WHERE class = 2 and socketcolor_2 = 0;
   
4. UPDATE item_template SET socketcolor_3 = 4 WHERE class = 2 and socketcolor_3 = 0;
   
5. UPDATE item_template SET socketcolor_1 = 8 WHERE class = 4 and socketcolor_1 = 0;
   
6. UPDATE item_template SET socketcolor_2 = 2 WHERE class = 4 and socketcolor_2 = 0;
   
7. UPDATE item_template SET socketcolor_3 = 4 WHERE class = 4 and socketcolor_3 = 0;
   
8. UPDATE item_template SET socketbonus = 3621 WHERE class = 2 and socketbonus = 0;
   
9. UPDATE item_template SET socketbonus = 3696 WHERE class = 4 and socketbonus = 0;

复制代码

注释:作用是给所有孔不足3个的装备都添加改为3个镶嵌孔，并有镶嵌奖励。

123462005

谢谢分享~~~~~一定要观光下~~~~~

夢虞癸佾

感谢楼主分享～～～～～

连笑寒

路过，支持一下

vrukzwuimr

感谢楼主分享。