GM Winter Posted February 12, 2022 Group: Members Topic Count: 176 Topics Per Day: 0.14 Content Count: 666 Reputation: 9 Joined: 12/04/20 Last Seen: Thursday at 06:46 AM Share Posted February 12, 2022 hello everyone i would like to ask how to config the online player in the website thanks in advance Quote Link to comment Share on other sites More sharing options...
0 Fluxion Posted February 13, 2022 Group: Members Topic Count: 11 Topics Per Day: 0.01 Content Count: 82 Reputation: 7 Joined: 12/29/18 Last Seen: Yesterday at 07:16 PM Share Posted February 13, 2022 according to your picture, it seems that it is already activated, right? Quote Link to comment Share on other sites More sharing options...
0 GM Winter Posted February 13, 2022 Group: Members Topic Count: 176 Topics Per Day: 0.14 Content Count: 666 Reputation: 9 Joined: 12/04/20 Last Seen: Thursday at 06:46 AM Author Share Posted February 13, 2022 2 hours ago, Yuno said: according to your picture, it seems that it is already activated, right? its only a online peak not the online players count that time the player is only 1 but it showing 2 Quote Link to comment Share on other sites More sharing options...
0 Shakto Posted February 26, 2022 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 402 Reputation: 89 Joined: 02/07/13 Last Seen: 1 hour ago Share Posted February 26, 2022 On 2/13/2022 at 6:28 AM, chadness said: its only a online peak not the online players count that time the player is only 1 but it showing 2 Change the SQL request then : Number of players online (with shops) SELECT COUNT(*) as online FROM `char` WHERE `online` = 1; Number of players online (without shops) SELECT COUNT(*) as online FROM `char` WHERE `online` = 1 and `char`.`char_id` NOT IN (select vendings.char_id FROM `vendings` INNER JOIN `char` ON `char`.`char_id` = `vendings`.`char_id`) Number of shops online SELECT COUNT(*) as online FROM `char` WHERE `online` = 1 and `char`.`char_id` IN (select vendings.char_id FROM `vendings` INNER JOIN `char` ON `char`.`char_id` = `vendings`.`char_id`) Quote Link to comment Share on other sites More sharing options...
Question
GM Winter
hello everyone i would like to ask how to config the online player in the website thanks in advance
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.