Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by leatherneck6017*:

 

Hmmm, 4-5 months ago. Open the file with notepad or the like and tell me the version number.

Ok it looks like it was v5.0.0.5

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ok it looks like it was v5.0.0.5

Anything after version 4 doesn't require manual SQL updates. Just run version 6 and you're fine.

[ImportBot]

Originally Posted by leatherneck6017*:

 

Anything after version 4 doesn't require manual SQL updates. Just run version 6 and you're fine.

Ok thank you. I guess I was confused not seeing a new section to add whitelisted players (in my case for spambot). After scrolling through the list of commands in the manual I now see that I have to add them with a command inside the game.

 

Thank you for your quick replies. BTW, is there any way to disable spambot from showing in Procon chat log?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ok thank you. I guess I was confused not seeing a new section to add whitelisted players (in my case for spambot). After scrolling through the list of commands in the manual I now see that I have to add them with a command inside the game.

 

Thank you for your quick replies. BTW, is there any way to disable spambot from showing in Procon chat log?

The entire system, aside from settings, is designed to work through in-game commands. One of the 85 available as of 6.0.2.3.

[ImportBot]

Originally Posted by leatherneck6017*:

 

Hello again. I'm now attempting to migrate my SQL database to one hosted by my server provider, NFOservers.com. So far I've been able to get XPKiller's stats logger working (tables successfully created on MySQL database). After doing that I tried to run the AdKats setup script and it failed.

 

So I contacted NFO support and received the following reply from their founder:

The error you're quoting means that it is set up to use MySQL routines, which we don't support. You would need to request a version that uses its own functions.

Is this something you've run into before? Is there an alternative way to setup the required tables?

 

Thanks!

[ImportBot]

Originally Posted by SmackDown*:

 

For the last couple of months, Adkats has been lagging or stopping my server. It has gotten to the point that Procon will stop for two or more minuets and nothing being recorded. No commands can be issued through Procon and no events are occurring. It is like Procon is just frozen.

 

This has been getting worse and worse over the last couple of months. I will see numerous network congestion errors on my Procon. My database is located on Gameservers as my other servers. I run four servers on my layer server and all are using the AdKats system. But the constant delay and lag is going to force me to stop using Adkats.

 

I do not want to stop using AdKats, but I need help in understanding what can be causing Procon to just stop recording for a minuet up to 3 minutes, and either just go off line causing me to reconnect or suddenly the Procon Layer catches up and starts recording information. There are times when we try to ban or kick a player through Procon and nothing happens. It might take up to a minuet or two before the ban or kick will take effect.

 

The lagging or freezing is occurring intermittently. It has gotten to the point that the Layer server will not let you connect to the server. When you click to open Procon on the server, it just opens up and closes. At this point I have to reboot the Procon Layer server to fix that issue.

 

If I turn off AdKats, the server runs fine.

 

Is there a setting that I need to make to fix the lag or freezing. I really do not want to give up on the great program, so if there is something that I need to do, I will. I am currently running version 6.0.2.3 but it is also doing this on the last stable version of 6.0.0.0.

 

What do I need to do to fix this issue?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello again. I'm now attempting to migrate my SQL database to one hosted by my server provider, NFOservers.com. So far I've been able to get XPKiller's stats logger working (tables successfully created on MySQL database). After doing that I tried to run the AdKats setup script and it failed.

 

So I contacted NFO support and received the following reply from their founder:

 

Is this something you've run into before? Is there an alternative way to setup the required tables?

 

Thanks!

The database setup script requires both triggers and stored procedures, there is currently not another way of doing it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

For the last couple of months, Adkats has been lagging or stopping my server. It has gotten to the point that Procon will stop for two or more minuets and nothing being recorded. No commands can be issued through Procon and no events are occurring. It is like Procon is just frozen.

 

This has been getting worse and worse over the last couple of months. I will see numerous network congestion errors on my Procon. My database is located on Gameservers as my other servers. I run four servers on my layer server and all are using the AdKats system. But the constant delay and lag is going to force me to stop using Adkats.

 

I do not want to stop using AdKats, but I need help in understanding what can be causing Procon to just stop recording for a minuet up to 3 minutes, and either just go off line causing me to reconnect or suddenly the Procon Layer catches up and starts recording information. There are times when we try to ban or kick a player through Procon and nothing happens. It might take up to a minuet or two before the ban or kick will take effect.

 

The lagging or freezing is occurring intermittently. It has gotten to the point that the Layer server will not let you connect to the server. When you click to open Procon on the server, it just opens up and closes. At this point I have to reboot the Procon Layer server to fix that issue.

 

