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

[ImportBot]

Originally Posted by XpKiller*:

 

@SoulReaper

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

 

The mysql server unexpectedly closes the connection --> no error of the plugin.

 

@DiD_StratManiac

 

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

 

The mysql Server is not reachable for the plugin anymore. Check your mysql server. And again no error of the plugin. The mysql server causes this problem.

[ImportBot]

Originally Posted by rgb*:

 

Hi,

I put the plugin on Procon , I make all settings and the plugin works fine.

When I put the plugin on Procon Layer, I got this:

 

[07:10:13] Error: System.DllNotFoundException: libodbc.so

at (wrapper managed-to-native) System.Data.Odbc.libodbc:SQLAllocHandle (System.Data.Odbc.OdbcHandleType,intptr,intptr&)

at System.Data.Odbc.OdbcConnection.Open () [0x00000] in :0

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder () [0x00000] in :0

 

Please tell me what to do so I can tell to my hosting provider.

Thanks.

[ImportBot]

Originally Posted by Mgalbraith*:

 

HI,

 

Can you advise why i am getting this error and what the resolution is? There are too many posts here to go looking for the last time this was asked/answered - may a FAQ at the front would be good.

 

[19:57:25 67] Error: Error in Startstreaming:

[19:57:25 75] Index #0

[19:57:25 77] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.25a]Out of range value for column 'Playtime' at row 7

[19:57:25 77] Native: 1264

[19:57:25 77] Source: myodbc5.dll

[19:57:25 78] SQL: HY000

 

the server has been running fine previously without any changes.

[ImportBot]

Originally Posted by ty_ger07*:

 

HI,

 

Can you advise why i am getting this error and what the resolution is? There are too many posts here to go looking for the last time this was asked/answered - may a FAQ at the front would be good.

 

[19:57:25 67] Error: Error in Startstreaming:

[19:57:25 75] Index #0

[19:57:25 77] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.25a]Out of range value for column 'Playtime' at row 7

[19:57:25 77] Native: 1264

[19:57:25 77] Source: myodbc5.dll

[19:57:25 78] SQL: HY000

 

the server has been running fine previously without any changes.

Did you see this in the release notes?

Attention:

ODBC MYSQL Driver 5.1.11 is buggy and will cause faulty date entires.

http://bugs.mysql.com/bug.php_id=65418

Thx to johnny5 for the find

 

Its recommend to use the 5.1.9 Driver

I don't know which version of the ODBC driver you are using, but that is my guess.

 

Either that, or you may have a player with a play time (server seeder maybe) which is in excess of the MySQL database column limit. The default limit I am seeing (at least for my old version of the BF3 stats plugin I am using) is an integer with 10 decimal places. What is that? 9.9 billion seconds? I wouldn't see that you would exceed that.

[ImportBot]

Originally Posted by Mgalbraith*:

 

My driver is 5.1.9.

 

obdc.png

 

Any other suggestions to resolve the error?

 

Thanks

[ImportBot]

Originally Posted by Mgalbraith*:

 

anyone?

[ImportBot]

Originally Posted by jstm*:

 

I receive the same error for a lot of people stats update at the and of round

 

Out of range value for column 'Playtime'

 

ODBC ver is 5.1.9

[ImportBot]

Originally Posted by XpKiller*:

 

@Mgalbraith and jstm

 

Run this on you DB:

Code:

ALTER TABLE `tbl_sessions` 
CHANGE COLUMN `Playtime` `Playtime` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'  ;

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 1.0.0.8beta

 

Changelog:

1.0.0.8

Fix for ServerInfo and Playerlist issue which could trigger more updates as needed.(Reduces DB Load) This behavior was causes by other plugin which request additional ServerInfo and Playerlist events.

Added new feature K/D correction.(experimental)

 

What is new:

KD Correction (still needs some testing)

Possibility to let the plugin write the currentplayerlist to DB. (this work in progress if you want to try this please write me a pm.)

[ImportBot]

Originally Posted by Taleeso*:

 

Is it possible to configure the update for the ingame stats every 30 or 60 sec.. ive got dedicated hardware for my procon layer.. load should be no prob...

[ImportBot]

Originally Posted by XpKiller*:

 

@Taleeso

 

not possible would need a massive amount of code change. I dont have the time to do that.

[ImportBot]

Originally Posted by dyn*:

 

Congrats on 1,000 posts and thank you for proving a great plugin. Your tool makes looking up past users very easy.

[ImportBot]

Originally Posted by Skaro*:

 

Hey,

I just installed the plugin but I get no messages ingame. MySQL does and he created the tables

[ImportBot]

Originally Posted by lothop*:

 

As in welcome messages etc?

[ImportBot]

Originally Posted by Skaro*:

 

As in welcome messages etc?

oh its works lol

[ImportBot]

Originally Posted by pharbehind*:

 

Seems like the Weapon Table keyword list doesn't contain all weapons. Are they easy to add? Does someone already have an updated list?

[ImportBot]

Originally Posted by XpKiller*:

 

