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

[ImportBot]

Originally Posted by Kinsman*:

 

Ah well, worth a try then, just because those forums are popular, does not make them secure, so no it does not work on ours.

 

Ezstats is just reading from our database what was stored there from BF4stats, so I thought it would be possible to read our own stats and generate png files was all.

[ImportBot]

Originally Posted by ty_ger07*:

 

Ah well, worth a try then, just because those forums are popular, does not make them secure, so no it does not work on ours.

It does not work on yours? Your answer was kind of confusing.

 

Ezstats is just reading from our database what was stored there from BF4stats, so I thought it would be possible to read our own stats and generate png files was all.

It is generating an image the same way as my code generates an image, but then it is saving the image to your server and giving you a link to it. The thing I don't like is every time you view a 'generate signature' link, an image is generated and saved to your server and it will just keep creating more and more images even if they aren't actually used by anyone.

[ImportBot]

Originally Posted by ty_ger07*:

 

Code in first post updated!

 

Changes:

- Added stats signature generator

- Added pagination to player of the week pages

- Added player stats signatures to player stats pages

- Added weapon images to player stats pages

 

Example:

http://open-web-community.com/bf4sta...ID=20&search=1

 

http://open-web-community.com/bf4stats/player-stats/signature/signature.php_PlayerID=20&GameID=1&FAV=0

http://open-web-community.com/bf4stats/player-stats/signature/signature.php_PlayerID=20&GameID=1&FAV=1

 

The stats images option is soldier rank or favorite weapon.

[ImportBot]

Originally Posted by ty_ger07*:

 

Oops!

 

I suppose the clan name should be in the signature also.

 

EDIT: Fixed

[ImportBot]

Originally Posted by CptChaos*:

 

The maps pie I made is far from done, but I lack the time to work things out with it.

So I am giving what I made: http://pastebin.com/33RptVEj

[ImportBot]

Originally Posted by Kinsman*:

 

Oops!

 

I suppose the clan name should be in the signature also.

 

EDIT: Fixed

Looks great but we cannot use php images on our site. Perhaps you could weave some magic and just rename the output to png?

 

heres how ezstats seems to be doing just that.

 

/* Variables */

$filename = $this->id."_".$type.".png";

$filename = $filename;

 

/* Create the picture */

imagepng($this->image, $path.'signatures/'.$filename);

imagedestroy($this->image);

That would remove any compatability issues for all sites.

 

Attached Files:

• signatures.zip

[ImportBot]

Originally Posted by ty_ger07*:

 

Looks great but we cannot use php images on our site. Perhaps you could weave some magic and just rename the output to png?

 

heres how ezstats seems to be doing just that.

 

 

 

That would remove any compatability issues for all sites.

My code already creates the image in the same way. The only difference is ezstats stores the image on the server instead of ouputting the image directly to the client.

As already explained, it would create potentially thousands or hundreds of thousands of unused images.

 

Have you checked to see if there is a way to allow your forum to use this in its bbcode?

[ImportBot]

Originally Posted by Kinsman*:

 

I believe ezstats uses a htaccess file to time out the ones not being used. But I didnt mean create 100's of images, i meant just rename the image you have created to .png.

 

Sure I can modify our bbcode img tag, i have no idea to what, as I cannot just download vbulletin to compare. The point is if they were png they are then universally acceptable on any site, not just a lucky few.

 

If its not feasible to simply rename your image to end in .png then I will try to download a board that works and have a look at their bbcode i guess.

[ImportBot]

Originally Posted by ty_ger07*:

 

I believe ezstats uses a htaccess file to time out the ones not being used. But I didnt mean create 100's of images, i meant just rename the image you have created to .png.

My images ARE PNG files already (as I have already said). Right-click one and save it. You'll see that it is a PNG file.

 

Sure I can modify our bbcode img tag, i have no idea to what, as I cannot just download vbulletin to compare. The point is if they were png they are then universally acceptable on any site, not just a lucky few.

 

If its not feasible to simply rename your image to end in .png then I will try to download a board that works and have a look at their bbcode i guess.

I don't think you understand.

 

The problem you are having is that your forum apparently is not trusting the PHP file which is creating the PNG image and is assuming that a PHP file couldn't possibly output as a PNG image.

 

There is no way that the htaccess file could automatically delete unused images. There is no way for it to know which images are used or not used and no way of guessing when one which hasn't been used for a while will be used again.

 

 

