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

[ImportBot]

Originally Posted by t0p8uzz*:

 

If you don't want to wait, here's how to update it for the Second Assault Maps

 

1) Download images from here =

 

http://files.bf4stats.com/img/bf4/ma..._firestorm.jpg

http://files.bf4stats.com/img/bf4/ma.xp0_metro.jpg

http://files.bf4stats.com/img/bf4/ma...m/xp0_oman.jpg

http://files.bf4stats.com/img/bf4/ma...p0_caspian.jpg

 

2) Uploads maps to /maps/

3) Open config/config.php and find line 73 and add the following 4 lines to the bottom of the map list:

 

case "XP0_Caspian": $sname="Caspian Border 2014"; $simage="xp0_caspian"; break;

case "XP0_Firestorm": $sname="Operation Firestorm 2014"; $simage="xp0_firestorm"; break;

case "XP0_Oman": $sname="Gulf of Oman 2014"; $simage="xp0_oman"; break;

case "XP0_Metro": $sname="Operation Metro 2014"; $simage="xp0_metro"; break;

4) Save and upload

[ImportBot]

Originally Posted by kcuestag*:

 

I'm not an expert when it comes to editing these files so I'll wait for supermillhouse to release the new version.

[ImportBot]

Originally Posted by t0p8uzz*:

 

Doesnt really require any kind of expertise, if you can type in Word or Notepad then you're more than skilled enough to Copy & Paste the lines provided above and upload it. Should take you 2 mins tops

[ImportBot]

Originally Posted by supermillhouse*:

 

Updated to:

 

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

[ImportBot]

Originally Posted by kcuestag*:

 

Download link still shows 0.0.1.4, is that still correct?

[ImportBot]

Originally Posted by supermillhouse*:

 

Download link still shows 0.0.1.4, is that still correct?

Removed version from link, just using post to track versions and updated heading.

[ImportBot]

Originally Posted by kcuestag*:

 

Thanks!

 

By the way, what Messages do you mean for AdKats in 0.0.1.5?

[ImportBot]

Originally Posted by supermillhouse*:

 

Thanks!

 

By the way, what Messages do you mean for AdKats in 0.0.1.5?

It was the chat messages on messages.php and index.php. Were yours ok? Moli87 chat messages were all screwed up. They are now referenced by column name instead of number as I believe adkats inserts a new column in the middle some ware.

[ImportBot]

Originally Posted by kcuestag*:

 

It was the chat messages on messages.php and index.php. Were yours ok? Moli87 chat messages were all screwed up. They are now referenced by column name instead of number as I believe adkats inserts a new column in the middle some ware.

That was fixed with AdKats 4.0.0.0.

 

Here's mine with AdKats 4.1.0.0 and webstats v0.0.1.4:

 

http://oaksclan.view-your-stats.com/

[ImportBot]

Originally Posted by supermillhouse*:

 

That was fixed with AdKats 4.0.0.0.

 

Here's mine with AdKats 4.1.0.0 and webstats v0.0.1.4:

 

http://oaksclan.view-your-stats.com/

A ok, it is better to have been changed anyway let me know if there are any problems, I will add them to the list of fixes and get to them at some point.

[ImportBot]

Originally Posted by kcuestag*:

 

A ok, it is better to have been changed anyway let me know if there are any problems, I will add them to the list of fixes and get to them at some point.

Ok, I should update it to v0.0.1.7 in a few hours.

[ImportBot]

Originally Posted by kcuestag*:

 

A ok, it is better to have been changed anyway let me know if there are any problems, I will add them to the list of fixes and get to them at some point.

Just updated:

 

http://oaksclan.view-your-stats.com/

 

All looking good.

[ImportBot]

Originally Posted by supermillhouse*:

 

v0.0.1.8

 

- Change page links on players.php

[ImportBot]

Originally Posted by kcuestag*:

 

v0.0.1.8

 

