Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger'

[ImportBot]

Originally Posted by leibhold*:
 
Finshed so post - now back to my own web page work...

if(mysql_num_rows($player_data_result)!=0)
{
//BEGIN ASSAULT RIFLES BLOCK
Statsout("tbl_weapons_assaultrifle",$table_suffix,$ThisID,"Assault Rifle");
//END ASSAULT RIFLES BLOCK

//BEGIN LMG BLOCK
Statsout("tbl_weapons_lmg",$table_suffix,$ThisID,"Light Machine Gun Stats");
//END LMG BLOCK

//BEGIN SHOTGUN BLOCK
Statsout("tbl_weapons_shotgun",$table_suffix,$ThisID,"Shot Gun");
//END SHOTGUN BLOCK

//BEGIN SMG BLOCK
Statsout("tbl_weapons_smg",$table_suffix,$ThisID,"Submachine Gun Stats");
//END SMG BLOCK

//BEGIN SNIPER BLOCK
Statsout("tbl_weapons_sniperrifle",$table_suffix,$ThisID,"Sniper Rifle Stats");
//END SNIPER BLOCK

//BEGIN PISTOLS BLOCK
Statsout("tbl_weapons_handgun",$table_suffix,$ThisID,"Hand Gun Stats");
//END PISTOLS BLOCK

//BEGIN ROCKETS BLOCK
Statsout("tbl_weapons_projectileexplosive",$table_suffix,$ThisID,"Projectile Explosive Stats");
//END ROCKETS BLOCK

//BEGIN EXPLOSIVES BLOCK
Statsout("tbl_weapons_explosive",$table_suffix,$ThisID,"Explosives Stats");
//END EXPLOSIVES BLOCK

//BEGIN OTHER WEAPONS BLOCK
Statsout("tbl_weapons_melee",$table_suffix,$ThisID,"Other Weapons Stats");
//END OTHER WEAPONS BLOCK
}

Function Statsout($tbl_name,$tbl_suffix,$TheID,$headingprint)
{
		$GetColumnNames = mysql_query("SHOW COLUMNS FROM $tbl_name$tbl_suffix") or die("mysql error");
		$numColumns = mysql_num_rows($GetColumnNames); 
		$x = 0; 
		while ($x < $numColumns) 
			{ 
    		$colname = mysql_fetch_row($GetColumnNames); 
    		$col[$x] = $colname[0]; 
    		$x++; 
			} 
		//Code from some smart guy on the internet
	$player_query = "SELECT * FROM $tbl_name$tbl_suffix where StatsID='$TheID'";
	$player_result = mysql_query($player_query);
	$row=mysql_fetch_assoc($player_result);
	if (!mysql_num_rows($player_result) == 0)  // Do we have any records for this player on this section _
		{
		$colloop=1;
		while ($colloop < $numColumns) 
			{ 
			$resulter[$col[$colloop]]=$row[$col[$colloop]];  // we put the name and the number into an array
			if (substr($col[$colloop],-6)=="_kills")   // this checks - is this a kills line
						{
						$sectionkillcount=$sectionkillcount + $row[$col[$colloop]];
						// as thsi is a kills line tally up the number of kills in the section
						}
					$colloop++;
			}
			// Once we have a tally of the kills - see if we will show this section.
			if($sectionkillcount > 0)    // tally of kills in the section - if zero then dont show section.
					{
					// We have kills so show the heading
					echo "<div style='margin-left: auto;margin-right: auto;width: 100%;background-color: #262626;border-radius: 15px;'>";
					echo "<table width='100%' border='0'>";
					echo "<tr><td width='100%'>";
					echo "<br/><center><b> $headingprint </b></center><br/>";
					// once we have dont the heading - then we can loop though the variable - which has the stats.
					foreach ($resulter as $weaponName => $value) 
						{
 						if (strrpos($weaponName,"_kills") > 0)  // check for a kills stat line
    						{
  							if ($value > 0 ) // its a kill stats line but any kills _
    							{
    							// there are kills so lets go - set ThereAreKills to true
    							$ThereAreKills=true;
								echo "<div style='margin-left: auto;margin-right: auto;width: 90%;background-color: #373737;border-radius: 10px;'>";
								echo "<table align='center' width='95%' border='0'>";
								echo "<tr>";
								// This is the row of the weapon with kills on it
								echo "<td width='25%' style='text-align: left'><font color='#CACACA'>";
								echo substr($weaponName,0,(strrpos($weaponName,"_kills")));
								echo ":</font></td>";
								echo "<td width='25%' style='text-align: left'><font color='#CACACA'>Kills:</font> $value</td>";
    							} // end of kills are greater than zero
    							else 
    							{
    								$ThereAreKills=false;
    							}
    						} // end of if a kills line
    						if ($ThereAreKills)  // we have to process the Headshots and Deaths - otherwise we dont
    							{
    								if (strrpos($weaponName,"_hs") > 0) //hopefully this is the headshot stat
    								{	
    								echo "<td width='25%' style='text-align: left'><font color='#CACACA'>Headshots:</font> $value</td>";
    								}
    						
									if (strrpos($weaponName,"_deaths") > 0) //hopefully this is the headshot stat
									{	
    								echo "<td width='25%' style='text-align: left'><font color='#CACACA'>Deaths:</font> $value</td>";
    								echo "</tr></table>";
				    				echo "</div><br/>";
    								}
    							} // End of if ThereAreKills
						} // end of variable loop
						// we can wrap up the end of the table
					echo "<br/>";
					echo "</td></tr>";
					echo "</table></div><br/>";
					} // end of the are there kills section
			} // End of check for zero entries
		}

