Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

ImportBot · December 3, 2011

Originally Posted by Legate*:

I need this settings:

Ranking by Score (yes/no)

overall Ranking (yes/no)

Determinate the broken query.

Ranking by Score: no

overall Ranking: no

ImportBot · December 3, 2011

Originally Posted by XpKiller*:

XP, thanks for the queries once again! For the second query of your post: I don't want to filter (where-clause) with servername, I want to see it back in the results. I can't seem to get that working as well...

So what I would like to have is the servername and then the stats fom the player.

Code:

SELECT ts.ServerName, `AEK-971_kills` , `AEK-971_hs` , `AEK-971_deaths` , `AN-94_Abakan_kills` , `AN-94_Abakan_hs` , `AN-94_Abakan_deaths` , `AS_Val_kills` , `AS_Val_hs` , `AS_Val_deaths` , `F2000_kills` , `F2000_hs` , `F2000_deaths` , `M16A4_kills` , `M16A4_hs` , `M16A4_deaths` , `AK74M_kills` , `AK74M_hs` , `AK74M_deaths` , `G3A3_kills` , `G3A3_hs` , `G3A3_deaths` , `KH2002_kills` , `KH2002_hs` , `KH2002_deaths` , `M416_kills` , `M416_hs` , `M416_deaths`
FROM tbl_server_player tsp
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
INNER JOIN tbl_weapons_assaultrifle twa ON tsp.StatsID = twa.StatsID
INNER JOIN tbl_server ts ON tsp.ServerID = ts.ServerID
WHERE tpd.SoldierName = "CptChaos"

@Legate

do you use a tbalesuffix?

Will look at this.

ImportBot · December 3, 2011

I made a stats page for a phpBB forum based off the data collected by this plugin.

Example:
http://thetacteam.info/stats.php

If you use it, you must enable the "Allow php in templates" feature located in Admin Control Panel -> General Tab -> Security Settings section. Otherwise it won't parse the ... section.

<table class="tablebg" width="100%" cellspacing="1"> 
<tr> 
<td class="row1"><div class="gen">
<table border="0" width="100%" align="center">
<tr>
<td>
<center>
<!-- PHP -->

//DATABASE INFORMATION

$db['host']		='YOUR_HOSTS_ADDRESS';
$db['uname']	='YOUR_DATABASE_USER_NAME';
$db['pass']		='YOUR_DATABASE_PASSWORD';
$db['name']		='YOUR_DATABASE_NAME';

//DATABASE ACCESS

mysql_connect($db['host'], $db['uname'], $db['pass']);
mysql_select_db("$db[name]") or die ("<b><center><br><br>Unable to access database. Please notify administrator.</center></b>");

//PAGE CONTENT

//CONTENT TABLE

echo "<br><br><table width='100%'>";

//LEFT SPACER

echo "<tr><td width='5%'>";
echo "</td><td>";

//END LEFT SPACER

//CENTER CONTENT

echo "<table width='100%' class='tablebg'>";
echo "<tr><td class='row1'>";
		
//CENTER SEARCH BLOCK

echo "<table align='left' width='100%' border='0'>";
echo "<form action='stats.php' method='POST'>";
echo "<tr><td>";
echo "<font color='EEEEEE'>Search for player's stats:</font>  ";
echo "<input type='text' name='player_name' /> ";
echo "<input type='submit' name='search_player' value='Search' />";
echo "</form>";
echo "</td></tr>";
echo "</table>";
			
//END CENTER SEARCH BLOCK

//SPACER BELOWER SEARCH BLOCK

echo "<table width='100%'><tr><td>";
echo "</td></tr><tr><td></td></tr><tr><td></td></tr></table>";

//END SPACER BELOW SEARCH BLOCK

//BEGIN SEARCH PLAYER LOGIC

