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

[ImportBot]

Originally Posted by Phil_K*:

 

HI.

 

Yeah, why is your plugin now creating duplicate M416 column entries just because there is a new weapon definition in the BF3.def file?

It's not only a new definition.

Like i wrote both entries are unique in the weapon definitions & the loc files.

Looking at the loc files and what GetWeaponList returns you see one "M416" and one "M416 Assault Rifle". (au.loc)

 

This done because if both loc entries would share the same string the reverse function may pick the wrong onKill weapon string if you want to know which weapon onKill code is behind "M416 Assault Rifle" for example.

 

As i said, i don't know what the plugin does on its internal, but i would try not to use language related strings into the DB but the underlaying onKill Weapon codes and / or merge them based on a regex to one combined instance.

 

Even so at the moment it is not clear if the use of M416 instead of Weapon/.... by the server is intended because its another weapon model or something like that or just a change in code which sets the old onKill weapon code useless.

 

Greets

Phil.

[ImportBot]

Originally Posted by TimSad*:

 

Oh yeah, I was aware that GetWeaponList used the localization. Musta just mixed things up for a second there.

 

As i said, i don't know what the plugin does on its internal, but i would try not to use language related strings into the DB but the underlaying onKill Weapon codes and / or merge them based on a regex to one combined instance.

Oops! I already do this in my "Server Kills" plugin. I guess we just better hope that people don't need to change their language or the weapon names inside the loc files don't need to be changed, huh? I see now that it really probably would have been best to use the onKill weapon strings...

[ImportBot]

Originally Posted by TimSad*:

 

Happen to have an update coming before Close Quarters' release that fixes the duplicate column thing? I wanna get stats going for my Close Quarters server but not with it spamming up the plugin console. Though, I suppose I could look into your code and disable it myself, huh?

[ImportBot]

Originally Posted by Mandizzy*:

 

Yeah, I've got it disabled too and waiting for an update.

[ImportBot]

Originally Posted by XpKiller*:

 

@Mandizzy & TimSad

 

there is no real bug in the plugin just the latest bf3.def files contains two definitions for the same weapon. That is the problem.

 

Just remove the deprecated entry and everything is fine.

 

 

@Phil_K

i dont use language related strings.

I use the definitions:

Code:

WeaponDictionary weapons = this.GetWeaponDefines();

[ImportBot]

Originally Posted by Phil_K*:

 

Hi.

 

Okay, my fault... while talking about M416 I had the impression its something with the name just taking the first part up to the space to get the pure weapon name and use it for the M416_kills column name.

 

GetWeaponDefines() gives you a list of unique weapons, so no problem with that.

 

Don't get me wrong I don't say and haven't said your plugin does wrong, but at the moment we do not really know if the "Weapons/M416/M416" is deprecated or introduced by intention.

 

I've mailed Mikael about it and hope to get an answer. As soon if it is clear which of the code will stays in I'll remove the deprecated one.

 

But meanwhile perhaps the check at line 5953+ can be enhanced for situations like this.

 

Greets

Phil.

[ImportBot]

Originally Posted by colaiutavinnie*:

 

Hello, I just installed the plugin, removed the duplicate M416 line in bf3.def.

It starts but with this error:

 

[13.07.56 59] Index #0

[13.07.56 59] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.63-community]Incorrect datetime value: '2012-06-10 12:56:11.546000000' for column 'TimeMapLoad' at row 1

[13.07.56 59] Native: 1292

[13.07.56 59] Source: myodbc5.dll

[13.07.56 59] SQL: HY000

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Getting an error this morning using the BF3 Stats Plugin. Can anyone tell me how to fix this?

The details of the error are below.

 

[12:21:19 52] Error in Tablebuilder:

[12:21:19 58] Index #0

[12:21:19 58] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:21:19 58] Native: 1060

[12:21:19 61] Source: myodbc5.dll

[12:21:19 61] SQL: 42S21

[12:21:22 14] Error in Tablebuilder:

[12:21:22 14] Index #0

[12:21:22 14] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:21:22 14] Native: 1060

[12:21:22 14] Source: myodbc5.dll

[12:21:22 15] SQL: 42S21

[12:21:24 67] Error in Tablebuilder:

[12:21:24 68] Index #0

[12:21:24 68] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:21:24 68] Native: 1060

[12:21:24 68] Source: myodbc5.dll

[12:21:24 68] SQL: 42S21

[12:21:27 24] Error in Tablebuilder:

[12:21:27 24] Index #0

[12:21:27 24] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:21:27 24] Native: 1060

[12:21:27 24] Source: myodbc5.dll

[12:21:27 24] SQL: 42S21

[12:21:29 77] Error in Tablebuilder:

[12:21:29 77] Index #0

[12:21:29 77] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:21:29 78] Native: 1060

[12:21:29 78] Source: myodbc5.dll

[12:21:29 78] SQL: 42S21

[12:21:52 51] Error in Tablebuilder:

[12:21:52 51] Index #0

