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

[ImportBot]

Originally Posted by meatball88*:

 

Hmm for me the plugin wont track kills and some other stats but it tracks score. kills deaths not working yet or am i doing somthing wrong ?

[ImportBot]

Originally Posted by PBSGTS*:

 

It probably is, but personal messages are not. So every time someone joins everyone has to see the message. Lots of spam.

[ImportBot]

Originally Posted by XpKiller*:

 

New version [0.0.0.2beta]

 

Fixed some things.

Will work on the ingame Commands the next days .

If need help for SQL Query feel free to ask.

If want you could replace you original BF3.def file with the one in the zip.

[ImportBot]

Originally Posted by sourtimer*:

 

Thank you for your work.

 

Wanted to let you know I have tried the new version 0.0.0.2 and get this 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 LumpyNutZ*:

 

Am I the only one that isn't getting any data for, tbl_dogtags, tbl_mapstats, tbl_playerdata, tbl_playerstats, tbl_server_player?

 

tbl_chatlog and tbl_server work fine. I have everything that would be obvious turned on.

 

Chatlogging: Yes

Log ServerSPAM: Yes

Instant Logging of Chat Messages: Yes

Flood Protection: 10

Mapstats: Yes

Session: (Yes)/No doesn't seem to matter

 

Statslogging: Yes

Weponstats: Yes

Update EA GUID: Yes

Update PB-GUID: No

Ranking by score: Yes

Send Stats to all players: No

Top10 ingame: Yes

 

Offset: 0

 

Periodical Webrequest on: Yes

 

Enable Welcomestats: No

Yell Welcome Message: No

Welcomestats Delay: 60

 

-----------------------------------------------------------------------------------

 

Could this be why?

I have exactly same. Only chat- and server tables gathering info.

[ImportBot]

Originally Posted by PBSGTS*:

 

xPKiller, if you could help Lumpy and me with our issue it would be greatly appreciated!

 

Also, it says suicide and damagearea are missing from the weapons list.

[ImportBot]

Originally Posted by Belligerent*:

 

Thank you for your work.

 

Wanted to let you know I have tried the new version 0.0.0.2 and get this 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)

Getting this error and also missing weapon in bf3.def file

 

Example:

 

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

 

Getting this warning for all weapons.

[ImportBot]

Originally Posted by EBassie*:

 

Hey XPKiller,

 

Running tests on 2 servers, one CQ (suffix _bf3cq) and one RUSH (suffix _bf3rush).

Is it correct to have 2 server tables like this?

 

tbl_server_bf3cq

tbl_server_bf3rush

 

&

 

tbl_server_player_bf3cq

tbl_server_player_bf3rush

 

Greetings,

 

EBassie

[ImportBot]

Originally Posted by PBSGTS*:

 

Nvm figured my problem out, well not really. I created a new server instance and new schema and that fixed it.

[ImportBot]

Originally Posted by TimSad*:

 

Are the kills intended to not be functioning currently? Everyone that has been tracked since I installed this yesterday has 0 kills.

[ImportBot]

Originally Posted by PBSGTS*:

 

Are the kills intended to not be functioning currently? Everyone that has been tracked since I installed this yesterday has 0 kills.

He said somewhere that it's intentionally disabled.

 

Hmm, now tbl_server isn't recording anything >.

[ImportBot]

Originally Posted by STS-E4*:

 

any idea ?

 

Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxxxxxxxxxxxxxxx".

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

bei System.Security.PermissionSet.Demand()

bei System.Data.Common.DbConnectionOptions.DemandPermi ssion()

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

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

System.Data.Odbc.OdbcPermission

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

MyComputer

ODBC in ProCon on is on.. but no tables created in database

 

 

 

EDIT: my fault - working now - i forgot to setup the outgoing connection

who can read is a clear advantage: D

[ImportBot]

Originally Posted by XpKiller*:

 

@all

Drop your tables if got this 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

 

The Changes in 0.0.0.2beta only work with new build tables.

 

@Belligerent

This normal unless you use the modified BF3.def file

The Stock BF3.def dont contain definitions abaut the weapons yet.

 

@sourtimer & LumpyNutZ

You Error is strange because on my testsystem Kill Tracking is working properly.

Could you provide a Dump of your tables?

 

@EBastard

actually there is no need to use the tablesuffix anymore. Because the Stats not mixed up anymore.

The Servers use the same tbl_playerdata but each player has multiply StatsID generated out of the PlayerID and ServerID (tbl_server_player)

so Please use the tablesuffix only really needed.

I can provide a SQL Statement to get Playerstats sorted by Server.

The tablesuffix intention is now to use this plugin together with the old one.

 

@PBSGTS

Killtracking should be working please drop all your table created by the plugin. And let them rebuilld.

[ImportBot]

Originally Posted by PBSGTS*:

 

@PBSGTS

Killtracking should be working please drop all your table created by the plugin. And let them rebuilld.

