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

[ImportBot]

Originally Posted by Kinsman*:

 

I don't know what you are trying to say.

Easier to just say theres no stopping you!

[ImportBot]

Originally Posted by Jaffaman*:

 

Is there a easy way to reset all the stats as we want to start a fresh on the 1st Jan 2014.

[ImportBot]

Originally Posted by MarcoV1980*:

 

Is there a easy way to reset all the stats as we want to start a fresh on the 1st Jan 2014.

Just empty the tables from mysqladmin or any other remote admin.

[ImportBot]

Originally Posted by ty_ger07*:

 

Just empty the tables from mysqladmin or any other remote admin.

1) Stop your PRoCon layer server.

 

2) Empty or drop all tables using phpmyadmin or any other remote database connection program you are using.

 

drop_tables.jpg

 

 

If you drop tables, the tables will be gone and will be recreated by the plugin next time the plugin is started back up. If you empty the tables, the tables will still be there, but will have no data in them. It's up to you. Either way will work. I just think dropping the tables is more thorough.

 

 

NOTE: Due to foreign key constraints, you will not be able to drop all tables at once. It will try, but 3 tables will not drop. Just try again, and 1 table will drop. Then try a third time and the remaining tables should drop. Just keep dropping all tables as many times as necessary until all the tables are gone.

[ImportBot]

Originally Posted by Jaffaman*:

 

Thanks a lot both of you for your help

[ImportBot]

Originally Posted by dingo_doo*:

 

Y a t'il quelqu'un qui parle français et qui a créer ce genre de page? Et qui saurait m'aider pour en faire une? Merci d'avance.

[ImportBot]

Originally Posted by mikedbom*:

 

ty_ger07,

 

is there any way to create a team page? like either a page that i can specify players or a filter based on tags? I like having the full server stats but would also like a page dedicated to just my community. great work btw.

[ImportBot]

Originally Posted by ty_ger07*:

 

ty_ger07,

 

is there any way to create a team page? like either a page that i can specify players or a filter based on tags? I like having the full server stats but would also like a page dedicated to just my community. great work btw.

Are these "tags" in their soldier name, or are they clan tags? Clan tags are not sent over rcon and therefore are unavailable.

[ImportBot]

Originally Posted by ty_ger07*:

 

Y a t'il quelqu'un qui parle français et qui a créer ce genre de page? Et qui saurait m'aider pour en faire une? Merci d'avance.

I do not understand french.

 

Programming languages almost exclusively use english; PHP as well. So you will have to program it in english. It would be easier for you to just search through the code and translate the echoed words.

[ImportBot]

Originally Posted by mikedbom*:

 

they would be the clan tags. i've seen them appear in bfstats.com. if i cant filter by tags, maybe i can edit a page to pull data for specfic users that i can add manually? i could probably reverse engineer it but was just wondering if you had a solution in place. thread is very long to read each post.

[ImportBot]

Originally Posted by ty_ger07*:

 

they would be the clan tags. i've seen them appear in bfstats.com. if i cant filter by tags, maybe i can edit a page to pull data for specfic users that i can add manually? i could probably reverse engineer it but was just wondering if you had a solution in place. thread is very long to read each post.

The only way to get the clan tags is to query battlelog like bf4stats does (by permission I am sure). My code just gets the data from the database xpkiller's plugin provides via data from rcon, so no clan tags.

[ImportBot]

Originally Posted by mikedbom*:

 

The only way to get the clan tags is to query battlelog like bf4stats does (by permission I am sure). My code just gets the data from the database xpkiller's plugin provides via data from rcon, so no clan tags.

ok, thanks. i will see what i can do about creating my own page.

[ImportBot]

Originally Posted by Jamesonp*:

 

ok, thanks. i will see what i can do about creating my own page.

You could always just query the db with your clan members names and make a page that way..

[ImportBot]

Originally Posted by mikedbom*:

 

You could always just query the db with your clan members names and make a page that way..

yeah, just have to figure out how to do that

[ImportBot]

Originally Posted by Kinsman*:

 

Its an interesting goal, perhaps Tyger could help with a query to pull certain soldier names out?

[ImportBot]

Originally Posted by ty_ger07*:

 

yeah, just have to figure out how to do that

I think the hardest part is organizing your clan members. I can tell you how to grab a list of X players stats, but I can't tell you how to combat the urge players have to constantly change their soldier names and screw up the system.

[ImportBot]

Originally Posted by mikedbom*:

 

I think the hardest part is organizing your clan members. I can tell you how to grab a list of X players stats, but I can't tell you how to combat the urge players have to constantly change their soldier names and screw up the system.

