Search results

I just use the killmsgs package that is included and modified the file slightly for no global chat message and a generic PKILL message when killerName isn't set. A simple search for PKILL or PHIT in the RPT file then shows what I need. diff --git a/pkg/killmsgs/compile/server_playerDied.sqf...

There's a thread here with some updates needed: http://dayzmod.com/forum/index.php?/topic/121631-filter-updates-for-1751/

All I had to do to my existing Bliss database was run 1 line of SQL: update migration_schema_version set name = 'Reality' where name = 'Bliss';

Yes, that is telling you it can't remove survivor entries that are linked to items in the instance_deployable table (like tents). db_utility.pl uses the proper SQL to remove deployables when using the cleandead option. Note in the original queries I showed you I'm deleting from...

Cool, glad I could help. If you're using Bliss you can use "db_utility.pl cleandead X", where X is the number of days, to clean up dead survivors. I have a call to db_utility.pl as part of my server start .bat file and clean up dead survivors older than 7 days.

Sure thing, here are the 2 queries. You can copy and paste one at a time or both at once, shouldn't matter. SELECT COUNT(*) FROM survivor; SELECT COUNT(*) FROM survivor WHERE last_updated < NOW() - INTERVAL 1 MONTH;

What do you get running these 2 queries? mysql> SELECT COUNT(*) FROM survivor; +----------+ | COUNT(*) | +----------+ | 1087 | +----------+ 1 row in set (0.00 sec) mysql> SELECT COUNT(*) FROM survivor WHERE last_updated < NOW() - INTERVAL 1 MONTH; +----------+ | COUNT(*) | +----------+ |...

That commit did indeed fix this bug for me.

Thanks for the links, epic fail at searching github for me. How did I miss that, wow...

I stood up a test server for 1.7.5 using devel branch and it all seems to be working. One thing that is really weird is any time I am holding down either Alt key (bound to Look) my fps goes from 50+ to 10 and I can't move the view around. Releasing the key returns fps to normal. If I double tap...

I didn't write a perl script for you but here is the SQL (for a Bliss server). -- clean up any deployed items DELETE FROM id USING instance_deployable id JOIN survivor s ON id.owner_id = s.id WHERE s.last_updated < now() - INTERVAL 1 MONTH; -- delete profile DELETE FROM p USING profile p JOIN...

Another way to do this: mysql> SELECT CONCAT(FLOOR(AVG(`survival_time`)/60), 'h ', MOD(ROUND(AVG(`survival_time`)),60),'m') AS 'Average Survival Time' FROM `survivor` WHERE `survival_time` > 50 AND `is_dead` = 0; +-----------------------+ | Average Survival Time | +-----------------------+ | 4h...