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

[ImportBot]

Originally Posted by BL4CKSH4D0W*:

 

@XpKiller

Honestly its a clean stock install of MySQL just for use with this. I work in IT for a living and have done plenty of MySQL installs, so I feel it was done correctly but anything is possible. I guess I will just try uninstalling and reinstalling unless you have any ideas?

[ImportBot]

Originally Posted by johnny5*:

 

Do these error in stats streaming mean a failure?

 

I get the occasional error, but the stats features seem to still work.

 

I mean occasional, the system seems pretty good. Ocassional means 2 or 3 a week with it running 24/7. Myserver goes nearly 24/7.

[ImportBot]

Originally Posted by XpKiller*:

 

Please post the error message.

[ImportBot]

Originally Posted by khyoshi*:

 

Thanks for a very good plugin!

 

I notice that procon now sees the intended destination of in game chats in bf3, such as ->squad, or ->team us and so on , but all logged chats end up as "global" in the database.

 

It would be awesome if this got "updated" in the comming versions.

 

/Me

[ImportBot]

Originally Posted by Phil_K*:

 

Hi.

 

I notice that procon now sees the intended destination of in game chats in bf3, such as ->squad, or ->team us and so on , but all logged chats end up as "global" in the database.

That's because of a bug in Procon dealing with the new information on raising plugin events. This results in all chat being send to plugins as global chat. It will be fixed with the next Procon version.

 

Greets

Phil.

[ImportBot]

Originally Posted by khyoshi*:

 

Hi.

 

 

 

That's because of a bug in Procon dealing with the new information on raising plugin events. This results in all chat being send to plugins as global chat. It will be fixed with the next Procon version.

 

Greets

Phil.

Thanks!

[ImportBot]

Originally Posted by HefePilz*:

 

[18:51:20 08] Error: Error in Startstreaming:

[18:51:20 08] Index #0

[18:51:20 08] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.6.5-m8-log]Duplicate entry 'EA_785CF37F2A985EA8CEA7334C759EEF5E' for key 'UNIQUE_playerdata'

[18:51:20 08] Native: 1062

[18:51:20 08] Source: myodbc5.dll

[18:51:20 08] SQL: 23000

 

I got this error. Please help me.

[ImportBot]

Originally Posted by XpKiller*:

 

@HefePilz

This error can be ignored except you get this regularly.

[ImportBot]

Originally Posted by HefePilz*:

 

I get this error regularly. Every 5 min. what can i do ?

 

[20:29:23 67] Error: Error in Startstreaming:

[20:29:23 67] Index #0

[20:29:23 67] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.6.5-m8-log]Duplicate entry 'EA_916A1A849B6CEDB1F8E7FF3AC2C62E76' for key 'UNIQUE_playerdata'

[20:29:23 67] Native: 1062

[20:29:23 67] Source: myodbc5.dll

[20:29:23 67] SQL: 23000

[20:44:00 63] Error: Error in Startstreaming:

[20:44:00 63] Index #0

[20:44:00 63] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.6.5-m8-log]Duplicate entry 'EA_4493E1402E1D3B3A05832FDB11355158' for key 'UNIQUE_playerdata'

[20:44:00 63] Native: 1062

[20:44:00 63] Source: myodbc5.dll

[20:44:00 63] SQL: 23000

[ImportBot]

Originally Posted by johnny5*:

 

03:13:01 99] Error: Error in Startstreaming:

[03:13:01 99] Index #0

[03:13:01 99] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.22]Out of range value for column 'Playtime' at row 22

[03:13:02 00] Native: 1264

[03:13:02 00] Source: myodbc5.dll

[03:13:02 00] SQL: HY000

[05:25:46 47] Error: Error in Startstreaming:

[05:25:46 47] Index #0

[05:25:46 54] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.22]Out of range value for column 'Playtime' at row 10

[05:25:46 58] Native: 1264

[05:25:46 65] Source: myodbc5.dll

[05:25:46 69] SQL: HY000

[06:06:45 29] Error: Error in Startstreaming:

[06:06:45 29] Index #0

[06:06:45 30] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.22]Out of range value for column 'Playtime' at row 2

[06:06:45 30] Native: 1264

[06:06:45 30] Source: myodbc5.dll

[06:06:45 30] SQL: HY000

[06:33:09 19] Error: Error in Startstreaming:

[06:33:09 19] Index #0

[06:33:09 19] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.22]Out of range value for column 'Playtime' at row 1

[06:33:09 19] Native: 1264

[06:33:09 19] Source: myodbc5.dll

[06:33:09 19] SQL: HY000

[ImportBot]

Originally Posted by XpKiller*:

 

@HefePilz

First thing might be silly please check if you have two procon instances running with the plugin.

Second you should not use a beta/ development release of the mysql server.

Please try 5.5.24.

 

@johnny5

which version you are using?

please post settings

try to set back the timeoffset to 0 if have changed it.

[ImportBot]

Originally Posted by beantje*:

 

Hey man not sure if this will help. But I can tell you that error means that the plugin cannot connect to the database. I would verify the Host(IP) and the Port you input. If you know they are correct I would then check to make sure the firewall is not blocking the port. Lastly if the database resides on the machine you are using procon on you can use the local host IP of "127.0.0.1" instead of "46.249.40.158" to get around any firewall issues.

mmm, but its now before it was working perfect...

 

how do i check this ?

[ImportBot]

Originally Posted by Jasonpb*:

 

Is there any chance of the stats being updated live as the game goes on? at the moment it seems to only update at the end of each round.

[ImportBot]

Originally Posted by Jaffaman*:

 

Thanks for making a great plugin installed and working ok

[ImportBot]

Originally Posted by Jaffaman*:

 

I have just noticed that for some reason it is not showing the date/time on the messages so it looks like the date/times for all settings I.E sessions/messages/first-last seen are not being sent to the database anyone know why that could be?

 

 

Also in the install instructions it says extract the Bf3.def into the Config directory but there is no bf3.def in the download could this be the problem.

 

 

Thanks in advance for any help.

[ImportBot]

Originally Posted by n0tiert*:

 

Hi all,

 

I have this running via db4free and freemysql but the service is so slow and i always getting "To many Connections" errors of the free mysql providers... so my question would be if there could be a rewrite using WebClient lib

 

using System.Net;

using System.Collections.Specialized;

WebClient client = new WebClient();

NameValueCollection postData = new NameValueCollection();

.....

postData.Add("@pr", this.ServerID);

postData.Add("@pr", this.Mapstats.TimeMaploaded);

......

byte[] responseArray = client.UploadValues("http://somehost.com/myScript.php", "POST", postData);

 

and myScript.php does the inserts/updates.....

 

this would help using non available remote Mysql db on own hosting .....

 

thx

[ImportBot]

Originally Posted by Phil_K*:

 

Hi.

 

this would help using non available remote Mysql db on own hosting .....

Just curious... why not make that mysql db remotely available for the ip your procon is running at?

This can be done directly with mysql or by using a mysql-proxy daemon.

 

Remember also, using a php script as proxy channel may create issues around order of commands and/or buffering of commands. There might also latency caused by the webserver providing php.

 

Greets

Phil.

[ImportBot]

Originally Posted by n0tiert*:

 

Hi.

 

 

 

Just curious... why not make that mysql db remotely available for the ip your procon is running at?

This can be done directly with mysql or by using a mysql-proxy daemon.

 

Remember also, using a php script as proxy channel may create issues around order of commands and/or buffering of commands. There might also latency caused by the webserver providing php.

 

Greets

Phil.

well,

 

Most of the hoster doesn´t allow remote access to the mysql DB, and running procon local on a box @ home could end up with problems adding it´s IP durring dyn IP by ISP (24h disc.) yeeah you could use some service like dynip .... i know, but it would be much easier to use 3rd party addons like

[RMG] Dr4k3 Statspage on own hosting account too........

 

Since reqs and insert seems to be stored in dic first and then be fired.... i don´t really see that much lags what i get now or maybe others too

[ImportBot]

Originally Posted by Helldon*:

 

There are hosters that offer this service included this feature. PM me if you need the name.

[ImportBot]

Originally Posted by XpKiller*:

 

@n0tiert

 

i wont do such a thing because i would need to rewrite nearly everything.

But feel free to try it by yourself. I simply have not the time for it.

 

i still hope for a patch for bf3 that will revert so things back like this suppressing fire shit.

At the current state the game is dead for me atm.

[ImportBot]

Originally Posted by johnny5*:

 

Your plugin works perfect.

 

The game is pretty bad. i agree.

[ImportBot]

Originally Posted by TimSad*:

 

All of my dates such as the chat log dates are being recorded as 0000-00-00 00:00:00 now ever since updating to the 1.0.0.6 version. Anyone else getting this or is it just me? I'm not sure what could have caused this...

[ImportBot]

Originally Posted by Jaffaman*:

 

All of my dates such as the chat log dates are being recorded as 0000-00-00 00:00:00 now ever since updating to the 1.0.0.6 version. Anyone else getting this or is it just me? I'm not sure what could have caused this...

I am getting the same but i never updated from an old version.

 

I see it says MYSQL Version 5.1.x is required and I notice that our host is using version 5.0.91-community-cll not sure if that's the problem for me_?

 

I have asked our host to upgrade and the responce i got was....... I can put you on a MySQL 5.5 server, but the PHP version will be 5.3 -- let me know if that's okay? You'd need to check your scripts are compatible with PHP 5.3. does anyone know if that will fix this issue ?

[ImportBot]

Originally Posted by TimSad*:

 

I don't think it will fix it. I don't think it is your MySQL version that is causing a zeroed out log date. Mine is at version 5.0 and was working correctly before. I think the problem may be in one of XpKiller's recent updates. I may take a good look into his code and try to figure it out myself if he isn't able.

[ImportBot]

Originally Posted by Jaffaman*:

 

Did you have a look at the code? as i did send XpKiller a PM on the forums but it does not look like he has the time to look in to it as i got no reply.

[ImportBot]

Originally Posted by XpKiller*:

 

Yeah im actual short at time atm.

 

i try to find a look weekend.

 

@Jaffaman

Sry that i dont reply i noticed your pm.

 

Something what would help alot would be access to a well visted server because mine are empty sinces weeks.

[ImportBot]

Originally Posted by Jaffaman*:

 

Our server is empty a fair bit but our members like this plugin along with ty_ger07 webstats thanks for taking your time to make the plugin

 

Once we find a fix for the dates being recorded as 0000-00-00 00:00:00 i can then reset the stats

[ImportBot]

Originally Posted by Thados*:

 

can someone give me a quick run through of how i set up MY SQL? cant find a manual or a tutorial

[ImportBot]

Originally Posted by Athlon*:

 

can someone give me a quick run through of how i set up MY SQL? cant find a manual or a tutorial

www.phogue.net/forumvb/showth...-Configuration*

 

[ImportBot]

Originally Posted by Thados*:

 

you the man... thanks