How to delete old char by LastloginTime

Results 1 to 1 of 1
  1. #1
    Member 123we is offline
    MemberRank
    Apr 2012 Join Date
    Any Where :>Location
    87Posts

    How to delete old char by LastloginTime

    Query

    Code:
    SELECT al.CharID,  uwc.UserJID FROM SRO_VT_SHARD.dbo._User uwc LEFT JOIN SRO_VT_SHARD.dbo._Char al ON uwc.CharID = al.CharIDWHERE LastLogout < '2014-05-22 23:59:59' AND Deleted=0 AND CurLevel <111
    
    UPDATE [SRO_VT_SHARD].[dbo].[_Char]
       SET [Deleted] = 1
     WHERE LastLogout < '2014-05-22 23:59:59' AND Deleted=0 AND CurLevel <111

    Video guide :







Advertisement