Jump to content

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

tyger07

By tyger07
in Plugin Enhancements

Recommended Posts

  • Replies 1.7k
  • Created
  • Last Reply
ImportBot Advanced Member

ImportBot

Posted
Posted

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.

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

ImportBot

Posted
Posted

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

ImportBot

Posted
Posted

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

ImportBot

Posted
Posted

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.

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

ImportBot

Posted
Posted

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.

 

Posted Image

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

ImportBot

Posted
Posted

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

ImportBot

Posted
Posted

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

ImportBot

Posted
Posted

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.

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

ImportBot

Posted
Posted

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.

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

ImportBot

Posted
Posted

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

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

ImportBot

Posted
Posted

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()

"

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

ImportBot

Posted
Posted

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.

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

ImportBot

Posted
Posted

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

ImportBot

Posted
Posted

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

ImportBot

Posted
Posted

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/

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