Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by slekkas*:

 

I just found another issue. At first i posted in the procon general forum but after i though about it maybe you would be the right people to ask.

 

This is what i posted:

 

I started using host4admins.com service but i realized there is a problem with the timezone. My stats page is probably taking his local time (US -7)and it doesn't match with our time here in Greece(+2). For instance in my stats website i have this:

 

2011-01-10

04:46:49 FyreNL Global that sucked

 

But the correct time should had been 14:46:49

 

Is there some way to tell procon to use a specific timezone for a specific server? Is it a procon issue or a BFBC2 Chat, GUID, Stats and Mapstats Logger issue. Could there be an option in the plugin settings that we could choose the timezone? Do others have this problem?

 

Edit: I think it's possible. I found this post http://support.modwest.com/content/6/25 ... ezone.html

 

If you could tell me were to add this line: SELECT DATE_ADD(NOW(), INTERVAL 2 HOUR); i would be able to get the result i want.

[ImportBot]

Originally Posted by XpKiller*:

 

BETA2 Out:

 

Changelog:

 

Some Switches added (chatloging on, off)

Optimized BFBCS API Query ( get stats for multply players in a single request)

 

Known Issues:

PB-Ban does not work properly all the time

 

Download

[ImportBot]

Originally Posted by slekkas*:

 

BETA2 Out:

 

Changelog:

 

Some Switches added (chatloging on, off)

Optimized BFBCS API Query ( get stats for multply players in a single request)

 

Known Issues:

PB-Ban does not work properly all the time

 

Download

I did the update and now i'm getting messages like this:

 

[10:56:40 73] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_4789test.tbl_bfbcs' doesn't exist

[10:56:40 73] Native: 1146

[10:56:40 73] Source: myodbc5.dll

[10:56:40 73] SQL: 42S02

[10:56:40 73] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n()

at System.Collections.Generic.List`1.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[10:57:11 40] Error in SQLQuery in Case 10:

[10:57:11 40] Index #0

[10:57:11 40] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_4789test.tbl_bfbcs' doesn't exist

[10:57:11 40] Native: 1146

[10:57:11 40] Source: myodbc5.dll

[10:57:11 40] SQL: 42S02

[10:57:11 42] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n()

at System.Collections.Generic.List`1.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[10:57:11 90] Error in SQLQuery in Case 10:

[10:57:11 90] Index #0

[10:57:11 90] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_4789test.tbl_bfbcs' doesn't exist

[10:57:11 90] Native: 1146

[10:57:11 90] Source: myodbc5.dll

[10:57:11 90] SQL: 42S02

[10:57:11 92] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n()

at System.Collections.Generic.List`1.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[10:57:12 81] =GAZA= ADEL has a 5 kill streak going!

[10:57:43 77] Error in SQLQuery in Case 10:

[10:57:43 77] Index #0

[10:57:43 77] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_4789test.tbl_bfbcs' doesn't exist

[10:57:43 77] Native: 1146

[10:57:43 77] Source: myodbc5.dll

[10:57:43 77] SQL: 42S02

[10:57:43 77] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n()

at System.Collections.Generic.List`1.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[10:57:44 27] Error in SQLQuery in Case 10:

[10:57:44 27] Index #0

[10:57:44 27] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_4789test.tbl_bfbcs' doesn't exist

[10:57:44 27] Native: 1146

[10:57:44 27] Source: myodbc5.dll

[10:57:44 27] SQL: 42S02

[10:57:44 27] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n()

at System.Collections.Generic.List`1.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[10:58:07 74] Error in SQLQuery in Case 10:

[10:58:07 74] Index #0

[10:58:07 74] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_4789test.tbl_bfbcs' doesn't exist

[10:58:07 74] Native: 1146

[10:58:07 74] Source: myodbc5.dll

[10:58:07 74] SQL: 42S02

[10:58:07 74] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n()

at System.Collections.Generic.List`1.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[10:58:08 90] Error in SQLQuery in Case 10:

