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

[ImportBot]

Originally Posted by ronin*:

 

@ronin you need to setup at least one DSN with the mysql ODBC Driver on your procon host.

Hi

 

Im not sure how to do that but i did install the 32bit odbc driver and the errors have stoped but im not sure if its working properly yet . Im kind of stumped if it doesnt as im using win2008 server now and ws using 2003 before and there so different on the 2003 server i didnt have to do anything except install the driver.

 

Thanks

[ImportBot]

Originally Posted by diabolik1973*:

 

XpKiller,congratulations for your work, i have installed your procon plugin and your web page statistics and work very well both.

How can i add the crossbow statistics?

Thanks

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller,congratulations for your work, i have installed your procon plugin and your web page statistics and work very well both.

How can i add the crossbow statistics?

Thanks

XpKiller doesn't have a web statistics page made by him. There are several people who have made web statistics pages. You should ask the person who created the web statistics page you are using for support.

 

BTW, I have a web statistics page which does include the Crossbow (I just added the crossbow a few hours ago). See link in my signature.

[ImportBot]

Originally Posted by diabolik1973*:

 

XpKiller doesn't have a web statistics page made by him. There are several people who have made web statistics pages. You should ask the person who created the web statistics page you are using for support.

 

BTW, I have a web statistics page which does include the Crossbow (I just added the crossbow a few hours ago). See link in my signature.

I made a mistake I have seen right now that he has developed only Procon plugin.

Thank you

[ImportBot]

Originally Posted by ArcticWolf*:

 

@ronin you need to setup at least one DSN with the mysql ODBC Driver on your procon host.

We're getting the same errors, despite checking all has been installed and set up properly.

 

Would you mind providing a little more detail on what needs to be done to set this exact feature up plz m8 __?

 

TY.

 

EDIT:- Sok, sorted TY .

[ImportBot]

Originally Posted by XpKiller*:

 

The next release of the that plugin will not need the odbc driver anymore because the coming procon version will contain a nativ .net connector.

[ImportBot]

Originally Posted by diabolik1973*:

 

XpKiller doesn't have a web statistics page made by him. There are several people who have made web statistics pages. You should ask the person who created the web statistics page you are using for support.

 

BTW, I have a web statistics page which does include the Crossbow (I just added the crossbow a few hours ago). See link in my signature.

Hi i have installed your web statistics and work fine.

Hi have a problem, i would like to exclude from the ranking my clan.

We haven't the battlefield clantag becouse it's too short but we are registred on origin with our_clan_name-our_nick.

Mysql side like:

Code:

SELECT 'SoldierName' FROM mydb.tbl_playerdata WHERE SoldierName NOT LIKE '%our_clan_name';

How do I change your code?

I'm not an expert in php code

Thank you.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi i have installed your web statistics and work fine.

Hi have a problem, i would like to exclude from the ranking my clan.

We haven't the battlefield clantag becouse it's too short but we are registred on origin with our_clan_name-our_nick.

Mysql side like:

Code:

SELECT 'SoldierName' FROM mydb.tbl_playerdata WHERE SoldierName NOT LIKE '%our_clan_name';

How do I change your code?

I'm not an expert in php code

Thank you.

You probably shouldn't ask here.

 

Ask here:

www.phogue.net/forumvb/showth...apstats-Logger*

 

EDIT: Here's your reply: myrcon.net/...server-stats-page-for-xpkillers-bf3-chat-guid-stats-and-mapstats-logger#entry23256

[ImportBot]

Originally Posted by EBassie*:

 

Hey XPKiller,

 

Today we shut down our dedicated server, running our webserver & mysql.

We moved our site & database (now MariaDB) to a nice cheap VPS for the time being, awaiting our new dedicated server.

 

But I noticed the CPU load reaches 100% for +/- 2,5 minutes every time the rounds end and stats are updated.

 

Is there any way to fix this behaviour? You have any tips for the best setup?

 

Current VPS specs:

RAM: 512MB

Disk: 25GB

