+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep1 Support (https://lckb.dev/forum/forumdisplay.php?fid=177)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=145)
+------ Thread: How to set the gold in all inventory? (/showthread.php?tid=1576)
- vps - 02-08-2013
How to set the gold in all inventory?, please help
- fonsy84 - 02-08-2013
??
- DrGenius - 02-08-2013
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 - 02-08-2013
Thx Maan :-)
- Johnny5 - 02-09-2013
Topic Closed - Reason: Problem sloved !
- Sutz - 03-19-2013
@ mod of this section:
Please dont forget to change the tags to solved.
First post tag edited to solved.