ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 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) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 Originally Posted by ToM666*: gabipaci* said: 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 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/ Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 21, 2012 Author Share Posted January 21, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 Originally Posted by XpKiller*: @CptChaos I will check that. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 Originally Posted by GitSum*: XpKiller* said: 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 22, 2012 Author Share Posted January 22, 2012 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by Dragon2203*: I get this error: Quote [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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by CptChaos*: gabipaci* said: 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by ty_ger07*: XpKiller* said: 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by GitSum*: sp37zn4z* said: 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/ Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by sp37zn4z*: GitSum* said: 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by XpKiller*: ty_ger07* said: 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by CptChaos*: sp37zn4z* said: 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by sp37zn4z*: CptChaos* said: 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 23, 2012 Author Share Posted January 23, 2012 Originally Posted by GitSum*: sp37zn4z* said: 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.