Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by Legate*:

 

Polak, I have been using this plugin since december 2010 (BC2/BF3 servers) and my SQL Datafiles just uses 350 megas of space.

[ImportBot]

Originally Posted by 0mni*:

 

[00:41:11 46] Error: Error in Startstreaming:

[00:41:11 46] Index #0

[00:41:11 46] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.21-log]Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

[00:41:11 46] Native: 1665

[00:41:11 46] Source: myodbc5.dll

[00:41:11 46] SQL: HY000

[00:41:11 48] Error: Error in UpdateRanking:

[00:41:11 48] Index #0

[00:41:11 48] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.21-log]Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

[00:41:11 48] Native: 1665

[00:41:11 48] Source: myodbc5.dll

[00:41:11 48] SQL: HY000

Getting thsi error message

[ImportBot]

Originally Posted by XpKiller*:

 

@0mni

search for "IsolationLevel.ReadCommitted"

and replace it with nothing

example:

Tx = Con.BeginTransaction(IsolationLevel.ReadCommitted) ; --> Tx = Con.BeginTransaction();

 

 

I will change that in next release.

[ImportBot]

Originally Posted by Neliscornelis*:

 

Hi,

 

I updated this plugin to 1.0.0.6 but now i dont see the stats spammed.. I only see "Welcome back to our server , Neliscornelis"

 

No errors in plugin log and !rank works fine..

 

Am i missing something?

 

EDIT: I see the welcome message changed.. Can i just paste this:

 

Serverstats for %playerName%:

Score: %playerScore% %playerKills% Kills %playerHeadshots% HS %playerDeaths% Deaths K/D: %playerKDR%

Your Serverrank is: %playerRank% of %allRanks%

 

in the welcomes array?

[ImportBot]

Originally Posted by XpKiller*:

 

@Neliscornelis

Correct you got it

[ImportBot]

Originally Posted by Sagittaire88*:

 

Hello,

 

Since the update it can not count the stats map.

 

The server has many other stats.

 

Sorry for my english I'm french, translation with google

[ImportBot]

Originally Posted by XpKiller*:

 

@Sagittaire88

 

Sorry i don't understand you. Could you be a bit more detailed.

 

Update from which version?

[ImportBot]

Originally Posted by Sagittaire88*:

 

Hi ,

 

since the last version 1.0.0.6, the map stats does not work on some cards

 

The stats of the player works, in game is good.

 

The stats on my server: http://www.team-b2p.fr/index.php_fil...ts_serveur_Bf3

 

thank you

[ImportBot]

Originally Posted by XpKiller*:

 

no changes has been done to the mapsstats in the version 1.0.0.6

 

Please keep in mind that ea changed the name of some cards in the r20 patch. This might be breaking the webstats script.

[ImportBot]

Originally Posted by Sagittaire88*:

 

ok thank you for your reply

[ImportBot]

Originally Posted by KK-FooKaa*:

 

Hi,

 

I have set this plugin up, created a database on my webhosting and im getting errors. I contacted my host and they said they have unblocked my IP im coming from (procon is set up on my VPS).

 

My host said this

If you still face any issue please update us how you are trying to connect to ODBC database? so that we we will check this for you.

What else do i need to do ?

 

Thanks in advance

 

This is what im seeing on procon

 

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 0

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by bbashy*:

 

Thanks for the plugin, great work!

[ImportBot]

Originally Posted by XpKiller*:

 

@=]KK[=FooKaa

 

How often do get this error?

[ImportBot]

Originally Posted by KK-FooKaa*:

 

@=]KK[=FooKaa

 

How often do get this error?

Hi,

 

I was using a 2nd database on my webhosting which i could just not get to work.

 

I basically have a Windows VPS server running Procon and now i have installed mysql and it seems to connect at last.....

[ImportBot]

Originally Posted by Krankenschwester*:

 

Hi,

 

i get some strange errors... (v 1.0.0.6)

 

Error: Error in Startstreaming: System.ArgumentOutOfRangeException: Index is less than 0 or more than or equal to the list count.

Parameter name: index

0

at System.Collections.ArrayList.ThrowNewArgumentOutOf RangeException (System.String name, System.Object actual, System.String message) [0x00000] in :0

at System.Collections.ArrayList.get_Item (Int32 index) [0x00000] in :0

at System.Data.Odbc.OdbcErrorCollection.get_Item (Int32 i) [0x00000] in :0

at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g () [0x00000] in :0

 

any suggestions?

 

aditionally i get some strange entrys into database like:

 

tbl_chatlog

 

ID/logDate/ServerID/logSubset/logSoldierName/logMessage

1/2012-05-03 00:21:01/2/___/___/________o\

2/2012-05-03 00:22:18/2/___/___/? _\?

 

other tables show the same... any ideas what i can do?

[ImportBot]

Originally Posted by XpKiller*:

 

@Krankenschwester

how often do you get this error.

 

Please turn on trace and upload the logs.

[ImportBot]

Originally Posted by Krankenschwester*:

 

@Krankenschwester

how often do you get this error.QUOTE]

 

