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

Rebirth shown on homepage.

8408323

Hoster
Joined
Mar 6, 2009
Messages
432
Reaction score
26
I've got a question regarding rebirths, is it possible to show rebirths on homepage without any table in database? Like through storage in any way? (I might ask any further questions after your answers)

Thanks in advice,
8408323
 
Yes, it's possible to show the amount of rebirths through storages.
 
Why don't use tables in database?
I'm not so good with sql, just started to learn that.. So I don't know how to create such a table, maybe you can show me? :)


Yes, it's possible to show the amount of rebirths through storages.
PHP:
$rebirths = mysql_query("SELECT 'value' FROM `player_storage` WHERE `player_id` = ".$player->getId()." AND `key` = '85987'");
if (empty($rebirths)){
echo "You haven't done any rebirths yet.";
} else {
while($row = mysql_fetch_array($rebirths)){ 

    echo $row['value'];

}}
I don't get it to work, guess it could look something like that. I'm not too good on this.. or should I skip echo?
Thanks for your help so far guys! :)
 
This is how I did it for Gesior AAC (only AAC I've got installed at the moment).
PHP:
$rebirths = $SQL->query('SELECT SUM(`value`) AS `sum` FROM `player_storage` WHERE `key` = "85987" AND `player_id` = ' . $player->getId())->fetch();
if(!$rebirths['sum']) { $rebirthpoints = '0'; } else { $rebirthpoints = $rebirths['sum']; }
$main_content .= '<tr bgcolor="' . $bgcolor . '"><td>Rebirths:</td><td>' . $rebirthpoints . '</td></tr>';
 
My code look like this now
PHP:
///Queries /// 
$query = $SQL->query('SELECT `name`,`id`,`level`,`experience`,`group_id` FROM `players` WHERE `group_id` < 2 ORDER BY `level` 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(); 
///Rebirths///
$rebirths = $SQL->query('SELECT player_storage.value AS `sum`,players.name AS`name` FROM `player_storage` INNER JOIN `players` ON players.id = player_storage.player_id WHERE `key` = 85987 < 2 ORDER BY `value` DESC LIMIT 1;')->fetch();
if(!$rebirths['sum']) { $rebirthpoints = '0'; } else { $rebirthpoints = $rebirths['sum']; }
///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($rebirths['name']).'"> '.$rebirths['name'].'</a> '.urlencode($rebirthpoints ).' rebirths. Congratulations!</center></td></tr> 

    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> Welcome to SweYork\'s OT'.$query['text'].'</center></td></tr>  

    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>&raquo; <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> &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>'; 

	$main_content .= '<table border="0" width="100%">
	<tr>
		<td style="text-align: center; font-weight: bold;">
			<center><font color="green">News</font></center>
		</td>
	</tr>
</table>';

however, at the homepage it says " Balthazzar with 999999 rebirths" when he haven't done a single one. How does that come?
 
I've fixed the code for you.

PHP:
///Queries /// 
$query = $SQL->query('SELECT `name`,`id`,`level`,`experience`,`group_id` FROM `players` WHERE `group_id` < 2 ORDER BY `level` 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(); 


///Rebirths///
$rebirths = $SQL->query('SELECT SUM(`player_storage`.`value`) AS `sum`, `players`.`name`,`players`.`id` FROM `player_storage` INNER JOIN `players` ON `players`.`id` = `player_storage`.`player_id` WHERE `key` = 85987 ORDER BY `player_storage`.`value` DESC LIMIT 1;')->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($rebirth['name']).'"> '.$rebirth['name'].'</a> '.urlencode($rebirth['sum']).' rebirths. Congratulations!</center></td></tr>


    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> Welcome to SweYork\'s OT'.$query['text'].'</center></td></tr>  


    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>&raquo; <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> &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>'; 


    $main_content .= '<table border="0" width="100%">
    <tr>
        <td style="text-align: center; font-weight: bold;">
            <center><font color="green">News</font></center>
        </td>
    </tr>
</table>';
 
Sorry, didn't see this post until today.. However I've encountered a new problem and I rewrote your code, you had forgotten a s on $rebirths
Now the page says "Currently, the best player on the server is: Abdo with 205 rebirths." Even though he has 0 in storage, and if I increase storage to 1 the page says 206 rebirths. Shouldn't I have something if the value is 0, so it don't print them out?

PHP:
///Queries /// 
$query = $SQL->query('SELECT `name`,`id`,`level`,`experience`,`group_id` FROM `players` WHERE `group_id` < 2 ORDER BY `level` 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(); 
///Rebirths///
$rebirths = $SQL->query('SELECT SUM(`player_storage`.`value`) AS `sum`, `players`.`name`,`players`.`id` FROM `player_storage` INNER JOIN `players` ON `players`.`id` = `player_storage`.`player_id` WHERE `key` = 85987 ORDER BY `player_storage`.`value` DESC LIMIT 1;')->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($rebirths['name']).'"> '.$rebirths['name'].'</a> with '.urlencode($rebirths['sum']).' rebirths. Congratulations!</center></td></tr>


    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> Welcome to SweYork\'s OT'.$query['text'].'</center></td></tr>  


    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>&raquo; <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> &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>'; 


    $main_content .= '<table border="0" width="100%">
    <tr>
        <td style="text-align: center; font-weight: bold;">
            <center><font color="green">News</font></center>
        </td>
    </tr>
</table>';
 
Sorry, not sure why I removed that part. :p

PHP:
///Queries /// 
$query = $SQL->query('SELECT `name`,`id`,`level`,`experience`,`group_id` FROM `players` WHERE `group_id` < 2 ORDER BY `level` 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(); 
///Rebirths///
$rebirths = $SQL->query('SELECT `player_storage`.`value` AS `sum`, `players`.`name` AS `name` FROM `player_storage` INNER JOIN `players` ON `players`.`id` = `player_storage`.`player_id` WHERE `key` = "85987" ORDER BY `value` DESC LIMIT 1;')->fetch();
if(!$rebirths['sum']) { $rebirthpoints = '0'; } else { $rebirthpoints = $rebirths['sum']; }

if($rebirthpoints > 0)
    $test = 'Currently, the best player on the server is: <a href="index.php?subtopic=characters&name='.urlencode($rebirths['name']).'"> '.$rebirths['name'].'</a> with <b>'.$rebirthpoints.'</b> rebirths. Congratulations!';
else
    $test = 'Currently, noone has done any rebirths yet.';
///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>'.$test.'</center></td></tr>

    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> Welcome to SweYork\'s OT'.$query['text'].'</center></td></tr>  

    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>&raquo; <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> &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>'; 

    $main_content .= '<table border="0" width="100%">
    <tr>
        <td style="text-align: center; font-weight: bold;">
            <center><font color="green">News</font></center>
        </td>
    </tr>
</table>';
 
Last edited:
Thanks! :)
It shouldn't be any maximum value, right? Since I've only got players which have done less than ten rebirths. And if I increase their number of rebirths, it increases until it reaches 10 rebirths. Then they disappear and the next player appear instead. I'll rep you, but I want to solve all problems first! :)
 
Back
Top Bottom