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

[ImportBot]

Originally Posted by Combo77*:

 

e.g. MTAR-21

 

...but i think i found the error. It should be Weapons/XP2_MTAR/MTAR.

I´m writing a complete keyword list atm. I will post it later.

[ImportBot]

Originally Posted by Combo77*:

 

I´ve added all weapons to the keyword list. Seems like it is working.

 

keyword list 20.08.2012

 

870MCS{870,870MCS}

AEK-971{AEK,AEK971,AEK-971}

AKS-74u{AKSU,AKS-74,AKSU-74,AKS-74U}

AN-94 Abakan{ABAKAN,AN94,AN-94}

AS Val{ASVAL,AS-VAL,AS VAL}

DAO-12{DAO12,DAO,DAO-12}

death{DEATH}

Defib{DEFIBRILLATOR,DEFIB,PADDLE,PADDLES}

F2000{F2000}

FAMAS{FAMAS}

FGM-148{JAVELIN,FGM148,FGM-148}

FIM92{STINGER,FIM92,FIM-92}

Glock18{GLOCK,GLOCK18,GLOCK-18}

HK53{HK53,HK-53,G53,G-53,HK-G53}

jackhammer{JACKHAMMER,MK3A1,MK3}

JNG90{JNG-90,JNG90,JNG}

L96{L-96,L96}

LSAT{LSAT}

M416{M-416,M416}

M417{M-417,M417}

M1014{M-1014,1014,M1014}

M15 AT Mine{M15,M15 MINE,AT MINE,ATMINE,ATM,M15-ATM}

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

M1911{1911,M1911}

M240{M-240,M240}

M249{M-249,M249,SAW}

M26Mass{M26,M-26,MASS,M26MASS}

M27IAR{M27,M-27,M27IAR}

M320{M-320,GRENADE LAUNCHER,M320}

M39{M-39,M39}

M40A5{M40,M-40,M40A5}

M4A1{M4,M-4,M4A1}

M60{M-60,M60}

M67{HANDGRENADE,GRENADE,M67,M-67}

M9{M-9,M9}

M93R{M93,M93R}

Medkit{MEDKIT}

MG36{MG-36,MG36}

Mk11{MK-11,MK11}

Model98B{M98,M98B,MODEL98,MODEL-98,MODEL98B,MODEL-98B}

MP7{MP-7,MP7}

Pecheneg{PKP-PECHENEG,PKP,PECHENEG}

PP-19{PP19,PP-19}

PP-2000{PP2000,PP-2000}

QBB-95{QBB,QBB95,QBB-95}

QBU-88{QBU,QBU88,QBU-88}

QBZ-95{QBZ,QBZ95,QBZ-95}

Repair Tool{REPAIRTOOL,TOOL,TORCH,BLOWTORCH}

RoadKill{ROADKILL}

RPG-7{RPG,RPG7,RPG7V2,RPG-7V2}

RPK-74M{RPK,RPK74,RPK-74,RPK74M,RPK-74M}

SCAR-L{SCARL,SCAR-L}

SG 553 LB{SG553,SG-553,SG-553LB}

Siaga20k{SAIGA,SAIGA20K,SIAGA,SIAGA20K}

SKS{SKS}

SMAW{SMAW}

SPAS-12{SPAS12,SPAS,SPAS-12}

Suicide{SUICIDE}

SV98{SV-98,SV98}

SVD{SVD,DRAGUNOV}

Steyr AUG{STEYR,AUGA3,AUG-A3,AUG}

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

Type88{TYPE88,TYPE-88}

USAS-12{USAS,USAS12,USAS-12}

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

Weapons/AK74M/AK74{AK74,AK-74,AKM,AK-74M,AK74M}

Weapons/G36C/G36C{G36,G36C,G-36,G-36C}

Weapons/G3A3/G3A3{G3,G-3,G3A3,G3-A3}

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

Weapons/Gadgets/Claymore/Claymore{CLAYMORE,LANDMINE,APMINE,AP-MINE,APM,M18,M-18,M18-CLAYMORE}

Weapons/KH2002/KH2002{KH2002,KH-2002}

Weapons/Knife/Knife{KNIFE,MELEE}

Weapons/MagpulPDR/MagpulPDR{PDW-R,PDWR,PDR,PDW}

Weapons/MP412Rex/MP412REX{MP412REX,REX,MP-412,MP412}

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

Weapons/P90/P90{P-90,P90}

Weapons/Sa18IGLA/Sa18IGLA{SA18,SA-18,IGLA,SA18IGLA,SA18-IGLA,SA-18IGLA}

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

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

Weapons/XP1_L85A2/L85A2{L85,L85A2,L-85,L-85A2,L85-A2}

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

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

Weapons/XP2_MP5K/MP5K{MP5,MP5K,M5K,MP-5,MP-5K,M5-K}

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

[ImportBot]

Originally Posted by aduh*:

 

"You can create Servergroups"

What is that mean ? How it works ?

[ImportBot]

Originally Posted by XpKiller*:

 

Since you can stream with multiply servers into one db you can set a server group for them

 

Example:

you have 2 normal Conquest Server and 1 Hardcore Conquest and you want dedicated stats for the Hardcoreserver. Then you could set the server group of the hardcore on a different values that for the normal Conquest server.

(So the Conquest server has group 0 and the hardcore server has group 1)

You can form up to 128 Groups atm.

[ImportBot]

Originally Posted by aduh*:

 

XpKiller did you thought about adding "Black List" option ?

I mean I would like to create "Black List" with players (nicks) that will be excluded from stats.

It will help during the tournament on the server when organizers are excluded from rank and they shouldn't be there (for example clan members who own server and organize tournament).

What do you think ? Is it possible ? Can I do it now using phpMyAdmin ?

[ImportBot]

Originally Posted by Neliscornelis*:

 

Hey,

 

How can i get this working under debian? I added a odbc like this: http://www.howtoforge.com/adding-an-...ysql-on-ubuntu

[ImportBot]

Originally Posted by back*:

 

I have a question - scores are calculated x2 for players with a premium account? If so, can I change it?

[ImportBot]

Originally Posted by alexrayden*:

 

I'm using procon layer with mono on ubuntu server, and all go ok.

But when i try tu use this plug in (after i had configured the ODBC), i have this error:

 

[18:04:59 69] Info: Start tablebuilder

[18:04:59 70] Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[18:04:59 70] Error in Tablebuilder:

[18:04:59 70] Index #0

[18:04:59 70] Message: [

[18:04:59 70] Native: 0

[18:04:59 70] Source:

[18:04:59 70] SQL: I

[18:04:59 70] Error: System.NullReferenceException: Object reference not set to an instance of an object

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

[18:04:59 70] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [i

 

Someone can help me pls?

[ImportBot]

Originally Posted by XpKiller*:

 

This plugin is not tested from me under linux + mono.

 

So i cant help you.

 

Anyway it would be better if you had copied the whole error message.

[ImportBot]

Originally Posted by alexrayden*:

 

This plugin is not tested from me under linux + mono.

 

So i cant help you.

 

Anyway it would be better if you had copied the whole error message.

That is all, just copy and past, nothing else

 

That error goes in loop...

[ImportBot]

Originally Posted by alexrayden*:

 

This plugin is not tested from me under linux + mono.

 

So i cant help you.

 

Anyway it would be better if you had copied the whole error message.

After several attempts I managed to get the full error message:

 

[05:26:01 55] Error in Tablebuilder:

[05:26:01 56] Index #0

[05:26:01 56] Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

[05:26:01 56] Native: 0

[05:26:01 56] Source:

[05:26:01 56] SQL: IM002

[05:26:01 56] Error: System.NullReferenceException: Object reference not set to an instance of an object

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

[05:26:01 56] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified

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

I hope it is useful for the solution

[ImportBot]

Originally Posted by XpKiller*:

 

The error said that your datasource is not configured properly.

 

System.Data.Odbc.OdbcException: ERROR [iM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified

[ImportBot]

Originally Posted by Combo77*:

 

I recognized a small error. After restarting Procon all %deathstreak% have been replaced by ?athstreak% and are not working anymore.

Any idea what could cause this?

[ImportBot]

Originally Posted by Prophet731*:

 

XpKiller, can you help me try to troubleshoot this problem or anyone else. The plugin works fine and was logging to a database just fine. Then when I moved the database over to a different server the chat log date/time are being inserted as 0000-00-00 00:00:00. It didn't do that before on my test server.

[ImportBot]

Originally Posted by XpKiller*:

 

Which odbc driver you are using? The latest causes that bug.

[ImportBot]

Originally Posted by alexrayden*:

 

The error said that your datasource is not configured properly.

 

System.Data.Odbc.OdbcException: ERROR [iM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified

I know, but all settings are ok. If i testing with isql command, the driver connect correctly to the database.

 

Remembering that i use procon layer on linux with mono:

 

Question 1: maybe the "procon.private.options.runPluginsInSandbox False" ? If that was the problem, in the configuration file where I should insert the trusted host?

 

Question 2: might be some setting in the configuration of mono?

[ImportBot]

Originally Posted by XpKiller*:

 

isql is using JDBC and not ODBC

Except you are using a brigde driver.

 

The error is clear your datasource is not setup properly. There is noting wrong with mono.

[ImportBot]

Originally Posted by Prophet731*:

 

Which odbc driver you are using? The latest causes that bug.

Was this directed at me or the other guy?

[ImportBot]

Originally Posted by XpKiller*:

 

It was for you.

[ImportBot]

Originally Posted by Bomber_aa*:

 

Hello Is there a Way to set !rank or !stats appears in Chatbox instead of yelling?

btw Good Job XpKiller

[ImportBot]

Originally Posted by Prophet731*:

 

It was for you.

Oh. Ok. Well I think I am using the latest. I personally don't have direct access to the actual server where procon is being hosted but this issue didn't happen when it was logging to my test database which was running the latest MySQL server. The server its on now is also running the latest MySQL server so I am currently at a loss at how to fix it.

[ImportBot]

Originally Posted by schosti03*:

 

I know, but all settings are ok. If i testing with isql command, the driver connect correctly to the database.

 

Remembering that i use procon layer on linux with mono:

 

Question 1: maybe the "procon.private.options.runPluginsInSandbox False" ? If that was the problem, in the configuration file where I should insert the trusted host?

 

Question 2: might be some setting in the configuration of mono?

if you working on ubuntu/debian, you have to install unixodbc-dev to, (sudo apt-get install unixodbc-dev)

then in /etc/odbcinst.ini you have to name de mysql driver [MySQL ODBC 5.1 Driver]

 

but now I got this also:

What does this means ?

Code:

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY001] [MySQL][ODBC 5.1 Driver][mysqld-5.5.16]Memory allocation error
   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)

[ImportBot]

Originally Posted by XpKiller*:

 

Hello Is there a Way to set !rank or !stats appears in Chatbox instead of yelling?

btw Good Job XpKiller

Just remove the yell brackets.

[ImportBot]

Originally Posted by alexrayden*:

 

isql is using JDBC and not ODBC

Except you are using a brigde driver.

 

The error is clear your datasource is not setup properly. There is noting wrong with mono.

Ok, this are my odbc.ini and odbcinst.ini

 

odbcinst.ini

[myodbc]

Description = Procon connection

Driver = /usr/lib/odbc/libmyodbc5.so

Setup = /usr/lib/odbc/libodbcmyS.so

CPTimeout =

CPReuse =

FileUsage = 1

odbc.ini

[procon]

Description = Procon connection

Driver = /usr/lib/odbc/libmyodbc5.so

SERVER = localhost

DATABASE = guerrieridellanotte

PORT = 3306

UID = ******

PWD = ******

Socket = /var/run/mysqld/mysqld.sock

Option = 3

Stmt =

 

 

[ODBC Data Sources]

procon = myodbc

What's wrong?

[ImportBot]

Originally Posted by Bomber_aa*:

 

Just remove the yell brackets.

I did but isnt working

[ImportBot]

Originally Posted by alexrayden*:

 

For all that use the procon under linux with mono:

 

- install unixODBC

- check the files required are in the correct direcory:

- libmyodbc.so --> /usr/lib/odbc/libmyodbc.so (driver library)

- libodbcmyS.so --> /usr/lib/odbc/libodbcmyS.so (setup library)

- check the correct mysql.sock file (mine is mysqld.sock located in /var/run/mysqld/

 

the odbc.ini and odbcinst.ini must be:

 

odbcinst.ini

[MySQL ODBC 5.1 Driver]

Description = Procon connection

Driver = /usr/lib/odbc/libmyodbc.so

Setup = /usr/lib/odbc/libodbcmyS.so

CPTimeout =

CPReuse =

FileUsage = 1

 

 

[ODBC Drivers]

MySQL ODBC 5.1 Driver = Installed

the important part is the name in [brackets] there, is mandatory [MySQL ODBC 5.1 Driver], cause in the plugin file the driver is called so

 

odbc.ini

[procon]

Description = Procon connection

Driver = /usr/lib/odbc/libmyodbc5.so

SERVER = yourserver

DATABASE = yourdatabase

PORT = yourport

UID = youruserid

PWD = yourdbpassword

Socket = /var/run/mysqld/mysqld.sock

Option = 3

Stmt =

 

 

[ODBC Data Sources]

procon = MySQL ODBC 5.1 Driver

remember to set the "ODBC Data Sources" section in = MySQL ODBC 5.1 Driver and to check your correct socket folder for the sock file of mysql in the "Socket = " line.

[ImportBot]

Originally Posted by XpKiller*:

 

I did but isnt working

change this:

Code:

[yell,2]Serverstats for %playerName%:
[yell,3]Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%
[yell,3]Your Serverrank is: %playerRank% of %allRanks%

to that:

Code:

Serverstats for %playerName%:
Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%
Your Serverrank is: %playerRank% of %allRanks%

[ImportBot]

Originally Posted by cjffly*:

 

hi,

 

I have branzone.com's procon and mysql, does any one know how to setup it's mysql to work?

 

I've create DB name and user name, but get this kind of error:

Code:

Error in Tablebuilder: 
[16:04:32 25] Index #0
[16:04:32 25] Message: [MySQL][ODBC 5.1 Driver]Access denied for user 'maomaoch_cjffly'@'208.100.45.9' (using password: YES)
[16:04:32 25] Native: 1045
[16:04:32 25] Source: 
[16:04:32 25] SQL: HY000
[16:04:32 25] Index #1
[16:04:32 25] Message: [MySQL][ODBC 5.1 Driver]Access denied for user 'maomaoch_cjffly'@'208.100.45.9' (using password: YES)
[16:04:32 25] Native: 1045
[16:04:32 25] Source: 
[16:04:32 25] SQL: HY000
[16:04:32 25] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

[ImportBot]

Originally Posted by GitSum*:

 

Branzone already sets the ODBC driver for you

 

Check and make sure your using the correct password and ip address in the settings for this plugin to connect to your database (where is the database hosted_)

 

If that doesn't work - open a ticket with them

[ImportBot]

Originally Posted by cjffly*:

 

thanks, i open a ticket, problem is solved~thanks