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

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi Ty_ger,

 

My webhost just closed down my website with this comment,

 

 

 

Is it the live scoreboard that makes that many queries?

Is there a way to change this?

 

Kind regards

I wonder what the rate is. 600,000 queries in an hour? In a day? In a month? In a year? In the lifetime of the account?

 

My opinion is that it is quite unlikely that my stats page caused the issue. It is quite unlikely that you have driven that much internet traffic to your stats pages. I would guess that the really heavy user of the stats database is XpKiller's plugin running on PRoCon since his plugin is constantly using the database when players are in your server(s).

 

Any options you disable in XpKiller's plugin will decrease database use. The scoreboard, map stats, session stats, and chat log seem like the items you could disable and probably not care too much that the information is no longer available. Indirectly, any options you disable in XpKiller's plugin will also decrease the amount my stats page uses the database.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

It's 600000 queries in about 20 days.

The database isn't that big because i empty it every month.

Is there a way of knowing how many queries the stats page does?

 

greetings,

[ImportBot]

Originally Posted by ty_ger07*:

 

It's 600000 queries in about 20 days.

The database isn't that big because i empty it every month.

Is there a way of knowing how many queries the stats page does?

 

greetings,

You could count up all the times you find 'mysqli_query' in my code, but that won't tell you much because it won't tell you which ones are fast and which ones are slow. Really, they should all be fast. I think it is highly unlikely that my stats page code triggered the issue. It is very unlikely that you have hundreds of thousands of stats page viewers. Like I said, I would say with quite a lot of confidence that XpKiller's plugin and in-game stats requests and updates are the heavy database users.

 

Are there any specific pages which say at the bottom 'server compiled page in...' greater than 1 seconds? And which pages are the highest? That would help me narrow it down.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

I understand your point of view. The only facts at the moment are that my provider closes down the website and not the mysql server.

The only code on the site is the stats page.

I will try to get more info on what queries and how many are produced in witch period of time.

Don't understand me wrong, I love your page and many of my server players love it to

 

greetz

[ImportBot]

Originally Posted by ty_ger07*:

 

I understand your point of view. The only facts at the moment are that my provider closes down the website and not the mysql server.

The only code on the site is the stats page.

I will try to get more info on what queries and how many are produced in witch period of time.

Don't understand me wrong, I love your page and many of my server players love it to

 

greetz

Surely my stats page will place additional load to the database, so I will not claim that it won't. It may have helped in reaching the trigger, but I doubt it is the prime contributor. I presume that your host did not consider that you have other tools remotely accessing the database and that they may have assumed that by shutting down the website that they were also stopping load on the database at the same time; I think they may be surprised to see that the database load remains high after shutting down your website.

[ImportBot]

Originally Posted by Canoni*:

 

When new weapon stats comes out ?

[ImportBot]

Originally Posted by ty_ger07*:

 

When new weapon stats comes out ?

You mean Naval Strike weapons? Or what do you mean?

 

Weapons populate the database automatically based on Procon's bf4.def file. When Procon is updated with new weapons, the database adds thenew weapons automatically.

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't have much time at the moment, but I would like to add tabbed out weapon categories to the player stats page, do something about the dog tag stats to make it not such a long boring mess, and do something about the home page to split up the scoreboard and top players. I would hope to do these things around the time of the release of Naval Strike.

 

Making this stats page compatible with BC2 was hopeless. Making this stats page compatible with BF3 is still a possibility but it doesn't seem like there is any demand.

 

I would like to add vehicle stats to the weapon stats, but so far no one has given me an updated copy of a BF4 database to work off of.

[ImportBot]

Originally Posted by commandotimmy*:

 

what does this error mean?

 

The game 'BF4' was not found in this database! Please notify this website's administrator

 

I have been chasing this for awhile now and cant figure out what I am doing wrong. I have plugin active in procon. the DB is up and running. the DB is localhost so there should be no issue with the page accessing it.?

[ImportBot]

Originally Posted by GR101*:

 

do something about the dog tag stats to make it not such a long boring mess

Please don't remove the current dog tag feature from your stats webpage because our Platoon is all about 'dog tags' and collecting them wherever possible, let's face it, it's more of a challenge to get dog tags during a normal game than kill somebody with a 320. That dog tag section is our trophy wall,

 

Server total dog tags collected 20717

[ImportBot]

Originally Posted by ty_ger07*:

 

Please don't remove the current dog tag feature from your stats webpage because our Platoon is all about 'dog tags' and collecting them wherever possible, let's face it, it's more of a challenge to get dog tags during a normal game than kill somebody with a 320. That dog tag section is our trophy wall,

 

Server total dog tags collected 20717

I wouldn't get rid of it. I just want to make it not take up so much space by default. I was thinking of making three tabs in that section: tog tag summary (listing totals), dog tags collected (list of names), and dog tags lost(list of names).

[ImportBot]

Originally Posted by GR101*:

 

I wouldn't get rid of it. I just want to make it not take up so much space by default. I was thinking of making three tabs in that section: tog tag summary (listing totals), dog tags collected (list of names), and dog tags lost(list of names).

Thanks for that.

 

I've found one bug since the recent BF4 update (Increased the maximum rank to 120), stats image for players with rank greater than 100 doesn't appear to generate them, whereas 100 or less work fine.

[ImportBot]

Originally Posted by ty_ger07*:

 

Thanks for that.

 

I've found one bug since the recent BF4 update (Increased the maximum rank to 120), stats image for players with rank greater than 100 doesn't appear to generate them, whereas 100 or less work fine.

Yes, I know. I have uploaded the rank images through 120 to Github a couple days ago.

 

https://github.com/tyger07/BF4-Serve...r/images/ranks

 

