[QUESTION] Characters revive trough database

[silvermcd]

i'm doing a script in php for reviving characters , and i need to know the table and column to change for a player that is dead/alive.

Thanks

[EARTHWALKER]

I'm not 100% certain, but I would try characters/characters/death_expire_time set to 0

At least that is what I would try.

[hunuza]

Didn't try it but I think this should work:

DELETE FROM corpse WHERE player = GUID;
DELETE FROM character_aura WHERE guid = GUID AND (spell = 20584 OR spell = 8326);
UPDATE characters SET health=1 WHERE guid = GUID;

[Diablox]

Didn't try it but I think this should work:

DELETE FROM corpse WHERE player = GUID;
DELETE FROM character_aura WHERE guid = GUID AND (spell = 20584 OR spell = 8326);
UPDATE characters SET health=1 WHERE guid = GUID;

Just to point out that this will only work when player is offline