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

[ImportBot]

Originally Posted by ty_ger07*:

 

Isn't there an option in the plugin settings to set the number of retries before giving up? I'm just trying to remember off the top of my head.

[ImportBot]

Originally Posted by utopiate*:

 

Yep, default is 3

[ImportBot]

Originally Posted by russel5*:

 

Hi, I have Win8 x64 and i installed a ODBC connector 5.1.9 (x86 and x64). I configure System DNS in ODBC Admin Tool (x86 and x64) but on plugin i allways get this error

Code:

[18:26:23 92] Error in Tablebuilder: 
[18:26:23 92] Index #0
[18:26:23 92] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
[18:26:23 92] Native: 0
[18:26:23 92] Source: 
[18:26:23 92] SQL: IM002
[18:26:23 92] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

Please tell me how fix it?

[ImportBot]

Originally Posted by XpKiller*:

 

Isn't there an option in the plugin settings to set the number of retries before giving up? I'm just trying to remember off the top of my head.

This is only for failed transaction eg. a transaction is rolled back by the mysql server due a deadlock.

[ImportBot]

Originally Posted by XpKiller*:

 

@russel5

 

it could be an issue with windows 8.

 

Stupid question, did you try a restarted of windows yet ? Windows behaves sometimes very strange.

 

 

And another info:

The comming version of the plugin will not need the odbc driver anymore!!

So you will just need to fill in you connection settings and you are done.

Thanks to the procon core team with has implemented the native mysql c# connector.

The version is nearly done and im testing right now.

[ImportBot]

Originally Posted by utopiate*:

 

@russel5

 

it could be an issue with windows 8.

 

Stupid question, did you try a restarted of windows yet ? Windows behaves sometimes very strange.

 

 

And another info:

The comming version of the plugin will not need the odbc driver anymore!!

So you will just need to fill in you connection settings and you are done.

Thanks to the procon core team with has implemented the native mysql c# connector.

The version is nearly done and im testing right now.

Thats great news, seems the driver does cause people a lot of probs. Nice one XpKiller. MOHW support in the new version? :smile:

[ImportBot]

Originally Posted by XpKiller*:

 

That will be the next thing.

 

Im my plans are to to release a version which will support all games.

[ImportBot]

Originally Posted by utopiate*:

 

That will be the next thing.

 

Im my plans are to to release a version which will support all games.

Awesome, if you ever need anything just give me a shout. I can always set up a server for you to test on On that note let me just say a big thankyou to all here on the procon forums, without this I simply would not operate servers

[ImportBot]

Originally Posted by russel5*:

 

Hi, I noticed a strange thing. My problem, as described above, only appears when I try to run plugin in Procon Layer Server. When I run the plugin from my local computer, no error to be. This case is hosting Procon? They do not support the database? My Procon Hosting is Gameservers.com

[ImportBot]

Originally Posted by XpKiller*:

 

@russel5

gameserver.com dont install the ODBC Driver.

 

But in the next version, coming the next days, you wont need the driver anymore!

[ImportBot]

Originally Posted by russel5*:

 

@russel5

gameserver.com dont install the ODBC Driver.

 

But in the next version, coming the next days, you wont need the driver anymore!

ok. thanks for info

[ImportBot]

Originally Posted by XpKiller*:

 

Changelog for Version 1.1.0.0:

ProCon 1.4.0.5 or higher is required!!!

Now uses the native ADO MySQL Connector instead the MySQL ODBC Driver. NO Driver Installation required anymore!!!

Also supporting Connection Pooling.

New feature Livescoreboard: If enabled, the plugin write several infos to the database in a table called tbl_currentplayers. Some of these infos are: Playerinfos(name, guids, countrycode, ...) and Playerstat(Score, Kills, Deads, Headshots)

The table gets updated everytime procon gets new full playerlist update (around every 30 sec. its adjustable to less updates.)

Some smaller fixes and code improvements.

[ImportBot]

Originally Posted by Dudenell*:

 

Not sure what's going on but the !rank command use to say the message, now it seems to be yelling and players are complaining, how would I revert it back?

[ImportBot]

Originally Posted by XpKiller*:

 

@Dudenell

Plugin Settings --> Stats --> Playermessage --> click on the three dots --> Replace eg. [yell,2] with [say]

[ImportBot]

Originally Posted by XpKiller*:

 

New Features:

NO ODBC Driver needed anymore! This version can be run on every PRoCon Layer with PRoCon 1.4.0.5 or higher. This should people which having a layer provide which will not install the ODBC Driver.

The Plugin is now able to write a LiveScoreboard back to the Database. The table is called tbl_currentplayers

The Plugin is supporting Connection Pooling. If get errors please disabled Connection pooling in the plugin settings.

 

Please give Feedback and Feel free to donate if you like my work.

 

 

Changelog:

1.1.0.0

