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

ImportBot · February 11, 2012

Originally Posted by GitSum*:

.

in the server details section do i put the webhosting details for the data base the already installed web admin is

ie host - website ip or name

database name : webadmin database name

password : webadmin password

etc ?

thanks in advance

yes

The info that gets entered into this plugin is for the database. IP address where the database is located, username and password are also for the database

ImportBot · February 12, 2012

Originally Posted by gabipaci*:

Hi XpKiller!

Can u make one more things here pls?

I will manage championship in our server, and i would like to see, how many player are registered.

Just logging the player name, who type the !reg (optional) to chat.

Can u do this, please?

Many Thanks

ImportBot · February 12, 2012

Originally Posted by ty_ger07*:

Wouldn't you get a bunch of false registrations? I think it would be better If you made a registration form on your website so you could also get their email address from them so you know how to contact the registered players.

ImportBot · February 12, 2012

Originally Posted by gabipaci*:

No, we have reg form on our website, but i can't filter, how many people give fals solider name.

I want use both reg methold. Website and ingame chat for verify the solider name.

ImportBot · February 12, 2012

Originally Posted by leibhold*:

Why not just query battle stats on the web registration - or query sql datebase on resistration for soldier name ?

ImportBot · February 12, 2012

Originally Posted by 0mni*:

What were the database SQL changes. It does not appear that the database was updated when 1.0.2 was installed, and I do not see any queries to run.

[19:22:18 02] Error: Error in UpdateRanking:

[19:22:18 02] Index #0

[19:22:18 02] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.60-rel13.1-log]'nonamegamers.ts.ServerGroup' isn't in GROUP BY

[19:22:18 02] Native: 1055

[19:22:18 02] Source: myodbc5.dll

[19:22:18 02] SQL: HY000

ImportBot · February 12, 2012

Originally Posted by XpKiller*:

@0mni

Stop and start the plugin.

The tablebuilder will fix the table.

ImportBot · February 12, 2012

Originally Posted by 0mni*:

@0mni

Stop and start the plugin.

The tablebuilder will fix the table.

I have done this several times since I first upgraded to 1.0.2

I thought the error had gone away but it appears to still persist.

ImportBot · February 12, 2012

Originally Posted by terwax*:

So if i say yes to include all servers, it'll start new player count?

Also what's player stats ID, playerdata andplayerstats. i have different number for them.

Which is the one that tells me how many players have visited my server?

ImportBot · February 12, 2012

Originally Posted by JOKEREMPIRE*:

Hi and first of all thank you for this great plugin!

I have one question / request that I would love to see implemented, or at least I'd like to implement it for myself.

Would it be possible to filter chat-messages in Cyrillic / Russian so they don't even get inserted into the database - as we all know RCON does not transfer / support Cyrillic thus the messages in Russian are empty and for example make my chat-logs on the site look rather broken, since well it adds entries, but the content is empty.

Also - is there any way to differentiate between All, Team and Squad chat entries or does RCON not send the data along in which "channel" the message was posted in?

If you decide not to implement this in a global version, would you be so kind as to give me some pointers how I could at least add a filter for this behavior (Russian empty chat msgs) for myself?

Thanks for your time and effort,

JOKER

ImportBot · February 12, 2012

Originally Posted by XpKiller*:

@0mni

I misread you error message. I investigate what causes this it properly has to do with the sql mode the server is running, because you are the first one with this problem.

@terwax

I dont understand the first part of your question.

You can find the Playercount in the table tbl_server_stats

Code:

SELECT ts.ServerID, ts.IP_Address, ts.ServerName, tss.CountPlayers
FROM tbl_server ts
INNER JOIN tbl_server_stats tss ON ts.ServerID = tss.ServerID;

@JOKEREMPIRE

I will add a filter which filter empty chat messages.

"Also - is there any way to differentiate between All, Team and Squad chat entries or does RCON not send the data along in which "channel" the message was posted in? "

- Unfortunately this behaviour is caused by the Rcon Protocol / ProCon.

I cannot fix this.

ImportBot · February 12, 2012

Originally Posted by XpKiller*:

@0mni

Found the problem it will fixed it the next version.

The error only occurs rarely and under so specific settings set.

In the meantime you can fix the broken query.

Search for the Methode: UpdateRanking (around line 5534)

Then search for this code part:

Code:

