[Request] Script or info on auto restoring UM's

[NocturnalSniper]

I am trying to see if there is a way to automate the process of restoring dead UM's after maintenance.
It gets confusing trying to sort through wich ones were dead because of no res rune and wich ones were deleted on purpose.
Also is there a way to remove all the previously deleted toons from the database automatically to clean up database and save space?

[sunder702]

in the Char table the RemainTime defines whether or not a toon was deleted on purpose I believe.

ok just double checked it, RemainTime gives a value greater then 0 if you delete on purpose and 0 if you die with no rez rune.

[ProfNerwosol]

RemainTime is the server time at which the character will be deleted. Zero is the default value. Anything else above zero is server time at which the character should be deleted. Simply, Del=0 AND RemainTime=0 normal live character, Del=0 AND RemainTime>0 character deletion requested by user, Del=1 AND RemainTime>0 character deleted because user requested it, Del=1 AND RemainTime=0 dead UM.

To remove entries of characters deleted by users use such query:
DELETE FROM PS_GAMEDATA.DBO.CHARS WHERE DEL=1 AND REMAINTIME>0

[sunder702]

Originally Posted by ProfNerwosol

RemainTime is the server time at which the character will be deleted. Zero is the default value. Anything else above zero is server time at which the character should be deleted. Simply, Del=0 AND RemainTime=0 normal live character, Del=0 AND RemainTime>0 character deletion requested by user, Del=1 AND RemainTime>0 character deleted because user requested it, Del=1 AND RemainTime=0 dead UM.

To remove entries of characters deleted by users use such query:
DELETE FROM PS_GAMEDATA.DBO.CHARS WHERE DEL=1 AND REMAINTIME>0

there you are, even better.

[ProfNerwosol]

Yup, but that query will delete even characters pending to be deleted so use caution.

[lae]

With this you only save space in the Chars table.

For real space you need to delete all the items, etc of the deleted characters from the Charitems, UserStoredItems, etc.

Usually the Char table is the smallest.

If you real problem is the space itself I would delete all the info of the deleted characters from the dbos PS_Gamelog (Actionlog, UserLog) and from the PS_ChatLog (Chatlog).

[patoringa]

To retrieve an Ultimate dead just change the fields to zero and NULL is DeleteData?

[lae]

Originally Posted by patoringa

To retrieve an Ultimate dead just change the fields to zero and NULL is DeleteData?

Yes.
But good to change the location of the character, too, so he/she won't die again at the same spot from the same mob.

For example: Bootleg: map to 42 and the coordinates to 50/5/50.

[patoringa]

Thanks for tip