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

[ImportBot]

Originally Posted by CptChaos*:

 

I think the query used explains it all:

 

SELECT `MapName`, COUNT(`MapName`) AS number FROM `tbl_mapstats` WHERE `ServerID` = 3 GROUP BY `MapName`;

 

Making it global is also easy, just remove the WHERE-clause.

 

Results are passed to pChart (it just needs the mapnames and numbers) and pChart does the rest.

It requires some extra files in the class folder though.

 

I'll see what I can do to make the pie larger, I think it would help a lot.

Thing is, with the expansions coming, the image would become higher in height as well, because the legend on the left could become taller, depending on serversettings.

[ImportBot]

Originally Posted by ty_ger07*:

 

So that would be how many times each map was loaded.

[ImportBot]

Originally Posted by CptChaos*:

 

So that would be how many times each map was loaded.

Yes, pChart does the rest.

[ImportBot]

Originally Posted by Jamesonp*:

 

Love the work, thanks!

 

It would be awesome if you could also make something similar to this for each server to be able to use on our home pages.

[ImportBot]

Originally Posted by ty_ger07*:

 

Love the work, thanks!

 

It would be awesome if you could also make something similar to this for each server to be able to use on our home pages.

What kind of information would you want displayed? The exact same information you linked to or something else?

[ImportBot]

Originally Posted by Jamesonp*:

 

What kind of information would you want displayed? The exact same information you linked to or something else?

The exact info (minus the ranking of course) would be great. Clicking a player displays their stats.

[ImportBot]

Originally Posted by ty_ger07*:

 

The exact info (minus the ranking of course) would be great. Clicking a player displays their stats.

I am confused why it is even necessary if the information is the same. It seems like the one would be equal to the other other than the name linking to their stats page.

 

I will consider it.

 

You would have to include it into your page as an iframe the same way as you do with the GameTracker iframe if you wanted the stylesheet to work properly since I am not sure how to make a PHP page compile itself as an image (maybe it isn't too difficult though, I don't know). You would use query strings I suppose to control what information is or isn't shown just like you do with the GameTracker server information.

[ImportBot]

Originally Posted by Jamesonp*:

 

iframes would be ok. The only reason I'm asking for it is so users can easily click on players in game and get their statistics.

[ImportBot]

Originally Posted by ty_ger07*:

 

iframes would be ok. The only reason I'm asking for it is so users can easily click on players in game and get their statistics.

Good idea!

 

Compiling it as an image wouldn't work in that case because you can't click links in images, so it would have to be an iframe.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey Hey!

 

I haven't compiled a PHP image before, so I started with that first. It's coming along nicely. The iframe version just didn't seem like much of a challenge. But don't worry, once I make an image version, adding the same as an iframe version will be easy since the code will be mostly reused.

[ImportBot]

Originally Posted by Jamesonp*:

 

Awesome!

[ImportBot]

Originally Posted by ty_ger07*:

 

Good night!

 

http://open-web-community.com/bf4sta...r/example.html

 

It's an image.

 

http://open-web-community.com/bf4sta...php_ServerID=3

 

banner.jpg

 

(not done yet)

[ImportBot]

Originally Posted by Ralphvd*:

 

Works great! Nice update!

[ImportBot]

Originally Posted by Jamesonp*:

 

Good night!

 

http://open-web-community.com/bf4sta...mmy_style.html

 

It's an image.

 

http://open-web-community.com/bf4sta...php_ServerID=1

 

(not done yet)

Nice! Can't wait.

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked to in first post has been updated!

 

Changes:

- Minor bug fix with counting sessions on the index page and global stats pages

- Added server banner generator for generating server banners for website homepage

 

See Banner Example to see what it looks like and how to use it:

http://open-web-community.com/bf4sta...r/example.html

 

The issue with displaying it as an image is that the data will tend to be outdated because user's browsers will cache the image and display the image as a cached image. But displaying it as an iframe should work great and should be what all of you are used to doing with GameTracker server banners.

[ImportBot]

Originally Posted by Kinsman*:

 

looks great, thanks!

 

http://www.junglewraiths.net/index.p...=Content&pid=3

 

BTW I'm assuming that player 8 and 10 being the same here is a problem with our DB?

 

http://jw.servegame.org/stuff/index.php_globalpotw=1

[ImportBot]

Originally Posted by ty_ger07*:

 

It's grouped by stats id. For some reason that player must have more than one stats id.

[ImportBot]

Originally Posted by Jamesonp*:

 

Looking good ty_ger! Thanks for the banners. Just a few notes:

 

1) Heads up for people running adblock with easylist - banner.php is automatically blocked (it will cause your banners not to display. Fix this by renaming banner.php to serverbanner.php)

 

 

2) Is it possible to change the size of the "Online Players" box height?

[ImportBot]

Originally Posted by ty_ger07*:

 

#2 is a pretty vague question.

[ImportBot]

Originally Posted by Jamesonp*:

 

#2 is a pretty vague question.

Currently it shows about 10 players, lets say I want it to show 20 players. What would I need to change?

[ImportBot]

Originally Posted by ty_ger07*:

 

Currently it shows about 10 players, lets say I want it to show 20 players.  What would I need to change?

For one thing, you increased your font size, so I can't give an exact number of pixels if I don't know what font size you are going to use.

