Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Either your database user name is not 'decojobs' or your database location is not 'localhost'.

but in DB credentials correct and its not" decojobs or localhost "

strange

[ImportBot]

Originally Posted by ty_ger07*:

 

but in DB credentials correct and its not" decojobs or localhost "

strange

After you make the changes, you should stop and start the plugin and/or restart the layer.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

i did that , same thing

[ImportBot]

Originally Posted by leibhold*:

 

If you have control over your database, add a user decojobs@localhost

 

You should be able to specify the user name and host name in creating user.

 

The SQL is being too helpful and appending the hostname to the end of the user - with is localhost.

[ImportBot]

Originally Posted by ty_ger07*:

 

i did that , same thing

Apparently, there is more at play than what is obvious on the surface. I don't have enough information to make any further recommendations since I don't know how you have your procon set up, whether you are using a layer server, whether you or one of your admins are connecting directly to the game server, which plugins you are using, etc.

[ImportBot]

Originally Posted by Prophet731*:

 

but in DB credentials correct and its not" decojobs or localhost "

strange

It's with the trigger that AdKats added to the table. Update the definer.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

It's with the trigger that AdKats added to the table. Update the definer.

can you tell plz or send like to guide how to update definer plz?

[ImportBot]

Originally Posted by HARDCOREBF*:

 

anyone?

[ImportBot]

Originally Posted by Prophet731*:

 

anyone?

Sorry forgot.

 

Open up phpMyAdmin, select your schema where AdKats is at, click on triggers at the top and edit each trigger and remove the text in the definer box. Like so.

 

[ImportBot]

Originally Posted by unconvincible*:

 

Hi, I'm new to plugin developing and this logger and db connections .

 

What should I do to get the GUID from an offline player (so from database)?

I hope you will help

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi, I'm new to plugin developing and this logger and db connections .

 

What should I do to get the GUID from an offline player (so from database)?

I hope you will help

You have phpMyAdmin access to the database? If so, log into the database in phpMyAdmin (or any other database access manager you may be using), and run this query:

 

SELECT `PBGUID`, `EAGUID`, `SoldierName`

FROM `tbl_playerdata`

WHERE `SoldierName` LIKE '%soldier%'

 

Substitue "%soldier%" for actual name. Leave the "%" before and after the name ('%example%' for example) to do a partial name match ignoring different starting and ending characters.

[ImportBot]

Originally Posted by unconvincible*:

 

ah thx

But I need it for my plugin. So I have to connect to the database and execute your script?

Lets say I want to get my guid, what I have to execute to get it (btw, I only need the EA_GUID)?

Is this correct:

 

SELECT `EAGUID`

FROM `tbl_playerdata`

WHERE `SoldierName` LIKE '%uncon%'

 

I don't remember, but is "LIKE" case sensitive?

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't know the C# code to use when creating a plugin to connect to a database. You can look at this plugin's source code and get ideas from it.

 

As far as the SQL query goes, = looks for an exact match. LIKE is used instead of = when looking for a fuzzy match and is not case sensitive.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Suddenly started having this error comming up, any ideas?

 

[15:56:55 21] [statslogger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by HARDCOREBF*:

 

showing this as well , plz help

 

[20:43:28 67] [statslogger]Error: Error in Startstreaming:

[20:43:28 67] Message: Cannot add or update a child row: a foreign key constraint fails (`dgns`.`tbl_playerstats`, CONSTRAINT `fk_tbl_playerstats_tbl_server_player1` FOREIGN KEY (`StatsID`) REFERENCES `tbl_server_player` (`StatsID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[20:43:28 67] Native: -2147467259

[20:43:28 67] Source: MySql.Data

[20:43:28 67] 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.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[20:43:36 60] [AdKats] SerHofi changed their IP from 67.249.142.161 to 67.246.73.224. Updating the database.

[20:43:38 40] [AdKats] Archigos8 changed their IP from 71.225.253.175 to 73.188.252.200. Updating the database.

[20:43:44 03] [AdKats] IxXHammerXxI changed their IP from 99.120.74.22 to 98.248.157.207. Updating the database.

[20:43:52 68] [AdKats] Fetching plugin links...

[20:43:53 20] [AdKats] Plugin links fetched.

[20:43:53 20] [AdKats] Fetching plugin readme...

[20:43:53 68] [AdKats] Plugin description fetched.

[20:43:53 68] [AdKats] Fetching plugin changelog...

[20:43:53 96] [AdKats] Plugin changelog fetched.

[20:43:53 96] [AdKats] Setting desc fetch handle.

[20:43:55 06] [statslogger]Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[ImportBot]

Originally Posted by TMiland*:

 

Anyone have any idea how to filter out !dfgdfg @sddfg /dfgdfg from the chat with a regex?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Anyone have any idea how to filter out !dfgdfg @sddfg /dfgdfg from the chat with a regex?

https://github.com/ColColonCleaner/AdKats/issues/579

[ImportBot]

Originally Posted by TMiland*:

 

https://github.com/ColColonCleaner/AdKats/issues/579

Nice! I'll try right away.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

ah thx

But I need it for my plugin. So I have to connect to the database and execute your script?

Lets say I want to get my guid, what I have to execute to get it (btw, I only need the EA_GUID)?

Is this correct:

 

SELECT `EAGUID`

FROM `tbl_playerdata`

WHERE `SoldierName` LIKE '%uncon%'

 

I don't remember, but is "LIKE" case sensitive?

You can get your GUID like that, yes, but i would suggest using your full name, and not using LIKE, use =

 

Case sensitivity depends on the collation of the column being queried.

[ImportBot]

Originally Posted by ty_ger07*:

 

You can get your GUID like that, yes, but i would suggest using your full name, and not using LIKE, use =

Certainly I would recommend the same. But we have no idea what the application is. I assumed that if the application includes human input, he would find LIKE to be much more useful than equals ( = ) simply because the most memorable parts of soldier's names are usually not the same as the full soldier's name.

 

For example, unconvincible, if you start entering a player name (just start entering any random word) in the top left of this page:

http://open-web-community.com/bf4sta...player&player=

... you will see how LIKE can be used.

[ImportBot]

Originally Posted by unconvincible*:

 

~ ~ ~

Hi XpKiller ,

 

can you add support for Cyrillic symbols please?

Here is the way how to do that (maybe you don't know that ) -> http://stackoverflow.com/questions/1...y-after-insert

 

Would be very nice if you can do that.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi XpKiller ,

 

can you add support for Cyrillic symbols please?

Here is the way how to do that (maybe you don't know that ) -> http://stackoverflow.com/questions/1...y-after-insert

 

Would be very nice if you can do that.

Cyrillic symbols are not transferred from the game server to Procon (DICE rcon limitation), therefore it is not possible for XpKiller to implememt Cyrillic symbols into the database (since there are no Cyrillic symbols to his plugin).

[ImportBot]

Originally Posted by unconvincible*:

 

hmm, ok thx

I don't know why they do that

[ImportBot]

Originally Posted by unconvincible*:

 

I got an error

... original message (german):

Code:

[Statslogger]Error: getUpdateServerID1: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)

Translated message:

Code:

[Statslogger] Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an object instance.
*** at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID (CServerInfo csiServerInfo)]

Maybe you want to know that

[ImportBot]

Originally Posted by SmackDown*:

 

I need some help and I have spent several hours searching, but haven't found an answer.

 

Due to hardware issues, my server provider had to move my server box. I now have a new server, but my problem is that I want to transfer the old servers database (players stats and rankings for that server) to the new server. The server provider was able to move my server so the it would stay in players favorites list so I want the same database for the new server.

 

If this is possible, what file should be moved. I am not sure which file should be moved. I am also currently using AdKats.

 

Can someone tell me which file(s) to move and where to move them too. Adkats had my old server ID number to be 1 and now its assigned the new server an id number of 7. (I included this info in case you need it.)

 

Is this possible and if so, How do I do it?

 

Thank you in advance for your help.

[ImportBot]

Originally Posted by iraqiboy90*:

 

Hello

 

I moved the database to another server.

When starting the logger is says this:

Code:

[03:08:05 28] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!
[03:08:08 31] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

I tried to search for "Weapons/M416/M416" on both databases, the one on the old server and the one on the new server using phpmyadmin and I couldnt find this keyword. I even searched a 2 days old .sql file, it doesnt have it there

[ImportBot]

Originally Posted by PHX_Big_Deal*:

 

I got an error

... original message (german):

Code:

[Statslogger]Error: getUpdateServerID1: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)

Translated message:

Code:

[Statslogger] Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an object instance.
*** at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID (CServerInfo csiServerInfo)]

Maybe you want to know that

I have the same.

[ImportBot]

Originally Posted by Jamesonp*:

 

Why does the plugin continue to add players to the tbl_playerdata table with the GAMEID of 0 instead of 1 for BF4.

[ImportBot]

Originally Posted by Prophet731*:

 

Why does the plugin continue to add players to the tbl_playerdata table with the GAMEID of 0 instead of 1 for BF4.

Restart the logger. It's a bug and it starts inserting 0s when it loses DB connection a lot.

[ImportBot]

Originally Posted by Jamesonp*:

 

Restart the logger. It's a bug and it starts inserting 0s when it loses DB connection a lot.

Copy, thanks for the reply. It added 952 players with the GameID of 0 in the past like 3 days.