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

[ImportBot]

Originally Posted by XpKiller*:

 

I do not understand, because I use a generator for php

 

I can give you my id in my sql

Which id?

[ImportBot]

Originally Posted by FARSTAN*:

 

The code you give will bring up the column name in the table soldler playerstats?

 

and do you think it can work for all players ?

it would be really great if I could get this column, playername in tbl_playerstats

Code:

WHERE tpd.SoldierName = '%SoldierName%';

[ImportBot]

Originally Posted by FARSTAN*:

 

Which id?

ah, look at your private message on the forum

[ImportBot]

Originally Posted by FARSTAN*:

 

the query function as you can see pictures, now, forgive me if I disturb you, how to do this automatically for all players ?

 

Attached Files:

• 72.51.45.245 - localhost - gspmegah_serv32hc - tbl_playerstats - phpMyAdmin 3.4.5.png

[ImportBot]

Originally Posted by XpKiller*:

 

the query function as you can see pictures, now, forgive me if I disturb you, how to do this automatically for all players ?

The where condition decides which player will be shown.

Just remove it the line which contains the Where condition.

 

You will need a php which do such a formed query .

[ImportBot]

Originally Posted by Globel*:

 

i get this repeating in my console..

 

 

[21:06:23 15] Error: SQLQuery:System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91mm-log]MySQL server has gone away

--- 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.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[ImportBot]

Originally Posted by XpKiller*:

 

@Globel

Your error is not caused by the plugin directly . The meaning of the error is that the MySQL server has unexpectedly closed the connection. This is probably a problem I can't fix . Also the MySQL version 5.0 is very old. Could you post who host this DB.

[ImportBot]

Originally Posted by g34rfr34k*:

 

This plugin is great. However, it could be perfect if it would save the data as a simple txt file on your pc, or in xml format.

 

Is it possible?

[ImportBot]

Originally Posted by Legate*:

 

You can use HeidiSQL for that.

[ImportBot]

Originally Posted by XpKiller*:

 

This plugin is great. However, it could be perfect if it would save the data as a simple txt file on your pc, or in xml format.

 

Is it possible?

A real database is needed for this plugin. I will not change this.

 

Also HeidiSQL wont help because it is just a Frontend.

[ImportBot]

Originally Posted by GoldFuchs*:

 

Hey great Plugin!

I have a question about the Mapstats (Joiner/leaver), Have i a option to evaluate this data?

[ImportBot]

Originally Posted by Legate*:

 

A real database is needed for this plugin. I will not change this.

 

Also HeidiSQL wont help because it is just a Frontend.

Its true but he can use HeidiSQL to extract info from his database without to much effort or DB knowlege.

[ImportBot]

Originally Posted by FARSTAN*:

 

XpKiller I wanted to show you my project, taking shape, only the stats from our server 32 tickets in 1000, is available, the others will be available next week

 

http://stats-server.team-gsp.net/

 

for example here, it lacks the column namesoldier which would be very good, unfortunately, I do not know how

http://team-gsp.net//stats-server/32...p_order=dScore

 

 

I would also like to know, it saves the base stats tank, plane, helicopter ... if it exists ?

 

CHAO

[ImportBot]

Originally Posted by i-B4se*:

 

Some german here and can help me with the installation?

Please PM

[ImportBot]

Originally Posted by XpKiller*:

 

I would also like to know, it saves the base stats tank, plane, helicopter ... if it exists ?

Yes as soon the gameserver report their kills correctly.

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 0.0.0.5beta

 

 

Changelog:

 

[0.0.0.5beta]

Overall ranking (merged server-ranking)

Fixed Queries

Small code improvements

Fixed dogtag command

Fixes for some errors

 

Note:

To use the overall ranking option the server need to be setup to use the same db and tablesnames(same suffix).

And again pls dont split up your server into multiply dbs or tables suffixes. This costs just db performance.

[ImportBot]

Originally Posted by max1982*:

 

Thanks for the update XpKiller

 

here is the new update error on the 0.0.0.5beta

 

