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

[ImportBot]

Originally Posted by VWOer*:

 

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 .

I am currently working on such page for e107; I have been updating my own one from BFBC2 to BF3. It will probably look like this page (without the CMS) but with extra functionalities (global server statistics, dog tag history and chat logs for example). I am however still busy with the development of these pages as there are still bugs left and the database is quite different from BFBC2. Depending on your site system I can update the code for you. Please contact me if you are interested (if anyone else is, please contact me as well). I might release my scripts on these forums sooner or later.

[ImportBot]

Originally Posted by ty_ger07*:

 

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}

Thank you!

 

EDIT: Added those to the Keywordlist Array, same problem. Specific weapon not found when I type in '!stats M416'.

 

I am using the latest plugin version.

[ImportBot]

Originally Posted by svet*:

 

We got it working, check it out:

 

http://www.flame-guards.com/forum/vi...p=20861#p20861

[ImportBot]

Originally Posted by tarreltje*:

 

getting this error:

 

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

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'sql.controlyourserver.net' (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.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

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)

 

What seems to be the problem? My hosting is telling me that procon is the problem, but i dont think so!

[ImportBot]

Originally Posted by XpKiller*:

 

@tarreltje

 

The plugin can not connect to the db server.

I would guess a Firewall rule is missing or your connection setting to the database are wrong.

 

Please make sure the you are using the right port an server address of the mysql server.

[ImportBot]

Originally Posted by XpKiller*:

 

Thank you!

 

EDIT: Added those to the Keywordlist Array, same problem. Specific weapon not found when I type in '!stats M416'.

 

I am using the latest plugin version.

hmm thats really strange.

 

Could you take a look into the weapontables if they are containing any values?

[ImportBot]

Originally Posted by ty_ger07*:

 

Yeah, I see the weapons fields with kills, deaths, and headshots and they are populated with numbers.

 

Just no workie.

[ImportBot]

Originally Posted by Vetula*:

 

Best Plugin ! But Please add a Command to disable the In-game-Commands !

[ImportBot]

Originally Posted by Clay52*:

 

edited...

[ImportBot]

Originally Posted by XpKiller*:

 

@Clay52

wrong thread?

 

@Vetula

i will add such an option to disable the ingame commands

[ImportBot]

Originally Posted by Clay52*:

 

@Clay52

wrong thread?

 

@Vetula

i will add such an option to disable the ingame commands

Oops!

[ImportBot]

Originally Posted by Waterboyeee*:

 

Those who reset stats each month..... Are you all creating a new database and keeping the old one? Or do you just delete the information from your current one? If so, what method of deleting do you use?

 

Could I just run "TRUNCATE TABLE tablename"?

[ImportBot]

Originally Posted by seim*:

 

omg this is so awesome

 

got it working on my own procon layer machine (on my own 24/7 uptime mac mini in the attic) and it works.. omg this is _so? awesome!

[ImportBot]

Originally Posted by ballybag*:

 

Okay umm....

 

Im a rookie when it comes to battlefield servers

 

is there a tutorial on where this mysql stuff goes etc and how to set it up step by step ?

[ImportBot]

Originally Posted by C-4-N*:

 

thx

 

i have specific weapon not found

 

 

... well i follow step by step , run in localhost , try odbc connector , it work ... but

 

Error in Tablebuilder:

Index #0

Message: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié

Native: 0

Source:

SQL: IM002

and we can't delete the line 144 ever came back

 

boring ...

[ImportBot]

Originally Posted by XpKiller*:

 

@ C-4-N

 

Which OS u are using?

[ImportBot]

Originally Posted by C-4-N*:

 

Win Home server 2011... (it s like windows server 2008)

[ImportBot]

Originally Posted by XpKiller*:

 

I guess it is the 64bit version right?

then you need to install the 32bit version of the odbc driver too.

 

And configure it with with the odbc manger for 32bit.

 

In some cases you need to configure both 64 and 32 bit version of the odbc driver ( dont know why)

 

http://robertoschiabel.wordpress.com...vs-64bit-odbc/

[ImportBot]

Originally Posted by C-4-N*:

 

well,was 64 ,I installed 32 bit dirver , nice doctor , i haven't Error in Tablebuilder now !

 

but still "weapon scpecifc not found when type @rank ...

[ImportBot]

Originally Posted by XpKiller*:

 

please post the error message

[ImportBot]

Originally Posted by C-4-N*:

 

i have no error , in procon when i set debug on error !

 

it s ingame , when type @rank or @stats etc , it s ever say :" weapon specifc not found !!"

 

all seems good because i have message like that

 

Trace: SQLQuery Weaponquery: INSERT INTO tbl_weapons_assaultrifleveit (`StatsID`, `M16A4_deaths`, `M416_kills`, `M416_hs`) VALUES(58, 3, 9, 2) ON DUPLICATE KEY UPDATE `M16A4_deaths` = `M16A4_deaths` + 3 , `M416_kills` = `M416_kills` + 9 , `M416_hs` = `M416_hs` + 2

there is value in columns, but no name near value , normal ?

 

i have name of players in playerdata

[ImportBot]

Originally Posted by Waterboyeee*:

 

............

 

Those who reset stats each month..... Are you all creating a new database and keeping the old one? Or do you just delete the information from your current one? If so, what method of deleting do you use?

 

Could I just run "TRUNCATE TABLE tablename"?

[ImportBot]

Originally Posted by Frakkas*:

 

Here's an error I received tonight. Let me know if you need more info:

 

[21:19:42 23] Info: OnLevelLoaded: MP_Subway Gamemode: RushLarge0 Round: 1/2

[21:19:42 23] Info: update sql server

[21:19:42 23] Info: Started streaming to the DB-Server

[21:19:42 23] Info: Connection OdbcCon closed

[21:19:42 51] Info: OdbcCon open

[21:19:42 81] Info: OdbcConn open

[21:19:44 04] Info: Status ID-Cache: 3 ID's in cache

[21:19:44 04] Info: Connection OdbcConn closed

[21:42:44 03] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'reading authorization packet', system error: 0

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.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

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)

[22:24:44 36] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'reading authorization packet', system error: 0

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.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

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 XpKiller*:

 

This no error caused by the plugin itself.

 

The Mysql Server has refused the connection during querying.

Code:

Lost connection to MySQL server at 'reading authorization packet', system error: 0

[ImportBot]

Originally Posted by C-4-N*:

 

i have no error , in procon when i set debug on error !

 

it s ingame , when type @rank or @stats etc , it s ever say :" weapon specifc not found !!"

 

all seems good because i have message like that

 

 

 

there is value in columns, but no name near value , normal ?

 

i have name of players in playerdata

omg man it's because we can't type command with "/" for command not appear !!!

 

-_-" so "/@rank" won't work and "@rank" work

 

thx for help doctor !

[ImportBot]

Originally Posted by Frakkas*:

 

The Mysql Server has refused the connection during querying.

Is this something that would happen frequently? It seems to be happening to me quite a bit. Perhaps I need to put my database somewhere else.

 

Also, the plugin doesn't seem to recover from it. Is there a way to maybe schedule a retry so the data isn't lost?

[ImportBot]

Originally Posted by ty_ger07*:

 

Is there a way to maybe schedule a retry so the data isn't lost?

x2 .

[ImportBot]

Originally Posted by sp37zn4z*:

 

Hi Xpkiller,

 

Thanks for the great plugin. I got the !stats and !top10 Welcomestats working but i'm having a problem with weaponstats (e.g. !top10 WEAPONNAME !stats WEAPONNAME) the plugin recognizes the command but all i'm getting as a reply is "This are the TOP10 WEAPONNAME KILLS in SERVERNAME" just that and no name list 1-10 as what !top10 giving to me. And as for !stats WEAPONNAME i'm getting a reply "no stats for this weapon try on the next round" i already played 10 rounds and still nothing?

 

I did a trace debug and all are working fine, it queries the db every round ends with no errors. Also i check the existing weapon/stats tables on the db through MYSQL workbench and all weapons/stats have the recorded values.BTW, i already deleted the (procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" "") on my config file. I'm using a procon client;not on a procon layer. Hosted locally running server Windows 2003 32bit SP2.

 

The odd thing with the deletion of the key (procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" "") on the config file is everytime i run procon with it and closes the procon; the deleted key reverted back in the config file. Is this normal? It seems the key is associated in the keywordlist of the plugin. And btw, the keyword list is incomplete do we have to add the specific weaponname manually?

[ImportBot]

Originally Posted by sp37zn4z*:

 

I also have a few questions on the plugins functions:

 

What's the function of these options? What does it do?

 

MapStats

Overall ranking(merged Serverranking)

Send Stats to all Player

tableSuffix

TimeOffset

Servertime Offset

Webrequest

 

I'm asking coz i didn't read any info's regarding these options from the plugin details. No info given by the users nor the developer itself. And btw, i browsed all 38 pages in this thread before posting this.

 

Thanks

[ImportBot]

Originally Posted by Frakkas*:

 

Also, the plugin doesn't seem to recover from it. Is there a way to maybe schedule a retry so the data isn't lost?

I poked around a bit, and I'm just familiarizing myself with plugin development, but this appears to just be updating the tbl_server with a current snapshot of CServerInfo, I'm not too worried about the data loss on this one.

 

Edit:

 

I did some tracing, and the plugin does keep working after this error (I initially thought it stopped everything). It seemed like this was the only error I've seen so far and I noticed you are updating this info on every OnServerInfo() and I wondered if it could be something with re-entrancy. Would Procon send another OnServerInfo if you haven't returned from a previous?