Masa 2 Report post Posted September 30, 2015 (edited) 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 Spoiler <html> <head> <meta charset="utf-8"> <title>Exile stats</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"> </head> <body> <div class="container"> <?php $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"; } else{ $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 } else { $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"> <tr> <?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>";?> </tr> <!--//";--> <?php 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>"; mysqli_close($con); ?> <a href="http://ddaygaming.com">©ddaygaming.com</a> </div> </body> </html> Edited March 18, 2017 by Masa updated code: removed WHERE is_alive = 1 2 Share this post Link to post Share on other sites
BetterDeadThanZed 1006 Report post Posted October 3, 2015 There's this... http://exile.majormittens.co.uk/topic/1538-esp-exile-stats-page-20-updated/ Share this post Link to post Share on other sites
Trillseeker82 20 Report post Posted November 11, 2015 (edited) 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=https://inthegame.nl/exile-leaderboard/.]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 November 12, 2015 by Trillseeker82 Share this post Link to post Share on other sites