I've already dropped the tables as of v 0.0.0.2, I'll give it another shot though.

 

Edit: I dropped the tables and when that didn't do anything I created a new db, still nothing. I assume you're talking about tbl_playerstats?

[ImportBot]

Originally Posted by Belligerent*:

 

Hi XpKiller,

 

Got almost everything working now

 

I have 2 servers running to the same database.The in-game rank/stats are only available from 1 server.

 

The 2nd server will display 'no stats available play a round first' no matter how many rounds you play.

 

Im not receiving any errors.

 

cheers

[ImportBot]

Originally Posted by XpKiller*:

 

Good to hear that's its work

Ingamecommands bugged atm will fix them the next days.

[ImportBot]

Originally Posted by Belligerent*:

 

Hi,

 

Ok,thanks for all your hard work

 

I did find out,depending on what server you first join with the plugin enabled is the only server your in-game rank will show.

 

I still adds everything from both servers to the database,you can only veiw stats from the first one you joined.

 

Thanks again.

 

cheers

[ImportBot]

Originally Posted by PBSGTS*:

 

Got it fixed, started everything fresh. Downloaded Procon 1.1.1.1, set this up, then added all my other plugins. Everything's working fine now.

[ImportBot]

Originally Posted by LumpyNutZ*:

 

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.17]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)

 

 

Made totally new db to 0.0.0.2 and getting this. Ideas?

[ImportBot]

Originally Posted by XpKiller*:

 

Could you post your full servername?

I increased the fieldsize to 200 chars it seems this is not enough . Unfortunately dice didn't documented how long a server name can be.

To fix that issue temporally change the datatype of the Field ServerName to Text .

[ImportBot]

Originally Posted by sourtimer*:

 

Xpkiller, many thanks!

 

Was my mistake. I deleted my DB and made a new one for version 0.0.0.2, now is working perfectly!

 

One thing is I do not have weaponstats tracking.

 

I think BF3.DEF does not go in plugin dir though.. maybe my mistake, should be elsewhere.

[ImportBot]

Originally Posted by Belligerent*:

 

Xpkiller, many thanks!

 

Was my mistake. I deleted my DB and made a new one for version 0.0.0.2, now is working perfectly!

 

One thing is I do not have weaponstats tracking.

 

I think BF3.DEF does not go in plugin dir though.. maybe my mistake, should be elsewhere.

I made the same mistake

 

The BF3.DEF belongs in the Configs file folder

 

@XpKiller,the rank and stats show to all players on the server,using either !,# or @ before the command and with the 'Send stats to all players' setting on or off.

 

Thanks again

 

cheers

 

cheers

[ImportBot]

Originally Posted by Legate*:

 

[10:30:10 35] Error: SQLQuery:

[10:30:10 37] Index #0

[10:30:10 37] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.13]Unknown column 'playerKills' in 'order clause'

[10:30:10 37] Native: 1054

[10:30:10 37] Source: myodbc5.dll

[10:30:10 37] SQL: 42S22

 

This message appears when a player checks his rank.

 

 

 

It's rare: on the playerstats table, no one player has stats about kills, deaths, headshots.. but has TKs, score, playtime, rounds....

[ImportBot]

Originally Posted by XpKiller*:

 

@Legate

The ingame commands are not working yet will fix that the next days.

The SQL query needs to adjusted.

[ImportBot]

Originally Posted by EBassie*:

 

I removed the suffixes, but now I get this errors:

 

[12:56:45 00] Error: Error in Startstreaming:

[12:56:45 00] Index #0

[12:56:45 01] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.35]Cannot add or update a child row: a foreign key constraint fails (`stats_db`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[12:56:45 01] Native: 1452

[12:56:45 01] Source: myodbc5.dll

[12:56:45 01] SQL: HY000

[ImportBot]

Originally Posted by 0mni*:

 

Some of the ingame commands are working, so I know that the plugin is able to send messages, but it does not send any messages when a player joins the server. Still not sure why that is happening.

[ImportBot]

Originally Posted by XpKiller*:

 

@ebastard could you give a DB dump?

How do you removed your suffix ?

 

@0mni

Welcomestats are disabled in the source code atm.

[ImportBot]

Originally Posted by Clay52*:

 

Sorry for the question but I'm a noob at setting up a database. I have the driver installed but then that's where I'm stuck, thanks everyone.

[ImportBot]

Originally Posted by EBassie*:

 

@ebastard could you give a DB dump?

How do you removed your suffix ?

I removed all automatic created tables and removed the suffix in the plugin settings screen.

So the plugin created all tables new.

 

EDIT:

Hmm, for some reason I cannot drop the tables to try it again building new tables from plugin:

 

DROP TABLE `tbl_server`

DROP TABLE `tbl_playerdata`

 

gives this message:

#1217 - Cannot delete or update a parent row: a foreign key constraint fails

[ImportBot]

Originally Posted by XpKiller*:

 

Do you have entries in the table tbl_server ?