装备属性翻倍,铸剑等技能的学习等等
UPDATE items SET stat_value1 = stat_value1*3 WHERE stat_type1=7; UPDATE items SET stat_value2 = stat_value2*3 WHERE stat_type2=7; UPDATE items SET stat_value3 = stat_value3*3 WHERE stat_type3=7; UPDATE items SET stat_value4 = stat_value4*3 WHERE stat_type4=7; UPDATE items SET stat_value5 = stat_value5*3 WHERE stat_type5=7; UPDATE items SET stat_value1 = stat_value1*3 WHERE stat_type1=4; UPDATE items SET stat_value2 = stat_value2*3 WHERE stat_type2=4; UPDATE items SET stat_value3 = stat_value3*3 WHERE stat_type3=4; UPDATE items SET stat_value4 = stat_value4*3 WHERE stat_type4=4; UPDATE items SET stat_value5 = stat_value5*3 WHERE stat_type5=4; UPDATE items SET stat_value1 = stat_value1*5 WHERE stat_type1=5; UPDATE items SET stat_value2 = stat_value2*5 WHERE stat_type2=5; UPDATE items SET stat_value3 = stat_value3*5 WHERE stat_type3=5; UPDATE items SET stat_value4 = stat_value4*5 WHERE stat_type4=5; UPDATE items SET stat_value5 = stat_value5*5 WHERE stat_type5=5; UPDATE items SET stat_value1 = stat_value1*3 WHERE stat_type1=6; UPDATE items SET stat_value2 = stat_value2*3 WHERE stat_type2=6; UPDATE items SET stat_value3 = stat_value3*3 WHERE stat_type3=6; UPDATE items SET stat_value4 = stat_value4*3 WHERE stat_type4=6; UPDATE items SET stat_value5 = stat_value5*3 WHERE stat_type5=6; UPDATE items SET stat_value1 = stat_value1*1.3 WHERE stat_type1=3; UPDATE items SET stat_value2 = stat_value2*1.3 WHERE stat_type2=3; UPDATE items SET stat_value3 = stat_value3*1.3 WHERE stat_type3=3; UPDATE items SET stat_value4 = stat_value4*1.3 WHERE stat_type4=3; UPDATE items SET stat_value5 = stat_value5*1.3 WHERE stat_type5=3; UPDATE items SET dmg_min1=dmg_min1*2.5; UPDATE items SET dmg_max1=dmg_max1*2.5; UPDATE items SET armor=armor*1.5;
|