Jump to content

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


tyger07

Recommended Posts

Originally Posted by ty_ger07*:

 

It was working with the first domain.

I deleted that entire site and created a new site.

Followed the instructions which as very simple and added the remotesql permission.

No need for approving website addresses. Just remotesql access needs approving.

I am not sure the reason then. If the database allows remote access without requiring the website host be whitelisted, it should work.
* Restored post. It could be that the author is no longer active.
Link to comment
  • Replies 1.7k
  • Created
  • Last Reply

Originally Posted by ty_ger07*:

 

I don't have any servers rented. Bf3 did it for me in the server renting department.

 

Does anyone have a db extract of a db with second assault data in it for me to use so I can update this code and make sure everything keeps working properly?

 

Thanks!

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

Originally Posted by Jamesonp*:

 

I don't have any servers rented. Bf3 did it for me in the server renting department.

 

Does anyone have a db extract of a db with second assault data in it for me to use so I can update this code and make sure everything keeps working properly?

 

Thanks!

Yea, let me export for you. Do you need the entire db or just specific tables?

 

Edit: I've included the tables I think you need. You can download it here:

 

http://files.precisionclan.com/dbdumps/20140218.zip

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

Originally Posted by JR8355*:

 

I am not sure the reason then. If the database allows remote access without requiring the website host be whitelisted, it should work.

I am the one who he's working with, if you would like, PM me and I can give you some access to see if you can trouble shoot? I love this enhancement and would love to have it working again, thank you ty_ger07

 

I don't have any servers rented. Bf3 did it for me in the server renting department.

 

Does anyone have a db extract of a db with second assault data in it for me to use so I can update this code and make sure everything keeps working properly?

 

Thanks!

I'm running a 24/7 Metro 2014 server
* Restored post. It could be that the author is no longer active.
Link to comment

Originally Posted by ty_ger07*:

 

It's up to you to decide if you trust me with that information.

 

If you do pm me the connection information, I can see if I can connect. And if I can connect, I could download a copy of the db for myself to get SA updates going. Two birds stoned at once so to say.

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

Originally Posted by JR8355*:

 

It's up to you to decide if you trust me with that information.

 

If you do pm me the connection information, I can see if I can connect. And if I can connect, I could download a copy of the db for myself to get SA updates going. Two birds stoned at once so to say.

Hi ty_ger, do you just need the database info or procon or both?
* Restored post. It could be that the author is no longer active.
Link to comment

Originally Posted by ty_ger07*:

 

Hi ty_ger, do you just need the database info or procon or both?

If you wanted me to try to connect to your database remotely, I would just need the database ip address, database port, database username, and database password.
* Restored post. It could be that the author is no longer active.
Link to comment

Originally Posted by ty_ger07*:

 

done, PM sent...

I use HeidiSQL to manage databases remotely.

 

This is the error I get:

Host xxxx[me] is not allowed to connect to this MySQL server

connect_error.jpg

 

It seems that you need to whitelist IP addresses allowed to connect to your database. Perhaps you can ask your database host.

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

Originally Posted by ty_ger07*:

 

Code on GitHub linked to in first post updated!

 

Changes:

- Added Second Assault Maps, Mode, and Weapons

 

 

This update is not fully tested since I do not have a Second Assault database to test with, but it should work given documentation available. Please let me know if there are any errors.

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

Originally Posted by Jamesonp*:

 

This update is not fully tested since I do not have a Second Assault database to test with, but it should work given documentation available. Please let me know if there are any errors.

I linked to one in my previous post one page back.

 

http://files.precisionclan.com/dbdumps/20140218.zip

 

BF4.def has the maps listed as:

 

XP0_Metro

XP0_Caspian

XP0_Oman

XP0_Firestorm

 

So obviously those are missing from the banner folder and cause a 404. I created a map image pack that should work for now until we get some better images:

 

http://files.precisionclan.com/images/sa_map_images.zip

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

Originally Posted by Jamesonp*:

 

Hi ty_ger, do you just need the database info or procon or both?

Hey man,

 

I contacted your admin and provided him with the reason why this is happening. Long story short, your files server is blocked by your database server for too many connection attempts. He or you will need to contact the web host to have them flush the connections.

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

Originally Posted by GR101*:

 

Code on GitHub linked to in first post updated!

 

Changes:

- Added Second Assault Maps, Mode, and Weapons

Thanks for the update.

 

 

Is it possible to have a player trend graph showing the following: Min and Max players on the server and the number of players joined and left the server per round for the last 48 hour period?

 

Also, could you increase the width of graphs?

 

Thanks in advance.

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

Originally Posted by ty_ger07*:

 

I linked to one in my previous post one page back.

 

