Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by Gijzijtdood*:

 

You want a ingame command for people to see who had a reserved slot rewarded last month?

yes, and a command for seeing how good(or how bad) they are doing in the current month.

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller,

 

I have another issue.

Now that i have a working query for the session data i have noticed that the data of the sessions is different then the overall ranking.

 

My logs are started the 1th of this month. So my guess is that the rank score of my first player would be equal with the sum of he's session scores.

This is not the case. The session score is allmost double of his ranking score. It's the same with all other players.

 

Here the query's i use

 

Top 30 stats

 

 

 

result:

 

 

 

sessions query:

 

 

 

result: (first 30 lines)

 

 

 

Am i doing something wrong or is the session data incorrect?

 

Greetings

Maybe I am missing something. What makes you think something is wrong?

 

Edit, didn't see your statement about the stats log start date. Maybe my query is wrong.

[ImportBot]

Originally Posted by TrBoss*:

 

Hi;

 

We installed plugin and it started to work perfectly.But recently we noticed plugin doesn't keep the statistics.We tried to initialize the database ut result was the same.Tables,chatlog,player data ,current player etc. are ok but server stats table doesnt loading.What would be the problem ?

 

 

 

And error code :

 

Code:

Error: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Enumerator.MoveNext()
   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()
[13:13:04 64] Error: System.InvalidOperationException: Transaction has already been rolled back or is not pending
   at MySql.Data.MySqlClient.MySqlTransaction.Rollback()
   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by Gijzijtdood*:

 

I made a pretty simple query that lists all sessions of a player since the start of loggings. And it shows that the sum of the session scores is not equal to the player score.

 

Aren't they supposed to be equal?

 

Greetings

[ImportBot]

Originally Posted by Ralphvd*:

 

Hmm seems like in server #2 weekly results arent displayed ingame. Header is displayed, but no stats. Same for player of the day. Is broken too.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Hey all,

 

I made used two queries for making a top 10.

One just to list the top10 players with highest rankscore

One that makes sum of all sessions.

The results are completely different. The server logs started on the 1th of January.

Am I doing something wrong?

 

ScreenShot001.pngScreenShot003.png

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Now i'm sure it's not me

I played one session and compared the scoreboard with the session data.

 

here the results: Scoreboard Kills:9 Deaths:18 score:2840 (I know, its not a great score :-))

Session data Kills:9 Deaths:17 score:4630 (would be a better score but its not right)

 

Something goes wrong with the session data.

 

Greetings

[ImportBot]

Originally Posted by ty_ger07*:

 

I think only XpKiller can help you whenever he chooses to come around and look.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

I think only XpKiller can help you whenever he chooses to come around and look.

I hope he's free this weekend

 

cheers

[ImportBot]

Originally Posted by Borzywit*:

 

Hi there

any idea what may couse belowed error?

[statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 109.234.111.65:3306

SOLVED.

 

Procon was blocked by my DB provider. Normally I was getting "access denied for [email protected]". This is what confused me.

[ImportBot]

Originally Posted by IBA_DR_DEATH*:

 

can you run this plugin from a home network, i run a procon on a home network pc 24/7. or does it need to be setup through a third party layer. provider is telling maybe thats the reason it doesn't connect.

 

heres the error I've getting been going at this for a month now cant figure it out. any help would be appreciated

 

[09:16:06 39] Error in Tablebuilder:

[09:16:06 39] Message: Unable to connect to any of the specified MySQL hosts.

[09:16:06 40] Native: -2147467259

[09:16:06 40] Source: MySql.Data

[09:16:06 41] StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

at MySql.Data.MySqlClient.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[09:16:06 41] InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 66.225.231.66:3306

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

at MySql.Data.MySqlClient.NativeDriver.Open()

[09:16:06 42] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by ty_ger07*:

 

can you run this plugin from a home network, i run a procon on a home network pc 24/7. or does it need to be setup through a third party layer. provider is telling maybe thats the reason it doesn't connect.

 

heres the error I've getting been going at this for a month now cant figure it out. any help would be appreciated

I am confused.

 

First, you say you are running it from home on your own PC 24/7. Then you say your provider is telling you that may be the reason...

 

Aren't you your own provider? Who is your provider and what are they providing? If they are providing you a database, why not just use your own database at your home from the same PC which is running 24/7?

 

For performance reasons, you want the database to be as close to the machine running this plugin as possible. If the database is running from the same machine which is running this plugin, great. The further the database is from this machine (in terms of network location, number of nodes in between, and latency), the more laggy this plugin will seem and the more likely you will see this plugin generate errors.

 

XAMPP makes it incredibly easy to set up a server on your own computer.

 

http://www.apachefriends.org/index.html

 

The following video is from a PHP tutorial series, but this particular video is regarding installing XAMPP and using phpmyadmin to administrate your database on your PC.

 

http://thenewboston.org/watch.php_cat=11&number=3

[ImportBot]

Originally Posted by IBA_DR_DEATH*:

 

maybe im having a brain fart. yes im running procon from home,all plugins working fine except chat logger. when you put your info in Server details (host,port,data base,user name,pw) we are talking about SQl? which i put all info in but it wont connect so i asked my provider (web host) to see if i had my info correct.

[ImportBot]

Originally Posted by ty_ger07*:

 

maybe im having a brain fart. yes im running procon from home,all plugins working fine except chat logger. when you put your info in Server details (host,port,data base,user name,pw) we are talking about SQl? which i put all info in but it wont connect so i asked my provider (web host) to see if i had my info correct.

Is there a reason why you would like your database to be running on the remote web server host instead of your own computer? As I said, you could create a database on your own computer and use that for this plugin which would be much better for performance reasons.

 

Reasons to run database on your own computer:

1) Better plugin performance, reduced plugin lag, reduced plugin errors

2) No reliance on 3rd party web server and possible cost reductions

 

Reasons to run database on web server:

1) Easier to display database contents on the web if you would like to also use web statistics for online users to see stats in other places instead of just inside your game server

2) More secure to have database hosted somewhere other than your computer if you are using the database to provide data to online users (online web stats would be connecting to your computer if your computer was used as database host)

 

 

If you decide that you do want the database to be running on a 3rd party web server, perform these actions:

1) Make sure your web server provider's network address is added to your PRoCon's trusted host list. You will also need to make sure PRoCon plugin sandbox is disabled (and close and re-open PRoCon after doing this).

2) (this step may be optional depending on if your web server provider requires specific client addresses connecting to their database to be whitelisted or if they allow all anonymous external traffic to connect to their database as long as such traffic has the correct username, database name, address name, and password) Provide your computer's network address to your web host so that they can add your address as a safe client to connect to their database. This step of course assumes that you have a fixed IP address, your ISP has approved you to use your internet connection in this way, and your home's network is set up to allow this necessary network traffic between your computer and your web service host.

[ImportBot]

Originally Posted by IBA_DR_DEATH*:

 

thanks ty_ger07,

 

you have been a lot of help and i have XAMPP up and running stats work like a charm now. should of done this from the start

 

Reasons to run database on your own computer:

1) Better plugin performance, reduced plugin lag, reduced plugin errors

2) No reliance on 3rd party web server and possible cost reductions

[ImportBot]

Originally Posted by ty_ger07*:

 

thanks ty_ger07,

 

you have been a lot of help and i have XAMPP up and running stats work like a charm now. should of done this from the start

I am glad you were able to understand what I said and that you got it working.

[ImportBot]

Originally Posted by Light555*:

 

__________.png

how to do this?

[ImportBot]

Originally Posted by kcuestag*:

 

That's the !yell command.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

That's the !yell command.

Did they activate the yell command in BF4__

[ImportBot]

Originally Posted by ty_ger07*:

 

That's the !yell command.

It looks like it could be a zoomed in view of a single chat box message to me.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

nope, it's activated

[ImportBot]

Originally Posted by _CH_KeyserSoze*:

 

