A lil' help with the server settings

[domey 1]

Hey there fellas ! I'm not certainly sure this is the right place for me to ask for help but i guess its worth the try !

I'm running a dayz server with a friend of mine & we are struggling with some of the settings our players would like to be implemented.

The first thing is we would like to spawn all our vehicles fully repaired, we figured out it works if we just change the database entry from 0 to 1 in the fully repaired section, but this needs one of us to be present at the time the restart is happening and thats not allways the case, so we tried to find some script that does that for us but we're helplessly lost.

So this is the one thing we're searching help for...

The next thing is that our server is playing the map lingor and people keep complaining about the low spawnrate of tents, is there a way to increase the spawnrate of just 1 specific gear part ?

If so i would be really happy for a lil hint how to do it...

so yeah thats the two major problems we got and i would really appreciate any help you have to offer and im sorry if this is not the right section for questions.

thx for reading

so far

[boxman80 964]

Hi mate, welcome to the forum. The first thing I'd ask is who are you renting your server from as this may affect how you tackle your issues?

For the issues you have with spawn rates,I'd recommend using a custom loot table, if you have access to your PBO's. I used this script;-

http://opendayz.net/threads/100-custom-loot-tables-tutorial.8474/

However I suspect this will be obsolete come the release of 1.7.7, or at the very least it will need some substantial changes made to it.

Edited May 16, 2013 by Box

[PK Richie 507]

You can repair and refuel all vehicles using a SQL command.

Between restarts just run this

UPDATE instance_vehicle SET fuel=1, damage=0, parts = '[]'

On the next restart all vehicles will be fully fueled and repaired :)

If you want all future vehicles to spawn with full health just do this

UPDATE vehicle SET damage_min=0, damage_max=0

[domey 1]

:D Thats exactly what i needed thanks guys <3

and we're renting our server on DayZ.st btw :>

[boxman80 964]

You can repair and refuel all vehicles using a SQL command.

Between restarts just run this

UPDATE instance_vehicle SET fuel=1, damage=0, parts = '[]'

On the next restart all vehicles will be fully fueled and repaired :)

If you want all future vehicles to spawn with full health just do this

UPDATE vehicle SET damage_min=0, damage_max=0

Niceone. Where exactly does this go though, in the world_vehicles table? SQL scares me!

[PK Richie 507]

Niceone. Where exactly does this go though, in the world_vehicles table? SQL scares me!

you run it as a query :) It all depends on what you use for your server management, I've always used phpMyAdmin so i can help with that, anything else google it or consult your documentation.

Make a mistake with this Can cause serious issues to your database.

[boxman80 964]

yea its the phpmyadmin that comes with the server - not a lot of documentation to read unfortunately!

[PK Richie 507]

yea its the phpmyadmin that comes with the server - not a lot of documentation to read unfortunately!

Login to PMA and click your database table on the left, then click SQL on the top tabs and that is your query box :) paste the query and hit go

[boxman80 964]

Cheers!

Login to PMA and click your database table on the left, then click SQL on the top tabs and that is your query box :) paste the query and hit go

Thanks