[ImportBot]

Originally Posted by ty_ger07*:

 

Dont use select * from table unless you really need all columns.

 

The query is ok inner joins don't hurt. But leibholds query is a little bit better.

I am using all the columns from that table. Select * is perfectly appropriate for this case.

 

Hi ty_ger07

little suggestion.

 

Each gun type section you have a big query

 

 

$player_assault_query = "SELECT * FROM tbl_weapons_assaultrifle$table_suffix wa INNER JOIN tbl_server_player$table_suffix tsp ON tsp.StatsID = wa.StatsID INNER JOIN tbl_playerdata$table_suffix tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '$server_ID' AND SoldierName = '$player_name'";

 

But really you only need to find the StatsID at the top - hold that in a variable ($hisID) then just do

 

$player_query = "SELECT * FROM tbl_weapons_lmg$table_suffix where StatsID='$hisID'";

 

 

Just a thought....

I agree with you and I did plan to use ...WHERE StatsID = '$StatsID' at one point since that variable already has all the necessary prerequisites associated with it. The reason I decided not to was simply for the purpose of integrity of each of the sections of the code. My goal from the beginning was to make a simple stats page and to divide it all up into sections (or 'blocks') in such a way that most of the sections have no requirements from other sections. This was done so that anyone can easily add or remove sections without affecting the integrity of the entire page displayed. I think it is lightning quick as it is and thus decided that there is no reason for me to change this plan of attack.

[ImportBot]

Originally Posted by ty_ger07*:

 

@leibhold

Whoa!

Ummm... wow.

Ok. I see that you are trying to eliminate all of the repetition of each of the weapon blocks.

I don't have time now, but will give your code a try later. Thanks for all your efforts.

I would like to say that, as I am sure you can see, I am not by any means an expert at any of this. Everything I know is self-taught and rather simple. I have little interest in making this project bigger than it already is.

If anyone wants to take my code and run with it, produce something awesome, and publish it, they are entirely welcome to it. Also, I would take a look at what 0mni is doing because what he has so far looks like it has a lot of potential.

[ImportBot]

Originally Posted by leibhold*:

 

