How to set the gold in all inventory?

[DrGenius]

 

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