Let me summarize:

 

What my code does:

 

PHP file creates PNG image every time a user's signature is viewed -> PNG image is sent directly to user's computer

 

What EZstats does:

 

PHP file creates PNG image every time a signature preview is generated -> PNG image is saved to server in a folder -> PNG image may be used later in someone's signature or may sit unused forever.

 

I certainly could cache the PNG image to the server to rectify your problem, I just am concerned over the implications of saving two PNG images to the server every time a new user's player stats page is viewed. If you have a robot searching through your stats page, it might view 100 player stats pages in a short period of time which means your server would have to absorb the load of generating and saving 200 images to a folder in a short period of time.

 

Another issue is keeping the image up to date. If the image is cached to the web server, a user's signature is a PNG image and there is nothing which will trigger it to be recreated. If you reference the PHP file directly as I do, you are sure to generate a new up-to-date version every time it is called. But if you use a cached image, there is no feedback back to the server to tell it to update an outdated cached image.

 

It certainly would be possible, I am just concerned about the extra storage space used and the issue of keeping old server cached images up to date somehow.

[ImportBot]

Originally Posted by ty_ger07*:

 

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.

[ImportBot]

Originally Posted by ty_ger07*:

 

Code in first post has been updated!

 

Changes:

- Changed stats signature output to cached PNG file on server for compatibility reasons.

- Fixed error which caused signature image displayed to link to the wrong website.

 

Example:

 

http://open-web-community.com/bf4stats/player-stats/signature/signature.php_PlayerID=1869&GameID=1&FAV=0

 

http://open-web-community.com/bf4sta...ID1869FAV1.png

 

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

[ImportBot]

Originally Posted by Kinsman*:

 

Cool!, have I done something wrong? maybe my webserver config perhaps? NVM, deleted the htaccess file and all good now.

 

[ImportBot]

Originally Posted by ty_ger07*:

 

Cool!, have I done something wrong? maybe my webserver config perhaps?

 

http://jw.servegame.org/stuff/signat...ID1660FAV0.png

I don't know. I don't know what you have done.

 

I would suggest that you delete all files and all sub-directories in the stuff folder and then start over from scratch.

 

Edit: Looks like you got it working.

[ImportBot]

Originally Posted by Sagittaire88*:

 

Thx for good update Ty_ger07

[ImportBot]

Originally Posted by Jaffaman*:

 

I know this might be asking a lot is there a way to to do a list of top 10's?

Example top 10 players,KDR,Deaths,Headshots, Top10 Player for the specific Weapon and top 10 dog tags.

 

I am not a coder so i do not know how hard this might be thanks in advance Jaffaman.

[ImportBot]

Originally Posted by ty_ger07*:

 

I know this might be asking a lot is there a way to to do a list of top 10's?

Example top 10 players,KDR,Deaths,Headshots, Top10 Player for the specific Weapon and top 10 dog tags.

 

I am not a coder so i do not know how hard this might be thanks in advance Jaffaman.

There already is a list of top players. It is on the home page.

 

It shows the top players in pages of 25 at a time, but just look at the first 10 if you don't care about 11 through 5000. If you click on the column heading, you can organize it by top score (default), top rounds played, top kills, top deaths, top KDR, top Headshots, top Headshot Ratio, or player name in alphabetic order.

 

For example:

 

Top score:

http://open-web-community.com/bf4sta...ore&order=DESC

 

Top rounds played:

http://open-web-community.com/bf4sta...nds&order=DESC

 

Top Kills:

http://open-web-community.com/bf4sta...lls&order=DESC

 

Top Deaths:

http://open-web-community.com/bf4sta...ths&order=DESC

 

Top Kill/Death Ratio:

http://open-web-community.com/bf4sta...KDR&order=DESC

 

Top Headshots:

http://open-web-community.com/bf4sta...ots&order=DESC

 

Top Headshot Ratio:

http://open-web-community.com/bf4sta...HSR&order=DESC

 

Players in alphabetic order:

http://open-web-community.com/bf4sta...Name&order=ASC

 

