vSRO Grab Online Players

04/16/2013 22:07 mrwinkles#1

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

Thanks.

04/16/2013 23:30 IceAmStiel#2

Code:

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

04/17/2013 03:26 mrwinkles#3

Quote:

Originally Posted by IceAmStiel

Code:

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!