Hello, I decided to convert [Gesior Acc] Last joined, Free Houses and other! to Modern AAC.
You can change the colors of the table easily at here.
Remember to change your server name at here
You can change the colors of the table easily at here.
Code:
$lightborder = '#282828';
$darkborder = '#242424';
Remember to change your server name at here
Code:
$servername = 'Your server name here';
Code:
<?php
/////////////////////////////////////////////////////////////////////////////////////////
//The new edition of my script: Best Player, Last joined and something new Server Motd.//
/////////////////////////Everything in the new appearance.///////////////////////////////
//////////////////////////////////////by Aleh///////////////////////////////////////////
/////////////////////////Converted to Modern AAC by MiPo91///////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();
//Colors//
$lightborder = '#282828';
$darkborder = '#242424';
$servername = 'Your server name here';
///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` < 2 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();
$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
///End Queries ///
echo '<table bgcolor="'.$darkborder.'" border=0 cellpadding=4 cellspacing=1 width=100%>
<tr bgcolor="'.$darkborder.'"><td align="center" class=white colspan=1><b>Welcome to '.$servername.'.</b></td></tr>
<tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>
<tr bgcolor="'.$darkborder.'"><td><center>Last joined us: <a href="/index.php/character/view/'.urlencode($query2['name']).'">'.$query2['name'].'</a>, player number '.$query2['id'].'. Welcome and wish you a nice game!</center></td></tr>
<tr bgcolor="'.$lightborder.'"><td><center>Currently, the best player on the server is: <a href="/index.php/character/view/'.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
<tr bgcolor="'.$lightborder.'"><td><center><b>Server motd:</b> '.$query['text'].'</center></td></tr>
<table border=0 cellpadding=0 cellspacing=1 width=100%>
<tr bgcolor="'.$lightborder.'"><td><center><b>Free Houses:</b> '.$housesfree[0].'</center></td>
<td><center><b>Rented Houses:</b> '.$housesrented[0].'</center></td></tr>
<tr bgcolor="'.$lightborder.'"><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td>
<td><center><b>Players</b> in database: '.$players[0].'</center></td></tr>
<td><center><b>Guilds</b> in database: '.$guilds[0].'</center></td></tr>
<tr bgcolor="'.$lightborder.'"><td><center><b>Banned</b> accounts: '.$banned[0].'</center></td>
<td><center><b>Guilds</b> in database: '.$guilds[0].'</center></td></tr>
</table></td></tr></table>';
///Don't delete this! Please respect my work! I am counting on reputation.
echo '<div align="right"><small><b>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b><br /><b>Converted to Modern AAC by: <a href="http://otland.net/members/mipo91/">MiPo91</a></b></small></div><br />';
///Don't delete this! Please respect my work! I am counting on reputation.
?>