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

[ImportBot]

Originally Posted by lothop*:

 

well gameservers is telling me it does not support driver.. is there another option/program (rcon) or driver that i can use to get this to work? thanks again for the help.

I came up against the same issue.

https://www.rconhostingservices.net/

Costs $2 a month which is nothing.

[ImportBot]

Originally Posted by lothop*:

 

I dunno if this is possible.

 

But what I'm trying to do is get round by round data for a 4 round battle.

So round 1 has round 1 stats. That information gets stored in another table from the plugins tables and then the information gets wiped from the plugin tables for the start of round 2.

 

I have setup all the required scripts but when I go to wipe the data for the beginning of round 2 it gives me that error

Error: Error in Startstreaming:

Index #0

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

Are you able to shed any light on what I could possibly do to get this to work? Wiping the data and removing any stored information in the keys?

truncate doesn't wipe key information with InnoDB type. and MyISAM doesn't use foreign keys.

Or is it preset in the plugin to look for that foreign key to update database rows? So if it can't find the key it errors?

[ImportBot]

Originally Posted by XpKiller*:

 

im still no understand what are trying to do.

[ImportBot]

Originally Posted by lothop*:

 

Get a round by round account of what happens in each round.

 

So, John gets 2 kills in round 1.

It saves it and lets him view how he did in round 1 when ever he chooses 2.

He gets 6 kills in round 2 and it saves that to round 2 so he can view it later.

 

If the database doesn't get cleared at the end of round 1 he will have 8 kills at the end of round 2. 2+6. round1+round2.

 

 

Basically I'm wanting to know how can I clear the database and start with a fresh blank sheet to record data in

[ImportBot]

Originally Posted by XpKiller*:

 

such a function needs to include into th plugin

[ImportBot]

Originally Posted by Cire*:

 

Heres a question. Can i run two procon layers for same server? in other words run the stats of one and the others off one?

[ImportBot]

Originally Posted by XpKiller*:

 

@cire

sure you can do that but what is the reason for that?

[ImportBot]

Originally Posted by Cire*:

 

well all my plugins are with the gameservers procon layer. I dont know how to transfer plugins to a new provider. Also, what if i just run procon under a regular account and not a admin account? would i be able to run the bf3 stats plugin then? just have to keep it on all the time huh?

[ImportBot]

Originally Posted by Athlon*:

 

well all my plugins are with the gameservers procon layer. I dont know how to transfer plugins to a new provider. Also, what if i just run procon under a regular account and not a admin account? would i be able to run the bf3 stats plugin then? just have to keep it on all the time huh?

If you decide to do it on your computer (or a spare you have) and leave it on all the time, then you won't need the Gameservers Procon account anyway. It will save you a little bit to help pay for the extra electricity.

 

If you decide to run them both at the same time, just be sure they are running different plugins - in other words the two Procons should not run the same plugin. Disable any duplicates on one or the other.

 

If you are doing it just to get the stats, then that should be the only plugin activated on your local computer.

 

While you are at it, you could also put the database on your local machine as well. That's how we do it for our clan. Just follow the instructions here: www.phogue.net/forumvb/showth...-Configuration*

 

All of the software you need is free......

[ImportBot]

Originally Posted by Cire*:

 

ok thanks, ill try something, i went through all that and the dbase, but i could never figure out why i couldnt get the plugins to work even after i had a dbase set up and both drivers installed, it was because the layer didnt support the odbc drivers. thanks again.

[ImportBot]

Originally Posted by lothop*:

 

such a function needs to include into th plugin

What about setting the count back to 0 in the database after the round finishes?

So the player id's and server id's stay there, but their kills, score etc are reset back to zero?

[ImportBot]

Originally Posted by lothop*:

 

Just tested it out with a few players and it works. Database keeps its integrity and kill count / deaths / score etc are reset for the next round

[ImportBot]

Originally Posted by lothop*:

 

Sorry, me again.

 

Defib highscores? is this only for kills? not rezzs?

Medkit highscore? this isnt working is it? No way to count medkit heals?

[ImportBot]

Originally Posted by XpKiller*:

 

No informations regarding team actions like heal or rez are not transmitted via the rcon protocol.

So there is no possibly to track them atm.

[ImportBot]

Originally Posted by ronin*:

 

Hey peeps can anyone help me with this error didnt see it last night

 

Code:

[12:23:32 20] Error: Error in Startstreaming: 
[12:23:32 20] Index #0
[12:23:32 20] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.24-cll]Cannot add or update a child row: a foreign key constraint fails (`bulletpr_stats`.`tbl_server_playertble_`, CONSTRAINT `fk_tbl_server_player_tbl_servertble_` FOREIGN KEY (`ServerID`) REFERENCES `tbl_servertble_` (`ServerID`) ON DELETE CASCADE ON UPDATE NO A)
[12:23:32 20] Native: 1452
[12:23:32 20] Source: myodbc5.dll
[12:23:32 20] SQL: HY000

[ImportBot]

Originally Posted by XpKiller*:

 

