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
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>';