Jump to content

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

ImportBot

By ImportBot
in Plugin Enhancements

Recommended Posts

  • Replies 169
  • Created
  • Last Reply
ImportBot Advanced Member

ImportBot

Posted
Posted

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 :biggrin:

 

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 :tongue:

 

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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. :biggrin:

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

 

:ohmy:

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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. :sad:

* Restored post. It could be that the author is no longer active.
Link to comment

Archived

This topic is now archived and is closed to further replies.

Go to topic listing


×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.