Cpu: X5650 (1 core)

 

Plugin settings (version 1.0.0.9):

Chatlogging: Yes

Instant Chatlogging: Yes

 

Close Connection After each request: No

High Performance mode: No

Failed retry: 4

Minimum secs between ServerInfo Updates: 60

 

Sessions: No

Welcome Message: No

 

It really seems InnoDB and transactions are pretty heavy for this machine. Any way to lighten it up a bit?

[ImportBot]

Originally Posted by XpKiller*:

 

@EBastard

 

The default values for innodb are very bad. That is the reason why you got such a bad result.

 

Could you give so info like the my.cnf and how much ram you are using right now.

[ImportBot]

Originally Posted by EBassie*:

 

@EBastard

 

The default values for innodb are very bad. That is the reason why you got such a bad result.

 

Could you give so info like the my.cnf and how much ram you are using right now.

I know 512MB RAM is not much, but that's all we have at the moment. (as this is a temporary solution)

 

I don't have access to the my.cnf at this time but here some graphics of the RAM & SWAP usage:

 

VPS-RAM.jpg VPS-SWAP.jpg

 

I think I will be able to get access to my.cnf tomorrow.

 

Also I forgot: we switched to MariaDB 5.5.28. So no MySQL.

 

 

 

EDIT: The my.cnf is empty

So if you have some tips to improve performance with our limited setup: shoot

[ImportBot]

Originally Posted by bananaSkill*:

 

Responded via private message

[ImportBot]

Originally Posted by remkot*:

 

Hi,

 

is there a log viewer for the chat messages for my website?

 

Thanks

[ImportBot]

Originally Posted by CaptCourage*:

 

How to set up table_...I am getting this error but it could have something to do with building the table on my sql server. I have been at this for days and any help would be extremely appreciated.....

 

Error in Tablebuilder:

[14:17:44 78] Index #0

[14:17:44 78] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[14:17:44 78] Native: 0

[14:17:44 78] Source:

[14:17:44 78] SQL: IM002

[14:17:44 78] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[14:17:44 79] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

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

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

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

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

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

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

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

 

Thanks in advance

[ImportBot]

Originally Posted by XpKiller*:

 

The odbc driver is not installed properly.

[ImportBot]

Originally Posted by Baile*:

 

Any idea what causes this:

 

 

Index #0

[00:21:53 46] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.21-log]No database selected

[00:21:53 46] Native: 1046

[00:21:53 46] Source: myodbc5.dll

[00:21:53 47] SQL: 3D000

[00:21:53 47] Error: System.IndexOutOfRangeException: Cannot find column 0.

at System.Data.DataColumnCollection.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[ImportBot]

Originally Posted by CaptCourage*:

 

Remkot

 

 

Hi,

 

is there a log viewer for the chat messages for my website?

 

Thanks

Look in your procon folder on your hard drive and open logs folder , open server ip folder and view logs...View them using notepad

[ImportBot]

Originally Posted by XpKiller*:

 

Any idea what causes this:

 

 

Index #0

[00:21:53 46] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.21-log]No database selected

[00:21:53 46] Native: 1046

[00:21:53 46] Source: myodbc5.dll

[00:21:53 47] SQL: 3D000

[00:21:53 47] Error: System.IndexOutOfRangeException: Cannot find column 0.

at System.Data.DataColumnCollection.get_Item(Int32 index)

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

Do you have entered a valid database name?

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

Hi guys,

 

I'm sorry for offtopic but could someone please suggest a web hoster with mysql that would support this plugin?

 

Thanks.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

Hi,

 

I'm getting this error by the end of every round:

 

Code:

[20:27:28 41] Error: Error in Startstreaming: 
[20:27:28 41] Index #0
[20:27:28 41] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.27-cll]Cannot add or update a child row: a foreign key constraint fails (`bf3fairp_01`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)
[20:27:28 41] Native: 1452
[20:27:28 41] Source: myodbc5.dll
[20:27:28 41] SQL: HY000

Could someone please help me to resolve it?

 

