BioHazard94
P[r]oland
Hello !
I edit script by Aleh:
http://otland.net/f118/gesior-acc-last-joined-free-houses-other-70272/
Add to yor database this code!
And to latestnews.php add this code !
Screen:
Look in practice:
HERE
I edit script by Aleh:
http://otland.net/f118/gesior-acc-last-joined-free-houses-other-70272/
Add to yor database this code!
Code:
ALTER TABLE `accounts` ADD `accounts` INT( 11 ) NOT NULL DEFAULT '0',
ALTER TABLE `players` ADD `players` INT( 11 ) NOT NULL DEFAULT '0';
And to latestnews.php add this code !
PHP:
$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, `players`.`id` DESC LIMIT 1;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$query3 = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$query4 = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `konto`=0;')->fetch();
$query5 = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `players`=0;')->fetch();
$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="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> '.$query['text'].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$query3[0].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts:</b> '.$query4[0].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Players:</b> '.$query5[0].'</center></td></tr>
</table></td></tr></table><br />';
Screen:
Look in practice:
HERE