if($_POST['search_player'])
{
	$player_name = $_POST['player_name'];

//NO RESULTS RETURNED BLOCK

	if ($player_name == null){
		
		echo "<table width='100%' class='container' border='0'>";
		echo "<tr><td class='row1'>";
		echo "<br><center>Please enter a player name.</center><br>";
		echo "</td></tr>";
		echo "</table>";

//END NO RESULTS RETURNED BLOCK

	}
	else
	{

//BEGIN PLAYER NAME'S TITLE BLOCK

		echo "<table width='100%' class='container' border='0'>";
		echo "<tr><td class='row1'>";
		echo "<br><center><b class='genmed'><font color='EEEEEE'>$player_name's stats</font></b></center><br>";
		echo "</td></tr>";
		echo "</table>";

//END PLAYER NAME'S TITLE BLOCK

//BEGIN 16-SLOT RESULTS BLOCK

		echo "<table width='100%' class='container' border='0'>";
		echo "<tr><td class='row1'>";
		
		$player_data16_query = "SELECT * FROM tbl_playerdata_16 WHERE SoldierName = '$player_name'";
		$player_data16_result = mysql_query($player_data16_query);
		
		if(mysql_num_rows($player_data16_result)==0)
			{

				echo "<br><center>No player data found for 16-slot server.</center><br>";

			}
			else
			{

				echo "<b class='genmed'><font color='EEEEEE'>16-slot server</font></b><br>";

				while($player_data16_row = mysql_fetch_array($player_data16_result))
				{
					$PlayerID = $player_data16_row['PlayerID'];

					$playerid_16_query  = "SELECT * FROM tbl_server_player_16 WHERE PlayerID = '$PlayerID'";
					$playerid_16_result = mysql_query($playerid_16_query);

					while($playerid_16_row = mysql_fetch_array($playerid_16_result))
					{

						$StatsID = $playerid_16_row['StatsID'];

						$playerstats_16_query  = "SELECT * FROM tbl_playerstats_16 WHERE StatsID = '$StatsID'";
						$playerstats_16_result = mysql_query($playerstats_16_query);

						while($playerstats_16_row = mysql_fetch_array($playerstats_16_result))
						{

							$Score = $playerstats_16_row['Score'];
							$Kills = $playerstats_16_row['Kills'];
							$Deaths = $playerstats_16_row['Deaths'];
							$Headshots = $playerstats_16_row['Headshots'];
							$HSrationumber = ($Headshots / $Kills);
							$HSratio = round($HSrationumber, 2);
							$Rounds = $playerstats_16_row['Rounds'];
							$Killstreak = $playerstats_16_row['Killstreak'];
							$Deathstreak = $playerstats_16_row['Deathstreak'];
							$StatsID = $playerstats_16_row['StatsID'];
							$KDRnumber = ($Kills / $Deaths);
							$KDR = round($KDRnumber, 2);

//BEGIN 16-SLOT STATS INFORMATION

							echo "<table width='100%' border='0' class='container'>";
							echo "<tr>";
							echo "<td width='11%' style='text-align: center;'>Score: $Score</td>";
							echo "<td width='11%' style='text-align: center;'>Rounds Played: $Rounds</td>";
							echo "<td width='11%' style='text-align: center;'>Kills: $Kills</td>";
							echo "<td width='11%' style='text-align: center;'>Deaths: $Deaths</td>";
							echo "<td width='11%' style='text-align: center;'>KDR: $KDR</td>";			
							echo "<td width='11%' style='text-align: center;'>Headshots: $Headshots</td>";
							echo "<td width='11%' style='text-align: center;'>Headshot Ratio: $HSratio</td>";
							echo "<td width='11%' style='text-align: center;'>Killstreak: $Killstreak</td>";
							echo "<td width='11%' style='text-align: center;'>Deathstreak: $Deathstreak</td>";
							echo "</tr>";		
							echo "</table>";

//END 16-SLOT STATS INFORMATION

						}
					}
				}	
			}

echo "</td></tr>";
echo "</table>";

//END 16-SLOT RESULTS BLOCK

//BEGIN 32-SLOT RESULTS BLOCK

echo "<table width='100%' class='container' border='0'>";
echo "<tr><td class='row1'>";

$player_data32_query = "SELECT * FROM tbl_playerdata_32 WHERE SoldierName = '$player_name'";
$player_data32_result = mysql_query($player_data32_query);
		
		if(mysql_num_rows($player_data32_result)==0)
		{

			echo "<br><center>No player data found for 32-slot server.</center><br>";

		}
		else
		{

			echo "<b class='genmed'><font color='EEEEEE'>32-slot server</font></b><br>";

			while($player_data32_row = mysql_fetch_array($player_data32_result))
			{

				$PlayerID = $player_data32_row['PlayerID'];

				$playerid_32_query  = "SELECT * FROM tbl_server_player_32 WHERE PlayerID = '$PlayerID'";
				$playerid_32_result = mysql_query($playerid_32_query);

				while($playerid_32_row = mysql_fetch_array($playerid_32_result))
				{

					$StatsID = $playerid_32_row['StatsID'];

					$playerstats_32_query  = "SELECT * FROM tbl_playerstats_32 WHERE StatsID = '$StatsID'";
					$playerstats_32_result = mysql_query($playerstats_32_query);

					while($playerstats_32_row = mysql_fetch_array($playerstats_32_result))
					{

						$Score = $playerstats_32_row['Score'];
						$Kills = $playerstats_32_row['Kills'];
						$Deaths = $playerstats_32_row['Deaths'];
						$Headshots = $playerstats_32_row['Headshots'];
						$HSrationumber = ($Headshots / $Kills);
						$HSratio = round($HSrationumber, 2);
						$Rounds = $playerstats_32_row['Rounds'];
						$Killstreak = $playerstats_32_row['Killstreak'];
						$Deathstreak = $playerstats_32_row['Deathstreak'];
						$StatsID = $playerstats_32_row['StatsID'];
						$KDRnumber = ($Kills / $Deaths);
						$KDR = round($KDRnumber, 2);

//BEGIN 32-SLOT STATS INFORMATION

						echo "<table width='100%' border='0' class='container'>";
						echo "<tr>";
						echo "<td width='11%' style='text-align: center;'>Score: $Score</td>";
						echo "<td width='11%' style='text-align: center;'>Rounds Played: $Rounds</td>";
						echo "<td width='11%' style='text-align: center;'>Kills: $Kills</td>";
						echo "<td width='11%' style='text-align: center;'>Deaths: $Deaths</td>";
						echo "<td width='11%' style='text-align: center;'>KDR: $KDR</td>";			
						echo "<td width='11%' style='text-align: center;'>Headshots: $Headshots</td>";
						echo "<td width='11%' style='text-align: center;'>Headshot Ratio: $HSratio</td>";
						echo "<td width='11%' style='text-align: center;'>Killstreak: $Killstreak</td>";
						echo "<td width='11%' style='text-align: center;'>Deathstreak: $Deathstreak</td>";
						echo "</tr>";		
						echo "</table>";

//END 32-SLOT STATS INFORMATION

					}
				}
			}	
		}

echo "</td></tr>";
echo "</table>";
//END 32-SLOT RESULTS BLOCK

//BEGIN EXTERNAL STATS BLOCK

echo "<table width='100%' class='container' border='0'>";
echo "<tr>";
echo "<tr><td class='row1'>";
echo "<br><center>Check $player_name's stats at <a href='http://bf3stats.com/stats_pc/$player_name' target='_blank'>http://bf3stats.com</a>.</center><br>";
echo "</td></tr>";
echo "</table>";

//END EXTERNAL STATS BLOCK

	}
}