Many thanks.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi,

 

I'm getting this error by the end of every round:

 

Code:

[20:27:28 41] Error: Error in Startstreaming: 
[20:27:28 41] Index #0
[20:27:28 41] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.27-cll]Cannot add or update a child row: a foreign key constraint fails (`bf3fairp_01`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)
[20:27:28 41] Native: 1452
[20:27:28 41] Source: myodbc5.dll
[20:27:28 41] SQL: HY000

Could someone please help me to resolve it?

 

Many thanks.

The first post says this:

 

" Its recommend to use the 5.1.9 or 5.1.10 Driver".

 

Is it possible for you to get your ODBC driver version changed?

[ImportBot]

Originally Posted by ronald32*:

 

Hey xp-killer thanks for the great work you did and i am having a issue i am able to connect to the database ans use the stats but when i use the playerstats.php that guy has created its doesn't show the battle stats but when i enter in my server everything works fine with the plugin and here is the link to website: http://mysql.clanservers.com/player_stats.php

Pliz can you help me out what is going wrong i have used localhost,127.0.01,my server ip that is running mysql and none of them have solved the problem and i port forwarded 3306 and i can use another computer and connect to my mysql server with no problem i have also telnet my ip and port works perfect !! I got no idea why its not going!! Any help would be great thank you and btw i am new to this !!

[ImportBot]

Originally Posted by XpKiller*:

 

Hi ronald32

 

This is the right thread for your question:

www.phogue.net/forumvb/showth...apstats-Logger*

 

I have not build the php Pages.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

The first post says this:

 

" Its recommend to use the 5.1.9 or 5.1.10 Driver".

 

Is it possible for you to get your ODBC driver version changed?

Hi, thank you for your response.

 

I'm actually hosting procon layer at prolayer.co.uk (the owner of this site is ronin - member of this forum) and I been told that they have correct driver installed to work with plugin. The plugin itself logs chat, mapstats and playerdata without a problem so I thought it must be somethingng else that not letting plugin to work correctly.

 

Also, plugin lets you to choose the version of the ODBC driver and I've tried both - same error. So, if it caused by incorrect driver installed I would speak to the owner of layer hosting to have a look at it but I need to be sure it's a drivers fault so I don't ask him to restart his server when he has many custumers runing procon at his server

 

Many thanks.

[ImportBot]

Originally Posted by XpKiller*:

 

@BF3-FairPlay

 

did you setup a a tablesuffix in the plugin configuration?

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

@BF3-FairPlay

 

did you setup a a tablesuffix in the plugin configuration?

No, I haven't. Shall I?

 

 

Ok, seems like it really was drivers fault as my layer's hoster restarted the server (probably re-installed driver as well) and it started to work.

 

Thanks for your help.

[ImportBot]

Originally Posted by XpKiller*:

 

No, I haven't. Shall I?

Please not. Its not needed.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

Please not. Its not needed.

I got the same error again Not sure what's going on... I think I need to get hold of ronin (owner of hosting server) to see if he can do something about it...

 

In case of error does your plugin stores all the data until successful connection to sql database or data is being lost due to this type of errors?

 

Cheers

[ImportBot]

Originally Posted by XpKiller*:

 

The plugin tries to write the stats after every round. if it fails the stats for that round are lost.

 

Regarding the error you got:

The error means that there is an entry missing the table tbl_server. This entry should be created/updated every 2 minutes.

 

Do you get any other errors?

 

It could help to drop all tables and let the plugin create the tables again.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

The plugin tries to write the stats after every round. if it fails the stats for that round are lost.

 

Regarding the error you got:

The error means that there is an entry missing the table tbl_server. This entry should be created/updated every 2 minutes.

 

Do you get any other errors?

 

It could help to drop all tables and let the plugin create the tables again.

I did it few times, I mean deleting all tabels and I'm not getting any other errors.

 

Regarding loosing data, would it be possible to get your plugin to try to write data several times to reduce chances of loosing all data for past round?

 

Thanks.