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

[ImportBot]

Originally Posted by Legate*:

 

I tried to show %playerRounds% but doesn't work.

 

Anyone knows how show the number of rounds played by a player?

[ImportBot]

Originally Posted by ty_ger07*:

 

I tried to show %playerRounds% but doesn't work.

 

Anyone knows how show the number of rounds played by a player?

It's %rounds%.

 

Look at "Replacement Strings for Playerstats" in the Plugin details in PRoCon.

 

"%rounds% Will be replaced by the player's totalrounds played on this server"

 

In the plugin code:

Line 3388: result = this.ListReplace(result, "%rounds%", row["Rounds"].ToString());

[ImportBot]

Originally Posted by johnny5*:

 

I changed ODBC connector version & it broke.

 

5.1.9 works 5.1.11 doesn't. just letting people know.

[ImportBot]

Originally Posted by XpKiller*:

 

@johnny5

you mean the time issue?

[ImportBot]

Originally Posted by Bl1ndy*:

 

Please add the option to automaticly input the top10 in chat on a timer or Round Start.

[ImportBot]

Originally Posted by blackeyes08*:

 

hello

[13:44:15 72] Error in Tablebuilder:

[13:44:15 72] Index #0

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

[13:44:15 73] Native: 0

[13:44:15 73] Source:

[13:44:15 73] SQL: IM002

[13:44:15 74] Error: System.NullReferenceException: La référence d'objet n'est pas définie à une instance d'un objet.

à PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[13:44:15 74] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié

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

à System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

à System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

à System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

à System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

à System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

à System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

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

à PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

 

Can you help please ?

 

thanks

[ImportBot]

Originally Posted by johnny5*:

 

Yeah the date/time stamp is differrent from 5.1.9.

 

5.1.11 doesnt work. when 5.1.9 does. 5.1.9, with my setup had some very intermittent time issues, i think it was caused by connection losses & retries, whatever glitches.

 

5.1.11 doesnt work at all. it says eg. timestamp in the whole database is wrong, first error was tbl_chatlog->logDate. Seems to me it wanted the month & day to be in oppososite positions, switch day & month or some shit. I just uninstalled 5.1.11 cause it is majorly different than 5.1.9.

 

I fucked arounf with some machine locale things, but re-installing 5.1.9 made things work again.

 

Surprising.

[ImportBot]

Originally Posted by Jaffaman*:

 

Thanks alot it looks like reinstalling the 5.1.9 worked for me

 

Is there a way to rebuild all the time sessions I.E 1st seen last seen ect? i am not to fussed about the times on the messages or do i just have to start again with a clean database?

[ImportBot]

Originally Posted by XpKiller*:

 

@Jaffaman

 

Rebuild is possible but complicated

[ImportBot]

Originally Posted by Jaffaman*:

 

Thanks but will most probs just reset it when the server is empty.

[ImportBot]

Originally Posted by Panther*:

 

Not sure what happend here. Trying to help a friend. The Table did work 2 days and suddenly this error.

 

Code:

[10:13:36 44] Info: Start tablebuilder[10:13:36 44] Error in Tablebuilder: 
[10:13:36 44] Index #0
[10:13:36 44] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.61-0+squeeze1]Incorrect table name 'tbl_chatlog
'
[10:13:36 44] Native: 1103
[10:13:36 44] Source: myodbc5.dll
[10:13:36 44] SQL: HY000
[10:13:36 44] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

[ImportBot]

Originally Posted by Legate*:

 

It's %rounds%.

 

Look at "Replacement Strings for Playerstats" in the Plugin details in PRoCon.

 

"%rounds% Will be replaced by the player's totalrounds played on this server"

 

In the plugin code:

Line 3388: result = this.ListReplace(result, "%rounds%", row["Rounds"].ToString());

Thanks :-)

[ImportBot]

Originally Posted by ty_ger07*:

 

Not sure what happend here. Trying to help a friend. The Table did work 2 days and suddenly this error.

 

