[BF3] Stats webpage for XpKiller's Stats Logger Plugin 1.0.0.2 (Updated 5-10-2017)

[ImportBot]

Originally Posted by ty_ger07*:

 

The full featured stats webpage!

 

 

BF3 Stats Web Page Overview

 

Screenshots:

 

SS1.jpg

 

SS2.jpg

 

SS3.jpg

 

Demo:

http://www.itapevagamers.com/bf3/index.php

 

Features:

- Easy setup.

- Individual server or combined server stats.

- Country stats.

- Map stats.

- Player stats.

- Weapon stats.

- Dog tag stats.

- Game server stats.

- Live scoreboard.

- Top players list / leaderboard.

- Player name search.

- Top players of the Week.

- Suspicious players search.

- Server chat log.

- Stats signature images.

- Gametracker-style server banners.

- Battlelog theme.

 

Prerequisites

 

This webpage code requires the use of a stats database which is created by XpKiller's BF3 Chat, GUID, Stats and Mapstats Logger Plugin* version 1.0.0.2. If you need help with XpKiller's stats logging plugin, you must seek assistance in XpKiller's thread.

 

For best compatibility with this code, use the following settings in XpKiller's PRoCon logging plugin:

"Enable Statslogging_" : Yes

"Enable Weaponstats_" : Yes

"Enable Livescoreboard in DB_" : Yes

"tableSuffix" : None (empty)

"MapStats ON_" : Yes

"Session ON_" : Yes

"Save Sessiondata to DB_" : Yes

"Log playerdata only (no playerstats)_" : No

 

This webpage code also requires that you have access to a web server running a modern version of PHP and that you have permission to modify files on the web server.

 

Additional Info

 

GitHub:

http://tyger07.github.io/BF3-Server-Stats

 

 

Installation Steps:

 

Download the following file:

https://github.com/tyger07/BF3-Serve...zipball/master

 

Extract the files.

 

You may change the appearance of the page by modifying the stats.css file in the common folder.

 

 

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

 

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

For example, this would not work:

// CLAN NAME

$clan_name = 'Ty_ger07's Clan'; // your gaming clan or organization name

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

For example, this would work:

// CLAN NAME

$clan_name = 'Ty_ger07's Clan'; // your gaming clan or organization name

You must fill in the following information in the config.php file found in the config folder

 

 

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

 

Code:

// DATABASE INFORMATION
DEFINE('HOST', '');			// database host address
DEFINE('PORT', '3306');		// database port - default is 3306
DEFINE('NAME', '');			// database name
DEFINE('USER', '');			// database user name - sometimes the same as the database name
DEFINE('PASS', '');			// database password

For example:

// DATABASE INFORMATION

DEFINE('HOST', '100.200.300.400'); // database host address

DEFINE('PORT', '3306'); // database port - default is 3306

DEFINE('NAME', 'database'); // database name

DEFINE('USER', 'user'); // database user name - sometimes the same as the database name

DEFINE('PASS', 'pass'); // database password

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

 

 

2) Input your clan name as you would like it to appear in the stats pages.

 

Code:

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

For example:

// CLAN NAME

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

3) Input your desired banner image URL if you want one other than the default to be displayed.

 

Code:

// PAGE BANNER
$banner_image	= './images/bf3-logo.png'; // your desired page banner

4) Enter the URL which you would like users to redirect to if they click your banner image.

 

Code:

// BANNER LINK
$banner_url		= 'http://tyger07.github.io/BF3-Server-Stats/'; // where clicking the banner will take you

Enjoy!

 

(if you want to donate, ask me how)

 

Changelog:

Refer to: https://github.com/tyger07/BF3-Serve...commits/master

[ImportBot]

Originally Posted by ty_ger07*:

 

Error found.

 

Image /common/images/weapons/RoadKill.png should be name Roadkill.png. Code updated.

[ImportBot]

Originally Posted by ty_ger07*:

 

Updated posted.

 

Changes:

- Added basic AdKats integration to highlight a player if they are banned or warned.

- Optimizations and improvements.

[ImportBot]

