• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC Gessior acc Lastnews.php

Sirdonald

Member
Joined
Jan 16, 2012
Messages
119
Reaction score
11
TFS 0.4
hi I have a script that shows on the main page a table with information who recently joined the best player, etc.
The problem is that when I add it to my lastnews it doesn't work and a white page is displayed when entering the site






PHP:
///Queries ///
$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();
$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
///End Queries ///




$main_content .= '<center><div class="NewsHeadline">
    <div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
        <table border="0">
            <tr>
                <td style="text-align: center; font-weight: bold;">
                    <font color="white">WELCOME to ' . $config['server']['serverName'] . ' !</font>
                </td>
            </tr>
        </table>
    </div>
</div></center>


';



$kutas = $accounts[0] + 300;
$kutas1 = $players[0] + 300;
$kutas2 = $guilds[0] + 4;







    $main_content .= '
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Ostatnio dolaczyl do nas: <b><a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a></b>, gracz numer '.$kutas1.'.</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Obecnie najlepszym graczem na serwerze jest: <b><a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).')</b>.</center></td></tr>
    <table border=0 cellpadding=0 cellspacing=1 width=100%>   
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts</b> in database: '.$kutas.'.</center></td>
    <td><center><b>Players</b> in database: '.$kutas1.'.</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>House</b> in game: 514.</center></td>
    <td><center><b>Guilds</b> in databese: '.$kutas2.'.</center></td></tr>

</table></td></tr></b></table>';
 
that means either you placed the code in the wrong place or the code is not written correctly
 
Back
Top