The Weapon Table keyword list is just for user friendly names for the some weapons and dont reflect all weapons tracked by the plugin. The plugin knows all weapons which has procon in his bf3.def file. If the bf3.def gets new weapons the tables get updated as well fully automatically.

[ImportBot]

Originally Posted by pharbehind*:

 

Ah, gotcha. So, if I wanted to add another keyword for the 240b, for example, I'd just add it there? I'd first have to find the strict name in bf3.def file? Thanks!

[ImportBot]

Originally Posted by XpKiller*:

 

i would guess this:

 

bf3.def

Code:

...
procon.protected.weapons.add Support "M240" Primary LMG
...

For the keyword list

Code:

M240{240B}

now entering

 

@stats 240b should bring up stats for that weapon(M240)

[ImportBot]

Originally Posted by pharbehind*:

 

So, as long as players want to use that !stats [weaponName] command, it needs to exist in the Keywords like you demonstrated above?

[ImportBot]

Originally Posted by chuckinbeast*:

 

Forgive me for the potentially dumb question, but if I have this running on a private server would I get the individual weapon stats by player?

[ImportBot]

Originally Posted by XpKiller*:

 

Forgive me for the potentially dumb question, but if I have this running on a private server would I get the individual weapon stats by player?

Yes so far procon know the weapon names

[ImportBot]

Originally Posted by chuckinbeast*:

 

Yes so far procon know the weapon names

I just jizzed in my pants. So if I follow your instructions I will have a database of individual players weaponstats from my private server_?

[ImportBot]

Originally Posted by Mandizzy*:

 

Running into a problem getting this plug-in to work on Windows 2008 R2. I have specified a system DSN in ODBC and plug-in works fine if I start procon normally as a windows program. However, starting it up as a service, it keeps throwing this error:

 

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

 

 

I have even tried setting up a service account and still no luck. Any of you know the solution to this problem?

 

Edit: Here is the solution

 

In a 64 bit windows server operating system, there are TWO odbc managers. When you pull up the usual menu for the odbc / dsn system, it is for the 64 bit odbc manager, and 32 bit applications (vb 6.0) will not work using these dsn's.

 

This is where the 32 bit odbc manager is:

 

C:\Windows\SysWOW64\odbcad32.exe

 

So I just setup a 32 bit system DSN and it works now.

[ImportBot]

Originally Posted by ADKGamers*:

 

I'm sorry if this has been asked before, but didn't finding anything while searching. Are we able to have this going to multiple databases?

[ImportBot]

Originally Posted by XpKiller*:

 

i dont understand your question.

could give me an example?

[ImportBot]

Originally Posted by ADKGamers*:

 

Right now I have it logging to a single database, would I be able to have it log to multiple databases? For example a developer database and then a live database.

[ImportBot]

Originally Posted by XpKiller*:

 

Ah i understand.

 

but this is not possible without massive code changes and it is also not common that a application uses two databases for the same use.

 

If you need a dev DB why not create a systemcopy of the prod db or set up a second instance of the plugin.

[ImportBot]

Originally Posted by Combo77*:

 

Hi,

 

i just finished installing and configuring this plugin. Configuring the database at my gsp ngz-server.de was very easy.

I got one question: I can´t retrieve weaponstats for most weapons. Error Output: "Specific Weapon not found"

The weapons which are defined on the keywords list are working (24 at all).

Is there a complete keyword list i am missing or am i doing something wrong?

 

keyword list

 

RPG-7{RPG}

Weapons/SCAR-H/SCAR-H{SCAR,SCAR-H,SCARH}

USAS-12{USAS12,USAS}

M27IAR{M27}

M16A4{M16,M16A3}

AEK-971{AEK971,AEK}

Weapons/A91/A91{A91,A-91}

Weapons/AK74M/AK74{AK74,AK74M,AK74-M}

Weapons/G36C/G36C{G36C,G36}

Weapons/G3A3/G3A3{G3A3,G3}

Weapons/Gadgets/C4/C4{C4,C-4}

Weapons/Gadgets/Claymore/Claymore{CLAYMORE,CLAY,LANDMINE}

Weapons/KH2002/KH2002{KH2002}

Weapons/Knife/Knife{KNIFE,MESSER}

Weapons/M416/M416{M416,M-416}

Weapons/MagpulPDR/MagpulPDR{MagpulPDR,PDR}

Weapons/MP412Rex/MP412REX{MP412REX,REX,MP412}

Weapons/MP443/MP443{MP443}

Taurus .44{.44,TAURUS,TAURUS.44}

Weapons/P90/P90{P90}

Weapons/Sa18IGLA/Sa18IGLA{Sa18IGLA,Sa18,IGLA}

Weapons/UMP45/UMP45{UMP,UMP-45,UMP45}

Weapons/XP1_L85A2/L85A2{L85A2,L85A,L85}

Glock18{GLOCK}

[ImportBot]

Originally Posted by XpKiller*:

 

Please give me an example for a not working weapon.