//END SEARCH PLAYER LOGIC

//BEGIN TOP PLAYERS CENTER BLOCK

echo "<br>";
echo "<table width='100%' border='0'>";
echo "<tr>";

//BEGIN TOP PLAYERS CENTER BLOCK LEFT BLOCK

echo "<td valign='top'>";

//BEGIN TOP-25 16-SLOT BLOCK

echo "<table width='100%' class='tablebg' border='0'>";
echo "<tr>";
echo "<th>Top 25 Players for 16-Slot server</th>";
echo "</tr>";
echo "<tr>";
echo "<td class='row1'>";

$count = 0;
$playerstats_16_query  = "SELECT * FROM tbl_playerstats_16 ORDER BY Score DESC LIMIT 25";
$playerstats_16_result = mysql_query($playerstats_16_query);

while($playerstats_16_row = mysql_fetch_array($playerstats_16_result))
{

	$Score = $playerstats_16_row['Score'];
	$StatsID = $playerstats_16_row['StatsID'];

	$playerid_16_query  = "SELECT * FROM tbl_server_player_16 WHERE StatsID = '$StatsID'";
	$playerid_16_result = mysql_query($playerid_16_query);

	while($playerid_16_row = mysql_fetch_array($playerid_16_result))
	{

		$PlayerID = $playerid_16_row['PlayerID'];

		$player_data_16_query  = "SELECT * FROM tbl_playerdata_16 WHERE PlayerID = '$PlayerID'";
		$player_data_16_result = mysql_query($player_data_16_query);

		while($player_data_16_row = mysql_fetch_array($player_data_16_result))
		{

			$SoldierName_16 = $player_data_16_row['SoldierName'];
			$count=$count+1;

//BEGIN PLAYER NAME POSITION BLOCK

						echo "<table width='100%' border='0' class='container'>";
						echo "<tr>";
						echo "<th style='text-align: left;'>";
						echo "<form action='stats.php' method='POST'>";
						echo "<input type='hidden' name='player_name' value='$SoldierName_16'/> ";
						echo "$count: <input type='submit' name='search_player' style='color:#99CCFF;width:140px;text-align:center;font-weight:bold' value='$SoldierName_16' /> <font color='#8E8E8E' size='1'>click name for stats</font>";
						echo "</form>";
						echo "</th>";
						echo "<tr>";
						echo "<td width='100%' style='text-align: left;' class='row1'>      Score: $Score</td>";
						echo "</tr>";		
						echo "</table>";

//END PLAYER NAME POSITION BLOCK

		}
	}
}