I was looking at your web stuff cause it looked neat and got caught in a programming loop.

Looking at weapons stats for my webadmin page and got trapped in your web page code.

 

Means also if a weapon added later - it will find it by itself.

[ImportBot]

Originally Posted by mudracing*:

 

Enter your GGC-Stream server ID and GGC-Stream API Key.

 

Code:

// GGC-STREAM INFORMATION

$serverId        = ''; // server ID
$key            = ''; // API Key

where can I find the API Key on GGC?

[ImportBot]

Originally Posted by ty_ger07*:

 

where can I find the API Key on GGC?

Go to your user control panel next to your logged in name at top right. Then click on account and you will see your API key listed on the right towards the bottom of your account page.

[ImportBot]

Originally Posted by Vetula*:

 

hey look your stats look very nice

 

We have to one ^^ you can look here :

 

http://www.bf3fl.org/index.php/server-stats.html

[ImportBot]

Originally Posted by ty_ger07*:

 

Just a super minor update:

 

Changed the web links color so that links aren't so dull and unnoticed.

Cleaned up the banned player query so that it will find banned players faster.

Search player function now ignores if someone accidentally adds spaces to the search.

[ImportBot]

Originally Posted by ty_ger07*:

 

I recommend you update to the latest code.

 

Changes:

- Older browser compatibility improvements

- Visual adjustments for text visibility

- Minor code improvements

[ImportBot]

Originally Posted by ty_ger07*:

 

Just so that you guys know, 'GGC-Stream failed to respond' means that one of three things happened:

 

It could be because:

1) You didn't enter your GGC-Stream information or you haven't set up a GGC-Stream account

2) GGC-Stream's web service is not working properly (rare)

3) GGC-Streams's web service flood protection threshold set it because too many players were checking your stats page at the same time. The ban data should start working again within 10 minutes after it is allowed to 'cool down'. This is a protection feature on GGC-Stream's side which I cannot disable.

[ImportBot]

Originally Posted by kopoBko*:

 

great thanks=). http://bf3.stronghold-guild.net/

Why don't work " all banned players"? GGC-STREAM information configured

[ImportBot]

Originally Posted by ty_ger07*:

 

great thanks=). http://bf3.stronghold-guild.net/

Why don't work " all banned players"? GGC-STREAM information configured

First of all, you are not using the most recent version of the code.

 

 

What isn't working?

 

It looks like it is working to me:

http://bf3.stronghold-guild.net/play...Banned+Players...

 

If you are banning with PRoCon, then they won't show up on the list. The Banned Players list can only show all the players who have been banned using GGC-Stream who are logged in your stats database. Currently, it looks like only one person on your GGC-Stream ban list has been found in your player stats database.

[ImportBot]

Originally Posted by kopoBko*:

 

First of all, you are not using the most recent version of the code.

 

 

What isn't working?

 

It looks like it is working to me:

http://bf3.stronghold-guild.net/play...Banned+Players...

 

If you are banning with PRoCon, then they won't show up on the list. The Banned Players list can only show all the players who have been banned using GGC-Stream who are logged in your stats database. Currently, it looks like only one person on your GGC-Stream ban list has been found in your player stats database.

where the most recent version of the code_o_O

I figured with banlist, was too lazy to go to the forum and write it =)

[ImportBot]

Originally Posted by ty_ger07*:

 

The latest code is always available in the first post. The file is located on our web server and is updated as changes are listed in the change log.

[ImportBot]

Originally Posted by ty_ger07*:

 

I added a player rank calculating function to our clan's stats page, but will not release it in this code yet. XpKiller will be releasing an update for his plugin soon which will calculate the player's rank at game round end and store the value for each player in the database where it can be retrieved my faster than my current method.

 

Here is an example of what I have for the time being:

http://thetacteam.info/player_stats1..._player=Search

 

Rank: 1 / 14069

Notice how slow it is though. This is why I am waiting for the official update from XpKiller which will be much faster.

