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

[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?

Am i the only one with this problem? Does anyone know how to fix this?

[ImportBot]

Originally Posted by cjffly*:

 

I think bambam's plug-in"ProconRulz", also mentioned that kind of problem, so his plug-in use "%_xxxxx" instead...

[ImportBot]

Originally Posted by CptChaos*:

 

Which topic is the current topic for this plugin? I responded in another topic, about the same plugin?

 

(Yes, I haven't been here for a while and I see that the forum is changed a lot)

 

Is there BTW an update coming for the new Close Quarters and Armored Kill weapons and vehicles?

 

And thanks again for this awesome plugin!

[ImportBot]

Originally Posted by XpKiller*:

 

This is the right topic the other is about a website for this plugin.

 

And no update is needed so far.

[ImportBot]

Originally Posted by zept0r*:

 

Hey so i got this awsome plugin running all fine together with my MySQL, but somehow only the stats are working i cant find any option for the Killstreak settings (to turn it on atleast) _! Im using 1.0.0.7

[ImportBot]

Originally Posted by hondarghini*:

 

Where is the tutorial?

[ImportBot]

Originally Posted by zept0r*:

 

Really? 10 days without an answer?

And I thought this was "supported".

[ImportBot]

Originally Posted by XpKiller*:

 

i dont understand what you mean with killstreak settings

[ImportBot]

Originally Posted by zept0r*:

 

Description:

 

This plugin is used to log player chat, player GUID's, player Stats, Weaponstats and Mapstats.

This includes: Chat, PBGUID, EAGUID, IP, Stats, Weaponstats, Dogtags, Killstreaks, Country, ClanTag to be continued.. ;-)

 

I cant get thoose killstreaks to work.

[ImportBot]

Originally Posted by XpKiller*:

 

the highest Killstreak of a player is tracked in the database. it always on. Killstreaks aren't actively announced.

[ImportBot]

Originally Posted by shadow2k1*:

 

is there anyway to use this plugin without the use of a mysql server?

maybe write to a text file?

[ImportBot]

Originally Posted by XpKiller*:

 

is there anyway to use this plugin without the use of a mysql server?

maybe write to a text file?

No, not possible a mysql server is required!

 

Anyway writing everything to a textfile wont work very long.

[ImportBot]

Originally Posted by hondarghini*:

 

Hello,

 

I am dutch, I have learnd a little bit english when i was young.So it isnt very good.

Now have i playd Battlefield cince the first one.

 

two weeks ago,Ive rented a server by Clanhost and it would be cool to have your plug-in.

But When i ask for help by Clanhost,they just aswers me by email whith little emails withouth any information.

 

My whole procon is red with errors about MySQl and the plugin shuts down.

 

I dont even now what a MySQL is? But Procon answer me,that The MySQL is (very difficult word)

 

Please... is there anyone who can help me with screens etc? or tutorial?

I cant find any?

 

gr hondarghini

[ImportBot]

Originally Posted by GitSum*:

 

This Plugin REQUIRES a database and in order for Procon to connect to the database, the computer that is running Procon needs to have a driver installed (ODBC). Without the driver and database, this plugin will simply not work!

 

Now, I understand that RCON Hosting provides both of these - so you may want to think about spending $2 a month and rent a procon server from them

 

 

 

http://www.rconhostingservices.net/

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller, or someone else who knows for certain, could you please let me know which ODBC driver version you recommend? I switched to a new PRoCon Layer Hosting service. This hosting service just started offering the PRoCon Layer service and do not know which ODBC driver is recommended.

 

With the driver version they are using, I am experiencing the '0000-00-00 00:00:00' time bug where I didn't experience this issue with my former PRoCon Layer host.

 

Thanks a lot!

[ImportBot]

Originally Posted by XpKiller*:

 

@ty_ger07:

from the plugin description:

Attention:

ODBC MYSQL Driver 5.1.11 is buggy and will cause faulty date entires.

http://bugs.mysql.com/bug.php_id=65418

Thx to johnny5 for the find

 

Its recommend to use the 5.1.9 Driver

 

The workaround is to use ODBC MYSQL Driver 5.1.9 or 5.1.10 with Mysql Server before 5.6

or

ODBC MYSQL Driver 5.1.11 with MySQL Server 5.6 or later

 

The bug is known and might be fixed in the next driver release.

[ImportBot]

Originally Posted by ty_ger07*:

 

@ty_ger07:

from the plugin description:

Attention:

ODBC MYSQL Driver 5.1.11 is buggy and will cause faulty date entires.

http://bugs.mysql.com/bug.php_id=65418

Thx to johnny5 for the find

 

Its recommend to use the 5.1.9 Driver

Thanks for the response! I was looking down in the "Requirements" section of your post and thought the information was a bit ambiguous. I totally skipped over the very top of the post where you provided more specific information.

[ImportBot]

Originally Posted by Jenne*:

 

habe ne Fehlermeldung ...wenn ich das Pluggi starte

 

[17:01:06 70] Info: Table suffix set to

[17:01:06 71] Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[17:01:08 73] Info: Start tablebuilder

[17:01:08 73] Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[17:01:08 75] Info: Prevented double creation of columns for weapon: P90

[17:01:08 76] Info: Prevented double creation of columns for weapon: MP443

[17:01:08 78] Info: The table tbl_weapons_shotgun is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 81] Info: The table tbl_weapons_assaultrifle is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 84] Info: The table tbl_weapons_smg is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 85] Info: The table tbl_weapons_suicide is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 85] Info: The table tbl_weapons_none is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 86] Info: The table tbl_weapons_melee is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 87] Info: The table tbl_weapons_projectileexplosive is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 87] Info: The table tbl_weapons_handgun is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 88] Info: The table tbl_weapons_sniperrifle is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 89] Info: The table tbl_weapons_lmg is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 89] Info: The table tbl_weapons_explosive is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[17:01:08 90] Info: The table tbl_weapons_nonlethal is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[ImportBot]

