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

[ImportBot]

Originally Posted by ty_ger07*:

 

player_stats.php Overview

 

This is a very simple and fast loading game server player stats webpage as requested by Friegide in these forums. The page is designed to provide minimal performance impact on your web server while still providing much very useful statistical data. This page requires the use of a stats database which is created by XpKiller's BF3 Chat, GUID, Stats and Mapstats Logger Plugin* . If you need help with his plugin, you must seek assistance in XpKiller's thread.

 

 

Each copy of this stats page code is designed to be used with one game server. Multiple copies of the file using different names or placed in different directories can be used to create multiple stats pages.

 

Demo

 

http://open-web-community.com/stats-...stats_main.php

 

Index page is optional if you have multiple servers and is included in the code. You can view index page help here* .

 

https://myrcon.net/recovered/img/39692_valid-xhtml10

 

banned_page.jpgmap_stats.jpgcountry_page.jpgsuspicious_page.jpgmain_page.jpg

 

Installation Steps:

 

Download the following file:

http://open-web-community.com/stats-...ayer_stats.zip

 

Extract the files all into the same directory. You may rename player_stats.php to any name of your choice. You may also use multiple copies of player_stats.php in the same directory with different names and use them to display stats information from different servers.

 

 

You may change the appearance of the page by modifying the player_stats.css file.

 

 

Fill in the required parameters before using this code. You must place the necessary data between the single quotation marks ('').

 

 

I recommend that you use Notepad++ when editing the file. Whichever text editor you use, make sure word wrap is disabled so the lines don't get split up into multiple lines.

 

Note: You may not include single quotation marks (') in the following fields. For instance, you may not call your game server "Ty_ger07's Game Server" as it will create a PHP compilation error.

For example, this would not work:

// SERVER Name

$server_name = 'Ty_ger07's Game Server'; // server name to display

You must use a PHP delimiter if you wish to use single quotes within the following fields.

For example, this would work:

// SERVER Name

$server_name = 'Ty_ger07's Game Server'; // server name to display

These are the sections which you must fill in:

 

1) Input your stats database host, stats database user name, stats database password, and stats database name.

 

Code:

// DATABASE INFORMATION
$db_host        = ''; // database host
$db_port        = '3306'; // database port. default is 3306
$db_name        = ''; // database name
$db_uname        = ''; // database user name
$db_pass        = ''; // database password

For example:

//DATABASE INFORMATION

$db_host = '100.200.300.400'; // database host

$db_port = '3306'; // database port. default is 3306

$db_name = 'database'; // database name

$db_uname = 'user'; // database user name

$db_pass = 'pass'; // database password

Note: Some web server providers (such as GoDaddy) use the same value for database name and database user name.

 

 

2) Add a table suffix if you use one.

 

Code:

// TABLE SUFFIX
$table_suffix        =''; // if you use a table suffix, enter it there

For example:

// TABLE SUFFIX

$table_suffix ='mysuffix'; // if you use a table suffix, enter it there

If you don't use a table suffix, don't make any changes to that section.

 

For example:

// TABLE SUFFIX

$table_suffix =''; // if you use a table suffix, enter it there

If you aren't sure whether you are using a table suffix, refer to XpKiller's stats plugin settings in your PRoCon client.

 

 

3) Change the Server ID if you want. The default server ID is 1. If you use more than one server in the same database and don't use table suffixes, you can specify which server to display based on server ID.

 

Code:

// SERVER ID
$server_ID        ='1'; // default server ID is 1.

4) Add GGC-Stream server information if you use GGC-Stream on your servers and want bans to show in stats page.

 

Code:

// GGC-STREAM INFORMATION
$serverId        = ''; // server ID
$key            = ''; // API Key

For example:

Code:

// GGC-STREAM INFORMATION
$serverId        = '12345'; // server ID
$key            = '12345_1234567890123456789012345678901234567890'; // API Key

If you don't use GGC-Stream, don't make any changes to that section.

 

 

5) Enter the name of the server as you want it to appear on your player stats page.

 

Code:

// SERVER Name
$server_name        = ''; // server name to display

