Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by fantasticplayer*:

 

Sorry dont read, wrong thread.

 

Hello again. Ive create a new msql database and ive got this error:

[19:38:41 70] [statslogger]Info: Connection MySqlConn closed

[19:38:41 79] [statslogger]Info: Streamingprocess duration: 0,562 seconds

[19:38:41 79] [statslogger]Error: Error in Startstreaming OuterException: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[19:38:43 18] [statslogger]Error: getUpdateServerID1: System.InvalidOperationException: Nested transactions are not supported.

bei MySql.Data.MySqlClient.ExceptionInterceptor.Throw( Exception exception)

bei MySql.Data.MySqlClient.MySqlConnection.BeginTransa ction(IsolationLevel iso)

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Anyone know what to do?

[ImportBot]

Originally Posted by Hawk*:

 

I don't have option to view the stats from web page currently, is there any way to view or search through the stats/logs somehow without php website? Thank you

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't have option to view the stats from web page currently, is there any way to view or search through the stats/logs somehow without php website? Thank you

You have to open up the database with something. You can do it with a desktop application like heidiSQL. Or with a web application like phpmyadmin.

[ImportBot]

Originally Posted by Hawk*:

 

Hello, i have run into a (potential) problem.

We are currently changing hosting of the database, we have database backed up, but how do we get it to run again?

Because plugin creates the tables automatically, when it creates them, can i jsut replace them with our 90mb database?

Will it work? or all our stats will be gone for good.

 

Thank you!

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello, i have run into a (potential) problem.

We are currently changing hosting of the database, we have database backed up, but how do we get it to run again?

Because plugin creates the tables automatically, when it creates them, can i jsut replace them with our 90mb database?

Will it work? or all our stats will be gone for good.

 

Thank you!

Are you using this old plugin version? Maybe you meant to post in the other newer thread.

myrcon.net/.../stats-webpage-for-xpkillers-stats-logger-plugin

 

 

You have to transfer the database while the plugin is disabled. Do not try to merge the data. Disable the plugin, delete all tables in the new database so that the database is empty, and then import the data into the new database from your backup.

 

After that is done, enable the plugin.

 

Let us know once you have completed this process. If after this has been completed, you still see the new data being stored in a new server ID instead of being stored into the old server ID, there is a way to make it switch back to the old server ID.

[ImportBot]

Originally Posted by Hawk*:

 

Are you using this old plugin version? Maybe you meant to post in the other newer thread.

myrcon.net/.../stats-webpage-for-xpkillers-stats-logger-plugin

 

 

You have to transfer the database while the plugin is disabled. Do not try to merge the data. Disable the plugin, delete all tables in the new database so that the database is empty, and then import the data into the new database from your backup.

 

After that is done, enable the plugin.

 

Let us know once you have completed this process. If after this has been completed, you still see the new data being stored in a new server ID instead of being stored into the old server ID, there is a way to make it switch back to the old server ID.

Yes i am afraid we still use version 3.0.2.2

So do u think we should start new database within the new version of this plugin, or continue with the old version fo the plugin?

When we use new version (plugin), are the tables same or is there any difference in storing stats etc.?

I am leaning to use new version i saw there is some cool features like top players of week etc

 

Thank you very much for your answer by the way!

[ImportBot]

Originally Posted by MRniceGuy*:

 

Edit:

... wrong topic sorry.

[ImportBot]

Originally Posted by Cablekiller*:

 

Hey guys, so im the First Admin of a good known BFBC2 (old gme i know) Clan. We have had 1 Server over the years which was always full (day and night) and it ran really well with the Plugins, but since a half year we have some Lag issue with the hoster and we hostet a 2nd Server, we got a database for free with it and with the help of Hand of Shadow we made this Plugin run there. But we use the 3... version because if i upload the 1...version it just doesnt appear in the Plugin list...why is that like that? Can someone help me?

 

And my second question is, both servers are always good visitet so we want to change the lag server to that provider too, so we would have 2 Servers with ranking systems, but we want to have all players the same score on both servers, i saw there is a "suffix table" but i dont know what i can do with is or what to write in if we have the 2nd server.

 

Thanks everyone for the answeres, i dont want to get on HandoFShadows nerves even longer =)

[ImportBot]

Originally Posted by petraunas*:

 

Glad you all sorted it out here. Cheers!

