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

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey Ty_ger07,

 

Just have a quick questions. I apologize if this has already been answered. Any plans to implement a "Total Playtime" time field on the live scoreboard or when you click on the player?

 

Great work!!!!

I am not sure if XpKiller's plugin records total play time more accurate than it used to. It used to be horribly wrong and that is why I didn't implemented the number into any page.

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok thank you ty_ger07 !

 

And latest question ^^ How I can integrate the stats on a website ?

I am not sure exactly what you are asking. Can you please explain what you have in mind?

[ImportBot]

Originally Posted by TonyGun38*:

 

With ezstats (leaderboard for example) we can integrate the leaderboard on a website page : http://www.fws-gaming.com/community/...classement-fws

With your BF4 server stats page it's possible ?

[ImportBot]

Originally Posted by ty_ger07*:

 

With ezstats (leaderboard for example) we can integrate the leaderboard on a website page : http://www.fws-gaming.com/community/...classement-fws

With your BF4 server stats page it's possible ?

With mine, you can put it in an iframe which is a pretty ugly solution. Otherwise, no, not really possible.

[ImportBot]

Originally Posted by ty_ger07*:

 

Update Released!

 

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

 

Changes:

- Added pagination to Suspicious Players page

- Added expand/contract functionality to player page to reduce page height

- Player ranks are now calculated on player stats page after the player page is loaded

- Combined server ranks now available on player stats page

[ImportBot]

Originally Posted by test_bench*:

 

Hi,

 

Thanks for your work.

 

Just wondering how often the leaderboard cache is updated? I have had the page running for a few hours now and it has not changed. Is there a config option to set this anywhere?

 

 

Thanks,

TB

[ImportBot]

Originally Posted by Level*:

 

Thanks for the update, very quickly the page is now.

 

Can you tell me where I can change the color again so would like an orange for the player.

 

Stats Orange.png

 

Stats jetzt.png

 

THX

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi,

 

Thanks for your work.

 

Just wondering how often the leaderboard cache is updated? I have had the page running for a few hours now and it has not changed. Is there a config option to set this anywhere?

 

 

Thanks,

TB

It updates every 12 hours. No, there is no config option.

 

As your database grows, it will become less and less important to update it more often in the interest of accuracy and it will become more and more important for it to be updated less often for performance reasons.

 

"cache_top_twenty" is a function in functions.php.

 

https://github.com/tyger07/BF4-Serve.functions.php

 

Code:

