Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger'

[ImportBot]

Originally Posted by glenn82*:

 

Thank you for your answer, i did replace the database and it i sstill not working. Ports are opened in my router.

 

http://83.128.159.112/stats/player_stats.php

 

No error screen just nothing

did you try to connect phpmyadmin to your database?

[ImportBot]

Originally Posted by Ralphvd*:

 

It works when i connect with navicat. I can see the tables and everything. It works ingame fine. (only top10 is not working anymore)

BTW its BF4 server.

On localhost it isnt working either(same pc as where mysql is)

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't have a BF4 server and haven't tested this with BF4. With all the changes XpKiller has made to the BF4 stats logging plugin, this code probably will not work for the most part.

[ImportBot]

Originally Posted by Narf!*:

 

Means we won't see an update for BF4?

[ImportBot]

Originally Posted by Ralphvd*:

 

I really would like to see an update or a new version of this website. It looks really nice for bf3

 

EDIT:

I got help from my clan mate, he fixed it. Dont know what he did, but it is working with BF4 now

 

http://83.128.159.112/stats/player_stats.php

[ImportBot]

Originally Posted by Kinsman*:

 

Thanks, would you like to post the updated script for everyone please?

[ImportBot]

Originally Posted by Narf!*:

 

I really would like to see an update or a new version of this website. It looks really nice for bf3

 

EDIT:

I got help from my clan mate, he fixed it. Dont know what he did, but it is working with BF4 now

 

http://83.128.159.112/stats/player_stats.php

Would you be that nice and share this to us? Maybe? Please?

[ImportBot]

Originally Posted by Kinsman*:

 

updated the map array, but not getting mapnames for some strange reason.

// make an array of map names

$map_array = array('Zavod 311'=>'MP_Abandoned','Lancang Dam'=>'MP_Damage','Flood Zone'=>'MP_Flooded','Golmud Railway'=>'MP_Journey','Paracel Storm'=>'MP_Naval','Operation locker'=>'MP_Prison','Hainan Resort'=>'MP_Resort','Siege of Shanghai'=>'MP_Siege','Rogue transmission'=>'MP_TheDish','Dawn breaker'=>'MP_Tremors');

http://jw.servegame.org/stats4/

[ImportBot]

Originally Posted by Kinsman*:

 

Got all the mapnames working, so thats about it I guess.

 

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

[ImportBot]

Originally Posted by Porthos1973*:

 

Got all the mapnames working, so thats about it I guess.

 

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

Any chance of sharing the files?

[ImportBot]

Originally Posted by ty_ger07*:

 

You guys need to edit the code for the weapon stats. Your weapon stats aren't working for each player's page because xpkiller made changes to how they are stored in the database. Since I don't have a bf4 database, I can't be of much more help (unless someone wants to pm me their database info so I can make compatible code).

[ImportBot]

Originally Posted by Kinsman*:

 

That would be cool, if I export an sql file and email it to you would that help?

 

If so just PM me your email and I'll send it along.

 

As for the mapname and round name edits, I can zip that up and post a link here later.

[ImportBot]

Originally Posted by ty_ger07*:

 

Yeah, that would work fine. I don't need access to your database necessarily. I just need the sql file to build the database myself and use it to tweak the code.

 

Thanks!

[ImportBot]

Originally Posted by Kinsman*:

 

We don't have many stats yet, only server 1 and 3 will be populated.

 

Also posted the player stats file that i updated, it has a few layout edits, and 2 links that will need to be changed if you change the filename, or just remove them, they are just to return to the homepage of the server after you click another link.

 

Attached Files:

• player_stats1.zip
• stats2.zip

[ImportBot]

Originally Posted by Porthos1973*:

 

ty_ger07, will the first page be update with complete file package when you are done?

[ImportBot]

Originally Posted by Kinsman*:

 

forgot, the player_stats1.zip does of course contain the working mode and map names as well.

[ImportBot]

Originally Posted by ty_ger07*:

 

ty_ger07, will the first page be update with complete file package when you are done?

Yeah.

[ImportBot]

Originally Posted by Kinsman*:

 

Was that SQL enough for you to play with? I can send along a bigger one once we have some more stats.

[ImportBot]

Originally Posted by WoFNuLL*:

 

Hey Kinsmann, I don't really know why, but the script you added up there seems not to work as expected:

 

http://bgm.wofnull.de/stats4/player_stats1.php

 

it looks like something in the script is broken. it pulls the data but seems to run on a error. please check this

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey Kinsmann, I don't really know why, but the script you added up there seems not to work as expected:

 

http://bgm.wofnull.de/stats4/player_stats1.php

 

it looks like something in the script is broken. it pulls the data but seems to run on a error. please check this

He only posted part of it. Your css stylesheet file is missing.

http://bgm.wofnull.de/stats4/player_stats.css

 

And there appear to be errors in your php file for the map names.

 

I will post a complete version soon when I am finished.

[ImportBot]

Originally Posted by WoFNuLL*:

 

Found the error already in the player_stats1.php is an additional PHP Part which should not be included at all into this file.

 

On line 2543 the File and the PHP script ends ( _> ) but the script continues , looks like a copy from the original code on the top part of the page, if you remove it or make it invisible via HTML , the script looks normal again and works fine.

[ImportBot]

Originally Posted by ty_ger07*:

 

Found the error already in the player_stats1.php is an additional PHP Part which should not be included at all into this file.

 

On line 2543 the File and the PHP script ends ( _> ) but the script continues , looks like a copy from the original code on the top part of the page, if you remove it or make it invisible via HTML , the script looks normal again and works fine.