[12:21:52 51] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:21:52 51] Native: 1060

[12:21:52 51] Source: myodbc5.dll

[12:21:52 51] SQL: 42S21

[12:21:55 20] Error in Tablebuilder:

[12:21:55 20] Index #0

[12:21:55 20] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:21:55 20] Native: 1060

[12:21:55 20] Source: myodbc5.dll

[12:21:55 20] SQL: 42S21

[12:22:22 92] Error in Tablebuilder:

[12:22:22 92] Index #0

[12:22:22 93] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:22:22 93] Native: 1060

[12:22:22 93] Source: myodbc5.dll

[12:22:22 93] SQL: 42S21

[12:22:25 63] Error in Tablebuilder:

[12:22:25 63] Index #0

[12:22:25 63] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-24+lenny5]Duplicate column name 'M416_kills'

[12:22:25 64] Native: 1060

[12:22:25 64] Source: myodbc5.dll

[12:22:25 65] SQL: 42S21

Thanks in advance...

[ImportBot]

Originally Posted by Phil_K*:

 

Getting an error this morning using the BF3 Stats Plugin. Can anyone tell me how to fix this?

The details of the error are below.

Did you read this thread a few pages before your post?

See www.phogue.net/forumvb/showth...-6-BF3/page106*

you may want to change your procons options not to do auto-update-checks and comment out the Weapons/M416/M416 line in the BF3.def file.

 

Or wait until it's clear why DICE introduced a new weapon coder for that weapon.

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Did you read this thread a few pages before your post?

See www.phogue.net/forumvb/showth...-6-BF3/page106*

you may want to change your procons options not to do auto-update-checks and comment out the Weapons/M416/M416 line in

the BF3.def file.

 

Or wait until it's clear why DICE introduced a new weapon coder for that weapon.

I don't have a clue how to change or delete anything in phpmyadmin.

Should I just wait for EA to fix it?

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Ok I have done as asked and all seems ok.

 

I will wait for an update so it can be enabled again.

Thanks for the fast reply..

[ImportBot]

Originally Posted by XpKiller*:

 

@colaiutavinnie

 

which odbc driver do you use atm?

 

dont use 5.1.11 it is buggy use 5.1.9 instead.

[ImportBot]

Originally Posted by XpKiller*:

 

Hi.

 

Okay, my fault... while talking about M416 I had the impression its something with the name just taking the first part up to the space to get the pure weapon name and use it for the M416_kills column name.

 

GetWeaponDefines() gives you a list of unique weapons, so no problem with that.

 

Don't get me wrong I don't say and haven't said your plugin does wrong, but at the moment we do not really know if the "Weapons/M416/M416" is deprecated or introduced by intention.

 

I've mailed Mikael about it and hope to get an answer. As soon if it is clear which of the code will stays in I'll remove the deprecated one.

 

But meanwhile perhaps the check at line 5953+ can be enhanced for situations like this.

 

Greets

Phil.

yeah i will enhance that.

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't have a clue how to change or delete anything in phpmyadmin.

Should I just wait for EA to fix it?

This has nothing to do with phpMyAdmin. He is saying to remove the duplicate 'Weapons/M416/M416' line from your BF3.def file which is a PRoCon file. If you use a PRoCon layer, you need to edit the file on your PRoCon Layer Host's server.

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 1.0.0.7!

 

Changelog:

 

1.0.0.7

Fix for the tablebuilder module its now more robust (solves the bf3.def issue you turn autoupdate on again.)

Optimized Updateranking querys for better perfromance and locking behavior in large databases with many server.

[ImportBot]

Originally Posted by gabipaci*:

 

Hi XpKiller!

 

I just try find a solider in our database, and no result.

He just join our server, and play couple of rounds. Server is full, and i just check the database after the round.

Sort by "last seen on server"

I see only 20players who play on the last10 minutes.

Server is full before and after end of round (32 slots)

 

Plugin version 1.0.0.6

 

Have u any idea?

 

Attached Files:

• procon.jpg

[ImportBot]

Originally Posted by cortez471*:

 

Hi guys, need a little help with getting the plugin to work.

 

We have the MySQL installed and setup and procon is running on the same machine as the database.

 

[22:10:02 34] Error in Tablebuilder:

[22:10:02 36] Index #0

[22:10:02 36] Message: [MySQL][ODBC 5.1 Driver]Access denied for user 'battlefielduser'@'localhost' (using password: YES)

[22:10:02 37] Native: 1045

[22:10:02 37] Source:

[22:10:02 39] SQL: HY000

[22:10:02 39] Index #1

[22:10:02 42] Message: [MySQL][ODBC 5.1 Driver]Access denied for user 'battlefielduser'@'localhost' (using password: YES)

[22:10:02 42] Native: 1045

[22:10:02 44] Source:

[22:10:02 44] SQL: HY000

[22:10:02 45] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

 

 

Thats the error we get when the plugin in enabled. could u help solve this problem. We are running windows server 2008 if that helps.

[ImportBot]

