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

Results 1 to 13 of 13
  1. #1
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts

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

    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:


  2. #2
    My Status --> LukasCCB is offline
    MemberRank
    Apr 2013 Join Date
    CracolandiaLocation
    1,190Posts
    PHP Code:
    SELECT uc.LastUpdateDateuc.Gamertaguc.CustomerIDud.CustomerIDud.IsDeveloperud.AccountTypeuc.GameMapId From UsersChars as uc    JOIN UsersData as ud ON    uc.CustomerID ud.CustomerIDWHERE DATEDIFF(MINUTEuc.LastUpdateDateGETDATE()) <= 

  3. #3
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts
    Quote Originally Posted by LukasCCB View Post
    PHP Code:
    SELECT uc.LastUpdateDateuc.Gamertaguc.CustomerIDud.CustomerIDud.IsDeveloperud.AccountTypeuc.GameMapId From UsersChars as uc    JOIN UsersData as ud ON    uc.CustomerID ud.CustomerIDWHERE DATEDIFF(MINUTEuc.LastUpdateDateGETDATE()) <= 
    My database is sqlserver. It cannot run on my database. I want to try to detect online players. Can you teach me? thank you

  4. #4
    Play Alpha MMO DouglasPro is offline
    MemberRank
    Nov 2014 Join Date
    //HKEY//RJ_BRLocation
    391Posts
    use the code from lukasccbixa it will work! :D

  5. #5
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts
    Quote Originally Posted by DouglasPro View Post
    use the code from lukasccbixa it will work! :D
    Does his code have this function?

  6. #6
    Play Alpha MMO DouglasPro is offline
    MemberRank
    Nov 2014 Join Date
    //HKEY//RJ_BRLocation
    391Posts
    Quote Originally Posted by XinMaiKeJi View Post
    Does his code have this function?
    yes....

  7. #7
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts
    Quote Originally Posted by DouglasPro View Post
    yes....
    Ok, sorry, I lost one when I copied it")"

  8. #8
    Play Alpha MMO DouglasPro is offline
    MemberRank
    Nov 2014 Join Date
    //HKEY//RJ_BRLocation
    391Posts
    no problem

  9. #9
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts
    Quote Originally Posted by LukasCCB View Post
    PHP Code:
    SELECT uc.LastUpdateDateuc.Gamertaguc.CustomerIDud.CustomerIDud.IsDeveloperud.AccountTypeuc.GameMapId From UsersChars as uc    JOIN UsersData as ud ON    uc.CustomerID ud.CustomerIDWHERE DATEDIFF(MINUTEuc.LastUpdateDateGETDATE()) <= 
    Thank you for your guidance and help me solve the problem successfully!

  10. #10
    Play Alpha MMO DouglasPro is offline
    MemberRank
    Nov 2014 Join Date
    //HKEY//RJ_BRLocation
    391Posts
    next time create topic in the right section @GigaToni @MentaL delete this thread...

  11. #11
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    New YorkLocation
    2,927Posts
    Quote Originally Posted by DouglasPro View Post
    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.

  12. #12
    My Status --> LukasCCB is offline
    MemberRank
    Apr 2013 Join Date
    CracolandiaLocation
    1,190Posts
    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?

  13. #13
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts
    Quote Originally Posted by LukasCCB View Post
    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!



Advertisement