[Release] Website addon kingdom players

[vBanex]

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]

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!

[LovecKrys]

Easier to use web API.

[vBanex]

Originally Posted by LovecKrys

Easier to use web API.

I Know,but i post this if someone need it.

[MityQ]

its give you the count of account, not the players, and not only online accounts.

[DexterSK]

$rotes = "SELECT COUNT (*) as count from play_index WHERE empire NOT LIKE '2%' and ampire NOT LIKE '3%' ";

DDDDDDDD

[kangar00]

It isn´t a big release, so post it here:


#closerequest

[Zevion]

#closed