[Player Safe Reset Mission]

Hi folks,

 

I on my server and really liked it.  Here's the sql event I used:

 DROP EVENT IF EXISTS resetVaults; CREATE EVENT resetVaults
   ON SCHEDULE EVERY 1 DAY
   COMMENT 'Sets safe codes to 0000 if not accessed for 14 days'
   DO
UPDATE `object_data` SET `CharacterID` = 0
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND
`Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND
`CharacterID` > 0 AND
`Classname` IN ('VaultStorageLocked') AND
`Inventory` <> '[]' AND
`Inventory` IS NOT NULL

can anybody tell me how to add this to sql events? i'm trying to add via navicat "funcions". is it right?

[disconnecting players, many "client not responded" and disapearing items]

i've solved this problem using this guide http://forums.dayzgame.com/index.php?/topic/51542-psa-server-admins-how-to-optimize-your-dayz-server-for-maximum-performance/ (about network)

but magazines and other itemts like them dissapear still
i looked it happens if player force disconnect or server restart

[disconnecting players, many "client not responded" and disapearing items]

UPD.
Walls players built disapearing after restart  :D

[disconnecting players, many "client not responded" and disapearing items]

hi everybody. i have such my server issues: 
1. often they are disconnected during a game with no rtp errors. example:

15:35:07 | Player #7 stakan disconnected

15:36:16 | Player #2 BlackManTmn disconnected

15:36:44 | Player #13 durdom disconnected

15:37:03 | Player #17 THORUSZ disconnected

or

14:30:48 | Player #4 rodrigo (852ff02e4543e4499f500c8c8d75563d) has been kicked by BattlEye: Client not responding

14:30:59 | Player #4 rodrigo (852ff02e4543e4499f500c8c8d75563d) has been kicked by BattlEye: Client not responding
this problem often interfere to connect for different players

but the average ping is 40-100.
And the main PROBLEM - deleting magazines, and other items after player relog or restart server

has anybody faced problems like this?
p.s sorry for my english

[purchased vehicle disappears till restart]

sorry

i have found solving this problem

[purchased vehicle disappears till restart]

hello

i have such a problem: sometimes, veh my players bought disappears at once till restart

then it appears

epoch 1.0.4.2

[[EMS] 0.2.6 Epoch Mission System]

hi. anybody knows how to add rpg to bots on missions? can i make them (rpg) to disapper after bot is dead?

[problem with the mission WAI and BTR 90]

can i add 1-2 (no random) rpg-7 to bots to each misson?