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

[ImportBot]

Originally Posted by Clay52*:

 

Just got this

 

[18:11:27 20] Error: Error in Startstreaming:

[18:11:27 20] Index #0

[18:11:27 20] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.37-1ubuntu5.4]Duplicate entry 'EA_4EAD204A5470F9CEFB8D09CD391EF123' for key 'UNIQUE_playerdata'

[18:11:27 20] Native: 1062

[18:11:27 20] Source: myodbc5.dll

[18:11:27 20] SQL: 23000

I get this from time to time.

[ImportBot]

Originally Posted by ty_ger07*:

 

I get this from time to time.

I think I remember the author saying it is a bug he is working on. I think he said that error means the player has more that one nickname / game alias on the same game copy GUID.

[ImportBot]

Originally Posted by Blade_Repper*:

 

When i look at the primary console i see

Debug mode Faster,Slower,Normal

But when i connect through the layer server i get Error,Trace,Warning,Info.

 

Anyone else get this issue?

 

In my config file it is correct

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "DebugLevel" "Error"

 

 

0.0.0.7beta

[ImportBot]

Originally Posted by Clay52*:

 

I get this often at the end of a round:

 

[23:39:58 78] Error: SQLQuery:System.InvalidOperationException: Internal .Net Framework Data Provider error 12.

at System.Data.ProviderBase.DbConnectionInternal.Crea teReferenceCollection()

at System.Data.ProviderBase.DbConnectionInternal.AddW eakReference(Object value, Int32 tag)

at System.Data.Odbc.OdbcCommand.GetStatementHandle()

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.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[ImportBot]

Originally Posted by Ghostryder81*:

 

Do we still have to use the bf3.def file from the first page with Procon 1.1.3.0 ?

[ImportBot]

Originally Posted by 123fry*:

 

Hello,

 

does somebody try to run this plugin on a swissquake server?

 

I tried and I get the message

 

Error in Tablebuilder:

Index #0

Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Native: 0

 

is the error the missing driver and if yes, will swissquake install it for requesting it?

 

thanks!

[ImportBot]

Originally Posted by RoTide*:

 

I'm getting a few missing weapons:

RoadKill

FAMAS

QBB-95

L96

MG36

SoldierCollision

DamageArea

Suicide

 

(I'll update as more show up)

(Yes, I copied the bf3.def file from the zip to the server as per the instructions!)

[ImportBot]

Originally Posted by XpKiller*:

 

Those Weapons are missing in the bf3.def file of procon.

if those weapons were in this bf3.def file the plugin automatically updated the tables.

 

Atm there is no preview of the next bf3.def file available

 

@123fry

The MySQL ODBC Driver is missing you need to ask Swissquake to install it.

[ImportBot]

Originally Posted by RoTide*:

 

In other words, those are missing and it's a known issue? Nothing I can do about it?

[ImportBot]

Originally Posted by XpKiller*:

 

In other words, those are missing and it's a known issue? Nothing I can do about it?

My Plugin has no internal weapon mapping inside.

I could provide a new bf3.def file with the new weapons inside.

[ImportBot]

Originally Posted by IceCold*:

 

i have installed your plugin for BF3

i cannot get it to connect to database.

gameservers.com is hosting procon & database.

i get the following messager :-

 

[21:40:50 98] Error in Tablebuilder:

[21:40:50 98] Index #0

[21:40:50 98] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:40:50 98] Native: 0

[21:40:50 98] Source:

[21:40:50 98] SQL: IM002

 

can you please help

[ImportBot]

Originally Posted by XpKiller*:

 

i have installed your plugin for BF3

i cannot get it to connect to database.

gameservers.com is hosting procon & database.

i get the following messager :-

 

[21:40:50 98] Error in Tablebuilder:

[21:40:50 98] Index #0

[21:40:50 98] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:40:50 98] Native: 0

[21:40:50 98] Source:

[21:40:50 98] SQL: IM002

 

can you please help

The MySQL ODBC Driver is missing on the procon host, you need to ask gameservers.com to install it.

http://dev.mysql.com/downloads/connector/odbc

[ImportBot]

Originally Posted by Legate*:

 

This appears using the new version (0.0.0.8beta):

 