So only thing missing there from what you requested are dogtags and weapons. I had weapon ranks on the player stats page, but removed them because weapon ranking really slows everything down when you are checking every weapon in a huge database with a lot of players. I think you would have to have a different page for each weapon to make it not incredibly slow in a huge database. But how could you afford the space of fitting a link to top 10 players for every weapon in the page menu? There are many weapons and many links would be necessary. It's a design/navigation problem more than a coding problem. The code itself is rather simple. Dogtags once again is a design/navigation problem. Where is a good place to put that information? Should number of dogtags be in the top players table?

[ImportBot]

Originally Posted by Kinsman*:

 

I don't know. I don't know what you have done.

 

I would suggest that you delete all files and all sub-directories in the stuff folder and then start over from scratch.

 

Edit: Looks like you got it working.

Yes, I deleted the htaccess file and all good now. I will set up a bat file and schedule it to mt the directory every few days, should take care of the caching problem.

 

Thanks for the excellent update, and Merry Christmas.

[ImportBot]

Originally Posted by ty_ger07*:

 

Yes, I deleted the htaccess file and all good now. I will set up a bat file and schedule it to mt the directory every few days, should take care of the caching problem.

 

Thanks for the excellent update, and Merry Christmas.

You won't want to delete the images, otherwise everyone's signatures will quit working every time you delete their images. Once their signature quits working, they will have to go to their player stats page to regenerate the image.

 

Like I said, their is no way for you to know which images aren't being used anywhere and which images are being used somewhere.

[ImportBot]

Originally Posted by MarcoV1980*:

 

It's working like a charm, really like the update to BF4.

 

Thanks!

[ImportBot]

Originally Posted by Jaffaman*:

 

There already is a list of top players. It is on the home page.

 

It shows the top players in pages of 25 at a time, but just look at the first 10 if you don't care about 11 through 5000. If you click on the column heading, you can organize it by top score (default), top rounds played, top kills, top deaths, top KDR, top Headshots, top Headshot Ratio, or player name in alphabetic order.

 

For example:

 

Top score:

http://open-web-community.com/bf4sta...ore&order=DESC

 

Top rounds played:

http://open-web-community.com/bf4sta...nds&order=DESC

 

Top Kills:

http://open-web-community.com/bf4sta...lls&order=DESC

 

Top Deaths:

http://open-web-community.com/bf4sta...ths&order=DESC

 

Top Kill/Death Ratio:

http://open-web-community.com/bf4sta...KDR&order=DESC

 

Top Headshots:

http://open-web-community.com/bf4sta...ots&order=DESC

 

Top Headshot Ratio:

http://open-web-community.com/bf4sta...HSR&order=DESC

 

Players in alphabetic order:

http://open-web-community.com/bf4sta...Name&order=ASC

 

So only thing missing there from what you requested are dogtags and weapons. I had weapon ranks on the player stats page, but removed them because weapon ranking really slows everything down when you are checking every weapon in a huge database with a lot of players. I think you would have to have a different page for each weapon to make it not incredibly slow in a huge database. But how could you afford the space of fitting a link to top 10 players for every weapon in the page menu? There are many weapons and many links would be necessary. It's a design/navigation problem more than a coding problem. The code itself is rather simple. Dogtags once again is a design/navigation problem. Where is a good place to put that information? Should number of dogtags be in the top players table?

Thanks a lot i will try and get our web admin to but them in some sort of blocks so we can put them in a widget on the homepage of our website.

[ImportBot]

Originally Posted by Narf!*:

 

Hi and Merry Christmas to all first

 

I think the new Stats Banner thing is buggy. I've got about 2,5k kills for example, but the banner says I've got 647 kills. Score, rounds, headschots, etc. stats are wrong, too. Just click here to see

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi and Merry Christmas to all first

 

I think the new Stats Banner thing is buggy. I've got about 2,5k kills for example, but the banner says I've got 647 kills. Score, rounds, headschots, etc. stats are wrong, too. Just click here to see

I will have to dig deeper into this. There seems that for some reason, some players have different PlayerIDs in different servers which causes their stats not to be calculated consistently in certain situations.

 

For the majority of players, their stats should be correct, and only the minority with multiple PlayerIDs should have stats which don't agree with eachother.

 

 

 

I posted a question for XpKiller on this subject here:

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry45212

 

 

EDIT:

 

In your situation, it looks like you may also have another problem. It looks like you may have had weapon stats disabled for quite a while which causes the accurate breakdown of stats to fail.

 

