Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by XpKiller*:

 

Atm i have some problems because some events like the endround event are not fired anymore so i dont get the results of a round.

Now im looking to find a way to bypass this but this also means that some score points might get lost.

[ImportBot]

Originally Posted by EBassie*:

 

Thanks for the update XpKiller!

 

But as it seems the RCON protocol is not really finished yet, maybe Phogue has some insights about the endround event.

Maybe it will be present in newer versions of the server.

 

So before you're doing the work twice...

[ImportBot]

Originally Posted by sfwombat*:

 

It fires server.onRoundOverPlayers and gives a list of players and scores. Is this any help? It is going to be a big list on a full 64 player server...

[ImportBot]

Originally Posted by jasonelmore*:

 

you could also just release a simple rank plugin while your working on this more detailed one. One that simply tells, top kills, kdr, and score. It would be really easy to do i would think but i dunno much about code. Just leave out all the weapons stats and just record kills, deaths, and points.

 

!rank

[ImportBot]

Originally Posted by LumpyNutZ*:

 

Atm i have some problems because some events like the endround event are not fired anymore so i dont get the results of a round.

Now im looking to find a way to bypass this but this also means that some score points might get lost.

Is there eny event for mapchanging? Maybe you could use that?

humm, when i think that more i think theres no such an event, but im not so ito this code thingy so forgive me

[ImportBot]

Originally Posted by XpKiller*:

 

This problem is solved now because there is now a working event.

Atm im waiting for the weapon definitions in the bf3.def file.

Then my plugin should work.

It also contains some improvements in the databasestructur.

pls be patient.

[ImportBot]

Originally Posted by RadicalMode*:

 

This plugin is very important... can you release a version without the weapon stats?

 

I really appreciate if you release this version. :-)

[ImportBot]

Originally Posted by EBassie*:

 

This problem is solved now because there is now a working event.

Atm im waiting for the weapon definitions in the bf3.def file.

Then my plugin should work.

It also contains some improvements in the databasestructur.

pls be patient.

Thanks for the update and your dedication dude!

 

Can't wait to implement 'tha shizzle' on our site

[ImportBot]

Originally Posted by fknChaos*:

 

Don't stress it dude! Take the time you need for the plugin to work properly!

Love the plugin!

[ImportBot]

Originally Posted by XpKiller*:

 

Update:

 

I'm going to release a beta version tomorrow. Which has still some issues.

[ImportBot]

Originally Posted by RadicalMode*:

 

yeah... good news!

 

thanks xpkiller.

[ImportBot]

Originally Posted by XpKiller*:

 

Unfortunately i found a serious bug. So i cant release it today you need to wait until tomorrow.

Atm im try trace this bug down.

[ImportBot]

Originally Posted by RadicalMode*:

 

np at all! thanks a lot for deploying a beta version.

[ImportBot]

Originally Posted by i3lack*:

 

Can't wait for the beta version =0 this plugin is much needed!

[ImportBot]

Originally Posted by XpKiller*:

 

And here we go:

www.phogue.net/forumvb/showth...0.0.1-beta-BF3*

[ImportBot]

Originally Posted by RadicalMode*:

 

nice, thanks!

 

First Error:

 

[21:01:45 55] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]Data too long for column 'ServerName' at row 1

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

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by Tom1314*:

 

where could have free /low price SQL host which support this plugin ?

[ImportBot]

Originally Posted by ty_ger07*:

 

where could have free /low price SQL host which support this plugin ?

For a BF3 server or a BFBC2 server?

 

This thread is quite old. His current thread for BF3 is here:

www.phogue.net/forumvb/showth...er-1-0-0-1-BF3*

[ImportBot]

Originally Posted by Tom1314*:

 

BC2 Server.......

[ImportBot]

Originally Posted by arionz*:

 

how do u dl this plugin.._?

[ImportBot]

Originally Posted by arionz*:

 

there no link for the dl of this plug in please re upload it xpkiller. it's very frustrating

[ImportBot]

Originally Posted by vilee*:

 

111.jpg

222.jpg

333.jpg

 

pls help me .

 

why the playerKills playerHeadshots playerDeaths playerSuicide playerTKs Killstreak Deathstreak WeaponStats dont inset

 

 

just playerScore playerPlaytime playerRounds FirstSeenOnServer LastSeenOnServer inset.

 

i set the rank off

[ImportBot]

Originally Posted by XpKiller*:

 

is your server a bf3 or bfbc2 server?

[ImportBot]

Originally Posted by vilee*:

 

is your server a bf3 or bfbc2 server?

i think that have to work on rank server

 

 

 

now this is a nEw Q

 

[17:24:32 57] Error in getBFBCStats: System.FormatException: ???????????? DateTime?

? System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)

? System.Convert.ToDateTime(String value)

? PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

 

 

???????????? google translate "String was not recognized as a valid

 

sry my english is poor ...

 

my server is bc2 .

[ImportBot]

Originally Posted by PahaShrek*:

 

Forgive for my English)

Please help!

I do everything on a manual, but there is a problem

[10:09:17 74] BF BC2 Chat, GUID and Stats Logger Enabled

[10:09:17 75] BF BC2 Chat, GUID and Stats Logger: Floodprotection set to 20 Request per Round for each Player

[10:09:17 75] Gamemod Tableschema set to: BC2

[10:09:17 75] Gamemod Weaponlist set to: BC2

[10:10:36 81] Start tablebuilder

[10:10:36 81] Error in OpenConnection:

[10:10:36 81] Index #0

[10:10:36 81] Message: [Microsoft][????????? ????????? ODBC] ???????? ?????? ?? ?????? ? ?? ?????? ???????, ???????????? ?? ?????????

[10:10:36 81] Native: 0

[10:10:36 81] Source:

[10:10:36 82] SQL: IM002

[10:10:36 82] Error in GetRank: System.NullReferenceException: ? ?????????? ??????? ?? ?????? ?????? ?? ??????.

? PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

? PRoConEvents.CChatGUIDStatsLogger.GetRank(String SoldierName)

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller,

 

Someone requested that my stats page has the ability to merge server ranking similar to how your plugin does it. Their situation is that they had to move the server around to multiple locations but they still want the server stats to reflect the overall ranking from all of the different server locations.

 

I assume it is a simple task of creating separate queries where server ID is not accounted for in the query, but I would like your input on this before I implement it since I don't want to implement the functionality incorrectly.

 

Does anyone know of a webpage addon for this plugin that would show all these collected stats in a SINGLE leaderboard? Our server has changed IP so many times, that the stats are a mess now, they are listed as 4 servers instead of 1, so our web based leaderboard shows 4 servers too, all though the in game stats are correct, that correctly combines the stats, but it would be nice if I could show the combined stats at our website too.

myrcon.net/.../chat-guid-stats-and-mapstats-logger

 

Thank you!

[ImportBot]

Originally Posted by Rumpel77*:

 

moinsen

ich noob ihr besser:ohmy:

mal auf anfang, kann mir wer sagen wie man den ganzen rotz überhaupt installt.?

link würde schon reichen ,finde nur leider nix

hab alles was mann braucht , hoffe ich .

msql is da aber was muss da druff und und und

hab mir die sachen von gamed! gemietet, mag mir wer bitte helfen , danke

gruss und respect

Rumpel

[ImportBot]

Originally Posted by vagelad*:

 

Hi, is there a fix for this error?

 

 

 

 

[18:04:10 22] Error in OpenConnection: System.TypeInitializationException: The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception. ---> System.TypeLoadException: Could not load type 'MySql.Data.MySqlClient.MySqlClientPermission' from assembly 'MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.

at Microsoft.Win32.NativeMethods.GetCurrentProcessId( )

at System.Diagnostics.Process.GetCurrentProcess()

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_ProcessName()

at System.Transactions.Diagnostics.DiagnosticTrace.Lo gEvent(TraceEventType type, String message, Boolean addProcessInfo)

at System.Transactions.Diagnostics.DiagnosticTrace..c ctor()

--- End of inner exception stack trace ---

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_Verbose()

at System.Transactions.Transaction.get_Current()

at System.Data.Common.ADP.IsSysTxEqualSysEsTransactio n()

at System.Data.Common.ADP.NeedManualEnlistment()

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

at PRoConEvents.CChatGUIDStatsLogger.OpenOdbcConnecti on(Int32 type)

[18:04:22 04] Error in SQLQuery in Case 10: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.70-cll]Lost connection to MySQL server during query