[11:32:02 28] Error: SQLQuery:

[11:32:02 28] Index #0

[11:32:02 28] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.13]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC) y

INNER JOIN tbl_playerdata pd ON y.' at line 6

[11:32:02 29] Native: 1064

[11:32:02 29] Source: myodbc5.dll

[11:32:02 29] SQL: 42000

[ImportBot]

Originally Posted by XpKiller*:

 

@Legate

I will fix the broken query. Anyway I wil release a new version to day with massiv improvement in the streaming process.

[ImportBot]

Originally Posted by Legate*:

 

Thank you ;-)

[ImportBot]

Originally Posted by REX9895*:

 

Hello. How about missing weapons from BtK ?

[ImportBot]

Originally Posted by XpKiller*:

 

Those Weapons are not missing in Plugin.

They are missing in the bf3.def file of Procon.

[ImportBot]

Originally Posted by REX9895*:

 

But we overwrite bf3.def procon-file with file from you archive (on first page) but still have this errors. Need to rollback bf3.def fle to procon version ?

 

[17:10:53 05] Warning: Weapon: QBU-88 is missing in the bf3.def file!!!

[17:11:28 92] Warning: Weapon: Weapons/XP1_L85A2/L85A2 is missing in the bf3.def file!!!

[17:12:17 65] Warning: Weapon: QBB-95 is missing in the bf3.def file!!!

[17:12:44 02] Warning: Weapon: HK53 is missing in the bf3.def file!!!

[17:13:12 22] Warning: Weapon: QBZ-95 is missing in the bf3.def file!!!

[17:13:38 02] Warning: Weapon: QBB-95 is missing in the bf3.def file!!!

[ImportBot]

Originally Posted by XpKiller*:

 

@Rex Version 0.0.0.8 was released before B2K

I release a fixed version today together with Version 0.0.0.9

[ImportBot]

Originally Posted by RoTide*:

 

XpKiller, thank you so much!

 

