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

[Gesior Acc] Last joined, Free Houses and other! [UPDATED]

shareon

New Member
Joined
Sep 5, 2012
Messages
5
Reaction score
0
Here is a script that i have customized:
PHP:
//######################## SHOW TICKERS AND NEWS #######################
$time = time();
///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` < '.$config['site']['players_group_id_block'].' 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();
///Players ///
$males = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `sex`=1;')->fetch();
$females = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `sex`=0;')->fetch();
///Vocations ///
$sorcer = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `vocation`=1;')->fetch();
$druid = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `vocation`=2;')->fetch();
$paladin = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `vocation`=3;')->fetch();
$knight = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `vocation`=4;')->fetch();

///End Queries ///
    $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>, player number '.$query2['id'].'. 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>&raquo; MORE INFO! &laquo;</center></td></tr> 
    <table border=0 cellpadding=0 cellspacing=1 width=100%>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$housesfree[0].'</center></td>
    <td><center><b>Rented Houses:</b> '.$housesrented[0].'</center></td></tr>      
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td>
    <td><center><b>Players</b> in database: '.$players[0].'</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Banned</b> accounts: '.$banned[0].'</center></td>
    <td><center><b>Guilds</b> in databese: '.$guilds[0].'</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Males</b> in database: '.$males[0].'</center></td>
    <td><center><b>Females</b> in databese: '.$females[0].'</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Sorcerers</b> in database: '.$sorcer[0].'</center></td>
    <td><center><b>Druids</b> in databese: '.$druid[0].'</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Paladins</b> in database: '.$paladin[0].'</center></td>
    <td><center><b>Knights</b> in databese: '.$knight[0].'</center></td></tr>

	</table></td></tr></table>';

///Don't delete this! Please respect my work!
$main_content .= '<div align="right"><small><b>Script by: <a href="http://otland.net/members/shareon/" target="_blank">Shareon</a></b></small></div><br />';
///Don't delete this! Please respect my work!

SCREEN SHOT
Namnlös.jpg
 
Just FYI, with Gesior 2012. Version 1.0.1 i had to change the $query query... This is what i had to change it to to get it to work..

Code:
$query = $SQL->query('SELECT `name`,`id`,`level`,`experience`,`group_id` FROM `players` WHERE `group_id` < 2 ORDER BY `level` DESC LIMIT 1;')->fetch();

from
Code:
[COLOR=#007700][FONT=monospace]>[/FONT][/COLOR][COLOR=#0000BB][FONT=monospace]query[/FONT][/COLOR][COLOR=#007700][FONT=monospace]([/FONT][/COLOR][COLOR=#DD0000][FONT=monospace]'SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '[/FONT][/COLOR][COLOR=#007700][FONT=monospace].[/FONT][/COLOR][COLOR=#0000BB][FONT=monospace]$config[/FONT][/COLOR][COLOR=#007700][FONT=monospace][[/FONT][/COLOR][COLOR=#DD0000][FONT=monospace]'site'[/FONT][/COLOR][COLOR=#007700][FONT=monospace]][[/FONT][/COLOR][COLOR=#DD0000][FONT=monospace]'players_group_id_block'[/FONT][/COLOR][COLOR=#007700][FONT=monospace]].[/FONT][/COLOR][COLOR=#DD0000][FONT=monospace]' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;'[/FONT][/COLOR][COLOR=#007700][FONT=monospace])->[/FONT][/COLOR][COLOR=#0000BB][FONT=monospace]fetch[/FONT][/COLOR][COLOR=#007700][FONT=monospace](); 
[/FONT][/COLOR][COLOR=#0000BB][FONT=monospace]$query2 [/FONT][/COLOR][COLOR=#007700][FONT=monospace]= [/FONT][/COLOR][COLOR=#0000BB][FONT=monospace]$SQL[/FONT][/COLOR][COLOR=#007700][FONT=monospace]->[/FONT][/COLOR][COLOR=#0000BB][FONT=monospace]query[/FONT][/COLOR][COLOR=#007700][FONT=monospace]([/FONT][/COLOR][COLOR=#DD0000][FONT=monospace]'SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;'[/FONT][/COLOR][COLOR=#007700][FONT=monospace])->[/FONT][/COLOR][COLOR=#0000BB][FONT=monospace]fetch[/FONT][/COLOR][COLOR=#007700][FONT=monospace]();
[/FONT][/COLOR]
 
To make it work with 1.0.1:

Lua:
//######################## SHOW TICKERS AND NEWS #######################
$time = time();
    $query = $SQL->query("SELECT * FROM `players` WHERE `group_id` < 3 ORDER BY `experience` DESC")->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 ///
 
I have problem:

Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE or '$' in C:\xampp\htdocs\pages\latestnews.php on line 33
 
Back
Top