- Change page links on players.php

Thanks!

 

By the way, are you planning on adding a Weapons page like in Battlefield 3? I am kind of missing that feature from the web stats.

[ImportBot]

Originally Posted by supermillhouse*:

 

Yes at some point, I would like to change from how it was originally done so it will be possible to sort the results but I will have to learn how to do this. I think it is within my capabilities and understanding of php but I will have to set aside some time to do it. Unfortunately the database stores the data slightly differently to how it did in bf3 so it was not possible to just use that one

 

 

Sent from my iPad using Tapatalk

[ImportBot]

Originally Posted by kcuestag*:

 

Yes at some point, I would like to change from how it was originally done so it will be possible to sort the results but I will have to learn how to do this. I think it is within my capabilities and understanding of php but I will have to set aside some time to do it. Unfortunately the database stores the data slightly differently to how it did in bf3 so it was not possible to just use that one

 

 

Sent from my iPad using Tapatalk

That would be awesome, I like the design of your web stats more than any other, only missing the Weapons page.

[ImportBot]

Originally Posted by supermillhouse*:

 

That would be awesome, I like the design of your web stats more than any other, only missing the Weapons page.

Have a look at this for me and let me know what you think ,it is still a work in progress though. All the M26 and m320 weapon specific weapon stats have been grouped together with the single weapon. ie there is no aek m320 stats, they have been added to the m320 weapon statistics.

http://test.slagsareus.com/weapons.php

[ImportBot]

Originally Posted by kcuestag*:

 

Have a look at this for me and let me know what you think ,it is still a work in progress though. All the M26 and m320 weapon specific weapon stats have been grouped together with the single weapon. ie there is no aek m320 stats, they have been added to the m320 weapon statistics.

http://test.slagsareus.com/weapons.php

Looking good!

[ImportBot]

Originally Posted by ty_ger07*:

 

Have a look at this for me and let me know what you think ,it is still a work in progress though. All the M26 and m320 weapon specific weapon stats have been grouped together with the single weapon. ie there is no aek m320 stats, they have been added to the m320 weapon statistics.

http://test.slagsareus.com/weapons.php

May I interject? I believe what people want is a weapon stats for each player -- such as [RMG] Dr4k3 originally had -- so that when you view a player's stats, you can see their particular weapon stats to see which weapons that particular player uses and how good they are with those weapons. I do not believe that people are particularly interested in global weapon stats for all players -- especially since global weapon stats sort of just all wash out in the end.

 

It seems that the weapon stats should be incorporated into players.php instead of weapons.php using this query from post #26 of this thread:

 

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

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'

[ImportBot]

Originally Posted by kcuestag*:

 

May I interject? I believe what people want is a weapon stats for each player -- such as [RMG] Dr4k3 originally had -- so that when you view a player's stats, you can see their particular weapon stats to see which weapons that particular player uses and how good they are with those weapons. I do not believe that people are particularly interested in global weapon stats for all players -- especially since global weapon stats sort of just all wash out in the end.

 

It seems that the weapon stats should be incorporated into players.php instead of weapons.php using this query from post #26 of this thread:

 

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

Yeah, that'd be better.

[ImportBot]

Originally Posted by supermillhouse*:

 

May I interject? I believe what people want is a weapon stats for each player -- such as [RMG] Dr4k3 originally had -- so that when you view a player's stats, you can see their particular weapon stats to see which weapons that particular player uses and how good they are with those weapons. I do not believe that people are particularly interested in global weapon stats for all players -- especially since global weapon stats sort of just all wash out in the end.

 

It seems that the weapon stats should be incorporated into players.php instead of weapons.php using this query from post #26 of this thread:

 

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

That is coming, I was just learning how to query and arrange the data as the database is structured differently to how it works in the old BF3 one. It shouldn't take me long now to port it over to the player page now. Its just I started with the overall stats page first.

[ImportBot]