http://files.precisionclan.com/dbdumps/20140218.zip

 

BF4.def has the maps listed as:

 

XP0_Metro

XP0_Caspian

XP0_Oman

XP0_Firestorm

 

So obviously those are missing from the banner folder and cause a 404. I created a map image pack that should work for now until we get some better images:

 

http://files.precisionclan.com/images/sa_map_images.zip

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

Originally Posted by ty_ger07*:

 

Edit: The pchart folder was writeable by group. xD

I see you edit but don't completely understand. Is it working for you now or not?

 

CptChaos reported the same problems regarding broken images here: myrcon.net/...stats-webpage-for-xpkillers-stats-logger-plugin#entry47469

 

I have extracted a fresh copy of the code to a new folder on my webserver straight from GitHub and it still works fine for me.

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

Originally Posted by ty_ger07*:

 

Code linked to in first post updated!

 

Changes:

- Added missing Second Assault banner images

- Added updated pChart API

 

I added the full (and updated) pChart API. I can not reproduce the issues 2 people have had with charts and hope adding the full unaltered and updated pChart API will help.

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

Originally Posted by Kinsman*:

 

Nevermind. I will just use the information from PRoCon's GitHub to add the map names, team names, and weapon names for Second Assault.

 

https://github.com/Myrcon/Procon-1/b...onfigs/BF4.def

Were there new team and weapon names to add somewhere? I thought they would all come from the DB so only updated the maps.

 

Also if you want a Second Assault DB update give it a few days to collect some updates and I will send one over.

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

Originally Posted by ty_ger07*:

 

Were there new team and weapon names to add somewhere? I thought they would all come from the DB so only updated the maps.

 

Also if you want a Second Assault DB update give it a few days to collect some updates and I will send one over.

Map names were added for map codes in constants.php and I had to verify that capture the flag was in there. Weapon images were added for new weapon names. Map images were added for gametracker-style server banners. Team names for map names and game modes were added to functions.php for the scoreboard.

 

GitHub shows the changes:

 

First change:

https://github.com/tyger07/BF4-Serve...49ac31e23ccad2

 

Second change:

https://github.com/tyger07/BF4-Serve...1dd2b1307240d3

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

Originally Posted by Jaffaman*:

 

Anyone else having a problem where it is not showing the payer names in the server any more but shows the number of players in the server ?

 

UPDATE: someone had turned off Enable Livescoreboard in DB.

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

Originally Posted by Mandizzy*:

 

Hi ty_ger07,

 

Thanks for the latest update. Works like a charm except a small CSS problem probably. It looks fine with default zoom level in all three major browsers but when you zoom in/increase font size, table backgrounds (black) don't resize properly. They used to work fine in last version I used, which was tyger07-BF4-Server-Stats-v1.01-22-g4e5c2cb.zip.

 

http://tocgaming.com/stats/index.php

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

Originally Posted by ty_ger07*:

 

Hi ty_ger07,

 

Thanks for the latest update. Works like a charm except a small CSS problem probably. It looks fine with default zoom level in all three major browsers but when you zoom in/increase font size, table backgrounds (black) don't resize properly. They used to work fine in last version I used, which was tyger07-BF4-Server-Stats-v1.01-22-g4e5c2cb.zip.

 

http://tocgaming.com/stats/index.php

Try playing with 'min-width: 1020px;' and 'width: 75%;' in #pagebody of stats.css.

 

I decreased the width some so it wouldn't be so stretched out of high resolution displays and added min-width for low resolution displays, but I guess it may need some tweaking in your case.

 

 

You can see versions of the file here:

https://github.com/tyger07/BF4-Serve...mmon/stats.css

 

The change from December 19th to January 23rd is probably the change you noticed. You can see in the December 19th code that there was no min-width and the page width was 80%.

 

https://github.com/tyger07/BF4-Serve...mmon/stats.css

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

Originally Posted by ty_ger07*:

 

It was working with the first domain.
I deleted that entire site and created a new site.
Followed the instructions which as very simple and added the remotesql permission.
No need for approving website addresses.  Just remotesql access needs approving.
By PM, I learned these things:

The database is provided by NFO servers.  The website is provided by NFO servers.  The database and website are on different people's accounts.  The database DOES require IP addresses to be whitelisted by the database server for the database to accept the connection.  The website's World Wide Web address was whitelisted, but that didn't help.

I am pretty sure that NFO servers redirects traffic internally between its machines rather than going out to the World Wide Web and then back in.  When they direct traffic between the machine which hosts the website and the machine which hosts the database, almost certainly the machine's internal network IP is different than the machine's World Wide Web IP.  I would ask NFO servers which IP address you should whitelist on your database server to allow it to communicate with your website server.

