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

[ImportBot]

Originally Posted by CptChaos*:

 

Ty_Ger07, thanks for releasing the code on github! I can't wait to do my additions!

[ImportBot]

Originally Posted by ty_ger07*:

 

I can't wait either to see what you do.

[ImportBot]

Originally Posted by CptChaos*:

 

I'm still busy with my maplog.php, with graphs and such, so mine addition will take a while, because I don't have plenty time...

[ImportBot]

Originally Posted by bFe*:

 

I have a problem, the stats aren't showing up as they should

 

In the front page i see Current Players as 0, even if there are people playing.

On the individual servers, only Rounds Played are working, the rest(kills, deaths etc) are 0.

And when I click to view someones stats, i get this.

 

Score Kills Killstreak Kill/Death Ratio

5/100 5/100 5/100 5/100

 

etc..

 

Any tips?

I have seven servers running in the same DB.

[ImportBot]

Originally Posted by lordicon*:

 

I have a problem, the stats aren't showing up as they should

 

In the front page i see Current Players as 0, even if there are people playing.

On the individual servers, only Rounds Played are working, the rest(kills, deaths etc) are 0.

And when I click to view someones stats, i get this.

 

Score Kills Killstreak Kill/Death Ratio

5/100 5/100 5/100 5/100

 

etc..

 

Any tips?

I have seven servers running in the same DB.

When I first set it up it took a few rounds before the stats started to show up.

[ImportBot]

Originally Posted by ty_ger07*:

 

I have a problem, the stats aren't showing up as they should

 

In the front page i see Current Players as 0, even if there are people playing.

On the individual servers, only Rounds Played are working, the rest(kills, deaths etc) are 0.

And when I click to view someones stats, i get this.

 

Score Kills Killstreak Kill/Death Ratio

5/100 5/100 5/100 5/100

 

etc..

 

Any tips?

I have seven servers running in the same DB.

Are you using table suffixes? Did you enter the correct server ids in each stats page and main stats page? Can you provide a link?

[ImportBot]

Originally Posted by ty_ger07*:

 

What if there was not a separate index? What if there was only one stats page file which appeared as an index until a server was selected? This file could automatically find all available servers in the database and display them in an index. Then when you selected a server, a variable would be added to the url query string to load the same stats page file but display all the data only for that selected server.

[ImportBot]

Originally Posted by bFe*:

 

I'm currently hosting it on localhost until i have everything straightened out, then ill move it.

I'm not using table suffixes no, and the server IDs are correct.

 

This is how the DB looks like.

 

[ImportBot]

Originally Posted by ty_ger07*:

 

You have filled in the information in commom/common.php and the information in serverstats.php?

[ImportBot]

Originally Posted by Pvtjohntowle*:

 

what would be a neat addition would arrows indicating progression or regression in the various stats. ie up or down

 

Sent from my GT-I9300 using Tapatalk

[ImportBot]

Originally Posted by ty_ger07*:

 

what would be a neat addition would arrows indicating progression or regression in the various stats. ie up or down

 

Sent from my GT-I9300 using Tapatalk

The database doesn't have timestamps for kill events and therefore it isn't possible to know if their is progression or regression without creating an additional table and additional processor hungry code to track each player on a certain schedule.

[ImportBot]

Originally Posted by bFe*:

 

I sent you a PM containing the files for the site, and a backup of the database.

If you would check it out, that would be great.

[ImportBot]

Originally Posted by lordicon*:

 

I changed mine up a bit so players can also find a user easy and add them to their own friends list. its a simple edit that adds a link for each person currently on the server to their battlelog so they can be added as a friend without having to type in their name and search for them.

 

Around lines 650-654 Change this.

Code:

echo'
<th width="10%" style="text-align:left">Score</th>
<th width="10%" style="text-align:left">Kills</th>
<th width="10%" style="text-align:left">Deaths</th>
<th width="14%" style="text-align:left">Squad</th>
';

To This

Code:

echo'
<th width="10%" style="text-align:left">Score</th>
<th width="10%" style="text-align:left">Kills</th>
<th width="10%" style="text-align:left">Deaths</th>
<th width="14%" style="text-align:left">Squad</th>
<th width="14%" style="text-align:left">Friend</th>
';

Around lines 693-697 Change this.

Code:

echo '
<td class="tablecontents" width="10%" style="text-align:left">' . $score . '</td>
<td class="tablecontents" width="10%" style="text-align:left">' . $kills . '</td>
<td class="tablecontents" width="10%" style="text-align:left">' . $deaths . '</td>
<td class="tablecontents" width="14%" style="text-align:left">' . $squad_name . '</td>
';

To this.

Code:

echo '
<td class="tablecontents" width="10%" style="text-align:left">' . $score . '</td>
<td class="tablecontents" width="10%" style="text-align:left">' . $kills . '</td>
<td class="tablecontents" width="10%" style="text-align:left">' . $deaths . '</td>
<td class="tablecontents" width="14%" style="text-align:left">' . $squad_name . '</td>
<td class="tablecontents" width="14%" style="text-align:left"><a href="http://battlelog.battlefield.com/bf4/user/' . $player . '/" target="_blank"><font size="2">Add</font></a></td>
';

