USE [SRO_VT_LOG]
GO

SELECT TOP 10
CHARS.CharName16 AS [Character Name],
LOGS.EventTime AS [Login Time],
LOGS.CharID AS [Character ID]
FROM _LogEventChar AS LOGS WITH (NOLOCK)
INNER JOIN SRO_VT_SHARD.dbo._Char AS CHARS
ON LOGS.CharID = CHARS.CharID
WHERE LOGS.EventID = 4
ORDER BY LOGS.EventTime DESC

Genişletmek için tıkla ...

• _LogEventChar → character event log table
• EventID = 4 → login event
• EventTime → giriş zamanı
• _Char → karakter isim mapping
• TOP 10 → en son 10 login kaydı
• WITH (NOLOCK) → read performance (dirty read olabilir)

• Online activity tracking
• GM monitoring tool
• Player activity analysis
• Security / login audit
• Server activity dashboard

SELECT TOP 50 *
FROM _LogEventChar
WHERE EventID = 4
ORDER BY EventTime DESC

Genişletmek için tıkla ...