For Example:

// SERVER Name

$server_name = 'My Gaming Server'; // server name to display

If you don't enter a server name, it will use the name of the server stored in the database.

 

 

6) Enter the name of the clan as you want it to appear on search engine results.

Code:

// CLAN NAME
$clan_name        = ''; // your gaming clan or organization name

For Example:

// CLAN NAME

$clan_name = 'my clan'; // your gaming clan or organization name

7) Change the banner URL if desired.

Code:

// PAGE BANNER
$banner_image    = 'http://thetacteam.info/styles/twilightBB/theme/images/forumbanner.png'; // your desired page banner

Change the banner URL to an image URL of your choice.

 

 

8) Change the banner link if desired.

Code:

// BANNER LINK
$banner_url        = 'http://www.TheTacTeam.info'; // where clicking the banner will take you

Change the destination of clicking the banner if desired.

 

 

9) Provide link to stats index page if you are using the stats index page to handle multiple server stats pages.

Code:

// STATS INDEX LINK
$index_link        = ''; // if you have multiple stats pages and want a link to the index page to be available, enter the link value here

For example:

Code:

// STATS INDEX LINK
$index_link        = 'player_stats_main.php'; // if you have multiple stats pages and want a link to the index page to be available, enter the link value here

Enjoy!

 

Changelog:

 

7-22-2013:

- Moved hosted files and demonstrations to my own web space.

 

3-06-2013:

- Added new End Game maps

- Added new End Game modes

 

1-26-2013:

- Added DB port option in the rare case that your database port is not at the default 3306.

 

1-18-2013:

- Added server chat page (lite version).

- Fixed issue with stats index link showing when it shouldn't if no index link was provided.

 

1-16-2013:

- Minor code cleanup.

- Included player_stats_main.php index page for users with multiple server stats pages.

- Added optional link in player_stats.php to stats index page.

 

1-15-2013:

- Added flush operation to end of file in case user's PHP environment requires it.

- Slight visual enhancements.

- Better handling of missing scoreboard data.

- Code used in multiple places combined into single functions.

- Smaller code size.

 

1-14-2013:

- Big update.

- Visual enhancements.

- CSS moved to separate file for easy modification.

- Changing banner URL and banner link is easier.

- Code cleanup and improvements.

 

1-13-2013:

- Scoreboard now reports squad name instead of just squad number.

- Scoreboard now reports player's country name.

- Scoreboard now reports players loading in.

- Now uses time() instead of gmmktime() for error control.

- Scoreboard now reports current game mode.

- Scoreboard now reports current map name.

- Scoreboard now reports team name instead of just team number.

- Scoreboard pages now refresh every minute.

- Sessions table remains optimized.

- Server game mode and map shows on scoreboard even if no one is in the server.

- Uses server's name as server name if no server name is provided.

 

1-12-2013:

- Now REQUIRES PRoCon version 1.4.0.5 or higher and XpKiller's Stats plugin version 1.1.0.0 or higher.

- Added server stats.

- Added server scoreboard.

 

1-11-2013:

- GGC-Stream ban stuff added back in after GGC-Stream moved to GGC-Stream.net

-

- GGC-Stream requests now using curl() instead of file_get_contents() for security reasons.

- Added external link to metabans ban information.

- Added external link to cheat-o-meter information.

- Added 30 minute session tracking to count number of users viewing stats page.

- Minor layout changes.

- Minor search engine optimization.

 

12-31-2012:

- GGC-Stream ban information removed due to GGC-Stream shutting down.

 

12-15-2012:

- Added crossbow stats.

- Better handling of errors so less error data is displayed if an error occurs.

- Change from one background image to two and slight visual changes so that page will display properly for high resolution monitor users.

- Adjustment of rank logic to support multiple server IDs.

 

12-14-2012:

- Necessary changes to make document validated as XHTML 1.0 Transitional.

- https://myrcon.net/recovered/img/39692_valid-xhtml10

- This change will cause some very archaic search engines to not properly interpret URLs in the code which contain query strings. This should now be considered the fault of the search engine for not updating to current code conventions.

 

