vSRO Grab Online Players

[mrwinkles]

Is there a table in the DB the shows a log of what players are online?

Thanks.

[IceAmStiel]

SELECT l.CharID, DATEDIFF(MINUTE, l.EventTime, GETDATE()) 'MinutesOnline', l.EventTime 'OnlineSince', COUNT(1) OVER (PARTITION BY c.EventID) 'OnlineCount'
FROM dbo._LogEventChar c with(NOLOCK)
JOIN (SELECT CharID, MAX(EventTime) 'EventTime' FROM dbo._LogEventChar with(NOLOCK) WHERE EventID in (4, 6) GROUP BY CharID) l on c.EventTime = l.EventTime AND c.CharID = l.CharID
WHERE c.EventID = 4
ORDER BY MinutesOnline desc

Noidea if that is accurate ;d

[mrwinkles]

Originally Posted by IceAmStiel

SELECT l.CharID, DATEDIFF(MINUTE, l.EventTime, GETDATE()) 'MinutesOnline', l.EventTime 'OnlineSince', COUNT(1) OVER (PARTITION BY c.EventID) 'OnlineCount'
FROM dbo._LogEventChar c with(NOLOCK)
JOIN (SELECT CharID, MAX(EventTime) 'EventTime' FROM dbo._LogEventChar with(NOLOCK) WHERE EventID in (4, 6) GROUP BY CharID) l on c.EventTime = l.EventTime AND c.CharID = l.CharID
WHERE c.EventID = 4
ORDER BY MinutesOnline desc

Noidea if that is accurate ;d

Perfect thank you very much!