Q> Website Online Player

[Sallycantdance]

hello everyone i would like to ask how to config the online player in the website thanks in advance

[Fluxion]

according to your picture, it seems that it is already activated, right?

[Sallycantdance]

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 

[Shakto]

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`)