View Single Post
  #1  
Old 05-04-2016, 10:12 AM
tigurius
Fire Beetle
 
Join Date: Sep 2004
Posts: 24
Default Corpses In DB but not in game

I wiped hard on Suled Dar's Shade in skyfire and decided to camp and clean up the mess the next day. When I returned to skyfire to do rezzes, all the corpses are gone and cannot be summoned, however, peeking in the DB corpse table, they are in fact there and in the correct zoneid. Any ideas? I guess I can try to move them to another zone but I'm wondering what went wrong- this has not happened before but I have also always recovered my corpses before camping for the day.

RESOLUTION:
It turns out my corpses were 'buried'. This is likely an adjustable variable I need to tweak but I did not recover my corpse in time and it was buried making it unavailable to me. To fix this by hand, I ran a query to update the time_of_death and set the is_buried flag = 0.

Code:
UPDATE character_corpses SET is_buried = 0, time_of_death = NOW() WHERE zone_id = 91;
I did a server bounce after this and logged back in, corpses were back scattered everywhere again. Yay!

Last edited by tigurius; 05-04-2016 at 10:26 AM.. Reason: FIXED
Reply With Quote