clean up scripts with navicat lite

[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 

[Driffter]

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]

thank you very much fellow racing fan (hope its f1)

[Punisher]

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 

[Driffter]

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.

[Punisher]

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 

[sercanatici]

Working great thankes a lot

[MGT]

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()"