Sign in to follow this  

Simple statistic page

3 posts in this topic

I didn't found any statistic pages for exile mod so i made simple statistics page for our own server. Check here!
You need webserver and access to exile database to use this.

You can modify code as you like. :)

Save this code as YouCanChangeThisText.php



    <meta charset="utf-8">
    <title>Exile stats</title>
    <link rel="stylesheet" href="">

    <div class="container">
$con=mysqli_connect("localhost","username","password","database");  //server address, username, password, dbname
// Check connection
if (mysqli_connect_errno())
echo "Failed to connect to MySQL: " . mysqli_connect_error();
    //check order ascending or descending
    if (isset($_GET["order"])) {
        $sort = $_GET["order"];
        if ($_GET["order"] == "asc"){
            $sort = "desc";
            $order = "asc";
            $sort = "asc";
            $order = "desc";
    //check filter
       if (!isset($_GET["name"])) {
        $name = "name";
    if (isset($_GET["name"])) {
        $name = $_GET["name"];

$list=array('name', 'Money', 'score', 'kills', 'deaths');
if (in_array($name,$list))
    //variable ok
        $name = "name";

$query = mysqli_query($con,"SELECT * FROM account a INNER JOIN player p ON a.uid = p.account_uid  ORDER BY a.$name $order");

?><!--//echo "<table border='1'>-->
<table class="table">
<?php echo "<th><a href=\"?order=$sort&name=name\">Player Name</a></th>";?>
<?php echo "<th><a href=\"?order=$sort&name=money\">Money</a></th>";?>
<?php echo "<th><a href=\"?order=$sort&name=score\">Score</a></th>";?>
<?php echo "<th><a href=\"?order=$sort&name=kills\">Kills</a></th>";?>
<?php echo "<th><a href=\"?order=$sort&name=deaths\">Deaths</a></th>";?>

while($row = mysqli_fetch_array($query))
?><tr class="success"><?php
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['money'] . "</td>";
echo "<td>" . $row['score'] . "</td>";
echo "<td>" . $row['kills'] . "</td>";
echo "<td>" . $row['deaths'] . "</td>";
echo "</tr>";
echo "</table>";

<a href="">©</a>


Edited by Masa
updated code: removed WHERE is_alive = 1
  • Like 2

Share this post

Link to post
Share on other sites

Hey Masa nice statistics page. looks very good and simple and that's the way i like it :). We have run it on our webpage [url=]Link We made a little adjusment to fit our web style. Only we got a lttle problem with the sorting option. somethimes it's a lttle buggy and not sorting it well. Do you got the same problem??  

Edit: fixt the problem :)

Edited by Trillseeker82

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.