Jump to content

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

ColColonCleaner

By ColColonCleaner
in Plugins

Recommended Posts

ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
  • Replies 2k
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

ColColonCleaner
ColColonCleaner

Description: This plugin is used to log player chat, player GUID's, player Stats, Weaponstats and Mapstats. This includes: Chat, PBGUID, EAGUID, IP, Stats, Weaponstats, Dogtags, Killstreaks, Country,

Hedius
Hedius

This should not happen. Wait for at least one round. If this does not help: Stop PRoCon Delete the config at Configs/IP/StatsLogger..... cfg Start PRoCon Do not modify any

Hedius
Hedius

Check the value of this field. Set it to 0. Does this help? Do you use AdKats? Not sure if AdKats updates the offset, but AdKats has an option to adjust the logger settings.

Posted Images

ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment
ImportBot Advanced Member

ImportBot

Posted
Posted

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 comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing


  • Our picks

    • EZRCON Update (9/4/2021)

      Prophet731 posted a topic in News,

      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.
      • 5 replies
      Prophet731

      Picked By

      Prophet731,

    • EZRCON Update 5/13/2021

      Prophet731 posted a topic in News,

      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
      Prophet731

      Picked By

      Prophet731,

    • Procon Version 1.5.3.5 Released

      Prophet731 posted a topic in News,

      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
      Prophet731

      Picked By

      Prophet731,

    • Procon, Database & BFACP Hosting

      Prophet731 posted a topic in News,

      I wanted I let you know that I am starting to build out the foundation for the hosting services that I talked about here. The pricing model I was originally going for wasn't going to be suitable for how I want to build it. So instead I decided to offer each service as it's own product instead of a package deal. In the future, hopefully, I will be able to do this and offer discounts to those that choose it.

      Here is how the pricing is laid out for each service as well as information about each. This is as of 7/12/2020.

      Single MySQL database (up to 30 GB) is $10 USD per month.



      If you go over the 30 GB usage for the database then each additional gigabyte is charged at $0.10 USD each billing cycle. If you're under 30GB you don't need to worry about this.


      Databases are replicated across 3 zones (regions) for redundancy. One (1) on the east coast of the USA, One (1) in Frankfurt, and One (1) in Singapore. Depending on the demand, this would grow to more regions.


      Databases will also be backed up daily and retained for 7 days.




      Procon Layer will be $2 USD per month.


      Each layer will only allow one (1) game server connection. The reason behind this is for performance.


      Each layer will also come with all available plugins installed by default. This is to help facilitate faster deployments and get you up and running quickly.


      Each layer will automatically restart if Procon crashes. 


      Each layer will also automatically restart daily at midnight to make sure it stays in tip-top shape.


      Custom plugins can be installed by submitting a support ticket.




      Battlefield Admin Control Panel (BFACP) will be $5 USD per month


      As I am still working on building version 3 of the software, I will be installing the last version I did. Once I complete version 3 it will automatically be upgraded for you.





      All these services will be managed by me so you don't have to worry about the technical side of things to get up and going.

      If you would like to see how much it would cost for the services, I made a calculator that you can use. It can be found here https://ezrcon.com/calculator.html

       
      • 11 replies
      Prophet731

      Picked By

      Prophet731,

    • Procon Version 1.5.3.4 Released

      Prophet731 posted a topic in News,

      I have pushed out a new minor release which updates the geodata pull (flags in the playerlisting). This should be way more accurate now. As always, please let me know if any problems show up.

       
      • 9 replies
      Prophet731

      Picked By

      Prophet731,
    View All
×
×
  • 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.