Thread: [Release] Simple statistics page

This is not made by me !!!

Credits: victov

Here is a simple statistics page i made.
You should edit the file, and fill in your own host, username, and password.
Then import it and use it on your own website :)

Here's a little preview:
[Only registered and activated users can see links. ]

PHP Code:

<?php
    
    ///////////////////////////////////////
    //         T0ba wAs Her3             //
    ///////////////////////////////////////
    
    $HOST = "localhost"; // YOUR HOST NAME HERE!
    $USERNAME = "";      // YOUR USERNAME HERE!
    $PASS = "";             // YOUR PASSWORD HERE.

    mysql_connect($HOST, $USERNAME, $PASS);
    mysql_select_db("deb14735_logon");
    $NUM_ACC = mysql_fetch_object(mysql_query("SELECT COUNT(acct) AS acct FROM `accounts` WHERE lastip != ''"));
    $NUM_CHAR = mysql_fetch_object(mysql_query("SELECT COUNT( guid ) AS Count FROM characters WHERE 1"));
    $AVG_LEVEL = mysql_fetch_object(mysql_query("SELECT ROUND( AVG( level ) ) AS LevelAvg FROM characters LIMIT 1"))->LevelAvg;
    $HORDE_CHARS = mysql_fetch_object(mysql_query("SELECT COUNT( race ) AS HordeChars FROM characters WHERE race IN (2, 5, 6, 8 ,10)"));
    $ALLY_CHARS = mysql_fetch_object(mysql_query("SELECT COUNT( race ) AS AllyChars FROM characters WHERE race IN (1, 3, 4, 7 ,11)"));
    $HORDE_KILLS = mysql_fetch_object(mysql_query("SELECT SUM( killsLifeTime ) AS HordeKills FROM characters WHERE race IN (2, 5, 6, 8 ,10)"));
    $ALLY_KILLS = mysql_fetch_object(mysql_query("SELECT SUM( killsLifeTime ) AS AllyKills FROM characters WHERE race IN (1, 3, 4, 7 ,11)"));
?>

<br />
<h2>Statistics</h2>

<table width="300">
    <tr>
        <td colspan="2">
            <b style="margin-left:40px;">General</b>
        </td>
    </tr>
    <tr>
        <td>
            Registered Accounts*:
        </td>
        <td>
            <?php echo $NUM_ACC->acct; ?>
        </td>
    </tr>
    <tr>
        <td>
            Total Characters:
        </td>
        <td>
            <?php echo $NUM_CHAR->Count; ?>
        </td>
    </tr>
    <tr>
        <td>
            Average Chars Per Account:
        </td>
        <td>
            <?php echo round($NUM_CHAR->Count/$NUM_ACC->acct, 2); ?>
        </td>
    </tr>
    <tr>
        <td>
            Average Character Level:
        </td>
        <td>
            <?php echo $AVG_LEVEL; ?>
        </td>
    </tr>
    <tr>
        <td colspan="2">
            <b style="margin-left:40px;">Horde vs Alliance</b>
        </td>
    </tr>
    <tr>
        <td>
            Horde Characters:
        </td>
        <td>
            <?php echo $HORDE_CHARS->HordeChars; ?>
        </td>
    </tr>
    <tr>
        <td>
            Alliance Characters:
        </td>
        <td>
            <?php echo $ALLY_CHARS->AllyChars; ?>
        </td>
    </tr>
    
    <tr>
        <td>
            Total Horde Kills:
        </td>
        <td>
            <?php echo $HORDE_KILLS->HordeKills; ?>
        </td>
    </tr>
    <tr>
        <td>
            Total Alliance Kills:
        </td>
        <td>
            <?php echo $ALLY_KILLS->AllyKills; ?>
        </td>
    </tr>
</table><br>
<br>

*: At least logged in once.

Thanks for sharing.

thanks :)

Thank You!

thanks for sharing

Thanks :)

Thanks.

Thanks