If I turn off AdKats, the server runs fine.

 

Is there a setting that I need to make to fix the lag or freezing. I really do not want to give up on the great program, so if there is something that I need to do, I will. I am currently running version 6.0.2.3 but it is also doing this on the last stable version of 6.0.0.0.

 

What do I need to do to fix this issue?

You are still getting this issue with 6.0.2.3? A major cause of that was found and fixed in that test version. What orchestration settings are you running? Are you using ban enforcer?

[ImportBot]

Originally Posted by SmackDown*:

 

You are still getting this issue with 6.0.2.3? A major cause of that was found and fixed in that test version. What orchestration settings are you running? Are you using ban enforcer?

I am using 6.0.2.3.

 

Below are my settings you asked about:

 

AdKats settings.jpg

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I am using 6.0.2.3.

 

Below are my settings you asked about:

 

AdKats settings.jpg

If you turn off all of those feeds, does the lag issue go away? If not, how long is it between lag instances?

[ImportBot]

Originally Posted by SmackDown*:

 

If you turn off all of those feeds, does the lag issue go away? If not, how long is it between lag instances?

Let me try that for a bit and I will post back.

[ImportBot]

Originally Posted by dyn*:

 

Hello again. I'm now attempting to migrate my SQL database to one hosted by my server provider, NFOservers.com. So far I've been able to get XPKiller's stats logger working (tables successfully created on MySQL database). After doing that I tried to run the AdKats setup script and it failed.

You said 'migrate' which makes me believe you're moving an existing database. If that is the case you should be aware that NFOservers.com has limits on how big a table can be. For this purpose, their 'unlimited' mysql databases most likely means unlimited number of databases, not size.

 

If your server has any traffic at all, I would suggest NOT using NFOservers.com for MySQL hosting though their 'unlimited' webhosting which comes along with a game server. Even if you purchase the biggest hosting package available they are not able to accommodate large databases, like the stats logger creates. Get a VPS with them and you'll be happy.

[ImportBot]

Originally Posted by TheMrApostel*:

 

Since Version 6.0.2.3 is there some duration problem by the new commands.

For example:

 

When you add a player to the reserved slots with !reserved 604800 [Playername] [Reason] the pluginconsole is confirming the command with

[21:36:23 30] [AdKats] Player [C4C]analyzerHD given 1w reserved slot on this server.

But when you check the specialplayers table in your the following info:

 

ID group pl_id game name effective expiration

146 slot_reserved 14146 NULL 1 analyzerHD 2015-01-09 20:31:53 2016-03-04 20:31:53

 

I attached a screenshot for you.

2015-01-09 21_37_04-webmysql.artatis.de ? localhost ? web990db_maxe ? adkats_specialplayers ? ph.jpg

 

Currently i am using the latest version 6.0.2.4 of the testbuild.

Commands like !rwhiteliste with the same duration etc. are displayed corretly.

[21:45:28 49] [AdKats] Player [Veto]Gremory-Sama given 1y3M report whitelist for all servers.

 

Also when i try to add a player to the reserved slot with the duration 1w ( !reserved 1w playername reason )

the plunginconsole displaye the following information: [21:46:33 03] [AdKats] Player [Veto]Gremory-Sama given 2h48m reserved slot on this server.

But in the specialplayers table the duration is one week..

 

Changing my rulz in the proconrulz plugin to avoid that little duration problem.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Since Version 6.0.2.3 is there some duration problem by the new commands.

For example:

 

When you add a player to the reserved slots with !reserved 604800 [Playername] [Reason] the pluginconsole is confirming the command with

[21:36:23 30] [AdKats] Player [C4C]analyzerHD given 1w reserved slot on this server.

But when you check the specialplayers table in your the following info:

 

ID group pl_id game name effective expiration

146 slot_reserved 14146 NULL 1 analyzerHD 2015-01-09 20:31:53 2016-03-04 20:31:53

 

I attached a screenshot for you.

2015-01-09 21_37_04-webmysql.artatis.de ? localhost ? web990db_maxe ? adkats_specialplayers ? ph.jpg

 

Currently i am using the latest version 6.0.2.4 of the testbuild.

Commands like !rwhiteliste with the same duration etc. are displayed corretly.

[21:45:28 49] [AdKats] Player [Veto]Gremory-Sama given 1y3M report whitelist for all servers.

 

Also when i try to add a player to the reserved slot with the duration 1w ( !reserved 1w playername reason )

the plunginconsole displaye the following information: [21:46:33 03] [AdKats] Player [Veto]Gremory-Sama given 2h48m reserved slot on this server.

But in the specialplayers table the duration is one week..

 

Changing my rulz in the proconrulz plugin to avoid that little duration problem.

Thanks for the testing, this is why we have test versions. I'll look into this issue.

[ImportBot]

Originally Posted by iraqiboy90*:

 

hi

 

what does this mean:

 

Code:

[AdKats] WARNING: Thread warning: databasecomm[29] onlineNonAdminYell[13] BattlelogComm[34] IPAPIComm[35] playerlisting[24] AccessFetching[25] killprocessing[26] messaging[27] Command[28] action[30] TeamSwap[31] BanEnforcer[32] HackerChecker[33] onlineNonAdminSay[23] onlineNonAdminYell[36] roundticketlogger[39] onlineNonAdminSay[22] onlineNonAdminYell[11] onlineNonAdminYell[42] SettingUploader[45]

been having it throughout the day

[ImportBot]

Originally Posted by b1257786*:

 

You can do that, if the layers are not rebooted. Once AdKats starts up it will begin holding in memory every player who enters the server, and if they leave they are stored in a separate section where they still can be acted on. Issuing punish against them will result in a question "Punish Player -> playername[OFFLINE] for reason_". Is this not working for you? It will not if your layers rebooted after the player left the server.

And older post, but we have exactly the same problem. The server and layer are rebooted by our hosting provider and after that no punishment can be assigned to any players that played the day before. The question is -- since XpKiller's Stats Logger plugin is mandatory anyways and all the players that ever played on the server are stored there -- why not query this info and take the player data from the database. What extra information is stored in memory that cannot be taken from the Stats database or cannot be added easily to the database?

 

If it's not planned to be implemented yet -- I would like to add this as a feature request (where can that be done_)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

And older post, but we have exactly the same problem. The server and layer are rebooted by our hosting provider and after that no punishment can be assigned to any players that played the day before. The question is -- since XpKiller's Stats Logger plugin is mandatory anyways and all the players that ever played on the server are stored there -- why not query this info and take the player data from the database. What extra information is stored in memory that cannot be taken from the Stats database or cannot be added easily to the database?

 

If it's not planned to be implemented yet -- I would like to add this as a feature request (where can that be done_)

I'm already looking into this issue. It's a memory usage problem for some layers, storing player objects in memory after they leave. Of course the database is queried for players, but not everything can be queried every time. Especially for slower database connections that seriously slows down the program. It will be fixed soon.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Since Version 6.0.2.3 is there some duration problem by the new commands.

For example:

 

When you add a player to the reserved slots with !reserved 604800 [Playername] [Reason] the pluginconsole is confirming the command with

[21:36:23 30] [AdKats] Player [C4C]analyzerHD given 1w reserved slot on this server.

But when you check the specialplayers table in your the following info:

 

ID group pl_id game name effective expiration

146 slot_reserved 14146 NULL 1 analyzerHD 2015-01-09 20:31:53 2016-03-04 20:31:53

 

I attached a screenshot for you.

2015-01-09 21_37_04-webmysql.artatis.de ? localhost ? web990db_maxe ? adkats_specialplayers ? ph.jpg

 

Currently i am using the latest version 6.0.2.4 of the testbuild.

Commands like !rwhiteliste with the same duration etc. are displayed corretly.

[21:45:28 49] [AdKats] Player [Veto]Gremory-Sama given 1y3M report whitelist for all servers.

 

Also when i try to add a player to the reserved slot with the duration 1w ( !reserved 1w playername reason )

the plunginconsole displaye the following information: [21:46:33 03] [AdKats] Player [Veto]Gremory-Sama given 2h48m reserved slot on this server.

But in the specialplayers table the duration is one week..

 

Changing my rulz in the proconrulz plugin to avoid that little duration problem.

This is fixed in 6.0.3.5.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hi

 

what does this mean:

 

Code:

[AdKats] WARNING: Thread warning: databasecomm[29] onlineNonAdminYell[13] BattlelogComm[34] IPAPIComm[35] playerlisting[24] AccessFetching[25] killprocessing[26] messaging[27] Command[28] action[30] TeamSwap[31] BanEnforcer[32] HackerChecker[33] onlineNonAdminSay[23] onlineNonAdminYell[36] roundticketlogger[39] onlineNonAdminSay[22] onlineNonAdminYell[11] onlineNonAdminYell[42] SettingUploader[45]

been having it throughout the day

Please send several examples of this warning, from different timestamps throughout the day.

[ImportBot]

Originally Posted by b1257786*:

 

I'm already looking into this issue. It's a memory usage problem for some layers, storing player objects in memory after they leave. Of course the database is queried for players, but not everything can be queried every time. Especially for slower database connections that seriously slows down the program. It will be fixed soon.

I don't know about others, but we have to ban a maximum of maybe 2-3 players per week. Even if I would have to wait for one minute for necessary queries to be made this would be much better than wanting to ban someone after a the daily layer restart by our game server provider and NOT being able to (being a coder myself I would assume the slowest possible query to fetch required data for a ban from a remote SQL server would not take more than a few seconds -- at least if you know the exact player name you want to query for).

[ImportBot]

Originally Posted by TheMrApostel*:

 

Is it possible to exclude specified weapons from the KPM Checker?

Players who use a shotgun in maps like Metro are able to reach the limit easier then players with assault rifle etc.

 

I would like to activate the KPM Checker and exclude all shotguns from the list to decrease false-positive bans.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Is it possible to exclude specified weapons from the KPM Checker?

Players who use a shotgun in maps like Metro are able to reach the limit easier then players with assault rifle etc.

 

I would like to activate the KPM Checker and exclude all shotguns from the list to decrease false-positive bans.

Increase the trigger level.

[ImportBot]

Originally Posted by TheMrApostel*:

 

Increase the trigger level.

In that case i will stay without the KPM Checker.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

In that case i will stay without the KPM Checker.

Sounds good. Some features may be added later but this is what's available right now.

[ImportBot]

Originally Posted by p19blo*:

 

for suggestions towards LRT do i post on github ?

 

Thanks, sorry for side topic.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

for suggestions towards LRT do i post on github ?

 

Thanks, sorry for side topic.

Yep, post on the LRT repository: https://github.com/AdKats/AdKats-LRT

[ImportBot]

Originally Posted by AmcieK*:

 

Problem back in last version http://i.imgur.com/Jcv1CeZ.jpg

[ImportBot]

Originally Posted by SmackDown*:

 

I have been running AdKats version Version 6.0.2.3. While using this version, the Procon layer is laggy at times and will go two to 3 minuets unresponsive and then all of a sudden start logging events and taking commands. I have turn off all orchestration settings to false. That might have helped a little bit, but the procon layer would still become unresponsive at times.

 

Today, I tried to upgrade to version 6.0.4.6. Upon restarting my layer server and activating the new version of Adkats, it would not run and I was getting the below error:

 

[06:23:09] [AdKats] ERROR: Non-Query failed. [Adding command 104]: MySql.Data.MySqlClient.MySqlException: Column count doesn't match value count at row 1

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)

[06:23:09] [AdKats] ERROR: Non-Query failed. [Adding command 105]: MySql.Data.MySqlClient.MySqlException: Column count doesn't match value count at row 1

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)

[06:23:10] [AdKats] ERROR: Non-Query failed. [Adding command 106]: MySql.Data.MySqlClient.MySqlException: Column count doesn't match value count at row 1

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)

[06:23:10] [AdKats] ERROR: Non-Query failed. [Adding command 107]: MySql.Data.MySqlClient.MySqlException: Column count doesn't match value count at row 1

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)

[06:23:10] [AdKats] INFO: Shutting down AdKats.

[06:23:15] [AdKats] AdKats 6.0.4.6 Disabled! =(

 

Can you advise what I need to do to fix this?

[ImportBot]

Originally Posted by TheSoulrester*:

 

Hey guys,

first i want to say that my english is not the best. I hope you can understand me.

 

I have a problem with installing the Adkats Plugin.

When i want to import the .sql file onto my MySQL-Database, i get an error with an error-code #1136 - Column count doesn't match value count at row 1

 

i contacted the support but the support told me that he can't do anything to solve this problem. some reason could be deleting something like "DEFINER='user'@'host' und LOCK TABLES;" but i can't find anything like that.

 

under my prozedures, there is a prozedure called "addLogPlayerID" but i cant do anything with this. (I can activate it (nothing happens) and export. I can't delete or edit it.

 

i put some screenshots into this post that you can see the problem.

 

i hope, you can help me with my problem.

 

Attached Files:

• mysql.png
• mysql1.png

[ImportBot]

Originally Posted by naurel*:

 

Hi ColColonCleaner just a question, is there a way (even webinterface) already released to access the list of ban list (like in the procon by default) ?

 

Thank You