You can copy the higher rank images to your stats page. I didn't make a formal announcement because I was hoping to have a more significant update ready sometime soon.

[ImportBot]

Originally Posted by Ente*:

 

I just installed you awesome site on our hp - works like a charm. I just have a little problem - as I did start the logging of our servers all at once - the servers our now not listed according to their number. Is there any way to change the sorting on the startpage? Link

[ImportBot]

Originally Posted by ty_ger07*:

 

I just installed you awesome site on our hp - works like a charm. I just have a little problem - as I did start the logging of our servers all at once - the servers our now not listed according to their number. Is there any way to change the sorting on the startpage? Link

Not really, no. I mean, you could change the server IDs in your database if you stopped procon and changed all the right things.

[ImportBot]

Originally Posted by Ente*:

 

Wont work - because of the relationship between the server id and the stats.

I would need to change the sorting order in the sql-query your script does - but thats obviously not intended.

 

Or start from scratch...

[ImportBot]

Originally Posted by ty_ger07*:

 

Wont work - because of the relationship between the server id and the stats.

I would need to change the sorting order in the sql-query your script does - but thats obviously not intended.

 

Or start from scratch...

If you change all the server IDs everywhere, it would work. Lots of things to change though as you say.

 

Or you could rename your servers in the order of their server ids.

 

Or you could delete all the data and start over; this time starting XPKiller's plugin one server at a time in the same order as the number in the server's name.

[ImportBot]

Originally Posted by ty_ger07*:

 

Things I want to change:

 

Add naval strike.

Add tabs to organize large fields of text and long tables better.

Add ashyncronous queries to speed up page loading so query is only executed when respective tab is selected.

 

But...

 

I feel like there may be a better stats page already being created by another user.

myrcon.net/.../bf4-stats-page-for-bf4-procon-chat-guid-stats-and-mapstats-logger

[ImportBot]

Originally Posted by ty_ger07*:

 

If you change all the server IDs everywhere, it would work. Lots of things to change though as you say.

 

Or you could rename your servers in the order of their server ids.

 

Or you could delete all the data and start over; this time starting XPKiller's plugin one server at a time in the same order as the number in the server's name.

Another option:

 

Since my code just selects the servers in the order they are in the database (row 1, row 2, row 3,...), you could stop the plugin or layer and then re-order the rows in the database by editing their content.

[ImportBot]

Originally Posted by brym*:

 

How do I add extra servers?

[ImportBot]

Originally Posted by ty_ger07*:

 

How do I add extra servers?

It finds all the servers in the database automatically.

 

If you have your servers in different databases, you will have to use different stats pages in different directories.

[ImportBot]

Originally Posted by brym*:

 

It finds all the servers in the database automatically.

 

If you have your servers in different databases, you will have to use different stats pages in different directories.

Hi ty_ger07. Thanks for your quick reply. Only one server is being listed. I should add I'm only helping set things up for a friend's clan. Two separate servers / IP's. Will I need to add the other server details to the plugin?

[ImportBot]

Originally Posted by Ente*:

 

Just changed your "select" for the servers to order by name - simply as that

SELECT `ServerID`

FROM `tbl_server`

WHERE `GameID` = {$GameID}

ORDER BY `ServerName` ASC

[ImportBot]

Originally Posted by ty_ger07*:

 

Just changed your "select" for the servers to order by name - simply as that

SELECT `ServerID`

FROM `tbl_server`

WHERE `GameID` = {$GameID}

ORDER BY `ServerName` ASC

I guess that would work well in your case since the first differences in the server name string are the server number.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi ty_ger07. Thanks for your quick reply. Only one server is being listed. I should add I'm only helping set things up for a friend's clan. Two separate servers / IP's. Will I need to add the other server details to the plugin?

It depends on how your friend's clan has set up their system. If they have created two databases with one server in each database, you will have to create two stats pages in different directories with one stats page connecting to one database address and one stats page connecting to the other database address (since the two databases will be at different addresses). If they are saving both servers to the same database, there is nothing you have to change since the webpage stats code will find both servers automatically in the database and will display both servers.

[ImportBot]

Originally Posted by brym*:

 

Just changed your "select" for the servers to order by name - simply as that

SELECT `ServerID`

FROM `tbl_server`

WHERE `GameID` = {$GameID}

ORDER BY `ServerName` ASC

That is a simple edit, thanks! Which file do I apply it to please? I applied this to index.php at line: 74, but it made no change.

 

It depends on how your friend's clan has set up their system. If they have created two databases with one server in each database, you will have to create two stats pages in different directories with one stats page connecting to one database address and one stats page connecting to the other database address (since the two databases will be at different addresses). If they are saving both servers to the same database, there is nothing you have to change since the webpage stats code will find both servers automatically in the database and will display both servers.

They intend to use the same database. But only one server gets listed.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Hi ty_ger07,

 

Is it possible to make a page that lists the top 10 of players with the most kills of a specified weapon.

 

Something like if you choose knife it lists the top10 players with most knife kills.

 

Greetings,

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi ty_ger07,

 

Is it possible to make a page that lists the top 10 of players with the most kills of a specified weapon.

 

Something like if you choose knife it lists the top10 players with most knife kills.

 

Greetings,

Yes, and I am working on such things at the moment.

[ImportBot]

Originally Posted by ty_ger07*:

 

In progress...

 

Asynchronous data transactions:

(chat search) http://open-web-community.com/bf4sta...dex.php_P=Chat

(country tabs) http://open-web-community.com/bf4sta...hp_P=Countries

 

Naval Strike

 

... more still in progress

[ImportBot]

Originally Posted by brym*:

 

Hi guys. Would still like to know where I am to make the suggested edits. As described above, I made them to index.php, but the 2nd server did not get listed. Would appreciate any further pointers. Thanks.