Achei Todas Alem da casa

$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 `lastwarning`>1;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();

 Oque você Pediu

$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `lastwarning`>1;')->fetch();

Não funciona pois o seu esta em latest news, que está dentro de html, o meu é em layout que é php, então é diferente, e eu nao sei adaptar

Tenta o seguinte

Aonde tá

        $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();

Add

$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();

Depois Aqui

<td><b>Último character: </b><a href="?subtopic=characters&name=<? echo urlencode($query2['name']); ?>"><? echo $query2['name']; ?></a></td>
<td> | </td>
<td><b>Total de Guilds: <font color="#FFFACD"></b><? echo $guilds[0]?></td></font>
<td> | </td>
<td><b>Total de Players: <font color="#FFFACD"></b><? echo $players[0];?></td></font>
</tr>
									
<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>Contas Banidas: <font color="#FFFACD"></b><? echo $banned[0] ?></td></font>
<td> | </td>
<td><b>Contas Criadas: <font color="#FFFACD"></b><? echo $accounts[0];?></td></font>

Add 

<td><b>Houses Free: <font color="#FFFACD"></b><? echo $housesfree[0];?></td></font>

Editado Julho 14, 2014 10 anos por macacaue (veja o histórico de edições)

Mas não é so as houses q nao aparece, só usei ela como exemplo.. pois nada aparece, nem top, nem houses, nem banidos, nem nada

O meu não apareceu Enquanto Eu não Liguei o server... Pode ser isto