It happens every round and after a while procon crashes.

 

a little snippet from the actual log...

 

[21:20:12] BF3 Chat' date=' GUID and Stats Logger Enabled

[21:20:12'] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[21:20:12] Info: Table suffix set to

[21:20:12] Trace: generateWeaponList

[21:20:12] Trace: PrepareKeywordDic: Preparing

[21:20:12] Trace: Weaponlist: DamageType: Shotgun Name: 870MCS

[21:20:12] Trace: Weaponlist: DamageType: Shotgun Name: DAO-12

[21:20:12] Trace: Weaponlist: DamageType: Shotgun Name: jackhammer

[21:20:12] Trace: Weaponlist: DamageType: Shotgun Name: M1014

[21:20:12] Trace: Weaponlist: DamageType: Shotgun Name: M26Mass

[21:20:12] Trace: Weaponlist: DamageType: Shotgun Name: Siaga20k

[21:20:12] Trace: Weaponlist: DamageType: Shotgun Name: USAS-12

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: AEK-971

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: AN-94 Abakan

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: AS Val

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: F2000

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: FAMAS

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: HK53

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: M16A4

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: QBZ-95

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/AK74M/AK74

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/G3A3/G3A3

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/KH2002/KH2002

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/M416/M416

[21:20:12] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/XP1_L85A2/L85A2

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: AKS-74u

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: M4A1

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: MP7

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: PP-2000

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: SG 553 LB

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: Weapons/A91/A91

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: Weapons/G36C/G36C

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: Weapons/MagpulPDR/MagpulPDR

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: Weapons/P90/P90

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: Weapons/SCAR-H/SCAR-H

[21:20:12] Trace: Weaponlist: DamageType: SMG Name: Weapons/UMP45/UMP45

[21:20:12] Trace: Weaponlist: DamageType: None Name: Death

[21:20:12] Trace: Weaponlist: DamageType: None Name: Roadkill

[21:20:12] Trace: Weaponlist: DamageType: Melee Name: Defib

[21:20:12] Trace: Weaponlist: DamageType: Melee Name: Melee

[21:20:12] Trace: Weaponlist: DamageType: Melee Name: Repair Tool

[21:20:12] Trace: Weaponlist: DamageType: Melee Name: Weapons/Knife/Knife

[21:20:12] Trace: Weaponlist: DamageType: ProjectileExplosive Name: FGM-148

[21:20:12] Trace: Weaponlist: DamageType: ProjectileExplosive Name: FIM92

[21:20:12] Trace: Weaponlist: DamageType: ProjectileExplosive Name: M320

[21:20:12] Trace: Weaponlist: DamageType: ProjectileExplosive Name: RPG-7

[21:20:12] Trace: Weaponlist: DamageType: ProjectileExplosive Name: SMAW

[21:20:12] Trace: Weaponlist: DamageType: ProjectileExplosive Name: Weapons/Sa18IGLA/Sa18IGLA

[21:20:12] Trace: Weaponlist: DamageType: Handgun Name: Glock18

[21:20:12] Trace: Weaponlist: DamageType: Handgun Name: M1911

[21:20:12] Trace: Weaponlist: DamageType: Handgun Name: M9

[21:20:12] Trace: Weaponlist: DamageType: Handgun Name: M93R

[21:20:12] Trace: Weaponlist: DamageType: Handgun Name: Taurus .44

[21:20:12] Trace: Weaponlist: DamageType: Handgun Name: Weapons/MP412Rex/MP412REX

[21:20:12] Trace: Weaponlist: DamageType: Handgun Name: Weapons/MP443/MP443

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: L96

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: M39

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: M40A5

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: Mk11

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: Model98B

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: QBU-88

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: SKS

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: SV98

[21:20:12] Trace: Weaponlist: DamageType: SniperRifle Name: SVD

[21:20:12] Trace: Weaponlist: DamageType: Explosive Name: M15 AT Mine

[21:20:12] Trace: Weaponlist: DamageType: Explosive Name: M67

[21:20:12] Trace: Weaponlist: DamageType: Explosive Name: Weapons/Gadgets/C4/C4

[21:20:12] Trace: Weaponlist: DamageType: Explosive Name: Weapons/Gadgets/Claymore/Claymore

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: M240

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: M249

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: M27IAR

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: M60

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: MG36

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: Pecheneg

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: PP-19

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: QBB-95

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: RPK-74M

[21:20:12] Trace: Weaponlist: DamageType: LMG Name: Type88

[21:20:12] Trace: Weaponlist: DamageType: Nonlethal Name: Medkit

[21:20:14] Info: Start tablebuilder

[21:20:14] Trace: generateWeaponList

[21:20:14] Trace: PrepareKeywordDic: Preparing

[21:20:14] Trace: Weaponlist: DamageType: Shotgun Name: 870MCS

[21:20:14] Trace: Weaponlist: DamageType: Shotgun Name: DAO-12

[21:20:14] Trace: Weaponlist: DamageType: Shotgun Name: jackhammer

[21:20:14] Trace: Weaponlist: DamageType: Shotgun Name: M1014

[21:20:14] Trace: Weaponlist: DamageType: Shotgun Name: M26Mass

[21:20:14] Trace: Weaponlist: DamageType: Shotgun Name: Siaga20k

[21:20:14] Trace: Weaponlist: DamageType: Shotgun Name: USAS-12

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: AEK-971

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: AN-94 Abakan

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: AS Val

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: F2000

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: FAMAS

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: HK53

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: M16A4

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: QBZ-95

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/AK74M/AK74

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/G3A3/G3A3

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/KH2002/KH2002

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/M416/M416

[21:20:14] Trace: Weaponlist: DamageType: AssaultRifle Name: Weapons/XP1_L85A2/L85A2

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: AKS-74u

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: M4A1

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: MP7

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: PP-2000

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: SG 553 LB

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: Weapons/A91/A91

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: Weapons/G36C/G36C

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: Weapons/MagpulPDR/MagpulPDR

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: Weapons/P90/P90

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: Weapons/SCAR-H/SCAR-H

[21:20:14] Trace: Weaponlist: DamageType: SMG Name: Weapons/UMP45/UMP45

[21:20:14] Trace: Weaponlist: DamageType: None Name: Death

[21:20:14] Trace: Weaponlist: DamageType: None Name: Roadkill

[21:20:14] Trace: Weaponlist: DamageType: Melee Name: Defib

[21:20:14] Trace: Weaponlist: DamageType: Melee Name: Melee

[21:20:14] Trace: Weaponlist: DamageType: Melee Name: Repair Tool

[21:20:14] Trace: Weaponlist: DamageType: Melee Name: Weapons/Knife/Knife

[21:20:14] Trace: Weaponlist: DamageType: ProjectileExplosive Name: FGM-148

[21:20:14] Trace: Weaponlist: DamageType: ProjectileExplosive Name: FIM92

[21:20:14] Trace: Weaponlist: DamageType: ProjectileExplosive Name: M320

[21:20:14] Trace: Weaponlist: DamageType: ProjectileExplosive Name: RPG-7

[21:20:14] Trace: Weaponlist: DamageType: ProjectileExplosive Name: SMAW

[21:20:14] Trace: Weaponlist: DamageType: ProjectileExplosive Name: Weapons/Sa18IGLA/Sa18IGLA

[21:20:14] Trace: Weaponlist: DamageType: Handgun Name: Glock18

[21:20:14] Trace: Weaponlist: DamageType: Handgun Name: M1911

[21:20:14] Trace: Weaponlist: DamageType: Handgun Name: M9

[21:20:14] Trace: Weaponlist: DamageType: Handgun Name: M93R

[21:20:14] Trace: Weaponlist: DamageType: Handgun Name: Taurus .44

[21:20:14] Trace: Weaponlist: DamageType: Handgun Name: Weapons/MP412Rex/MP412REX

[21:20:14] Trace: Weaponlist: DamageType: Handgun Name: Weapons/MP443/MP443

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: L96

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: M39

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: M40A5

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: Mk11

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: Model98B

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: QBU-88

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: SKS

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: SV98

[21:20:14] Trace: Weaponlist: DamageType: SniperRifle Name: SVD

[21:20:14] Trace: Weaponlist: DamageType: Explosive Name: M15 AT Mine

[21:20:14] Trace: Weaponlist: DamageType: Explosive Name: M67

[21:20:14] Trace: Weaponlist: DamageType: Explosive Name: Weapons/Gadgets/C4/C4

[21:20:14] Trace: Weaponlist: DamageType: Explosive Name: Weapons/Gadgets/Claymore/Claymore

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: M240

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: M249

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: M27IAR

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: M60

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: MG36

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: Pecheneg

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: PP-19

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: QBB-95

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: RPK-74M

[21:20:14] Trace: Weaponlist: DamageType: LMG Name: Type88

[21:20:14] Trace: Weaponlist: DamageType: Nonlethal Name: Medkit

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_shotgun is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_assaultrifle is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_smg is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_none is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_melee is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_projectileexplosive is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_handgun is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_sniperrifle is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_explosive is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_lmg is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck Weapons

[21:20:14] Info: The table tbl_weapons_nonlethal is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[21:20:14] Trace: Tablecheck playerstats

[21:20:14] Trace: Tablecheck tbl_server

[21:20:37] [xVotemap] Info: Estimated voting start in 5 minutes, 17 seconds @ 21:25:54

[21:21:07] [xVotemap] Info: Estimated voting start in 2 minutes, 17 seconds @ 21:23:24

[21:21:37] [xVotemap] Info: Estimated voting start in 18 minutes, 30 seconds @ 21:40:07

[21:22:07] [xVotemap] Info: Estimated voting start in 4 minutes, 7 seconds @ 21:26:14

[21:22:13] Trace: playerLeftServer: v3ntorian EAGUID:

[21:22:13] Trace: Score: 860 Playtime: 413

[21:22:13] Trace: Adding Session of Player v3ntorian to passed sessions

[21:22:37] [xVotemap] Info: Estimated voting start in 3 minutes, 34 seconds @ 21:26:11

[21:23:07] [xVotemap] Info: Estimated voting start in 3 minutes, 6 seconds @ 21:26:13

[21:23:37] [xVotemap] Info: Estimated voting start in 3 minutes, 37 seconds @ 21:27:14

[21:23:57] Trace: playerLeftServer: Teepoettchen EAGUID:

[21:23:57] Trace: Score: 1724 Playtime: 1256

[21:23:57] Trace: Adding Session of Player Teepoettchen to passed sessions

[21:24:07] [xVotemap] Info: Estimated voting start in 1 minutes, 19 seconds @ 21:25:26

[21:24:37] [xVotemap] Info: Estimated voting start 50 seconds ago, @ 21:23:47

[21:24:41] [xVotemap] Info: Teheran Highway [CQ] was removed from maplistoptions.

[21:24:42] [xVotemap] Info: No flexiblity in displayed map options

[21:24:43] [xVotemap] Info: Votemap Options: Operation Metro [CQ] | Kharg Island [CQ] | Seine Crossing [CQ] | Grand Bazaar [CQ] | Noshahr Canals [CQ] | Damavand Peak [CQ]

[21:24:43] [xVotemap] Work: Displayed vote banner

[21:24:44] [xVotemap] Info: Voting poll: Started!

[21:25:06] Trace: Weapon: Suicide is missing in the bf3.def file!!!

[21:25:07] [xVotemap] Info: Voting duration: 25 seconds.

[21:25:37] [xVotemap] Info: Voting duration: 55 seconds.

[21:26:03] [xVotemap] Info: zghor voted for Operation Metro [CQ]

[21:26:07] [xVotemap] Info: Voting duration: 1 minutes, 25 seconds.

[21:26:37] [xVotemap] Info: Voting duration: 1 minutes, 55 seconds.

[21:27:06] Trace: playerLeftServer: johannessahlin EAGUID: EA_FBA63D0EF61C084457487410EDD6E305

[21:27:06] Trace: Score: 2677 Playtime: 1965

[21:27:06] Trace: Adding Session of Player johannessahlin to passed sessions

[21:27:07] [xVotemap] Info: Voting duration: 2 minutes, 25 seconds.

[21:27:12] Trace: Weapon: SoldierCollision is missing in the bf3.def file!!!

[21:27:33] Trace: playerLeftServer: zaall EAGUID:

[21:27:33] Trace: Score: 570 Playtime: 398

[21:27:33] Trace: Adding Session of Player zaall to passed sessions

[21:27:37] [xVotemap] Info: Voting duration: 2 minutes, 55 seconds.

[21:27:40] [xVotemap] Info: lekokeur voted for Damavand Peak [CQ]

[21:27:54] Trace: playerLeftServer: gotit177 EAGUID: EA_43134DCD5FB38D2C06EDB585D3F4A855

[21:27:54] Trace: Score: 9911 Playtime: 2730

[21:27:54] Trace: Adding Session of Player gotit177 to passed sessions

[21:27:55] [xVotemap] Info: 3Things voted for Seine Crossing [CQ]

[21:28:07] [xVotemap] Info: Voting duration: 3 minutes, 25 seconds.

[21:28:37] [xVotemap] Info: Voting duration: 3 minutes, 55 seconds.

[21:28:39] Trace: playerLeftServer: Ullimon76 EAGUID: EA_70385D985CFBB33D43D007F477057905

[21:28:39] Trace: Score: 3740 Playtime: 1404

[21:28:39] Trace: Adding Session of Player Ullimon76 to passed sessions

[21:28:42] [xVotemap] Info: Winning vote tie, Damavand Peak [CQ] randomly selected as winner.

[21:28:42] [xVotemap] Info: Voting Ended. 10% of the players voted.

[21:28:42] [xVotemap] Info: Votes: Operation Metro [CQ]: 1

[21:28:42] [xVotemap] Info: Votes: Kharg Island [CQ]: 0

[21:28:42] [xVotemap] Info: Votes: Seine Crossing [CQ]: 1

[21:28:42] [xVotemap] Info: Votes: Grand Bazaar [CQ]: 0

[21:28:42] [xVotemap] Info: Votes: Noshahr Canals [CQ]: 0

[21:28:42] [xVotemap] Info: Votes: Damavand Peak [CQ]: 1

[21:28:42] [xVotemap] Info: Damavand Peak [CQ] Won

[21:29:22] Trace: playerLeftServer: KanesFather EAGUID: EA_3A5164DEB984CC5235644AF0F876C65D

[21:29:22] Trace: Score: 950 Playtime: 385

[21:29:22] Trace: Adding Session of Player KanesFather to passed sessions

[21:30:12] [xVotemap] Work: Displayed next map

[21:30:14] Trace: playerLeftServer: levelup58 EAGUID:

[21:30:14] Trace: Score: 0 Playtime: 132

[21:30:14] Trace: Adding Session of Player levelup58 to passed sessions

[21:30:16] Trace: OnRoundOver: TeamId -> 2

[21:30:16] [xVotemap] Work: Round Over: Stopping voting system

[21:30:16] Trace: OnRoundOverPlayers Event

[21:30:40] Trace: playerLeftServer: i_zozulya EAGUID:

[21:30:40] Trace: Score: 2300 Playtime: 1470

[21:30:40] Trace: Adding Session of Player i_zozulya to passed sessions

[21:30:42] Trace: playerLeftServer: Comics971 EAGUID:

[21:30:43] Trace: Score: 1000 Playtime: 1788

[21:30:43] Trace: Adding Session of Player Comics971 to passed sessions

[21:30:54] Trace: playerLeftServer: lekokeur EAGUID:

[21:30:54] Trace: Score: 4326 Playtime: 1721

[21:30:54] Trace: Adding Session of Player lekokeur to passed sessions

[21:31:33] Info: OnLevelLoaded: MP_013 Gamemode: ConquestSmall0 Round: 0/1

[21:31:33] Info: update sql server

[21:31:33] Info: Started streaming to the DB-Server

[21:31:33] Info: OdbcConn was close, Reopen it, Current State is open

[21:31:33] Trace: Mapstats Write querys

[21:31:33] [xVotemap] Info: Level loaded: Damavand Peak [CQ], Round 1 of 1

[21:31:33] [xVotemap] Work: Level loaded: Last round detected, starting voting system

[21:31:33] Trace: PlayerStats Write querys

[21:31:33] Trace: Adding EAGUID EA_A85693F7C83E872DB3ED527265B50CE1 to searchlist

[21:31:33] Trace: Adding EAGUID EA_91F49EE18DE24A57034292FCF14FE276 to searchlist

[21:31:33] Trace: Adding EAGUID EA_F06240086B7DC61D9E6B7362452BDA99 to searchlist

[21:31:33] Trace: Adding EAGUID EA_C0F3A83C46ABEF4F2565A21666CD1ECA to searchlist

[21:31:33] Trace: Adding EAGUID EA_90BFE1D8A48EF0C68A1B94FCE21C850B to searchlist

[21:31:33] Trace: Adding EAGUID EA_198226C82238105474A95ACB30A98492 to searchlist

[21:31:33] Trace: Adding EAGUID EA_5F1A646F1FBE34C974A2C155C7C0F2E0 to searchlist

[21:31:33] Trace: Adding EAGUID EA_43134DCD5FB38D2C06EDB585D3F4A855 to searchlist

[21:31:33] Trace: Adding EAGUID EA_046C330D49E6FB1FC1AB0A2684375C66 to searchlist

[21:31:33] Trace: Adding EAGUID EA_387DB63FD5AFE7943252DACF55E175AC to searchlist

[21:31:33] Trace: Adding EAGUID EA_ACB4D6F03E60CD39EEB180B512517CEC to searchlist

[21:31:33] Trace: Adding EAGUID EA_CD016B3C9F09A3CA92A94D9872B08F6C to searchlist

[21:31:33] Trace: Adding EAGUID EA_3423C450BF7FC606CE50C419E51B9B43 to searchlist

[21:31:33] Trace: Adding EAGUID EA_2AE90F14E4F0485A1555E844B98993FE to searchlist

[21:31:33] Trace: Adding EAGUID EA_C9EC0364EA78F06B28B375927F0491C3 to searchlist

[21:31:33] Trace: Adding EAGUID EA_16677342281BDD40DFB297FAE92A57E2 to searchlist

[21:31:33] Trace: Adding EAGUID EA_70385D985CFBB33D43D007F477057905 to searchlist

[21:31:33] Trace: Adding EAGUID EA_87CF42E40788B943B5EE35D72D464E84 to searchlist

[21:31:33] Trace: Adding EAGUID EA_E4543D55BB206B7FFC78F912C1E41CFC to searchlist

[21:31:33] Trace: Adding EAGUID EA_861A4F671FDF89C26E14498AB02A59CD to searchlist

[21:31:33] Trace: Adding EAGUID EA_584692D76E19CC33948846BA3920D734 to searchlist

[21:31:33] Trace: Adding EAGUID EA_FCB4E7E5F3B3D2635E64894A4368BD95 to searchlist

[21:31:33] Trace: Adding EAGUID EA_FBA63D0EF61C084457487410EDD6E305 to searchlist

[21:31:33] Trace: Adding EAGUID EA_FB03383D387837EBC646217032E49756 to searchlist

[21:31:33] Trace: Adding EAGUID EA_DFC83D7224B19CF71CF89650EDA3F400 to searchlist

[21:31:33] Trace: Adding EAGUID EA_94BA57E2E7EDE7B16125222EF6CC6B61 to searchlist

[21:31:33] Trace: Adding EAGUID EA_16197A988630789AD2567222DC1BE37F to searchlist

[21:31:33] Trace: Adding EAGUID EA_04383283B754E538796A604084F04DA1 to searchlist

[21:31:33] Trace: Adding EAGUID EA_C9DC99FBD0206381E642923C61592A2D to searchlist

[21:31:33] Trace: Adding EAGUID EA_DC0E341E8840CD3F7552D030DF246386 to searchlist

[21:31:33] Trace: Adding EAGUID EA_3ECAF9A217B574771D42D8AC2D128CCC to searchlist

[21:31:33] Trace: Adding EAGUID EA_735219E19A3CD1611A8F5A3675358427 to searchlist

[21:31:33] Trace: Adding EAGUID EA_737496B6FEB6CC353B849B24A9679BF2 to searchlist

[21:31:33] Trace: Adding EAGUID EA_42969DEC82FEB8EB85C14F75244DF35F to searchlist

[21:31:33] Trace: Adding EAGUID EA_7C900AFE22D0D50B356154CEA5CB2FE2 to searchlist

[21:31:33] Trace: Adding EAGUID EA_3A5164DEB984CC5235644AF0F876C65D to searchlist

[21:31:33] Trace: Adding EAGUID EA_CEB9766E8C8B11982CA729FC088A6110 to searchlist

[21:31:33] Trace: Adding EAGUID EA_1087165682F80660B4009429CDAA6BF7 to searchlist

[21:31:33] Trace: Adding EAGUID EA_2BCBDECF2C1634AECC1F657DBC39630C to searchlist

[21:31:33] Trace: Adding EAGUID EA_2CCF9D2A388C2BBD67712DEA2B8827FF to searchlist

[21:31:33] Trace: Adding EAGUID EA_9BF6C167971266687B80C426B54D7D5C to searchlist

[21:31:33] Trace: Adding EAGUID EA_86C08C8FA6DA3868F4D806FE79F289E4 to searchlist

[21:31:33] Trace: Adding EAGUID EA_E065DB171E5692F2717DD8DEA9CE3473 to searchlist

[21:31:33] Trace: Adding EAGUID EA_0B3C2BFB84FD24DD8B2BAAE1AEC00F53 to searchlist

[21:31:33] Trace: Insert for Player tomsetsfire

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName tomsetsfire

[21:31:33] Trace: PBGUID d519a55bbc1c7ac2b869a7b21a8f42de

[21:31:33] Trace: EAGUID EA_A85693F7C83E872DB3ED527265B50CE1

[21:31:33] Trace: IP_Address 79.222.193.4

[21:31:33] Trace: CountryCode de

[21:31:33] Trace: Insert for Player Lydhagen

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName Lydhagen

[21:31:33] Trace: PBGUID 1aba366a5fb16249bd15eb91240bd9b9

[21:31:33] Trace: EAGUID EA_91F49EE18DE24A57034292FCF14FE276

[21:31:33] Trace: IP_Address 81.167.113.200

[21:31:33] Trace: CountryCode no

[21:31:33] Trace: Insert for Player ObiNaldO

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName ObiNaldO

[21:31:33] Trace: PBGUID e084af9de187f9ae88d8571da2c7bb1a

[21:31:33] Trace: EAGUID EA_F06240086B7DC61D9E6B7362452BDA99

[21:31:33] Trace: IP_Address 90.186.106.200

[21:31:33] Trace: CountryCode de

[21:31:33] Trace: Insert for Player DrAnonym

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName DrAnonym

[21:31:33] Trace: PBGUID 681aff37a9b978d62e6139180d41db0c

[21:31:33] Trace: EAGUID EA_C0F3A83C46ABEF4F2565A21666CD1ECA

[21:31:33] Trace: IP_Address 93.82.110.202

[21:31:33] Trace: CountryCode at

[21:31:33] Trace: Insert for Player Glueckswurscht

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName Glueckswurscht

[21:31:33] Trace: PBGUID aac6737fd68d5fb9c9231a89dd371387

[21:31:33] Trace: EAGUID EA_90BFE1D8A48EF0C68A1B94FCE21C850B

[21:31:33] Trace: IP_Address 31.16.120.213

[21:31:33] Trace: CountryCode de

[21:31:33] Trace: Insert for Player ZeroKoo1

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName ZeroKoo1

[21:31:33] Trace: PBGUID cc783b762646db7279dccb8a1d2476d3

[21:31:33] Trace: EAGUID EA_198226C82238105474A95ACB30A98492

[21:31:33] Trace: IP_Address 87.202.30.54

[21:31:33] Trace: CountryCode gr

[21:31:33] Trace: Insert for Player Comics971

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName Comics971

[21:31:33] Trace: PBGUID fae03a7b2f8489a7a57a1445b5ac6bd9

[21:31:33] Trace: EAGUID EA_5F1A646F1FBE34C974A2C155C7C0F2E0

[21:31:33] Trace: IP_Address 88.182.213.12

[21:31:33] Trace: CountryCode fr

[21:31:33] Trace: Insert for Player gotit177

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName gotit177

[21:31:33] Trace: PBGUID c892cb19b1bf6a77edb7ed7d6252eb18

[21:31:33] Trace: EAGUID EA_43134DCD5FB38D2C06EDB585D3F4A855

[21:31:33] Trace: IP_Address 91.47.250.130

[21:31:33] Trace: CountryCode de

[21:31:33] Trace: Insert for Player Mission3000

[21:31:33] Trace: ClanTag

[21:31:33] Trace: SoldierName Mission3000

[21:31:33] Trace: PBGUID b72ccf926ba3a6a958dbf47c7d7c7966

[21:31:33] Trace: EAGUID EA_046C330D49E6FB1FC1AB0A2684375C66

[21:31:33] Trace: IP_Address 94.216.196.49

[21:31:33] Trace: CountryCode de

[21:31:33] Error: Error in Startstreaming:

[21:31:33] Index #0

[21:31:33] Native: 1062

[21:31:33] Source: libmyodbc5.so

[21:31:33] SQL: 23000

[21:31:33] Info: Connection OdbcConn closed

[21:31:43] Trace: playerLeftServer: maysn EAGUID: EA_C9DC99FBD0206381E642923C61592A2D

[21:31:43] Trace: Score: 6062 Playtime: 1015

[21:31:43] Trace: Adding Session of Player maysn to passed sessions

[21:32:07] [xVotemap] Info: Estimated voting start in 2 hours, 42 minutes, 39 seconds @ 00:14:46

[21:32:29] Trace: Weapon: DamageArea is missing in the bf3.def file!!!

[21:32:37] [xVotemap] Info: Estimated voting start in 2 hours, 42 minutes, 39 seconds @ 00:15:16

[21:33:07] [xVotemap] Info: Estimated voting start in 11 minutes, 15 seconds @ 21:44:22

[21:33:37] [xVotemap] Info: Estimated voting start in 7 minutes, 43 seconds @ 21:41:20

[21:34:07] [xVotemap] Info: Estimated voting start in 5 minutes, 6 seconds @ 21:39:13

[21:34:27] [xVotemap] Info: Estimated voting start in 5 minutes, 17 seconds @ 21:39:44

[21:34:49] Trace: Weapon: DamageArea is missing in the bf3.def file!!!

[ImportBot]

Originally Posted by Athlon*:

 

Dude - you gotta learn how to use

[ImportBot]

Originally Posted by XpKiller*:

 

@Krankenschwester

You are running it under linux right?

It hasn't been tested under Linux. So it very possible that this causes the bug.

Anyway you have an different error here.

[ImportBot]

Originally Posted by Dudenell*:

 

what would be the best way to check names with the EA guid while using this plugin? Thank you.

[ImportBot]

Originally Posted by Krankenschwester*:

 

@Krankenschwester

You are running it under linux right?

Right, im using it under Debian 6 with mono 2.4

 

myodbc5.so is registred and works fine.

[ImportBot]

Originally Posted by ty_ger07*:

 

what would be the best way to check names with the EA guid while using this plugin? Thank you.

Don't understand the question. You want to associate a person's GUID with their name? Look at the tbl_playerdata table and you will see that the player name, EA GUID, and PB GUID are all associated with eachother already. Just find the player of interest by searching through the database or use a query.

[ImportBot]

Originally Posted by XpKiller*:

 

@Krankenschwester

i have not this plugin tested under linux with mono. I dont this there is a bug in the plugin itself. But might be in mono.

Please update your mono to the latest stable 2.10.8. Older releases of mono were buggy.

 

Then try again.

[ImportBot]

Originally Posted by Krankenschwester*:

 

@Krankenschwester

Please update your mono to the latest stable 2.10.8. Older releases of mono were buggy.

highest stable version for Squeeze (Debian6) is 2.6.7... upgrade to this Version doesnt seem to fix this issue...

 

I'll test it on SID this weekend...

 

anyone else here using this plugin with mono?

[ImportBot]

Originally Posted by Krankenschwester*:

 

Same error with 2.10.8....

 

[ImportBot]

Originally Posted by XpKiller*:

 

hmm it seems mono is bugged here.

if i have some time i will reproduce this on my linux vm.

[ImportBot]

Originally Posted by BL4CKSH4D0W*:

 

Thanks in advance for any help. The plugin seems to have created the correct fields in the database. It seems however its not logging any data. And if I try to request stats using "!stats" it always says to wait until the next round. I am getting this error so I assume its related.

 

 

[08:15:32 50] Error: Error in Startstreaming:

[08:15:32 53] Index #0

[08:15:32 54] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.23]Incorrect datetime value: '2012-05-09 08:05:04.296000000' for column 'FirstSeenOnServer' at row 1