[10:58:08 90] Index #0

[10:58:08 90] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_4789test.tbl_bfbcs' doesn't exist

[10:58:08 91] Native: 1146

[10:58:08 91] Source: myodbc5.dll

[10:58:08 91] SQL: 42S02

[10:58:08 91] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

 

 

Any idea what this means?

[ImportBot]

Originally Posted by XpKiller*:

 

Looks like I forgot to trigger the tablebuilder.

This error are caused be missing tables.

Try to restart procon.

[ImportBot]

Originally Posted by HelloKitty*:

 

I get the only the following error on previous and current beta:

 

Code:

[09:56:09 68] BF BC2 Chat, GUID and Stats Logger Enabled
[09:56:09 68] BF BC2 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[09:56:46 98] Start tablebuilder
[09:56:47 92] OdbcCon open
[09:56:48 84] Your Weapontable is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls
[09:56:48 90] Last Update: 0
[09:56:48 90] 17619537,9469184
[09:56:48 95] Thread started and fetching Stats from BFBCS for Players: HeLlO-KitTyCaT
[09:56:49 09] Error in DownloadBFBCS: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".
   bei System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   bei System.Net.WebClient.DownloadString(Uri address)
   bei System.Net.WebClient.DownloadString(String address)
   bei PRoConEvents.CChatGUIDStatsLogger.DownloadBFBCS(Object ListObject)
Die Aktion, bei der ein Fehler aufgetreten ist:
Demand
Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:
System.Net.WebPermission
Die Zone der Assembly, bei der ein Fehler aufgetreten ist:
MyComputer

..but I guess this is a problem with bfbcs or the securitysettings on my homeserver.

 

The sql-ables are buildt propperly; only EAGUID is not inserted on every player and mapstats are missing some "gamemode" entries.

[ImportBot]

Originally Posted by slekkas*:

 

Looks like I forgot to trigger the tablebuilder.

This error are caused be missing tables.

Try to restart procon.

I did restart procon and it created the database. This error is gone. Now i get this:

 

[11:30:18 54] Error in DownloadBFBCS: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DownloadBFBCS(Ob ject ListObject)

 

 

Thanks for the quick response. I cant wait to try out the anti-cheat feature:-).

 

Edit: I figured that one my self. I think this message is for the players that never went to bfbcs.com and they don't exist in their database. Correct me if I'm wrong.

[ImportBot]

Originally Posted by XpKiller*:

 

@ hellokitty you must add the bfbcs api site to the outgoing connections.

 

@slekkas looks like you found bug, I must missing a check.

[ImportBot]

Originally Posted by HelloKitty*:

 

The previous reported errormessage appeared with "plugins in sandbox" and "all outgoing allowed".

Now I set it to "No restrictions" and it seems to work. No errors threw pluginrestart. Ingame stats are shown:

Code:

15:19:26 79] BF BC2 Chat, GUID and Stats Logger Disabled
[15:20:53 34] BF BC2 Chat, GUID and Stats Logger Enabled
[15:20:53 37] BF BC2 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[15:20:53 37] Gamemod Tableschema set to: SHARED
[15:20:53 43] Gamemod Weaponlist set to: SHARED
[15:20:58 78] Start tablebuilder
[15:20:59 12] OdbcCon open
[15:20:59 93] Your Weapontable is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls
[15:21:00 00] Last Update: 0
[15:21:00 00] 17619543,35
[15:21:00 01] Thread started and fetching Stats from BFBCS for Players: MaGIcYe
[15:21:00 12] No Stats found for Player: MaGIcYe
[15:24:16 17] Connection OdbcCon closed
[15:28:16 60] OnLoadingLevel: Levels/NAM_MP_005CQ Round: 1/1
[15:28:16 62] update sql server
[15:28:17 07] OdbcConn open
[15:28:17 90] OdbcCon open
[15:28:18 50] Received ID from Database ID: 755Added to cache
[15:28:19 53] Received ID from Database ID: 756Added to cache
[15:28:21 56] Status ID-Cache: 2 ID's in cache
[15:28:21 57] Connection OdbcCon closed
[15:28:21 57] Connection OdbcConn closed
[15:29:22 21] OdbcCon open
[15:29:22 29] Connection OdbcCon closed
[15:29:29 18] OdbcCon open
[15:29:29 25] Last Update: 11.01.2011 15:28:19
[15:29:29 25] 0,0195138888888889
[15:29:29 26] No Update needed

