ImportBot Posted January 26, 2015 Share Posted January 26, 2015 Originally Posted by scarecr0w12*: Is there anyway to have this only report stats per the month. So basically it would only show stats from Feburary 1st-28th, and then start fresh the next month, or more preferably, show all-time stats aswell as per-month. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 27, 2015 Share Posted January 27, 2015 Originally Posted by ty_ger07*: Is there anyway to have this only report stats per the month. So basically it would only show stats from Feburary 1st-28th, and then start fresh the next month, or more preferably, show all-time stats aswell as per-month.This is something only XpKiller's plugin can do. My stats page cannot control the information saved in the database. The only way for XpKiller's plugin to log one month worth of data is if you delete all the data every month and start over. There is no way to retrieve only one month worth of stats. Session stats can be collected over a specified period of time, but session stats are quite inaccurate and very incomplete (no weapon stats, maps stats, dog tags, etc in session stats). Another clan has already done what you are interested in doing. What they did: You need two instances of XpKiller's plugin running at the same time and saving to separate databases. One database you empty every month to reset a months worth of data, and the other one you let build up data without resetting it. To run two separate instances of XpKiller's plugin, you need to either: 1) run each instance of the plugin on a separate machine/layer or 2) rename the plugin and some data inside the plugin so that it appears to your layer server as if they are two different plugins. If you want to try this solution and need help with option #2, let us know. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 27, 2015 Share Posted January 27, 2015 Originally Posted by ty_ger07*: i added the banner as standard bbcode since our "news" plugin can use that our page is powered by ILCH clan script (if thats what you meant by "engine") This means that your site's BBcode wasn't passing on the query string values to the image output. Since you file_get_contents is now working for you, it isn't anything you need to be concerned of. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 28, 2015 Share Posted January 28, 2015 Originally Posted by Killermike007*: I become this error, "The game 'BF4' was not found in this database! Please notify this website's administrator. If you are the administrator, please seek assistance here." What does it wrong? * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 28, 2015 Share Posted January 28, 2015 Originally Posted by ty_ger07*: I become this error, "The game 'BF4' was not found in this database! Please notify this website's administrator. If you are the administrator, please seek assistance here." What does it wrong? Are you using XpKiller's plugin version 1.0.0.2? Is the plugin working and can you get your stats in the game with no problem? Is your server a BF4 server? * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 28, 2015 Share Posted January 28, 2015 Originally Posted by Killermike007*: Are you using XpKiller's plugin version 1.0.0.2? Is the plugin working and can you get your stats in the game with no problem? Is your server a BF4 server?Plugin Version is BF3 Chat, GUID, Stats and Map Logger - 1.1.0.1plugin works, i can get stats ingame Yes BF4 server Gameserver, Proco-Layer and SQL all on gamed.de * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 28, 2015 Share Posted January 28, 2015 Originally Posted by ty_ger07*: 1.0.0.2 That's why it isn't working. See the preresequites in the first post. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 28, 2015 Share Posted January 28, 2015 Originally Posted by ColColonCleaner*: 1.0.0.2 That's why it isn't working. See the preresequites in the first post. Those old versions really need to be moved to a reference-only/replaced forum section so people stop downloading incorrect versions for new installs. Obviously still keep the threads around for support but they need to be moved out of the main section if the original author has a working replacement. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 30, 2015 Share Posted January 30, 2015 Originally Posted by scarecr0w12*: This is something only XpKiller's plugin can do. My stats page cannot control the information saved in the database. The only way for XpKiller's plugin to log one month worth of data is if you delete all the data every month and start over. There is no way to retrieve only one month worth of stats. Session stats can be collected over a specified period of time, but session stats are quite inaccurate and very incomplete (no weapon stats, maps stats, dog tags, etc in session stats). Another clan has already done what you are interested in doing. What they did: You need two instances of XpKiller's plugin running at the same time and saving to separate databases. One database you empty every month to reset a months worth of data, and the other one you let build up data without resetting it. To run two separate instances of XpKiller's plugin, you need to either: 1) run each instance of the plugin on a separate machine/layer or 2) rename the plugin and some data inside the plugin so that it appears to your layer server as if they are two different plugins. If you want to try this solution and need help with option #2, let us know. Right on, thanks for the tip there, i should be able to handle the editing myself, but if i do need help i'll give a shout. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 31, 2015 Share Posted January 31, 2015 Originally Posted by ChironeX-BF3*: Hello, I am using this page for our BF3 server, most of the time the "signature" with player's favorite weapon aren't working so i was wondering if someone could help to change this: Capture2.JPG To: Capture.JPG I tried to edit it myself on the player.php but i am not able to do it Thank you * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 31, 2015 Share Posted January 31, 2015 Originally Posted by UKF_HHA*: How can I change CN team to US team (live mode)? * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 31, 2015 Share Posted January 31, 2015 Originally Posted by ty_ger07*: Hello, I am using this page for our BF3 server, most of the time the "signature" with player's favorite weapon aren't working so i was wondering if someone could help to change this: Capture2.JPG To: Capture.JPG I tried to edit it myself on the player.php but i am not able to do it Thank you You just want to remove the broken one completely? By the way, the reason the right one is broken is because the BF3 weapon image is missing. To remove the right one, in ./common/player/player.php, change this: Code: // show signature images echo ' </div> <table class="prettytable"> <tr> <td class="tablecontents" style="text-align: left; padding: 20px;" valign="top" width="50%"> Stats image with player\'s rank: '; // include signature.php image echo ' <a href="' . $host . $file . '_p=player&pid=' . $PlayerID . '" target="_blank"><img src="./common/signature/signature.png_pid=' . $PlayerID . '" style="height: 100px; width: 400px;" alt="signature" /></a> <span class="information">BBcode:</span> <table class="prettytable"> <tr> <td class="tablecontents"> <span style="font-size: 10px;">[url=http://.%20%24host%20.%20%24file%20.%20%26#39%3B_p%3Dplayer%26amp%3Bpid%3D%26#39%3B%20.%20%24PlayerID%20.][img=' . $host . $dir . '/common/signature/signature.png_pid=' . $PlayerID . '][/url]</span> </td> </tr> </table> </td> <td class="tablecontents" style="text-align: left; padding: 20px;" valign="top" width="50%"> Stats image with player\'s favorite weapon: '; // include signature.php image echo ' <a href="' . $host . $file . '_p=player&pid=' . $PlayerID . '" target="_blank"><img src="./common/signature/signature.png_pid=' . $PlayerID . '&fav=1" style="height: 100px; width: 400px;" alt="signature" /></a> <span class="information">BBcode:</span> <table class="prettytable"> <tr> <td class="tablecontents"> <span style="font-size: 10px;">[url=http://.%20%24host%20.%20%24file%20.%20%26#39%3B_p%3Dplayer%26amp%3Bpid%3D%26#39%3B%20.%20%24PlayerID%20.][img=' . $host . $dir . '/common/signature/signature.png_pid=' . $PlayerID . '&fav=1][/url]</span> </td> </tr> </table> </td> </tr> </table> ';to this:Code: // show signature images echo ' </div> <table class="prettytable"> <tr> <td class="tablecontents" style="text-align: left; padding: 20px;" valign="top" width="100%"> Stats image with player\'s rank: '; // include signature.php image echo ' <a href="' . $host . $file . '_p=player&pid=' . $PlayerID . '" target="_blank"><img src="./common/signature/signature.png_pid=' . $PlayerID . '" style="height: 100px; width: 400px;" alt="signature" /></a> <span class="information">BBcode:</span> <table class="prettytable"> <tr> <td class="tablecontents"> <span style="font-size: 10px;">[url=http://.%20%24host%20.%20%24file%20.%20%26#39%3B_p%3Dplayer%26amp%3Bpid%3D%26#39%3B%20.%20%24PlayerID%20.][img=' . $host . $dir . '/common/signature/signature.png_pid=' . $PlayerID . '][/url]</span> </td> </tr> </table> </td> </tr> </table> '; * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 31, 2015 Share Posted January 31, 2015 Originally Posted by ty_ger07*: How can I change CN team to US team (live mode)?The team names are specified in ./common/home/scoreboard-live.php. Code: // change team name displayed on scoreboard based on team number and game mode if(($mode == 'ConquestLarge0') OR ($mode == 'ConquestSmall0') OR ($mode == 'Domination0') OR ($mode == 'Elimination0') OR ($mode == 'Obliteration') OR ($mode == 'TeamDeathMatch0') OR ($mode == 'AirSuperiority0') OR ($mode == 'CaptureTheFlag0')) { if($this_team == 1) { if(($map == 'MP_Abandoned') OR ($map == 'MP_Damage') OR ($map == 'MP_Journey') OR ($map == 'MP_TheDish')) { $team_name = 'RU Army'; } elseif(($map == 'MP_Flooded') OR ($map == 'MP_Naval') OR ($map == 'MP_Prison') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'US Army'; } else { $team_name = 'US Army'; } } elseif($this_team == 2) { if($map == 'MP_Abandoned') { $team_name = 'US Army'; } elseif(($map == 'MP_Damage') OR ($map == 'MP_Flooded') OR ($map == 'MP_Journey') OR ($map == 'MP_Naval') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_TheDish') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront')) { $team_name = 'CN Army'; } elseif(($map == 'MP_Prison') OR ($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'RU Army'; } else { $team_name = 'CN Army'; } } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } } elseif($mode == 'RushLarge0') { if($this_team == 1) { if(($map == 'MP_Abandoned') OR ($map == 'MP_Damage') OR ($map == 'MP_Flooded') OR ($map == 'MP_Journey') OR ($map == 'MP_Naval') OR ($map == 'MP_Prison') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_TheDish') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'US Attackers'; } else { $team_name = 'Attackers'; } } elseif($this_team == 2) { if(($map == 'MP_Abandoned') OR ($map == 'MP_Damage') OR ($map == 'MP_Flooded') OR ($map == 'MP_Journey') OR ($map == 'MP_Naval') OR ($map == 'MP_Prison') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_TheDish') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront')) { $team_name = 'CN Defenders'; } elseif(($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'RU Defenders'; } else { $team_name = 'Defenders'; } } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } } elseif(($mode == 'SquadDeathMatch0')) { if($this_team == 1) { $team_name = 'Alpha'; } elseif($this_team == 2) { $team_name = 'Bravo'; } elseif($this_team == 3) { $team_name = 'Charlie'; } elseif($this_team == 4) { $team_name = 'Delta'; } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } } elseif(($mode == 'CarrierAssaultLarge0') OR ($mode == 'CarrierAssaultSmall0')) { if($this_team == 1) { $team_name = 'US Attackers'; } elseif($this_team == 2) { $team_name = 'CN Defenders'; } else { $team_name = 'Team ' . $this_team; } } elseif($mode == 'Chainlink0') { if($this_team == 1) { $team_name = 'US Attackers'; } elseif($this_team == 2) { $team_name = 'CN Defenders'; } else { $team_name = 'Team ' . $this_team; } } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2015 Share Posted February 1, 2015 Originally Posted by UKF_HHA*: The team names are specified in ./common/home/scoreboard-live.php. Code: // change team name displayed on scoreboard based on team number and game mode if(($mode == 'ConquestLarge0') OR ($mode == 'ConquestSmall0') OR ($mode == 'Domination0') OR ($mode == 'Elimination0') OR ($mode == 'Obliteration') OR ($mode == 'TeamDeathMatch0') OR ($mode == 'AirSuperiority0') OR ($mode == 'CaptureTheFlag0')) { if($this_team == 1) { if(($map == 'MP_Abandoned') OR ($map == 'MP_Damage') OR ($map == 'MP_Journey') OR ($map == 'MP_TheDish')) { $team_name = 'RU Army'; } elseif(($map == 'MP_Flooded') OR ($map == 'MP_Naval') OR ($map == 'MP_Prison') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'US Army'; } else { $team_name = 'US Army'; } } elseif($this_team == 2) { if($map == 'MP_Abandoned') { $team_name = 'US Army'; } elseif(($map == 'MP_Damage') OR ($map == 'MP_Flooded') OR ($map == 'MP_Journey') OR ($map == 'MP_Naval') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_TheDish') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront')) { $team_name = 'CN Army'; } elseif(($map == 'MP_Prison') OR ($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'RU Army'; } else { $team_name = 'CN Army'; } } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } } elseif($mode == 'RushLarge0') { if($this_team == 1) { if(($map == 'MP_Abandoned') OR ($map == 'MP_Damage') OR ($map == 'MP_Flooded') OR ($map == 'MP_Journey') OR ($map == 'MP_Naval') OR ($map == 'MP_Prison') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_TheDish') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'US Attackers'; } else { $team_name = 'Attackers'; } } elseif($this_team == 2) { if(($map == 'MP_Abandoned') OR ($map == 'MP_Damage') OR ($map == 'MP_Flooded') OR ($map == 'MP_Journey') OR ($map == 'MP_Naval') OR ($map == 'MP_Prison') OR ($map == 'MP_Resort') OR ($map == 'MP_Siege') OR ($map == 'MP_TheDish') OR ($map == 'MP_Tremors') OR ($map == 'XP1_001') OR ($map == 'XP1_002') OR ($map == 'XP1_003') OR ($map == 'XP1_004') OR ($map == 'XP3_MarketPl') OR ($map == 'XP3_Prpganda') OR ($map == 'XP3_UrbanGdn') OR ($map == 'XP3_WtrFront')) { $team_name = 'CN Defenders'; } elseif(($map == 'XP0_Caspian') OR ($map == 'XP0_Firestorm') OR ($map == 'XP0_Metro') OR ($map == 'XP0_Oman') OR ($map == 'XP2_001') OR ($map == 'XP2_002') OR ($map == 'XP2_003') OR ($map == 'XP2_004') OR ($map == 'XP4_Arctic') OR ($map == 'XP4_SubBase') OR ($map == 'XP4_Titan') OR ($map == 'XP4_Wlkrftry')) { $team_name = 'RU Defenders'; } else { $team_name = 'Defenders'; } } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } } elseif(($mode == 'SquadDeathMatch0')) { if($this_team == 1) { $team_name = 'Alpha'; } elseif($this_team == 2) { $team_name = 'Bravo'; } elseif($this_team == 3) { $team_name = 'Charlie'; } elseif($this_team == 4) { $team_name = 'Delta'; } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } } elseif(($mode == 'CarrierAssaultLarge0') OR ($mode == 'CarrierAssaultSmall0')) { if($this_team == 1) { $team_name = 'US Attackers'; } elseif($this_team == 2) { $team_name = 'CN Defenders'; } else { $team_name = 'Team ' . $this_team; } } elseif($mode == 'Chainlink0') { if($this_team == 1) { $team_name = 'US Attackers'; } elseif($this_team == 2) { $team_name = 'CN Defenders'; } else { $team_name = 'Team ' . $this_team; } } // something unexpected occurred and a correct team name was not found // just name the team based on team number instead else { $team_name = 'Team ' . $this_team; } Thanks buddy * Restored post. It could be that the author is no longer active. Link to comment
Striker77733 Posted February 1, 2015 Share Posted February 1, 2015 Originally Posted by Striker77733*: is there a function to reset the whole leaderboard or do i have to delte the stats db? Link to comment
ImportBot Posted February 1, 2015 Share Posted February 1, 2015 Originally Posted by ty_ger07*: is there a function to reset the whole leaderboard or do i have to delte the stats db?The stats page just shows what is in the database. If you want to reset everything, you have to do it in the database by emptying the tables. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2015 Share Posted February 1, 2015 Originally Posted by ChironeX-BF3*: Thank you ty_ger07 You just want to remove the broken one completely? By the way, the reason the right one is broken is because the BF3 weapon image is missing.I took every BF3 weapon and replaced them on the /common/images/weapons folder :/ * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2015 Share Posted February 1, 2015 Originally Posted by ty_ger07*: Thank you ty_ger07 I took every BF3 weapon and replaced them on the /common/images/weapons folder :/ Some name must be wrong in ./common/constants.php or some image must be missing. The image name in constants.php has to exactly match the image file name. constants.php says: // make an array of weapon names // the left value is the name which will be displayed on the stats page // the image filename in /images/weapons/ must match the right value for each weapon (otherwise the image will appear broken) What it doesn't say is that the right value is the name of the weapon in the database. I guess I assumed that it would be clear. The right value is the name of the weapon in the database AND should be the exact name of the weapon image in /images/weapons/. The only exception to that rule is the "VehicleCustom" array values which can be either the weapon name in the database or the weapon category in the database in different circumstances. But you won't be worrying about vehicle stats in BF3 (since there are no vehicle stats in BF3), so you don't have to worry about the "VehicleCustom" exception. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 4, 2015 Share Posted February 4, 2015 Originally Posted by ChironeX-BF3*: I am gonna let it like this, doesn't look bad at all, thx for extra info * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 24, 2015 Share Posted February 24, 2015 Originally Posted by DevilOmaxe*: Hello, Thanks for this Awesome Plugin and Web Page.. I am a complete noob in this stuff and i need some help regarding this.. I want to know if Database actually saves the "Time Played" on the server? If yes how can i possibly make it appear on the Leaderboards instead of HS/K? If Time Played is not possible to Display then i want to know a method to Display "Rounds Played" on Leaderboards. Please help me with this. DevilOmaxe Battlefield India * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 24, 2015 Share Posted February 24, 2015 Originally Posted by ty_ger07*:Time played is saved in the database, but the number saved is very inaccurate.Rounds played is also saved and used to be displayed, but was removed from the leaderboard because it isn't a very important number and was decreasing performance needlessly.How do you add it to the leaderboard? You would need to edit ./common/leaders/leaders.php.https://github.com/tyger07/BF4-Serve...rs/leaders.phpSome things to pay attention to:Code: // get current rank query details if(!empty($rank)) { // filter out SQL injection if($rank != 'SoldierName' AND $rank != 'Score' AND $rank != 'Kills' AND $rank != 'KDR' AND $rank != 'HSR') { // unexpected input detected // use default instead $rank = 'Score'; } }Above, you would need to add whatever else you want as a valid input of $rank, otherwise it would ignore it.Code: elseif(!empty($player)) { // if there is a ServerID, this is a server stats page if(!empty($ServerID)) { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, tps.`Score`, tps.`Kills`, (tps.`Kills`/tps.`Deaths`) AS KDR, (tps.`Headshots`/tps.`Kills`) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tsp.`ServerID` = {$ServerID} AND tpd.`GameID` = {$GameID} AND tpd.`SoldierName` LIKE '%{$player}%' ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT 10 "); } // or else this is a global stats page else { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, SUM(tps.`Score`) AS Score, SUM(tps.`Kills`) AS Kills, (SUM(tps.`Kills`)/SUM(tps.`Deaths`)) AS KDR, (SUM(tps.`Headshots`)/SUM(tps.`Kills`)) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tpd.`GameID` = {$GameID} AND tsp.`ServerID` IN ({$valid_ids}) AND tpd.`SoldierName` LIKE '%{$player}%' GROUP BY tpd.`PlayerID` ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT 10 "); } } // or else just display every player the normal way else { // if there is a ServerID, this is a server stats page if(!empty($ServerID)) { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, tps.`Score`, tps.`Kills`, (tps.`Kills`/tps.`Deaths`) AS KDR, (tps.`Headshots`/tps.`Kills`) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tsp.`ServerID` = {$ServerID} AND tpd.`GameID` = {$GameID} ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT {$offset}, {$rowsperpage} "); } // or else this is a global stats page else { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, SUM(tps.`Score`) AS Score, SUM(tps.`Kills`) AS Kills, (SUM(tps.`Kills`)/SUM(tps.`Deaths`)) AS KDR, (SUM(tps.`Headshots`)/SUM(tps.`Kills`)) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tpd.`GameID` = {$GameID} AND tsp.`ServerID` IN ({$valid_ids}) GROUP BY tpd.`PlayerID` ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT {$offset}, {$rowsperpage} "); } }Above, you need to add additional field(s) to the sql queries.Code: <table class="prettytable" style="margin-top: -2px;"> <tr> <th width="5%" class="countheader">#</th> '; // player column pagination_headers('Player',$ServerID,'leaders','19','r',$rank,'SoldierName','o',$order,'ASC',$nextorder,$currentpage,'',$player,''); // score column pagination_headers('Score',$ServerID,'leaders','19','r',$rank,'Score','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); // kills column pagination_headers('Kills',$ServerID,'leaders','19','r',$rank,'Kills','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); // kdr column pagination_headers('Kill / Death',$ServerID,'leaders','19','r',$rank,'KDR','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); // hsr column pagination_headers('Headshot / Kill',$ServerID,'leaders','19','r',$rank,'HSR','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); echo ' </tr> </table>Above, you need to add the additional field(s) to the table header.Code: <table class="prettytable" style="margin-top: -2px; position: relative;"> <tr> <td width="5%" class="count"> <div style="position: absolute; z-index: 2; width: 100%; height: 100%; top: 0; left: 0; padding: 0px; margin: 0px;"> <a class="fill-div" style="padding: 0px; margin: 0px;" href="' . $link . '"></a> </div> <span class="information">' . $count . '</span> </td> <td width="19%" class="tablecontents"><a href="' . $link . '">' . $SoldierName . '</a></td> <td width="19%" class="tablecontents">' . $Score . '</td> <td width="19%" class="tablecontents">' . $Kills . '</td> <td width="19%" class="tablecontents">' . $KDR . '</td> <td width="19%" class="tablecontents">' . $HSR . '<span class="information"> %</span></td> </tr> </table>Lastly, above, you need to add the additional field(s) to the output. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 24, 2015 Share Posted February 24, 2015 Originally Posted by DevilOmaxe*: I won't lie but most of this stuff went over my head.. But i will try to do what you told.. Thank you for Replying. Update I am Failing at this. http://devilomaxe.com/stats/ Will update when i get some success. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 24, 2015 Share Posted February 24, 2015 Originally Posted by DevilOmaxe*: Time played is saved in the database, but the number saved is very inaccurate.Rounds played is also saved and used to be displayed, but was removed from the leaderboard because it isn't a very important number and was decreasing performance needlessly.How do you add it to the leaderboard? You would need to edit ./common/leaders/leaders.php.https://github.com/tyger07/BF4-Serve...rs/leaders.phpSome things to pay attention to:Code: // get current rank query details if(!empty($rank)) { // filter out SQL injection if($rank != 'SoldierName' AND $rank != 'Score' AND $rank != 'Kills' AND $rank != 'KDR' AND $rank != 'HSR') { // unexpected input detected // use default instead $rank = 'Score'; } }Above, you would need to add whatever else you want as a valid input of $rank, otherwise it would ignore it.Code: elseif(!empty($player)) { // if there is a ServerID, this is a server stats page if(!empty($ServerID)) { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, tps.`Score`, tps.`Kills`, (tps.`Kills`/tps.`Deaths`) AS KDR, (tps.`Headshots`/tps.`Kills`) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tsp.`ServerID` = {$ServerID} AND tpd.`GameID` = {$GameID} AND tpd.`SoldierName` LIKE '%{$player}%' ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT 10 "); } // or else this is a global stats page else { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, SUM(tps.`Score`) AS Score, SUM(tps.`Kills`) AS Kills, (SUM(tps.`Kills`)/SUM(tps.`Deaths`)) AS KDR, (SUM(tps.`Headshots`)/SUM(tps.`Kills`)) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tpd.`GameID` = {$GameID} AND tsp.`ServerID` IN ({$valid_ids}) AND tpd.`SoldierName` LIKE '%{$player}%' GROUP BY tpd.`PlayerID` ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT 10 "); } } // or else just display every player the normal way else { // if there is a ServerID, this is a server stats page if(!empty($ServerID)) { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, tps.`Score`, tps.`Kills`, (tps.`Kills`/tps.`Deaths`) AS KDR, (tps.`Headshots`/tps.`Kills`) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tsp.`ServerID` = {$ServerID} AND tpd.`GameID` = {$GameID} ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT {$offset}, {$rowsperpage} "); } // or else this is a global stats page else { // get the info from the db $Players_q = @mysqli_query($BF4stats," SELECT tpd.`SoldierName`, tpd.`PlayerID`, SUM(tps.`Score`) AS Score, SUM(tps.`Kills`) AS Kills, (SUM(tps.`Kills`)/SUM(tps.`Deaths`)) AS KDR, (SUM(tps.`Headshots`)/SUM(tps.`Kills`)) AS HSR FROM `tbl_playerdata` tpd INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID` INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID` WHERE tpd.`GameID` = {$GameID} AND tsp.`ServerID` IN ({$valid_ids}) GROUP BY tpd.`PlayerID` ORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder} LIMIT {$offset}, {$rowsperpage} "); } }Above, you need to add additional field(s) to the sql queries.Code: <table class="prettytable" style="margin-top: -2px;"> <tr> <th width="5%" class="countheader">#</th> '; // player column pagination_headers('Player',$ServerID,'leaders','19','r',$rank,'SoldierName','o',$order,'ASC',$nextorder,$currentpage,'',$player,''); // score column pagination_headers('Score',$ServerID,'leaders','19','r',$rank,'Score','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); // kills column pagination_headers('Kills',$ServerID,'leaders','19','r',$rank,'Kills','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); // kdr column pagination_headers('Kill / Death',$ServerID,'leaders','19','r',$rank,'KDR','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); // hsr column pagination_headers('Headshot / Kill',$ServerID,'leaders','19','r',$rank,'HSR','o',$order,'DESC',$nextorder,$currentpage,'',$player,''); echo ' </tr> </table>Above, you need to add the additional field(s) to the table header.Code: <table class="prettytable" style="margin-top: -2px; position: relative;"> <tr> <td width="5%" class="count"> <div style="position: absolute; z-index: 2; width: 100%; height: 100%; top: 0; left: 0; padding: 0px; margin: 0px;"> <a class="fill-div" style="padding: 0px; margin: 0px;" href="' . $link . '"></a> </div> <span class="information">' . $count . '</span> </td> <td width="19%" class="tablecontents"><a href="' . $link . '">' . $SoldierName . '</a></td> <td width="19%" class="tablecontents">' . $Score . '</td> <td width="19%" class="tablecontents">' . $Kills . '</td> <td width="19%" class="tablecontents">' . $KDR . '</td> <td width="19%" class="tablecontents">' . $HSR . '<span class="information"> %</span></td> </tr> </table>Lastly, above, you need to add the additional field(s) to the output.Ok so i sorted 1, 3 and 4 are easy but i can't figure how to put 2nd one.. Also what is name for Rounds Played Queer? "RoundPlayed"? * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 25, 2015 Share Posted February 25, 2015 Originally Posted by ty_ger07*: For some reason, it says that DevilOmaxe replied most recently today, but his post doesn't show up for me.... Huh. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 25, 2015 Share Posted February 25, 2015 Originally Posted by LCARSx64*: For some reason, it says that DevilOmaxe replied most recently today, but his post doesn't show up for me.... Huh.I saw the same thing. I think he may have replied and then deleted his post. Sent from Samsung Galaxy S5 using Tapatalk * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 25, 2015 Share Posted February 25, 2015 Originally Posted by DevilOmaxe*: For some reason, it says that DevilOmaxe replied most recently today, but his post doesn't show up for me.... Huh. I saw the same thing. I think he may have replied and then deleted his post. Sent from Samsung Galaxy S5 using Tapatalk I repled but i think some MOD Removed my Post. Coming back to Topic, Ty_ger Editing/Adding Code 1,3 and 4 seems easy but i am not sure about 2nd one.. I have hosted another Stats page on my own domain for testing but i am failing till now.. You can just say i am too bad in this. * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 25, 2015 Share Posted February 25, 2015 Originally Posted by iraqiboy90*: hi how do I get this working for BF3? * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 26, 2015 Share Posted February 26, 2015 Originally Posted by ty_ger07*: hi how do I get this working for BF3? I am not sure how many times I can say this over and over again. In ./common/connect.php, change `GameID` from 'BF4' to 'BF3'. https://github.com/tyger07/BF4-Serve...on/connect.php In ./common/constants.php, change map names, mode names, weapon names, and ranks as necessary. https://github.com/tyger07/BF4-Serve.constants.php In ./common/images/, change map images, rank images, and weapon images as necessary. https://github.com/tyger07/BF4-Serve.common/images Adjust elsewhere as necessary (change background image and text that says BF4 to BF3 as necessary). * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 26, 2015 Share Posted February 26, 2015 Originally Posted by iraqiboy90*: I am not sure how many times I can say this over and over again. In ./common/connect.php, change `GameID` from 'BF4' to 'BF3'. https://github.com/tyger07/BF4-Serve...on/connect.php In ./common/constants.php, change map names, mode names, weapon names, and ranks as necessary. https://github.com/tyger07/BF4-Serve.constants.php In ./common/images/, change map images, rank images, and weapon images as necessary. https://github.com/tyger07/BF4-Serve.common/images Adjust elsewhere as necessary (change background image and text that says BF4 to BF3 as necessary). I'm sorry lol I already searched like over 20 pages (with the search function) before I gave up and asked... Cant you put it on post one or two? * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted March 6, 2015 Share Posted March 6, 2015 Originally Posted by clanbfb*: Error! WebPage Unable to access stats database. Please notify this website's administrator. If you are the administrator, please seek assistance here. Error: Access denied for user 'clanbfb' (using password: YES) PROCON [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Host '178.9.135.230' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' em MySql.Data.MySqlClient.MySqlStream.ReadPacket() em MySql.Data.MySqlClient.NativeDriver.Open() em MySql.Data.MySqlClient.Driver.Open() em MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings) em MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on() em MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() em MySql.Data.MySqlClient.MySqlPool.GetConnection() em MySql.Data.MySqlClient.MySqlConnection.Open() em PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo) * Restored post. It could be that the author is no longer active. Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.