Punisher Posted June 22, 2013 Report Share Posted June 22, 2013 hi could someone please help me out and explain how i get navicat lite to do my cleanups ie delete destroyed vehicles and objects not used in so many days ive seen them on http://dayzepoch.com/wiki/index.php/Server_Configuration_Instructions but im a real noob when it comes to dayz all ive ever really done is wasteland maps and servers and the epoch server we run now so if someone could help id be grateful thanks in advance Link to comment Share on other sites More sharing options...
0 Driffter Posted June 22, 2013 Report Share Posted June 22, 2013 all righty then this link is for you to take what they provide as a "clean up script" and use it in your query. 1. open your navi 2.open epoch 3.open query. this is listed were your tables, functions, views, events ect ect 4.when you open it you will see "New query" at the top of your window. click it 5. copy and past the script in your link to this page. 6. hit save. and name it what ever you want. 7.this should put it in your query page. 8. at the top of the page click the Run. 9. this will run your clean up query. your server has to be up and running for this to happen the simply restart it. 10. for this query to work you have to run it manualy. we do upon every server restart. this is our clean up query. DELETE FROM character_data WHERE Alive=0; DELETE FROM object_data WHERE Damage = 1; UPDATE `traders_data` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'; hope this helps. Punisher 1 Link to comment Share on other sites More sharing options...
0 Punisher Posted June 22, 2013 Author Report Share Posted June 22, 2013 thank you very much fellow racing fan (hope its f1) Link to comment Share on other sites More sharing options...
0 Punisher Posted June 22, 2013 Author Report Share Posted June 22, 2013 and whilst im extracting your excellent knowledge could you tell me also how to run an update to the database to restock items or create ones that are missing ie plot pole ? thanks in advance Link to comment Share on other sites More sharing options...
0 Driffter Posted June 23, 2013 Report Share Posted June 23, 2013 the script i posted will restock all traders in real time you wont have to restart the server. for adding items to traders i need a little time to compile my thoughts on how i did that. i ran into some problems with trader ids. be back to ya in a bit. Link to comment Share on other sites More sharing options...
0 Punisher Posted June 23, 2013 Author Report Share Posted June 23, 2013 i have the standard epoch.sql file that i downloaded i just dont know how to force it upon my database and i dont want to risk upsetting all the guys that play in case i wipe all there things out Link to comment Share on other sites More sharing options...
0 sercanatici Posted September 3, 2014 Report Share Posted September 3, 2014 Working great thankes a lot Link to comment Share on other sites More sharing options...
0 MGT Posted September 3, 2014 Report Share Posted September 3, 2014 If you use a batchfile to start your server you can call an SQL command from there Create a SQL proc called pMain and list all the calls you want to run, then call the pMain from your batch file, eg pMain BEGIN CALL pCleanup; CALL sOmethingelse; END Startup batch file .\SQL\bin\mysql.exe --user=**********--password=**********--host=127.0.0.1 --port=**** --database=dayz_epoch --execute="call pMain()" Link to comment Share on other sites More sharing options...
Question
Punisher
hi could someone please help me out and explain how i get navicat lite to do my cleanups ie delete destroyed vehicles and objects not used in so many days ive seen them on http://dayzepoch.com/wiki/index.php/Server_Configuration_Instructions
but im a real noob when it comes to dayz all ive ever really done is wasteland maps and servers and the epoch server we run now so if someone could help id be grateful
thanks in advance
Link to comment
Share on other sites
7 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