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

[ImportBot]

Originally Posted by ty_ger07*:

 

That never gets old.

[ImportBot]

Originally Posted by lothop*:

 

http://www.auswarfare.com/index.php_...=battlereports

 

Check it out. Round 1 - 4

Still got some tweaking to go but think its going well.

[ImportBot]

Originally Posted by Athlon*:

 

http://www.auswarfare.com/index.php_...=battlereports

 

Check it out. Round 1 - 4

Still got some tweaking to go but think its going well.

Nicely done!

 

[ImportBot]

Originally Posted by XpKiller*:

 

Very cool!

 

i just thinking about of extending my plugin to store roundbased results.

[ImportBot]

Originally Posted by lothop*:

 

Now you do it! lol After I haxxed it up to work.

All good, as long as it makes it easier to do because at the moment I'm just doing a workabout way and it's a bit fragile at times

 

Would be a lot safer and easier if plugin handled it all.

Great for tournament play

[ImportBot]

Originally Posted by Capt-O*:

 

[01:38:55 37] Error: Error in Startstreaming:

[01:38:55 37] Index #0

[01:38:55 37] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.25]Out of range value for column 'Playtime' at row 2

[01:38:55 37] Native: 1264

[01:38:55 37] Source: myodbc5.dll

[01:38:55 37] SQL: HY000

 

Everything is running great, but just noticed i got this error.

 

http://www.capt-o.com/wordpress/serv...nk/players.php

[ImportBot]

Originally Posted by Dezar*:

 

who will help to adjust this plug-in for money?

skype - dezar-pro

[ImportBot]

Originally Posted by lothop*:

 

Question.

 

High Performance mode turned off - When will it connect to database to store information? At round completion?

[ImportBot]

Originally Posted by XpKiller*:

 

High Performance mode on allows the plugin to run multiply querys an the same time. Stats still get updated at the end of the round.

[ImportBot]

Originally Posted by lothop*:

 

So high performance mode -

Updates 1 user - closes connection

Updates next user - closes connection?

 

I'm getting Max SQL connection error at times with high performance mode turned on.

Max connections is 8 to my sql server per username

[ImportBot]

Originally Posted by XpKiller*:

 

The plugin does more things than just updating the stats. It fetches data if a user joins the server for the welcomstats or if he enter an ingame command.

 

So i high performance mode is on the plugin tries to solve every query as fast as possible. --> eg. 4 Player join at the same time, at high performance mode the plugon open 4 connections to get player stats instead of handle them in a row.

[ImportBot]

Originally Posted by DanielEXQ*:

 

Hi,

i have a question. Give it more templates for the BF3 Stats?

thx.

 

greets danielexq

[ImportBot]

Originally Posted by XpKiller*:

 

@DanielEXQ

What do you mean with more templates?

Could you give an example.

[ImportBot]

Originally Posted by DanielEXQ*:

 

I have installed your plugin for BF3 stats (compliments for your work at this point) and now i use the default player_stats.php to view the stats of our BF3 Server.

Look there: bf3stats.abt-labs.de

This is what i mean with "Template". Give it more from these templates (also like player_stats.php), maybe with another stats and views to download?

[ImportBot]

Originally Posted by XpKiller*:

 

I'm not responsible for that php stats pages which are using the database created by my plugin.

 

Please post you questions in the Thread of this stats page:

 

www.phogue.net/forumvb/showth...apstats-Logger*

[ImportBot]

Originally Posted by PROSHKA*:

 

Hello! Please help solve the problem with the configuration of this plug-in

My system is windows 7 64 ...

plug-in provides just such an error:

 

* Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL] [ODBC 5.1 Driver] Host '176 .51.80.121 'is not allowed to connect to this MySQL server

ERROR [HY000] [MySQL] [ODBC 5.1 Driver] Host '176 .51.80.121 'is not allowed to connect to this MySQL server

*** in System.Data.Odbc.OdbcConnection.HandleError (OdbcHandle hrHandle, RetCode retcode)