--- 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(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteReader()

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

[18:04:22 04] Error in getBFBCStats: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n(ExceptionArgument argument, ExceptionResource resource)

at System.ThrowHelper.ThrowArgumentOutOfRangeExceptio n()

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[18:04:22 24] ProconRulz: Player makuro protected from Kill by ProconRulz

[18:04:40 51] ProconRulz: Player digital_hero666 killed

[18:04:40 68] Error in OpenConnection: System.TypeInitializationException: The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception. ---> System.TypeLoadException: Could not load type 'MySql.Data.MySqlClient.MySqlClientPermission' from assembly 'MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.

at Microsoft.Win32.NativeMethods.GetCurrentProcessId( )

at System.Diagnostics.Process.GetCurrentProcess()

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_ProcessName()

at System.Transactions.Diagnostics.DiagnosticTrace.Lo gEvent(TraceEventType type, String message, Boolean addProcessInfo)

at System.Transactions.Diagnostics.DiagnosticTrace..c ctor()

--- End of inner exception stack trace ---

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_Verbose()

at System.Transactions.Transaction.get_Current()

at System.Data.Common.ADP.IsSysTxEqualSysEsTransactio n()

at System.Data.Common.ADP.NeedManualEnlistment()

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

at PRoConEvents.CChatGUIDStatsLogger.OpenOdbcConnecti on(Int32 type)

[18:04:40 76] Error in DownloadBFBCS: System.TypeLoadException: Could not load type 'MySql.Data.MySqlClient.MySqlClientPermission' from assembly 'MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.

at System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.CodeAccessPermission.Demand()

at System.Configuration.TypeUtil.CallerHasMemberAcces sOrAspNetPermission()

at System.Configuration.TypeUtil.CreateInstanceRestri cted(Type callingType, Type targetType)

at System.Configuration.ConfigurationElement.CreateEl ement(Type type)

at System.Configuration.ConfigurationElement.get_Item (ConfigurationProperty prop)

at System.Diagnostics.SystemDiagnosticsSection.get_So urces()

at System.Diagnostics.DiagnosticsConfiguration.get_So urces()

at System.Diagnostics.TraceSource.Initialize()

at System.Net.Logging.InitializeLogging()

at System.Net.Logging.get_On()

at System.Net.WebClient.DownloadString(Uri address)

at System.Net.WebClient.DownloadString(String address)

at PRoConEvents.CChatGUIDStatsLogger.DownloadBFBCS(Ob ject ListObject)

[18:05:19 34] Error in SQLQuery in Case 8: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.70-cll]Lost connection to MySQL server during query

--- 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(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteReader()

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

[18:05:19 50] Error in OpenConnection: System.TypeInitializationException: The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception. ---> System.TypeLoadException: Could not load type 'MySql.Data.MySqlClient.MySqlClientPermission' from assembly 'MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.

at Microsoft.Win32.NativeMethods.GetCurrentProcessId( )

at System.Diagnostics.Process.GetCurrentProcess()

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_ProcessName()

at System.Transactions.Diagnostics.DiagnosticTrace.Lo gEvent(TraceEventType type, String message, Boolean addProcessInfo)

at System.Transactions.Diagnostics.DiagnosticTrace..c ctor()

--- End of inner exception stack trace ---

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_Verbose()

at System.Transactions.Transaction.get_Current()

at System.Data.Common.ADP.IsSysTxEqualSysEsTransactio n()

at System.Data.Common.ADP.NeedManualEnlistment()

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

at PRoConEvents.CChatGUIDStatsLogger.OpenOdbcConnecti on(Int32 type)

[18:05:40 98] Error in OpenConnection: System.TypeInitializationException: The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception. ---> System.TypeLoadException: Could not load type 'MySql.Data.MySqlClient.MySqlClientPermission' from assembly 'MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.

at Microsoft.Win32.NativeMethods.GetCurrentProcessId( )

at System.Diagnostics.Process.GetCurrentProcess()

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_ProcessName()

at System.Transactions.Diagnostics.DiagnosticTrace.Lo gEvent(TraceEventType type, String message, Boolean addProcessInfo)

at System.Transactions.Diagnostics.DiagnosticTrace..c ctor()

--- End of inner exception stack trace ---

at System.Transactions.Diagnostics.DiagnosticTrace.ge t_Verbose()

at System.Transactions.Transaction.get_Current()

at System.Data.Common.ADP.IsSysTxEqualSysEsTransactio n()

at System.Data.Common.ADP.NeedManualEnlistment()

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

at PRoConEvents.CChatGUIDStatsLogger.OpenOdbcConnecti on(Int32 type)

[ImportBot]

Originally Posted by MUXA*:

 

Forgive for my English)

Please help!

I do everything on a manual, but there is a problem

10:09:17 74] BF BC2 Chat, GUID and Stats Logger Enabled

[10:09:17 75] BF BC2 Chat, GUID and Stats Logger: Floodprotection set to 20 Request per Round for each Player

[10:09:17 75] Gamemod Tableschema set to: BC2

[10:09:17 75] Gamemod Weaponlist set to: BC2

[10:10:36 81] Start tablebuilder

[10:10:36 81] Error in OpenConnection:

[10:10:36 81] Index #0

[10:10:36 81] Message: [Microsoft][????????? ????????? ODBC] ???????? ?????? ?? ?????? ? ?? ?????? ???????, ???????????? ?? ?????????

[10:10:36 81] Native: 0

[10:10:36 81] Source:

[10:10:36 82] SQL: IM002

[10:10:36 82] Error in GetRank: System.NullReferenceException: ? ?????????? ??????? ?? ?????? ?????? ?? ??????.

? PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

? PRoConEvents.CChatGUIDStatsLogger.GetRank(String SoldierName)

 

 

I have the same problem, which he described. Can somebody helped me?

[ImportBot]

Originally Posted by Mr_Nasty_Time405*:

 

What do I put for the Suffix?

 

#Tablesuffix

SET @SUFFIX='yourSuffixhere';