[ImportBot]

Originally Posted by kopoBko*:

 

I added a player rank calculating function to our clan's stats page, but will not release it in this code yet. XpKiller will be releasing an update for his plugin soon which will calculate the player's rank at game round end and store the value for each player in the database where it can be retrieved my faster than my current method.

 

Here is an example of what I have for the time being:

http://thetacteam.info/player_stats1..._player=Search

 

 

 

Notice how slow it is though. This is why I am waiting for the official update from XpKiller which will be much faster.

i added "last seens"=)

how to convert a date form YYYY.MM.DD to DD.MM.YYYY?

[ImportBot]

Originally Posted by leibhold*:

 

i added "last seens"=)

how to convert a date form YYYY.MM.DD to DD.MM.YYYY?

$gooddate=date("d-m-Y",strtotime($baddate));

[ImportBot]

Originally Posted by kopoBko*:

 

$gooddate=date("d-m-Y",strtotime($baddate));

Thanks, but I can not figure out how to add this line to the time:sad:

 

add. $gooddate=date("d.M.Y H:i;s",strtotime($LastSeenOnServer));

[ImportBot]

Originally Posted by ty_ger07*:

 

Another pretty size-able change. I recommend that everyone update.

 

Changes:

- Cleaned up suspicious players query to increase speed

- Cleaned up code to reduce its size

- Cleaned up player stats page to make it more visually stimulating

- Added first seen, last seen, country, and rank to player stats page

 

Rank query on player stats page will be sped up when XpKiller releases the next version of his stats logger plugin.

 

stats_update.png

[ImportBot]

Originally Posted by ty_ger07*:

 

Another update has been posted in the first post.

 

Changes:

- Player rank function sped up

- Player rank function made more accurate

- Player rank function compatibility for people with multiple server IDs

- Player rank function for player search using wrong case

- Added $clan_name variable to top of file so that it can be added as a search engine keyword

[ImportBot]

Originally Posted by ty_ger07*:

 

Another nice update:

 

Changes:

- If server does not have GGC-Stream enabled, user can leave GGC-Stream information blank and it will not show up in stats page.

[ImportBot]

Originally Posted by ty_ger07*:

 

More visual enhancements and minor adjustments added.

 

Demo page:

http://thetacteam.info/player_stats.php

[ImportBot]

Originally Posted by Amnacog*:

 

Nice Code thanks but i Have also some problems with my database : http://vzoneserver.dyndns.org/BF_Stats/

Nothings appears but i have correctly configure my database in innoDB and the plugin works.. so what appens..?

Thanks for answers.

[ImportBot]

Originally Posted by ty_ger07*:

 

Nice Code thanks but i Have also some problems with my database : http://vzoneserver.dyndns.org/BF_Stats/

Nothings appears but i have correctly configure my database in innoDB and the plugin works.. so what appens..?

Thanks for answers.

You should seek help from XpKiller in his thread regarding the stats logger plugin. I don't offer support for his plugin. This code only makes use of the database which his plugin creates when properly configured.

[ImportBot]

Originally Posted by ty_ger07*:

 

Update:

 

Changes:

- Country reported in player stats page is full country name instead of just two letter abreviation

- Country stats page added

 

Here is the php code for translating country code to full country name (where $CountryCode is a supplied value):

Code:

