PHP код:
UPDATE item_template SET stat_value1 = 200 WHERE stat_type1=35 and InventoryType in (1,3,5,7,10,16) and stat_value1<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value2 = 200 WHERE stat_type2=35 and InventoryType in (1,3,5,7,10,16) and stat_value2<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value3 = 200 WHERE stat_type3=35 and InventoryType in (1,3,5,7,10,16) and stat_value3<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value4 = 200 WHERE stat_type4=35 and InventoryType in (1,3,5,7,10,16) and stat_value4<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value5 = 200 WHERE stat_type5=35 and InventoryType in (1,3,5,7,10,16) and stat_value5<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value6 = 200 WHERE stat_type6=35 and InventoryType in (1,3,5,7,10,16) and stat_value6<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value7 = 200 WHERE stat_type7=35 and InventoryType in (1,3,5,7,10,16) and stat_value7<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value8 = 200 WHERE stat_type8=35 and InventoryType in (1,3,5,7,10,16) and stat_value8<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value9 = 200 WHERE stat_type9=35 and InventoryType in (1,3,5,7,10,16) and stat_value9<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value10 = 200 WHERE stat_type10=35 and InventoryType in (1,3,5,7,10,16) and stat_value10<200 and (itemLevel>499 and itemLevel<599) and Quality=4;
UPDATE item_template SET stat_value1 = 200 WHERE stat_type1=35 and InventoryType=18 and stat_value1<80;
UPDATE item_template SET stat_value2 = 200 WHERE stat_type2=35 and InventoryType=18 and stat_value2<80;
UPDATE item_template SET stat_value3 = 200 WHERE stat_type3=35 and InventoryType=18 and stat_value3<80;
UPDATE item_template SET stat_value4 = 200 WHERE stat_type4=35 and InventoryType=18 and stat_value4<80;
UPDATE item_template SET stat_value5 = 200 WHERE stat_type5=35 and InventoryType=18 and stat_value5<80;
UPDATE item_template SET stat_value6 = 200 WHERE stat_type6=35 and InventoryType=18 and stat_value6<80;
UPDATE item_template SET stat_value7 = 200 WHERE stat_type7=35 and InventoryType=18 and stat_value7<80;
UPDATE item_template SET stat_value8 = 200 WHERE stat_type8=35 and InventoryType=18 and stat_value8<80;
UPDATE item_template SET stat_value9 = 200 WHERE stat_type9=35 and InventoryType=18 and stat_value9<80;
UPDATE item_template SET stat_value10 = 200 WHERE stat_type10=35 and InventoryType=18 and stat_value10<80;
- - - Updated - - -
както так чО
- - - Updated - - -
PHP код:
UPDATE item_template SET stat_value1 = stat_value1+15 WHERE stat_type1=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value2 = stat_value2+15 WHERE stat_type2=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value3 = stat_value3+15 WHERE stat_type3=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value4 = stat_value4+15 WHERE stat_type4=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value5 = stat_value5+15 WHERE stat_type5=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value6 = stat_value6+15 WHERE stat_type6=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value7 = stat_value7+15 WHERE stat_type7=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value8 = stat_value8+15 WHERE stat_type8=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value9 = stat_value9+15 WHERE stat_type9=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value10 = stat_value10+15 WHERE stat_type10=35 and InventoryType in (8,11,2,9) and itemLevel=566 and Quality=4;
UPDATE item_template SET stat_value1 = 110 WHERE stat_type1=35 and InventoryType in (4,19) and stat_value1<110;
UPDATE item_template SET stat_value2 = 110 WHERE stat_type2=35 and InventoryType in (4,19) and stat_value2<110;
UPDATE item_template SET stat_value3 = 110 WHERE stat_type3=35 and InventoryType in (4,19) and stat_value3<110;
UPDATE item_template SET stat_value4 = 110 WHERE stat_type4=35 and InventoryType in (4,19) and stat_value4<110;
UPDATE item_template SET stat_value5 = 110 WHERE stat_type5=35 and InventoryType in (4,19) and stat_value5<110;
UPDATE item_template SET stat_value6 = 110 WHERE stat_type6=35 and InventoryType in (4,19) and stat_value6<110;
UPDATE item_template SET stat_value7 = 110 WHERE stat_type7=35 and InventoryType in (4,19) and stat_value7<110;
UPDATE item_template SET stat_value8 = 110 WHERE stat_type8=35 and InventoryType in (4,19) and stat_value8<110;
UPDATE item_template SET stat_value9 = 110 WHERE stat_type9=35 and InventoryType in (4,19) and stat_value9<110;
UPDATE item_template SET stat_value10 = 110 WHERE stat_type10=35 and InventoryType in (4,19) and stat_value10<110;
И еще немного доводочки до ума 
- - - Updated - - -
PHP код:
UPDATE item_template SET stat_value1 = 120 WHERE stat_type1=35 and InventoryType=12 and stat_value1<120;
UPDATE item_template SET stat_value2 = 120 WHERE stat_type2=35 and InventoryType=12 and stat_value2<120;
UPDATE item_template SET stat_value3 = 120 WHERE stat_type3=35 and InventoryType=12 and stat_value3<120;
UPDATE item_template SET stat_value4 = 120 WHERE stat_type4=35 and InventoryType=12 and stat_value4<120;
UPDATE item_template SET stat_value5 = 120 WHERE stat_type5=35 and InventoryType=12 and stat_value5<120;
UPDATE item_template SET stat_value6 = 120 WHERE stat_type6=35 and InventoryType=12 and stat_value6<120;
UPDATE item_template SET stat_value7 = 120 WHERE stat_type7=35 and InventoryType=12 and stat_value7<120;
UPDATE item_template SET stat_value8 = 120 WHERE stat_type8=35 and InventoryType=12 and stat_value8<120;
UPDATE item_template SET stat_value9 = 120 WHERE stat_type9=35 and InventoryType=12 and stat_value9<120;
UPDATE item_template SET stat_value10 = 120 WHERE stat_type10=35 and InventoryType=12 and stat_value10<120;
- - - Updated - - -
PHP код:
UPDATE item_template SET stat_value1 = stat_value1-15 WHERE stat_type1=35 and stat_value1>230;
UPDATE item_template SET stat_value2 = stat_value2-15 WHERE stat_type2=35 and stat_value2>230;
UPDATE item_template SET stat_value3 = stat_value3-15 WHERE stat_type3=35 and stat_value3>230;
UPDATE item_template SET stat_value4 = stat_value4-15 WHERE stat_type4=35 and stat_value4>230;
UPDATE item_template SET stat_value5 = stat_value5-15 WHERE stat_type5=35 and stat_value5>230;
UPDATE item_template SET stat_value6 = stat_value6-15 WHERE stat_type6=35 and stat_value6>230;
UPDATE item_template SET stat_value7 = stat_value7-15 WHERE stat_type7=35 and stat_value7>230;
UPDATE item_template SET stat_value8 = stat_value8-15 WHERE stat_type8=35 and stat_value8>230;
UPDATE item_template SET stat_value9 = stat_value9-15 WHERE stat_type9=35 and stat_value9>230;
UPDATE item_template SET stat_value10 = stat_value10-15 WHERE stat_type10=35 and stat_value10<230;
У некоторых мб будет чуть-чуть бобмить от этого запроса.
Нерфит рес на 15 едениц на всех предметах где его свыше 230 едениц.