In the next version would you consider adding an Auto-Enable/Keep Alive setting like Adkats has? Thanks!

[ImportBot]

Originally Posted by staazvaind*:

 

any plans on auto-prune settings ?

 

in 2 month our db got already over 32000 unique players and got really

slow. i already had to disable the chatlog and delete the entries to make

it at least work somehow.

 

something like:

lastseen = 1month -> erase player+stats

[ImportBot]

Originally Posted by Dreddy*:

 

Hi everybody

 

I just installed this plugin for my BC2 server and maybe I'm missing someting but I can't record playerstats, except tbl_chatlog, tbl-games, tbl_currentplayers and tbl_server. I checked the previous advise on the forum for this plugin, but can't find any clue :/

 

here are my settings :

enable chatlogging : yes

log serverspam : no

instant logging of chat messages : no

enable chat log filter : no

map stats on : yes

Enable statslogging : yes

enable weaponstats : yes

ranking by score : yes

enable ingame commands : yes

overall ranking : no

server group : 0

send stats to all players : yes

kdr correction : yes

enable livescore in DB : yes

log player data only : no

table suffix : empty

 

thanks for your help

Dreddy

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi everybody

 

I just installed this plugin for my BC2 server and maybe I'm missing someting but I can't record playerstats, except tbl_chatlog, tbl-games, tbl_currentplayers and tbl_server. I checked the previous advise on the forum for this plugin, but can't find any clue :/

 

here are my settings :

enable chatlogging : yes

log serverspam : no

instant logging of chat messages : no

enable chat log filter : no

map stats on : yes

Enable statslogging : yes

enable weaponstats : yes

ranking by score : yes

enable ingame commands : yes

overall ranking : no

server group : 0

send stats to all players : yes

kdr correction : yes

enable livescore in DB : yes

log player data only : no

table suffix : empty

 

thanks for your help

Dreddy

Have you tried disabling and re-enabling the plugin or tried restarting the layer server. Sometimes settings changes don't work until the plugin is restarted.

[ImportBot]

Originally Posted by Dreddy*:

 

yes, I already tried on/off (no layer restart because ProCon is running on my own PC), restart ProCon, and it doens'nt change anything. It acts like if "log player data only" was set to : "yes" :/

[ImportBot]

Originally Posted by Indigo82*:

 

I got ingame the Message:

 

No Stats are available yet! Please wait one Round! On the Webpage it works but only the Liveview if i search for a Player he says:

 

No unique player data found for "Indigo1982" in this server.

 

Can someone help me?

[ImportBot]

Originally Posted by Prophet731*:

 

any plans on auto-prune settings ?

 

in 2 month our db got already over 32000 unique players and got really

slow. i already had to disable the chatlog and delete the entries to make

it at least work somehow.

 

something like:

lastseen = 1month -> erase player+stats

If your database got slow then something isn't configured correctly. Our database is over 3.2 GB big and we don't have really any performance problems. We also have over 1 million unique players across battlefield 3 and battlefield 4. Chatlog alone is over 10 million entries and that includes the server spam.

 

15015c7b260bcc9aba092be1d719c7b1.png

[ImportBot]

Originally Posted by XpKiller*:

 

XpKiller,

 

I have another issue.

Now that i have a working query for the session data i have noticed that the data of the sessions is different then the overall ranking.

 

My logs are started the 1th of this month. So my guess is that the rank score of my first player would be equal with the sum of he's session scores.

This is not the case. The session score is allmost double of his ranking score. It's the same with all other players.

 

Here the query's i use

 

Top 30 stats

 

 

 

result:

 

 

 

sessions query:

 

 

 

result: (first 30 lines)

 

 

 

Am i doing something wrong or is the session data incorrect?

 

Greetings

Hi,

 

looks like a bug.

sorry for the late response. I'm a bit short with time the last months

[ImportBot]

Originally Posted by God_Zilla*:

 

13lackHawk

If possible, please show screenshot of your plugin settings in Procon.

We have the exact same problem like Indigo82.

Information is written to the database only partially.