[ImportBot]

Originally Posted by BalboaCZ*:

 

What is the diff between these two plugins and which should I use?

 

Chat, GUID, Stats and Mapstats Logger[1.0.0.2] and this one?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

ONLY use this plugin for bad company 2. All other games should use the following stat logger:

 

myrcon.net/.../stats-webpage-for-xpkillers-stats-logger-plugin

[ImportBot]

Originally Posted by BalboaCZ*:

 

ONLY use this plugin for bad company 2. All other games should use the following stat logger:

 

myrcon.net/.../stats-webpage-for-xpkillers-stats-logger-plugin

Thanks!

[ImportBot]

Originally Posted by BalboaCZ*:

 

Ok, I have tried using 1.0.0.2, tables built but no data was collect.

 

I switched to 3.0.2.2 and nothing. No tables, no data, nothing. I did set up ODBC and no joy. All I get is:

 

[03:55:54 25] Error in OpenConnection:

[03:55:54 26] Index #0

[03:55:54 26] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[03:55:54 27] Native: 0

[03:55:54 28] Source:

[03:55:54 28] SQL: IM002

 

 

I know this works because I see other servers using it. But I just can't seem to get this going.

 

Any ideas? And remember I am a MySQL noob.

 

BCZ

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok, I have tried using 1.0.0.2, tables built but no data was collect.

 

I switched to 3.0.2.2 and nothing. No tables, no data, nothing. I did set up ODBC and no joy. All I get is:

 

[03:55:54 25] Error in OpenConnection:

[03:55:54 26] Index #0

[03:55:54 26] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[03:55:54 27] Native: 0

[03:55:54 28] Source:

[03:55:54 28] SQL: IM002

 

 

I know this works because I see other servers using it. But I just can't seem to get this going.

 

Any ideas? And remember I am a MySQL noob.

 

BCZ

From earlier in this thread:

myrcon.net/...chat-guid-stats-and-mapstats-logger-0102#entry1192

 

This is my error

 

[21:56:43 66] Start tablebuilder

[21:56:43 67] Error in OpenConnection:

[21:56:43 67] Index #0

[21:56:43 67] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:56:43 67] Native: 0

[21:56:43 67] Source:

[21:56:43 67] SQL: IM002

 

very strange the plugin has been working fine then tonight this error then it crashes procon console

 

database screwed ?

You dont have a Problem with the DB. You have a ODBC Driver issue on the machine on which procon is running. So reinstall the ODBC Driver and double check your connection parameter (user, password,...).

http://dev.mysql.com/downloads/connector/odbc/5.1.html

lol thanks for your help got mine working spoke to our hosts who do our procon they reinstalled the driver now all working

[ImportBot]

Originally Posted by BalboaCZ*:

 

Ok, some progress. After banging my head with the latest ODBC 5.3.x, I loaded 5.1.x and got a new error (without procon crashing).

 

[01:42:54 18] Error in Tablebuilder:

[01:42:54 20] Index #0

[01:42:54 22] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.7.11-log]All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

[01:42:54 23] Native: 1171

[01:42:54 24] Source: myodbc5.dll

[01:42:54 25] SQL: HY000

 

So, yes a "ty_ger07 corrected" version will be needed or I need to rip out everything I have done so far and just start over with an older version of SQL.

 

I'd rather a corrected version. Perhaps you could even fix the need for the 5.1 driver and update it to work with the newer 5.3.x driver?

[ImportBot]

Originally Posted by BalboaCZ*:

 

I do want to express my thanks for your patience and help ty_ger07. I am learning a lot through this exercise.

 

BCZ

[ImportBot]

Originally Posted by ty_ger07*:

 

I will try to take a look at it later today.

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok, some progress. After banging my head with the latest ODBC 5.3.x, I loaded 5.1.x and got a new error (without procon crashing).

 

[01:42:54 18] Error in Tablebuilder:

[01:42:54 20] Index #0

[01:42:54 22] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.7.11-log]All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

[01:42:54 23] Native: 1171

[01:42:54 24] Source: myodbc5.dll

[01:42:54 25] SQL: HY000

 

So, yes a "ty_ger07 corrected" version will be needed or I need to rip out everything I have done so far and just start over with an older version of SQL.

Give this one a try:

https://github.com/tyger07/Unofficia...ive/master.zip

 

