[Gesior AAC] Who is online fix for TFS 1.0

[Danger II]

Greetings,
since TFS 1.0 we dont have the column "online" in players table anymore, we have "players_online" table with players_id column in SQL instead..

Just one line have to be edited, a small change, which will let your whoisonline.php work well again...

in whoisonline.php search for:

$q = 'SELECT * FROM players WHERE world_id='.$id.' AND online=1';

and replace it with:

 $q = 'SELECT * FROM players, players_online WHERE players.id = players_online.player_id';

My script looks like this:
http://pastebin.com/WXdmWEzj


To MOD: If this post is in wrong section please move it..

 

[danio4don]

thanks

 

[averatec]

don't use ANSI-89 syntax it's bad habbit

corrected

$q = 'SELECT p.* FROM `players` p RIGHT JOIN `players_online` po ON p.id = po.player_id'