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?Why don't use tables in database?
Yes, it's possible to show the amount of rebirths through storages.
$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'];
}}
$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>';
///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>» <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> «</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>';
///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>» <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> «</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>';
///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>» <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> «</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>';
///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>» <a href="http://sweyork.no-ip.org/?subtopic=serverinfo">MORE INFO!</a> «</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>';