BF4 Stats Page for \"BF4 PRoCon Chat, GUID, Stats and Mapstats Logger\" [v0.0.3.0]

[ImportBot]

Originally Posted by supermillhouse*:

 

Holder

[ImportBot]

Originally Posted by supermillhouse*:

 

Description:

This is a stats page based on RMG-Dr4k3 BF3 stats page located here:myrcon.net/.../stats-webpage-for-xpkillers-stats-logger-plugin

 

As I am using this project/to learn my way through PHP and MySQL everyone will need to bare with me when faults occur because it is likely I will need to learn how to fix them before I can actually fix them

 

This site uses the live scoreboard and stats collected by XpKiller's BF4 PRoCon Chat, GUID, Stats and Mapstats Logger. Please ensure you have enabled Livescoreboard in the Plugin.

 

Please bare in mind when viewing the test site there is over a years worth of stats in there so the weapon stat page and tabs take ages to load.

 

Demo Here

 

My apologies for the profanities in the chat section

 

Download: Millies_Stats

 

screen1.jpg

 

v0.0.3.0

 

- Remove XP1 Weapon

- Add RAWR

- Add Final Stand Weapons

 

v0.0.2.8

 

- Fix maps.php error

 

v0.0.2.7

 

- Added Dragon's Teeth Weapons

 

v0.0.2.6

 

- Added Dragon's Teeth

- Maps and mode only

- No aditional weapon images at the moment as i don't have the entire list.

 

v0.0.2.3

 

- Added Weapon Stats

 

v0.0.2.1

 

-Added Naval Strike

 

v0.0.1.8

 

- Change page links on players.php

 

v0.0.1.7

 

- Added Second Assault

 

v0.0.1.6

 

- Fix page limit when players were sorted

 

v0.0.1.5

 

- Change to footer note and update messages to work with Adkats

 

v0.0.1.4

 

-Add China Rising maps

 

v0.0.1.3

 

-Added BF4 stats link

 

-Changed index totals to be for current server

 

v0.0.1.0

 

Home page:

-Live server statistic

-Top server statistic

-Clan website

-Server Battlelog site

 

Players Page:

-All players statistics

-Order by all data

-Search player by name

 

Playerstat page:

-All type of ranks

-Kills, Deaths, K/D etc...

-Weapons statistics WIP

-Battlelog profile

 

Maps page:

-List avarage data of maps

-Show map image

 

Weapons

- WIP

 

Messages

-List all messages

-Search chat player or message

[ImportBot]

Originally Posted by XpKiller*:

 

if you need help with the weaponstats query feel free to ask me. :-)

[ImportBot]

Originally Posted by supermillhouse*:

 

Will do, it has been so long since I have done MySQL queries, and even then it was a struggle, I hill have to get my head around the logic again.

[ImportBot]

Originally Posted by Rcon-Admin*:

 

Excellent work, thank you.

Will no doubt be deploying it and testing it within a few hours.

 

Thanks for your work

[ImportBot]

Originally Posted by kcuestag*:

 

Can't wait to get this going!

[ImportBot]

Originally Posted by Kinsman*:

 

Do you plan on updating BF3Conn for the live server details? or just pull them from the DB?

 

Looks great so far, top work. :-)

[ImportBot]

Originally Posted by jking54*:

 

Would this work with rented web sites such as Enjin?

[ImportBot]

Originally Posted by Kinsman*:

 

Heres what it looks like with 5 servers.

 

http://jw.servegame.org/test/index.php

 

I also added a link to bf4stats in the playerstats, which I need a new button for, but added a "title" tag too for now.

 

http://jw.servegame.org/test/playerstat.php_pid=302

[ImportBot]

Originally Posted by Narf!*:

 

Thx Millhouse for sharing this to us.

[ImportBot]

Originally Posted by ZeroKooL*:

 

So after a little playing around i ended up getting this:

 

http://tdsgamers.com/rankmain.php

 

Thanks for sharing all the code.

[ImportBot]

Originally Posted by supermillhouse*:

 

Would this work with rented web sites such as Enjin?

I'm not sure of the function of Enjin, but if you can upload the files to their system and they allow access to a MySQL database that both procon and the webpage can access then I don't see why not. Maybe someone that has some technical knowledge of Enjin coud better clarify.

[ImportBot]

Originally Posted by kcuestag*:

 

Ignore this message, I noticed everything was in the plugin.

[ImportBot]

Originally Posted by supermillhouse*:

 

Do you plan on updating BF3Conn for the live server details? or just pull them from the DB?

 

Looks great so far, top work. :-)

I have no plans to implement the direct fetch as a lot of web hosts don't allow the connection, or enable the use of fsockopen().

 

What information would you like that is not currently accessible from the plugin database, recent addition to the plugin is team ticket count?

[ImportBot]

Originally Posted by Kinsman*:

 

The database is fine, I was just curious.

[ImportBot]

Originally Posted by kcuestag*:

 

Ticket count and Commander Slots would be nice.

 

Also I'd love if we could have the Admin messages (When you write a message from Procon's chat tab) but disable all others from plugins/admins, not quite sure if that's possible.

 

Edit:

 

I forgot, weapon stats too! Although not sure if that's possible with current status of plugin? Correct me if I'm wrong, I have no idea.