$country_array = array('Unknown'=>'--','Afghanistan'=>'AF','Albania'=>'AL','Algeria'=>'DZ','American Samoa'=>'AS','Andorra'=>'AD','Angola'=>'AO','Anguilla'=>'AI','Antarctica'=>'AQ','Antigua'=>'AG','Argentina'=>'AR','Armenia'=>'AM','Aruba'=>'AW','Australia'=>'AU','Austria'=>'AT','Azerbaijan'=>'AZ','Bahamas'=>'BS','Bahrain'=>'BH','Bangladesh'=>'BD','Barbados'=>'BB','Belarus'=>'BY','Belgium'=>'BE','Belize'=>'BZ','Benin'=>'BJ','Bermuda'=>'BM','Bhutan'=>'BT','Bolivia'=>'BO','Bosnia'=>'BA','Botswana'=>'BW','Bouvet Island'=>'BV','Brazil'=>'BR','Indian Ocean'=>'IO','Brunei Darussalum'=>'BN','Bulgaria'=>'BG','Burkina Faso'=>'BF','Burundi'=>'BI','Cambodia'=>'KH','Cameroon'=>'CM','Canada'=>'CA','Cape Verde'=>'CV','Cayman Islands'=>'KY','Central Africa'=>'CF','Chad'=>'TD','Chile'=>'CL','China'=>'CN','Christmas Island'=>'CX','Cocos Islands'=>'CC','Columbia'=>'CO','Comoros'=>'KM','Congo'=>'CG','Republic of Congo'=>'CD','Cook Islands'=>'CK','Costa Rica'=>'CR','Ivory Coast'=>'CI','Croatia'=>'HR','Cuba'=>'CU','Cyprus'=>'CY','Czech Repuplic'=>'CZ','Denmark'=>'DK','Djibouti'=>'DJ','Dominica'=>'DM','Dominican Republic'=>'DO','East Timor'=>'TP','Ecuador'=>'EC','Egypt'=>'EG','El Salvador'=>'SV','Equatorial Guinea'=>'GQ','Eritrea'=>'ER','Estonia'=>'EE','Ethiopia'=>'ET','Falkland Islands'=>'FK','Faroe Islands'=>'FO','Fiji'=>'FJ','Finland'=>'FI','France'=>'FR','Metropolitan France'=>'FX','French Guiana'=>'GF','French Polynesia'=>'PF','French Territories'=>'TF','Gabon'=>'GA','Gambia'=>'GM','Georgia'=>'GE','Germany'=>'DE','Ghana'=>'GH','Gibraltar'=>'GI','Greece'=>'GR','Greenland'=>'GL','Grenada'=>'GD','Guadeloupe'=>'GP','Guam'=>'GU','Guatemala'=>'GT','Guinea'=>'GN','Guinea-Bissau'=>'GW','Guyana'=>'GY','Haiti'=>'HT','McDonald Islands'=>'HM','Vatican City'=>'VA','Honduras'=>'HN','Hong Kong'=>'HK','Hungary'=>'HU','Iceland'=>'IS','India'=>'IN','Indonesia'=>'ID','Iran'=>'IR','Iraq'=>'IQ','Ireland'=>'IE','Israel'=>'IL','Italy'=>'IT','Jamaica'=>'JM','Japan'=>'JP','Jordan'=>'JO','Kazakstan'=>'KZ','Kenya'=>'KE','Kiribati'=>'KI','North Korea'=>'KP','South Korea'=>'KR','Kuwait'=>'KW','Kyrgyzstan'=>'KG','Lao'=>'LA','Latvia'=>'LV','Lebanon'=>'LB','Lesotho'=>'LS','Liberia'=>'LR','Libya'=>'LY','Liechtenstein'=>'LI','Lithuania'=>'LT','Luxembourg'=>'LU','Macau'=>'MO','Macedonia'=>'MK','Madagascar'=>'MG','Malawi'=>'MW','Malaysia'=>'MY','Maldives'=>'MV','Mali'=>'ML','Malta'=>'MT','Marshall Islands'=>'MH','Martinique'=>'MQ','Mauritania'=>'MR','Mauritius'=>'MU','Mayotte'=>'YT','Mexico'=>'MX','Micronesia'=>'FM','Moldova'=>'MD','Monaco'=>'MC','Mongolia'=>'MN','Montserrat'=>'MS','Morocco'=>'MA','Mozambique'=>'MZ','Myanmar'=>'MM','Namibia'=>'NA','Nauru'=>'NR','Nepal'=>'NP','Netherlands'=>'NL','Netherlands Antilles'=>'AN','New Caledonia'=>'NC','New Zealand'=>'NZ','Nicaragua'=>'NI','Niger'=>'NE','Nigeria'=>'NG','Niue'=>'NU','Norfolk Island'=>'NF','Mariana Islands'=>'MP','Norway'=>'NO','Oman'=>'OM','Pakistan'=>'PK','Palau'=>'PW','Palestine'=>'PS','Panama'=>'PA','Papua New Guinea'=>'PG','Paraguay'=>'PY','Peru'=>'PE','Philippines'=>'PH','Pitcairn'=>'PN','Poland'=>'PL','Portugal'=>'PT','Puerto Rico'=>'PR','Qatar'=>'QA','Reunion'=>'RE','Romania'=>'RO','Russian Federation'=>'RU','Rwanda'=>'RW','Saint Helena'=>'SH','Saint Kitts'=>'KN','Saint Lucia'=>'LC','Saint Pierre'=>'PM','Saint Vincent'=>'VC','Samoa'=>'WS','San Marino'=>'SM','Sao Tome'=>'ST','Saudi Arabia'=>'SA','Senegal'=>'SN','Seychelles'=>'SC','Sierra Leone'=>'SL','Singapore'=>'SG','Slovakia'=>'SK','Slovenia'=>'SI','Solomon Islands'=>'SB','Somalia'=>'SO','South Africa'=>'ZA','Sandwich Islands'=>'GS','Spain'=>'ES','Sri Lanka'=>'LK','Sudan'=>'SD','Suriname'=>'SR','Svalbard'=>'SJ','Swaziland'=>'SZ','Sweden'=>'SE','Switzerland'=>'CH','Syria'=>'SY','Taiwan'=>'TW','Tajikistan'=>'TJ','Tanzania'=>'TZ','Thailand'=>'TH','Togo'=>'TG','Tokelau'=>'TK','Tonga'=>'TO','Trinidad'=>'TT','Tunisia'=>'TN','Turkey'=>'TR','Turkmenistan'=>'TM','Turks Islands'=>'TC','Tuvalu'=>'TV','Uganda'=>'UG','Ukraine'=>'UA','United Arab Emirates'=>'AE','United Kingdom'=>'GB','United States'=>'US','US Minor Outlying Islands'=>'UM','Uruguay'=>'UY','Uzbekistan'=>'UZ','Vanuatu'=>'VU','Venezuela'=>'VE','Vietnam'=>'VN','Virgin Islands (British)'=>'VG','Virgin Islands (US)'=>'VI','Wallis and Futuna'=>'WF','Western Sahara'=>'EH','Yemen'=>'YE','Yugoslavia'=>'YU','Zambia'=>'ZM','Zimbabwe'=>'ZW');

$country = array_search($CountryCode,$country_array);

[ImportBot]

Originally Posted by kopoBko*:

 

All good=)

may be add statistics on knives in a separate page_as it was in BFBC2.See who is who and how many killed

[ImportBot]

Originally Posted by dakeeper*:

 

Very Great!

 

I`m missing some things...

 

e.g. "Show all players"

 

And perhaps...you can manage ist to make something like "Ranks for Weapons". Most kills with AK74M, or Top 3 etc...

[ImportBot]

Originally Posted by ty_ger07*:

 

I`m missing some things...

 

e.g. "Show all players"

What do you mean by 'show all players'?

 

If you have 20,000 people logged, who is going to look at a list of 20,000 players? Just type in the name of the player you are interested in using the player search box.

[ImportBot]

Originally Posted by ty_ger07*:

 

Update in first post.

 

Changes:

- Added map stats

[ImportBot]

Originally Posted by ty_ger07*:

 

Update in first post.

 

Changes:

- Stats blocks in player stats page can be expanded and collapsed to save space

- Dog tag stats added to player stats page