Originally Posted by XpKiller*:

 

Hi XpKiller!

 

I just try find a solider in our database, and no result.

He just join our server, and play couple of rounds. Server is full, and i just check the database after the round.

Sort by "last seen on server"

I see only 20players who play on the last10 minutes.

Server is full before and after end of round (32 slots)

 

Plugin version 1.0.0.6

 

Have u any idea?

Properly its a problem with new rcon bugs. Some other plugins have problems too. The rcon dont deliver guid and ip sometimes. My plugin skips empty guid because the guid is needed for storage in the database.

 

So this is no general problem with the plugin

 

See also:

www.phogue.net/forumvb/showth...-their-updates*

[ImportBot]

Originally Posted by XpKiller*:

 

@cortez471

Check you permission of you db user.

Access denied means that there is something wrong with the permissions.

[ImportBot]

Originally Posted by gabipaci*:

 

Properly its a problem with new rcon bugs. Some other plugins have problems too. The rcon dont deliver guid and ip sometimes. My plugin skips empty guid because the guid is needed for storage in the database.

 

So this is no general problem with the plugin

 

See also:

www.phogue.net/forumvb/showth...-their-updates*

Thanks for quick reply.

 

Regards

[ImportBot]

Originally Posted by cortez471*:

 

Thanks for the reply, had a look and we granted full access to the user battlefielduser and it's not fixing anything ^^

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi guys, need a little help with getting the plugin to work.

 

We have the MySQL installed and setup and procon is running on the same machine as the database.

 

[22:10:02 34] Error in Tablebuilder:

[22:10:02 36] Index #0

[22:10:02 36] Message: [MySQL][ODBC 5.1 Driver]Access denied for user 'battlefielduser'@'localhost' (using password: YES)

[22:10:02 37] Native: 1045

[22:10:02 37] Source:

[22:10:02 39] SQL: HY000

[22:10:02 39] Index #1

[22:10:02 42] Message: [MySQL][ODBC 5.1 Driver]Access denied for user 'battlefielduser'@'localhost' (using password: YES)

[22:10:02 42] Native: 1045

[22:10:02 44] Source:

[22:10:02 44] SQL: HY000

[22:10:02 45] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

 

 

Thats the error we get when the plugin in enabled. could u help solve this problem. We are running windows server 2008 if that helps.

Have you tested to make sure localhost is a valid reference to self? If it isn't specified in your HOSTS file, the operating system won't know that localhost is referring to 127.0.0.1.

[ImportBot]

Originally Posted by leibhold*:

 

Sometimes, when you connect due to stupity in the drivers, you have to create a user on the database called battlefielduser@localhost

 

I have had the issue where I have a user called battlefielduser but it (driver) is actually sending battlefielduser@localhost - so create a user on the database called battlefielduser@localhost

 

DOnt assume you are using phpmyadmin but here is a shot of it

 

Capture.JPG

 

So instead of anyhost use localhost.

 

Pretty much the same deal with sql on 2008.

[ImportBot]

Originally Posted by XpKiller*:

 

You should also check you password. It might be containing special chars which procon uses for stuff too

[ImportBot]

Originally Posted by colaiutavinnie*:

 

@colaiutavinnie

 

which odbc driver do you use atm?

 

dont use 5.1.11 it is buggy use 5.1.9 instead.

I replaced 5.1.11 with 5.1.9 and now it looks work.

It runs entire day but when i write !stats or !rank in chat it says that i need to wait next match to get stats and it can't stream stats ingame.

[ImportBot]

Originally Posted by nztrigger*:

 

someone needs to make a video on how to setup this

[ImportBot]

Originally Posted by cortez471*:

 

Ok all is ok with that error now, i can log into the database. the error was that for some reason it did not like that user so we just used the root user and it's working now.

 

Now a new problem has arrived, at the end of the round it won't save to the database, well i think it's not saving but the error is caused by a time difference of about 30 minuites. The database is trying to input a time of 11am lets say but the server time is 11:30am, now i know there a plugin option for this but my question is by how much should i add the time offset to?

[ImportBot]

Originally Posted by Athlon*:

 

someone needs to make a video on how to setup this

Not a video, but pretty damn close....

 

www.phogue.net/forumvb/showth...-Configuration*

[ImportBot]

Originally Posted by Bl1ndy*:

 

With the new version our stats are no longer updated on our stats page, everything is being logged except stats.

 

http://bye.branspace.com/statscanals/index.php

 

My stats say im last seen on 10/6 but i've just been playing on it. I've recieved a couple of reports from players saying theyre kills are "stuck".

 

Any idea what might be causing this?

[ImportBot]

Originally Posted by XpKiller*:

 

@Blindy

 

Please dont shoot that fast, the reason is not by the plugin.

Reason for that is because a bug in the rcon protocol. the plugin needs the guids to log stats if no guid present no stats can be logged.

www.phogue.net/forumvb/showth...rver-is-coming*

 

Anyway i didnt change anything on the statstracking since the last 5 versions.