Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by nelmaster_vc*:

 

I trying this stast but the tablet tbl_playerstats is empty , just work Live scored and leader of the week nothing more.

What can be this ? I using the lasted plugin.

 

Any help please ?

[ImportBot]

Originally Posted by ty_ger07*:

 

And the game is what? BF:BC2? Yeah, this plugin seems to be broken in that game. Some other game? Give us some details.

[ImportBot]

Originally Posted by nelmaster_vc*:

 

On BF4 server lan offline

Here a video

[ImportBot]

Originally Posted by ColColonCleaner*:

 

On BF4 server lan offline

Here a video

Do not mention illegal servers on this forum. Battlelog is still online and usable.

[ImportBot]

Originally Posted by nelmaster_vc*:

 

Sorry friend the problems is that server if over lan offline of internet, here in Cuba dont have internet full the time, and want to implement the stats for the people that play in this lan.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Sorry friend the problems is that server if over lan offline of internet, here in Cuba dont have internet full the time, and want to implement the stats for the people that play in this lan.

Unfortunately this isn't designed to work that way. Any usage of the servers that isn't officially supported by DICE isn't supported on these forums either.

[ImportBot]

Originally Posted by DoggGodd*:

 

Anyone know why I'm getting this exception?

 

[16:38:11 13] [statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[16:38:26 80] [statslogger]Error: SQLQuery:

[16:38:26 82] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank

FROM tbl_playerrank tpr

' at line 1

[16:38:26 82] Native: -2147467259

[16:38:26 82] Source: MySql.Data

[16:38:26 82] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& 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.ExecuteDbDataR eader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[ImportBot]

Originally Posted by skepmeister*:

 

Hi,

Having problems getting additional weapon names to work.

for example the real name for the groza is groza-1. I would like to use the name groza as well.

They are a few weapons with funny names but I cant get the any of the new names I use in the keywordlist to work.

for Groza-1 I have,

GROZA-1{GROZA}

[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, ClanTag to be continued.. ;-)
Please post errors if get some.
You can adjust the debug level to a lower value to get less Console Spam. High -> Low (Trace, Info, Warning, Error).
Error only will show critical errors.
Feel free to post feedback and suggestions.

Requirements:
The plugin Sandbox needs to be disabled!!! if you are not using PRoCon 1.4.1.2 or later
Access to a MySQL database that accepts remote connections is required so you need to create a user and database if not exists.
It requires the use of a MySQL database with INNODB engine that allows remote connections.(MYSQL Version 5.1 or greater is required!!!)
No ODBC Driver is needed!!!.

Pleases also read the changelog

Installation:
Extract the content of Zipfile into plugin directory.
Set DB Server Settings and the Plugin Settings
Add the machine running the plugin to the remote mysql access host list.
Will throw a permissions error if not done
Enter the correct details for your database connection in the plugin settings tab. You don't need to create tables, the plugin will do that.
The Standard MySQL Port is 3306.

Supported Games:

• Battlefield 4
• Battlefield 3
• Battlefield Bad Comany 2 + Vietnam
• MOH
• MOHW

Whats new:

• New Databasedesign only one Set of tables needed for multiply gameserver even with different games. Stats are not mixed up!!
• The new Databasedesign allows easy deletion of playerentries.
• Some Code improvements.
• one table for all Weaponstats
• You can create Servergroups

Working:

• Guidlogging
• Statslogging
• Chatlogging
• Weaponstatslogging
• Autotable creation
• Ingame commands
• Welcomestats
• Ingame commands for Dogtags
• merged stats from all Server

May Working:

• Ingame Weaponstats

Not Working:

• ClanTag coz the server don't deliver it to PRoCon thx EA/DICE!!!.
• Stats for tanks and other vehicles. thx EA/DICE!!!.

ToDo's:
Ticketcount for ServerLiveView
Join/Leave History Bugfixes(always :-))
Code improvements

Issues/Requests:
--

Fixed or Implemented:

• Deprecated Trace messages:
• Missing columns for AdKats
• tbl_playerdata: column GameID has no default value
• Feature request: Error prefix
• Duplicate Weapon entry
• Feature request: Simple Stats
• CountryCode too long for column
• Weaponname too long for Fullname column
• Feature Request: Option to disabled weaponstats