12-05-2012:

- Added Aftermath map names to map stats.

 

09-12-2012:

- Added Armored Kill map names to map stats.

 

07-19-2012:

- Fixed GGC-Stream requests for new GGC-Stream API format.

 

06-15-2012:

- Added new Close Quarters map names to map stats page.

 

06-02-2012:

- Added pagination so that you can scroll through multiple pages of "top players".

 

06-01-2012:

- Search function will search for partial player name matches if no exact match is found.

- GGC-Stream Banlist is cached to stats database for faster page loading. It will automatically refresh the cached copy after its 24th use or can be manually refreshed by selecting "refresh ban list".

- Minor code improvements.

 

04-02-2012:

- Fixed issue in code where KDR is very high if zero deaths.

- Incorporated leibhold's suggestion for handling references to self.

 

03-01-2012:

- Fixed issue in code which might cause PHP errors in rare circumstances.

 

02-19-2012:

- Minor code improvements for error-control.

- Banned players page re-worked and now much faster.

 

02-18-2012:

- Dog tag stats are visible even if player has not collected any dog tags

- Borders added around HTML 5 blocks for visual enhancement

 

02-15-2012:

- Player names in dog tags list are clickable

- More external links added to player stats page

- Link to XpKiller's plugin added at bottom of page

- Page compute time added to bottom of page

- Player world distribution map added to country stats page

- Top 10 players for each country added to country stats page

 

02-10-2012:

- 'GGC-Stream failed to respond' message changed to 'GGC-Stream returned no results'

- Text color brightened up

- Code formatting complete

 

02-10-2012:

- Weapon stats are smarter about choosing weapon columns (thanks for the reference leibhold)

- Minor code improvements

- Code formatting is mostly finished

 

02-08-2012:

- Player rank query is slightly faster

- Player weaponstats query is slightly faster

- Player dogtag query is significantly faster

- Suspicious players query is significantly faster

- Banned players query is significantly faster

 

02-07-2012:

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

- Dog tag stats added to player stats page

 

02-06-2012:

- Added map stats

 

02-05-2012:

- 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

- If server does not have GGC-Stream, can leave GGC-Stream information blank and page will hide GGC-Stream functions

- Visual enhancements and interface cleaned up

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

- Country stats page added

 

02-04-2012:

- 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

- Added better description for GGC-Stream ban page

 

02-03-2012:

- Compatibility improvements for older browsers

- Visual adjustments for text visibility

- Minor code improvements

 

02-02-2012:

- Link color changed

- Cleaned up Banned players query to make it faster

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

 

02-01-2012:

- PHP notices are suppressed. Only actual errors will be displayed.

- All clickable player names are now links instead of submit buttons (for search engine compatibility).

- Server ID can be specified at the top of the file. Default server ID is 1.

 

01-30-2012:

- Search engine optimization: titles, meta keywords, meta descriptions, and URLs change for each page.

 

01-30-2012:

- Added player weapon stats

 

01-29-2012:

- Added HTML5 to round 'blocks'

 

01-28-2012:

- Initial release

[ImportBot]

Originally Posted by ty_ger07*:

 

If you find this code helpful, please consider donating to my clan:

http://thetacteam.info/donations.php

 

Choose the 'Custom Amount (One-Time)' option.

[ImportBot]

Originally Posted by ty_ger07*:

 

Feedback please.

 

I also created a similar topic in my forum: http://thetacteam.info/viewtopic.php_f=3&t=1360

[ImportBot]

Originally Posted by ty_ger07*:

 

I added HTML5 to make the boxes nice and curved.

 

I only added HTML5 to the code with GGC-Stream included and removed the code for the non-GGC-Stream version.

[ImportBot]

Originally Posted by sp37zn4z*:

 

I'll try this. When do you add some features on this? like specific weapon stats each player?

[ImportBot]

Originally Posted by ty_ger07*:

 

When do you add some features on this? like specific weapon stats each player?

I'm not sure if I will add any more features to this code. This was meant to be a simple basic stats page. If I were to add more features, I would want to redesign it all over again. As it is now, all the code is in one file but it would be desirable to split it up into multiple files for a more complex series of web pages.

 