// function to cache top 20 players
function cache_top_twenty($ServerID, $valid_ids, $GameID, $BF4stats)
{
	// check to see if this top twenty cache table exists
	@mysqli_query($BF4stats,"
		CREATE TABLE IF NOT EXISTS `tyger_stats_top_twenty_cache`
		(`PlayerID` INT(10) UNSIGNED NOT NULL, `GID` INT(11) NOT NULL DEFAULT '0', `SID` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `SoldierName` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Score` INT(11) NOT NULL DEFAULT '0', `Kills` INT(11) NOT NULL DEFAULT '0', `KDR` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `HSR` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `timestamp` INT(11) NOT NULL DEFAULT '0', INDEX (`PlayerID`, `SID`))
		ENGINE=MyISAM
		DEFAULT CHARSET=utf8
		COLLATE=utf8_bin
	");
	
	// initialize timestamp values
	$now_timestamp = time();
	$old = $now_timestamp - 43200;

"$old = $now_timestamp - 43200;"

43200 is the number of seconds (12 hours) for the cache.

[ImportBot]

Originally Posted by ty_ger07*:

 

Thanks for the update, very quickly the page is now.

 

Can you tell me where I can change the color again so would like an orange for the player.

 

Stats Orange.png

 

Stats jetzt.png

 

THX

It's in stats.css.

 

https://github.com/tyger07/BF4-Serve...mmon/stats.css

 

More than likely, you changed this:

Code:

/* links */
a, a:visited{
	color: #D5DDE5;
	text-decoration: none;
	box-shadow: 0px 0px 20px 1px rgba(100,120,150,0.1);
}
a:hover, a:active{
	color: #DDDDDD;
	text-decoration: none;
	box-shadow: 0px 0px 10px 1px rgba(000,020,050,0.1);
}

[ImportBot]

Originally Posted by ty_ger07*:

 

http://www.fws-gaming.com/bf4serverstats/

 

[ Statistics data provided by FwS Gaming BF4 servers ] [ Stats page by FwS Gaming ]

Ok? That is a very shameful thing to do. XpKiller and I deserve credit for each of our hundreds of hours of work.

[ImportBot]

Originally Posted by Level*:

 

http://www.fws-gaming.com/bf4serverstats/

 

 

 

Ok? That is a very shameful thing to do. XpKiller and I deserve credit for each of our hundreds of hours of work.

@ ty_ger07

 

Oh this is really shameful, praise and appreciation, i love your page very very good work

 

----

 

@ TonyGun38

 

shameful to remove the copyright

[ImportBot]

Originally Posted by Jamesonp*:

 

Very nice, thanks!

[ImportBot]

Originally Posted by Hutchew*:

 

http://www.fws-gaming.com/bf4serverstats/

 

 

 

Ok? That is a very shameful thing to do. XpKiller and I deserve credit for each of our hundreds of hours of work.

Yeah, that's fucked up for sure.

 

Thanks for the update, Tyger.

 

 

Hutchew

[ImportBot]

Originally Posted by ty_ger07*:

 

I have seen them yes, that's why i am asking. Using the server banner on http://nbfc.no/forums/

 

Well, i was thinking something along the line of the gametracker server signature, just like this:

I have been plugging away at it slowly.

 

This is what I have so far:

http://open-web-community.com/bf4stats/player-stats/banner/banner.png_sid=3

 

The text isn't great, the graph is missing, and stuff is out of alignment. I just wanted to show you that I haven't ignored your request.

[ImportBot]

Originally Posted by test_bench*:

 

Thanks - great work!

 

It updates every 12 hours. No, there is no config option.

 

As your database grows, it will become less and less important to update it more often in the interest of accuracy and it will become more and more important for it to be updated less often for performance reasons.

 

"cache_top_twenty" is a function in functions.php.

 

https://github.com/tyger07/BF4-Serve.functions.php

 

Code:

// function to cache top 20 players
function cache_top_twenty($ServerID, $valid_ids, $GameID, $BF4stats)
{
	// check to see if this top twenty cache table exists
	@mysqli_query($BF4stats,"
		CREATE TABLE IF NOT EXISTS `tyger_stats_top_twenty_cache`
		(`PlayerID` INT(10) UNSIGNED NOT NULL, `GID` INT(11) NOT NULL DEFAULT '0', `SID` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `SoldierName` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Score` INT(11) NOT NULL DEFAULT '0', `Kills` INT(11) NOT NULL DEFAULT '0', `KDR` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `HSR` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `timestamp` INT(11) NOT NULL DEFAULT '0', INDEX (`PlayerID`, `SID`))
		ENGINE=MyISAM
		DEFAULT CHARSET=utf8
		COLLATE=utf8_bin
	");
	
	// initialize timestamp values
	$now_timestamp = time();
	$old = $now_timestamp - 43200;

"$old = $now_timestamp - 43200;"

43200 is the number of seconds (12 hours) for the cache.

[ImportBot]

Originally Posted by TonyGun38*:

 

http://www.fws-gaming.com/bf4serverstats/

 

 

 

Ok? That is a very shameful thing to do. XpKiller and I deserve credit for each of our hundreds of hours of work.

Oh sorry bro. It's modified

 

And I've resized the images for Final Stand (Maps and Ranks)

 

Maps :

 

ZIP : maps.zip

 

Attached Files:

• XP4_Arctic.png
• XP4_SubBase.png
• XP4_Titan.png
• XP4_WlkrFtry.png

[ImportBot]

Originally Posted by TonyGun38*:

 

Ranks :

 

ZIP : ranks.zip

 

Attached Files:

• Battlefield_4_Ranks.png

[ImportBot]

Originally Posted by ty_ger07*:

 

Did Final Stand come out? I haven't played in many months.

[ImportBot]

Originally Posted by Breakmaster*:

 

Yes, today

[ImportBot]

Originally Posted by test_bench*:

 

I have a question about the Top Players vs the Top 20 Players This Week.

 

How is it that the values for the same player can be different for these two pages?

 

For example, I have one player who in the Top Players has a score of 87,145 but in the Top 20 Players this week section the same player has a score of 117,234 - how is this possible?

 

Looking into the database, the playerstats table holds the value of 87,145 and the sessions table holds the value of 117,234.

 

Am I missing something here?

 

Also, what is the stats_sessions table for?

 

 

Thanks,

TB

[ImportBot]

Originally Posted by ty_ger07*:

 

I have a question about the Top Players vs the Top 20 Players This Week.

 

How is it that the values for the same player can be different for these two pages?

 

For example, I have one player who in the Top Players has a score of 87,145 but in the Top 20 Players this week section the same player has a score of 117,234 - how is this possible?

 

Looking into the database, the playerstats table holds the value of 87,145 and the sessions table holds the value of 117,234.

 

Am I missing something here?

 

Also, what is the stats_sessions table for?

 

 

Thanks,

TB

This is a known issue with XpKiller's plugin. For whatever reason, XpKiller's plugin calculates session score way different than player stats score. I rely on the assumption that everyone's session score is equally screwed up and therefore still useful in making comparisons.

 

The tyger_stats_sessions table is for storing X number of visitors are viewing this page data.

[ImportBot]

Originally Posted by test_bench*:

 

Thanks.

 

 

Sent from my iPhone using Tapatalk

[ImportBot]

Originally Posted by ty_ger07*:

 

I have seen them yes, that's why i am asking. Using the server banner on http://nbfc.no/forums/

 

Well, i was thinking something along the line of the gametracker server signature, just like this:

Will this work for you?

 

http://open-web-community.com/bf4stats/player-stats/banner/banner.png_sid=3&dummy

[ImportBot]

Originally Posted by TMiland*:

 

Will this work for you?

 

http://open-web-community.com/bf4stats/player-stats/banner/banner.png_sid=3&dummy

That looks very nice sir! Good job!

 

It it too much to ask to get the country flag too?

 

And maybe place the Players: Previous 24 hrs above the graph not inside?

[ImportBot]

Originally Posted by ty_ger07*:

 

It it too much to ask to get the country flag too?

The server's country is not in the database. On GameTracker, you can manually select whichever country you want it to appear as.

 

Maybe I can find a php API to determine the server country based on IP address. I don't know how reliable/accurate it would be.

 

Or maybe I can just select the country code of one of the players in the database who have an ip address similar to the server's ip address and thereby indirectly rely on Procon's geoip data.

[ImportBot]

Originally Posted by TMiland*:

 

The server's country is not in the database. On GameTracker, you can manually select whichever country you want it to appear as.

 

Maybe I can find a php API to determine the server country based on IP address. I don't know how reliable/accurate it would be.

 

Or maybe I can just select the country code of one of the players in the database who have an ip address similar to the server's ip address and thereby indirectly rely on Procon's geoip data.

Or you could use google api for ip to country: http://ip-api.com/json/{ipadress}

 

Docs: ip-api.com/docs/

[ImportBot]

Originally Posted by ty_ger07*:

 

Or you could use google api for ip to country: http://ip-api.com/json/{ipadress}

 

Docs: ip-api.com/docs/

Stated as quoted.

[ImportBot]

Originally Posted by TMiland*:

 

Stated as quoted.

yes. It it useable?

[ImportBot]

Originally Posted by ty_ger07*:

 

yes. It it useable?

Certainly. Trusting on an outside source to exist and remain working without changing is always a risk. But the results seem to be very accurate. Querying the database for players with similar ips to the server's ip was hitting and missing a group of countries around the server.

[ImportBot]

Originally Posted by TMiland*:

 

Certainly. Trusting on an outside source to exist and remain working without changing is always a risk. But the results seem to be very accurate. Querying the database for players with similar ips to the server's ip was hitting and missing a group of countries around the server.

That's why i was giving you a reliable source, not something that just popped up on the net days ago.

 

*edit

ip2nation.com could also work, most reliable i guess.