I would appreciate a query...i think i would know how to do it but getting it into the page looks tough as you have a lot of conditionals in the code. I'm not worried about players changing names as they would understand their stats would reset as well. Unless you are capturing GUID and querying from that.

[ImportBot]

Originally Posted by ty_ger07*:

 

If you are willing to do the work of finding their PlayerIDs, you will want to use their PlayerIDs in the query so that the information remains correct even if the player changes their name. You could search by SoldierName instead, but I would recommend using PlayerID since those will remain the same even if the player changes their name.

 

How do you find their PlayerIDs? Just do a search for their name in my stats page. Then look at their stats page.

 

For instance, if I search for "magsin", it brings me to his stats page:

http://open-web-community.com/bf4sta...&search=Search

 

Towards the bottom of that page, if you look at his signature, you will see that his signature image is "PID788FAV0.png". PID788 means that his PlayerID is 788.

 

Make a list of all the PlayerIDs you are after, then they can easily be added to a query.

 

I will give you an example page shortly after I make an example.

[ImportBot]

Originally Posted by ty_ger07*:

 

I would appreciate a query...i think i would know how to do it but getting it into the page looks tough as you have a lot of conditionals in the code. I'm not worried about players changing names as they would understand their stats would reset as well. Unless you are capturing GUID and querying from that.

Here's an example:

http://open-web-community.com/test/i...lclanmembers=1

 

In this example, it is looking for stats for PlayerID 1, 2, 3, or 4.

 

clanmembers.php has these queries:

 

Starting on Line 42 (server pagination query):

SELECT COUNT(tpd.`SoldierName`)

FROM `tbl_playerstats` tps

INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = tps.`StatsID`

INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`

WHERE tsp.`ServerID` = {$ServerID}

AND tpd.`GameID` = {$GameID}

AND (tpd.`PlayerID` = 1 OR tpd.`PlayerID` = 2 OR tpd.`PlayerID` = 3 OR tpd.`PlayerID` = 4)

Starting on Line 57 (global pagination query):

SELECT SUM(tps.`Score`) AS Score

FROM `tbl_playerdata` tpd

INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`

INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`

WHERE tpd.`GameID` = {$GameID}

AND (tpd.`PlayerID` = 1 OR tpd.`PlayerID` = 2 OR tpd.`PlayerID` = 3 OR tpd.`PlayerID` = 4)

GROUP BY tpd.`PlayerID`

Starting on Line 148 (server stats query):

SELECT tpd.`SoldierName`, tpd.`PlayerID`, tps.`Score`, tps.`Kills`, tps.`Deaths`, (tps.`Kills`/tps.`Deaths`) AS KDR, tps.`Rounds`, tps.`Headshots`, (tps.`Headshots`/tps.`Kills`) AS HSR

FROM `tbl_playerstats` tps

INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = tps.`StatsID`

INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`

WHERE tsp.`ServerID` = {$ServerID}

AND tpd.`GameID` = {$GameID}

AND (tpd.`PlayerID` = 1 OR tpd.`PlayerID` = 2 OR tpd.`PlayerID` = 3 OR tpd.`PlayerID` = 4)

ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder}

LIMIT {$offset}, {$rowsperpage}

Starting on Line 164 (global stats query):

SELECT tpd.`SoldierName`, tpd.`PlayerID`, SUM(tps.`Score`) AS Score, SUM(tps.`Kills`) AS Kills, SUM(tps.`Deaths`) AS Deaths, (SUM(tps.`Kills`)/SUM(tps.`Deaths`)) AS KDR, SUM(tps.`Rounds`) AS Rounds, SUM(tps.`Headshots`) AS Headshots, (SUM(tps.`Headshots`)/SUM(tps.`Kills`)) AS HSR

FROM `tbl_playerdata` tpd

INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`

INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`

WHERE tpd.`GameID` = {$GameID}

AND (tpd.`PlayerID` = 1 OR tpd.`PlayerID` = 2 OR tpd.`PlayerID` = 3 OR tpd.`PlayerID` = 4)

GROUP BY tpd.`PlayerID`

ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder}

LIMIT {$offset}, {$rowsperpage}

Note that in each of those queries are the lines

AND (tpd.`PlayerID` = 1 OR tpd.`PlayerID` = 2 OR tpd.`PlayerID` = 3 OR tpd.`PlayerID` = 4)

Change those PlayerIDs in all four queries to the PlayerIDs of interest and add as many PlayerIDs as you want separated by 'OR'.

 

 

You can download it here:

http://open-web-community.com/test/B...sTestStats.zip

 

Files changed:

index.php

common/index.php

 

Files added:

clanmembers.php

[ImportBot]

Originally Posted by mikedbom*:

 

