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

[ImportBot]

Originally Posted by ToM666*:

 

Hi all, Has anyone successfully set this up to run procon on a laptop and have the database on the same server as your website online?

[ImportBot]

Originally Posted by gabipaci*:

 

leibhold:

 

ToM666:

Our game server provider gives us procon layer, free mysql database, free 500MB webspace with ftp, etc.

We already working on webstat, with real time and logged player names / points /kill / death / chat / maps / weapons / wehicles / etc.

Will be RC about monday (cross fingers)

[ImportBot]

Originally Posted by ToM666*:

 

leibhold:

 

ToM666:

Our game server provider gives us procon layer, free mysql database, free 500MB webspace with ftp, etc.

We already working on webstat, with real time and logged player names / points /kill / death / chat / maps / weapons / wehicles / etc.

Will be RC about monday (cross fingers)

Our servers are up for renewal this week mate and what you have described is really tempting.

Who are your server providers mate?

 

Could you also tell me what their customer service is like etc?

 

Thanks matey

 

ToM

[ImportBot]

Originally Posted by gabipaci*:

 

We can display all data, what this plugin can logging, and all things, what we can calculate from data (eg: K/D, Score/Minutes, Score/Round, Kill/Round, and lots of more)

And some extra, we can display with different things the current (relatime) player/map data (name, kill, deaths, points, tickets, map name, mode)

 

Our server provider here: http://www.ngz-server.de/

[ImportBot]

Originally Posted by CptChaos*:

 

I've updated to the first stable version of this plugin. I've also activated the mapstats, I think it's interesting to see those stats as well.

 

Later I was checking the table tbl_mapstats and I noticed that the time when a round started is being recorded, but when a round has ended it doesn't get recorded into the database. Is this a bug or something RCON just doesn't support? If it's RCON, can I assume that the starttime of another record in the table (sorted by date as wel) is the endtime of the round which came first?

[ImportBot]

Originally Posted by GitSum*:

 

We have been collecting the map stats for the last month are so here is a link >>> Map Stats

 

Time round ends is not working on all the maps, and Time round started does not work on the B2K maps

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

Hello.

 

I'm find a bug int tbl_weapons_handgun.

The taurus44 kills have 2x3 data place. The first 's have a bad name like Taurus_.44_kills and the second is taurus_44_kills.

The plugin is save the data in the first place. and tghe normal data place is full empty.

 

Sorry for my bad english.

[ImportBot]

Originally Posted by XpKiller*:

 

@RMG-Dr4k3

This was a bug in previous version now the plugin should store data in Taurus_44_kills only.

 

@Gitsum and CptChaos

im aware of the problem in not sure yet what causes this because it is not every time.

Maybe a serverbug.

 

Edit:

If a round never started due less player this clomun stays empty too.

[ImportBot]

Originally Posted by CptChaos*:

 

Well, the plugin tracks multiple (8) servers in our Procon layer server, the table has (atm) 38 records and 2 have end time.

Is it possible to edit that part, making the end time the same as the start time of the new map?

[ImportBot]

Originally Posted by XpKiller*:

 

@CptChaos

I will check that.

[ImportBot]

Originally Posted by CptChaos*:

 

Thanks, I noticed I also have a record where it's unknown which map and gamemode it was. So maybe it's a nice idea to check from time to time which map and gamemode is running?

[ImportBot]

Originally Posted by XpKiller*:

 

Bug found!

 

I found a bug which occurs under high load.

It will raise a such an Error:

Code:

Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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(OdbcCommand selectQuery)

Setting "Close Connection after each request_" to yes and disable instant chatlogging will avoid this bug.

[ImportBot]

Originally Posted by CptChaos*:

 

That would be odd. I am having chatlogging disabled and I've already set "Close connection after each request" to enabled.

Most errors I can see with Procon are errors from the shared banlist plugin, that a file would be unreadable.

[ImportBot]

Originally Posted by XpKiller*:

 

I upload a fix today i think i found the issue which causes this.

Atm im high load testing on my root server.

Also i add a new High performance mode which has no connection limits anymore.

[ImportBot]

Originally Posted by GitSum*:

 

I upload a fix today i think i found the issue which causes this.

Atm im high load testing on my root server.

Also i add a new High performance mode which has no connection limits anymore.

I was starting to see some errors relating to the ODBC Driver

 

Code:

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'waiting for initial communication 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)

I have instant chat logging enabled, but when I change "close connection after each request" to yes, it seems like the layer crashes a bit

 

Do you think this is related to the problem you found?

[ImportBot]

Originally Posted by XpKiller*:

 

@Gitsum

your error is caused by th mysql server which has refused the connection.

 

it could be related to it, atm i testing the new release seems good atm

[ImportBot]

Originally Posted by Dragon2203*:

 

I get this error:

