Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 09:50

  • Please register to post and access all features, it's quick, easy and FREE!


HOW TO DETECT CHARACTER ONLINE OR NOT IN SQL SERVER?

Discussion on HOW TO DETECT CHARACTER ONLINE OR NOT IN SQL SERVER? within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2008
Posts: 17
Received Thanks: 9
HOW TO DETECT CHARACTER ONLINE OR NOT IN SQL SERVER?

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!?



pulpcorn is offline  
Old 02/09/2012, 11:37   #2
 
elite*gold: 0
Join Date: Nov 2011
Posts: 333
Received Thanks: 186
iv looked in db i cant find any thing about online characters too
its will be great if some body know way


ThElitEyeS is offline  
Old 02/09/2012, 12:09   #3
 
elite*gold: 0
Join Date: Jan 2008
Posts: 17
Received Thanks: 9
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!?
pulpcorn is offline  
Reply



« [WISH] [Dr.Abdelfettah] I need SMC_ServerControl.cfg, the newest one. | Qeustion »

Similar Threads
Q>Openkore 2.0.7 cannot detect all my character!
10/16/2011 - Ragnarok Online - 1 Replies
need help openkore cant detect all my charaters in my account....char 7 or 1/3
[DB.de BoT] Don't detect Character on ZSZC
04/11/2011 - SRO Private Server - 5 Replies
I played on ZSZC after 1.678 update my DB bot don't detect my character and don't write pink info in chat window. It's login normal but nothing appear in chat. I have this problem with all ver 0.8-1.1 I use crack from NoeX and from lolkop and on all have same problem Can some1 help me :(
The best Co private server .::MaX-Co Online::. With new style and ninja Character
12/14/2010 - CO2 PServer Archive - 18 Replies
Welcome Every One Exclusive and after more than 1 year We offer you http://img40.imageshack.us/img40/6634/un456987tit ledq.gif With Everything New http://img401.imageshack.us/img401/6686/sshot1235 891.jpg http://img63.imageshack.us/img63/2199/sshot1qb.jp g http://img202.imageshack.us/img202/6634/un456987t itledq.gif With start you can get full +12 gears for free ^^ Just go to Cherry and choose your class to get your gear



All times are GMT +2. The time now is 09:50.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 3KeUpz52VCbhmLwuwydqxu6U1xsgbT8YT5
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2019 elitepvpers All Rights Reserved.