Hello Guys, today i am gonna release one addon for your website which show's all the players in every kingdom! [R.I.P Eng]
Don't Forget to say thanks! :)
PHP Code:
<!-- Online Status -->
<!-- mysql_connect($dbhost,$dbuser,$dbpass); -->
<div id="info">
<table>
<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass); // MySQL ->
mysql_select_db("player");
$rotes = "SELECT COUNT (*) as count from play_index WHERE empire NOT LIKE '2%' and ampire NOT LIKE '3%' ";
$rotes_count = mysql_fetch_object ($rotes) -> count+1;
$blaues = "SELECT COUNT (*) as count from player_index WHERE empire NOT LIKE '1%' and empire NOT LIKE '2%';";
$blaues_count = mysql_fetch_object ($blaues) -> count+1;
$gelbes = "SELECT COUNT (*) from player_index WHERE empire NOT LIKE '1%' and empire NOT LIKE '3%';";
$gelbes_count = mysql_fetch_object ($gelbes) -> count+1;
$online_count = $gelbes_count + $blaues_count + $rotes_count;
echo "<tr>";
echo "<div class='info'>";
echo "<tr><th><p>Rotes Reich: </th><th><b style='color:#BB232B'>$rotes_count</b></th></p></tr>";
echo "</div>";
echo "<br />";
echo "<tr><th><p>Blaues Reich: </th><th><b style='color:#0022FF'>$blaues_count</b></th></p></tr>";
echo "<br />";
echo "<tr><th><p>Gelbes Reich: </th><th><b style='color:#FFD500'>$blaues_count</b></th></p></tr>";
echo "<div class='acleear'>";
echo "<hr noshade width='100' size='1' align='left' color='#726E56'>";
echo "</div>";
echo "<br />";
echo "<tr><th><h1 style='color:#A0A0A0'>Gesamt: </th><th><b style='color:#A0A0A0'>$online_count</b></th></h1></tr>";
echo "</tr>";
?>
</table>
</div>
Don't Forget to say thanks! :)