Current Version:
Stable: 1.0.0.3

Changelog:

Code:

1.0.0.3
Many thanks to Tyger.
Line 462 through 545: Added additional weapon keywords.
Line 4367: Fixed error in query which caused !top10 weapons query to fail.
Line 5489: Fixed null primary key problem which caused incompatibility with MySQL version 5.7.3 m13 and up.

1.0.0.2
Bugfixes for column errors.
Bugfixes for the sessions streaming bug
Weaponstats working again.
Bugfix for Identifier name is too long.

1.0.0.1
Bugfixes for value too long for column errors.
Bugfixes for some other bugs
Changed deprecated Tracemessages
Added an error prefix in pluginlog
New feature: Tickets/teamscores are now tracked in tbl_teamscores
New feature: Simple Stats (collects playerdata only)
New feature: Switch for disabling weaponstats

1.0.0.0
First Release

 

extended Keywordlist(BF3):

870MCS{870,870MCS}
AEK-971{AEK,AEK971,AEK-971}
AKS-74u{AKSU,AKS-74,AKSU-74,AKS-74U}
AN-94 Abakan{ABAKAN,AN94,AN-94}
AS Val{ASVAL,AS-VAL,AS VAL}
DAO-12{DAO12,DAO,DAO-12}
death{DEATH}
Defib{DEFIBRILLATOR,DEFIB,PADDLE,PADDLES}
F2000{F2000}
FAMAS{FAMAS}
FGM-148{JAVELIN,FGM148,FGM-148}
FIM92{STINGER,FIM92,FIM-92}
Glock18{GLOCK,GLOCK18,GLOCK-18}
HK53{HK53,HK-53,G53,G-53,HK-G53}
jackhammer{JACKHAMMER,MK3A1,MK3}
JNG90{JNG-90,JNG90,JNG}
L96{L-96,L96}
LSAT{LSAT}
M416{M-416,M416}
M417{M-417,M417}
M1014{M-1014,1014,M1014}
M15 AT Mine{M15,M15 MINE,AT MINE,ATMINE,ATM,M15-ATM}
M16A4{M-16,M16,M16A3,M16-A3,M16A4,M16-A4}
M1911{1911,M1911}
M240{M-240,M240}
M249{M-249,M249,SAW}
M26Mass{M26,M-26,MASS,M26MASS}
M27IAR{M27,M-27,M27IAR}
M320{M-320,GRENADE LAUNCHER,M320}
M39{M-39,M39}
M40A5{M40,M-40,M40A5}
M4A1{M4,M-4,M4A1}
M60{M-60,M60}
M67{HANDGRENADE,GRENADE,M67,M-67}
M9{M-9,M9}
M93R{M93,M93R}
Medkit{MEDKIT}
MG36{MG-36,MG36}
Mk11{MK-11,MK11}
Model98B{M98,M98B,MODEL98,MODEL-98,MODEL98B,MODEL-98B}
MP7{MP-7,MP7}
Pecheneg{PKP-PECHENEG,PKP,PECHENEG}
PP-19{PP19,PP-19}
PP-2000{PP2000,PP-2000}
QBB-95{QBB,QBB95,QBB-95}
QBU-88{QBU,QBU88,QBU-88}
QBZ-95{QBZ,QBZ95,QBZ-95}
Repair Tool{REPAIRTOOL,TOOL,TORCH,BLOWTORCH}
RoadKill{ROADKILL}
RPG-7{RPG,RPG7,RPG7V2,RPG-7V2}
RPK-74M{RPK,RPK74,RPK-74,RPK74M,RPK-74M}
SCAR-L{SCARL,SCAR-L}
SG 553 LB{SG553,SG-553,SG-553LB}
Siaga20k{SAIGA,SAIGA20K,SIAGA,SIAGA20K}
SKS{SKS}
SMAW{SMAW}
SPAS-12{SPAS12,SPAS,SPAS-12}
Suicide{SUICIDE}
SV98{SV-98,SV98}
SVD{SVD,DRAGUNOV}
Steyr AUG{STEYR,AUGA3,AUG-A3,AUG}
Taurus .44{TAURUS,.44MAGNUM,TAURUS.44,MAGNUM,.44}
Type88{TYPE88,TYPE-88}
USAS-12{USAS,USAS12,USAS-12}
Weapons/A91/A91{A91,A-91}
Weapons/AK74M/AK74{AK74,AK-74,AKM,AK-74M,AK74M}
Weapons/G36C/G36C{G36,G36C,G-36,G-36C}
Weapons/G3A3/G3A3{G3,G-3,G3A3,G3-A3}
Weapons/Gadgets/C4/C4{C4,C-4}
Weapons/Gadgets/Claymore/Claymore{CLAYMORE,LANDMINE,APMINE,AP-MINE,APM,M18,M-18,M18-CLAYMORE}
Weapons/KH2002/KH2002{KH2002,KH-2002}
Weapons/Knife/Knife{KNIFE,MELEE}
Weapons/MagpulPDR/MagpulPDR{PDW-R,PDWR,PDR,PDW}
Weapons/MP412Rex/MP412REX{MP412REX,REX,MP-412,MP412}
Weapons/MP443/MP443{MP-443,MP443,GRACH}
Weapons/P90/P90{P-90,P90}
Weapons/Sa18IGLA/Sa18IGLA{SA18,SA-18,IGLA,SA18IGLA,SA18-IGLA,SA-18IGLA}
Weapons/SCAR-H/SCAR-H{SCARH,SCAR-H}
Weapons/UMP45/UMP45{UMP45,UMP-45,UMP}
Weapons/XP1_L85A2/L85A2{L85,L85A2,L-85,L-85A2,L85-A2}
Weapons/XP2_ACR/ACR{ACWR,ACW-R,ACR,AC-R}
Weapons/XP2_L86/L86{L86,L86A2,L-86,L-86A2,L86-A2}
Weapons/XP2_MP5K/MP5K{MP5,MP5K,M5K,MP-5,MP-5K,M5-K}
Weapons/XP2_MTAR/MTAR{MTAR,MTAR21,MTAR-21}

 

 

 

DOWNLOAD
Chat, GUID, Stats and Mapstats Logger

[XaosBr]

How to reset players' points every month?

[Prophet731]

How to reset players' points every month?

 

What do you mean by points?

[XaosBr]

What do you mean by points?

 

 

I want to reset stats for all players at the beginning of each month.

[Stov3top]

I want to reset stats for all players at the beginning of each month.

Only thing I can think of would be to edit your sql in some way, there could be a way other than that, but I don't know personally.

[icecold]

hi,

 

i have added a second server to stats logger , but it does not seem to be logging stats ?

Edited September 28, 2019 by icecold

[maxdralle]

you have to play a full round. form the first minute till the last minute of the round. do not skip/end the round with admin cmd. also is good to use ranked mode and min 4players. then in the next round your stats are there.

[icecold]

server full, 5 round played.

still no stats , also noticed in database for ServerID 2 in  tbl_currentplayers   ' PB_GUID    IP_aton    CountryCode   ' these 3 are empty ?

do you think the database maybe corrupt ?

Edited September 28, 2019 by icecold

[maxdralle]

how many entries are in the 'tbl_server' table?
is there your new server with the correct game ip?

 

i hope you have legal server because lan servers are not supported...
 

[icecold]

yes i have a legal server !!

 

i'm NOT a criminal.

 

just asked for help.

 

ok, just refund my donation and i'll sort it out my  self !

[maxdralle]

calm down bro...
your bug sounds like a typical bug for servers without ranked mode.ofc i have to ask...
anyway, good luck

[icecold]

FYI my 2 legal servers !

 

http://battlelog.battlefield.com/bf3/servers/show/pc/2e897c85-7c22-4da0-9ba3-48545cd2f35f/PL-Platoon-3-TDM-NO-C4-NO-SHOTGUNS/

http://battlelog.battlefield.com/bf3/servers/show/pc/ab95befb-486f-439f-92cd-6edfec0b305e/PL-Platoon-TDM-NO-C4-NO-SHOTGUNS-NO-CRANE/

[icecold]

REFUND ?

[Prophet731]

hi,

 

i have added a second server to stats logger , but it does not seem to be logging stats ?

 

 

server full, 5 round played.

still no stats , also noticed in database for ServerID 2 in  tbl_currentplayers   ' PB_GUID    IP_aton    CountryCode   ' these 3 are empty ?

do you think the database maybe corrupt ?

 

 

yes i have a legal server !!

 

i'm NOT a criminal.

 

just asked for help.

 

ok, just refund my donation and i'll sort it out my  self !

 

 

FYI my 2 legal servers !

 

http://battlelog.battlefield.com/bf3/servers/show/pc/2e897c85-7c22-4da0-9ba3-48545cd2f35f/PL-Platoon-3-TDM-NO-C4-NO-SHOTGUNS/

http://battlelog.battlefield.com/bf3/servers/show/pc/ab95befb-486f-439f-92cd-6edfec0b305e/PL-Platoon-TDM-NO-C4-NO-SHOTGUNS-NO-CRANE/

 

 

REFUND ?

 

 

@maxdralle has no say in handling donations/money. I'm the only one that does. He was trying to help you and the reason he asked that question about having a legit server was valid as sometimes server owners have illegal copies of the game server files, which we don't provide support for.  I don't believe he was accusing you of being one of those people.

 

As for the donation, which you did back in July, asking for it back now because of this one incident is just childish. Donations are to help keep the forums online, doesn't cover any support on plugins/procon. As I said in my post about it, I don't ask anyone to donate, those that do I appreciate the help with that when they don't have to. If you really want the refund still just reply back quoting this post stating that.

 

Now for the issue of the plugin not sending information to your database. I have to ask these questions.

• Are the database credentials and host information correct?
• Is the plugin enabled?
• Does it show the server in the tbl_server table?
• Are any errors showing up in the procon console?
• Are you running AdKats?
• Are you hosting the ProCon layer or is it done through a hosting provider? If through a hosting provider, which one?

Without this information it's hard to figure out what's going on and why it wont connect.

[icecold]

yes,i took offense at his comment.

childish really ?

i expect admin to be respectful of people, now you go on the offensive.

he could have just said sorry, i was not accusing you of being one of those people. ?

[Prophet731]

yes,i took offense at his comment.

childish really ?

i expect admin to be respectful of people, now you go on the offensive.

he could have just said sorry, i was not accusing you of being one of those people. ?

 

He's not an admin. He's a plugin developer. I'm the only admin on the site. 

[maxdralle]

i am a normal forum member and try to help. maybe the "illegal server" call could easily be misunderstood. i just asked because THE PLUGIN works only when the gameserver is showing up on battlelog in ranked/offical mode. if it runs in private mode or in any other mode then he get exacly the problem what he explained... no reason to get pissed off

I AM SO SORRY BROOOO

[icecold]

ok, thanks for your help

[icecold]

i found an error in CChatGUIDStatsLogger.inc

line 3462

 

@Suicide and @Headshots . needs to be swapped around.

 

so it should look like this.

 

 InsertSQL.Append("( @ServerID, @SoldierName" + i + ",@ClanTag" + i + ", @EA_GUID" + i + ", @PB_GUID" + i + ", @Score" + i + ", @Kills" + i + ", @Deaths" + i + ", @Headshots" + i + ", @Suicide" + i + ",@TeamID" + i + ",@SquadID" + i + " ,@PlayerJoined" + i + ",@Ping" + i + ", INET_ATON( @IP_aton" + i + ")" + ",@CountryCode" + i + ",@Killstreak" + i + ",@Deathstreak" + i + ",@GlobalRank" + i + "),");

[Prophet731]

i found an error in CChatGUIDStatsLogger.inc

line 3462

 

@Suicide and @Headshots . needs to be swapped around.

 

so it should look like this.

 

InsertSQL.Append("( @ServerID, @SoldierName" + i + ",@ClanTag" + i + ", @EA_GUID" + i + ", @PB_GUID" + i + ", @Score" + i + ", @Kills" + i + ", @Deaths" + i + ", @Headshots" + i + ", @Suicide" + i + ",@TeamID" + i + ",@SquadID" + i + " ,@PlayerJoined" + i + ",@Ping" + i + ", INET_ATON( @IP_aton" + i + ")" + ",@CountryCode" + i + ",@Killstreak" + i + ",@Deathstreak" + i + ",@GlobalRank" + i + "),");

Ok, but, did that solve your original problem?

[icecold]

no, i just spotted this error sorting out a stats php page. so this was just FYI.

the original problem was because the server was running unranked.

[icecold]

I want to reset stats for all players at the beginning of each month.

hi, what stats do you need for each month.