BlissDB dead clean up

[Killzone_Kid]

-

 

[Falcon911]

Even better with Bliss 4.0 run this first


perl db_spawn_vehicles.pl --instance 1 --name yourDBname --cleanup all (Deletes Tents with anything older than 4 days once character dies)

then run

cleandead <days> - delete dead survivors who were last updated more than <days> days ago\n"

perl db_utility.pl --name yourDBname --instance 1 cleandead 5

 

[Killzone_Kid]

-

 

[Karl]

I was getting errors with this until I edited its format

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;

 

[Killzone_Kid]

-

 

[Karl]

yes

 

[Killzone_Kid]

-

 

[Karl]

The error was something to do with MySQL version syntax perhaps you are running a different version to me :S

 

[Killzone_Kid]

-

 

[Karl]

Maybe that is why. I don't know much about these things and ran it as a query