[Modern] Pagina inicial com ultimo player criado, casas livres e top jogador,

[diarmaint 19]

OLá galera, Trazendo de outro fórum, vou ajudar vocês a deixar a página inicial do modern acc assim.

[Testado Modern Acc v3 Avuenja]

É simples, basta ir em \injections\home e criar uma nova pasta chamada Aleh-Table agora pegue esse código e salve dentro dessa pasta com o nome de injection.php

Citar

<?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 ///

?>

 

<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 " "; ECHO $query['level']; ECHO " Congratulations!</center></td></tr>

   <tr class=lightBorder><td><center><b>Server motd:</b>"; ECHO " "; 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 " ";  ECHO $housesfree[0]; ECHO "</center></td>

   <td><center><b>Rented Houses:</b>"; ECHO " "; ECHO $housesrented[0]; ECHO ".</center></td></tr>      

   <tr class=lightBorder><td><center><b>Accounts</b> in database:"; ECHO " ";  ECHO $accounts[0]; ECHO "</center></td>

   <td><center><b>Players</b> in database:"; ECHO " ";  ECHO $players[0]; ECHO "</center></td></tr>

   <tr class=lightBorder><td><center><b>Banned</b> accounts:"; ECHO " ";  ECHO $banned[0]; ECHO "</center></td>

   <td><center><b>Guilds</b> in databese:"; ECHO " "; 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.  

Por fim, edite aqui 

<script>

$(document).ready(function() {$('#serverStats').fadeIn(7000)});

</script>

o tempo que vai levar para aparecer. no meu deixei em 3000

Fim

Créditos.

Aleh < da otland

Eu < por traduzir e trazer até aqui o/

 

Editado Agosto 14, 2018 por diarmaint

[LeoTK 173]

valeu xD tava procurando isso um tempo mas não achei xD

[diarmaint 19]

@Brunds