string sqlupdate3 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankKills, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) x 
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID 
                                                           ORDER BY SUM(tps.Kills) DESC, SUM(tps.Deaths) ASC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID
                                    SET tpr.rankKills = sub.rankKills
                                    WHERE tpr.rankKills != sub.rankKills AND sub.ServerGroup = tpr.ServerGroup";


            string sqlupdate4 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankScore, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID 
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) y
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID 
                                                           ORDER BY SUM(tps.Score) DESC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID AND sub.ServerGroup = tpr.ServerGroup
                                    SET tpr.rankScore = sub.rankScore
                                    WHERE tpr.rankScore != sub.rankScore";

And replace it with this:

Code:

string sqlupdate3 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankKills, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) x 
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID, ts.ServerGroup 
                                                           ORDER BY SUM(tps.Kills) DESC, SUM(tps.Deaths) ASC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID
                                    SET tpr.rankKills = sub.rankKills
                                    WHERE tpr.rankKills != sub.rankKills AND sub.ServerGroup = tpr.ServerGroup";


            string sqlupdate4 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankScore, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID 
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) y
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID, ts.ServerGroup 
                                                           ORDER BY SUM(tps.Score) DESC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID AND sub.ServerGroup = tpr.ServerGroup
                                    SET tpr.rankScore = sub.rankScore
                                    WHERE tpr.rankScore != sub.rankScore";

ImportBot · February 12, 2012

Originally Posted by JOKEREMPIRE*:

@JOKEREMPIRE

I will add a filter which filter empty chat messages.

"Also - is there any way to differentiate between All, Team and Squad chat entries or does RCON not send the data along in which "channel" the message was posted in? "

- Unfortunately this behaviour is caused by the Rcon Protocol / ProCon.

I cannot fix this.

Thanks, much appreciated!

One more idea: maybe an option to filter messages intended for the ingame-admin interface that start with either /@ or /# or /! that are not supposed to be displayed in the chat, but are meant to control the ingame-admin plugin...

ImportBot · February 12, 2012

Originally Posted by ty_ger07*:

One more idea: maybe an option to filter messages intended for the ingame-admin interface that start with either /@ or /# or /! that are not supposed to be displayed in the chat, but are meant to control the ingame-admin plugin...

Umm.... Do you think PRoCon has the ability to make the game stop displaying messages in the chat box? PRoCon reads the events from the game (including chat messages) and reacts to them, not the other way around.

ImportBot · February 12, 2012

Originally Posted by JOKEREMPIRE*:

Umm.... Do you think PRoCon has the ability to make the game stop displaying messages in the chat box? PRoCon reads the events from the game (including chat messages) and reacts to them, not the other way around.

O.o Where did I mention that I want ProCon to stop displaying anything?

I simply don't want these messages getting into my database...

They don't serve any purpose there, do they?

ImportBot · February 12, 2012

Originally Posted by ty_ger07*:

You said that you wanted them to not be displayed in chat and didn't say that you wanted them to not be saved to the database.

ImportBot · February 12, 2012

Originally Posted by JOKEREMPIRE*:

You said that you wanted them to not be displayed in chat and didn't say that you wanted them to not be saved to the database.

Please read in context with my previous message, which was all about filtering chat-messages from getting into the database.

Anyways, you know now what I meant.

ImportBot · February 12, 2012

Originally Posted by Azubiene*:

Can someone please upload the "BF3 Chat, GUID, Stats and Mapstats Logger[1.0.0.1]" ?

I need this version. It whould be very nice if someone could upload it.

ImportBot · February 12, 2012

Originally Posted by CptChaos*:

What's the reason you can't use 1.0.0.2?

I've added it to this post, but I am still curious why you wouldn't want to use the newest version.

CChatGUIDStatsLoggerBF3[1.0.0.1].zip

ImportBot · February 12, 2012

Originally Posted by Azubiene*:

Thank you for uploading 1.0.0.1 .

My request was infront of trouble to get this plugin started.

I was talking to my provider support ngz and they told me to use the next older version of this plugin.

But nothing changed. Still the same problem.

My problem is when i enter the information for login and actived it my ProCon Client crash (client run on a Win7 64x) and this Error come:

Plugin logging started: Sonntag, 12 Februar 2012 19:37:48

[19:38:28] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[19:38:30] Error in Tablebuilder:

[19:38:30] Index #0

[19:38:30] Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben

[19:38:30] Native: 0

[19:38:30] Source:

[19:38:30] SQL: IM002

The support told me that the requested things are running and working for all users they have. They checked it out.

Im really at the end of my know how.

It whould be very nice if someone can tell me how to fix this.

ImportBot · February 12, 2012

Originally Posted by XpKiller*:

@Azubiene

Do you run the plugin on a local installtion of Procon or on a proconlayer at ngz?

Anyway an older Version wont help here.

ImportBot · February 12, 2012

Originally Posted by Azubiene*:

