How to set the gold in all inventory?

[vps]

How to set the gold in all inventory?, please help

[fonsy84]

??

[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

[lordzik112]

Thx Maan :-)

[Johnny5]

Topic Closed - Reason: Problem sloved !

[Sutz]

@ mod of this section:

Please dont forget to change the tags to solved.

First post tag edited to solved.