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

[ImportBot]

Originally Posted by Panther*:

 

Just a small hint for the people who use any kind of webstats.

There is the row showing the time. The problem is, that this time is not shown correctly. If somebody has played more than 60 hours on your server, it is not shown correctly.

 

How to fix it:

 

Search in the index.php for these lines:

Code:

$hours=($playertime/3600)%60;
$minutes=sprintf("%02d",($playertime/60)%60);

This line should be somewhere around line 680.

 

Replace those lines with:

Code:

$hours=sprintf("%d",($playertime/3600));
$minutes=sprintf("%02d",($playertime/60)%60);

And you will see the complete time player have played on your server.

 

 

Keep up the good job XPKilla.

 

Regards

[ImportBot]

Originally Posted by XpKiller*:

 

I found a bug in the ClanTag column

Wrong ClanTag is entered and

Wrong IP

 

In my Test before there was no such issue

This new maybe this is relate to the new procon update.

[ImportBot]

Originally Posted by EBassie*:

 

It seems country code is also incorrect.

[ImportBot]

Originally Posted by XpKiller*:

 

I have done a mistake found it already and fix it

only 3 columns a effected: ClanTag, IP and CountryCode

Now the data is wrong in this 3 columns

[ImportBot]

Originally Posted by XpKiller*:

 

Updated Version 3.0.0.1 in first Post

 

Sry for this silly mistake.

[ImportBot]

Originally Posted by EBassie*:

 

I have done a mistake found it already and fix it

only 3 columns a effected: ClanTag, IP and CountryCode

Now the data is wrong in this 3 columns

I see it sets these columns for all players the same

[ImportBot]

Originally Posted by XpKiller*:

 

I have done a mistake found it already and fix it

only 3 columns a effected: ClanTag, IP and CountryCode

Now the data is wrong in this 3 columns

I see it sets these columns for all players the same

Is fixed now.

[ImportBot]

Originally Posted by Legate*:

 

Thanks for your work XpKiller.

[ImportBot]

Originally Posted by Panther*:

 

yes - good job!

update to 3.0.0.1 and everything seems fine.

 

Hey guy, just a short hint.

 

STOP APPOLOGIZING FOR CODING ERRORS! YOU ARE THE MAN!

If you make mistakes, it is normal. The community needs to be very happy, having such a guy programming a huge plugin like this.

[ImportBot]

Originally Posted by slekkas*:

 

I was using webstats without a problem but after the update i/m getting this: "Unknown column 'SoldierName' in 'field list'"

 

Any Ideas? :cry:

[ImportBot]

Originally Posted by Panther*:

 

sekkas, one page before you can find the webstats for 3.0.

 

just install them. they are more save and work with 3.0

 

 

here is the link:

download/file.php_id=660*

[ImportBot]

Originally Posted by Stryker412*:

 

Anyone know a free host for a database to do the stats logging?

[ImportBot]

Originally Posted by HelloKitty*:

 

http://freesqldatabase.com

 

or run it on your own with Xampp

[ImportBot]

Originally Posted by haclevan*:

 

Hello!

Since the last procon-update procon crashed after a view minutes ( Problemsignatur 09: System.Data.Odbc.OdbcException)

If I disable your logger procon runs without problems. Could you help me to fix the problem?

Thx

Ha

[ImportBot]

Originally Posted by XpKiller*:

 

Without any complete Errormessage i cant help you.

 

 

ATM i found a bug with top10 weapons fixing it now

[ImportBot]

Originally Posted by RedOne1*:

 

Hi

 

I love this plugin. I tried to update to 3.x with 2.x_to_3.x.sql but i get error.

 

Can somebody give me a step by step guide how to update from 2.6.3 to 3.0.0?

When i update i lose the names and the guides in the stats. I am sure I do something wrong.

 

Thx

 

GrTz Red

[ImportBot]

Originally Posted by XpKiller*:

 

Apply this to your database:

 

Code:

