Jump to content

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]


ColColonCleaner

Recommended Posts

Originally Posted by sourtimer*:

 

Fixed my problem by copy pasting the contents of BF4.def to BF3.def file. Seems like the plugin is still calling bf3.def even though it detected that the server is BF4.

Are you completely overwriting the existing contents of BF3.DEF with BF4.DEF's data ? Or are you adding the data from BF4.DEF to BF3.DEF leaving what was already in BF3.DEF alone ?

 

Thanks

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by exadmin*:

 

Are you completely overwriting the existing contents of BF3.DEF with BF4.DEF's data ? Or are you adding the data from BF4.DEF to BF3.DEF leaving what was already in BF3.DEF alone ?

 

Thanks

deleted all the contents of bf3.def and copy pasted the data from the bf4.def and restart your procon after. I'm using the procon client btw, not on a layer.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by sourtimer*:

 

deleted all the contents of bf3.def and copy pasted the data from the bf4.def and restart your procon after. I'm using the procon client btw, not on a layer.

Alrighty thanks. I am doing the same. Running Procon locally with the mySQL database running on the same machine. Just run it all off my fileserver in the basement. Hopefully this fixes it for me.

 

Thanks

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by sourtimer*:

 

Crap. No dice. I still get this error at the end of every round and stats don't seem to be saving or working apart from the tables being created

 

Code:

[07:46:34 76] Error: Error in Startstreaming: 
[07:46:34 77] Message: Data too long for column 'CountryCode' at row 1
[07:46:34 77] Native: -2147467259
[07:46:34 77] Source: MySql.Data
[07:46:34 81] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
[07:47:04 71] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by jaczart*:

 

In MOHW

With new database table creation error 'Data to long for column Fullname'

 

Make a change in CChatGUIDStatsLogger.inc in line 5281 to remove the error

 

//New Weapon table

change

from

`Fullname` varchar(45) DEFAULT NULL,

to

`Fullname` varchar(150) DEFAULT NULL,

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ColColonCleaner*:

 

Crap. No dice. I still get this error at the end of every round and stats don't seem to be saving or working apart from the tables being created

 

Code:

[07:46:34 76] Error: Error in Startstreaming: 
[07:46:34 77] Message: Data too long for column 'CountryCode' at row 1
[07:46:34 77] Native: -2147467259
[07:46:34 77] Source: MySql.Data
[07:46:34 81] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
[07:47:04 71] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
This is from the CountryCode column not being long enough to store a player's country. Country codes are supposed to be 2 chars, but apparently someone has a 3+ char country code. Try this:

 

ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(3) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL;

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by sourtimer*:

 

This is from the CountryCode column not being long enough to store a player's country. Country codes are supposed to be 2 chars, but apparently someone has a 3+ char country code. Try this:

 

ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(3) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL;

Thanks for the help. This is a bit out of my knowledge base though. I am guessing that I need to make this amendment in MySQL, but I am not certain how or where in mySQL I would apply that ? My guess is that I run this command against the database I created somehow, I'm not quite certain how to do that though.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by EBassie*:

 

Hey XP,

 

I was wondering of you could add the option of NOT to use the weapon stats.

I only want to use the round statistics for a simple leaderboard and am not really interested in the weapon stats.

 

Keep up the good work and buy some beers :ohmy:

 

 

PS: I'm also interested in a migration script for my current BF3 stats DB.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ColColonCleaner*:

 

Thanks for the help. This is a bit out of my knowledge base though. I am guessing that I need to make this amendment in MySQL, but I am not certain how or where in mySQL I would apply that ? My guess is that I run this command against the database I created somehow, I'm not quite certain how to do that though.

Just run it at a script/query, there should be a place in your database control panel where you can paste this and run it.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by CptChaos*:

 

Hey XP,

 

I was wondering of you could add the option of NOT to use the weapon stats.

I only want to use the round statistics for a simple leaderboard and am not really interested in the weapon stats.

 

Keep up the good work and buy some beers :ohmy:

 

 

PS: I'm also interested in a migration script for my current BF3 stats DB.

The trackers at gametracker.com have such a feature. I wouldn't install a plugin for it. :smile:
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Mandizzy*:

 

GT is external, this plug-in can show rank within game on your server. BTW, this is exactly what I want, don't care about weapon stats for individual players etc. Just simple player rankings and perhaps time well wasted on my servers ;-)

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

Just an update.

 

I created a new database just to test it out and found out it still it only has 37 weapons mapped. This is the logs.

 

Code:

[10:51:48] PRoCon Chat, GUID and Stats Logger Enabled
[10:51:48] PRoCon Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[10:51:48] Info: Table suffix set to
[10:51:48] Trace: generateWeaponList
[10:51:48] Trace: PrepareKeywordDic: Preparing
[10:51:48] Trace: Weaponlist: DamageType: Suicide Name: DamageArea
[10:51:48] Trace: Weaponlist: DamageType: Suicide Name: SoldierCollision
[10:51:48] Trace: Weaponlist: DamageType: Suicide Name: Suicide
[10:51:48] Trace: Weaponlist: DamageType: None Name: Death
[10:51:48] Trace: Weaponlist: DamageType: None Name: RoadKill
[10:51:48] Trace: Weaponlist: DamageType: Melee Name: Melee
[10:51:48] Trace: Weaponlist: DamageType: Melee Name: U_Repairtool
[10:51:48] Trace: Weaponlist: DamageType: Shotgun Name: U_870
[10:51:48] Trace: Weaponlist: DamageType: Shotgun Name: U_M26Mass
[10:51:48] Trace: Weaponlist: DamageType: Shotgun Name: U_QBS09
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_ACR
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK12
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK5C
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_MX4
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_RFB
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_SCAR-H
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_AK12_M320_HE
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_FIM92
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_M320_HE
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_MGL
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_RPG7
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M26_Buck
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M320_HE
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_Starstreak
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_XM25
[10:51:48] Trace: Weaponlist: DamageType: Explosive Name: U_C4
[10:51:48] Trace: Weaponlist: DamageType: Explosive Name: U_M67
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_CS-LR4
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_M40A5
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_M82A3_MED
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_MK11
[10:51:48] Trace: Weaponlist: DamageType: Handgun Name: U_M9
[10:51:48] Trace: Weaponlist: DamageType: Handgun Name: U_P226
[10:51:48] Trace: Weaponlist: DamageType: SMG Name: U_PP2000
[10:51:48] Trace: Weaponlist: DamageType: Nonlethal Name: U_PortableMedicpack
[10:51:49] Trace: Weaponlist: DamageType: LMG Name: U_Type88
[10:51:49] Trace: Weaponlist: DamageType: LMG Name: U_Ultimax
[10:51:51] Trace: getUpdateServerID
[10:51:52] Info: Start tablebuilder
[10:51:52] Trace: generateWeaponList
[10:51:52] Trace: PrepareKeywordDic: Preparing
[10:51:52] Trace: Weaponlist: DamageType: Suicide Name: DamageArea
[10:51:52] Trace: Weaponlist: DamageType: Suicide Name: SoldierCollision
[10:51:52] Trace: Weaponlist: DamageType: Suicide Name: Suicide
[10:51:52] Trace: Weaponlist: DamageType: None Name: Death
[10:51:52] Trace: Weaponlist: DamageType: None Name: RoadKill
[10:51:52] Trace: Weaponlist: DamageType: Melee Name: Melee
[10:51:52] Trace: Weaponlist: DamageType: Melee Name: U_Repairtool
[10:51:52] Trace: Weaponlist: DamageType: Shotgun Name: U_870
[10:51:52] Trace: Weaponlist: DamageType: Shotgun Name: U_M26Mass
[10:51:52] Trace: Weaponlist: DamageType: Shotgun Name: U_QBS09
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_ACR
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK12
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK5C
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_MX4
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_RFB
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_SCAR-H
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_AK12_M320_HE
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_FIM92
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_M320_HE
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_MGL
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_RPG7
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M26_Buck
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M320_HE
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_Starstreak
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_XM25
[10:51:52] Trace: Weaponlist: DamageType: Explosive Name: U_C4
[10:51:52] Trace: Weaponlist: DamageType: Explosive Name: U_M67
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_CS-LR4
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_M40A5
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_M82A3_MED
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_MK11
[10:51:52] Trace: Weaponlist: DamageType: Handgun Name: U_M9
[10:51:52] Trace: Weaponlist: DamageType: Handgun Name: U_P226
[10:51:52] Trace: Weaponlist: DamageType: SMG Name: U_PP2000
[10:51:52] Trace: Weaponlist: DamageType: Nonlethal Name: U_PortableMedicpack
[10:51:52] Trace: Weaponlist: DamageType: LMG Name: U_Type88
[10:51:52] Trace: Weaponlist: DamageType: LMG Name: U_Ultimax
[10:51:52] Trace: GetGameIDfromDB Game: BF4
[10:51:52] Trace: GetGameIDfromDB GameID: 1
[10:51:52] Trace: WeaponMapping: ID: 1 <--> Weapon:DamageArea
[10:51:52] Trace: WeaponMapping: ID: 4 <--> Weapon:Death
[10:51:52] Trace: WeaponMapping: ID: 6 <--> Weapon:Melee
[10:51:52] Trace: WeaponMapping: ID: 5 <--> Weapon:RoadKill
[10:51:52] Trace: WeaponMapping: ID: 2 <--> Weapon:SoldierCollision
[10:51:52] Trace: WeaponMapping: ID: 3 <--> Weapon:Suicide
[10:51:52] Trace: WeaponMapping: ID: 8 <--> Weapon:U_870
[10:51:52] Trace: WeaponMapping: ID: 11 <--> Weapon:U_ACR
[10:51:52] Trace: WeaponMapping: ID: 12 <--> Weapon:U_AK12
[10:51:52] Trace: WeaponMapping: ID: 17 <--> Weapon:U_AK12_M320_HE
[10:51:52] Trace: WeaponMapping: ID: 13 <--> Weapon:U_AK5C
[10:51:52] Trace: WeaponMapping: ID: 26 <--> Weapon:U_C4
[10:51:52] Trace: WeaponMapping: ID: 28 <--> Weapon:U_CS-LR4
[10:51:52] Trace: WeaponMapping: ID: 18 <--> Weapon:U_FIM92
[10:51:52] Trace: WeaponMapping: ID: 9 <--> Weapon:U_M26Mass
[10:51:52] Trace: WeaponMapping: ID: 19 <--> Weapon:U_M320_HE
[10:51:52] Trace: WeaponMapping: ID: 29 <--> Weapon:U_M40A5
[10:51:52] Trace: WeaponMapping: ID: 27 <--> Weapon:U_M67
[10:51:52] Trace: WeaponMapping: ID: 30 <--> Weapon:U_M82A3_MED
[10:51:52] Trace: WeaponMapping: ID: 32 <--> Weapon:U_M9
[10:51:52] Trace: WeaponMapping: ID: 20 <--> Weapon:U_MGL
[10:51:52] Trace: WeaponMapping: ID: 31 <--> Weapon:U_MK11
[10:51:52] Trace: WeaponMapping: ID: 14 <--> Weapon:U_MX4
[10:51:52] Trace: WeaponMapping: ID: 33 <--> Weapon:U_P226
[10:51:52] Trace: WeaponMapping: ID: 35 <--> Weapon:U_PortableMedicpack
[10:51:52] Trace: WeaponMapping: ID: 34 <--> Weapon:U_PP2000
[10:51:52] Trace: WeaponMapping: ID: 10 <--> Weapon:U_QBS09
[10:51:52] Trace: WeaponMapping: ID: 7 <--> Weapon:U_Repairtool
[10:51:52] Trace: WeaponMapping: ID: 15 <--> Weapon:U_RFB
[10:51:52] Trace: WeaponMapping: ID: 21 <--> Weapon:U_RPG7
[10:51:52] Trace: WeaponMapping: ID: 16 <--> Weapon:U_SCAR-H
[10:51:52] Trace: WeaponMapping: ID: 22 <--> Weapon:U_SCAR-H_M26_Buck
[10:51:52] Trace: WeaponMapping: ID: 23 <--> Weapon:U_SCAR-H_M320_HE
[10:51:52] Trace: WeaponMapping: ID: 24 <--> Weapon:U_Starstreak
[10:51:52] Trace: WeaponMapping: ID: 36 <--> Weapon:U_Type88
[10:51:52] Trace: WeaponMapping: ID: 37 <--> Weapon:U_Ultimax
[10:51:52] Trace: WeaponMapping: ID: 25 <--> Weapon:U_XM25
Your bf4.def file dont contain the all weapons of bf4 yet.

 

Fixed my problem by copy pasting the contents of BF4.def to BF3.def file. Seems like the plugin is still calling bf3.def even though it detected that the server is BF4.

The plugin is not calling the bf3.def file. It call a buildin procon fuction to get all weapons known by procon. Those weapons definitions are saved in those *.def files.

There is absolutly no need to copy stuff from the bf4.def to bf4.def file. I STRONGLY NOT recommend to do this.

 

You will not solve that problem an might get new ones as well. You need an updated bf4.def file.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by tonnic*:

 

Nope, it's definitely set as Yes... again, it has no problem at all on one of my servers, but the other seems to have issues.

Could my issue be because both the old plugin and new plugin are showing in my plugins?

 

PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0

BF3 Chat, GUID, Stats and Map Logger - 1.1.0.1

 

ONLY the "PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0" is enabled.

 

Again to recap my issue. I have 2 servers on my PRoCon layer. One of the servers seems to be working 100%, but the other... not so much... player data saved, but the tbl_playerrank has a whole bunch of 0's in it.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by KennyR*:

 

Could my issue be because both the old plugin and new plugin are showing in my plugins?

 

PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0

BF3 Chat, GUID, Stats and Map Logger - 1.1.0.1

 

ONLY the "PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0" is enabled.

 

Again to recap my issue. I have 2 servers on my PRoCon layer. One of the servers seems to be working 100%, but the other... not so much... player data saved, but the tbl_playerrank has a whole bunch of 0's in it.

I use this plugin to put everything in the database, then i just made a page where i read out all the stuff.

 

Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by tonnic*:

 

I use this plugin to put everything in the database, then i just made a page where i read out all the stuff.

 

Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers.

No I don't and they are actually on different databases too...should I be only using 1 database__?
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by tonnic*:

 

I use this plugin to put everything in the database, then i just made a page where i read out all the stuff.

 

Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers.

Oh so you coded a script for the output yourself?
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by KennyR*:

 

Oh so you coded a script for the output yourself?

Yes i did. When you have everything in a database the rest is easy, if you have knowlegde of basic programming.

 

It's a web page that reads the stats from his database live. Here's mine:

 

http://ecbiz122.inmotionhosting.com/...ayer_stats.php

Nice! Is there a way to get the current ticket count from the server? You can see live player kills, but not live server stats?

 

edit; nevermind, i was blind..will be here later.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by tonnic*:

 

Yes i did. When you have everything in a database the rest is easy, if you have knowlegde of basic programming.

 

 

 

Nice! Is there a way to get the current ticket count from the server? You can see live player kills, but not live server stats?

 

edit; nevermind, i was blind..will be here later.

Ugh I don't want to code a page... was hoping there was a joomla plugin somewhere :smile:.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by sourtimer*:

 

This is from the CountryCode column not being long enough to store a player's country. Country codes are supposed to be 2 chars, but apparently someone has a 3+ char country code. Try this:

 

ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(3) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL;

I just made this change and it still throws this error at the end of every round

 

Code:

[07:46:34 76] Error: Error in Startstreaming: 
[07:46:34 77] Message: Data too long for column 'CountryCode' at row 1
[07:46:34 77] Native: -2147467259
[07:46:34 77] Source: MySql.Data
[07:46:34 81] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
[07:47:04 71] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
Very strange. I've tried recreating the database several times as well. It has no issue populating it with the tables, but starts to stop deploying the stats into the database. I'll try installing this on another machine and see if there is something funky on the PC I've been doing this with that is interfering with it.

 

I guess no one else is getting this error ? :smile:

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Kinsman*:

 

Anyone willing to share their display scripts for the more program challenged? I don't have the skills to update our old ones. Perhaps you could post them in the Plugin Enhancements Forum.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

I just made this change and it still throws this error at the end of every round

 

Code:

[07:46:34 76] Error: Error in Startstreaming: 
[07:46:34 77] Message: Data too long for column 'CountryCode' at row 1
[07:46:34 77] Native: -2147467259
[07:46:34 77] Source: MySql.Data
[07:46:34 81] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
[07:47:04 71] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
Very strange. I've tried recreating the database several times as well. It has no issue populating it with the tables, but starts to stop deploying the stats into the database. I'll try installing this on another machine and see if there is something funky on the PC I've been doing this with that is interfering with it.

 

I guess no one else is getting this error ? :smile:

I running tests right now to debug this issue.

 

In the meantime you could try make the field even larger:

 

ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(10) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL;

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

I use this plugin to put everything in the database, then i just made a page where i read out all the stuff.

 

Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers.

The stats are always separated. The servergroup is only relevant for calculating rankings over multiply servers.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Athlon*:

 

Cool stats... I am running a joomla site that I'd love that stuff in... you developed everything there yourself?

It's heavily modified by me from the original page created by ty_ger07 and posted here:

 

myrcon.net/.../bf4-stats-page-for-bf4-procon-chat-guid-stats-and-mapstats-logger

 

You would need to know php and mysql coding to make it your own.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by KennyR*:

 

Anyone willing to share their display scripts for the more program challenged? I don't have the skills to update our old ones. Perhaps you could post them in the Plugin Enhancements Forum.

I'm still working on my and will make it public later when it is finished.

 

@ Athlon.

 

How can i get the total score from a player? I only seem to see rankscore, but that doesn't give the total score by that player. Im trying to get a top 10.

* Restored post. It could be that the author is no longer active.
Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Our picks

    • Game Server Hosting:

      We're happy to announce that EZRCON will branch out into the game server provider scene. This is a big step for us so please having patience if something doesn't go right in this area. Now, what makes us different compared to other providers? Well, we're going with the idea of having a scaleable server hosting and providing more control in how you set up your server. For example, in Minecraft, you have the ability to control how many CPU cores you wish your server to have access to, how much RAM you want to use, how much disk space you want to use. This type of control can't be offered in a single service package so you're able to configure a custom package the way you want it.

      You can see all the available games here. Currently, we have the following games available.

      Valheim (From $1.50 USD)


      Rust (From $3.20 USD)


      Minecraft (Basic) (From $4.00 USD)


      Call of Duty 4X (From $7.00 USD)


      OpenTTD (From $4.00 USD)


      Squad (From $9.00 USD)


      Insurgency: Sandstorm (From $6.40 USD)


      Changes to US-East:

      Starting in January 2022, we will be moving to a different provider that has better support, better infrastructure, and better connectivity. We've noticed that the connection/routes to this location are not ideal and it's been hard getting support to correct this. Our contract for our two servers ends in March/April respectively. If you currently have servers in this location you will be migrated over to the new provider. We'll have more details when the time comes closer to January. The new location for this change will be based out of Atlanta, GA. If you have any questions/concerns please open a ticket and we'll do our best to answer them.
      • 1 reply
    • Hello All,

      I wanted to give an update to how EZRCON is doing. As of today we have 56 active customers using the services offered. I'm glad its doing so well and it hasn't been 1 year yet. To those that have services with EZRCON, I hope the service is doing well and if not please let us know so that we can improve it where possible. We've done quite a few changes behind the scenes to improve the performance hopefully. 

      We'll be launching a new location for hosting procon layers in either Los Angeles, USA or Chicago, IL. Still being decided on where the placement should be but these two locations are not set in stone yet. We would like to get feedback on where we should have a new location for hosting the Procon Layers, which you can do by replying to this topic. A poll will be created where people can vote on which location they would like to see.

      We're also looking for some suggestions on what else you would like to see for hosting provider options. So please let us know your thoughts on this matter.
      • 4 replies
    • Hi All,

      So seeing as Venice Unleased is released, I'm looking into if I should offer game hosting for it. I would like some feedback on this subject.

      VU - Experience Battlefield 3 like never before! (veniceunleashed.net)
      • 3 replies
    • So as the topic title says, should EZRCON offer general web hosting services?
      • 1 reply
    • Added ability to disable the new API check for player country info


      Updated GeoIP database file


      Removed usage sending stats


      Added EZRCON ad banner



      If you are upgrading then you may need to add these two lines to your existing installation in the file procon.cfg. To enable these options just change False to True.

      procon.private.options.UseGeoIpFileOnly False
      procon.private.options.BlockRssFeedNews False



       
      • 2 replies
×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.