How to check a user login or not ?

[myShinichi]

Hi,

I want to know (view on database) how to check a user is login or not ? Some query or table contain that info ?

Thanks !

[MentaL]

[Simiramist]

hi i created big script :D

--by. Simiramist--
USE SRO_VT_ACCOUNT
SELECT*
FROM dbo.TB_User WHERE StrUserID like 'type here username'
now you get JID
SELECT*
FROM dbo._ShardCurrentUser WHERE nID like 'type here JID'
you get log date
USE SRO_VT_SHARD
SELECT*
FROM dbo._User WHERE UserJID like 'type here JID'
you get all character id's (1-4) in the account CharID
SELECT*
FROM dbo._Char WHERE CharID like 'CharID'
you get char data search LastLogout between the columns.

compare the two and you can get ONLINE or NO
have fun

[myShinichi]

hi i created big script :D

--by. Simiramist--
USE SRO_VT_ACCOUNT
SELECT*
FROM dbo.TB_User WHERE StrUserID like 'type here username'
now you get JID
SELECT*
FROM dbo._ShardCurrentUser WHERE nID like 'type here JID'
you get log date
USE SRO_VT_SHARD
SELECT*
FROM dbo._User WHERE UserJID like 'type here JID'
you get all character id's (1-4) in the account CharID
SELECT*
FROM dbo._Char WHERE CharID like 'CharID'
you get char data search LastLogout between the columns.

compare the two and you can get ONLINE or NO
have fun

nID in _ShardCurrentUser is auto increament number, not JID

[Caipi]

SELECT         
            chart.CharName16 as 'Player', 
            CASE 
                WHEN MAX(elog.EventID) = 4 THEN 'Online' 
                WHEN MAX(elog.EventID) = 6 THEN 'Offline' 
                ELSE '-' 
            END as 'Status',
            CASE 
                WHEN MAX(elog.EventID) = 6 THEN '0'
                WHEN LEN(MAX(elog.EventTime)) > 0 THEN DATEDIFF(MINUTE,cast(MAX(elog.EventTime) as datetime),GETDATE()) 
                ELSE '-' 
            END as 'Minutes',
            MAX(elog.EventTime) as Date
FROM        
            /*#*/_LogEventChar/*#*/ as elog
            JOIN /*#*/SRO_VT_SHARD.dbo._Char/*#*/ as chart on elog.CharID = chart.CharID    
WHERE        
            (elog.EventID = 4 OR elog.EventID = 6)
GROUP BY    chart.CharName16
HAVING        MAX(elog.EventID) = 4
ORDER BY    MAX(elog.EventID) asc 

[SnapPop]

SELECT         
            chart.CharName16 as 'Player', 
            CASE 
                WHEN MAX(elog.EventID) = 4 THEN 'Online' 
                WHEN MAX(elog.EventID) = 6 THEN 'Offline' 
                ELSE '-' 
            END as 'Status',
            CASE 
                WHEN MAX(elog.EventID) = 6 THEN '0'
                WHEN LEN(MAX(elog.EventTime)) > 0 THEN DATEDIFF(MINUTE,cast(MAX(elog.EventTime) as datetime),GETDATE()) 
                ELSE '-' 
            END as 'Minutes',
            MAX(elog.EventTime) as Date
FROM        
            /*#*/_LogEventChar/*#*/ as elog
            JOIN /*#*/SRO_VT_SHARD.dbo._Char/*#*/ as chart on elog.CharID = chart.CharID    
WHERE        
            (elog.EventID = 4 OR elog.EventID = 6)
GROUP BY    chart.CharName16
HAVING        MAX(elog.EventID) = 4
ORDER BY    MAX(elog.EventID) asc 

hehehe Caipi king of Queries

[myShinichi]

Char online in town but there are no record returned :(


Well done ! Thanks Caipi :)