[ImportBot]

Originally Posted by XpKiller*:

 

New Update for testing: Beta3:

 

Pls give Feedback

 

Changelog:

Plugin now tries to repair BFBCS Strings with Errors and dont drop them

Removed some debug messages

Added Option to change the Update interval for BFBCS

Download

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

The previous reported errormessage appeared with "plugins in sandbox" and "all outgoing allowed".

Now I set it to "No restrictions" and it seems to work. No errors threw pluginrestart. Ingame stats are shown:

All outgoing ODBC-Connections allowed is one thing, but adding http://api.bfbcs.com , port 80 to the list of trusted hosts is another one...

You will have to do this manually (or turn of sandbox mode), otherwise it will block incoming connections from all hosts, and thus you wont get your stats.

[ImportBot]

Originally Posted by EoT-Honk*:

 

works beautifully

[ImportBot]

Originally Posted by slekkas*:

 

New beta is looking good.

 

Did you have the chance to look at the time zone problem I'm having? My procon host and i have 10 hours difference. He is -7 and i am +2. We have 10 hours difference so in the chat log the time does not show correctly. Is there somewhere in the plugin code we could add a command that it will take the time of the server and add 10 hours before is sends the data to the database. Later on you could add it as an option to the plugin since I'm pretty sure I'm not the only one that hosts his procon in a different timezone.

 

thanks.

[ImportBot]

Originally Posted by XpKiller*:

 

New beta is looking good.

 

Did you have the chance to look at the time zone problem I'm having? My procon host and i have 10 hours difference. He is -7 and i am +2. We have 10 hours difference so in the chat log the time does not show correctly. Is there somewhere in the plugin code we could add a command that it will take the time of the server and add 10 hours before is sends the data to the database. Later on you could add it as an option to the plugin since I'm pretty sure I'm not the only one that hosts his procon in a different timezone.

 

thanks.

i think i might got a solution for it.

[ImportBot]

Originally Posted by slekkas*:

 

New beta is looking good.

 

Did you have the chance to look at the time zone problem I'm having? My procon host and i have 10 hours difference. He is -7 and i am +2. We have 10 hours difference so in the chat log the time does not show correctly. Is there somewhere in the plugin code we could add a command that it will take the time of the server and add 10 hours before is sends the data to the database. Later on you could add it as an option to the plugin since I'm pretty sure I'm not the only one that hosts his procon in a different timezone.

 

thanks.

i think i might got a solution for it.

That would be great:-).

[ImportBot]

Originally Posted by XpKiller*:

 

The solution is figured out is working.

I will integrate it into the final release of 3.0.2.0 then you can determinate a timeoffset to the servertime.

[ImportBot]

Originally Posted by slekkas*:

 

The solution is figured out is working.

I will integrate it into the final release of 3.0.2.0 then you can determinate a timeoffset to the servertime.

Dude you are awesome. Thanks a million.

[ImportBot]

Originally Posted by XpKiller*:

 

Im very very Sorry but it didnt work as espected but try to get it working. :cry:

 

Edit got working but its a real hack:

 

Changelog:

its possible now to define an Offset to the Servertime.

 

 

Download

[ImportBot]

Originally Posted by slekkas*:

 

I installed the new beta and now i'm getting this error:

 

 

