Navicat Dayz Traders_Data Help

[Guest]

I made a new record into Traders_data and wrote this:

 

Id:4995

 

Item ["PartWoodLumber",1]

 

Quantity 100

 

Buy[1,"ItemGoldBar",1]

 

Sell[1,"ItemGoldBar",1]

 

Order 0

 

TID 508

 

Afile trade_items

 

It saves with no errors, but when i go to the guy who sells building supplies its not listed.

Any help would be appreciated

 

[haku]

No,

 
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["PartWoodLumber",1]',10,'[1,"ItemGoldBar",1]','[10,"ItemSilverBar",2]',0,662,'trade_items')
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["PartWoodLumber",1]',10,'[1,"ItemGoldBar",1]','[10,"ItemSilverBar",2]',0,508,'trade_items')
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["PartWoodLumber",1]',10,'[1,"ItemGoldBar",1]','[10,"ItemSilverBar",2]',0,678,'trade_items')
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["PartWoodLumber",1]',10,'[1,"ItemGoldBar",1]','[10,"ItemSilverBar",2]',0,680,'trade_items')
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["PartWoodLumber",1]',10,'[1,"ItemGoldBar",1]','[10,"ItemSilverBar",2]',0,530,'trade_items')
 

 

This will add Lumber to all traders that also sells Building supplies wich was sorted from DB.

[Guest]

How do i insert it into navicat? I got no idea what to do.

[haku]

http://dayzepoch.com/forum/index.php?/topic/1700-how-to-do-database-backups/?p=11523

 

scroll down , its explained there, just don't run them all in one go , insert 1 , run , insert another , run , and so on.

[Guest]

So i need to schedule it to insert t into navicat? (im using lite BTW)

[haku]

No. Check the last part with the Query , the schedule is for backups , the last part is explained for executing Querys

[Guest]

Damn you reply fast

[haku]

Just trying to help :)

[Guest]

After i run the command, is there any way to undo it?

[haku]

Yes , go to Navicat into traders_data , look for what u added , delete line and restart server , every changes you make in database at traders requires server restart.

[Guest]

I can't seem to find what i inserted, is there a search tool?

[haku]

CTRL+F and look for example if you added PartWoodLumber copy the whole line and just delete it also it might be on 2nd page

[Guest]

Can i make it so when i buy lumber i get 1000 of them? e.g 1000 lumber costs 1 gold and i would revice 1000 lumber on thefloor or in non visible invo slots (like when you convert 1 ozgold into 10 gold, they appear when there are invo slots avalible.)l

[haku]

No, I dont think its possible. but you can buy 100 lumber in inventory and then place all 100 in a car with 100 slots imediatly. But it takes alot of time.

[Guest]

Completing trade 1 of 900 :/. Wasting time powers activate!

[Guest]

Also, +5 stars for you, haku. Nice job

[haku]

no problem :)

[Guest]

Is there a way for me to prevent myself from starving when im completing a 4000 step trade?

[haku]

Nope, sorry , u have to intrerupt the process :P