Like before, you need to stop the procon service, update the file, clear out your database tables which were created before, and then start the procon service again.

 

Let me know if that fixes the table builder error.

[ImportBot]

Originally Posted by BalboaCZ*:

 

ty_ger07,

 

3 "I am not worthy" coming your way.

 

Not only did it cure the error, data is being collected, even on my non-ranked server. So far, I have tested on the non-ranked server and one ranked (scoring was off so...). No errors, no crashes and data collected!! On the non-ranked server, the "pseudo-scores" are even retrievable.

 

On the ranked (scoring off) server, it collected player data and the welcome msg displayed the fact K/D=0, kills=0, etc. So, it is "aware" of players even when scoring is off.

 

I am enabling your plugin on all my servers for a hard core test for the next few days.

 

Preliminary test score: 98.99%.

 

Thank you,

BCZ

[ImportBot]

Originally Posted by ty_ger07*:

 

All I changed is one query to fix the table builder error. It was a very easy modification.

 

The unranked restriction must not have been added to this older plugin version. XpKiller must have only added that restriction to the newest plugin version. I didn't change anything in regards to that.

 

Regarding modifying this plugin to use a newer version of ODBC, I don't know how to do that. I think the ODBC connector is built into Procon and I think Procon would need to be modified to support a newer version of ODBC.

 

I am glad that it worked.

[ImportBot]

Originally Posted by BalboaCZ*:

 

After nearly a week, data is collecting data nicely on all 9 servers.

 

Now to build web front end so my admins can analyze the data. Any suggestions?

 

Thank you again.

 

BCZ

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Everyone running Stat Logger should run this on their database. It's an updated fix for the blank data bug that stat logger has.

 

Code:

DELIMITER $$
DROP TRIGGER IF EXISTS `Player_Update_BlankDataFix`$$
CREATE TRIGGER `Player_Update_BlankDataFix` BEFORE UPDATE ON `tbl_playerdata`
 FOR EACH ROW BEGIN
    IF (NEW.SoldierName IS NULL OR CHAR_LENGTH(NEW.SoldierName) = 0) 
       AND OLD.SoldierName IS NOT NULL
       AND CHAR_LENGTH(OLD.SoldierName) > 0
        THEN SET NEW.SoldierName = OLD.SoldierName;
    END IF;
    IF (NEW.EAGUID IS NULL OR CHAR_LENGTH(NEW.EAGUID) = 0)
        AND OLD.EAGUID IS NOT NULL 
        AND CHAR_LENGTH(OLD.EAGUID) > 0
        THEN SET NEW.EAGUID = OLD.EAGUID;
    END IF;
    IF (NEW.PBGUID IS NULL OR CHAR_LENGTH(NEW.PBGUID) = 0)
        AND OLD.PBGUID IS NOT NULL 
        AND CHAR_LENGTH(OLD.PBGUID) > 0
        THEN SET NEW.PBGUID = OLD.PBGUID;
    END IF;
    IF (NEW.IP_Address IS NULL OR CHAR_LENGTH(NEW.IP_Address) = 0)
        AND OLD.IP_Address IS NOT NULL 
        AND CHAR_LENGTH(OLD.IP_Address) > 0
        AND OLD.IP_Address <> '127.0.0.1'
        THEN SET NEW.IP_Address = OLD.IP_Address;
    END IF;
    IF CHAR_LENGTH(NEW.ClanTag) = 0
        THEN SET NEW.ClanTag = NULL;
    END IF;
END$$
DELIMITER ;

[ImportBot]

Originally Posted by BalboaCZ*:

 

How do I modify this to do the KDR calculation?

 

SELECT a.* ,b.*, c.*

FROM tbl_playerdatabc2sqdm a

INNER JOIN tbl_playerstatsbc2sqdm b ON a.PlayerID = b.StatsID

INNER JOIN tbl_weaponstatsbc2sqdm c ON a.PlayerID = c.WeaponstatsID

WHERE a.SoldierName LIKE "%%";

[ImportBot]

Originally Posted by BalboaCZ*:

 

ColColonCleaner,

 

Do we copy and paste that into the command line utility or some where else?

 

SQL n00b here.

 

BCZ

[ImportBot]

Originally Posted by ty_ger07*:

 

ColColonCleaner,

 

Do we copy and paste that into the command line utility or some where else?

 

SQL n00b here.

 

BCZ

Use phpMyAdmin to log into your database and then execute it from there. It is easy to do and there are a lot of YouTube videos to explain much better than I can with text.

[ImportBot]

Originally Posted by ty_ger07*:

 

How do I modify this to do the KDR calculation?

 

SELECT a.* ,b.*, c.*

FROM tbl_playerdatabc2sqdm a

INNER JOIN tbl_playerstatsbc2sqdm b ON a.PlayerID = b.StatsID

INNER JOIN tbl_weaponstatsbc2sqdm c ON a.PlayerID = c.WeaponstatsID

WHERE a.SoldierName LIKE "%%";

Here is a thread XpKiller created with a bunch of different queries:

myrcon.net/.../advanced-in-game-admin-and-ban-enforcer-adkats

 

Some may not work since this older plugin version has some tables organized differently.

[ImportBot]

Originally Posted by BalboaCZ*:

 

Here is a thread XpKiller created with a bunch of different queries:

myrcon.net/.../advanced-in-game-admin-and-ban-enforcer-adkats

 

Some may not work since this older plugin version has some tables organized differently.

Took me a couple hours of tweaking but what do you think? Yes, produces the expected output. Figuring out that I only needed data from two tables vs the three in the original was like "Hallelujah!" moment. Understanding the temp table naming assignment was the next. (What "FROM tbl_playerstatsbc2r24 tps" actually meant and how to use it.)

 

SELECT tpd.PlayerID AS PlayerID, tpd.SoldierName AS SoldierName, SUM(tps.playerScore )AS Score, SUM(tps.playerKills) AS Kills, SUM(tps.playerDeaths) AS Deaths, (SUM(tps.playerKills)/SUM(tps.playerDeaths)) AS KDR,

SUM( tps.playerHeadshots) AS Headshots, (SUM(tps.playerHeadshots)/SUM(tps.playerKills) * 100) AS HeadPerc ,SUM(tps.playerSuicide) AS Suicide, SUM(tps.playerTKs) AS TKs, SUM(tps.playerPlaytime) AS Playtime,

( SUM(tps.playerPlaytime) / 3600) AS Hours, (SUM(tps.playerKills)/(SUM( tps.playerPlaytime)/60)) AS KPM ,SUM(tps.playerRounds) AS Rounds, MAX(tps.Killstreak) AS Killstr, MAX(tps.Deathstreak) AS Deathstr

FROM tbl_playerstatsbc2r24 tps

INNER JOIN tbl_playerdatabc2r24 tpd ON tpd.PlayerID = tps.StatsID

GROUP BY PlayerID

HAVING (SUM(tps.playerKills)/SUM(tps.playerDeaths)) >= 3 AND (SUM(tps.playerHeadshots)/SUM(tps.playerKills) )>= 0.4 AND MAX(tps.Killstreak) >= 10

ORDER BY KPM DESC

 

Based off the original below:

 

SELECT tpd.PlayerID AS PlayerID, tpd.SoldierName AS SoldierName, SUM(tps.Score )AS Score, SUM(tps.Kills) AS Kills, SUM(tps.Deaths) AS Deaths, (SUM(tps.Kills)/SUM(tps.Deaths)) AS KDR,

SUM( tps.Headshots) AS Headshots, (SUM(tps.Headshots)/SUM(tps.Kills) * 100) AS HeadPerc ,SUM(tps.Suicide) AS Suicide, SUM(tps.TKs) AS TKs, SUM(tps.Playtime) AS Playtime,

( SUM(tps.Playtime) / 3600) AS Hours, (SUM(tps.Kills)/(SUM( tps.Playtime)/60)) AS KPM ,SUM(tps.Rounds) AS Rounds, MAX(tps.Killstreak) AS Killstr, MAX(tps.Deathstreak) AS Deathstr

FROM tbl_playerstats tps

INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID

INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID

GROUP BY PlayerID

HAVING (SUM(tps.Kills)/SUM(tps.Deaths)) >= 3 AND (SUM(tps.Headshots)/SUM(tps.Kills) )>= 0.4 AND MAX(tps.Killstreak) >= 10

ORDER BY KPM DESC

[ImportBot]

Originally Posted by Gam3R*:

 

I see that it doesnt work on servers with PB disabled. Is there an alternative to use it on non-PB server?