How to set the gold in all inventory?
#3

 

UPDATE t_inven00 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven00 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven00 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven00 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven00 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven01 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven01 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven01 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven01 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven02 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven02 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven02 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven02 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven03 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven03 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven03 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven03 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven04 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven04 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven04 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven04 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven05 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven05 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven05 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven05 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven06 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven06 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven06 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven06 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven07 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven07 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven07 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven07 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven08 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven08 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven08 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven08 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;
 
UPDATE t_inven09 SET a_count0 = 0 + "GOLD AMOUNT" WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count1 = 0 + "GOLD AMOUNT" WHERE a_item_idx1 = 19;
UPDATE t_inven09 SET a_count2 = 0 + "GOLD AMOUNT" WHERE a_item_idx2 = 19;
UPDATE t_inven09 SET a_count3 = 0 + "GOLD AMOUNT" WHERE a_item_idx3 = 19;
UPDATE t_inven09 SET a_count4 = 0 + "GOLD AMOUNT" WHERE a_item_idx4 = 19;

 

Here you go, no give thanks to me, all credits to HateMe



Messages In This Thread
[No subject] - by vps - 02-08-2013, 08:10 PM
[No subject] - by fonsy84 - 02-08-2013, 08:31 PM
[No subject] - by DrGenius - 02-08-2013, 10:24 PM
[No subject] - by lordzik112 - 02-08-2013, 11:01 PM
[No subject] - by Johnny5 - 02-09-2013, 02:34 PM
[No subject] - by Sutz - 03-19-2013, 04:22 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)