Originally Posted by XpKiller*:

 

Hallo Jenne,

 

das sind keine Fehler :-)

 

Info ist wieder names sagt nur Infos.

 

Warning sind hinweise aber in den meisten fällen kann man die ignorieren. Wie hier in diesem Fall.

 

Richtige Fehler sind mit Error und in rot geschrieben.

 

Wenn du das Debuglevel auf error stellst sieht du nur die wirklich wichtigen Fehler.(falls welche auftreten)

[ImportBot]

Originally Posted by Jenne*:

 

ah ok vielen Dank

[ImportBot]

Originally Posted by XpKiller*:

 

Two new ingames command have been integrated: Player of the day & top10 for a specific time period

 

New Ingame CommandSystem:

Now every ingame command can be customized by the user.

 

 

Please post new ideas, feature requests or just feedback in this thread.

 

 

 

Changelog:

1.0.0.9

Optimzed / rewritten Code

New Ingame Commandsystem; every commandword can be customized now. Also you can set multiply commandword for the same command (comma seperated, e.g: stats,rank)

New Ingamecommand Player of the day, shows up the best player of the server for today (sessions needs to be turned on!)

New Ingamecommand top10 player for a variable period, shows up the top 10 players for a specific period (default is 7 days) (sessions needs to be turned on!)

a few performance improvements

 

 

 

 

And Thanks for more than 1000 Downloads of my plugin

[ImportBot]

Originally Posted by fantasticplayer*:

 

Im wondering how can i setup this plugin if i dont know how to do it. Maybe my sentense is without sense but ive setup some other plugins but with that one i dont have no idea how to do all that ODBC MYSQL Driver 5.1.9. Maybe someone have a some solution or instruction how to do that.

 

King regards

FanTasticPlayer

[ImportBot]

Originally Posted by XpKiller*:

 

Hi,

 

the most things are described in this thread:

www.phogue.net/forumvb/showth...ighlight=mysql*

 

If you still go problems feel free to ask.

Please not nearly all free mysql services like freesql are not suiteable for that plugin because of the high usage of the database. They are getting to slow and unreliable.

[ImportBot]

Originally Posted by Bustar*:

 

I keep getting my procon host' IP block because of connection errors, this is now happening weekly, any ideas?

 

[18:16:31 56] Info: Start tablebuilder

[18:16:31 56] Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[18:16:31 59] Error in Tablebuilder:

[18:16:31 59] Index #0

[18:16:31 59] Message: [MySQL][ODBC 5.1 Driver]Host '208.100.45.9' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

[18:16:31 61] Native: 1129

[18:16:31 61] Source:

[18:16:31 61] SQL: HY000

[18:16:31 61] Index #1

[18:16:31 61] Message: [MySQL][ODBC 5.1 Driver]Host '208.100.45.9' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

[18:16:31 61] Native: 1129

[18:16:31 61] Source:

[18:16:31 61] SQL: HY000

[18:16:31 61] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:16:31 64] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Host '208.100.45.9' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Host '208.100.45.9' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

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

 

Hi Bustar,

 

I need some more infos from you to help you.

 

I need the Server details settings(without password and user)

 

Question:

Did it ever work?

Do you have other plugins running which using the same db/mysql server?

Have you seen different errors as the posted ones?

 

Could you enable tracelogging?

 

Normally those errors pop up if you got a network issues, a connection gets closed due a timeout, reaching max querys, MySQL syntax errors or invalid credentials. Those thing are count as aborted_clients. (By default 10 error are allowed per minute).

 

The MySQL server increments Aborted_clients when:

 

The client program did not call mysql_close() before exiting.(shouldnt be the problem)

The client had been sleeping more than wait_timeout or interactive_timeout second without issuing any requests to the server.

The client program ended abruptly in the middle of a data transfer. (network issues)

 

The MySQL server increments Aborted_connects when:

 

A client doesn't have privileges to connect to a database.

A client uses an incorrect password.

A connection packet doesn't contain the right information.

It takes more than connect_timeout seconds to get a connect packet.

[ImportBot]

Originally Posted by Bustar*:

 

Hi XpKiller, thanks for your quick reply,

 

Yes the plugin has been working fine for months, and only started playing up about 6 weeks ago.

 

No we're not using any other plugins with the db/mysql server.

 

The posted errors are the only ones I have seen.

 

Yes I was able to enable the trace.

 

I'm having trouble uploading a pic of the settings, so I just typed them out. Im also pretty new to using mysql

 

 

Chat logging:

enable chat logging yes

log server spam yes

instant logging of chat message yes

enable chatlog filter no

 

Debug:

Debug level trace

 

Flood protection:

player requests per round 0

 

Map stats yes

 

Server details:

host xxxxx

port xxxxx

database name xxxxx

username xxxxx

password xxxxx

close connection after each request yes

high performance mode no

failed transaction retry attempts 3

 

Session:

session on no

session message

save session to db no

 

Stats:

enable stats logging yes

ranking by score yes

enable ingame commands no

overall ranking no

server group 32

send stats to all players no

player message

weapon stats message

top10 ingame no

 

timeroffset:

servertime offset 0

 

welcome stats:

enable welcome stats yes

welcome message

welcome message for new polayers

welcomestats delay 3

 

 

Thanks heaps, Bustar

[ImportBot]

Originally Posted by Pegasus829*:

 

Which gameserver port is the plugin going out over? Game port or query port? I need to request an exception be added with my host.

[ImportBot]

Originally Posted by XpKiller*:

 

The plugin only needs the TCP port 3306 to access the MySQL server.

Please note some MySQL have a different port. But most times 3306 is the right one.

 

I guess your provider will also need the ip address of you MySQL server.

[ImportBot]

Originally Posted by DrFellatio*:

 

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

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)

 

The plugin doesnt work. I used the correct database informations and this is showing up all the time. I don`t get this issue about the MYQL connector... I`ve installed the newest version on my local PC and nothing has changed. And I do not understand why I have to put BF3.def into config folder. It`s already there... Please help (maybe in german...), this installation is overhelming me!

[ImportBot]

Originally Posted by XpKiller*:

 

@DrFellatio

 

Hi,

 

du musst nichts mehr mit der bf3.def machen. Ich muss das mal aus der Beschreibung herausnehmen.

 

Zu deinem Fehler:

Du musst noch einen DSN (Data Source Name) setzen.

Das geht so(windows 64bit):

1. Start --> Ausführen

2. %windir%\syswow64\odbcad32.exe eingeben

3.Dann den Reiter System DSN auswählen

4.Hinzufügen/Add

5.Den MySQL ODBC Driver 5.1 auswählen und auf fertig klicken

6.Einen beliebigen Datasource Name eingeben und OK drücken.

6.a. die restlich Felder braucht man nicht angepassen.

7. Mit OK bestätigen nun sollte es gehen.