My idea is an event called on login/logout that writes to table LoginHistory which contains:
int LoginID, varchar PlayerName, varchar SteamID, varchar IPAddress, datetime LoginTime, datetime LogoutTime
Then, an in-game menu would prompt admins for how far back to search (5, 10, 15 minutes) and query the DB:
Code: Select all
DECLARE @SearchTime as INT = _MenuSelectedTime_
select
LoginHistory.LoginID
,LoginHistory.PlayerName
from LoginHistory
where LoginHistory.LogoutTime <= DateAdd(minute,@SearchTime,NOW())
Code: Select all
DECLARE @UserLoginID as INT = _PreviouslySelectedLoginID_
select --ALIASES
LoginHistory.PlayerName
from LoginHistory
where LoginHistory.SteamID in
(select LoginHistory.SteamID from LoginHistory where LoginHistory.LoginID = @UserLoginID)
Code: Select all
DECLARE @UserLoginID as INT = _PreviouslySelectedLoginID_
select --LANNERS
LoginHistory.PlayerName
,LoginHisotry.SteamID
from LoginHistory
where LoginHistory.IPAddress in
(select LoginHistory.IPAddress from LoginHistory where LoginHistory.LoginID = @UserLoginID)