ALTER TABLE `tbl_playerstats` ENGINE = MyISAM ;
CREATE TABLE tbl_playerstats_old SELECT * FROM tbl_playerstats;
ALTER TABLE `tbl_playerstats_old` CHANGE COLUMN `ID` `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT , ADD PRIMARY KEY (`ID`) ;
CREATE TABLE tbl_playerdata SELECT ID AS PlayerID, SoldierName, GUID, CountryCode FROM tbl_playerstats;
ALTER TABLE `tbl_playerdata` ADD COLUMN `ClanTag` VARCHAR(45) NULL DEFAULT NULL  AFTER `PlayerID` , ADD COLUMN `EAGUID` VARCHAR(35) NULL DEFAULT NULL  AFTER `GUID` , ADD COLUMN `IP_Address` VARCHAR(15) NULL DEFAULT NULL  AFTER `EAGUID` , CHANGE COLUMN `PlayerID` `PlayerID` INT(10) UNSIGNED NULL AUTO_INCREMENT  
, ADD PRIMARY KEY (`PlayerID`) 
, ADD INDEX `UNIQUE_SoldierName` (`SoldierName` ASC, `GUID` ASC) ;
CREATE TABLE tbl_weaponstats SELECT * FROM tbl_playerstats;
ALTER TABLE `tbl_weaponstats` DROP COLUMN `LastSeenOnServer` , DROP COLUMN `FirstSeenOnServer` , DROP COLUMN `CountryCode` , DROP COLUMN `playerRounds` , DROP COLUMN `playerHeadshots` , DROP COLUMN `playerPlaytime` , DROP COLUMN `playerScore` , DROP COLUMN `playerSuicide` , DROP COLUMN `playerDeaths` , DROP COLUMN `playerKills` , DROP COLUMN `playerTKs` , DROP COLUMN `GUID` , DROP COLUMN `SoldierName` , CHANGE COLUMN `ID` `WeaponStatsID` INT(10) UNSIGNED NOT NULL  
, ADD PRIMARY KEY (`WeaponStatsID`) ;
DROP TABLE tbl_playerstats;
CREATE TABLE tbl_playerstats SELECT ID AS StatsID, playerScore, playerKills, playerHeadshots, playerDeaths, playerSuicide, playerTKs, playerPlaytime, playerRounds, FirstSeenOnServer, LastSeenOnServer FROM tbl_playerstats_old;
ALTER TABLE `tbl_playerstats` CHANGE COLUMN `StatsID` `StatsID` INT(10) UNSIGNED NOT NULL, CHANGE COLUMN `playerScore` `playerScore` INT(11)  NOT NULL DEFAULT 0
, ADD PRIMARY KEY (`StatsID`) ;
ALTER TABLE `tbl_playerstats_old` 
ADD UNIQUE INDEX `UNIQUE` (`SoldierName` ASC, `GUID` ASC) ;
ALTER TABLE `tbl_playerstats` ADD COLUMN `Killstreak` INT NOT NULL DEFAULT 0  AFTER `LastSeenOnServer` , ADD COLUMN `Deathstreak` INT NOT NULL DEFAULT 0  AFTER `Killstreak` ;
ALTER TABLE `tbl_weaponstats` 
 ADD COLUMN `M16K_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M16_deaths` , 
 ADD COLUMN `M16K_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M16K_kills` , 
 ADD COLUMN `M16K_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M16K_hs` , 
 ADD COLUMN `UMPK_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `UMP_deaths` , 
 ADD COLUMN `UMPK_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `UMPK_kills` , 
 ADD COLUMN `UMPK_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `UMPK_hs` , 
 ADD COLUMN `MG3K_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `MG3_deaths` , 
 ADD COLUMN `MG3K_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `MG3K_kills` , 
 ADD COLUMN `MG3K_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `MG3K_hs` , 
 ADD COLUMN `M95K_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M95_deaths` , 
 ADD COLUMN `M95K_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M95K_kills` , 
 ADD COLUMN `M95K_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M95K_hs` , 
 ADD COLUMN `MP7_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
 ADD COLUMN `MP7_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
 ADD COLUMN `MP7_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
 ADD COLUMN `QLZ8_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
 ADD COLUMN `QLZ8_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
 ADD COLUMN `QLZ8_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `tbl_playerstats` ENGINE = InnoDB ;
ALTER TABLE `tbl_weaponstats` ENGINE = InnoDB ;
ALTER TABLE `tbl_playerdata` ENGINE = InnoDB ;
ALTER TABLE `tbl_playerstats_old` ENGINE = InnoDB ;

The data is now split up into multiply tables.

If you dont got a real SQL Error while apply the script everything is fine.

 

Use this SQL Query to get a full Dataset for a Player:

Code:

SELECT a.* ,b.*, c.*
 FROM tbl_playerdata a
 INNER JOIN tbl_playerstats b ON a.PlayerID = b.StatsID
 INNER JOIN tbl_weaponstats c ON a.PlayerID = c.WeaponstatsID
 WHERE a.SoldierName LIKE "%XpKiller%";

[ImportBot]

Originally Posted by RedOne1*:

 

Code:

ADD COLUMN `MP7_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0 ;

Does ";" dont have to be ","?

 

Keep up the good work and the fast service

 

GrTz Red

 

Edit: No playernames and guides in stats yet:sad:

[ImportBot]

Originally Posted by XpKiller*:

 

Code:

ADD COLUMN `MP7_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0 ;

Does ";" dont have to be ","?

 

Keep up the good work and the fast service

 

GrTz Red

 

Edit: No playernames and guides in stats yet:sad:

Yepp you are right typo mistake fixed it

 

the Scripte creates a a backup of you old table called tbl_playerstats_old

 

*Bump*

 

New Version 3.0.0.2

[ImportBot]

Originally Posted by RedOne1*:

 

I used the simple stats and log script earlier in this topic. But the player names are gone there. What should I do to solve this?

 

GrTz Red

[ImportBot]

Originally Posted by XpKiller*:

 

I used the simple stats and log script earlier in this topic. But the player names are gone there. What should I do to solve this?

 

GrTz Red

Which script do you use?

 

Otherwise you could use this:

download/file.php_id=660*

[ImportBot]

Originally Posted by RedOne1*:

 

I can check,

but how about the stats i have now? They will be there too?

GrTz Red

[ImportBot]

Originally Posted by haclevan*:

 

Without any complete Errormessage i cant help you.

 

 

ATM i found a bug with top10 weapons fixing it now

Sry - thats the only message ( Problemsignatur 09: System.Data.Odbc.OdbcException)

How can I find more details to copy them into the forum?

Could this be a problem because of the new map names etc?

[ImportBot]

Originally Posted by Flyswamper*:

 

I'm not sure how elegantl this could be handled but....

 

 

For those of us that are using the table_suffix option in the plugin.......

 

It creates tables that include the suffix. Then when you run the SQL code to migrate/fix your tables for the version 2.x to version 3.x switch.... It won't do what it is supposed to.

 

You need to edit every instance of the tablename in the SQL code to adjust it to include your custom suffix.

 

 

I am NOT an SQL coder, but I do wonder if it might be possible to rewrite your sql code so that it allows the end user to more automatically handle the tablename suffix issue?

 

 

My situation is this....

 

I am storing data/logs from a couple of different servers into the same database. I've used the suffix for table names. I have used the port# for our hosted-Procon-parent layer as the tablename suffix. So... I end up with tablenames like

 

tbl_playerstats23434

tbl_playerstats23435

 

making the need to edit the SQL code carefully for the switchover fairly important.

[ImportBot]

Originally Posted by EBassie*:

 

I think I found a bug:

For some reason EA_GUID for existing players is never updated.

[ImportBot]

Originally Posted by EBassie*:

 

I found another bug:

Scores are not updating after each round.

Kills / Deaths & rounds are updated, but scores are not

 

Got no error-messages

[ImportBot]

Originally Posted by XpKiller*:

 

I think I found a bug:

For some reason EA_GUID for existing players is never updated.

This was intended so.

 

I will review this score thing

[ImportBot]

Originally Posted by EBassie*:

 

This was intended so.

Is it an option for you to make this possible?

It would be very useful for us.

 

Keep up the good work!

[ImportBot]

Originally Posted by XpKiller*:

 

Will make an Option for it

 

Score is working properly for me cant find a bug there. But i will keep an eye on this.

[ImportBot]

Originally Posted by EBassie*:

 

Thanks for making it an option!

 

Hmm.. that's weird you don't have this problem.

 

New players get a score sometimes, but existing players won't be updated at all.

I've this problem on all 3 servers.

 

This is the tabledesign:

Code:

CREATE TABLE IF NOT EXISTS `tbl_playerstats_bc2rush` (
  `StatsID` int(10) unsigned NOT NULL,
  `playerScore` int(11) NOT NULL DEFAULT '0',
  `playerKills` int(10) unsigned NOT NULL DEFAULT '0',
  `playerHeadshots` int(10) unsigned NOT NULL DEFAULT '0',
  `playerDeaths` int(10) unsigned NOT NULL DEFAULT '0',
  `playerSuicide` int(10) unsigned NOT NULL DEFAULT '0',
  `playerTKs` int(10) unsigned NOT NULL DEFAULT '0',
  `playerPlaytime` int(10) unsigned NOT NULL DEFAULT '0',
  `playerRounds` int(10) unsigned NOT NULL DEFAULT '0',
  `FirstSeenOnServer` datetime DEFAULT NULL,
  `LastSeenOnServer` datetime DEFAULT NULL,
  `Killstreak` int(11) NOT NULL DEFAULT '0',
  `Deathstreak` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`StatsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Has it maybe something to do with the table-suffix?