[ImportBot]

Originally Posted by xT_norbyg570_Tx*:

 

can anybody tell how i can install this? the logger with mysql is running but i dont know how to install this.

[ImportBot]

Originally Posted by Porthos1973*:

 

Got it installed but the link back to my clan site doesn't work. http://2abrigade.branspace.com/conqstats/index.php link for clan site should take me back to 2abrigade.com but goes to http://2abrigade.branspace.com/conqs....2abrigade.com

[ImportBot]

Originally Posted by ZeroKooL*:

 

Got it installed but the link back to my clan site doesn't work. http://2abrigade.branspace.com/conqstats/index.php link for clan site should take me back to 2abrigade.com but goes to http://2abrigade.branspace.com/conqs....2abrigade.com

Open database.php and have a look at what is on line 21.

[ImportBot]

Originally Posted by xT_norbyg570_Tx*:

 

Could anybody help me? i m a totaly noob in mysql and php ...... only the stats logger is running, but were and how i have to install the web stats ?

[ImportBot]

Originally Posted by Porthos1973*:

 

Open database.php and have a look at what is on line 21.

define("CWEBSITE", "www.2abrigade.com");

[ImportBot]

Originally Posted by WoFNuLL*:

 

Hi there I'm running in some installation problems:

 

Webserver / MYSQL host is a Linux based Dedicated Machine with PHP 5.3 Everytime i try to setup the script via the installer it says that not enough rights were given to create the config. Well all Files and folders have 777 rights on this installation.

 

Even if i go and tear down the installer php and create the database.php manually and put it in place -> i get a blank page.

[ImportBot]

Originally Posted by supermillhouse*:

 

Hi there I'm running in some installation problems:

 

Webserver / MYSQL host is a Linux based Dedicated Machine with PHP 5.3 Everytime i try to setup the script via the installer it says that not enough rights were given to create the config. Well all Files and folders have 777 rights on this installation.

 

Even if i go and tear down the installer php and create the database.php manually and put it in place -> i get a blank page.

Here is a blank database file http://download.supermillhouse.co.uk/WebStats/database.zip

 

Permissions on mine are only 644

not too sure what to suggest.

[ImportBot]

Originally Posted by kaytan*:

 

define("CWEBSITE", "www.2abrigade.com");

I had the same problem today. You must put http:// in front of www....

[ImportBot]

Originally Posted by supermillhouse*:

 

Heres what it looks like with 5 servers.

 

http://jw.servegame.org/test/index.php

 

I also added a link to bf4stats in the playerstats, which I need a new button for, but added a "title" tag too for now.

 

http://jw.servegame.org/test/playerstat.php_pid=302

bf4stats.png

Will add it in to the standard one at some point, thanx for the idea.

[ImportBot]

Originally Posted by ty_ger07*:

 

This should help you with weapon stats:

 

myrcon.net/...server-stats-page-for-xpkillers-bf3-chat-guid-stats-and-mapstats-logger#entry23488

 

SELECT tws.Friendlyname, wa.Kills, wa.Headshots

FROM tbl_weapons_stats wa

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

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

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

WHERE tsp.ServerID = '$server_ID'

AND tpd.SoldierName = '$ThisPlayerName'

AND tws.Damagetype = '$damagetype'

AND wa.Kills > '0'

You can remove the "AND wa.Kills > '0'" portion if you want to display weapons with 0 kills also.

You can use "AND tpd.PlayerID = '$thisID'" instead of "tpd.SoldierName = '$ThisPlayerName'" if you want to find the player based on player id instead of soldier name.

You can remove "AND tws.Damagetype = '$damagetype'" if you want to display all weapons instead of just a category of weapons.

Also of course you could add things like "SELECT tws.Friendlyname, wa.Kills, wa.Deaths, wa.Headshots" (include "wa.Deaths") if you want to add deaths or any other columns.

 

[ImportBot]

Originally Posted by XpKiller*:

 

An alternative which returns all weapons:

 

Code:

SELECT 
    tws.Friendlyname,
    tws.Damagetype,
    coalesce(wa.Kills, 0) AS Kills,
    coalesce(wa.Headshots, 0) AS Headshots
FROM
    tbl_weapons tws
        LEFT JOIN
    tbl_weapons_stats wa ON tws.WeaponID = wa.WeaponID
        AND wa.StatsID = (SELECT 
            tsp.StatsID
        FROM
            tbl_server_player tsp
                INNER JOIN
            tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
                AND tpd.SoldierName = 'playername'
                AND tsp.ServerID = 1);

edit:

i guess there is a way to keep the subquery out. But it shouldnt make a big performance difference.

[ImportBot]

Originally Posted by supermillhouse*:

 

Thank you very much for this start, I probably won't get round to understanding all this for another couple of weeks, get some gaming in and some head scratching, it's a pity that EA/DICE don't provide vehicle reports.

[ImportBot]

Originally Posted by Talzac*:

 

Thanks for this! But I am not so good at PHP, how can I limit the number of players showing?

[ImportBot]

Originally Posted by supermillhouse*:

 

Thanks for this! But I am not so good at PHP, how can I limit the number of players showing?

Clarify, on what page and what exactly?