[ImportBot]

Originally Posted by lordicon*:

 

Hello all Join my server thanks

ROFL This is not a site to request people to join your server, a lot of people check for new servers on sites liek gametracker.com

[ImportBot]

Originally Posted by Jaffaman*:

 

Hi i notice that on one of your servers the chat has stopped logging http://open-web-community.com/bf4sta....php_chat=View we have had the same problem http://grimreapers.co.uk/Serverstats....php_chat=View is this dut to the updated code or the plugin ?

Thanks inadvance Jaffaman.

[ImportBot]

Originally Posted by Kinsman*:

 

Thanks, finally got around to updating, also added the "Add" link to the top 25.

 

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

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi i notice that on one of your servers the chat has stopped logging http://open-web-community.com/bf4sta....php_chat=View we have had the same problem http://grimreapers.co.uk/Serverstats....php_chat=View is this dut to the updated code or the plugin ?

Thanks inadvance Jaffaman.

I don't have a BF4 server. The demo pages use a dummy database which is not live. That's why the chat has 'stopped' in the demo pages. (that is the date of the dummy data when it was given to me)

 

I would say your problem is likely that your plugin isn't working properly or xpkiller changed the way the chat logging works recently. I don't have time to ask xpkiller or look through his changelog, but maybe you can ask him.

 

Make sure chat logging is still enabled in your plugin of course.

[ImportBot]

Originally Posted by Kinsman*:

 

added some more info to the index.

 

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

[ImportBot]

Originally Posted by Kinsman*:

 

Heres a request as I have no idea how to do it. Would it be possible to add an Overall Ranks Block to the Index. In other words the Ranks you see here.

 

http://jw.servegame.org/bf4stats/ser..._player=Search

 

But on the index as a Top 10 across all servers?

 

I notice the Plugin creates a playerranks table too, but unsure what thats for.

 

I've updated the sql for you with all 5 servers full and a tonne more stats.

 

www.jw.servegame.org/downloads/stats2.zip

[ImportBot]

Originally Posted by Porthos1973*:

 

Working on a e107 plugin, with a sidebar menu:

 

 

And the index:

 

 

This is great!

When you release this will it work on evo extreme?

[ImportBot]

Originally Posted by Jaffaman*:

 

Thanks for getting back to me i will try and find out what's happened to make the chat logging.

[ImportBot]

Originally Posted by bFe*:

 

I deleted the database and tried to start from scratch.

The plugin isn't writing to tbl_server ..anyone know how I can fix this?

Now all I get is this:

 

"[17:08:12 14] PRoCon Chat, GUID and Stats Logger Enabled

[17:08:12 14] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[17:11:14 30] [statslogger]Error: Error in Startstreaming:

[17:11:14 31] Message: Cannot add or update a child row: a foreign key constraint fails (`fbf_arma2b`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[17:11:14 31] Native: -2147467259

[17:11:14 31] Source: MySql.Data

[17:11:14 31] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

"

[ImportBot]

Originally Posted by XpKiller*:

 

did you restart the layer after deleting the database?

 

It is possible that this is a caching issue. The stats plugin cache some data to reduce the number required of sql queries.

[ImportBot]

Originally Posted by bFe*:

 

Ah, didn't think of that.

Ill try, thanks!

[ImportBot]

Originally Posted by Kinsman*:

 

I deleted the database and tried to start from scratch.

The plugin isn't writing to tbl_server ..anyone know how I can fix this?

Now all I get is this:

 

"[17:08:12 14] PRoCon Chat, GUID and Stats Logger Enabled

[17:08:12 14] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[17:11:14 30] [statslogger]Error: Error in Startstreaming:

[17:11:14 31] Message: Cannot add or update a child row: a foreign key constraint fails (`fbf_arma2b`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

"

What is 'fbf_arma2b' ? you sure that belongs in your DB?

[ImportBot]

Originally Posted by joh93*:

 

Thanks, finally got around to updating, also added the "Add" link to the top 25.

 

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

It's possible you share your file for this updating?

thanks!

[ImportBot]

Originally Posted by joh93*:

 

Thanks, finally got around to updating, also added the "Add" link to the top 25.

 

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

It's possible you share you files for this updating?

Thanks!

[ImportBot]

Originally Posted by joh93*:

 

thx men for this plugin!!

It's possible to add colonn with "score by minute" ?

[ImportBot]

Originally Posted by ty_ger07*:

 

thx men for this plugin!!

It's possible to add colonn with "score by minute" ?

It is possible, yes, but I find that the SPM data provided is not always accurate or reliable depending on when the plugin notices player joins/leaves and pre-round warmup, therefore I excluded the data.

[ImportBot]

Originally Posted by bFe*:

 

What is 'fbf_arma2b' ? you sure that belongs in your DB?

Thats just the database name, used a spare one I had for DayZ.

And it worked XpKiller, restarting the layer.

 

Now here comes the fun part again, some of the stats wont show up - like kills, total deaths, K/D, headshots etc. Its all at 0.

 

http://bf4stats.battlefield.no/