EQEmulator Forums - I hope your corpse rots! ;)

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Bug Reports (https://www.eqemulator.org/forums/forumdisplay.php?f=591)

- - I hope your corpse rots! ;) (https://www.eqemulator.org/forums/showthread.php?t=23851)

I hope your corpse rots! ;)

Maybe I am crazy but are player corpse rot timers broken when set to leave corpse?

I mean they just don't rot.

We have 505 players corpses server wide right now and counting, all the way back to the 26th of October (the last time I cleaned out the table).

The timer resets when the zone shuts down.

Gernblan, do you make your players retreive their corpses after death, or leave naked corpses? I know you can turn off corpses altogether, but that might not be what you need for your server rules.

Quote:

Originally Posted by KLS (Post 140134)

The timer resets when the zone shuts down.

Ok that makes sense.

Thanks!

Quote:

Originally Posted by John Adams (Post 140149)

Gernblan, do you make your players retreive their corpses after death, or leave naked corpses? I know you can turn off corpses altogether, but that might not be what you need for your server rules.

My server has no death penalty.. we try to leave corpses so that in a raid they can res people back that die... but beyond that corpses have no other use to us.

In that case, could you just put your "rot timer" to something horribly low, since if a raid wipes and does not rez and get back to business within, say, 30 mins, the corpses poof? I understand it's just a maintenance issue for you. When I took the Abyss DB, I was shocked how many dead bodies were lying around, too. :)

Yeah it may come down to that, thanks for the great suggestions!

I think another thing that would help this issue is if the server can be changed so that empty corpses poof once they have been rezzed. I know on GC players rezz, but since corpses don't drop items (yet, haha!) they don't ever loot so the corpses stay until they finally rot.

Remove Rotten Corpses

I think the function "LoadPlayerCorpses" is run when a zone is loaded up. If we put a function to check if the corpses have rotted,
it should resolve the issue. Keep in mind this is depends on real time and not game time...
If the server is off for 2 days, it does not move the rot time.....

In PlayerCorpse.cpp find

Code:

bool ZoneDatabase::LoadPlayerCorpses(int32 iZoneID) {

Under the line

Code:

unsigned long* lengths;

#####WARNING UNTESTED CODE#####
Warning, I took a look at this, but have not actually run the code. BACKUP the table, player_corpses BEFORE USING.....
Add this

Code:

        if(!RuleB(Zone, EnableShadowrest))

        {

                RunQuery(query, MakeAnyLenString(&query, "update player_corpses set IsBurried=1 where zoneid= %u and (UNIX_TIMESTAMP(timeofdeath) + %u) < UNIX_TIMESTAMP(NOW())  ", iZoneID, RuleI(Character, CorpseDecayTimeMS)), errbuf);

        }

        else

        {

                RunQuery(query, MakeAnyLenString(&query, "delete from player_corpses where zoneid= %u and (UNIX_TIMESTAMP(timeofdeath) + %u) < UNIX_TIMESTAMP(NOW())  ", iZoneID, RuleI(Character, CorpseDecayTimeMS)), errbuf);

        }

        safe_delete_array(query);

####WARNING UNTESTED CODE#####
Warning, I took a look at this, but have not actually run the code. BACKUP the table, player_corpses BEFORE USING.....