ProCon 1.4.0.5 or higher is required!!!

The Plugin uses the native ADO MySQL Connector now instead of the MySQL ODBC Driver.

NO Driver Installation needed anymore!!!

This also means it can be run on host with dont install the odbc driver like gameservers.com.

Also supporting Connection Pooling.

New feature Livescoreboard: If enabled, the plugin write several infos to the database in a table called tbl_currentplayers.

Some of these infos are: Playerinfos(name, guids, countrycode, ...) and Playerstat(Score, Kills, Deads, Headshots)

The table gets updated everytime procon gets new full playerlist update (around every 30 sec. its adjustable to less updates.)

Some smaller fixes and improvments code

[ImportBot]

Originally Posted by ty_ger07*:

 

New Features:

NO ODBC Driver needed anymore! This version can be run on every PRoCon Layer with PRoCon 1.4.0.5 or higher. This should people which having a layer provide which will not install the ODBC Driver.

The Plugin is now able to write a LiveScoreboard back to the Database. The table is called tbl_currentplayers

The Plugin is supporting Connection Pooling. If get errors please disabled Connection pooling in the plugin settings.

 

Please give Feedback and Feel free to donate if you like my work.

 

 

Changelog:

1.1.0.0

ProCon 1.4.0.5 or higher is required!!!

The Plugin uses the native ADO MySQL Connector now instead of the MySQL ODBC Driver.

NO Driver Installation needed anymore!!!

This also means it can be run on host with dont install the odbc driver like gameservers.com.

Also supporting Connection Pooling.

New feature Livescoreboard: If enabled, the plugin write several infos to the database in a table called tbl_currentplayers.

Some of these infos are: Playerinfos(name, guids, countrycode, ...) and Playerstat(Score, Kills, Deads, Headshots)

The table gets updated everytime procon gets new full playerlist update (around every 30 sec. its adjustable to less updates.)

Some smaller fixes and improvments code

Awesome work XpKiller!

 

The live scoreboard feature should be nice for users who are unable to use BF3conn due to host not allowing it through their firewall.

 

I will plan to add the live scoreboard to my stats page soon.

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller, I am trying out this new version.

 

Is there anything which needs to be done to make the currentplayers table work? Is it dependent on any other feature? I have sessions disabled. Is that why the currentplayers table isn't working?

 

EDIT:

 

Sorry, I am a n00b. I didn't see the "Enable Livescoreboard in DB_" in the options. Doh!

 

Scoreboard added to my stats page code.

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller,

 

I assume if you could do this, you would already have done it... But I have to ask anyway.

 

Is it not possible to store the current number of team tickets in the currentplayers table?

 

EDIT: And current game mode being played?

[ImportBot]

Originally Posted by utopiate*:

 

Hi xpkiller and thx for this update it looks good. Quick question; do I need to drop my existing DB or can I just update the plugin and have carry on sending to my existing DB?

 

Once again many thanks

[ImportBot]

Originally Posted by XpKiller*:

 

you can keep you existing DB. Just update your Plugin.

[ImportBot]

Originally Posted by XpKiller*:

 

XpKiller,

 

I assume if you could do this, you would already have done it... But I have to ask anyway.

 

Is it not possible to store the current number of team tickets in the currentplayers table?

 

EDIT: And current game mode being played?

i will added that very soon, it will added to the tbl_server table.

[ImportBot]

Originally Posted by ty_ger07*:

 

i will added that very soon, it will added to the tbl_server table.

Oh, I didn't realize that current game mode was already stored in that table. Cool. Thanks! Can't wait.

[ImportBot]

Originally Posted by XpKiller*:

 

Oh, I didn't realize that current game mode was already stored in that table. Cool. Thanks! Can't wait.

Yeah but the tickets not, i forgot them.

[ImportBot]

Originally Posted by GerWonder*:

 

hello,

can someone please help me with installing this awesome plugin? i think i set all settings correct but i still get this errror.

 

thanks for your help ...

 

Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Security.Permissions.SecurityPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@ GerWonder

You need to disabled the sandbox or add your database host to the trusted hosts.

After that you need to restart procon.

[ImportBot]

Originally Posted by mc-kay*:

 

I get the same error on a hosted Procon layer (g-portal.de).

How can I disable this sandbox?

Is this even possible without root access?

[ImportBot]

Originally Posted by utopiate*:

 

tools/options/plugins/plugin security

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

You cannot disable the sandbox of your hosted Procon Layer yourself.

You'll have to ask g-portal to do that for you, though they probably won't do that.

[ImportBot]

Originally Posted by mc-kay*:

 

This are the current settings:

 

Looks good, but its not working

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

That's because you're changing your local sandbox settings.

As posted above, you cannot modify your layer's settings without accessing the Procon Layer directly (either via GUI and RemoteDesktop or via full FTP access to the config directory). This is usually not allowed by hosters.