Originally Posted by BuRockK*:

 

do we need to update config.php file too? if not it would be easier to update with simple copy-paste

[ImportBot]

Originally Posted by ty_ger07*:

 

You do not need to update config.php.

 

Copy and paste the whole thing except for config.php. No problem. It is that easy. If you use the GitHub Windows program to update your code, it automatically updates all the files except for config.php. Or at least is supposed to work that way.

 

By the way, if you use AdKats and the new style elements start appearing funny, reload the page a few times or manually flush your browser cache. The AdKats ban information player highlighting might look funny if your browser is using the cached old sylesheet instead of the new stylesheet. The new stylesheet file is the same as the old one except for adding a couple new style elements.

[ImportBot]

Originally Posted by BuRockK*:

 

Okay, thanks man. I dont use AdKats but ill keep that in mind.

[ImportBot]

Originally Posted by ty_ger07*:

 

Let me know if you have any issues (if I accidentally broke something) for non-AdKats users. Thank you!

[ImportBot]

Originally Posted by BuRockK*:

 

Sure ill post here if i see something broken. By the way whats the size on background images (background picture and the basic color overlay on that picture). I dont have PS on pc to check, edit etc. so im just gonna find one on google.

[ImportBot]

Originally Posted by ty_ger07*:

 

It should automatically scale to full width and the height scales in the same ratio as the width. In other words, if your image is half as wide as someone's screen, it will scale width wise by 2 and then the height will automatically scale up by 2 to match the width scale. Choose whichever image you want and try it out.

 

The background gradient in the middle is a separate image which will stay there to keep the background image from overwhelming the text.

[ImportBot]

Originally Posted by BuRockK*:

 

okay man thanks for info. ill try some images to best fit the overall color scheme

 

and yea i guess ill just change the color of that gradient.

[ImportBot]

Originally Posted by ty_ger07*:

 

Update posted.

 

Change:

- Fixed a bug which caused only players ranked #2 through #20 to show up in country stats and skipped player ranked #1.

[ImportBot]

Originally Posted by ty_ger07*:

 

Update posted.

 

Change:

- Performance optimization which wraps two queries into one for both the dog tag collected and dog tag surrendered stats when using AdKats. Performance issue labelled on GitHub as issue #2. Improves performance due to latency. If player had hundreds or thousands of dog tags collected or dog tags surrendered, hundreds or thousands of queries would fire back to back. Now it is all balled up into one query. Could improve performance in some cases by 50% or more in this regard.

[ImportBot]

Originally Posted by ty_ger07*:

 

Code updated.

 

Changes:

- Removed server IP address from server banner image

[ImportBot]

Originally Posted by keb2*:

 

Thanks

[ImportBot]

Originally Posted by ty_ger07*:

 

Code updated. Change:

- Unbanned bot access and made bot access restricted instead. This allows search engines to crawl the stats page and get more clan/community attention while also restricting bot database performance impact to some slower features.

[ImportBot]

Originally Posted by ty_ger07*:

 

Code updated! Changes:

- Added warning to scoreboard if a possible server connection issue was detected

- Added simple chat search suggestions which shouldn't have a huge impact on database performance

[ImportBot]

Originally Posted by ty_ger07*:

 

Code updated. Changes:

- Reduced the rate at which autocomplete tries to fill in searches

- Added page request throttles. If a user tries to load pages every 1 to 2 seconds, server adds a 1 second delay. If a user tries to load pages every 1 second or less, the server denies the request and gives them an error message and redirect link.

[ImportBot]

Originally Posted by ty_ger07*:

 

Updated posted. Change:

- Free up the top 142px of the page when scrolling down.

 

Note: you may need to refresh the page a few times to force your browser's cache to update properly to the new stylesheet changes.

 

Example:

http://stats.synergy-clan.com/index.php_p=home&sid=2

[ImportBot]

Originally Posted by ty_ger07*:

 

Update posted. Changes:

- When using AdKats and when not a bot: Add ban reason to player page

- When using AdKats and when not a bot: Add ban list page displaying all banned players and ban reasons

[ImportBot]

Originally Posted by ty_ger07*:

 

