HOW TO DETECT CHARACTER ONLINE OR NOT IN SQL SERVER?

02/09/2012 07:27 pulpcorn#1
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!?
02/09/2012 11:37 ThElitEyeS#2
iv looked in db i cant find any thing about online characters too
its will be great if some body know way
02/09/2012 12:09 pulpcorn#3
I think we don't have fully database...
take a look at this procedure _ReportDailyLog_Connection
Quote:
....
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
Quote:
...
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!?