BfBC2 Chat GUID and Stats Logger Webstats v1.21 [BC2]

ImportBot · 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

ImportBot · February 11, 2011

Originally Posted by Stryker412*:

My signatures don't work either.

ImportBot · 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/

ImportBot · 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.

ImportBot · 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

ImportBot · 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!

ImportBot · 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_...

ImportBot · 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.

ImportBot · 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?

ImportBot · 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 Settings

Code:

<_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!
 _>

ImportBot · February 24, 2011

Originally Posted by BB-Insomnia*:

you should allow outgoing connections to your DB in procon, or disable sandbox

ImportBot · February 24, 2011

Originally Posted by TimSad*:

you should allow outgoing connections to your DB in procon, or disable sandbox

This 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?

ImportBot · 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.

ImportBot · 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.

ImportBot · March 1, 2011

Originally Posted by BB-Insomnia*:

Hi, i figured out why its not working, will fix it soon!

ImportBot · 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!

ImportBot · May 27, 2011

Originally Posted by TimSad*:

So, what's so different about my setup that my weapons stats don't work?

ImportBot · 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.

ImportBot · 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";
		}

ImportBot · 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)

ImportBot · 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)

ImportBot · 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.

ImportBot · 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:

ImportBot · 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 ?

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

ImportBot · 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/

ImportBot · 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_}

ImportBot · July 16, 2011

Originally Posted by HelloKitty*:

in "config.inc.php" set " $bc2conn_enable="0"; " and see if it works...

ImportBot · 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

Unknown column '_kills' in 'where clause'

ImportBot · 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.

Sign In

BfBC2 Chat GUID and Stats Logger Webstats v1.21 [BC2]

Recommended Posts

Link to comment

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Join the conversation

Our picks

Picked By

Picked By

Picked By

Picked By

Picked By

Important Information