Top Player 1 Website

[felipemko]

Why my tag in website dont show the 1st top?

<td><b>TOP Player: </b><a href="index.php?subtopic=characters&name=<? echo urlencode($query['name'])?>"><? echo $query['name'] ?></a> [<? echo urlencode($query['level'])?>]</td>

up

up

 

[raf]

Why my tag in website dont show the 1st top?



up

up

code you gave, mean nothing to us you gave us front-end part, could you post back-end please? (query code)

 

[felipemko]

Look, this is where need to show:
http://prntscr.com/42fzho

The code where take properties:

$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
    $players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
    $query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;')->fetch();
    $query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
    $banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
    $guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();

And here put the properties:

<tr align="center">
                                        <td><b>TOP Player: </b><a href="index.php?subtopic=characters&name=<? echo urlencode($query['name'])?>"><? echo $query['name'] ?></a> [<? echo urlencode($query['level'])?>]</td>
                                        <td> | </td>
                                        <td><b>Banned Accounts: <font color="#FFFACD"></b><? echo $banned[0] ?></td></font>
                                        <td> | </td>
                                        <td><b>Created Accounts: <font color="#FFFACD"></b><? echo $accounts[0];?></td></font>
                                    </tr>