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

[ImportBot]

Originally Posted by Pgneon*:

 

Which entry do I modify? I have 2

 

ServerID 1 - Server name

ServerID 2 - Server name

 

Get the info from serverid 2 and put it on serverid 1, then delete the serverid 2?

[ImportBot]

Originally Posted by XpKiller*:

 

Only the column IP_Address is relevant.

[ImportBot]

Originally Posted by MisterBensen*:

 

Hi!

 

I just installed your plugin and tried to start it, but i get this error message:

 

Code:

Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=XXXXXXXXXXXXX".
   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

On page 139 'MrJakl' had the same issue and you told him to enable the outgoing odbc connections or disable the sandbox and it worked for him......I tried both but I still get the same message! Any other ideas?

[ImportBot]

Originally Posted by XpKiller*:

 

The procon layer needs to be restarted if you change those settings.

[ImportBot]

Originally Posted by utopiate*:

 

@XpKiller I thought you might like to know that there is now another frontend for displaying stats from your plugin. Its a simple leaderboard but looks great. You can see it here in action on my webby. Support for MOHW is already there when you get a chance to port the plugin over

http://oldtimerstactical.co.uk/ezServer/index.php

http://www.ezstats.org/

[ImportBot]

Originally Posted by Athlon*:

 

^^^

 

That is not showing stats from this plugin. Ezstats pulls global stats from bf3stats.com.

[ImportBot]

Originally Posted by utopiate*:

 

er no, it can now provide you with a server 'leaderboard' drawing it's data from either this plugin or xlrstats. I let the dev access my databases in order for him to develop it. This is separate from the 'live' server viewer.

 

Here is a demo, you can also see it at work on my webby under 'server viewer' however, I've just dropped all the tables to coincide with 'aftermath'.

 

http://demo.ezstats.org/standalone_serv/

[ImportBot]

Originally Posted by XpKiller*:

 

Nice work. Hope I find sometime to port it to mohw won't be a big deal.

[ImportBot]

Originally Posted by utopiate*:

 

Yep me too as you would save me from using xlrstats lols

[ImportBot]

Originally Posted by MisterBensen*:

 

The procon layer needs to be restarted if you change those settings.

Hey XpKiller.....thx for the quick answer, but I still get the error message. Procon and the Procon Layer Server were restarted multiple times. The Database Server i am using is a Server i got for free to my BF3 Server that i rented at g-portal. Maybe it has something to do with their server? Had contact to the support there too, but they tell my everything should run fine!_!

[ImportBot]

Originally Posted by cjffly*:

 

Hi, XpKiller, can you help me? I got this error code:

Code:

Error: SQLQuery:
[23:04:08 25] Index #0
[23:04:08 25] Message: [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 2
[23:04:08 26] Native: 2013
[23:04:08 26] Source: 
[23:04:08 26] SQL: 08S01
[00:02:22 38] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'reading authorization packet', system error: 0
   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)
[04:46:11 07] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'reading authorization packet', system error: 0
   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)

months ago, I use layer from branezone. I am sure DB side is ok, because when I use branezone's layer, and DB, it's working fine. I set up my own layer recently, and install ODBC on my layer server 5.1.9. ports 3306 is open, can you help check what's going on here?

 

Regards

[ImportBot]

Originally Posted by th3hood*:

 

added crossbow to my weapons -

 

CrossBow{XBow,crossbow}

 

Does the BF Premium knife need to be added, (Knife_RazorBlade{knife}) and will it write to the dogtags table in the sql ?

 

 

Had any joy with this error ?

 

[12:34:02 17] Error: Error in Startstreaming:

[12:34:02 17] Index #0

[12:34:02 17] Message: [MySQL][ODBC 5.1 Driver]DUP_PK_KEY

[12:34:02 18] Native: 51204

[12:34:02 18] Source: myodbc5.dll

[12:34:02 18] SQL: HY000

 

 

XPKiller if its awkward to reproduce this error your welcome to access my db and proconlayer.

 

p.s. I Read up something about IGNORE DUP KEY - dont know if thats of any help here...

 

p.p.s. just noticed rounds played is showing 1 for all players in the db which isnt right....

also noticed that although session time (!session) is wrong for me, it is the correct time for where the server is based, maybe a timezone correction is possible, not sure.

[ImportBot]

Originally Posted by XpKiller*:

 

@th3hood

i need so more infos like which version has you mysql server.

 

@ cjffly

looks like a network problem eg. Firewall

[ImportBot]

Originally Posted by th3hood*:

 

think i found something -

 

the following SQL functionality is NOT SUPPORTED in the current release:

 

