[BF4] Stats webpage for XpKiller's Stats Logger Plugin

[ImportBot]

Originally Posted by aceventura81*:

 

Hey buddy, leave nitrado, can`t get your plugin works.

 

I just went to different one where I can get connect to procon layer. no errors come back. But now nothing shows on website. All is set up. Size of database is still 0 MB. I planning to sit down tonight and do complete reinstall of server with fresh install of plugins

[ImportBot]

Originally Posted by keb2*:

 

Ok, I can see now that none of your pChart library stuff is working.

 

I think that I would need FTP access to your server in order to do testing in order to solve your issue. There is no way that I can just guess the reason why it is unable to properly locate the font located /common/pchart/fonts/.

Now everything works without errors on Linux.Maybe when I re-launch everything on xampp I will return to this issue.

[ImportBot]

Originally Posted by xloneshadowx*:

 

i run servers with nitrado whats up? I have the stats webpage up and running through nitrado

[tyger07]

The full-featured stats webpage!


BF4 Stats Web Page Overview







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.

Demo

https://egc-la.evga.com/battlefield/index.php

Prerequisites

This webpage code requires the use of a stats database which is created by XpKiller's BF4 Chat, GUID, Stats and Mapstats Logger Plugin version 1.0.0.2 or newer. 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/BF4-Server-Stats


Installation Steps:

Download the following file:
https://github.com/tyger07/BF4-Server-Stats/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 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.
 

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

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

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

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

// BANNER LINK
$banner_url = 'http://tyger07.github.io/BF4-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/BF4-Server-Stats/commits/master

[TheClown]

My Clan is using this (www.lawclan.co.za)

Its AWESOME!!.

Thanx Killer

[DECoZ97]

anyone can tells me how i get the xpkiller plugin???

[Prophet731]

anyone can tells me how i get the xpkiller plugin???

 

https://myrcon.net/topic/162-chat-guid-stats-and-mapstats-logger-1003/

[DonFuZi0N]

The top 20 is basically refreshed every week, is it possible to change it to be refreshed month by month?
 

if so, I think I found the line of code, is that it?

// initialize timestamp values
$now_timestamp = time();
$old = $now_timestamp - 10800;
if($rank == 'SoldierName')

If that's it, what value should I put?

 

(the line of code I found is in the file "leader-ranks.php" in /common/leaders folder)

Thank you all for your help

[tyger07]

No, that would not be correct. What you referred to is some code for determining whether cached stats should be refreshed for that leaderboard. Cached stats are, for example, keeping a cached list of the top 20 players so that every time a person visits the first page within each 3 hour period of time, it doesn't have to find and calculate the top 20 players out of thousands of players. It lowers SQL server load greatly for when people are just browsing the first pages and not really searching through the stats with interest.



What you are looking for is line 31, line 47, line 68, and line 84 (applicable in different circumstances) of /common/leaders/sessions-tab.php

... BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE() ...

Change "INTERVAL 7 DAY" to "INTERVAL 30 DAY", if you would like.

 

Basically, it is saying, show me the information for the top 20 players for range of dates of (today through (today - X days)).

[DonFuZi0N]

Perfect! I'll have another little problem... the server doesn't display anything in "leaderboard" and nothing in "server info" either.

is that normal and I have to wait or is there a problem somewhere?

[DonFuZi0N]

if you want to look, maybe it can help: https://serveurs.lequipefra.eu/

[tyger07]

It's hard for me to be sure why your players do not seem to be being saved to your database.

 

I would start first by asking whether you are using the following settings in XpKiller's stats logger plugin settings:

 

 

• "Enable Statslogging?" : Yes
• "Enable Weaponstats?" : Yes
• "Enable Livescoreboard in DB?" : Yes
• "tableSuffix" : None
• "MapStats ON?" : Yes
• "Session ON?" : Yes
• "Save Sessiondata to DB?" : Yes
• "Log playerdata only (no playerstats)?" : No

 

... Oh, and, is the server ranked and is punkbuster enabled?  Those are required by xpkiller's stats logger plugin in order to record players and player stats.

[DonFuZi0N]

Well all configs are good, I followed your post well, however we did remove punkbuster well... punkbuster its stink, I'm banned like a lot of people as a false positive... I'm never cheating or doing anything... Is it really not possible to display these servers correctly even without punkbuster?

You are the developer, an anti-punkbuster movement has been developing this form for a few months....

 

When EA closes Battlefield 3, there will only be servers without punkbuster, I don't understand that the players keep on attacking punkbuster... they'll put it upside down soon

[tyger07]

XpKiller's plugin requires punkbuster to keep track of players. If his plugin doesn't store data to the database, my stats page can't display that data.

 

Punkbuster is integral to Xpkiller's plugin to keep track of unique players across name changes, location changes, IP address changes, etcetera. Without punkbuster, it can't determine players' identities.

[TheTomik]

Hello. Is there some way how to do this for free? I mean if there is some hosting for free supports all requirements 

[Prophet731]

Hey @tyger07, @sixpax12 is having issues with his banners being generated. Some do and some don't. I'm not sure if it's your cache thing but the images are not being linked correctly on the HTML side cause in a folder I saw the image and it generated just fine. Would you happen to know what's causing it? Has the GD extension and correct permissions so i'm at a loss on your code

Thanks

[tyger07]

Is there a link for me to view, poke and prod, and think about?  That would be very helpful.

[sixpax12]

21 minutes ago, tyger07 said:

Is there a link for me to view, poke and prod, and think about?  That would be very helpful.

https://www.vq37.org/index.php?pages/vq37_statistics_landing/

[tyger07]

"You must be logged-in to do that."

[Hedius]

The php version is probably >=7.1

Updating pchart to the latest version should fix it. At least it did for me.

Not sure if it is the problem here. But just a suggestion

[Prophet731]

32 minutes ago, tyger07 said:

"You must be logged-in to do that."

http://statistics.vq37.org/bf3/

28 minutes ago, Hedius said:

The php version is probably >=7.1

Updating pchart to the latest version should fix it. At least it did for me.

Not sure if it is the problem here. But just a suggestion

He's on 5.6 for that domain.

[Hedius]

6 minutes ago, Prophet731 said:

http://statistics.vq37.org/bf3/

He's on 5.6 for that domain.

Hmm

[tyger07]

All over that stats webpage I see "3".  At the beginning of almost every section, "3" is just sitting there.  I wonder why.  And I wonder if that has something to do with corrupting the image headers.

 

I won't have access to my computer for quite a while, so my abilities/will to snoop are limited at the moment.

[sixpax12]

1 hour ago, tyger07 said:

All over that stats webpage I see "3".  At the beginning of almost every section, "3" is just sitting there.  I wonder why.  And I wonder if that has something to do with corrupting the image headers.

 

I won't have access to my computer for quite a while, so my abilities/will to snoop are limited at the moment.

I think that is something that was changed in one of the sql queries to fix the live scoreboard not working ... inspecting the page shows a reference to a query ... I think.

[tyger07]

As I suspected, I see that the first character at the beginning of the image headers is "3".  I have no idea where the 3 is coming from, but its all over your web page.

 

Have you modified any of the source code?

 

Because the image headers are corrupted by the 3, none of those images are displayed.  The "3" seems to be created at the beginning of your web server's PHP files.  Some sort of debugger output or something?  It's really weird.

 

Fix the 3's, and I am pretty sure that the images will be fixed too.

 

  

[sixpax12]

9 hours ago, tyger07 said:

As I suspected, I see that the first character at the beginning of the image headers is "3".  I have no idea where the 3 is coming from, but its all over your web page.

 

Have you modified any of the source code?

 

Because the image headers are corrupted by the 3, none of those images are displayed.  The "3" seems to be created at the beginning of your web server's PHP files.  Some sort of debugger output or something?  It's really weird.

 

Fix the 3's, and I am pretty sure that the images will be fixed too.

 

  

something prophet would have to look at as I think it is something to do with several mysql query statements that he edited to get the live scoreboard to work ... 

[tyger07]

I do not think that editing any query will cause all of your PHP files to echo out a  3 at their beginning.  Something is up with the web server.

[Prophet731]

15 hours ago, sixpax12 said:

something prophet would have to look at as I think it is something to do with several mysql query statements that he edited to get the live scoreboard to work ... 

 

14 hours ago, tyger07 said:

I do not think that editing any query will cause all of your PHP files to echo out a  3 at their beginning.  Something is up with the web server.

@sixpax12 When you transferred the files to the new server, how did you do it? Maybe the transfers caused the issue I'm thinking.

[sixpax12]

9 hours ago, Prophet731 said:

 

@sixpax12 When you transferred the files to the new server, how did you do it? Maybe the transfers caused the issue I'm thinking.

they would have been part of the zip file for the whole site and extracted on the server via cpanel file manager.  i suppose i could re-download bf3 and reupload in a test dir to see if it works any differently.

EDIT: That did the trick. 

[tyger07]

I'm glad that re-downloading the files fixed the issue.  I love simple solutions.