While this is probably "off topic", would anyone happen to have any php/html code they use to pull, say, the last 50 lines of chat out dynamically for viewing on a webpage, or a "top 10" list for a webpage? I'm sure I could use this as an opportunity to learn some more coding, but frankly, I hate reinventing the wheel. Plus it would be nice to have little "modules" that utilize this plugin that aren't in themselves plugins (can't create a new thread for them).

 

Maybe they could be submitted to XPKiller for inclusion as an "extras.zip" or something for added utility.

[ImportBot]

Originally Posted by XpKiller*:

 

Maybe they could be submitted to XPKiller for inclusion as an "extras.zip" or something for added utility.

Unfortunately i dont have the time to do some php coding. But I could a bundle of SQL Queries for different cases.

To help webdeveloper with there sites.

[ImportBot]

Originally Posted by RoTide*:

 

That could be helpful, but honestly, I didn't mean for _you? to do the coding. I meant other users/people could write up some code, php, etc. Maybe they would be nice enough to share those code snippets with you and you could provide them in a .zip or something.

[ImportBot]

Originally Posted by ty_ger07*:

 

That could be helpful, but honestly, I didn't mean for _you? to do the coding. I meant other users/people could write up some code, php, etc. Maybe they would be nice enough to share those code snippets with you and you could provide them in a .zip or something.

I already did and posted it in this topic.

 

Maybe it isn't what you are looking for though.

[ImportBot]

Originally Posted by Clay52*:

 

I'm getting this after every round, please comment on what may be causing this behavior, otherwise all seems to work as it should.

 

[08:49:02 53] Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.

at System.Data.Odbc.OdbcDataReader.GetRowCount()

at System.Data.Odbc.OdbcDataReader.FirstResult()

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.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[08:49:09 95] Error: SQLQuery:System.ObjectDisposedException: Safe handle has been closed

at System.StubHelpers.StubHelpers.SafeHandleC2NHelper (Object pThis, IntPtr pCleanupWorkList)

at System.Data.Common.UnsafeNativeMethods.SQLBindPara meter(OdbcStatementHandle StatementHandle, UInt16 ParameterNumber, Int16 ParamDirection, SQL_C SQLCType, Int16 SQLType, IntPtr cbColDef, IntPtr ibScale, HandleRef rgbValue, IntPtr BufferLength, HandleRef StrLen_or_Ind)

at System.Data.Odbc.OdbcStatementHandle.BindParameter (Int16 ordinal, Int16 parameterDirection, SQL_C sqlctype, SQL_TYPE sqltype, IntPtr cchSize, IntPtr scale, HandleRef buffer, IntPtr bufferLength, HandleRef intbuffer)

at System.Data.Odbc.OdbcParameter.Bind(OdbcStatementH andle hstmt, OdbcCommand command, Int16 ordinal, CNativeBuffer parameterBuffer, Boolean allowReentrance)

at System.Data.Odbc.OdbcParameterCollection.Bind(Odbc Command command, CMDWrapper cmdWrapper, CNativeBuffer parameterBuffer)

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.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[08:49:13 32] Error: SQLQuery:System.ObjectDisposedException: Safe handle has been closed

at System.StubHelpers.StubHelpers.SafeHandleC2NHelper (Object pThis, IntPtr pCleanupWorkList)

at System.Data.Common.UnsafeNativeMethods.SQLBindPara meter(OdbcStatementHandle StatementHandle, UInt16 ParameterNumber, Int16 ParamDirection, SQL_C SQLCType, Int16 SQLType, IntPtr cbColDef, IntPtr ibScale, HandleRef rgbValue, IntPtr BufferLength, HandleRef StrLen_or_Ind)

at System.Data.Odbc.OdbcStatementHandle.BindParameter (Int16 ordinal, Int16 parameterDirection, SQL_C sqlctype, SQL_TYPE sqltype, IntPtr cchSize, IntPtr scale, HandleRef buffer, IntPtr bufferLength, HandleRef intbuffer)

at System.Data.Odbc.OdbcParameter.Bind(OdbcStatementH andle hstmt, OdbcCommand command, Int16 ordinal, CNativeBuffer parameterBuffer, Boolean allowReentrance)

at System.Data.Odbc.OdbcParameterCollection.Bind(Odbc Command command, CMDWrapper cmdWrapper, CNativeBuffer parameterBuffer)

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.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 0.0.0.9

 

Note:

Please run the SQL Script in the tablefixes.txt.

The bf3.def which comes with Procon 1.1.3.1 contains the new Back 2 Karkand weapons.

 

Due the improvement in the Streaming process the plugin now only need 3 Queries to fetch the Id's for all Players instead of 2 Queries for each Player. This hopeful fixes the problems with connection loss during querying.

 

Changelog:

[0.0.0.9beta]

Improved Statsstreaming process, now need much less queries.

Fixed broken SQL Query thx Legate for report.

Some minor fixes for Back to Karkand.

[ImportBot]

Originally Posted by Clay52*:

 

New Version 0.0.0.9

 

Note:

Please run the SQL Script in the tablefixes.txt.

The bf3.def which comes with Procon 1.1.3.1 contains the new Back 2 Karkand weapons.

 

Due the improvement in the Streaming process the plugin now only need 3 Queries to fetch the Id's for all Players instead of 2 Queries for each Player. This hopeful fixes the problems with connection loss during querying.

 

Changelog:

[0.0.0.9beta]

Improved Statsstreaming process, now need much less queries.

Fixed broken SQL Query thx Legate for report.

Some minor fixes for Back to Karkand.

Run what SQL script?

 

So, we log into MySQL, click onto the database in question, then choose SQL tab, then place script in box and hit "Go"?

[ImportBot]

Originally Posted by Ghostryder81*:

 

The one in tablefixes.txt from the zip file

[ImportBot]

Originally Posted by Clay52*:

 

The one in tablefixes.txt from the zip file

Right, so everything except this line below?

 

#Removing the dot in name.

[ImportBot]

Originally Posted by Ghostryder81*:

 

Right, so everything except this line below?

 

#Removing the dot in name.

Yes. I used PhpMyAdmin and copied everything except this line. Worked for me. Its just a comment I think

[ImportBot]

Originally Posted by Clay52*:

 

Yes. I used PhpMyAdmin and copied everything except this line. Worked for me. Its just a comment I think

Ok Ghost, ty.

 

Edit: I actually ran the script when procon was running, will this cause any issues?