*** in System.Data.Odbc.OdbcConnectionHandle .. ctor (OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

*** in System.Data.Odbc.OdbcConnectionOpen .. ctor (OdbcConnection outerConnection, OdbcConnectionString connectionOptions)

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

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

*** in System.Data.ProviderBase.DbConnectionFactory.GetCo nnection (DbConnection owningConnection)

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

*** in System.Data.Odbc.OdbcConnection.Open ()

*** in PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID (CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by persianview*:

 

my error :

[13:51:03 69] Error in Tablebuilder:

[13:51:03 70] Index #0

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

[13:51:03 71] Native: 0

[13:51:03 71] Source:

[13:51:03 71] SQL: IM002

[13:51:03 72] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[13:51:10 48] Error in Tablebuilder:

[13:51:10 49] Index #0

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

[13:51:10 50] Native: 0

[13:51:10 51] Source:

[13:51:10 51] SQL: IM002

[13:51:10 52] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[13:51:10 52] 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)

1.jpg 2.jpg

[ImportBot]

Originally Posted by XpKiller*:

 

@persianview

 

your odbc driver is missing or not configured well on the procon layer server.

 

And also your connection settings dont make sense to me. Where is the database located?

[ImportBot]

Originally Posted by Shakal-hh*:

 

can i use one Database for 4 Servers? and how?

[ImportBot]

Originally Posted by XpKiller*:

 

you can use up to 65000 server into one single db.

 

just use the same credentials the plugin will do the rest.

[ImportBot]

Originally Posted by Shakal-hh*:

 

hmm okay.. i have now 4 DBs...

 

can i change it to 1 DB?

 

i have seen that e.g. the playerranks have a "servergroup" table

[ImportBot]

Originally Posted by XpKiller*:

 

a merge on a later time is not possible without big efforts.

[ImportBot]

Originally Posted by persianview*:

 

@XpKiller

 

i use gameservers.com hostting (linux , cpanel 5.1.X)

can you give me last odbc driver ver downlod link (i can not download from cpanel site, maybe this site have problem with my country user:ohmy:)

1.jpg 2.jpg

[ImportBot]

Originally Posted by persianview*:

 

in procon > plugins > BF3 chat , guid , stats and ... > plugins settings TAB > SERVER DETAILS :

 

in front of HOST , what information i must insert ? ip of my host ? like xx.xx.xx.xx or domain like www.name.com

[ImportBot]

Originally Posted by XpKiller*:

 

@persianview

 

You can find the odbc Driver ( i recommend 5.1.9) here:

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

 

in the host field you can enter the ip address or the dns name of the target mysql server.

 

One question: do you run procon under linux or do you use gameserver.com layer hosting.

 

Because gameservers.com don install the odbc driver on there procon layer, without it this plugin will not work!

[ImportBot]

Originally Posted by Shakal-hh*:

 

i have switched my database from local to my webhoster and can connect to it over SSH....

i have connectet to this database with putty but now procon says:

 

 

Code:

[13:08:54 88] Error: SQLQuery:
[13:08:54 88] Index #0
[13:08:54 88] Message: [MySQL][ODBC 5.1 Driver]Benutzer 'root'@'localhost' hat keine Zugriffsberechtigung (verwendetes Passwort: Ja)
[13:08:54 89] Native: 1045
[13:08:54 89] Source: 
[13:08:54 89] SQL: HY000
[13:08:54 89] Index #1
[13:08:54 89] Message: [MySQL][ODBC 5.1 Driver]Benutzer 'root'@'localhost' hat keine Zugriffsberechtigung (verwendetes Passwort: Ja)
[13:08:54 89] Native: 1045
[13:08:54 89] Source: 
[13:08:54 89] SQL: HY000
[13:08:54 89] Error: System.IndexOutOfRangeException: Spalte 0 wurde nicht gefunden.
   bei System.Data.DataColumnCollection.get_Item(Int32 index)
   bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[13:08:54 89] Error: System.InvalidOperationException: OdbcTransaction wurde beendet und kann nicht mehr verwendet werden.
   bei System.Data.Odbc.OdbcTransaction.Rollback()
   bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

why he says "root"? i have set a other user in procon?

 

EDIT:

problem solved: i have reinstalled the odbc drivers and now it is working

[ImportBot]

Originally Posted by persianview*:

 

@XpKiller

i have windows seven

[ImportBot]

Originally Posted by PROSHKA*:

 

greetings. thanks in advance for giving me help!)

error:

 

[22 21:09:24] BF3 Chat, GUID and Stats Logger Enabled

[22 21:09:24] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[23 21:09:24] Info: Table suffix set to

[27 21:09:24] Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[28 21:09:26] Info: Start tablebuilder

[29 21:09:26] Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[83 21:09:27] Info: Prevented double creation of columns for weapon: P90

[18 21:09:28] Info: Prevented double creation of columns for weapon: MP443

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

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

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

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

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

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

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

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

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

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

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

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

[ImportBot]

Originally Posted by SoulReaper*:

 

Hello,

 

I am receiving the following SQL error:

 

[10:37:29] Error: LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.30-community]MySQL server has gone away

--- End of inner exception stack trace ---

at System.Data.Odbc.OdbcConnection.ConnectionIsAlive( Exception innerException)

at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow (OdbcHandle hrHandle, RetCode retcode)

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.LogChat(Strin g strSpeaker, String strMessage, String strType)

 

Am i missing something?

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

I am getting the following error, updates are turned on I think..

 

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'database.lcn.com' (10061)

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'database.lcn.com' (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)

 

Any idea what's causing this?

 

Thanks in advance..

 

Strat