Hope that helps.

By the way, if you want to see a more detailed error message on the stats page, change this:

Code:
$BF4stats = @mysqli_connect(HOST, USER, PASS, NAME, PORT) or die ("<title>BF4 Player Stats - Error</title></head><body><div id='pagebody'><div id='pagebodyback'><center><b>Unable to access stats database. Please notify this website's administrator.</b></center><center>If you are the administrator, please seek assistance <a href='https://forum.myrcon.com/showthread.php_6854-Server-Stats-page-for-XpKiller-s-BF4-Chat-GUID-Stats-and-Mapstats-Logger' target='_blank'>here</a>.</center></div></div></body></html>");
to this:

Code:
$BF4stats = mysqli_connect(HOST, USER, PASS, NAME, PORT);
in index.php.

That will get rid of the custom error message and display the raw error message instead.  Note: if you get rid of the custom error message, the page will not be XHTML valid when the error message is displayed and the error message text may be more useful to a hacker since it will be more detailed.
* Restored post. It could be that the author is no longer active.
Link to comment

Originally Posted by Kinsman*:

 

Is anybody else having issues where you KNOW there are players in the server, but the livescoreboard does not function? Just wondering if its our DB playing up somehow, or something has changed. our displayservers works, because its custom, but scoreboard is gone. http://jw.servegame.org/bf4stats/index.php I even downloaded the latest code, same problem. http://jw.servegame.org/test/

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

Originally Posted by ty_ger07*:

 

Is anybody else having issues where you KNOW there are players in the server, but the livescoreboard does not function? Just wondering if its our DB playing up somehow, or something has changed. our displayservers works, because its custom, but scoreboard is gone. http://jw.servegame.org/bf4stats/index.php I even downloaded the latest code, same problem. http://jw.servegame.org/test/

AdKats has a bug where it keeps disabling the live scoreboard.
* Restored post. It could be that the author is no longer active.
Link to comment

Originally Posted by audiodk*:

 

Hello I am trying to use your pluggin. My procon is hosted by gameservers and im trying to store the stats on my website. I keep getting this error though when i start the pluggin

 

[13:19:56 66] Error in Tablebuilder:

[13:19:56 66] Message: Host '68.232.167.46' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

[13:19:56 66] Native: -2147467259

[13:19:56 66] Source: MySql.Data

[13:19:56 66] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

at MySql.Data.MySqlClient.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[13:19:56 66] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[13:19:56 72] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Host '68.232.167.46' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

at MySql.Data.MySqlClient.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

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

Originally Posted by ty_ger07*:

 

The error message says "Host '68.232.167.46' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'".

 

BTW, this isn't the correct thread to ask about stats plugin issues. I did not write the plugin.

* 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.




  • 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.
      • 5 replies
    • 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
    • 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
    • I wanted I let you know that I am starting to build out the foundation for the hosting services that I talked about here. The pricing model I was originally going for wasn't going to be suitable for how I want to build it. So instead I decided to offer each service as it's own product instead of a package deal. In the future, hopefully, I will be able to do this and offer discounts to those that choose it.

      Here is how the pricing is laid out for each service as well as information about each. This is as of 7/12/2020.

      Single MySQL database (up to 30 GB) is $10 USD per month.



      If you go over the 30 GB usage for the database then each additional gigabyte is charged at $0.10 USD each billing cycle. If you're under 30GB you don't need to worry about this.


      Databases are replicated across 3 zones (regions) for redundancy. One (1) on the east coast of the USA, One (1) in Frankfurt, and One (1) in Singapore. Depending on the demand, this would grow to more regions.


      Databases will also be backed up daily and retained for 7 days.




      Procon Layer will be $2 USD per month.


      Each layer will only allow one (1) game server connection. The reason behind this is for performance.


      Each layer will also come with all available plugins installed by default. This is to help facilitate faster deployments and get you up and running quickly.


      Each layer will automatically restart if Procon crashes. 


      Each layer will also automatically restart daily at midnight to make sure it stays in tip-top shape.


      Custom plugins can be installed by submitting a support ticket.




      Battlefield Admin Control Panel (BFACP) will be $5 USD per month


      As I am still working on building version 3 of the software, I will be installing the last version I did. Once I complete version 3 it will automatically be upgraded for you.





      All these services will be managed by me so you don't have to worry about the technical side of things to get up and going.

      If you would like to see how much it would cost for the services, I made a calculator that you can use. It can be found here https://ezrcon.com/calculator.html

       
      • 11 replies
    • I have pushed out a new minor release which updates the geodata pull (flags in the playerlisting). This should be way more accurate now. As always, please let me know if any problems show up.

       
      • 9 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.