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

Results 1 to 13 of 13
  1. 24-09-22 #1
    XinMaiKeJi
    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：
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    [Help] How to count the number of people online?
  3. 24-09-22 #2
    LukasCCB
    My Status --> LukasCCB is offline
    MemberRank
    Apr 2013 Join Date
    CracolandiaLocation
    1,190Posts
    PHP Code:
    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 
    Reply With Quote Reply With Quote
  4. 24-09-22 #3
    XinMaiKeJi
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts
    Quote Originally Posted by LukasCCB View Post
    PHP Code:
    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
    Reply With Quote Reply With Quote
  5. 24-09-22 #4
    DouglasPro
    Play Alpha MMO DouglasPro is offline
    MemberRank
    Nov 2014 Join Date
    //HKEY//RJ_BRLocation
    391Posts
    use the code from lukasccbixa it will work! :D
    Reply With Quote Reply With Quote
  6. 24-09-22 #5
    XinMaiKeJi
    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?
    Reply With Quote Reply With Quote
  7. 24-09-22 #6
    DouglasPro
    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....
    Reply With Quote Reply With Quote
  8. 24-09-22 #7
    XinMaiKeJi
    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")"
    Reply With Quote Reply With Quote
  9. 24-09-22 #8
    DouglasPro
    Play Alpha MMO DouglasPro is offline
    MemberRank
    Nov 2014 Join Date
    //HKEY//RJ_BRLocation
    391Posts
    no problem
    Reply With Quote Reply With Quote
  10. 24-09-22 #9
    XinMaiKeJi
    Apprentice XinMaiKeJi is offline
    MemberRank
    Sep 2022 Join Date
    13Posts
    Quote Originally Posted by LukasCCB View Post
    PHP Code:
    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!
    Reply With Quote Reply With Quote
  11. 24-09-22 #10
    DouglasPro
    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...
    Reply With Quote Reply With Quote
  12. 24-09-22 #11
     Ketchup 
    ‎‎‎‎ 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.
    Reply With Quote Reply With Quote
  13. 25-09-22 #12
    LukasCCB
    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?
    Reply With Quote Reply With Quote
  14. 27-09-22 #13
    XinMaiKeJi
    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!
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement