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

[ImportBot]

Originally Posted by Bl1ndy*:

 

Ah sorry then mate, i did not know the guids had something to do with stats aswell.

[ImportBot]

Originally Posted by cortez471*:

 

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

thats the same error i am getting and i am using the 5.1.11 but can't revert back to 5.1.9 bit of a noob so if someone can point me in the right place that would be cool.

[ImportBot]

Originally Posted by XpKiller*:

 

@cortez471

 

Atm i know no workaround for that issue with the odbc driver 5.1.11 because my code is correct and the driver is faulty.

[ImportBot]

Originally Posted by cortez471*:

 

ok np, how would i go about removing the 5.1.11 driver and replace it with 5.1.9?

[ImportBot]

Originally Posted by leibhold*:

 

ok np, how would i go about removing the 5.1.11 driver and replace it with 5.1.9?

Urk - what are you running ? different op system have different ways - though usual to stop services using the driver, eg procon, goto control panel, add remove program, or programs and features ( depend on the flavour) MySql connector remove/uninstall

 

Download the other one and install...

 

 

The other question is - is this part of this bug.

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

 

 

 

This result is probably related to SQL mode set upon connection, and engine used for the table you are inserting into

Seems if the table is "set sql_mode='STRICT_ALL_TABLES';" then it will fail

 

mysql> insert into tts values('2012-05-24 15:51:00.055000000');

ERROR 1292 (22007): Incorrect datetime value: '2012-05-24 15:51:00.055000000' for column 'c1' at row 1

If not set - then it reports a warning but will work.

 

mysql> insert into tts values('2012-05-24 15:51:00.055000000');

Query OK, 1 row affected, 1 warning (0.32 sec)

 

mysql> show warnings\G

*************************** 1. row ***************************

Level: Warning

Code: 1265

Message: Data truncated for column 'c1' at row 1

please, check what SQL mode is set in your code (or for your server in my.ini).

[ImportBot]

Originally Posted by TimSad*:

 

Thanks a lot for this update, XpKiller! Just in time for Close Quarters!

 

Here's a full, comprehensive list for the weapon keywords that I've worked up if anybody would like to use it. ...

 

Weapon Keywords:

 

870MCS{870}

AEK-971{AEK971,AEK}

AKS-74u{AKS74,AKS-74,AKS74u,AKS}

AN-94 Abakan{AN94,ABAKAN}

AS Val{VAL,AS,AS-VAL}

DamageArea{DAMAGE}

DAO-12{DAO12,DAO}

Death{}

Defib{DEFIBRILLATOR,DEFIBS}

F2000{}

FAMAS{}

FGM-148{FGM,FGM148}

FIM92{FIM,FIM-92}

Glock18{GLOCK,GLOCK-18}

HK53{HK,HK-53,MP5,MP53}

jackhammer{MK3A1,MK3-A1}

JNG90{JNG,JNG-90}

Knife_RazorBlade{PREMIUM,PREMIUM-KNIFE}

L96{L-96}

LSAT{L-SAT}

M416{M-416}

M417{M-417}

M1014{M-1014}

M15 AT Mine{ATM,M15}

M16A4{M16,M16A3,M16-A3,M16-A4}

M1911{M-1911}

M240{M-240}

M249{M-249}

M26Mass{M26,MASS}

M27IAR{M27,IAR}

M320{M-320,GRENADE-LAUNCHER,TUBE}

M39{M-39}

M40A5{M40,M40-A5}

M4A1{M4}

M60{M-60}

M67{M-67}

M9{M-9}

M93R{M-93R}

Medkit{}

Melee{TAKEDOWN,ANIMATION}

MG36{MG-36}

Mk11{MK-11}

Model98B{M98,M98B}

MP7{MP-7}

Pecheneg{PKP}

PP-19{PP19}

PP-2000{PP2000}

QBB-95{QBB,QBB95}

QBU-88{QBU,QBU88}

QBZ-95{QBZ,QBZ95}

Repair Tool{TORCH,TOOL,REPAIR}

RoadKill{ROAD}

RPG-7{RPG}

RPK-74M{RPK,RPK74,RPK74M}

SCAR-L{SCARL}

SG 553 LB{SG,SG553,SG553LB}

Siaga20k{SAIGA,SAIGA20K}

SKS{}

SMAW{}

SoldierCollision{COLLISION}

SPAS-12{SPAS,SPAS12}

Suicide{}

SV98{SV,SV-98}

SVD{}

Steyr AUG{AUG,AUGA3,STEYR}

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

Type88{TYPE-88}

USAS-12{USAS12,USAS}

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,MAGPUL}

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

Weapons/MP443/MP443{MP443,MP-443}

Weapons/P90/P90{P90}

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

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

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

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

Weapons/XP2_ACR/ACR{ACR,ACWR,ACW-R}

Weapons/XP2_L86/L86{L86,L-86,L86A2,L86-A2}

Weapons/XP2_MTAR/MTAR{MTAR,MTAR-21}

 

 

[ImportBot]

Originally Posted by johnny5*:

 

Urk - what are you running ? different op system have different ways - though usual to stop services using the driver, eg procon, goto control panel, add remove program, or programs and features ( depend on the flavour) MySql connector remove/uninstall

 

Download the other one and install...

 

 

The other question is - is this part of this bug.

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

 

 

 

 

 

Seems if the table is "set sql_mode='STRICT_ALL_TABLES';" then it will fail

 

 

 

 

 

If not set - then it reports a warning but will work.

Thanks for that. I tell ya, it is difficult.

 

I have been playing with computers for a long time, getting every setting all working at once is pretty hard.

 

Now that 5.1.9 works, i will be scared to try newer versions.

 

On win7 php, mysql is basically setup from standard install settings. I havn't changed too many settings.

[ImportBot]

Originally Posted by cyrq*:

 

Thanks a lot for this update, XpKiller! Just in time for Close Quarters!

 

Here's a full, comprehensive list for the weapon keywords that I've worked up if anybody would like to use it. ...

 

Weapon Keywords:

 

870MCS{870}

AEK-971{AEK971,AEK}

AKS-74u{AKS74,AKS-74,AKS74u,AKS}

AN-94 Abakan{AN94,ABAKAN}

AS Val{VAL,AS,AS-VAL}

DamageArea{DAMAGE}

DAO-12{DAO12,DAO}

Death{}

Defib{DEFIBRILLATOR,DEFIBS}

F2000{}

FAMAS{}

FGM-148{FGM,FGM148}

FIM92{FIM,FIM-92}

Glock18{GLOCK,GLOCK-18}

HK53{HK,HK-53,MP5,MP53}

jackhammer{MK3A1,MK3-A1}

JNG90{JNG,JNG-90}

Knife_RazorBlade{PREMIUM,PREMIUM-KNIFE}

L96{L-96}

LSAT{L-SAT}

M416{M-416}

M417{M-417}

M1014{M-1014}

M15 AT Mine{ATM,M15}

M16A4{M16,M16A3,M16-A3,M16-A4}

M1911{M-1911}

M240{M-240}

M249{M-249}

M26Mass{M26,MASS}

M27IAR{M27,IAR}

M320{M-320,GRENADE-LAUNCHER,TUBE}

M39{M-39}

M40A5{M40,M40-A5}

M4A1{M4}

M60{M-60}

M67{M-67}

M9{M-9}

M93R{M-93R}

Medkit{}

Melee{TAKEDOWN,ANIMATION}

MG36{MG-36}

Mk11{MK-11}

Model98B{M98,M98B}

MP7{MP-7}

Pecheneg{PKP}

PP-19{PP19}

PP-2000{PP2000}

QBB-95{QBB,QBB95}

QBU-88{QBU,QBU88}

QBZ-95{QBZ,QBZ95}

Repair Tool{TORCH,TOOL,REPAIR}

RoadKill{ROAD}

RPG-7{RPG}

RPK-74M{RPK,RPK74,RPK74M}

SCAR-L{SCARL}

SG 553 LB{SG,SG553,SG553LB}

Siaga20k{SAIGA,SAIGA20K}

SKS{}

SMAW{}

SoldierCollision{COLLISION}

SPAS-12{SPAS,SPAS12}

Suicide{}

SV98{SV,SV-98}

SVD{}

Steyr AUG{AUG,AUGA3,STEYR}

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

Type88{TYPE-88}

USAS-12{USAS12,USAS}

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,MAGPUL}

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

Weapons/MP443/MP443{MP443,MP-443}

Weapons/P90/P90{P90}

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

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

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

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

Weapons/XP2_ACR/ACR{ACR,ACWR,ACW-R}

Weapons/XP2_L86/L86{L86,L-86,L86A2,L86-A2}

Weapons/XP2_MTAR/MTAR{MTAR,MTAR-21}

 

 

Maybe a stupid question, but how to add those to the database (not manually)? I've pasted it all into the keyword list but all i get is

 

example: Warning: PrepareKeywordDic: Mainkey JNG90 not found!

[ImportBot]

Originally Posted by TimSad*:

 

Maybe a stupid question, but how to add those to the database (not manually)? I've pasted it all into the keyword list but all i get is

 

example: Warning: PrepareKeywordDic: Mainkey JNG90 not found!

For this plugin, you gotta restart the plugin for it to read in those keywords then they can be used in game as such... !stats tool

[ImportBot]

Originally Posted by cyrq*:

 

I've restarted the plugin and also the layer. After that it outupts errors like posted above. When I type !stats JNG-90/JNG90 or whatever new weapon from CC it says "Weapon not found". I've checked the database and there are no tables with the new guns

[ImportBot]

Originally Posted by IceCold*:

 

could you please help ?

what would be the query for deleting all players from database that have not been on a server within the last 2 months ?

[ImportBot]

Originally Posted by Shakal-hh*:

 

is it possible to show the visits of a player?

like "welcome on our server... this is your xx. visit here"

[ImportBot]

Originally Posted by cortez471*:

 

Would it be possible to add in vehical kills table so we can track the stats for people in jets and tanks? if so would you be able to add it in or give me the code in a pm so i can do it

 

Thanks cortez

[ImportBot]

Originally Posted by Phil_K*:

 

Would it be possible to add in vehical kills table so we can track the stats for people in jets and tanks? if so would you be able to add it in or give me the code in a pm so i can do it

BF3 reports kills with all kind of vehicles to land, water & air with just "DEATH", next to some other weapons which raise onKill events with weapon "Death".

 

So, no chance to separate those kills.

[ImportBot]

Originally Posted by leibhold*:

 

is it possible to show the visits of a player?

like "welcome on our server... this is your xx. visit here"

No there is no replacement string for that in the existing code.

[ImportBot]

Originally Posted by maester*:

 

Not sure if it has been posted in the thread could not find it. Stats work fine if you hit !rank and Welcome stats work. However I saw a server where it was yelled kinda like the serverstats messages. However I cant get them to work for some reason. I have tried getting serverstats, Weaponstats, player messages or Top 10 to work. Am I doing something wrong?

 

Chatlogging off

Session On

Statslogging On

Rank by Score On

Enable Ingame On

Send Stats to players On

Enable Welcome Stats On

 

Using ver 1.0.0.7

[ImportBot]

Originally Posted by TimSad*:

 

I've restarted the plugin and also the layer. After that it outupts errors like posted above. When I type !stats JNG-90/JNG90 or whatever new weapon from CC it says "Weapon not found". I've checked the database and there are no tables with the new guns

I think internally, the weapons may be added to the keyword list if found in the database. I think the weapons get added to the database when someone first gets a kill with the specific weapon. Had anyone gotten a kill with the JNG90 on your server that you are aware of?

[ImportBot]

Originally Posted by XpKiller*:

 

No

The weapon column are created from the bf3.def file.

The purpose of keyword list to define userfriendly names for the ingame commands

[ImportBot]

Originally Posted by TimSad*:

 

Okay, cyrq, then that means that your BF3.def wasn't updated. Is it now? If it is, your keyword lists will work and you can use either JNG90 or JNG-90 in chat with !stats...

[ImportBot]

Originally Posted by cyrq*:

 

Okay, cyrq, then that means that your BF3.def wasn't updated. Is it now? If it is, your keyword lists will work and you can use either JNG90 or JNG-90 in chat with !stats...

Uhm, well I thought it was up to date since I've could set all the new maps and modes. Wasn't that the same update? If I understand correctly, the BF3.def file is automatically updated in the background? Can't check it now, cause I'm away from my PC but from what I see there's still no stats registering with the new guns on both of my servers. The layer is hosted at branzone.

[ImportBot]

Originally Posted by XpKiller*:

 

Atm there is still a bug in the rcon protocol of dice which empty guid and IPs . If the plugin has no valid guid it will not log stats for that user. The database is organized after eaguid.

[ImportBot]

Originally Posted by Bl1ndy*:

 

How did he manage to create this welcome message? I can't find the right vars to use.

 

AT9i3.jpg

[ImportBot]

Originally Posted by jstm*:

 

How did he manage to create this welcome message? I can't find the right vars to use.

 

AT9i3.jpg

