01-02-2014, 02:55 AM
UPDATE t_inven00 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19; sorry if im mistaken
UPDATE t_inven00 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven00 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven00 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven00 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count0 = 100000000000 If a_count0 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count1 = 100000000000 If a_count1 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count2 = 100000000000 If a_count2 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count3 = 100000000000 If a_count3 > 500000000000 WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count4 = 100000000000 If a_count4 > 500000000000 WHERE a_item_idx0 = 19;