[21:47:04 81] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.6.4-m7-log]Lock wait timeout exceeded; try restarting transaction

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

bei System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

bei System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

bei System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

I turned chat-logging of and turned "Close connection after each request" on. But it didn't change

[ImportBot]

Originally Posted by gabipaci*:

 

XpKiller, our webstat are 99% finished.

Only last thing, what we have problem the playtime.

Can u check please, and try find the bug?

 

Thank U.

[ImportBot]

Originally Posted by XpKiller*:

 

New Version:

 

[1.0.0.1]

Changed Connectionhandling to avoid errors under high load.

Added high perfomance mode (no connection limit for ODBC Connections)

Enable Connection Pooling in the ODBC Driver for best performance

[ImportBot]

Originally Posted by CptChaos*:

 

XpKiller, our webstat are 99% finished.

Only last thing, what we have problem the playtime.

Can u check please, and try find the bug?

 

Thank U.

How is anyone able to find a bug with such little info if anyone is able to understand what you are saying? Maybe you could tell more or perhaps (and even better), give something like an errormesssage that you receive? Show what you are trying to do and do not let someone just guess what it could be. This forum is not some sort of helpdesk I hope.

 

@XPKiller, I'm going to update and let you know if I find anything wrong. Is the bug with the end round times also fixed?

[ImportBot]

Originally Posted by ty_ger07*:

 

New Version:

 

[1.0.0.1]

Changed Connectionhandling to avoid errors under high load.

Added high perfomance mode (no connection limit for ODBC Connections)

Enable Connection Pooling in the ODBC Driver for best performance

In which cases would you want to use high performance mode and in which cases would you not want to?

[ImportBot]

Originally Posted by sp37zn4z*:

 

can anyone suggest a procon layer hosting that allows odbc connector to be installed on the procon machine? and have a mysql database support? most of the procon hosting i'm seeing don't have this.

[ImportBot]

Originally Posted by GitSum*:

 

can anyone suggest a procon layer hosting that allows odbc connector to be installed on the procon machine? and have a mysql database support? most of the procon hosting i'm seeing don't have this.

Branzone is pretty reasonable - full ftp access, has the odbc driver installed ready to go

 

http://www.branzone.com/

[ImportBot]

Originally Posted by sp37zn4z*:

 

Branzone is pretty reasonable - full ftp access, has the odbc driver installed ready to go

 

http://www.branzone.com/

hi gitsum, do they support also MySQL database? have you tried their services with this plugin? does it work?

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

The problem is the Next with playtime. No any error message.

When anyone playing on the server, the playtime are saved the end of round.

But the playtime is 3.4x bigger than real.

It measured with clock.

[ImportBot]

Originally Posted by XpKiller*:

 

In which cases would you want to use high performance mode and in which cases would you not want to?

If you running a 64 slot server with all features enabled in the plugin with a big DB and your DB server is not fast enough to respond below one second for certain querys. The plugin would need to wait longer as needed for the MySQL because the plugin execute the query in row if high performance mode is off.

This won't effect procon because those widths are running in own threads.

 

In short words with performance mode on the plugin tries to execute every query instant and don't need to wait anymore.

 

Sorry I'm only online with my smartphone I will respond to the other questions later.

[ImportBot]

Originally Posted by sp37zn4z*:

 

found a bug where when you type !TOP10 AFASLDKFJLASDFJLASKDJ (or any keyword that doesn't exist in the database) causes the procon client to crash to desktop. I use procon client not procon layer. Tried to rollback previous version and the bug disappears at version 0.1.2bet downwards. 0.1.3beta to latest version have this bug. Please check.

[ImportBot]

Originally Posted by CptChaos*:

 

can anyone suggest a procon layer hosting that allows odbc connector to be installed on the procon machine? and have a mysql database support? most of the procon hosting i'm seeing don't have this.

Why does it have to be hosted by a company? Installing your own Procon layer or database isn't that hard and wouldn't cost a thing! And you also have the freedom to do with it what you want it should do.

[ImportBot]

Originally Posted by sp37zn4z*:

 

Why does it have to be hosted by a company? Installing your own Procon layer or database isn't that hard and wouldn't cost a thing! And you also have the freedom to do with it what you want it should do.

yeah i end up hosting it myself.

[ImportBot]

Originally Posted by GitSum*:

 

hi gitsum, do they support also MySQL database? have you tried their services with this plugin? does it work?

I do not know about the database but this plugin does work with our layer server at Branzone. Our database is located at our GSP - they provide a free web server (with databases) when you rent a game server - NFO

 

I used to host our layer server - but by moving it to a hosting company, other clan members can now stop/ restart it very easily through a web page if for some reason it goes down. I think a one layer server is like $3 a month. I believe a small portion of that goes to phogue in a 'license fee" - so it also helps them out