Yes, it looks like he made an error.

 

As I said, I am working on this code and will be releasing a full official version soon.

[ImportBot]

Originally Posted by Narf!*:

 

As I said, I am working on this code and will be releasing a full official version soon.

Yay, good news =) Your page was my favourite for BF3, will wait for an update =)))

[ImportBot]

Originally Posted by ty_ger07*:

 

This query might help you developers with BF4 weapon stats:

 

Code:

$table_suffix = '';
$server_ID = '';
$ThisPlayerName = '';
$damagetype = '';
$weapon_result = @mysql_query("SELECT tws.Friendlyname, wa.Kills, wa.Headshots FROM tbl_weapons_stats{$table_suffix} wa INNER JOIN tbl_server_player{$table_suffix} tsp ON tsp.StatsID = wa.StatsID INNER JOIN tbl_playerdata{$table_suffix} tpd ON tsp.PlayerID = tpd.PlayerID INNER JOIN tbl_weapons{$table_suffix} 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 ty_ger07*:

 

BF4 page is up and running:

 

Demo: http://open-web-community.com/bf4sta.StatsMain.php

 

 

EDIT:

I started a new thread instead since it is a subtle but definite transition.

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

[ImportBot]

Originally Posted by Borzywit*:

 

@ty_ger07

 

No download available. Can you please proviode me with a download link?

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't have a copy of the BF3 code any more. At least not with me. I might have a backup somewhere.

[ImportBot]

Originally Posted by Borzywit*:

 

If you can dig it, it would be great! I know it will not work with current revision of XPkiller's logger, but stats page current revision is perfectly adjustable for BF3.

[ImportBot]

Originally Posted by Clinton1977*:

 

hi all if there is any one with files for the BF3 stats page that would be great

[ImportBot]

Originally Posted by Borzywit*:

It seems like there is no working copy of stats web page. However it is possible to run statistics page on BF4 version. In order to force it to work with BF3 you need to do some changes.

Open root/index.php
find:

// first we need to find the GameID
$Server_q = @mysqli_query($BF4stats,"
    SELECT `GameID`
    FROM `tbl_games`
    WHERE `Name` = 'BF4'
");  

replace with:

// first we need to find the GameID
$Server_q = @mysqli_query($BF4stats,"
    SELECT `GameID`
    FROM `tbl_games`
    WHERE `Name` = 'BF3'
");  

Now it will work with BF3. Another change I have made is adding maps.

Open root/common/constants.php

Find:

// make an array of map names
$map_array = array(
    'Zavod 311'                    =>    'MP_Abandoned',
    'Lancang Dam'                =>    'MP_Damage',
    'Flood Zone'                =>    'MP_Flooded',
    'Golmud Railway'            =>    'MP_Journey',
    'Paracel Storm'                =>    'MP_Naval',
    'Operation Locker'            =>    'MP_Prison',
    'Hainan Resort'                =>    'MP_Resort',
    'Siege of Shanghai'            =>    'MP_Siege',
    'Rogue Transmission'        =>    'MP_TheDish',
    'Dawnbreaker'                =>    'MP_Tremors',
    // china rising
    'Silk Road'                    =>    'XP1_001',
    'Altai Range'                =>    'XP1_002',
    'Guilin Peaks'                =>    'XP1_003',
    'Dragon Pass'                =>    'XP1_004',
    // second assault
    'Caspian Border'            =>    'XP0_Caspian',
    'Firestorm'                    =>    'XP0_Firestorm',
    'Operation Metro'            =>    'XP0_Metro',
    'Gulf Of Oman'                =>    'XP0_Oman',
    // naval strike
    'Lost Islands'                =>    'XP2_001',
    'Nansha Strike'                =>    'XP2_002',
    'Wave Breaker'                =>    'XP2_003',
    'Operation Mortar'            =>    'XP2_004'
    // note comma at the end of each line except for the last line
);  

and replace with:

// make an array of map names
$map_array = array(
    'Grand Bazaar'                        =>    'MP_001',
    'Teheran Highway'                    =>    'MP_003',
    'Caspian Border'                    =>    'MP_007',
    'Seine Crossing'                    =>    'MP_011',
    'Operation Firestorm'                =>    'MP_012',
    'Damavand Peak'                        =>    'MP_013',
    'Noshahar Canals'                    =>    'MP_017',
    'Kharg Island'                        =>    'MP_018',
    'Operation Metro'                    =>    'MP_Subway',

//Back to Karkand
    'Strike at Karkand'                    =>    'XP1_001',
    'Gulf of Oman'                        =>    'XP1_002',
    'Sharqi Peninsula'                    =>    'XP1_003',
    'Wake Island'                        =>    'XP1_004',

//Close Quarters
    'Scrapmetal'                        =>    'XP2_Factory',
    'Operation 925'                        =>    'XP2_Office',
    'Donya Fortress'                    =>    'XP2_Palace',
    'Ziba Tower'                        =>    'XP2_Skybar',

//Armored Kill (New gamemode: TankSuperiority0)
    'Bandar Desert'                        =>    'XP3_Desert',
    'Alborz Mountains'                    =>    'XP3_Alborz',
    'Armored Shield'                    =>    'XP3_Shield',
    'Death Valley'                        =>    'XP3_Valley',

If you want to use server banner as we do ( http://fmj.mil.pl/ ) upload below images into root/banner/images/maps/

 

I am missing expansion images, but you can make you own. It has to be *.png image sized 200px*113px. If someone will make game mode array edit and weapons array edit, please send it to me. Also weapons images are required, while some are missing in BF4.