item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=38; UPDATE item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=38; UPDATE item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=38; UPDATE item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=38; UPDATE item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=38; UPDATE item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=38; UPDATE item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=38; UPDATE item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=38; UPDATE item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=38; 修改每5秒回藍 UPDATE item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=43; UPDATE item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=43; UPDATE item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=43; UPDATE item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=43; UPDATE item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=43; UPDATE item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=43; UPDATE item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=43; UPDATE item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=43; UPDATE item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=43; UPDATE item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=43; 修改護甲穿透等級 UPDATE item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=44; UPDATE item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=44; UPDATE item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=44; UPDATE item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=44; UPDATE item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=44; UPDATE item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=44; UPDATE item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=44; UPDATE item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=44; UPDATE item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=44; UPDATE item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=44; 修改法術強度等級 UPDATE item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=45; UPDATE item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=45; UPDATE item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=45; UPDATE item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=45; UPDATE item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=45; UPDATE item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=45; UPDATE item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=45; UPDATE item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=45; UPDATE item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=45; UPDATE item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=45; 所有玩家則成為1級賬號,將沒有gm權限 :UPDATE account SET gmlevel = 1; |