ty_ger, you are awesome. thank you very much for doing this. i was digging through your code and i have to say it is very well laid out and well commented. I'm pretty good with HTML/CSS but PHP is a weak point of mine so it would have taken me days to figure it out if I could at all. I'm sure this will be a good feature to add for upcoming releases.

 

i'm also planning to add a link to BFStats.com so we can have the battlelog stats and our server stats in a central location. I'm sure you know you can create leaderboards there. It will be nice to see what everyone has done in the battlefield world as well as drive competition to play more on our own server and drive those stats up.

 

Again, thank you.

[ImportBot]

Originally Posted by ty_ger07*:

 

You could always just query the db with your clan members names and make a page that way..

http://stats.precisionclan.com/index.php

 

[ Modified by pRc|Jamesonp ]

Ok?

[ImportBot]

Originally Posted by Kinsman*:

 

Can't tell, I have no idea what I'm looking at? modified how?

[ImportBot]

Originally Posted by ty_ger07*:

 

Can't tell, I have no idea what I'm looking at? modified how?

Exactly.

 

I guess I should just keep my mouth closed, but I am puzzled.

[ImportBot]

Originally Posted by Kinsman*:

 

Hehe, seems pretty standard to me, perhaps I missed something? Anyhow, thanks for the clan page, its great.

 

http://jw.servegame.org/bf4stats/ind...lclanmembers=1

 

Just a note, all references to "potw" need to become "clanmembers" on all the links.

[ImportBot]

Originally Posted by CptChaos*:

 

Fine, Fine, Fine...

 

I will....

 

But don't get mad at me if you see old cached versions of stats being displayed. It will be the user's job to view their player stats page from time to time to generate a more current version of their stats signature.

A fix is quite simple:

Create a (sub)folder, and place a script in it, but named as .png. Place an .htaccess file with it with following code:

Code:

AddType application/x-httpd-php .png

Now the .png file in the folder will be parsed as PHP. And yes, not what it should be, but hey, with proper headers you'd get a proper .png as well.

[ImportBot]

Originally Posted by Kinsman*:

 

Yes, my original intent was just to use htaccess to name the link as a png file. I have to confess I don't fully understand why ezstats would create a single png file that is never updated, and I do not believe thats how it works.

 

http://www.junglewraiths.net/index.php_name=bf4stats

 

Everytime I check someones sigs, they are up to date.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hehe, seems pretty standard to me, perhaps I missed something? Anyhow, thanks for the clan page, its great.

 

http://jw.servegame.org/bf4stats/ind...lclanmembers=1

 

Just a note, all references to "potw" need to become "clanmembers" on all the links.

Good point.

[ImportBot]

Originally Posted by ty_ger07*:

 

A fix is quite simple:

Create a (sub)folder, and place a script in it, but named as .png. Place an .htaccess file with it with following code:

Code:

AddType application/x-httpd-php .png

Now the .png file in the folder will be parsed as PHP. And yes, not what it should be, but hey, with proper headers you'd get a proper .png as well.

Huh. That seems like sort of a hack, but if it works, that's interesting.

 

My code is caching images now anyway.

 

I have to confess I don't fully understand why ezstats would create a single png file that is never updated, and I do not believe thats how it works.

If it is up to date, then it must be getting updated by some method or another. Usually PHP code is only executed when a user looks at it and therefore you have to look at the player's stats page in my code to update the user's signature image. Perhaps ezstats makes a task to update all user's signatures every time any single page is looked at.

[ImportBot]

Originally Posted by TheBoomplayer*:

 

Hey

 

I have a Problem with my Website for this Plugin. I hope someone can help me. In the Config.php i set all correct settings, but when i go to my subdomain where i install this Plugins (http://zockerstube.silver-revenge.de/) it dont load the website.

 

Please help

 

Edit:

And when i set a fault IP the plugin is there with a error

 

Sorry my English is very bad...

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey

 

I have a Problem with my Website for this Plugin. I hope someone can help me. In the Config.php i set all correct settings, but when i go to my subdomain where i install this Plugins (http://zockerstube.silver-revenge.de/) it dont load the website.

 

Please help

 

Edit:

And when i set a fault IP the plugin is there with a error

 

Sorry my English is very bad...

It is likely a DNS issue where you will need to wait.

 

Usually domain name and subdomain creations/changes take 4-6 hours to be available to route to your computer's browser. Since the code is internally referring to various subdirectories of that subdomain, it would manifest itself as a multifaceted issue (even if you manually use the correct ip address in your browser).

 

I think that it will work fine once the subdomain route is established by the DNS (domain name service host resolution). I think you will just have to wait a while and then try again.

 

Does it work fine in a sub-directory of http://silver-revenge.de/?