[11:22:40 74] Error in OnPunkbusterPlayerInfo: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CStats..ctor(String guid, Int32 score, Int32 kills, Int32 headshots, Int32 deaths, Int32 suicides, Int32 teamkills, Int32 playtime, Double timeoffset)

at PRoConEvents.CChatGUIDStatsLogger.AddPBInfoToStats (CPunkbusterInfo cpbiPlayer)

at PRoConEvents.CChatGUIDStatsLogger.OnPunkbusterPlay erInfo(CPunkbusterInfo cpbiPlayer)

 

 

[11:19:43 30] Error in CreateSession: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CStats..ctor(String guid, Int32 score, Int32 kills, Int32 headshots, Int32 deaths, Int32 suicides, Int32 teamkills, Int32 playtime, Double timeoffset)

at PRoConEvents.CChatGUIDStatsLogger.CreateSession(St ring SoldierName)

 

 

Even though i get these error the result is looking good though.

[ImportBot]

Originally Posted by XpKiller*:

 

Looks like an error cause by my time workaround if I can't fix you must live without it.

[ImportBot]

Originally Posted by slekkas*:

 

Looks like an error cause by my time workaround if I can't fix you must live without it.

No problem.

[ImportBot]

Originally Posted by XpKiller*:

 

New Version out: 3.0.2.0 Final

 

Download in First Post and also via the Procon Packetmanagement

 

Changelog:

3.0.2.0

Now able to pull Stats from BFBCS and able to warn/kick/ban Player with high kdr and high Score per Minute (Globalstats)

The Stats of BFBCS will be stored in the DB to reduce stress on BFBCS api.

The Updateinterval (in hours) for the BFBCS Stats is variable and configurable (pls dont choose to low values)

The plugin fetches up to 32 Players in one query from BFBCS and is able to repair JSON Objects containing Error messages from BFBCS API.

The plugin tries to get the stats onetime only at the moment.

Some Improvements in Code

Cheater and Statspadder Protection based on Globalstats of BFBCS with configurable Limits and minimum values.

Chatlog can be turned off now

Option for Update empty PB-Guids(not recommend)

Added Servertimeoffset feature

[ImportBot]

Originally Posted by EBassie*:

 

Hey XpKiller,

 

nice work!

But for some reason changing some settings in the settingspanel of this plugin crashes my local Procon.

Seems when enabling chat logging caused the crashes.

My procon layer keeps running without problems though.

 

I had to restart procon multiple times to set the settings for my 3 servers.

Hope I don't have to change something soon

 

Thanks for the update!

[ImportBot]

Originally Posted by XpKiller*:

 

i didnt had such problems but i will take a look at i try to reproduce and fix it.

[ImportBot]

Originally Posted by haclevan*:

 

Hi,

Since a few hours I became this error message:

Error in DownloadBFBCS: System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler.

bei System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)

bei System.Net.WebClient.DownloadString(Uri address)

bei PRoConEvents.CChatGUIDStatsLogger.DownloadBFBCS(Ob ject ListObject)

Before it works fine and the the bfbcs table is full of entires.

Do you know the problem?

Regards, Ha

[ImportBot]

Originally Posted by XpKiller*:

 

Hi,

Since a few hours I became this error message:

Error in DownloadBFBCS: System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler.

bei System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)

bei System.Net.WebClient.DownloadString(Uri address)

bei PRoConEvents.CChatGUIDStatsLogger.DownloadBFBCS(Ob ject ListObject)

Before it works fine and the the bfbcs table is full of entires.

Do you know the problem?

Regards, Ha

This is not a error of my plugin its an error of the BFBCS Server.

500 Internal Server Error

Dies ist ein "Sammel-Statuscode" für unerwartete Serverfehler.

500 Internal Server Error

This is an unexpected of the Webserver.

 

So i cant fix it, but it shouldn't disturb the plugin web request a run in a own Thread.

