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

[ImportBot]

Originally Posted by XpKiller*:

 

Ok Ghost, ty.

 

Edit: I actually ran the script when procon was running, will this cause any issues?

Properly not.

[ImportBot]

Originally Posted by Clay52*:

 

Properly not.

Alright then, it's been done and new beta now running, seems great so far.

[ImportBot]

Originally Posted by sourtimer*:

 

I'm a little confused as to how to run the tablefixes.txt script ?

 

I go into MySQL Workbench an see my database. Where do I go from there to run the script ?

 

Thanks

[ImportBot]

Originally Posted by leibhold*:

 

I'm a little confused as to how to run the tablefixes.txt script ?

 

I go into MySQL Workbench an see my database. Where do I go from there to run the script ?

 

Thanks

Tried google - I did and got this

http://www.techotopia.com/index.php/...te_SQL_Scripts

[ImportBot]

Originally Posted by Panther*:

 

Hey, installed a fresh installation of this plugin. Version 0.0.0.9

It generated the table by itself and logged the frist stats.

 

but for the commands in tablefix.txt i got this error:

#1054 - Unknown column 'Taurus_.44_kills' in 'tbl_weapons_handgun'

 

And it is true, there is no such column in tbl_weapons_handgun

[ImportBot]

Originally Posted by Ghostryder81*:

 

I got this error today:

 

[14:12:30 69] Error: Error in Startstreaming:

[14:12:30 69] Index #0

[14:12:30 69] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.19]Unknown column 'MG36_deaths' in 'field list'

[14:12:30 69] Native: 1054

[14:12:30 69] Source: myodbc5.dll

[14:12:30 69] SQL: 42S22

 

Anybody else got this ?

[ImportBot]

Originally Posted by Clay52*:

 

I'm a little confused as to how to run the tablefixes.txt script ?

 

I go into MySQL Workbench an see my database. Where do I go from there to run the script ?

 

Thanks

Just clink onto the player data portion of the database, then click the SQL tab, then a window should pop up to place the text into, and a "Go" button to run it, hope that helps.

[ImportBot]

Originally Posted by XpKiller*:

 

Hey, installed a fresh installation of this plugin. Version 0.0.0.9

It generated the table by itself and logged the frist stats.

 

but for the commands in tablefix.txt i got this error:

#1054 - Unknown column 'Taurus_.44_kills' in 'tbl_weapons_handgun'

 

And it is true, there is no such column in tbl_weapons_handgun

Sry I forgot to write that this script is only need if you have old tables.

[ImportBot]

Originally Posted by Panther*:

 

Nice, love you Killer, awesome work again. Can't wait for a webpage for your stats. If you find something like this, could you please post it here or on your first post. can't wait to put our serverstats on our homepage again .

[ImportBot]

Originally Posted by Legate*:

 

0.0.0.9 IoI !!!!!

 

Thanks XpKiller ;-)

[ImportBot]

Originally Posted by Waterboyeee*:

 

In the instructions, to delete the line do you remove this in it's entirety?

 

"procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" "RPG-7{RPG}|Weapons/SCAR-H/SCAR-H{SCAR,SCAR-H}|USAS-12{USAS12}|M27IAR{M27}|AEK-971{AEK971,AEK}|Weapons/A91/A91{A91}|Weapons/AK74M/AK74{AK74,AK74M}|Weapons/G36C/G36C{G36C}|Weapons/G3A3/G3A3{G3A3,G3}|Weapons/Gadgets/C4/C4{C4}|Weapons/Gadgets/Claymore/Claymore{CLAYMORE,CLAY,LANDMINE}|Weapons/KH2002/KH2002{KH2002}|Weapons/Knife/Knife{KNIFE}|Weapons/M416/M416{M416}|Weapons/MagpulPDR/MagpulPDR{MagpulPDR}|Weapons/MP412Rex/MP412REX{MP412REX,REX,MP412}|Weapons/MP443/MP443{MP443}|Weapons/P90/P90{P90}|Weapons/Sa18IGLA/Sa18IGLA{Sa18IGLA,Sa18,IGLA}|Weapons/UMP45/UMP45{UMP,UMP-45,UMP45}""

[ImportBot]

Originally Posted by IceCold*:

 

The MySQL ODBC Driver is missing on the procon host, you need to ask gameservers.com to install it.

http://dev.mysql.com/downloads/connector/odbc

hi,

 

they will not install it.

who hosts mysql database with this software ?

[ImportBot]

Originally Posted by Waterboyeee*:

 

hi,

 

they will not install it.

who hosts mysql database with this software ?

I am running Dreamhost with no issues.

[ImportBot]

Originally Posted by XpKiller*:

 

hi,

 

they will not install it.

who hosts mysql database with this software ?

The ODBC Driver must be install on the ProCon Host and not on the Database Host

[ImportBot]

Originally Posted by XpKiller*:

 

In the instructions, to delete the line do you remove this in it's entirety?

 

"procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" "RPG-7{RPG}|Weapons/SCAR-H/SCAR-H{SCAR,SCAR-H}|USAS-12{USAS12}|M27IAR{M27}|AEK-971{AEK971,AEK}|Weapons/A91/A91{A91}|Weapons/AK74M/AK74{AK74,AK74M}|Weapons/G36C/G36C{G36C}|Weapons/G3A3/G3A3{G3A3,G3}|Weapons/Gadgets/C4/C4{C4}|Weapons/Gadgets/Claymore/Claymore{CLAYMORE,CLAY,LANDMINE}|Weapons/KH2002/KH2002{KH2002}|Weapons/Knife/Knife{KNIFE}|Weapons/M416/M416{M416}|Weapons/MagpulPDR/MagpulPDR{MagpulPDR}|Weapons/MP412Rex/MP412REX{MP412REX,REX,MP412}|Weapons/MP443/MP443{MP443}|Weapons/P90/P90{P90}|Weapons/Sa18IGLA/Sa18IGLA{Sa18IGLA,Sa18,IGLA}|Weapons/UMP45/UMP45{UMP,UMP-45,UMP45}""

Yes!

[ImportBot]

Originally Posted by Clay52*:

 

Yes!

Wait, Xp, didn't you say awhile back only delete that line only if it's blank as in "" and not with all of that in between?

[ImportBot]

Originally Posted by XpKiller*:

 

I add some new friendly names for ingames stats.

 

The plugin recreate this line after deletion.

 

You also can add own names for weapons ingame like:

 

M320{Noobtube}

[ImportBot]

Originally Posted by Waterboyeee*:

 

Thank you for the clarification.

[ImportBot]

Originally Posted by petchpanu*:

 

I never use MySQL before and i'm now very confuse how to set this up. Could anyone guide me step by step how to use this plugin together with MySQL?

I already download MySQL workbench and ODBC 5.1 Driver.

[ImportBot]

Originally Posted by leibhold*:

 

I never use MySQL before and i'm now very confuse how to set this up. Could anyone guide me step by step how to use this plugin together with MySQL?

I already download MySQL workbench and ODBC 5.1 Driver.

See this -->www.phogue.net/forumvb/showth...Configuration.*

 

Basically you need to create a user for the sql, create a database, then put that user,password and information into the plugin. It will then connect to sql and create all the tbales etc.

[ImportBot]

Originally Posted by petchpanu*:

 

Thank you very much leibhold!!! I will read it carefully!! ^^"

[ImportBot]

Originally Posted by IceCold*:

 

The ODBC Driver must be install on the ProCon Host and not on the Database Host

anyone know who host procon with ODBC Driver installed.

[ImportBot]

Originally Posted by GitSum*:

 

Branzone

 

They are licensed by Phogue, offer ftp access and will have you up and running in short order

[ImportBot]

Originally Posted by IceCold*:

 

thx man

[ImportBot]

Originally Posted by salik*:

 

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

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '*.*.*.*' (10060)

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by ty_ger07*:

 

Do you know why it always says 'specific weapon not found' when I try to do a weapon stats?

 

I can't upload the BF3.def file to the server layer host because that file is read-only on the host. Is that why I am having this problem?

[ImportBot]

Originally Posted by XpKiller*:

 

@sallik

The plugin can't connect to the MySQL server. Check your MySQL serveraddress and make sure the port is correct and open.

 

@ty_ger07

Properly your keyword list is empty.

Some weapons in bf 3 got strange names. The keyword list contains remapping to user friendly name for in-game commands .

If you don't have accesss to the configfiles I can give the content you need. Just paste it in the keyword list under plugin settings

[ImportBot]

Originally Posted by ty_ger07*:

 

Yeah, could you provide the keyword list for me?

[ImportBot]

Originally Posted by XpKiller*:

 

Keyword list:

 

Code:

RPG-7{RPG}
Weapons/SCAR-H/SCAR-H{SCAR,SCAR-H}
USAS-12{USAS12}
M27IAR{M27}
AEK-971{AEK971,AEK}
Weapons/A91/A91{A91}
Weapons/AK74M/AK74{AK74,AK74M}
Weapons/G36C/G36C{G36C}
Weapons/G3A3/G3A3{G3A3,G3}
Weapons/Gadgets/C4/C4{C4}
Weapons/Gadgets/Claymore/Claymore{CLAYMORE,CLAY,LANDMINE}
Weapons/KH2002/KH2002{KH2002}
Weapons/Knife/Knife{KNIFE}
Weapons/M416/M416{M416}
Weapons/MagpulPDR/MagpulPDR{MagpulPDR}
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{L85A,L85}

[ImportBot]

Originally Posted by Clay52*:

 

Thanks bud, anything new upcoming?