Actually... yeah... maybe I will add that functionality. Or maybe I will just add a brief summary of that player's most used weapons and their stats with those weapons.

[ImportBot]

Originally Posted by sp37zn4z*:

 

i got an error after uploading the player_stats.php on my cpanel public_html location.

 

Internal Server Error

 

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

btw i edited all the field with correct info as per your instruction. Am i missing something? thanks

[ImportBot]

Originally Posted by ty_ger07*:

 

i got an error after uploading the player_stats.php on my cpanel public_html location.

 

btw i edited all the field with correct info as per your instruction. Am i missing something? thanks

I can't really tell you the problem since you are the one with the file. All I can say is that the code doesn't have any errors as you can see by the fact that the exact same code works properly here: http://thetacteam.info/player_stats.php

 

You only edited this part, right?

Code:

<_php

//DATABASE INFORMATION

$db['host']		=''; // database host
$db['uname']		=''; // database user name
$db['pass']		=''; // database password
$db['name']		=''; // database name

// TABLE SUFFIX

$table_suffix		=''; // if you use a table suffix, enter it there

// GGC-STREAM INFORMATION

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

// SERVER Name

$server_name		= ''; // your server name

_>

And you only placed text between the single quotation marks (' '), right? You must leave the semi colon ( ; ) there after the single quotation marks.

 

Make sure you copied everything correctly and make sure that you didn't forget to copy a bit of the beginning or ending. Oh, and if you are using something like notepad, MAKE SURE YOU HAVE WORD WRAP TURNED OFF!

[ImportBot]

Originally Posted by ty_ger07*:

 

I am working on adding the weapon stats.

 

Here is what I have so far:

weapon_stats.jpg

[ImportBot]

Originally Posted by Terran*:

 

A big THX for that code

 

http://excalibur.homeunix.net/opt/bf...ayer_stats.php

[ImportBot]

Originally Posted by ty_ger07*:

 

A big THX for that code

 

http://excalibur.homeunix.net/opt/bf...ayer_stats.php

You are welcome! I am glad I can help.

 

I will update the code above adding weapon stats once I have finished it.

[ImportBot]

Originally Posted by ty_ger07*:

 

I have updated the code in the first post to include player's weapon stats.

 

The code has grown too long to post in a message, so I have provided a download link instead.

 

As before, you can demo this code here:

http://thetacteam.info/player_stats.php

[ImportBot]

Originally Posted by ty_ger07*:

 

For those with multiple servers, you can take your inspiration for multiple server stats pages from this page here:

http://thetacteam.info/player_stats_main.php

[ImportBot]

Originally Posted by ty_ger07*:

 

I updated the code linked to in the first post for Search Engine Optimization.

 

Now, the Page Titles, Keywords, Page Descriptions, and URLs change for each page. This will make your page more likely to be indexed by a search engine as well as make it possible for you to be able to link to a specific page.

[ImportBot]

Originally Posted by mudracing*:

 

I have some errors

 

Code:

Notice: Undefined index: search_player in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 37 Notice: Undefined index: suspicious_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 44 Notice: Undefined index: banned_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 50 Notice: Undefined index: top25_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 56 

Notice: Undefined index: search_player in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 181 Notice: Undefined index: suspicious_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 1717 Notice: Undefined index: banned_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 1870 Notice: Undefined index: top25_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 1997 Notice: Undefined index: search_player in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 1997 Notice: Undefined index: suspicious_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 1997 Notice: Undefined index: banned_players in /var/www/vhosts/spqrclan.com/httpdocs/player_stats.php on line 1997

EDIT: location https://www.spqrclan.com/player_stats.php

[ImportBot]

Originally Posted by ty_ger07*:

 

How many servers do you have logged in that one database?

[ImportBot]

Originally Posted by mudracing*:

 

3 servers, but the page I have set for one server

[ImportBot]

Originally Posted by ty_ger07*:

 

Are you using table suffixes for your servers?

[ImportBot]

