gold...

[MrBuSta]

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]

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]

 

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]

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]

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]

UPDATE t_character SET a_nas = 100000000 WHERE a_nas > 500000000;

 

[Creep]

exactly

PS: do u also get logged out of lckb when you click a subforum?

[Paramount]

exactly

 

 

 

PS: do u also get logged out of lckb when you click a subforum?

//offtop

change your theme

[MrBuSta]

Thanks for help
Close please.

[Nymphetamine]

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