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

ImportBot · December 16, 2011

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 · December 16, 2011

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 · December 16, 2011

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 · December 16, 2011

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 · December 16, 2011

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 · December 17, 2011

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 · December 17, 2011

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 · December 17, 2011

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 · December 17, 2011

Originally Posted by RoTide*:

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

ImportBot · December 17, 2011

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 · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

Originally Posted by Legate*:

Thank you ;-)

ImportBot · December 18, 2011

Originally Posted by REX9895*:

Hello. How about missing weapons from BtK ?

ImportBot · December 18, 2011

Originally Posted by XpKiller*:

Those Weapons are not missing in Plugin.

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

ImportBot · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

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 · December 18, 2011

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()