It is not var - it is command admin.say or admin.yell

[ImportBot]

Originally Posted by Networkvirus*:

 

Message: [MySQL][ODBC 5.1 Driver][mysqld-5.6.5-m8-log]Duplicate column name 'P90_kills' ---> Tablbuilder error!!

 

How can i solve this problem?

Do i have to edit my BF3.def file for that?

 

Tables i got so far:

 

Structuretbl_chatlog

Structuretbl_mapstats

Structuretbl_playerdata

Structuretbl_playerrank

Structuretbl_playerstats

Structuretbl_server

Structuretbl_server_player

Structuretbl_server_stats

Structuretbl_sessions

Structuretbl_weapons_assaultrifle

Structuretbl_weapons_shotgun

 

Sry, if ask i twice the same but i don't have the time to browse 112 pages..

[ImportBot]

Originally Posted by TimSad*:

 

Don't edit your BF3.FedEx file. There are two types of P90 and MP443 entries none of which should be removed. XpKiller's latest version of this plugin should have solved this duplicate column issue. Have you updated to the latest version?

[ImportBot]

Originally Posted by Networkvirus*:

 

Message: [MySQL][ODBC 5.1 Driver][mysqld-5.6.5-m8-log]Duplicate column name 'P90_kills' ---> Tablbuilder error!!

 

How can i solve this problem?

Do i have to edit my BF3.def ...

OK, i found the problem with installing the 1.0.0.7 update.

My Proconlayer doesn't let my do any changes/ edit to files on the server. I had to remove the file and replace with the 1.0.0.7!!

 

Sry, sry, sry ... didn't noticed the ftp error

[ImportBot]

Originally Posted by Bl1ndy*:

 

It is not var - it is command admin.say or admin.yell

I'm smart enough to know that lol. I meant the message using PlayerRank and NextPlayersRank or something...

[ImportBot]

Originally Posted by Mandizzy*:

 

XpKiller, I keep getting this error message over and over - every few seconds - any idea what this could be ? Funny thing is, it worked fine yesterday and it is using the latest version. Some windows update occurred today and restarted I restarted the PC and this started happening.

 

[23:22:38 88] Error: LogChat: System.InvalidOperationException: The ConnectionString property has not been initialized.

at System.Data.Odbc.OdbcConnection.PermissionDemand()

at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.LogChat(Strin g strSpeaker, String strMessage, String strType)

 

EDIT:

 

I disabled and re-enabled the plug-in today and it started just fine but a few seconds later it logged this message:

 

 

[19:36:34 59] Error: LogChat:

[19:36:34 61] Index #0

[19:36:34 61] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.17]Duplicate entry '453375' for key 'PRIMARY'

[19:36:34 61] Native: 1062

[19:36:34 61] Source: myodbc5.dll

[19:36:34 62] SQL: 23000

My chat table's max id is 453374 so what gives? Is it hitting some sort of max limit or something? After this message, it started logging the InvalidOperationException messages.

[ImportBot]

Originally Posted by Flaxe*:

 

XpKiller, I keep getting this error message over and over - every few seconds - any idea what this could be ? Funny thing is, it worked fine yesterday and it is using the latest version. Some windows update occurred today and restarted I restarted the PC and this started happening.

 

[23:22:38 88] Error: LogChat: System.InvalidOperationException: The ConnectionString property has not been initialized.

at System.Data.Odbc.OdbcConnection.PermissionDemand()

at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.LogChat(Strin g strSpeaker, String strMessage, String strType)

I think it's because your Procon Layer host don't accept ODBC Connections. What host do you use?

 

Edit: I have a problem myself that started about 2 hours after I first activated the plugin. Since then I get this error about every 5 minutes. Everything is correct in database and all stats have been transmitted correctly before. Not sure if it still works because I've disabled it because of the error messages.

 

Code:

Error: LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.5.21]MySQL server has gone away   --- End of inner exception stack trace ---
   at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException)
   at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   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.CChatGUIDStatsLoggerBF3.LogChat(String strSpeaker, String strMessage, String strType)

Anyone got any idea? Thanks!

[ImportBot]

Originally Posted by khyoshi*:

 

Hi, do you have any suggestions for when running procon as a "windows service" and as a layer server with this plugin?

The ODBC seems to not be available for the windows service but works just perfectly when I run procon as a stand alone app.

 

I am using my own Debian with MYSQL and a windows host for procon.

 

Any ideas?