(((Error: GetTop10: System.InvalidCastException: Object cannot be cast from DBNull to other types.

at System.DBNull.System.IConvertible.ToDouble(IFormat Provider provider)

at System.Convert.ToDouble(Object value)

at PRoConEvents.CChatGUIDStatsLoggerBF3.GetTop10(Stri ng strSpeaker, Int32 delay, String scope)

))

[ImportBot]

Originally Posted by FARSTAN*:

 

I finish my script for server 32, tell me what you think http://stats-server.team-gsp.net/

 

ty XpKiller I drew the new with great impatiance, you have a news for the welcome & player stats & clan tag ?

 

Oh and our question, hoping not to disturb it possible to change the sql in phpmyadmin (countrycode) in image, not text, because I want an image of flags, I could put on my ftp, a file and sql as the player affcihe the flags in my script?

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 0.0.0.6beta

 

Please use the bf3.def in the zip file. The bf3.def files which comes with Procon has some errors!!!!

 

 

Changelogs fixed SQL Querys again :-( oops.

 

Feel free to post feedback.

 

Also make suggestions for improvements and new feature please.

[ImportBot]

Originally Posted by Clay52*:

 

XpKiller, I get this occasionally among other erros but have beta 0.0.0.5, will the new beta fix this_:

 

[15:27:45 60] Error: Error in Startstreaming:

[15:27:45 61] Index #0

[15:27:45 61] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56]Duplicate entry 'EA_82A454A4681FADB4DBA2A8F4822C00BE' for key 'UNIQUE_playerdata'

[15:27:45 61] Native: 1062

[15:27:45 61] Source: myodbc5.dll

[15:27:45 61] SQL: 23000

[ImportBot]

Originally Posted by XpKiller*:

 

@Clay52

Normally such error should not occur because the plugin check before insert a new a entry. Something must be wrong here.

 

Is it always the same EA_GUID which causes this error?

[ImportBot]

Originally Posted by Ghostryder81*:

 

Is the ingame command @top10 (@stats, @rank) WeaponName working for BF3 ?

Because I dont get any stats after typing @top10 M67 for example.

[ImportBot]

Originally Posted by XpKiller*:

 

@top10 weaponname and rank weaponname are not working atm but will work very soon properly with an update in the next days.

[ImportBot]

Originally Posted by FARSTAN*:

 

I come to you, to say that the kills are not Updated

[ImportBot]

Originally Posted by XpKiller*:

 

I come to you, to say that the kills are not Updated

The code for stats streaming hasn't be touch since the last 3 versions.

On my test system I don't have problems.

If possible turn general logging of the MySQL server on. For a few rounds.

[ImportBot]

Originally Posted by FARSTAN*:

 

I do not know, it was some days that are block kills, but the rest works fine, just the kills

[ImportBot]

Originally Posted by CptChaos*:

 

Today I had to reinstall Procon and thus this plugin today. I made a fresh new DB as well (just to be sure). It doesn't matter what I do, I can't seem to get weaponstats working. The plugin settings tab says "yes", but the tables won't show up in the database and I also can't set it to "no" (which should be the default I'd guess, because in the weekend I had to manually turn it on). Someonw who knows what to do? I would really like to keep track of the server(s) stats!

 

Even when the sandbox mode is disabled the plugin is not keeping track of the weaponstats. Odd thing: over the weekend 0.0.0.5 beta did work, even with weaponstats. Today it doesn't, 0.0.0.6 also doesn't keep track of weaponstats.

[ImportBot]

Originally Posted by Clay52*:

 

Any idea what causes this:

 

[20:22:48 69] Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.

at System.Data.Odbc.OdbcDataReader.GetRowCount()

at System.Data.Odbc.OdbcDataReader.FirstResult()

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.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[ImportBot]

Originally Posted by XpKiller*:

 

@all who have problems with statslogging

 

I can't reproduce the problem I have 2 server logging into the same DB and everything is fine. I need your logs procon pluginlog (debuglevel trace) and if possible the MySQL general log.

 

Also make sure you are using the bc3.def which comes with the plugin because the which comes with procon is bugged atm.

[ImportBot]

Originally Posted by Quax*:

 

"Warning: Weapon: RoadKill is missing in the bf3.def file!!!"

 

Warning: Weapon: M26Mass is missing in the bf3.def file!!!