///Queries ///
$query = $SQL->query('SELECT name,level from players where group_id < 2 order by `experience` 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 `accounts` WHERE forum_name != "";')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0 and `flag` != "";')->fetch();
$wars = $SQL->query('SELECT COUNT(*) FROM `guild_wars`;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
///Queries end ///
$main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%>
<tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>Welcome to '.$config['server']['serverName'].'</b></td></tr>
<tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center>Last joined us: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>! Welcome and wish you a nice game!</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center>Currently, the best player on the server is: <a href="?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
<table border=0 cellpadding=0 cellspacing=1 width=100%>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><font color="red" size=4>Activated Accounts: '.$accounts[0].'</font></center></td>
<td><center><font color="red" size=4>Players: '.$players[0].'</font></center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Active guild wars:</b> '.$wars[0].'</center></td>
<td><center><b>Guilds</b> in databese: '.$guilds[0].'</center></td></tr>
</table></td></tr></table>';