i run this plugin on a NGZ Server side procon layer

ImportBot · February 12, 2012

Originally Posted by XpKiller*:

ngz needs to install and configure the Mysql odbc driver on their PRoCon layer host.

Anyway if need help you could meet me in the german wildcards teamspeak atm

Server-IP: 212.227.20.116:9987

Online: 5 / 50

Passwort: joker

ImportBot · February 13, 2012

Originally Posted by 0mni*:

@0mni

Found the problem it will fixed it the next version.

The error only occurs rarely and under so specific settings set.

In the meantime you can fix the broken query.

Search for the Methode: UpdateRanking (around line 5534)

Then search for this code part:

Code:

string sqlupdate3 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankKills, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) x 
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID 
                                                           ORDER BY SUM(tps.Kills) DESC, SUM(tps.Deaths) ASC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID
                                    SET tpr.rankKills = sub.rankKills
                                    WHERE tpr.rankKills != sub.rankKills AND sub.ServerGroup = tpr.ServerGroup";


            string sqlupdate4 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankScore, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID 
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) y
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID 
                                                           ORDER BY SUM(tps.Score) DESC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID AND sub.ServerGroup = tpr.ServerGroup
                                    SET tpr.rankScore = sub.rankScore
                                    WHERE tpr.rankScore != sub.rankScore";

And replace it with this:

Code:

string sqlupdate3 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankKills, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) x 
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID, ts.ServerGroup 
                                                           ORDER BY SUM(tps.Kills) DESC, SUM(tps.Deaths) ASC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID
                                    SET tpr.rankKills = sub.rankKills
                                    WHERE tpr.rankKills != sub.rankKills AND sub.ServerGroup = tpr.ServerGroup";


            string sqlupdate4 = @"  UPDATE " + this.tbl_playerrank + @" tpr
                                    INNER JOIN (SELECT (@num := @num + 1) AS rankScore, sub1.PlayerID ,sub1.ServerGroup
                                                      FROM(SELECT tsp.PlayerID, ts.ServerGroup
                                                           FROM " + this.tbl_server_player + @" tsp
                                                           INNER JOIN " + this.tbl_server + @" ts ON tsp.ServerID = ts.ServerID 
                                                           INNER JOIN " + this.tbl_playerstats + @" tps  ON  tsp.StatsID = tps.StatsID ,(SELECT @num := 0) y
                                                           WHERE ts.ServerGroup = _
                                                           GROUP BY tsp.PlayerID, ts.ServerGroup 
                                                           ORDER BY SUM(tps.Score) DESC, tsp.PlayerID ASC  
                                                     ) sub1 
                                                ) sub
                                    ON sub.PlayerID = tpr.PlayerID AND sub.ServerGroup = tpr.ServerGroup
                                    SET tpr.rankScore = sub.rankScore
                                    WHERE tpr.rankScore != sub.rankScore";

I'll let you know how it goes

Also noticed two issues. Maybe related to the mysql I am running as well. When players type !rank it says "Your rank 0 of XXX".

Also I thought it was an admin turning off the plugin, it appears as if the stats plugin is shuting down on its own.

ImportBot · February 13, 2012

Originally Posted by Waterboyeee*:

Strange error just showed up today... I recently turned off sandbox mode. Not sure if that was it.

] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 0

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)

ImportBot · February 13, 2012

Originally Posted by XpKiller*:

@0nmi

The ranking issue will be gone after one round. I changed the way how the rank is calculated the new methode is much faster.

I'm aware of this shutdown issue it is caused by an attempt to prevent a procon crash.

It will be removed or fixed in the comming version.

@waterboyeee

Your MySQL server closed the connection unexpectedly. Maybe network problems or server was to busy.

ImportBot · February 14, 2012

Originally Posted by IceCold*:

hi,

your plugin keeps shuting down

since latest update.

Please help

BFE Clan Stats

ImportBot · February 14, 2012

Originally Posted by Large_Pudding*:

Apologies in advance should a similar post have been made. The topic is rather big now and it's rather overwhelming

Is it possible to track [repair tool] kills? This weapon is logged by procon, however I have no idea as to what needs amending. A nudge in the right direction would be greatly appreciated

ImportBot · February 14, 2012

Originally Posted by ty_ger07*:

Repair tool kills are already tracked. I forgot the specific name it is tracked by though.

ImportBot · February 14, 2012

Originally Posted by Large_Pudding*:

O_o cannot find it refernced anywhere in the db ... but then this is a little ovr my head Thanks for your reply, I'll keep tinkering

Sign In

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

Recommended Posts

Link to comment

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Join the conversation

Important Information