Removing Dead Survivors

[R.J.]

How do I go about removing dead survivors in the Bliss database? I have so many pages it's becoming unbearable.

I should note that I have zero coding skill. Perhaps something step by step?

 

[Omer]

DELETE FROM survivor
WHERE is_dead = 1 AND id NOT IN (SELECT DISTINCT owner_id FROM instance_deployable);

There you go

 

[Torndeco]

There is a db_utility.pl
That comes with bliss, it has option to remove dead players etc...
Just run --help & check out the options

 

[Karl]

I use

DELETE FROM survivor WHERE id NOT IN (SELECT owner_id FROM instance_deployable) AND is_dead = 1 AND last_updated < NOW() - INTERVAL 24 HOUR;
 
DELETE FROM log_entry WHERE created < NOW() - INTERVAL 24 HOUR;

 

[R.J.]

Thanks, worked great!