Jump to content

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


ImportBot

Recommended Posts

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 post
  • Replies 169
  • Created
  • Last Reply

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.

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

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

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

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 post

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 post

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 post

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 post

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 ?

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

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 post

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 post

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 post

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 post

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 post

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 post

Archived

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


  • Our picks

    • Game Server Hosting:

      We're happy to announce that EZRCON will branch out into the game server provider scene. This is a big step for us so please having patience if something doesn't go right in this area. Now, what makes us different compared to other providers? Well, we're going with the idea of having a scaleable server hosting and providing more control in how you set up your server. For example, in Minecraft, you have the ability to control how many CPU cores you wish your server to have access to, how much RAM you want to use, how much disk space you want to use. This type of control can't be offered in a single service package so you're able to configure a custom package the way you want it.

      You can see all the available games here. Currently, we have the following games available.

      Valheim (From $1.50 USD)


      Rust (From $3.20 USD)


      Minecraft (Basic) (From $4.00 USD)


      Call of Duty 4X (From $7.00 USD)


      OpenTTD (From $4.00 USD)


      Squad (From $9.00 USD)


      Insurgency: Sandstorm (From $6.40 USD)


      Changes to US-East:

      Starting in January 2022, we will be moving to a different provider that has better support, better infrastructure, and better connectivity. We've noticed that the connection/routes to this location are not ideal and it's been hard getting support to correct this. Our contract for our two servers ends in March/April respectively. If you currently have servers in this location you will be migrated over to the new provider. We'll have more details when the time comes closer to January. The new location for this change will be based out of Atlanta, GA. If you have any questions/concerns please open a ticket and we'll do our best to answer them.
      • 1 reply
    • Hello All,

      I wanted to give an update to how EZRCON is doing. As of today we have 56 active customers using the services offered. I'm glad its doing so well and it hasn't been 1 year yet. To those that have services with EZRCON, I hope the service is doing well and if not please let us know so that we can improve it where possible. We've done quite a few changes behind the scenes to improve the performance hopefully. 

      We'll be launching a new location for hosting procon layers in either Los Angeles, USA or Chicago, IL. Still being decided on where the placement should be but these two locations are not set in stone yet. We would like to get feedback on where we should have a new location for hosting the Procon Layers, which you can do by replying to this topic. A poll will be created where people can vote on which location they would like to see.

      We're also looking for some suggestions on what else you would like to see for hosting provider options. So please let us know your thoughts on this matter.
      • 4 replies
    • Hi All,

      So seeing as Venice Unleased is released, I'm looking into if I should offer game hosting for it. I would like some feedback on this subject.

      VU - Experience Battlefield 3 like never before! (veniceunleashed.net)
      • 3 replies
    • So as the topic title says, should EZRCON offer general web hosting services?
      • 1 reply
    • Added ability to disable the new API check for player country info


      Updated GeoIP database file


      Removed usage sending stats


      Added EZRCON ad banner



      If you are upgrading then you may need to add these two lines to your existing installation in the file procon.cfg. To enable these options just change False to True.

      procon.private.options.UseGeoIpFileOnly False
      procon.private.options.BlockRssFeedNews False



       
      • 2 replies
×
×
  • 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.