Originally Posted by mudracing*:

 

no, this needs?

[ImportBot]

Originally Posted by ty_ger07*:

 

3 servers, but the page I have set for one server

I have updated the code linked to in the first post. Please download it again.

 

Changes:

- PHP notices are suppressed. Only actual errors will be displayed.

- All clickable player names are now links instead of submit buttons (for search engine compatibility).

- Server ID can be specified at the top of the file. Default server ID is 1.

[ImportBot]

Originally Posted by ty_ger07*:

 

no, this needs?

No, it doesn't need a table suffix if you aren't using one. I was just wondering.

[ImportBot]

Originally Posted by beantje*:

 

can you add your own logo at the top ?

[ImportBot]

Originally Posted by mudracing*:

 

I have updated the code linked to in the first post. Please download it again.

 

Changes:

- PHP notices are suppressed. Only actual errors will be displayed.

- All clickable player names are now links instead of submit buttons (for search engine compatibility).

- Server ID can be specified at the top of the file. Default server ID is 1.

Thank you, you have solved my problem! : D

 

 

I still have another question, you can join 3 servers stats page with links?

[ImportBot]

Originally Posted by ty_ger07*:

 

Thank you, you have solved my problem! : D

 

 

I still have another question, you can join 3 servers stats page with links?

Yes. Here is an example:

http://thetacteam.info/player_stats_main.php

 

I have renamed my stats pages to player_stats1.php and player_stats2.php -- one for each server. But doing so, requires changing the _GET data file location in the code. I can explain more later when I have more time.

[ImportBot]

Originally Posted by ty_ger07*:

 

can you add your own logo at the top ?

Yes. I have our clan's logo and website as an advertisement since I am the one who wrote the code, but you are welcome to change it if you want.

 

The banner is in regular HTML (not inside a PHP section) so anyone who knows HTML should have no problem changing it.

 

Just change the image and URL on line 114 to the desired image and URL.

Code:

<center><a href="http://thetacteam.info/portal.php"><img alt="Copyright 2012 The Tac Team" border="0" src="http://thetacteam.info/styles/twilightBB/theme/images/forumbanner.png" /></a></center>

[ImportBot]

Originally Posted by mudracing*:

 

Yes. Here is an example:

http://thetacteam.info/player_stats_main.php

 

I have renamed my stats pages to player_stats1.php and player_stats2.php -- one for each server. But doing so, requires changing the _GET data file location in the code. I can explain more later when I have more time.

Perfect!

 

You can send me that page?

 

 

... I will implement these pages in vBulletin (with this*), do you think this works?

 

 

Thank you very much

[ImportBot]

Originally Posted by leibhold*:

 

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....

[ImportBot]

Originally Posted by XpKiller*:

 

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.

[ImportBot]

Originally Posted by leibhold*:

 

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.

Oi !

 

He uses all the table columns so select * is fair.

 

But leibholds query is a little bit better Sniff

 

Just once he has the stats ID he doesnt need those big a%$ed queries......

 

$player_data_query = "SELECT tpd.SoldierName, tpd.PBGUID, tps.Score, tps.Kills, tps.Deaths, tps.Suicide, tps.TKs, tps.Playtime, tps.Headshots, tps.Rounds, tps.Killstreak, tps.Deathstreak , tsp.StatsID FROM tbl_playerstats$table_suffix tps INNER JOIN tbl_server_player$table_suffix tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata$table_suffix tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '$server_ID' AND SoldierName = '$player_name'";

 

added in bold.

 

Then in the mysql_fetch_array

 

$ThisID = $player_data_result_row['StatsID'];

 

then its just

"SELECT * FROM "table_with_guns" where StatsID='$ThisID'";

[ImportBot]

Originally Posted by leibhold*:

 

Dont know if you want this but.

 

Its a function - shove in the table name, the statsId and the name you want for the section

If takes the column headings as the names for weapons, checks for kills, puts out the stats like you have it

 

replaces all your hard coded weapons stats

 

eg Statsout("tbl_weapons_assaultrifle","627","Assault Rifle Stats");

 

 

Let me know