echo "</td>";
echo "</tr>";
echo "</table>";

//END TOP-25 16-SLOT BLOCK

echo "</td>";

//END TOP PLAYERS CENTER BLOCK LEFT BLOCK

//BEGIN TOP PLAYERS CENTER BLOCK MIDDLE SPACER

echo "<td width='1%'></td>";

//END TOP PLAYERS CENTER BLOCK MIDDLE SPACER

//BEGIN TOP PLAYERS CENTER BLOCK RIGHT BLOCK

echo "<td valign='top'>";

//BEGIN TOP-25 32-SLOT BLOCK

echo "<table width='100%' border='0' class='tablebg'>";
echo "<tr>";
echo "<th>Top 25 Players for 32-Slot server</th>";
echo "</tr>";
echo "<tr>";
echo "<td class='row1'>";

$count = 0;
$playerstats_32_query  = "SELECT * FROM tbl_playerstats_32 ORDER BY Score DESC LIMIT 25";
$playerstats_32_result = mysql_query($playerstats_32_query);

while($playerstats_32_row = mysql_fetch_array($playerstats_32_result))
{

	$Score = $playerstats_32_row['Score'];
	$StatsID = $playerstats_32_row['StatsID'];

	$playerid_32_query  = "SELECT * FROM tbl_server_player_32 WHERE StatsID = '$StatsID'";
	$playerid_32_result = mysql_query($playerid_32_query);

	while($playerid_32_row = mysql_fetch_array($playerid_32_result))
	{

		$PlayerID = $playerid_32_row['PlayerID'];

		$player_data_32_query  = "SELECT * FROM tbl_playerdata_32 WHERE PlayerID = '$PlayerID'";
		$player_data_32_result = mysql_query($player_data_32_query);

		while($player_data_32_row = mysql_fetch_array($player_data_32_result))
		{

			$SoldierName_32 = $player_data_32_row['SoldierName'];
			$count=$count+1;

//BEGIN PLAYER NAME POSITION BLOCK

			echo "<table width='100%' border='0' class='container'>";
			echo "<tr>";
			echo "<th style='text-align: left;'>";
			echo "<form action='stats.php' method='POST'>";
			echo "<input type='hidden' name='player_name' value='$SoldierName_32'/> ";
			echo "$count: <input type='submit' name='search_player' style='color:#99CCFF;width:140px;text-align:center;font-weight:bold' value='$SoldierName_32' /> <font color='#8E8E8E' size='1'>click name for stats</font>";
			echo "</form>";
			echo "</th>";
			echo "</tr>";
			echo "<tr>";
			echo "<td width='100%' style='text-align: left;' class='row1'>      Score: $Score</td>";
			echo "</tr>";		
			echo "</table>";

//END PLAYER NAME POSITION BLOCK

		}
	}
}

echo "</td>";
echo "</tr>";
echo "</table>";

//END TOP-25 32-SLOT BLOCK

echo "</td>";

//END TOP PLAYERS CENTER BLOCK RIGHT BLOCK

echo "</tr></table>";

//END TOP PLAYERS CENTER BLOCK

