First, sorry for the wrong section.
The reason for my request is players found a way to change faction using the player-res-script.
I know theres' a SQL script here at epvprs, to res all dead ums during maintenance, but we have *very* old dated dead ums on our DB, so the ADM is afraid to introduce some bug using that script. He solved it by now making the res runes almost 'eternal'. But there's still the problem on resurrecting just 'recently dead' ums.
I was thinking on taking this line:
Code:
DECLARE dead_um CURSOR FOR
SELECT UserUID,UserID,CharID,Slot,CharName,Family FROM PS_GameData.dbo.Chars WHERE Del=1 AND RemainTime=0;
and change it to this:
Code:
DECLARE dead_um CURSOR FOR
SELECT UserUID,UserID,CharID,Slot,CharName,Family FROM PS_GameData.dbo.Chars WHERE Del=1 AND RemainTime=0 AND DeleteDate > '01/07/2012 00:00:00';
PS: I'm talking about this script: