Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by XpKiller*:

 

i got many request like: pls change this keep the tablenames lowercase

So i did it

The tablemodfier is working though but these php i did written need a fix too it looks a little bit like i sould write my own script ^^.

[ImportBot]

Originally Posted by SexDrugOverclocking*:

 

Code:

[18:47:43 65] Error in SQLQuery: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is connecting. 
   at System.Data.Odbc.OdbcConnection.SetStateExecuting(String method, OdbcTransaction transaction) 
   at System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) 
   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 PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

Code:

[20:45:52 61] Error: System.InvalidOperationException: The transaction is either not associated with the current connection or has been completed. 
   at System.Data.Odbc.OdbcConnection.SetStateExecuting(String method, OdbcTransaction transaction) 
   at System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) 
   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.ExecuteNonQuery() 
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

Since the ProCon stats are "newer" then WolfCon stats I only host them for about 25 customers, many of which don't really monitor ProCon, etc.

 

Recently a few customers have noticed some SQL errors (posted above), however stats and chat update normally and my MySQL server is running fine so I am not sure what the issue is.

 

We also noticed that player "Play Time" seems to reset after 60 hours.

 

These errors are not ALL the time and we are currently testing my theory that they are related to "Log ServerSPAM" enabled.

 

 

Can you tell me what these error messages mean and if its something to do with my MySQL server or the plugin?

 

Thanks in advance!

[ImportBot]

Originally Posted by GrossKopf*:

 

i got many request like: pls change this keep the tablenames lowercase

So i did it

The tablemodfier is working though but these php i did written need a fix too it looks a little bit like i sould write my own script ^^.

Not sure what the tablemodifier is supposed to do, but it doesn't convert everything to lower case. After running it, I have both upper case and lower case table names and everyone that has upgraded had to have their stats reset, basically requiring me to remove all the tables and let their stats repopulate.

[ImportBot]

Originally Posted by GrossKopf*:

 

Ok, deleted the tables in one customer's database, running 2.02, some data is now in the database, but this error is coming up:

 

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/phs/public_html/procon/garnock/index.php on line 19

http://procon.host4admins.com/garnock/

[ImportBot]

Originally Posted by Brazin*:

 

Just reformatted the WinXP machine running the plugin to get it on Win7 x64.

 

I'm still getting the same error as described before while trying to make the plugin connect to a database hosted on the same machine as the plugin.

 

This is getting really frustrating.

 

Error: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.49-community]Field 'AEK971_kills' doesn't have a default value

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.CChatGUIDStatsLogger.StartStreaming()

[ImportBot]

Originally Posted by XpKiller*:

 

Code:

[18:47:43 65] Error in SQLQuery: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is connecting. 
   at System.Data.Odbc.OdbcConnection.SetStateExecuting(String method, OdbcTransaction transaction) 
   at System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) 
   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 PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

Code:

[20:45:52 61] Error: System.InvalidOperationException: The transaction is either not associated with the current connection or has been completed. 
   at System.Data.Odbc.OdbcConnection.SetStateExecuting(String method, OdbcTransaction transaction) 
   at System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) 
   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.ExecuteNonQuery() 
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

Since the ProCon stats are "newer" then WolfCon stats I only host them for about 25 customers, many of which don't really monitor ProCon, etc.

 

Recently a few customers have noticed some SQL errors (posted above), however stats and chat update normally and my MySQL server is running fine so I am not sure what the issue is.

 

We also noticed that player "Play Time" seems to reset after 60 hours.

 

These errors are not ALL the time and we are currently testing my theory that they are related to "Log ServerSPAM" enabled.

 

 

Can you tell me what these error messages mean and if its something to do with my MySQL server or the plugin?

 

Thanks in advance!

Hi

 

i know these errors, but i dont know why they appear i think they are ODBC or MYSQLServer related.

and im 100% sure that these errors has nothing to do with "Log ServerSPAM" enabled.

Both errors are Problems with the connection to the mysql Server.

 

This thing with Playtime i will take a lot at it on our Server the Playtime is working.

[ImportBot]

Originally Posted by XpKiller*:

 

Just reformatted the WinXP machine running the plugin to get it on Win7 x64.

 

I'm still getting the same error as described before while trying to make the plugin connect to a database hosted on the same machine as the plugin.

 

This is getting really frustrating.

 

Error: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.49-community]Field 'AEK971_kills' doesn't have a default value

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.CChatGUIDStatsLogger.StartStreaming()

i tested my Plugin under Windows 7 64bit with a VM --> Everthing is fine.

[ImportBot]

Originally Posted by XpKiller*:

 

i got many request like: pls change this keep the tablenames lowercase

So i did it

The tablemodfier is working though but these php i did written need a fix too it looks a little bit like i sould write my own script ^^.

Not sure what the tablemodifier is supposed to do, but it doesn't convert everything to lower case. After running it, I have both upper case and lower case table names and everyone that has upgraded had to have their stats reset, basically requiring me to remove all the tables and let their stats repopulate.

The tablemodfifer working definitively i tested it with my own tables.

[ImportBot]

Originally Posted by GrossKopf*:

 

The tablemodfifer working definitively i tested it with my own tables.

When I ran it, it added tables in lower case and did nothing to the tables with mixed upper and lower case. I could see the old tables still had their data. Wasn't there a way for you make it so it just converted the existing tables to lower case or to copy the data from the old tables to the new ones? What about the php code that displays the chat, GUID and stats? That doesn't seem to work with this version because it's looking for tables in different formats?

 

What about this problem: viewtopic.php_f=18&t=694&start=200#p7918*

[ImportBot]

Originally Posted by Panther*:

 

there is somthing else wrong with the stats logger.

it doesn't count kills and deaths as it should

 

we bought a new server and started statslogger on it

i played a whole round where the statsloger showed me 10:1 K/D (first round).

but my score was totaly diffrent.

 

than i played another round with a kd of 16/12

 

so in the stats there should be

 

26/13 but it showes 24/3.

there is something not working correctly.

rcon tool was only all time and i have 2 servers running on one procon tool

[ImportBot]

Originally Posted by XpKiller*:

 

there is somthing else wrong with the stats logger.

it doesn't count kills and deaths as it should

 

we bought a new server and started statslogger on it

i played a whole round where the statsloger showed me 10:1 K/D (first round).

but my score was totaly diffrent.

 

than i played another round with a kd of 16/12

 

so in the stats there should be

 

26/13 but it showes 24/3.

there is something not working correctly.

rcon tool was only all time and i have 2 servers running on one procon tool

I can't believe that are u sure?

[ImportBot]

Originally Posted by Panther*:

 

yes. also other user reported that the stats didn't count correctly.

 

EDIT:

I tested it again on my two servers.

The points are recorded correctly but the kill and death don't count correctly.

 

Kind Regards

Panther

[ImportBot]

Originally Posted by XpKiller*:

 

yes. also other user reported that the stats didn't count correctly.

 

EDIT:

I tested it again on my two servers.

The points are recorded correctly but the kill and death don't count correctly.

 

Kind Regards

Panther

Hi found the stupid bug update comes soon

[ImportBot]

Originally Posted by Panther*:

 

found it too:

 

Code:

if(blheadshot)
				{
					CUsedWeapon killinfo = new CUsedWeapon(1,1,0);
					this.dicWeap.Add(strweaponType,killinfo);
				}
				else
				{
					CUsedWeapon killinfo = new CUsedWeapon(1,0,0);
					this.dicWeap.Add(strweaponType,killinfo);
				}

the this._Kills++ is missing here. same with death.

 

Kind Regards

Panther

[ImportBot]

Originally Posted by XpKiller*:

 

New version is up really a stupid bug anyway

 

Update

 

The Sandbox dont need to be disabled anymore!!!

[ImportBot]

Originally Posted by GrossKopf*:

 

Hi found the stupid bug update comes soon

Any update to the website code so we can view our database contents online again? The code stopped working when 2.02 came out.

[ImportBot]

Originally Posted by Panther*:

 

no, this is not stupid at all.

 

do not forgett that your code 3000 lines long. nobody expacts from somebody who is doing this for free and as a hobby to make it bug free.

 

your work is realy excellent. i used it as layer for my TrueBalancer.

 

Great work. Keep up the good work!!!

 

Regards

Panther

 

 

Hi found the stupid bug update comes soon

Any update to the website code so we can view our database contents online again? The code stopped working when 2.02 came out.

i dont know how. i have 2.02 installed and i use the newest website code 0.98 and everything is working fine here.

[ImportBot]

Originally Posted by XpKiller*:

 

Hi found the stupid bug update comes soon

Any update to the website code so we can view our database contents online again? The code stopped working when 2.02 came out.

i will write a fix for it now but again i did wrote this script

[ImportBot]

Originally Posted by GrossKopf*:

 

i dont know how. i have 2.02 installed and i use the newest website code 0.98 and everything is working fine here.

As far as I can tell, that tablemodifier.sql changed the tables into lower case, but didn't copy over any data, so when my customers try viewing their stats, they get errors so as far as I know, the web interface to view the stats, chat and GUID's doesn't work. When I deleted the tables for a customer, the stats continued to go into the database, but nothing gets displayed. An error appears about a table missing. Never should have modified the table names. Linux needs case sensitive and with the change to lower case, it messed things up on my linux webserver

[ImportBot]

Originally Posted by XpKiller*:

 

Fixed Version of the simple Viewer

Download:

[ImportBot]

Originally Posted by Panther*:

 

it looks like the welcome message for a newcommer is not working.

 

you are using:

Code:

SQL = @"SELECT [...]
									WHERE SoldierName ='"+strSpeaker+"'";

But for a newcommer (in this case: strSpeaker) such a Soldiername doesn't exist in the database.

 

Further down you use a if function.

and you are using result[0] or something like that for that if fucntion. It looks like this if function is broken, if there is no strSpeaker in the database, because no message is appearing at all for a newcommer.

 

is it possibel for you to make a diffrent if function like:

if(database.contains.soldiername==false)

 

Welcomestats working for players who return to the server.

[ImportBot]

Originally Posted by XpKiller*:

 

This feature is working take closer look at the code.

[ImportBot]

Originally Posted by Panther*:

 

i tested it with a new character on our server.

i also resetet the whole database because the k/d was wrong.

 

when a player REjoins the server: he get his message: WELCOME BACK!

 

but if a NEWcommer joins the server -- no welcomemessage at all

 

test it yourself and you will see.

[ImportBot]

Originally Posted by Stryker412*:

 

Can anyone share with me their stats page? I'd like to see what it looks like.

[ImportBot]

Originally Posted by XpKiller*:

 

i tested it with a new character on our server.

i also resetet the whole database because the k/d was wrong.

 

when a player REjoins the server: he get his message: WELCOME BACK!

 

but if a NEWcommer joins the server -- no welcomemessage at all

 

test it yourself and you will see.

ok i will look at it.

[ImportBot]

Originally Posted by SexDrugOverclocking*:

 

Is there any fix or need for a fix for the errors I posted about on page 22 of this forum topic?

[ImportBot]

Originally Posted by Flyswamper*:

 

Forgive me if an answer to my question/suggestion is hiding somewhere in the 24 pages of posts (which I didn't read all of them...)

 

 

As this plug-in writes a record to the database, *IT WOULD BE NICE* if one of the fields being written to the database identified the game-server that the record was being generated by. This would allow using a single database and table to track multiple game servers but still be able to process the data later to separate what records came from each game-server.

 

 

Apologies if this is already being written and I'm just ignorant of that fact.

[ImportBot]

Originally Posted by XpKiller*:

 

Forgive me if an answer to my question/suggestion is hiding somewhere in the 24 pages of posts (which I didn't read all of them...)

 

 

As this plug-in writes a record to the database, *IT WOULD BE NICE* if one of the fields being written to the database identified the game-server that the record was being generated by. This would allow using a single database and table to track multiple game servers but still be able to process the data later to separate what records came from each game-server.

 

 

Apologies if this is already being written and I'm just ignorant of that fact.

hi

 

i will add a feature that give the tables a prefix(which you can choose) like tbl_playerstats_server1 instead of tbl_playerstats

 

would this be suiteable? because in the table i cant add a column with this function it wont work.

[ImportBot]

Originally Posted by Flyswamper*:

 

Thanks, but.... I don't think that will accomplish what I was thinking.

 

The issue / idea is because of this:

 

We are using GrossKopf's professional hosting services to run our master copy of ProCon. (and I have nothing but good things to say about all my experiences with his service...both now and back at Wolf Servers).

 

Anyway... we took him up on his offer to setup the Mysql database and links and configure ProCon to get it all working. We are using ProCon to monitor more than one game-server. To prevent proliferation of databases and tables on his professionally hosted site/services.... I believe he defaults to setting ProCon up so that it stores records/entries from ALL the game-servers being monitored by ProCon into a common database and even into a common table. Of course, he sets up a new table (and/or new database_) for each client.... But...I don't think it made sense for him to have such a proliferation of database tables.

 

Now... he did offer for an insignificant fee to make a special case for me/us and setup separate tables for our game servers that get monitored. Maybe I should just take him up on that idea? I dunno. But..... I came here fishing for whether it might not make more sense and be a better global solution for people monitoring multiple servers to just add a field to the database tables identifying the source-server.

 

Now.... as I type this and think about it... I can imagine that my idea might be fine in concept, but would probably not be workable unless everybody was OK with starting-over with their database records... So... maybe my fishing expedition was a bit misguided?

 

Anyway.... no need for the table-prefix business for me. Maybe it will help others, but I was really curious about the extra field within the table and whether or not that would be workable.

[ImportBot]

Originally Posted by GrossKopf*:

 

I believe he defaults to setting ProCon up so that it stores records/entries from ALL the game-servers being monitored by ProCon into a common database and even into a common table.

Each customer has their own database. If that customer has more than one server, all of their servers go into one database. It sounds like you think that every customer's server is in one database, which isn't how it works (in case that's what you were thinking).