Code:

[10:13:36 44] Info: Start tablebuilder[10:13:36 44] Error in Tablebuilder: 
[10:13:36 44] Index #0
[10:13:36 44] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.61-0+squeeze1]Incorrect table name 'tbl_chatlog
'
[10:13:36 44] Native: 1103
[10:13:36 44] Source: myodbc5.dll
[10:13:36 44] SQL: HY000
[10:13:36 44] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

It looks like there is a line return at the end of the table name. Is it possible that he accidentally added a line break where it asks for the table suffix and this has been appended to the table name in the plugin?

[ImportBot]

Originally Posted by Ruger*:

 

Yeah...mine started giving me this:

[10:28:11 40] Info: Start tablebuilder

[10:28:12 13] Error in Tablebuilder:

[10:28:12 13] Index #0

[10:28:12 13] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56]Duplicate column name 'M416_kills'

[10:28:12 13] Native: 1060

[10:28:12 13] Source: myodbc5.dll

[10:28:12 13] SQL: 42S21

[ImportBot]

Originally Posted by XpKiller*:

 

Looks like a faultly bf3.def files which has two different entries for the weapon m416.

Remove one and it should be working again.

 

I looking to release a new version the weekend too.

[ImportBot]

Originally Posted by Phil_K*:

 

Hi.

 

Looks like a faultly bf3.def files which has two different entries for the weapon m416.

Remove one and it should be working again.

Not really faulty but since R-24 the servers also report M416 as pure and not with "Weapons/M416/M416".

But I also find some entries with the long version but not 100% if that was before the update restart or

after that. So both entries are in the BF3.def and the loc files. Compared they are uniq so it shouldn't hurt

anyway, but I don't know what magic your plugin does to those strings.

 

Greets

Phil.

[ImportBot]

Originally Posted by TeamKiller*:

 

Is there a way to delete a particular player or to reset their stats?

can help me as a

[ImportBot]

Originally Posted by Athlon*:

 

Is there a way to delete a particular player or to reset their stats?

can help me as a

Do you have access to your MySql server? (phpMyAdmin_) You can delete a record there.

 

If not - can you upload and run a web page (php) if I post it here? I have one I wrote that I use to delete multiple records at a time....

[ImportBot]

Originally Posted by Athlon*:

 

Looks like a faultly bf3.def files which has two different entries for the weapon m416.

Remove one and it should be working again.

 

I looking to release a new version the weekend too.

It seems the latest Procon download has the offending M416 entry removed from the bf3.def file.

[ImportBot]

Originally Posted by Athlon*:

 

Looks like a faultly bf3.def files which has two different entries for the weapon m416.

Remove one and it should be working again.

 

I looking to release a new version the weekend too.

It seems the latest Procon download has the offending M416 entry removed from the bf3.def file.

I may have spoken too soon....

 

The current download does not have the double entry, but Procon seems to add it back in and then suggest a restart.

 

Anyway - when I remove this entry: 'procon.protected.weapons.add Assault "Weapons/M416/M416" Primary AssaultRifle', the plugin no longer gives the error. I will just ignore the prompt to restart Procon.

 

BTW, when I removed the other entry (procon.protected.weapons.add Assault "M416" Primary AssaultRifle), I got a 'shotgun' error with the plugin. I then put that line back in and removed the other line and all is good so far.

[ImportBot]

Originally Posted by TeamKiller*:

 

@Athlon

 

Yes, I have access to mysql also tried to delete when I deleted the player can not I! 10Top more players but only 9 players.

Are there any good solution for a player to simply reset his stats

[ImportBot]

Originally Posted by Phil_K*:

 

Hi.

 

The current download does not have the double entry, but Procon seems to add it back in and then suggest a restart.

You should have read myrcon.net/...chat-guid-stats-and-mapstats-logger#entry7606

As long as it is not officially confirmed which weapon code will stay with onKill both remain in the BF3.def.

Both are unique because "M416" != "Weapons/M416/M416".

 

If you want to use a modified BF3.def disable the automated check for updates.

 

Greets

Phil.

[ImportBot]

Originally Posted by Athlon*:

 

Got it. Thanks Phil.

[ImportBot]

Originally Posted by Athlon*:

 

@Athlon

 

Yes, I have access to mysql also tried to delete when I deleted the player can not I! 10Top more players but only 9 players.

Are there any good solution for a player to simply reset his stats

If you delete all of a player's records from the tables then the next time he joins he will start again with 'reset' stats.

[ImportBot]

Originally Posted by TeamKiller*:

 

@Athlon

 

How do I delete the table player?

I do not want to delete all the players only one player

[ImportBot]

Originally Posted by Athlon*:

 

@Athlon

 

How do I delete the table player?

I do not want to delete all the players only one player

I'm not saying to delete a whole table - just the player's records who you want to delete.

 

***MAKE A BACKUP OF YOUR DATABASE BEFORE YOU DO ANYTHING!!!***

 

Find the player's ID number in the tbl_playerdata table. Then delete the row with that ID number in all of the other tables as well as the tbl_playerdata table.

 

It may not be possible to do what you want this way because of the tbl_dogtags table though.

 

If you are not familiar with what I am saying, you are best off not doing it. I wouldn't want to see you mess up all of your stats. There may be an easier way, but I don't see one......

 

***MAKE A BACKUP OF YOUR DATABASE BEFORE YOU DO ANYTHING!!!***

[ImportBot]

Originally Posted by Ruger*:

 

Looks like a faultly bf3.def files which has two different entries for the weapon m416.

Remove one and it should be working again.

 

I looking to release a new version the weekend too.

Thanks XpKiller, Phil and Athlon!

[ImportBot]

Originally Posted by XpKiller*:

 

I'm not saying to delete a whole table - just the player's records who you want to delete.

 

***MAKE A BACKUP OF YOUR DATABASE BEFORE YOU DO ANYTHING!!!***

 

Find the player's ID number in the tbl_playerdata table. Then delete the row with that ID number in all of the other tables as well as the tbl_playerdata table.

 

It may not be possible to do what you want this way because of the tbl_dogtags table though.

 

If you are not familiar with what I am saying, you are best off not doing it. I wouldn't want to see you mess up all of your stats. There may be an easier way, but I don't see one......

 

***MAKE A BACKUP OF YOUR DATABASE BEFORE YOU DO ANYTHING!!!***

This is the wrong way

PlayerID != StatsID and so on

 

Just delete the Player in the tbl_playerdata (all other entries of this player in other tables except tbl_chatlog will get deleted automatically due the foreign key constains.

 

Or the delete all entries with the target PlayerID in tbl_server_player.

 

Otherwise i can give you an sql script for that.

[ImportBot]

Originally Posted by Athlon*:

 

Thanks XP - didn't want to delete a player to test my suggestion. That's why I said there might be an easier way.

 

Good information to have! Thanks!!

[ImportBot]

Originally Posted by TimSad*:

 

Hi.

 

Looks like a faultly bf3.def files which has two different entries for the weapon m416.

Remove one and it should be working again.

Not really faulty but since R-24 the servers also report M416 as pure and not with "Weapons/M416/M416".

But I also find some entries with the long version but not 100% if that was before the update restart or

after that. So both entries are in the BF3.def and the loc files. Compared they are uniq so it shouldn't hurt

anyway, but I don't know what magic your plugin does to those strings.

 

Greets

Phil.

Yeah, why is your plugin now creating duplicate M416 column entries just because there is a new weapon definition in the BF3.def file? I wouldn't think that should happen unless GetWeaponList (which I would think you would use to base the column creations off of) now somehow returns 2 instances of the M416. Also, do you or do you not use IF NOT EXISTS in the SQL?

 

I temporarily have this plugin disabled. Too much spamming of the plugin console about the duplicate columns. I'll re-enable it once you get an update out.