Jump to content

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

ImportBot

By ImportBot
in Plugins

Recommended Posts

ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by lothop*:

 

  Cire* said:

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.

* Restored post. It could be that the author is no longer active.
Link to comment
  • Replies 1.9k
  • Created
  • Last Reply

Top Posters In This Topic

  • ImportBot

    1934

Popular Days

Top Posters In This Topic

Popular Days

ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

  Quote

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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Athlon*:

 

  Cire* said:

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......

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by lothop*:

 

  XpKiller* said:

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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ronin*:

 

  XpKiller* said:

@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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Capt-O*:

 

  XpKiller* said:

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

 

  Quote

[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?
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by GitSum*:

 

  Cornholio* said:

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

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Singh400*:

 

  GitSum* said:

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

:ohmy:
* Restored post. It could be that the author is no longer active.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing


×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.