HOW TO DETECT CHARACTER ONLINE OR NOT IN SQL SERVER?

[pulpcorn]

Hi!

I'm doing some things in asp.net and I want to know how to check character is playing game or not in sql server or somewhere else...
I found column: LastLogout in _Char table but it can't solve my issue.

Can someone help!?

[ThElitEyeS]

iv looked in db i cant find any thing about online characters too
its will be great if some body know way

[pulpcorn]

I think we don't have fully database...
take a look at this procedure _ReportDailyLog_Connection

....
select top 1 @LogoutTime = EventTime
from _LogEventChar
where CharID = @CharID and EventTime > @LoginTime and EventID = 6 -- 6: logout
if (@@rowcount = 1)
begin
set @Elapsed_Min = datediff(minute, @LoginTime, @LogoutTime)
if (exists (select * from _TempConnectionLog where CharID = @CharID))
begin
select @TotalPlayMin = TotalPlayMin, @ConCount = ConCount from _TempConnectionLog where CharID = @CharID
set @TotalPlayMin = @TotalPlayMin + @Elapsed_Min
set @ConCount = @ConCount + 1
update _TempConnectionLog Set TotalPlayMin = @TotalPlayMin, ConCount = @ConCount where CharID = @CharID
end
else
begin
insert into _TempConnectionLog values (@CharID, @Elapsed_Min, 0, 1)
end
end

and

...
select CharID, EventTime
from _LogEventChar
where EventTime >= @Time_Begin and EventTime <= @Time_End and EventID = 4 -- 4: login
...

Can someone help please!?
I really need an answer

hello!? Anyone help!?