[Help] How to count the number of people online?

[XinMaiKeJi]

Well, I plan to do an online population statistics, but I don't know where to start. I only know how to count when they are online, but I don't know how to count when they are offline：

 

[LukasCCB]

SELECT uc.LastUpdateDate, uc.Gamertag, uc.CustomerID, ud.CustomerID, ud.IsDeveloper, ud.AccountType, uc.GameMapId From UsersChars as uc    JOIN UsersData as ud ON    uc.CustomerID = ud.CustomerIDWHERE DATEDIFF(MINUTE, uc.LastUpdateDate, GETDATE()) <= 1

 

[XinMaiKeJi]

SELECT uc.LastUpdateDate, uc.Gamertag, uc.CustomerID, ud.CustomerID, ud.IsDeveloper, ud.AccountType, uc.GameMapId From UsersChars as uc    JOIN UsersData as ud ON    uc.CustomerID = ud.CustomerIDWHERE DATEDIFF(MINUTE, uc.LastUpdateDate, GETDATE()) <= 1

My database is sqlserver. It cannot run on my database. I want to try to detect online players. Can you teach me? thank you

 

[DouglasPro]

use the code from lukasccbixa it will work!

 

[XinMaiKeJi]

use the code from lukasccbixa it will work!

Does his code have this function?

 

[DouglasPro]

Does his code have this function?

yes....

 

[XinMaiKeJi]

yes....

Ok, sorry, I lost one when I copied it")"

 

[DouglasPro]

no problem

 

[XinMaiKeJi]

SELECT uc.LastUpdateDate, uc.Gamertag, uc.CustomerID, ud.CustomerID, ud.IsDeveloper, ud.AccountType, uc.GameMapId From UsersChars as uc    JOIN UsersData as ud ON    uc.CustomerID = ud.CustomerIDWHERE DATEDIFF(MINUTE, uc.LastUpdateDate, GETDATE()) <= 1

Thank you for your guidance and help me solve the problem successfully!

 

[DouglasPro]

next time create topic in the right section GigaToni MentaL delete this thread...

 

[Lodelight]

next time create topic in the right section GigaToni MentaL delete this thread...

Or we could just move it? Instead of tagging only 2 people you should report it next time.

Anyways, moved.

 

[LukasCCB]

DouglasAlmostPro can help you with words and no codes. sorry.
For it work, run in Query.

Want show players online in your website, launcher, where?

 

[XinMaiKeJi]

DouglasAlmostPro can help you with words and no codes. sorry.
For it work, run in Query.

Want show players online in your website, launcher, where?

It's already shown Thank you, boss!