here are 2 usefull sql-statements for the daily work with this patch:
restore a character:
UPDATE characters
SET name = deleteInfos_Name
,account = deleteInfos_Account
,deleteInfos_Name = NULL
,deleteInfos_Account = NULL
,deleteDate = NULL
WHERE deleteInfos_Name IS NOT NULL
AND deleteInfos_Account IS NOT NULL
AND guid = -1;
(for a formated code see here: http://paste2.org/p/118125 )
to restore a char with this statement you have to replace the -1 in the last line with the GUID from the char. you can also remove the last line to restore ALL characters.
INFO: if you restore a character by hand (without the above sql statement), be sure that you set the deleteDate to NULL, else the char get's deleted anyway...
statistik:
(for a formated code see here: http://paste2.org/p/118121 )can any dev give a statement if this will go into the master branch? this patch is now since some weeks in the 'under review' section and i haven't heard any statement until now...