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

[ImportBot]

Originally Posted by XpKiller*:

 

I am thinking there is probably some Boolean code (that determines when the round is over) that can be used in contrast with a loop or something to either put them all in a new row...or would I need to make it to where each round was a separate table?

Round by Round Statistics would need changes in the code.

It on my agenda now.

[ImportBot]

Originally Posted by KaiserZer0*:

 

Round by Round Statistics would need changes in the code.

It on my agenda now.

Nice, if it is ok can I experiment with the code and see if I can figure it out too? I will give you any usable code that comes out of it.

[ImportBot]

Originally Posted by XpKiller*:

 

@KaiserZer0

 

no Problem the code and concept is basically ready. It just a matter of free time to implement it.

May i getting it done in the coming week.

[ImportBot]

Originally Posted by KaiserZer0*:

 

@KaiserZer0

 

no Problem the code and concept is basically ready. It just a matter of free time to implement it.

May i getting it done in the coming week.

Ah cool, great to hear that. It will definitely be featured in our tournament when that is done. Keep up the good work.

[ImportBot]

Originally Posted by MrJakl*:

 

Hello together,

 

after i reinstall my procon and start this plugin, i get the following Error:

 

Code:

[19:38:10 52] Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxxxx".
   bei System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   bei System.Security.PermissionSet.Demand()
   bei System.Data.Common.DbConnectionOptions.DemandPermission()
   bei System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   bei System.Data.Odbc.OdbcConnection.Open()
   bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
Die Aktion, bei der ein Fehler aufgetreten ist:
Demand
Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:
System.Data.Odbc.OdbcPermission
Die Zone der Assembly, bei der ein Fehler aufgetreten ist:
MyComputer
[19:38:10 53] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[19:38:10 53] Error: getUpdateServerID1: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxxxx".
   bei System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   bei System.Security.PermissionSet.Demand()
   bei System.Data.Common.DbConnectionOptions.DemandPermission()
   bei System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   bei System.Data.Odbc.OdbcConnection.Open()
   bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServerID(CServerInfo csiServerInfo)
Die Aktion, bei der ein Fehler aufgetreten ist:
Demand
Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:
System.Data.Odbc.OdbcPermission
Die Zone der Assembly, bei der ein Fehler aufgetreten ist:
MyComputer

Need help please.

[ImportBot]

Originally Posted by XpKiller*:

 

Enabled outgoing odbc connection in procon or disabled the sandbox.

[ImportBot]

Originally Posted by MrJakl*:

 

Enabled outgoing odbc connection in procon or disabled the sandbox.

Hello XpKiller,

 

very thanks for your quick answer. Now the Plugin works fine.

[ImportBot]

Originally Posted by demetrope*:

 

hello,

 

That's all I started with debian 6 32bit and now I receive this message:

 

[08:39:00 61] BF3 Chat, GUID and Stats Logger Enabled

[08:39:00 62] BF3 Chat, GUID and Stats Logger: Floodprotection set to 32 Request per Round for each Player

[08:39:19 70] Error: SQLQuery:

[08:39:19 70] Index #0

[08:39:19 70] Message: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

[08:39:19 70] Native: 1267

[08:39:19 70] Source: libmyodbc5.so

[08:39:19 70] SQL: HY000