Update posted. Change:

- When using AdKats, the first (default) page of the leaderboard now loads slightly faster and uses less database connections

 

The numbers will be different for everyone depending on your server location and server performance, but, as a matter of comparison, in my testing, the first page of the leaderboard loaded in ~600ms instead of ~800ms. And, of course, reducing the number of queries by 19, is a good thing.

[ImportBot]

Originally Posted by ty_ger07*:

 

Update released!

Changes:

- A rare server configuration was reported which chops query strings off

of .PNG extensions. Restructured file names to place the needed

information into the file name instead of using a query string. Old way

still works, but new way is now displayed and recommended.

- A .sql file is included in the ./test-database/ folder for users to set up a dummy test database to test this web page when they otherwise have not yet set up a server or have not yet got XpKiller's Stats Logger plugin and database working.

 

As always, the link to the most recent version is in the first post of this thread and is: https://github.com/tyger07/BF3-Serve...zipball/master

[ImportBot]

Originally Posted by ty_ger07*:

 

Update released.

 

Changes:

- tyger_stats_cache tables are now more robustly indexed to provide better performance

- many re-cache trigger periods dropped from 12 hours to 3 hours in order to display more recent data

 

To apply the new tyger_stats_cache table changes:

1) update to the latest stats webpage code

2) while no one is viewing the stats webpage, drop/delete the 5 database tables which start with "tyger_stats..."

3) view the stats web page to allow it to automatically rebuild those tables using the new table building commands

 

Otherwise, if you only update the stats webpage code and don't delete/rebuild the tyger_stats_cache tables, the stats page will continue working as is (but with the new shorter re-cache trigger period).

[ImportBot]

Originally Posted by keb2*:

 

Thanks

[ImportBot]

Originally Posted by payver*:

 

Thank you very much ty_ger07,

i have no clue (in the past i only set up apache server, programmed in html with a little bit css) why i have some errors or pictures not loaded (map pictures, banners etc.).

I just uploaded all the contents from the zip to the webserver and i i have no clue from php.

I wanna send you a pm to my website. And i have this error if i search for a player and his playerpage is shown:

 

"Strict Standards: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /homepages/5/d343911648/htdocs/common/player/player.php on line 443

 

Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /homepages/5/d343911648/htdocs/common/player/player.php on line 443

 

Strict Standards: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /homepages/5/d343911648/htdocs/common/player/player.php on line 444

 

Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /homepages/5/d343911648/htdocs/common/player/player.php on line 444"

 

 

Greetings,

payver

[ImportBot]

Originally Posted by ty_ger07*:

 

It is really not appropriate for this stats page code to handle the solution to that error message. The source of that error message is a server configuration issue. Your server's php environment should have the time zone specified in the server's php.ini configuration file.

 

https://stackoverflow.com/questions/...ezone-settings

 

If you need further assistance, I encourage you to contact your web server host.

[ImportBot]

Originally Posted by payver*:

 

Hmm ok thank you ty_ger07. What about the missing map pictures. Or is it because of the time thing?

[ImportBot]

Originally Posted by ty_ger07*:

 

It's hard for me to guess why the images wouldn't display. There could be a variety of reasons. Have a link so I can look?

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't know why URLs to stats pages are treated as secrets, but thanks for the PM with the link.

 

Those images are returning 404 errors (file not found). Even the join button ( XXXXXXX.xx/common/images/joinbtn.png ) image returns a 404 error. Interestingly, the background image (in the same folder as joinbtn.png) is one image which loads properly. Why does it work properly but the rest doesn't? Something is wrong with the file structure or the URL translation or something. I don't know your web server nor structure. Assuming that you didn't fail to copy whole folders properly, I would ask your host.

[ImportBot]

Originally Posted by payver*:

 

For a little privacy for the players on the server, because the chat is also on the homepage. Would be good if i could see the SQL data on a similar way like the homepage from my desktop at home. For example: i download the playerdata table from the SQL server as excel if i have to ban/tban someone with guid.

I will look into the errors, you have done enough for the community.

 

Happy new year, health and good luck to you