Hello friends. I need a help in php question
This ranking shows top reset, level. But I need to get the player status to show the top ranking with green when is online and red when is offline.
Is possible someone that understand php help me with that?
Like add a table p.isonline ( 0 to offline, 1 to online)
Thanks.
Oh, the online table show in players_online.player_id
PHP:
SELECT p.name, ps.value AS resets, p.level, p.vocation, p.lookbody, p.lookfeet, p.lookhead, p.looklegs, p.looktype, p.lookaddons
FROM players p
LEFT JOIN player_storage ps ON ps.player_id = p.id AND ps.key = 66037
where p.account_id != 2 AND p.deleted = 0 and p.group_id <= 2
ORDER BY ps.value DESC, p.level DESC
LIMIT 5
This ranking shows top reset, level. But I need to get the player status to show the top ranking with green when is online and red when is offline.
Is possible someone that understand php help me with that?
Like add a table p.isonline ( 0 to offline, 1 to online)
Thanks.
Oh, the online table show in players_online.player_id
Attachments
-
1725619955672.webp15.9 KB · Views: 7 · VirusTotal