Originally Posted by commandotimmy*:

 

I was wondering if someone could help me with my nub question. while installing it asks for the prefix which I get, but what is the suffix and or where do i find this with in my DB?

[ImportBot]

Originally Posted by supermillhouse*:

 

I was wondering if someone could help me with my nub question. while installing it asks for the prefix which I get, but what is the suffix and or where do i find this with in my DB?

The likelihood is you don't have a suffix so just leave it blank, prefix before the table name, suffix after the table name. I believe by default there is no suffix from the stats plugin

[ImportBot]

Originally Posted by supermillhouse*:

 

For the player specific weapon stats should they be a summary or all weapon stats for all servers in the database or split up in to per server_? I will also get on to doing vehicle stats at some point now that is working. Any idea what the XP1 weapon is_?

[ImportBot]

Originally Posted by GR101*:

 

Excellent work supermillhouse, could I suggest future functionality?

 

players.php

 

Add melee for each player.

 

Total server play time for each player.

 

playerstat.php

 

Details per weapons (Kills, Deaths, K/D ratio).

 

Dog tags collected by player (list all players, value).

 

Dog tags lost by player (list all players, value).

 

maps.php

 

Sort maps by number of rounds. (Most and least popular maps).

 

weapons.php (please keep this page)

 

Add top player per weapon. (Player name, Kills, Deaths, K/D ratio).

 

 

And finally, Clan or Platoon page like players.php

 

Thanks.

[ImportBot]

Originally Posted by supermillhouse*:

 

Excellent work supermillhouse, could I suggest future functionality?

 

players.php

 

Add melee for each player.

 

Total server play time for each player.

 

playerstat.php

 

Details per weapons (Kills, Deaths, K/D ratio).

 

Dog tags collected by player (list all players, value).

 

Dog tags lost by player (list all players, value).

 

maps.php

 

Sort maps by number of rounds. (Most and least popular maps).

 

weapons.php (please keep this page)

 

Add top player per weapon. (Player name, Kills, Deaths, K/D ratio).

 

 

And finally, Clan or Platoon page like players.php

 

Thanks.

Would someone be able to provide me with a database that contains multiple servers in it, so I can test these above requests. currently my clan only has 1 server. A database backup would be sufficient.

[ImportBot]

Originally Posted by commandotimmy*:

 

The likelihood is you don't have a suffix so just leave it blank, prefix before the table name, suffix after the table name. I believe by default there is no suffix from the stats plugin

thanks, I figured that it was this, but I thought I had to have something in that field.thanks for the quick help.

 

 

Edit: I must be doing something wrong. I got it installed but it comes up blank. and when I click on clan website it just adds it to the end of the stats address. I have the DB setup and Procon plugin is linked. I am getting no errors from Procon, and I can see tables in the DB.

 

http://forsakenmisfits.com/FM_Server_Stats/index.php

[ImportBot]

Originally Posted by supermillhouse*:

 

thanks, I figured that it was this, but I thought I had to have something in that field.thanks for the quick help.

 

 

Edit: I must be doing something wrong. I got it installed but it comes up blank. and when I click on clan website it just adds it to the end of the stats address. I have the DB setup and Procon plugin is linked. I am getting no errors from Procon, and I can see tables in the DB.

 

http://forsakenmisfits.com/FM_Server_Stats/index.php

Change clan website to have http:// at the start.

Will need to look at the database.php file to figure out the rest. Send me the content of the database.php file in a PM, remember to delete out the password for your own security. Is it a localhost connection or an external database with respect to your webserver?

[ImportBot]

Originally Posted by kcuestag*:

 

Wish I could help, I have just started to learn about SELECT's on MySQL, I'm a newbie.

[ImportBot]

Originally Posted by supermillhouse*:

 

Wish I could help, I have just started to learn about SELECT's on MySQL, I'm a newbie.

oops just put that in the wrong thread, lol