• 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!

Where do I get this awesome table?!

Im sorry, you can delete this... I found it for Modern AAC :)

If somebody needs this here you are:
PHP:
<?php
//** Connection to the database **//
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = POT::getInstance()->getDBHandle();

include ('config.php');
/////////////////////////////////////////////////////////////////////////////////////////
//The new edition of my script: Best Player, Last joined and something new Server Motd.//
/////////////////////////Everything in the new appearance.///////////////////////////////
//////////////////////////////////////by  Aleh///////////////////////////////////////////
///////////////////////Modification For Modern Aac made by Kavvson///////////////////////
///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` 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 ///
?>

//** Fade Effect **/
//** You can change the speed of the fade in .fadeIn(7000) **/
<script>
$(document).ready(function() {$('#serverStats').fadeIn(7000)});
</script>

<?PHP
    echo " <div id=\"serverStats\" style=\"display: none;\"><table class=darkBorder border=0 cellpadding=4 cellspacing=1 width=100%>
    <tr class=vdarkBorder><td align=\"center\" class=white colspan=1><b>Welcome to "; ECHO $config['server_name']; ECHO "</b></td></tr>
    <tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>

    <tr class=lightBorder><td><center>Last joined us: <a href=\"#\">"; ECHO $query2['name']; ECHO "</a>"; ECHO ". Welcome and wish you a nice game!</center></td></tr>
    <tr class=lightBorder><td><center>Currently, the best player on the server is: <a href=\"#\">"; ; ECHO $query['name']; ECHO "</a>"; ECHO "&nbsp;"; ECHO $query['level']; ECHO " Congratulations!</center></td></tr>
    <tr class=lightBorder><td><center><b>Server motd:</b>"; ECHO "&nbsp;"; ECHO $query['text']; ECHO "</center></td></tr> 
    <table border=0 cellpadding=0 cellspacing=1 width=100%>

      <tr class=lightBorder><td><center><b>Free Houses:</b>"; ECHO "&nbsp;";  ECHO $housesfree[0]; ECHO "</center></td>
    <td><center><b>Rented Houses:</b>"; ECHO "&nbsp;"; ECHO $housesrented[0]; ECHO ".</center></td></tr>      
    <tr class=lightBorder><td><center><b>Accounts</b> in database:"; ECHO "&nbsp;";  ECHO $accounts[0]; ECHO "</center></td>
    <td><center><b>Players</b> in database:"; ECHO "&nbsp;";  ECHO $players[0]; ECHO "</center></td></tr>
    <tr class=lightBorder><td><center><b>Banned</b> accounts:"; ECHO "&nbsp;";  ECHO $banned[0]; ECHO "</center></td>
    <td><center><b>Guilds</b> in databese:"; ECHO "&nbsp;"; ECHO $guilds[0]; ECHO "</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></small></div><br /></div>";
///Don't delete this! Please respect my work! I am counting on reputation.  
?>
 
Back
Top