[08:15:32 54] Native: 1292

[08:15:32 57] Source: myodbc5.dll

[08:15:32 59] SQL: HY000

[ImportBot]

Originally Posted by beantje*:

 

[22:02:43 41] Error in Tablebuilder:

[22:02:43 41] Index #0

[22:02:43 41] Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

[22:02:43 41] Native: 2003

[22:02:43 41] Source:

[22:02:43 41] SQL: HY000

[22:02:43 41] Index #1

[22:02:43 41] Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

[22:02:43 42] Native: 2003

[22:02:43 42] Source:

[22:02:43 42] SQL: HY000

[22:02:43 42] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[22:02:44 42] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

 

 

whats wrong ?

[ImportBot]

Originally Posted by BL4CKSH4D0W*:

 

[22:02:43 41] Error in Tablebuilder:

[22:02:43 41] Index #0

[22:02:43 41] Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

[22:02:43 41] Native: 2003

[22:02:43 41] Source:

[22:02:43 41] SQL: HY000

[22:02:43 41] Index #1

[22:02:43 41] Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

[22:02:43 42] Native: 2003

[22:02:43 42] Source:

[22:02:43 42] SQL: HY000

[22:02:43 42] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[22:02:44 42] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

 

 

whats wrong ?

Hey man not sure if this will help. But I can tell you that error means that the plugin cannot connect to the database. I would verify the Host(IP) and the Port you input. If you know they are correct I would then check to make sure the firewall is not blocking the port. Lastly if the database resides on the machine you are using procon on you can use the local host IP of "127.0.0.1" instead of "46.249.40.158" to get around any firewall issues.

[ImportBot]

Originally Posted by XpKiller*:

 

@BL4CKSH4D0W

 

At I'm not sure what causes problems. Do have changed the SQL mode the MySQL server is running?

 

I never seen the problem until now.