Jump to content

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

ImportBot

By ImportBot
in Plugin Enhancements

Recommended Posts

  • Replies 487
  • Created
  • Last Reply
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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)

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

ImportBot

Posted
  • Author
Posted

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.

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

ImportBot

Posted
  • Author
Posted

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 :biggrin:

 

http://83.128.159.112/stats/player_stats.php

Would you be that nice and share this to us? Maybe? Please? :biggrin:
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

ImportBot

Posted
  • Author
Posted

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

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

ImportBot

Posted
  • Author
Posted

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.

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

ImportBot

Posted
  • Author
Posted

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!

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

ImportBot

Posted
  • Author
Posted

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:

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

ImportBot

Posted
  • Author
Posted

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

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

ImportBot

Posted
  • Author
Posted

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.

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

ImportBot

Posted
  • Author
Posted

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.

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

ImportBot

Posted
  • Author
Posted

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.

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

ImportBot

Posted
  • Author
Posted

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

ImportBot

Posted
  • Author
Posted

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.

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

ImportBot

Posted
  • Author
Posted

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.

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