@ronin

 

have you done any manual deletes?

you are using a table suffix is that correct.

 

The error means that the plugin tries to add a row to table tbl_server_playertble? but the serverid, which was expect was not in the server table. This could be just a timing issue.

 

How often do you get these error?

[ImportBot]

Originally Posted by ronin*:

 

@ronin

 

have you done any manual deletes?

you are using a table suffix is that correct.

 

The error means that the plugin tries to add a row to table tbl_server_playertble? but the serverid, which was expect was not in the server table. This could be just a timing issue.

 

How often do you get these error?

Well i only noticed it this morning i was trying to use the plugin with the stats page and thort this might be the reason the stats page was not working properly as it was displaying the server chat but thats it . Ive turned it back on now and will keep an eye on it for a bit .

 

the sufix i am using is tble? which im also using in the stats page.

 

Thanks Ronin

[ImportBot]

Originally Posted by Capt-O*:

 

I get this error after i got everything all setup, tried looking at some stuff but can't figure it out. Sorry if somebody already had this error and is in the posts.

 

02:46:26 78] Trace: StatsID: 1

[02:46:26 79] Error: Error in Startstreaming:

[02:46:26 79] Index #0

[02:46:26 80] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.25]Incorrect datetime value: '2012-07-12 02:20:18.712000000' for column 'FirstSeenOnServer' at row 1

[02:46:26 81] Native: 1292

[02:46:26 82] Source: myodbc5.dll

[02:46:26 82] SQL: HY000

[ImportBot]

Originally Posted by XpKiller*:

 

You are useing the MySQL ODBC 5.1.11 Driver. Please use 5.1.9 instead. This is a bug in the latest odbc driver.

[ImportBot]

Originally Posted by ronin*:

 

It seems to be giving this error every 3 hours . also this is what im getting on the stats page

 

stats.jpg

[ImportBot]

Originally Posted by Capt-O*:

 

You are useing the MySQL ODBC 5.1.11 Driver. Please use 5.1.9 instead. This is a bug in the latest odbc driver.

And i thought i made sure i downloaded the 5.1.9, but thats what i get for doing it at 4:00 in the morning. I knew had to be something stupid i did.

 

Thanks guys, will try now.

[ImportBot]

Originally Posted by Cornholio*:

 

anyone who's got a direct download link for ODBC 5.1.9 ? cannot find it on the MySQL site

[ImportBot]

Originally Posted by Athlon*:

 

anyone who's got a direct download link for ODBC 5.1.9 ? cannot find it on the MySQL site

both the 32 bit & 64 bit versions are on this page: http://dev.mysql.com/downloads/connector/odbc/5.0.html

[ImportBot]

Originally Posted by Shakal-hh*:

 

i have a problem after i have switched procon.exe to a windows-service....

before a have created and run this service it was working fine

 

[15:55:48 18] Error in Tablebuilder:

[15:55:48 18] Index #0

[15:55:48 18] Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben

[15:55:48 18] Native: 0

[15:55:48 18] Source:

[15:55:48 18] SQL: IM002

[15:55:48 18] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[15:55:48 18] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben

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

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

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

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

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

can someone help?

[ImportBot]

Originally Posted by XpKiller*:

 

setup the database connection as system dsn in the odbc pannel

[ImportBot]

Originally Posted by Shakal-hh*:

 

problem solved:

 

i had installed version 5.1.10..

i have deinstalled it and installed 5.1.9 64bit and 32bit

 

now it works without any changes

[ImportBot]

Originally Posted by GitSum*:

 

anyone who's got a direct download link for ODBC 5.1.9 ? cannot find it on the MySQL site

I found this site that has ALL the MySQL drivers. It is located in Japan but appears to be a mirror for the MySql website

 

Go to this page and then scroll down - you are looking for these files, either 32 or 64 bit. They even have md5's for the files

 

http://download.softagency.net/mysql...ctor-ODBC/5.1/

 

Here are direct links:

 

mysql-connector-odbc-5.1.9-win32.msi

 

mysql-connector-odbc-5.1.9-winx64.msi

 

Here is a link to a page on that domain - it looks just like the MySql site

http://download.softagency.net/mysql...dbc/index.html

[ImportBot]

Originally Posted by Singh400*:

 

FYI: You can download the legacy versions from . Just search the page for 5.1.9.

 

Might be worth putting up a mirror in the first post as well GitSum should they ever disappear.

 

I'll add some mirrors here:-

• http://localhostr.com/files/LC3jmBl/...1.9-winx64.msi
• http://localhostr.com/files/zfFyOsz/....1.9-win32.msi
• http://ge.tt/6UPivSK (both x86 & x64 MSIs)

[ImportBot]

Originally Posted by GitSum*:

 

I looked all over the main MySQL site and could not find those drivers! I don't know how you found them , but good job. That site is very hard to navigate.

[ImportBot]

Originally Posted by Singh400*:

 

I looked all over the main MySQL site and could not find those drivers! I don't know how you found them , but good job. That site is very hard to navigate.