echo "</td></tr></table>";
echo "</td>";

//END CENTER CONTENT BLOCK

//BEGIN RIGHT SPACER BLOCK

echo "<td width='5%'></td>";

//END RIGHT SPACER BLOCK

echo "</tr>";
echo "</table>";

//END CONTENT TABLE

echo "<br><br>";

<!-- ENDPHP -->
</center>
</td>
</tr> 
</table>
</td>
</tr>
</table>

I am still a bit of a novice at PHP, but this may help someone.

You would need to enter all the correct database information. Also, your table names would have to be corrected if you are using a different structure than me. I am using two suffixes in the same database for two different servers. One has the suffix of _16 and the other the suffix of _32. You would have to correct for this.

You may have to change the CSS style references if your style doesn't use the same reference names.

Edited August 7, 2019 by maxdralle

ImportBot · December 3, 2011

Originally Posted by XpKiller*:

@ty_ger07

You could put everything in one query and you would get a better performance. If your db gets more entries you can run in performance issues.

SQL Query:

Code:

SELECT tpd.SoldierName, tps.Score, tps.Kills, tps.Deaths, tps.Suicide, tps.TKs, tps.Playtime, tps.Headshots, tps.Rounds, tps.Killstreak, tps.Deathstreak  
FROM tbl_playerstats tps 
INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
WHERE tsp.ServerID = 1
ORDER BY Score DESC 
LIMIT 25

ImportBot · December 3, 2011

Originally Posted by ty_ger07*:

I've never done a query in that sort of syntax. Does php support it?

ImportBot · December 3, 2011

Originally Posted by XpKiller*:

I've never done a query in that sort of syntax. Does php support it?

Yes Php support this . This just a SQlquery. All kind of SQL Query is support by PHP.

If you question regarding the syntax feel free to ask.

ImportBot · December 3, 2011

Originally Posted by Legate*:

@Legate

do you use a tbalesuffix?

Will look at this.

Nope

ImportBot · December 3, 2011

Originally Posted by CptChaos*:

Code:

SELECT ts.ServerName, `AEK-971_kills` , `AEK-971_hs` , `AEK-971_deaths` , `AN-94_Abakan_kills` , `AN-94_Abakan_hs` , `AN-94_Abakan_deaths` , `AS_Val_kills` , `AS_Val_hs` , `AS_Val_deaths` , `F2000_kills` , `F2000_hs` , `F2000_deaths` , `M16A4_kills` , `M16A4_hs` , `M16A4_deaths` , `AK74M_kills` , `AK74M_hs` , `AK74M_deaths` , `G3A3_kills` , `G3A3_hs` , `G3A3_deaths` , `KH2002_kills` , `KH2002_hs` , `KH2002_deaths` , `M416_kills` , `M416_hs` , `M416_deaths`
FROM tbl_server_player tsp
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
INNER JOIN tbl_weapons_assaultrifle twa ON tsp.StatsID = twa.StatsID
INNER JOIN tbl_server ts ON tsp.ServerID = ts.ServerID
WHERE tpd.SoldierName = "CptChaos"

@Legate

do you use a tbalesuffix?

Will look at this.

You sir, are very generous! #LikeABoss!

I also have a feature request: is it possible to add the Procon (layer) connection info to the server table (Procon's IP-address and port, just like the gameserver the Procon layer is connected to) as well? Now I mod that in manually, if it would be part of this awesomeness anyone can easily make a check wether if Procon is up or not.

ImportBot · December 3, 2011

Originally Posted by tbagger*:

Great work thus far on the plugin XPkiller. Any news on when the full completed version might be ready? My server is currently ranked 8th in the world on GameTracker and I have this plugin implemented. However with some of the functions not working it is hard to advertise that we have it!

ImportBot · December 4, 2011

Originally Posted by CptChaos*:

I'm not sure if it's a bug or not: but I see people having deaths with the medkit, but I don't see users with kills with it...

ImportBot · December 4, 2011

Originally Posted by Clay52*:

I got this at the end then start of a new round: Otherwise the plugin has been really nice, works great...

[10:12:37 98] Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.

at System.Data.Odbc.OdbcDataReader.GetRowCount()

at System.Data.Odbc.OdbcDataReader.FirstResult()

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[10:12:39 43] Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.