Guest Posted October 4, 2013 Report Share Posted October 4, 2013 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 Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 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. Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 How do i insert it into navicat? I got no idea what to do. Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 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. Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 So i need to schedule it to insert t into navicat? (im using lite BTW) Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 No. Check the last part with the Query , the schedule is for backups , the last part is explained for executing Querys Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 Damn you reply fast Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 Just trying to help :) Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 After i run the command, is there any way to undo it? Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 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. Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 I can't seem to find what i inserted, is there a search tool? Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 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 Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 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 Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 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. Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 Completing trade 1 of 900 :/. Wasting time powers activate! Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 Also, +5 stars for you, haku. Nice job Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 no problem :) Link to comment Share on other sites More sharing options...
0 Guest Posted October 4, 2013 Report Share Posted October 4, 2013 Is there a way for me to prevent myself from starving when im completing a 4000 step trade? Link to comment Share on other sites More sharing options...
0 haku Posted October 4, 2013 Report Share Posted October 4, 2013 Nope, sorry , u have to intrerupt the process :P Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
18 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now