The height of the DIV is here:
Code:

<div class="section"><b>Online Players:</b></div>
<div style="height: 184px; overflow-y: auto; overflow-x: hidden;">

Change height from 184px to what you want.  But then of course you will need to increase your iframe height as well otherwise data will spill off the bottom.

I will upload a new version soon with font size increased from 11px to 12px, current players increased from 10 players to 20 players, and a couple other tiny improvements.

[ImportBot]

Originally Posted by Jamesonp*:

 

For one thing, you increased your font size, so I can't give an exact number of pixels if I don't know what font size you are going to use.

The height of the DIV is here:
Code:

<div class="section"><b>Online Players:</b></div>
<div style="height: 184px; overflow-y: auto; overflow-x: hidden;">

Change height from 184px to what you want.  But then of course you will need to increase your iframe height as well otherwise data will spill off the bottom.

I will upload a new version soon with font size increased from 11px to 12px, current players increased from 10 players to 20 players, and a couple other tiny improvements.

Thanks I figured it out.  I appreciate all the help and your time!

[ImportBot]

Originally Posted by ty_ger07*:

 

Code in first post updated!

 

Changes:

- server banner iframes now shows 20 current players in server instead of 10

- server banner iframe has sql injection threat fix added

- server banner php file name changed to prevent popup blocking

- server banner minor text and formatting changes

[ImportBot]

Originally Posted by Kinsman*:

 

You know, know that you have mastered drawing php images, the next logical extension would be Player and Server Signatures.

 

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

 

Click on a player to get their popup, then click on signatures.

 

BTW can you make players online a variable, or tell me how to make it ten again, theres no way I can use Iframes that long.

 

No matter, I figured it out.

 

http://www.junglewraiths.net/index.p...=Content&pid=3

 

Online and Top 10 should prob both be options, for maximum versatility.

[ImportBot]

Originally Posted by BoneHead1211*:

 

First of all : Nice Work @ ty_ger07

i have made some modifications to show the weapongraphs

Sure it is a cosmetic but it looks nice if you can see the weapon as a picture. Some weapons i have to fix in its name but almost ready ...

You can see it here : http://www.battlefield4you.de/bf4sta...ID=40&search=1

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked to in first post updated:

 

Changes:

- More server banner generator help in example file and an additional option to adjust online player count shown in server banner.

 

For example of changes, see example file:

http://open-web-community.com/bf4sta...r/example.html

 

Note that the fourth example shows how suggested iframe sizes are now given to make your life easier.

[ImportBot]

Originally Posted by ty_ger07*:

 

You know, know that you have mastered drawing php images, the next logical extension would be Player and Server Signatures.

I am not so sure most forums allow you to insert a PHP file in as an image in BBcode. I guess it depends on whether the BBcode searches to see that it does provide an image header with dimensions. If it doesn't look, it will see that it is a PHP file and not even try.

 

Test:

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

 

EDIT:

I guess this vBulletin must support it at least.

 

EDIT2:

It seems ASPPlayground also supports inserting the PHP generated image.

 

I am not sure about phpBB though yet.

 

EDIT3:

The start of a pretty bland (so far) signature image generator:

http://open-web-community.com/bf4stats/player-stats/signature/signature.php_PlayerID=1540

 

http://open-web-community.com/bf4stats/player-stats/signature/signature.php_PlayerID=2

 

Any ideas for better colors?

[ImportBot]

Originally Posted by ty_ger07*:

 

First of all : Nice Work @ ty_ger07

i have made some modifications to show the weapongraphs

Sure it is a cosmetic but it looks nice if you can see the weapon as a picture. Some weapons i have to fix in its name but almost ready ...

You can see it here : http://www.battlefield4you.de/bf4sta...ID=40&search=1

It looks real good. Finding all the weapon images and updating them each expansion pack is what scares me.

[ImportBot]

Originally Posted by Kinsman*:

 

Correct, thats why the files need to be named .png just like EzStats and gametracker do it.

 

Download EzStats here to see how it works.

 

http://sourceforge.net/projects/ezstats3/

 

and here is my sig from EzStats.

 

 

I cant see any reason our own stats cant generate the same?

[ImportBot]

Originally Posted by ty_ger07*:

 

Correct, thats why the files need to be named .png just like EzStats and gametracker do it.

 

Download EzStats here to see how it works.

 

http://sourceforge.net/projects/ezstats3/

 

and here is my sig from EzStats.

 

 

I cant see any reason our own stats cant generate the same?

Because a .png file isn't executable as PHP. It needs to be named .PHP to execute as PHP. Creating a cache of a bunch of .png images -- one for each user -- seems like an inefficient way to proceed.

 

As you can see above, .PHP is embedding fine as an image.

 

Have you tried embedding this image in your forum to see if it works?

 

http://open-web-community.com/bf4sta..._PlayerID=1540

 

It embeds fine here.

 

http://open-web-community.com/bf4stats/player-stats/signature/signature.php_PlayerID=1540

 

I just tried it on phpBB and it works fine in phpBB.

 

http://www.try-phpbb.com/30x/viewtop...f=2&t=1&p=2#p2

 

So, it works on vBulletin, on ASPplayground, and on phpBB. Those are the most popular forums I can think of.