[ImportBot]

Originally Posted by Joshman2934*:

 

i keep getting this error everytime the server changes round

im using www.freesql.org

Code:

[17:40:36 15] OnLoadingLevel: Levels/MP_003 Round: 1/1
[17:40:36 15] update sql server
[17:40:36 15] Start tablebuilder
[17:40:36 93] OdbcCon open
[17:40:38 68] Your Weapontable is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls
[17:40:39 47] Setting playlist to: RUSH
[17:40:39 47] Clearing the maplist
[17:40:39 47] Adding levels/mp_006 to the maplist with 2 rounds
[17:40:39 51] OdbcConn open
[17:40:40 07] Error in Startstreaming: 
[17:40:40 07] Index #0
[17:40:40 07] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.16-standard-log]Got error -1 from storage engine
[17:40:40 07] Native: 1030
[17:40:40 07] Source: myodbc5.dll
[17:40:40 07] SQL: HY000
[17:40:40 07] Connection OdbcCon closed
[17:40:40 29] Connection OdbcConn closed

[ImportBot]

Originally Posted by Legate*:

 

XpKiller,

 

It is possible to include the stats in the welcome message? (show the player stats in yell)

 

Thanks,

[ImportBot]

Originally Posted by EBassie*:

 

XpKiller,

 

I just found a couple of player-records that were incomplete.

The players were in table "tbl_playerdata", but were absent in table "tbl_playerstats".

So their records were only half saved.

 

If the player has been saved in playerdata and the playerstats record is not created, does the plugin fix this itself and automatically create the record another time when the player is in the server?

 

For other people who want to check if the stats are complete. Here are two queries to check.

 

Check if all record ID's in playerdata are in playerstats:

Code:

SELECT * FROM tbl_playerdata
WHERE tbl_playerdata.PlayerID
NOT IN (
SELECT tbl_playerstats.StatsID
FROM tbl_playerstats
WHERE tbl_playerdata.PlayerID=tbl_playerstats.StatsID
)

Check if all record ID's in playerstats are in playerdata:

Code:

SELECT * FROM tbl_playerstats
WHERE tbl_playerstats.StatsID
NOT IN (
SELECT tbl_playerdata.PlayerID
FROM tbl_playerdata
WHERE tbl_playerstats.StatsID=tbl_playerdata.PlayerID
)

[ImportBot]

Originally Posted by XpKiller*:

 

These entries are no problem the plugin will create the rest afterwards So dont worry about this.

These entries may come incomplete Streaming process were a rollback has been performed. But i keep an eye on this.

[ImportBot]

Originally Posted by XpKiller*:

 

i keep getting this error everytime the server changes round

im using http://www.freesql.org

Code:

[17:40:36 15] OnLoadingLevel: Levels/MP_003 Round: 1/1
[17:40:36 15] update sql server
[17:40:36 15] Start tablebuilder
[17:40:36 93] OdbcCon open
[17:40:38 68] Your Weapontable is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls
[17:40:39 47] Setting playlist to: RUSH
[17:40:39 47] Clearing the maplist
[17:40:39 47] Adding levels/mp_006 to the maplist with 2 rounds
[17:40:39 51] OdbcConn open
[17:40:40 07] Error in Startstreaming: 
[17:40:40 07] Index #0
[17:40:40 07] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.16-standard-log]Got error -1 from storage engine
[17:40:40 07] Native: 1030
[17:40:40 07] Source: myodbc5.dll
[17:40:40 07] SQL: HY000
[17:40:40 07] Connection OdbcCon closed
[17:40:40 29] Connection OdbcConn closed

Hi

An other user got these Error to a couple of month ago, As far as i know it these error not plugin related, it is a MYSQL Bug. The Version of MySQL is really really old on http://www.freesql.org, they using 5.0.16 the latest is 5.5.8.

So im sry but i cant do anything. Also it is possible that you data is corrupt now