Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Jamesonp*:

 

That would be awesome, and when it's activated can you please make it so it doesn't refresh all the settings as often?

 

How feasible would it be to have it unlock with a password set in the database?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

That would be awesome, and when it's activated can you please make it so it doesn't refresh all the settings as often?

 

How feasible would it be to have it unlock with a password set in the database?

Alright, there will be an enter password field that will set the password for that server's settings (it will not push to all servers, just like settings per server do not automatically push for other servers). Once entered that field will disappear. Once password set it will only be changeable in the database. Settings will be locked with password and unlocked with password.

 

Refresh should no longer be an issue since it will only be refreshing 5-10 fields instead of every one. In our layer instances AdKats has over 800 settings in the settings tab....procon is just not built to handle that.

 

Also, a suggested list of all settings to remain in the window when its locked would be nice. Right now on the list is the server info stuff, mini-ban-management, and the debug section.

[ImportBot]

Originally Posted by Jamesonp*:

 

Sounds awesome. Keep up the good work!

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Test version 4.1.0.6

 

Added setting locking. Moved setting storage to the database only wherever possible.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

[ImportBot]

Originally Posted by Jamesonp*:

 

Downloaded the new version. I like the lock, thank you.

 

We are still seeing freezes with Procon every 15 - 20 seconds as a result of Adkats. When we disable the plugin, there is no issues. Our databased is hosted on a remote VDS which has been properly tuned and passes all performance tests. Any ideas?

 

Edit:

 

I'll give it some time after the restart to see if it's just the initial refresh.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Downloaded the new version. I like the lock, thank you.

 

We are still seeing freezes with Procon every 15 - 20 seconds as a result of Adkats. When we disable the plugin, there is no issues. Our databased is hosted on a remote VDS which has been properly tuned and passes all performance tests. Any ideas?

 

Edit:

 

I'll give it some time after the restart to see if it's just the initial refresh.

We are seeing the freeze too. I will have to look much deeper to find what is causing that...some way of monitoring the threads live. One thing i do know is it's related to the number of players in the server; Its worse with full 64, much less with fewer players.

[ImportBot]

Originally Posted by Jamesonp*:

 

Could it be related to the BF4Stats lookup thread? I'll keep my eye on the process with Sysinternals Process Explorer to see if I can locate the issue.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Could it be related to the BF4Stats lookup thread? I'll keep my eye on the process with Sysinternals Process Explorer to see if I can locate the issue.

Disable hacker checker on the layers and restart them to check that, no calls to bf3/bf4stats are made if that is disabled. I hope it's not just general amount of code...because that is only going to increase, and we are already at 19000 lines...

[Prophet731]

Originally Posted by Prophet731*:

 

Thinking about adding one last thing before the official release. A lock on adkats settings. Basically once activated via the settings tab it will lock all adkats settings and grey out the values. The only thing that can be used in settings when locked is command entry and mini-ban-management. Some people had issues with admins having access to all settings when all they needed was ban management and command entry. The only way to unlock settings will be to have direct database access and change the lock setting from there in the settings table.

I'll put an AdKats management section for settings to help ease the use of it if they have the web admin installed. Do I just need to change a DB value and it will push to the layer or would a field saying settings update and AdKats just checks that and pulls the new information?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I'll put an AdKats management section for settings to help ease the use of it if they have the web admin installed. Do I just need to change a DB value and it will push to the layer or would a field saying settings update and AdKats just checks that and pulls the new information?

With 4.1.0.6+ no settings other than db creds and lock information are stored plugin side. Everything is moved to the database. The fetch for settings happens immediately on startup, and every 5 minutes after that. "Settings Locked" True/False, "Settings Password" String > 5 chars. Line can be added to the settings table for each server. I assume a password is added before locking is done.

[ImportBot]

Originally Posted by Kinsman*:

 

What would be a realistic setting if we wanted to try out the KPM check?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

What would be a realistic setting if we wanted to try out the KPM check?

We have it set at 4.5, but a few false positives have come through, so i would suggest going up to 5.0

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Gah, there is an error with "targeted player X has left the server" messages...its happening at the wrong times.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Targeted player issue fixed: https://raw.github.com/ColColonClean...test/AdKats.cs

[ImportBot]

Originally Posted by Rollin_Coal*:

 

I just got this plugin set up, haven't had much time to play with settings so most everything is at default. One of the features that I plan on using it the mute function. I just tried it on a player and received the following message in game, "You can't mute an admin, dimwit." This player is surely not an admin, and isn't even on a reserved slot list. My player is listed as a Full Admin and mute player is allowed under role settings. Anyone know where I went wrong?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I just got this plugin set up, haven't had much time to play with settings so most everything is at default. One of the features that I plan on using it the mute function. I just tried it on a player and received the following message in game, "You can't mute an admin, dimwit." This player is surely not an admin, and isn't even on a reserved slot list. My player is listed as a Full Admin and mute player is allowed under role settings. Anyone know where I went wrong?

Lol, that message only gets shown if the person you are attempting to mute is an admin...unless something went wrong with the latest patch. Is there another player you can test it on to check?

 

I just tried it with the latest version on a random player >

 

[22:17:40] Admin > /mute knights testing

[22:17:40] AdKats > Say > xXxKnightsXxX > You have been muted by an admin, talking will cause punishment. You can speak again next round.

[22:17:40] AdKats > xXxKnightsXxX has been muted for this round.

 

No error. No message.

[ImportBot]

Originally Posted by Rollin_Coal*:

 

Just tried it again as my player in game, and through the procon chat.

 

[23:21:15] Woot_Woooooo > /mute ark testing

[23:21:12] AdKats > Say > Woot_Woooooo > You can't mute an admin, dimwit.

 

[23:24:22] Admin > /mute ark testing

[23:24:20] AdKats > You can't mute an admin, dimwit.

 

I am using 4.1.0.0. Any ideas?

[ImportBot]

Originally Posted by Kinsman*:

 

Targeted player issue fixed: https://raw.github.com/ColColonClean...test/AdKats.cs

Thanks, whats that message used for may I ask?

 

Also is this the version that I need to add a password and stores its settings in the DB I guess?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thanks, whats that message used for may I ask?

 

Also is this the version that I need to add a password and stores its settings in the DB I guess?

You don't need to add a password, but it's suggested. If you have other admins with access to plugin settings it makes sure they aren't messing with them if not allowed.

 

That message is for when a player gets acted on in any way, report, kill, psay, etc, it will tell you when they leave the server. We've had cases where admins would wonder why name completion wasn't working on a guy who was reported; it wasn't finding him because he left immediately after being reported. This informs the admins of those situations.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Just tried it again as my player in game, and through the procon chat.

 

[23:21:15] Woot_Woooooo > /mute ark testing

[23:21:12] AdKats > Say > Woot_Woooooo > You can't mute an admin, dimwit.

 

[23:24:22] Admin > /mute ark testing

[23:24:20] AdKats > You can't mute an admin, dimwit.

 

I am using 4.1.0.0. Any ideas?

I'll look into it tomorrow after my finals are done.

[ImportBot]

Originally Posted by GR101*:

 

Trying a fresh installation, step 2 part of the process 'Set up the database', when I run the SQL script on my working stats logging database, I'm getting the following error message:

 

Code:

SQL query:
DROP TRIGGER IF EXISTS `tbl_chatlog_player_id_insert` $$

MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation

I have checked for the error message but it doesn't really explain what needs to be done to fix the error, anybody experienced the same problem?

[ImportBot]

Originally Posted by Kinsman*:

 

The live scoreboard issues is on our end as well, and unfortunately i do not control/develop that element, that is prophet's domain. We are waiting on him to fix it on our end as well.

There is no issue on his tracker for this, nor can i find any mention of it on the forums there?

 

I do know that if I disable Adkats Plugin, then our Live Scoreboard setting stops being set to No in the stats logger.

 

Prophet said his Live Scoreboard comes from Rcon I thought?

[ImportBot]

Originally Posted by Kinsman*:

 

Mmm, seems some confusion here, to clarify I'm referring to the Live Scoreboard Setting in the Stats logger Plugin being forced off by Adkats Plugin. NOT our Livescoreboard not working in webadmin, because it is bizarrely. Anyhow, we use the live scoreboard for our own stats, so if adkats keeps forcing it off then thats that for us I guess.

[ImportBot]

Originally Posted by _CH_KeyserSoze*:

 

Mmm, seems some confusion here, to clarify I'm referring to the Live Scoreboard Setting in the Stats logger Plugin being forced off by Adkats Plugin. NOT our Livescoreboard not working in webadmin, because it is bizarrely. Anyhow, we use the live scoreboard for our own stats, so if adkats keeps forcing it off then thats that for us I guess.

Col is fixing that in the next release...It is a known issue

[ImportBot]

Originally Posted by CaptCourage*:

 

4.1.0.5

 

It will automatically update the database from 4.0.0.0+, no extra scripts are needed.

 

Changes here, minus some small bugs fixed: https://github.com/ColColonCleaner/A...6&state=closed

 

Test version until proven working on 1.4.2.0 of procon, which all layers should currently be updated to.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

All versions of procon have been updated yet still am seeing this

 

[02:49:32 99] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[02:49:32 99] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[02:49:34 85] [AdKats] EXCEPTION: Line 0: [FetchUserList][Error while fetching access list.]: MySql.Data.MySqlClient.MySqlException: Table 'ccsteamt_procon.adkats_specialplayers' doesn't exist

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 PRoConEvents.AdKats.FetchUserList()

[02:49:34 85] [AdKats] User List Fetched from Database. User Count: 3

[02:49:40 89] [AdKats] adkats_exception upload for AdKats by AdKats SUCCESSFUL!

[02:49:46 81] [AdKats] adkats_exception update for AdKats by AdKats SUCCESSFUL!

[02:49:46 81] [AdKats] In-Game/Automated adkats_exception record took 11965.8649ms to complete.

 

Will look at database now to see if table exists....although I really dont know much about database and its workings.Well see.

 

Cheers

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Trying a fresh installation, step 2 part of the process 'Set up the database', when I run the SQL script on my working stats logging database, I'm getting the following error message:

 

Code:

SQL query:
DROP TRIGGER IF EXISTS `tbl_chatlog_player_id_insert` $$

MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation

I have checked for the error message but it doesn't really explain what needs to be done to fix the error, anybody experienced the same problem?

You do not have the needed database privileges to add that trigger, please talk with your database provider.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Mmm, seems some confusion here, to clarify I'm referring to the Live Scoreboard Setting in the Stats logger Plugin being forced off by Adkats Plugin. NOT our Livescoreboard not working in webadmin, because it is bizarrely. Anyhow, we use the live scoreboard for our own stats, so if adkats keeps forcing it off then thats that for us I guess.

4.1.0.7 to fix

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

All versions of procon have been updated yet still am seeing this

 

[02:49:32 99] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[02:49:32 99] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[02:49:34 85] [AdKats] EXCEPTION: Line 0: [FetchUserList][Error while fetching access list.]: MySql.Data.MySqlClient.MySqlException: Table 'ccsteamt_procon.adkats_specialplayers' doesn't exist

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 PRoConEvents.AdKats.FetchUserList()

[02:49:34 85] [AdKats] User List Fetched from Database. User Count: 3

[02:49:40 89] [AdKats] adkats_exception upload for AdKats by AdKats SUCCESSFUL!

[02:49:46 81] [AdKats] adkats_exception update for AdKats by AdKats SUCCESSFUL!

[02:49:46 81] [AdKats] In-Game/Automated adkats_exception record took 11965.8649ms to complete.

 

Will look at database now to see if table exists....although I really dont know much about database and its workings.Well see.

 

Cheers

4.1.0.7 to fix

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

4.1.0.7 Test Version: https://raw.github.com/ColColonClean...test/AdKats.cs

[Prophet731]

Originally Posted by Prophet731*:

 

There is no issue on his tracker for this, nor can i find any mention of it on the forums there?

 

I do know that if I disable Adkats Plugin, then our Live Scoreboard setting stops being set to No in the stats logger.

 

Prophet said his Live Scoreboard comes from Rcon I thought?

Correct, I connect directly to the gameserver with the RCON protocol. I don't use the logger for the scoreboard but in the future I might add support for it incase users are not able open the port required to connect to the gameserver.