[08:39:19 71] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [23000] [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Duplicate entry '_________' for key 'IP_Address_UNIQUE'

at System.Data.Odbc.OdbcCommand.ExecSQL (CommandBehavior behavior, Boolean createReader, System.String sql) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery (System.String method, CommandBehavior behavior, Boolean createReader) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery () [0x00000] in :0

at (wrapper remoting-invoke-with-check) System.Data.Odbc.OdbcCommand:ExecuteNonQuery ()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID (PRoCon.Core.CServerInfo csiServerInfo) [0x00000] in :0

[ImportBot]

Originally Posted by demetrope*:

 

good, I found just install the tables on a database utf8-general will to remove this problem and the problem now against q'au few hours it crashes and returns me as a message:

 

Executing procon...

Running... (Press any key to shutdown)

Segmentation fault

 

 

___?

procon sous linux debian

[ImportBot]

Originally Posted by XpKiller*:

 

you shouldnt use the console under linux. Its better to run the procon.service.exe

[ImportBot]

Originally Posted by oOKenTOo*:

 

Hi there.

 

I've come across the following problem:

 

i've installed xampp on one of my 64bit windows 7 servers, and installed the MySQL ODBC Driver 5.2 aswell, and can connect the ODBC to my database without any problems.

 

But when i activate the plugin in procon after i've inserted the correct login informations, i get the following error:

 

Code:

[00:25:14 02] BF3 Chat, GUID and Stats Logger Enabled
[00:25:14 04] BF3 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[00:25:16 07] Error in Tablebuilder: 
[00:25:16 08] Index #0
[00:25:16 09] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
[00:25:16 10] Native: 0
[00:25:16 10] Source: 
[00:25:16 11] SQL: IM002
[00:25:16 12] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[00:25:20 25] Error in Tablebuilder: 
[00:25:20 26] Index #0
[00:25:20 27] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
[00:25:20 28] Native: 0
[00:25:20 28] Source: 
[00:25:20 29] SQL: IM002
[00:25:20 30] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[00:25:20 31] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServerID(CServerInfo csiServerInfo)

you guys have any idea why, have tried some different things but without any luck, so now im kinda lost..

[ImportBot]

Originally Posted by dyn*:

 

you guys have any idea why, have tried some different things but without any luck, so now im kinda lost..

Interestingly enough I too had this problem with Win 2008 x64. I had been using the 32 bit version of ODBC without any problem (C:\Windows\SysWOW64\odbcad32.exe). Then, however, it just stopped working and I think it displayed the error you provided. My fix action was to actually install the 64 bit version of the connector. Once it was installed it started working. Heck, I didn't even have to mess with the 64bit settings. No idea what caused it, or why it worked... but it did. 0_o

[ImportBot]

Originally Posted by XpKiller*:

 

@oOKenTOo

 

You need to setup a dsn name in the odbc Datasource manager.

 

@dyn

I could image that may the new procon version now uses the 64bit one, but not sure.

[ImportBot]

Originally Posted by utopiate*:

 

could someone link to the 5.1.10 driver as I cannot get newer ones to connect.

 

many thanks

[ImportBot]

Originally Posted by dyn*:

 

could someone link to the 5.1.10 driver as I cannot get newer ones to connect.

 

many thanks

I've gotten my copies from:

 

http://mirror.services.wisc.edu/mysq...ctor-ODBC/5.1/

[ImportBot]

Originally Posted by utopiate*:

 

yep thx got it. Gonna have to throw myself at the mercy of the forum as I can't get this to work. I keep getting this error;

 

[17:48:38 13] Error in Tablebuilder:

[17:48:38 13] Index #0

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

[17:48:38 13] Native: 0

[17:48:38 13] Source:

[17:48:38 13] SQL: IM002

[17:48:38 13] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

 

 

Here is what I have done. please bear in mind I do not have root access to the server my layers are installed on.

 

Created database, username and password with full privileges.

Added the ip of my layers to the remote access list.

Hoster has installed odbc 5.1.9 and now 5.1.10 (originally installed the lateset ver but didn't work)

Entered details into plugin;

host: username@ipaddress

port: 3306

database name: database name

Username: username

Password: password

 

However, always results in the above error.

 

Any help really appreciated.

[ImportBot]

Originally Posted by XpKiller*:

 

@utopaite

 

Your Hoster need to setup a dsn entry to define the mysql driver as a default driver.

http://dev.mysql.com/doc/refman/5.5/...n-windows.html

[ImportBot]

Originally Posted by utopiate*:

 

yep they have but still the same error

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

[08:56:08 59] Native: 0

[08:56:08 59] Source:

[08:56:08 60] SQL: IM002

[08:56:08 60] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

 

test.jpg

proconwebstatserror.jpg

[ImportBot]

Originally Posted by dyn*:

 

utopiate --

 

Your host is incorrect. You should ONLY have an IP / host name in that field. Remove "ottgamin_uto@" from the Host field leaving just the IP.

[ImportBot]

Originally Posted by utopiate*:

 

utopiate --

 

Your host is incorrect. You should ONLY have an IP / host name in that field. Remove "ottgamin_uto@" from the Host field leaving just the IP.

Ok, tried that but still giving the same error.

[ImportBot]

Originally Posted by dyn*:

 

Perhaps post 1393* can help you?

 

TL;DR: Had to configure ODBC 32 bit version. Still have to install 64 bit version for Procon to connect. Didn't do anything to the 64 bit version. Could it have been a coincidence ? Maybe.

[ImportBot]

Originally Posted by Cedbru57*:

 

Hi

 

I've an error with my Procon Layer on Linux, just for your plugin, i've tested on Debian Squeeze 32 & 64 bits and it's the same error.

I'am using the lastest version of Mono and the libiodbc.so (package libiodbc2-dev) for correct the error "System.DllNotFoundException: libodbc.so"

Procon 1.4.0.2

 

etc/mono/config

[23:55:40 13] Error in Tablebuilder:

[23:55:40 13] Index #0

[23:55:40 13] Message: [[23:55:40 13] Native: 0

[23:55:40 13] Source:

[23:55:40 13] SQL: I[23:55:40 13] Error: System.NullReferenceException: Object reference not set to an instance of an object

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

[23:55:40 13] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [i[23:55:42 99] BF3 Chat, GUID and Stats Logger Disabled

Someone can help me please ? Thanks

Sorry for my bad english.

[ImportBot]

Originally Posted by utopiate*:

 

thx for the help chaps, got it resolved (reinstalled) 32bit and kerpow! of it went, no more errors. I do have another query which I can't seem to find an answer. How long before I would start to see entries into the leaderboard. Is there a default number of connections a player needs to make in order to appear in the stats etc?

 

cheers

[ImportBot]

Originally Posted by XpKiller*:

 

@utopiate

 

The stats are updated after every round.

[ImportBot]

Originally Posted by utopiate*:

 

yep, thanks for that. A quick question, do you have any plans to port the plugin over to warfighter?

 

cheers

[ImportBot]

Originally Posted by XpKiller*:

 

would be easy to port to warfighter will do it as soon i have time to.

[ImportBot]

Originally Posted by utopiate*:

 

thats great news thanks

[ImportBot]

Originally Posted by Cedbru57*:

 

XpKiller, have you any solution for my probleme with your plugin ?

[ImportBot]

Originally Posted by Pgneon*:

 

XpKiller, How do we keep the serverid as 1. We had to move the procon host and the new one is setting new players in serverid 2 like its a different game server.

[ImportBot]

Originally Posted by XpKiller*:

 

@Cedbru57

Sry i cant help you with that linux specific problem.

 

@Pgneon

You need to to edit your table tbl_server with your new server ip + port. Then you will keep your stats.