Quote:
Originally Posted by anatoliawar
I want to put the game's Status web !
|
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