A player's Kills, Deaths, Headshots, ... are all stored generically in the playerstats table but my code relies on the more accurate breakdown of stats for each individual weapon. If the server counted 2000 generic kills with weapon stats disabled and then counted 200 accurate kills with weapon stats enabled, my code will only show 200 kills in the signature image.

 

Look at your page here for example:

 

http://koksnutten.net/stats1/index.p...&search=Search

 

See that the player has 15856 kills but no weapon stats and no stats signature image.

[ImportBot]

Originally Posted by Berndel*:

 

for one reason the Signature images don't show up ? any idea

 

 

berndel

Merry Christmas to all

[ImportBot]

Originally Posted by ty_ger07*:

 

for one reason the Signature images don't show up ? any idea

 

 

berndel

Merry Christmas to all

It would help if you gave me a link to look at.

[ImportBot]

Originally Posted by Berndel*:

 

ups sorry

http://gwg-clan.eu/gwg-stats/index.p...rID=9&search=1

[ImportBot]

Originally Posted by ty_ger07*:

 

ups sorry

http://gwg-clan.eu/gwg-stats/index.p...rID=9&search=1

Do you have any images in http://gwg-clan.eu/gwg-stats/signature/cache/ ? Does that directory exist? Does your PHP installation include the GD extension? Have you tried deleting the .htaccess file in the signature cache folder to see if that makes a difference?

[ImportBot]

Originally Posted by Narf!*:

 

I will have to dig deeper into this. There seems that for some reason, some players have different PlayerIDs in different servers which causes their stats not to be calculated consistently in certain situations.

 

For the majority of players, their stats should be correct, and only the minority with multiple PlayerIDs should have stats which don't agree with eachother.

 

 

 

I posted a question for XpKiller on this subject here:

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry45212

 

 

EDIT:

 

In your situation, it looks like you may also have another problem. It looks like you may have had weapon stats disabled for quite a while which causes the accurate breakdown of stats to fail.

 

A player's Kills, Deaths, Headshots, ... are all stored generically in the playerstats table but my code relies on the more accurate breakdown of stats for each individual weapon. If the server counted 2000 generic kills with weapon stats disabled and then counted 200 accurate kills with weapon stats enabled, my code will only show 200 kills in the signature image.

 

Look at your page here for example:

 

http://koksnutten.net/stats1/index.p...&search=Search

 

See that the player has 15856 kills but no weapon stats and no stats signature image.

Yes, I've disabled weapon stats because of there were many weapon keys missing in Procon, so I thought it would maybe better to disable this. We plan a reset of our stats at the beginning of 2014 and then weapon stats will be re-enabled. But this was only on 1 server, the other 3 servers have never enabled weapon stats.

 

But if it maybe would help you, I could send you a backup of our sql database.

[ImportBot]

Originally Posted by Berndel*:

 

Do you have any images in http://gwg-clan.eu/gwg-stats/signature/cache/ ? Does that directory exist? Does your PHP installation include the GD extension? Have you tried deleting the .htaccess file in the signature cache folder to see if that makes a difference?

php5-gd is already the newest version.

directory exist? yes no images ,if i delete .htaccess this not help

[ImportBot]

Originally Posted by ty_ger07*:

 

Yes, I've disabled weapon stats because of there were many weapon keys missing in Procon, so I thought it would maybe better to disable this. We plan a reset of our stats at the beginning of 2014 and then weapon stats will be re-enabled. But this was only on 1 server, the other 3 servers have never enabled weapon stats.

 

But if it maybe would help you, I could send you a backup of our sql database.

I don't need a backup. With weapon stats disabled, weapon stats and signatures will be messed up and there is nothing I could do to artificially try to correct the data. The stats and signature images can only be as accurate as the data in the database.

[ImportBot]

Originally Posted by ty_ger07*:

 

php5-gd is already the newest version.

directory exist? yes no images ,if i delete .htaccess this not help

Can you run this query in phpmyadmin and verify that you get a proper output?

 

SELECT tw.Friendlyname, SUM(tws.Kills) AS weaponKills, tpd.SoldierName, tpd.GlobalRank, 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_playerstats tps

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

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

INNER JOIN tbl_weapons_stats tws ON tws.StatsID = tps.StatsID

INNER JOIN tbl_weapons tw ON tw.WeaponID = tws.WeaponID

WHERE tpd.PlayerID = 9

GROUP BY Friendlyname

ORDER BY weaponKills DESC

LIMIT 1