ALTER TABLE {ADD|DROP} PRIMARY KEY. A table's primary key constraint can only be defined while creating a table and as a part of the CREATE TABLE DDL.

INSERT IGNORE, INSERT …ON DUPLICATE KEY UPDATE & REPLACE – these statements are supported for a single operation transaction, or when the duplicate values are both in the same transaction. In bulk operations/transactions, a uniqueness constraint violation might fail the entire transaction.

[ImportBot]

Originally Posted by cjffly*:

 

...

@ cjffly

looks like a network problem eg. Firewall

Thanks!

I am running my layer on a Windows Server 2008, can you tell me besides 3306, what other ports need to be open?

[ImportBot]

Originally Posted by XpKiller*:

 

@th3hood

The plugin highly make use of the insert on duplicated key update command.

Without this command it will not work.

[ImportBot]

Originally Posted by Athlon*:

 

I get this error when starting the plugin:

 

Code:

[10:09:38 67] Error in Tablebuilder: 
[10:09:38 67] Index #0
[10:09:38 69] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.20]ALTER command denied to user 'procon'@'localhost' for table 'tbl_weapons_none'
[10:09:38 70] Native: 1142
[10:09:38 70] Source: myodbc5.dll
[10:09:38 70] SQL: HY000

Otherwise - everything seems to be working fine.....

[ImportBot]

Originally Posted by XpKiller*:

 

@Athlon your DB user needs alter permissions.

[ImportBot]

Originally Posted by Athlon*:

 

I think I have done that.....

 

Code:

grant select,insert,update,delete,create on *.* to 'username-changed'@'localhost' identified by 'password-changed';

My db is on the same computer running 24/7 as our Procon Layer. It's been running like this since last February.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

You granted select, insert, update, delete and create to the user, but alter is still missing. Changing it to Code:

grant select,insert,update,delete,create,alter on *.* to 'username-changed'@'localhost' identified by 'password-changed';

should fix it.

[ImportBot]

Originally Posted by Sagittaire88*:

 

Hello,

 

How do you have a message for the best player of the week or day in chat without putting order! Potd?

[ImportBot]

Originally Posted by XpKiller*:

 

do you mean automatically?

 

 

no not yet but could be a feature request.

[ImportBot]

Originally Posted by Sagittaire88*:

 

yes automatically , ok thank you very much and congratulations for your work

[ImportBot]

Originally Posted by Athlon*:

 

@MorpheusX(AUT) & XPKiller

 

Slap to the forehead!

 

Sometimes you can stare at code for an hour and not see the obvious. Thank you both!!

[ImportBot]

Originally Posted by th3hood*:

 

everything working great for me on our 2 servers now, apart from one small error. When you type !dogtags ingame it scrolls in the format of -

TITLE - VICTIMS

victim

victim

victim

enemy

enemy

TITLE - ENEMY

 

enemy is appearing before TITLE - ENEMY. Any ideas on how to fix this. ty.

[ImportBot]

Originally Posted by cjffly*:

 

Hi,

Code:

[22:52:52 09] Error: Error in UpdateRanking: 
[22:52:52 10] Index #0
[22:52:52 10] Message: [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'reading authorization packet', system error: 0
[22:52:52 11] Native: 2013
[22:52:52 11] Source: 
[22:52:52 12] SQL: 08S01

Is this kind of error also network problem?

 

Thanks

[ImportBot]

Originally Posted by XpKiller*:

 

http://dev.mysql.com/doc/refman/5.5/...onnection.html

[ImportBot]

Originally Posted by cjffly*:

 

http://dev.mysql.com/doc/refman/5.5/...onnection.html

Great Thanks!

[ImportBot]

Originally Posted by ronin*:

 

Hi

 

Can some tell me what i need to do to fix this please

 

[21:06:59 19] Error in Tablebuilder:

[21:06:59 19] Index #0

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

[21:06:59 19] Native: 0

[21:06:59 19] Source:

[21:06:59 19] SQL: IM002

[21:06:59 19] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

Is it to do with the database host or something to do with the odbc driver .

 

Here is some more of the error i think thats it .

 

[21:28:53 43] BF3 Chat, GUID and Stats Logger Disabled

[21:28:54 35] Error in Tablebuilder:

[21:28:54 35] Index #0

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

[21:28:54 35] Native: 0

[21:28:54 35] Source:

[21:28:54 35] SQL: IM002

[21:28:54 35] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[21:28:54 35] 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(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 XpKiller*:

 

@ronin you need to setup at least one DSN with the mysql ODBC Driver on your procon host.