ImportBot Posted February 11, 2011 Author Share Posted February 11, 2011 Originally Posted by guanaco*: hi =BB=Insomnia Sorry to bother you again, I am trying as much as I can to help other in your forum, but I ran into a wallblock :shock: and dont know where to move... I just realize that on the info.php page an image should be displayed for forum signatures but mine is not displaying. On any players. This is the link http://games.tusell.net/stats/bc2/sig.php_p=Tusell that should generate my signature image but gives me error. Do you have something in mind that could cause this error? Thanks again for your help Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 11, 2011 Author Share Posted February 11, 2011 Originally Posted by Stryker412*: My signatures don't work either. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 12, 2011 Author Share Posted February 12, 2011 Originally Posted by TimSad*: Any idea what would cause my installments' specific weapon stats to give me this_... Unknown column '_kills' in 'where clause' I've installed one for my Vietnam server and one for my standard BC2 Rush server and both get the same thing... http://soldiersofchaosgaming.com/rushstats/ http://soldiersofchaosgaming.com/vietnamstats/ Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 13, 2011 Author Share Posted February 13, 2011 Originally Posted by Indeterminate*: hi =BB=Insomnia Sorry to bother you again, I am trying as much as I can to help other in your forum, but I ran into a wallblock :shock: and dont know where to move... I just realize that on the info.php page an image should be displayed for forum signatures but mine is not displaying. On any players. This is the link http://games.tusell.net/stats/bc2/sig.php_p=Tusell that should generate my signature image but gives me error. Do you have something in mind that could cause this error? Thanks again for your help The sig.php file somehow gets corrupted and drops some spaces and line breaks. If you edit the file before upload in a program such as Crimson Editor, which can recognise the formatting, re-save the file and upload that version, you should find the problem resolved. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 13, 2011 Author Share Posted February 13, 2011 Originally Posted by guanaco*: hi =BB=Insomnia Sorry to bother you again, I am trying as much as I can to help other in your forum, but I ran into a wallblock :shock: and dont know where to move... I just realize that on the info.php page an image should be displayed for forum signatures but mine is not displaying. On any players. This is the link http://games.tusell.net/stats/bc2/sig.php_p=Tusell that should generate my signature image but gives me error. Do you have something in mind that could cause this error? Thanks again for your help The sig.php file somehow gets corrupted and drops some spaces and line breaks. If you edit the file before upload in a program such as Crimson Editor, which can recognise the formatting, re-save the file and upload that version, you should find the problem resolved.Thanks for your reply, I just checked the file again and I cant find any spaces or line breaks that look somehow wrong in the code... could you point me to a good sig.php file? perhaps share the good code so I can copy/paste it? Thanks Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 13, 2011 Author Share Posted February 13, 2011 Originally Posted by guanaco*: hi =BB=Insomnia Sorry to bother you again, I am trying as much as I can to help other in your forum, but I ran into a wallblock :shock: and dont know where to move... I just realize that on the info.php page an image should be displayed for forum signatures but mine is not displaying. On any players. This is the link http://games.tusell.net/stats/bc2/sig.php_p=Tusell that should generate my signature image but gives me error. Do you have something in mind that could cause this error? Thanks again for your help The sig.php file somehow gets corrupted and drops some spaces and line breaks. If you edit the file before upload in a program such as Crimson Editor, which can recognise the formatting, re-save the file and upload that version, you should find the problem resolved.Thanks for your reply, I just checked the file again and I cant find any spaces or line breaks that look somehow wrong in the code... could you point me to a good sig.php file? perhaps share the good code so I can copy/paste it? Thanks I think I founded the problem... the freetype library is not installed... I compyled a new Apache build and it is working now!!! I apologize for the inconvenient. Thanks! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 16, 2011 Author Share Posted February 16, 2011 Originally Posted by TimSad*: Any idea what would cause my installments' specific weapon stats to give me this_... Unknown column '_kills' in 'where clause' I've installed one for my Vietnam server and one for my standard BC2 Rush server and both get the same thing... http://soldiersofchaosgaming.com/rushstats/ http://soldiersofchaosgaming.com/vietnamstats/ Anything_... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 17, 2011 Author Share Posted February 17, 2011 Originally Posted by HelloKitty*: There is something wrong with your table names. Do you have one database for both servers or for each? Post your Plugin settings and maybe a screeny of your sql tablename. That makes it easier to find the problem. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 17, 2011 Author Share Posted February 17, 2011 Originally Posted by BB-Insomnia*: Any idea what would cause my installments' specific weapon stats to give me this_... Unknown column '_kills' in 'where clause' I've installed one for my Vietnam server and one for my standard BC2 Rush server and both get the same thing... http://soldiersofchaosgaming.com/rushstats/ http://soldiersofchaosgaming.com/vietnamstats/ Anything_...Did you enable weapon stats logging in the plugin? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 23, 2011 Author Share Posted February 23, 2011 Originally Posted by TimSad*: Did you enable weapon stats logging in the plugin?Yep! There is something wrong with your table names. Do you have one database for both servers or for each? Post your Plugin settings and maybe a screeny of your sql tablename. That makes it easier to find the problem. I have two separate databases for each... Database Tables Rush Server Database Tables Vietnam Server Database Tables Plugin Settings Rush Server Plugin Settings Vietnam Server Plugin Settings Webstats Config Settings Rush Server Config Settings Code: <_php $showerrors="1"; // Set to 1 to report Errors $embedded=""; // When 1 => width~600px else width~900px $background_enable="1"; // Set 1 to enable Background (bad_background.jpg) $mysqlhost="bfbc2procon.db.6024623.hostedresource.com"; // Set the MySQL Host $mysqldb="bfbc2procon"; // Set the MySQL Databasename $mysqluser="my_db_username"; // Set the MySQL Database Username $mysqlpwd="my_db_password"; // Set the MySQL Database Password $mysqltable_suffix="rush"; // Same like in your Procon plugin! $mysqlchatlogtable="tbl_chatlogrush"; // Set the Name of the Chatlog Table $ts3id=""; // Set your own TS3 Viewer ID from [url=http://www.tsviewer.com/]http://www.tsviewer.com/[/url] 0 to deactivate $gametracker="1"; // Set 1 to show your Gameserverinfo $gameserver="76.74.238.189"; // Set your Gameserver IP $gameserverport="19567"; // Set your Gameserver Port $rconport="48888"; // Set your Gameserver IP $rconpassword="my_gameserver_rcon_pw"; // Set your Gameserver IP $limit="20"; // Player shown per Page $chat="1"; // Show last 15 Chatmessages on Mainpage $sig_path="soldiersofchaosgaming.com/rushstats"; // URL adress to your Statspage $sig_image="images/sig.jpg"; // Backgroundimage for Signatures 400x80px! $defaultgame="bc2"; // Set bc2 for BC2, nam for Vietnam stats or shared for shared DB! $allowswitchgame=""; // Check to allow viewers to switch between BC2 and Vietnam stats $bc2conn_enable="0"; // Set 0 to disable ServerQuery if Server is down! $serverstatus="Currently there are %player/%slots Players playing %gamemode on %map. Join them on \"%servername\"!"; // Serverinfo: Use %servername, %map, %player, %slots $serversum="%players Players scored %score Points in %rounds Rounds (%pointsperround PpR) having %kills Kills and %deaths Deaths. They spent %time of their sparetime since %firstconnect on our server doing %teamkills Teamkills and %suicides Suicides with a max Killstreak of %killstreak Kills and a max Deathstreak of %deathstreak Deaths"; // Serversummery: Use %players %score %rounds %kills %deaths %time %firstconnect %teamkills %suicides %killstreak %deathstreak and for new line $top_killstreaks="1"; // to enable Top10-View of Killstreaks IMPORTANT: You need to enable Chatlog and LOG SERVERSPAM in your BC2 Stats & Chatlogger! $killstreakstart=""; // not needed atm $killstreakend=" has a 10 kill streak going!"; // Same like in your Killstreakplugin! $killstreaktitle="10 Kills in a row"; // Title for the Row in the Table! _> Vietnam Server Config SettingsCode: <_php $showerrors=""; // Set to 1 to report Errors $embedded=""; // When 1 => width~600px else width~900px $background_enable="1"; // Set 1 to enable Background (bad_background.jpg) $mysqlhost="proconvietnam.db.6024623.hostedresource.com"; // Set the MySQL Host $mysqldb="proconvietnam"; // Set the MySQL Databasename $mysqluser="my_db_username"; // Set the MySQL Database Username $mysqlpwd="my_db_password"; // Set the MySQL Database Password $mysqltable_suffix=""; // Same like in your Procon plugin! $mysqlchatlogtable="tbl_chatlog"; // Set the Name of the Chatlog Table $ts3id=""; // Set your own TS3 Viewer ID from [url=http://www.tsviewer.com/]http://www.tsviewer.com/[/url] 0 to deactivate $gametracker=""; // Set 1 to show your Gameserverinfo $gameserver="76.74.158.106"; // Set your Gameserver IP $gameserverport="19567"; // Set your Gameserver Port $rconport="48888"; // Set your Gameserver IP $rconpassword="my_gameserver_rcon_pw"; // Set your Gameserver IP $limit="20"; // Player shown per Page $chat="1"; // Show last 15 Chatmessages on Mainpage $sig_path="soldiersofchaosgaming.com/vietnamstats"; // URL adress to your Statspage $sig_image="images/sig.jpg"; // Backgroundimage for Signatures 400x80px! $defaultgame="nam"; // Set bc2 for BC2, nam for Vietnam stats or shared for shared DB! $allowswitchgame=""; // Check to allow viewers to switch between BC2 and Vietnam stats $bc2conn_enable=""; // Set 0 to disable ServerQuery if Server is down! $serverstatus="Currently there are %player/%slots Players playing %gamemode on %map. Join them on \"%servername\"!"; // Serverinfo: Use %servername, %map, %player, %slots $serversum="%players Players scored %score Points in %rounds Rounds (%pointsperround PpR) having %kills Kills and %deaths Deaths. They spent %time of their sparetime since %firstconnect on our server doing %teamkills Teamkills and %suicides Suicides with a max Killstreak of %killstreak Kills and a max Deathstreak of %deathstreak Deaths"; // Serversummery: Use %players %score %rounds %kills %deaths %time %firstconnect %teamkills %suicides %killstreak %deathstreak and for new line $top_killstreaks="1"; // to enable Top10-View of Killstreaks IMPORTANT: You need to enable Chatlog and LOG SERVERSPAM in your BC2 Stats & Chatlogger! $killstreakstart=""; // not needed atm $killstreakend=" has a 10 kill streak going!"; // Same like in your Killstreakplugin! $killstreaktitle="10 Kills in a row"; // Title for the Row in the Table! _> Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 24, 2011 Author Share Posted February 24, 2011 Originally Posted by BB-Insomnia*: you should allow outgoing connections to your DB in procon, or disable sandbox Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 24, 2011 Author Share Posted February 24, 2011 Originally Posted by TimSad*: you should allow outgoing connections to your DB in procon, or disable sandboxThis is all I have access to at PrimaryTarget and this is what is set... But I don't get it... If there are kills already recorded in the database, wouldn't it be able to read them from there? How does the Procon's connection to my DB have anything to do with your webstats getting the weapon data that already exists? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 24, 2011 Author Share Posted February 24, 2011 Originally Posted by BB-Insomnia*: settings seem to be correct, take a look into your tables, to ensure the procon plugin logs correctly. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 25, 2011 Author Share Posted February 25, 2011 Originally Posted by TimSad*: settings seem to be correct, take a look into your tables, to ensure the procon plugin logs correctly. They look fine to me. Here's my weapons table... Is it possibly something to do with my PHP version? I have version 5.2.14 on my webserver. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted March 1, 2011 Author Share Posted March 1, 2011 Originally Posted by BB-Insomnia*: Hi, i figured out why its not working, will fix it soon! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted April 29, 2011 Author Share Posted April 29, 2011 Originally Posted by TimSad*: Did you ever get around to fixing that issue? I'd really love to see our weapon stats. Don't feel pressured though man. I realize that this is all volunteer community work and that you have a life. Heh! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted May 27, 2011 Author Share Posted May 27, 2011 Originally Posted by TimSad*: So, what's so different about my setup that my weapons stats don't work? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted June 24, 2011 Author Share Posted June 24, 2011 Originally Posted by TimSad*: Anyone have any idea why it's doing this with my installation? If I know why, I can try to fix it myself. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted June 26, 2011 Author Share Posted June 26, 2011 Originally Posted by TimSad*: Okay, I decided to take a look at it myself and found the problem. For those that are interested, in the single_weaponstats.php, all that is needed is for the $weapon variable to exist within the if condition like so. Bold is what had to be added... Code: if(isset($_GET['weapon']) && in_array($_GET['weapon'],$all_weapons)){ [b]$weapon = $_GET['weapon'];[/b] $weapon_sql = $_GET['weapon']; $weapon_selected = $_GET['weapon']; $weapon_kills =$_GET['weapon']."_kills"; $weapon_deaths =$_GET['weapon']."_deaths"; $weapon_hs = $_GET['weapon']."_hs"; $weapon_HPK = $_GET['weapon']."_HPK"; $weapon_KD = $_GET['weapon']."_KD"; } else { $weapon = "GARAND"; $weapon_sql = "GARAND"; $weapon_selected = "GARAND"; $weapon_kills = "GARAND_kills"; $weapon_deaths = "GARAND_deaths"; $weapon_hs = "GARAND_hs"; $weapon_HPK = "GARAND_HPK"; $weapon_KD = "GARAND_KD"; } Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted June 30, 2011 Author Share Posted June 30, 2011 Originally Posted by GitSum*: I just got this up and running today and was having the same exact problem ->Unknown column '_kills' in 'where clause' This fixed it for me Thanks Tim for the fix and thanks BB Insomnia for all the hard work on the plugin (you to XpKiller) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted June 30, 2011 Author Share Posted June 30, 2011 Originally Posted by GitSum*: This morning I noticed this error message in Procon - it looks like the plugin is having trouble connecting to BFBCS. Could the problem be with the "public token"? Error code 08S01 is "Communication link failure" [23:41:38 48] BF BC2 Chat, GUID and Stats Logger Enabled [23:41:38 48] BF BC2 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player [23:41:38 78] In-Game Admin Enabled! [08:32:04 70] Error in DownloadBFBCS: System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request) at System.Net.WebClient.DownloadString(Uri address) at System.Net.WebClient.DownloadString(String address) at PRoConEvents.CChatGUIDStatsLogger.DownloadBFBCS(Ob ject ListObject) The action that failed was: Demand The type of the first permission that failed was: System.Net.WebPermission The Zone of the assembly that failed was: MyComputer [09:13:40 05] Error in SQLQuery in Case 8: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community-log]MySQL server has gone away --- End of inner exception stack trace --- at System.Data.Odbc.OdbcConnection.ConnectionIsAlive( Exception innerException) at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow (OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteReader() at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted June 30, 2011 Author Share Posted June 30, 2011 Originally Posted by XpKiller*: No The plugin has problems with your Sandboxsettings. Add the address of bfbcs (http://api.bfbcs.com) to the allowed connections with port 80 or disable the sandbox. The second errors is caused by the target mysqlserver. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 1, 2011 Author Share Posted July 1, 2011 Originally Posted by GitSum*: Thanks for the quick reply I disabled the sandbox, and restarted everything - and it already looks like it is working! Thread started and fetching Stats from BFBCS for Players:... Got BFBC2 stats for ... Got BFBC2 stats for... Thanks again:smile: Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 1, 2011 Author Share Posted July 1, 2011 Originally Posted by Ace*: Hi i get this error message listed at bottom of ProCon Error in OpenConnection: [07:27:01 35] Index #0 [07:27:01 36] Message: [MySQL][ODBC 5.1 Driver]Access denied for user 'database_bfbcprocon'@'localhost' (using password: YES) [07:27:01 37] Native: 1045 [07:27:01 39] Source: [07:27:01 40] SQL: HY000 [07:27:01 42] Index #1 any chance of fixing this at all ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 1, 2011 Author Share Posted July 1, 2011 Originally Posted by MorpheusX(AUT)*: Access denied for user 'database_bfbcprocon'@'localhost'Please read the error message. This is a problem on your side, nothing other people could fix for you.Your MySQL-User doesn't have the needed rights to access the database. You will have to fix that yourself (or your database-provider, if you don't host it yourself). Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 5, 2011 Author Share Posted July 5, 2011 Originally Posted by BLAZE*: Regarding the Private server stats, I ran the installer.php. And I'm sure everything is correct because its the same as my plugin and its working. The only thing is I see nowhere in the config.inc.php to put the port for the sql server. Here is what I get..... http://fpsbandofbrothers.com/bc2stats/stats/ Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 8, 2011 Author Share Posted July 8, 2011 Originally Posted by BLAZE*: If I enable Bfbcs then I get "BC2Conn could not be established." and a blank page. If I disable it I do have some ranks but not all players have ranks. I've read somewhere to disable port 48888 in script to fix but I don't know what script. Any help would be appreciated. {addition...Do I need to change anything in BC2Conn.php_} Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 16, 2011 Author Share Posted July 16, 2011 Originally Posted by HelloKitty*: in "config.inc.php" set " $bc2conn_enable="0"; " and see if it works... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted August 13, 2011 Author Share Posted August 13, 2011 Originally Posted by BLAZE*: Can someone help. I get this when I click on a weapon. Also when I click on a player their sig doesn't show up. Any ideas? Notice: Undefined variable: game in /home/elevat6/public_html/fpsbandofbrothers.com/stats/single_weaponstats.php on line 30 Notice: Undefined variable: weapon in /home/elevat6/public_html/fpsbandofbrothers.com/stats/single_weaponstats.php on line 158 Notice: Undefined variable: weapon in /home/elevat6/public_html/fpsbandofbrothers.com/stats/single_weaponstats.php on line 158 Unknown column '_kills' in 'where clause' Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted August 13, 2011 Author Share Posted August 13, 2011 Originally Posted by TimSad*: To fix your weapon issue... In single_weaponstats.php look for... Code: if (isset($_GET['game']) && ($allowswitchgame=="1") && $_GET['game']=="nam"){ $game=="nam"; $game_suff="_bfv"; } elseif (isset($_GET['game']) && ($allowswitchgame=="1") && $_GET['game']=="bc2"){ $game=="bc2"; $game_suff=""; } elseif (isset($_GET['game']) && ($allowswitchgame=="1") && $_GET['game']=="shared"){ $game=="shared"; $game_suff=""; }and change to (changed lines in bold)... Code: if (isset($_GET['game']) && ($allowswitchgame=="1") && $_GET['game']=="nam"){ [b]$game="nam";[/b] $game_suff="_bfv"; } elseif (isset($_GET['game']) && ($allowswitchgame=="1") && $_GET['game']=="bc2"){ [b]$game="bc2";[/b] $game_suff=""; } elseif (isset($_GET['game']) && ($allowswitchgame=="1") && $_GET['game']=="shared"){ [b]$game="shared";[/b] $game_suff=""; }Then to clear up the next two parsing errors look for the following segment of code. The line in bold is what has to be added... Code: if(isset($_GET['weapon']) && in_array($_GET['weapon'],$all_weapons)){ [b]$weapon = $_GET['weapon'];[/b] $weapon_sql = $_GET['weapon']; $weapon_selected = $_GET['weapon']; $weapon_kills =$_GET['weapon']."_kills"; $weapon_deaths =$_GET['weapon']."_deaths"; $weapon_hs = $_GET['weapon']."_hs"; $weapon_HPK = $_GET['weapon']."_HPK"; $weapon_KD = $_GET['weapon']."_KD"; } else { $weapon = "GARAND"; $weapon_sql = "GARAND"; $weapon_selected = "GARAND"; $weapon_kills = "GARAND_kills"; $weapon_deaths = "GARAND_deaths"; $weapon_hs = "GARAND_hs"; $weapon_HPK = "GARAND_HPK"; $weapon_KD = "GARAND_KD"; }Tell me how this goes for you. I'll get back to you on the player signature problem. Quote * Restored post. It could be that the author is no longer active. Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.