I created a php script that will post all info from the database.
I use this when searching for someones ip.
So it just pulls all users who ever entered my server and i can just "CTRL + F" with my browser (firefox) and search for his steam id
So i figured i would share it, maybe someone else might use it.
You just need to configure your mysql settings (at top of script)
WARNING : if you have a few thousand or more players in your database.
It might lag the SQL server for such a big QUERY, and might take 30 + seconds for your browser to load.
If people request a sql limit, i will code one in for you.
PHP Code:
<?php
// MYSQL SETTINGS
$mysql_username = "mysql_username_here";
$mysql_password = "mysql_password_here";
$mysql_database = "mysql_database_here";
$mysql_host = "localhost";
$link = mysql_connect($mysql_host, $mysql_username, $mysql_password);
if (!$link) { die('Could not connect: ' . mysql_error()); }
mysql_set_charset('utf8',$link);
// MYSQL ENCODING?
$charset = mysql_client_encoding($link);
echo "The current character set is: $charset <br />";
mysql_selectdb($mysql_database,$link);
$query = "SELECT * FROM player_tracker ORDER BY id ASC";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
$players_total = $num_rows;
echo 'Total Players = '.$players_total.'<br/>';
echo "
<html>
<head>
<title>Players</title>
<style type='text/css'>
table.sample {
border-width: 3px;
border-spacing: 3px;
border-style: ridge;
border-color: gray;
border-collapse: collapse;
background-color: white;
}
table.sample th {
border-width: 1px;
padding: 1px;
border-style: outset;
border-color: green;
background-color: rgb(153, 153, 153);
-moz-border-radius: ;
}
table.sample td {
border-width: 1px;
padding: 1px;
border-style: outset;
border-color: green;
background-color: rgb(153, 153, 153);
-moz-border-radius: ;
}
</style>
</head>
<body>
<table class='sample' border='0'>
<tr>
<th width='80'>steamid</th>
<th width='200'>playername</th>
<th width='20'>playerip</th>
<th width='20'>servertype</th>
<th width='20'>serverip</th>
<th width='20'>serverport</th>
<th width='20'>geoipcountry</th>
</tr>
";
while ($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$steamid = $row['steamid'];
$playername = $row['playername'];
$playerip = $row['playerip'];
$servertype = $row['servertype'];
$serverip = $row['serverip'];
$serverport = $row['serverport'];
$geoipcountry = $row['geoipcountry'];
$status = $row['status'];
//$playerip = 'disabled';
echo "
<tr>
<td width='100'>".$steamid."</td>
<td width='200'>".$playername."</td>
<td width='20'>".$playerip."</td>
<td width='20'>".$servertype."</td>
<td width='20'>".$serverip."</td>
<td width='20'>".$serverport."</td>
<td width='20'>".$geoipcountry."</td>
</tr>";
}
echo '
</table>
</body>
</html>
';
?>
Enjoy.
Any errors in my php let me know
Linear Mode
