+- 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: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: gold... (/showthread.php?tid=3126)
- MrBuSta - 01-02-2014
hi guys,
im interest how to remove gold from inventory + warehouse with console on navicat.
example who have more than 500bill edit to 100bill max.
- dethunter12 - 01-02-2014
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;
- Darkface - 01-02-2014
UPDATE t_inven00 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven00 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven00 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven00 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven00 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven01 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven01 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven01 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven01 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven02 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven02 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven02 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven02 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven03 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven03 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven03 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven03 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven04 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven04 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven04 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven04 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven05 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven05 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven05 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven05 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven06 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven06 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven06 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven06 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven07 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven07 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven07 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven07 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven08 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven08 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven08 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven08 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven09 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven09 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven09 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven09 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
- dethunter12 - 01-02-2014
ha i guess thats alot easier but that would be giving people who didnt deserver 100 bill 100 bill so i dont see that as the correct method
- Creep - 01-03-2014
Its probably even easier as I have seen, in the ep3 versions the gold is save as nas in t_character in a_nas, because the gold item doesnt exist anymore so just
UPDATE t_character SET a_nas=xx WHERE a_nas > xx;
xx for ure values
- Nymphetamine - 01-03-2014
UPDATE t_character SET a_nas = 100000000 WHERE a_nas > 500000000;
- Creep - 01-03-2014
exactly
PS: do u also get logged out of lckb when you click a subforum?
- Paramount - 01-03-2014
exactly
PS: do u also get logged out of lckb when you click a subforum?
//offtop
change your theme
- MrBuSta - 01-03-2014
Thanks for help
Close please.
- Nymphetamine - 01-03-2014
Hi.
As you got your answer, and your problem is solved, I am gonna move that topic to Solved section and mark it as solved.
Thanks,
-LCKB Staff