users online status

11/07/2011 19:57 anatoliawar#1
How can I add to my Rappelz online players ?
11/07/2011 20:11 Rangada#2
Search for [Telecaster].[dbo].[Character] in your Database. There are two colums named "login_time" and "logout_time". If logout_time is earlier than login_time the character should be online.
11/07/2011 20:13 anatoliawar#3
I want to put the game's Status web !

[Only registered and activated users can see links. Click Here To Register...]
11/07/2011 20:30 Rangada#4
Quote:
Originally Posted by anatoliawar View Post
I want to put the game's Status web !

[Only registered and activated users can see links. Click Here To Register...]
I understood that no need to ' ! '

Very Raw. Just proof of concept. Won`t work if a character logs in more than one time a day. But this shoould give you a raw view how this could be done. (If you want have it more excat you have probalby to do it webserver side. (Well, my knowgelge in mssql is very limited, but this is not hard to do with php or any other server capable language (.NET, JAVA whatever)
Code:
SELECT name
FROM [Telecaster].[dbo].[Character]
WHERE DATEDIFF(day, login_time, logout_time) < 0
05/24/2012 23:04 OnlyWorld#5
Good evening,

You still have no status players?
05/25/2012 00:53 BlueConnect#6
Quote:
Originally Posted by OnlyWorld View Post
Good evening,

You still have no status players?
Can u help me with something with my server ? :) :please: