Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by SmackDown*:

 

I have not had any issues, but I am not using the Discord feature.

[ImportBot]

Originally Posted by Sp0rAdiC*:

 

Has anyone on the test versions noticed the procon process hanging or freezing? Trying to isolate a current issue and see if it's being caused by AdKats. It appears to have started after adding the discord integration, but i'm not sure if that's really the cause.

Running Version 6.9.0.141 and haven't noticed any freezing.

[ImportBot]

Originally Posted by WolfBlade*:

 

ColColonCleaner - I've had a few times where I've seen Procon still connected to the server, but I'm actually not logged in. It's shows the server 'green', but it also shows the login screen where it's attempting to login and then times out after about a minute. Once I restart procon (from my computer) it connects fine.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hmm, odd, i'm still seeing the freezing issue. Sometimes it remains running in game, as in you can still interact with it via in-game commands, however sometimes after 12 hours or so being online it will freeze and become unresponsive completely. I'm unsure why this is happening. Is anyone else seeing this?

 

Also. Last night i posted an update to some of the auto-nuke processing, just small messaging things. On top of that I completely renamed all of the 'hacker-checker' stuff in AdKats to simply 'AntiCheat', and added code to update the commands involved with that.

 

If you modified your hcwhitelist or unhcwhitelist command text you will need to do it again. They are now acwhitelist and unacwhitelist by default.

[ImportBot]

Originally Posted by Hodor*:

 

This is flooding in my console

Code:

[21:08:42 49] [AdKats] EXCEPTION-6900-FetchPlayerBattlelogInformation-BattlelogComm26: [Could not find persona ID for Taajson]

And ColColonCleaner can you give me SQL query to delete all bans except those in which there are words: Hacking/Cheating, Hacker, Cheater, Hack, Cheat, WH, AIM, Wallhack, Aimbot, Walling, ESP, Linked.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

This is flooding in my console

Code:

[21:08:42 49] [AdKats] EXCEPTION-6900-FetchPlayerBattlelogInformation-BattlelogComm26: [Could not find persona ID for Taajson]

And ColColonCleaner can you give me SQL query to delete all bans except those in which there are words: Hacking/Cheating, Hacker, Cheater, Hack, Cheat, WH, AIM, Wallhack, Aimbot, Walling, ESP, Linked.

Updating to the latest version fixes that persona issue, assuming you're on 6900 still.

 

As for the bans i can write a query to disable those bans.

[ImportBot]

Originally Posted by Hodor*:

 

As for the bans i can write a query to disable those bans.

Yes please i will wait, thanks!

[ImportBot]

Originally Posted by Timm*:

 

Hey.

On 6.9.0.144 version begin spam in BFACP log tab like this

a08fa90da7e74a0197387032837f52b4.png

 

1 our server working on 6.9.0.0 and this log is not coming, it's come only from 6.9.0.144 runned version of AdKats.

This record is formed even if the player did not change the clantnag.

 

PS I saw this from many players, not from one

[ImportBot]

Originally Posted by Timm*:

 

Has anyone on the test versions noticed the procon process hanging or freezing? Trying to isolate a current issue and see if it's being caused by AdKats. It appears to have started after adding the discord integration, but i'm not sure if that's really the cause.

Last month I noticed this. What I just did not try, change the machine for procon, reinstall Windows, Nothing helps, every day we have to restart the procon service and I had to put the restart for every 3 hours automatically to avoid questions from server admins

Before all work fine, and procon restarted once in 24 hours.

 

I thought maybe this is due to the overflow of our database, which already has more than 10GB.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hey.

On 6.9.0.144 version begin spam in BFACP log tab like this

a08fa90da7e74a0197387032837f52b4.png

 

1 our server working on 6.9.0.0 and this log is not coming, it's come only from 6.9.0.144 runned version of AdKats.

This record is formed even if the player did not change the clantnag.

 

PS I saw this from many players, not from one

Did you add this change to your database?

 

myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry42254

 

If that's not added, stat logger will keep erasing player's clan tags in the database.

 

That log is made when a player changes clan tag, however I see that the log is also made when their first clan tag is fetched from battlelog. I'll stop it from making a log in that case.

[ImportBot]

Originally Posted by Timm*:

 

Did you add this change to your database?

 

myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry42254

 

If that's not added, stat logger will keep erasing player's clan tags in the database.

 

That log is made when a player changes clan tag, however I see that the log is also made when their first clan tag is fetched from battlelog. I'll stop it from making a log in that case.

Oh thank you.

For a long time was not here and missed. Thank you.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Last month I noticed this. What I just did not try, change the machine for procon, reinstall Windows, Nothing helps, every day we have to restart the procon service and I had to put the restart for every 3 hours automatically to avoid questions from server admins

Before all work fine, and procon restarted once in 24 hours.

 

I thought maybe this is due to the overflow of our database, which already has more than 10GB.

I wish you would have brought this to my attention sooner. Needing to restart that often is not good. I am only seeing this issue now. I'm not sure what is causing it but anything that you can provide would be helpful.

 

The best thing you could probably do to help is change AdKats to level 10 debug, and send me the log file after you realize procon has stopped responding.

[ImportBot]

Originally Posted by Hodor*:

 

Can I suggest to implement reporting system with webhooks? Example:

Attachment 4509

JSON Body:

Code:

{
  "username":"AdKats",
  "avatar_url":"https://avatars2.githubusercontent.com/u/9680130",
  "content":"**```diff\n- New report\n```**",
  "embeds":[
    {
      "color":16711680,
      "author":{
        "name":"Chilace",
        "url":"http://battlelog.battlefield.com/bf4/soldier/Chilace/stats/227280600/pc/",
        "icon_url":"http://www.gravatar.com/avatar/b399d0376f9c49910534390b9a120f42"
      },
      "title":"24/7 METRO 2014 :: Meat Grinder :: NO EXPLOSIVES! :: *Fast XP*",
      "url":"http://battlelog.battlefield.com/bf4/ru/serverbrowserwarsaw/show/pc/9edaf665-617f-4b4e-b466-75cbda0f6525/",
      "thumbnail":{
        "url":"http://eaassets-a.akamaihd.net/bl-cdn/cdnprefix/production-283-20170323/public/base/bf4/map_images/195x79/xp0_metro.jpg"
      },
      "description":"Suspicious man",
      "fields":[
        {"name":"BATTLELOG","value":"http://battlelog.battlefield.com/bf4/ru/soldier/lachmut/stats/1024957778/pc/"},
        {"name":"ACI","value":"http://history.anticheatinc.com/bf4/index.php_searchvalue=lachmut"},
        {"name":"BF4DB","value":"https://bf4db.com/player/1024957778"},
        {"name":"247FAIRPLAY","value":"https://www.247fairplay.com/CheatDetector/lachmut"},
        {"name":"METABANS","value":"http://metabans.com/search/_phrase=lachmut"},
        {"name":"PBSCREENS","value":"https://pbscreens.com/_search&input=lachmut"},
        {"name":"I-STATS","value":"http://i-stats.net/index.php_action=pcheck&player=lachmut&game=BF4"},
        {"name":"BF4STATS","value":"http://bf4stats.com/search_q=lachmut"},
        {"name":"GOOGLE","value":"https://www.google.com/#q=%22lachmut%22"}
      ],
      "image":{
        "url":"http://www.gravatar.com/avatar/39a1fdf6d0337ba32f9b3d18a5015090"
      },
      "footer":{
        "text":"Reported at",
        "icon_url":"https://avatars2.githubusercontent.com/u/9680130"
      },
      "timestamp":"2017-05-11T20:39:22.278Z"
    }
  ]
}

??? ?? ?????? ????? ? ?????? ?????? ??? ??? ??????????? ? ????_)))) Xenforo ???? ??? ??????

Where did you get this from? From which site? How to implement it on my forum Xenforo?

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry42292

Can you post query today if you can please?

[ImportBot]

Originally Posted by Timm*:

 

I wish you would have brought this to my attention sooner. Needing to restart that often is not good. I am only seeing this issue now. I'm not sure what is causing it but anything that you can provide would be helpful.

 

The best thing you could probably do to help is change AdKats to level 10 debug, and send me the log file after you realize procon has stopped responding.

Okay, i set debag level 10 on 1 GS, i hope is this enough or do you need as many servers as possible?

We have 3 server with latest AdKats.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Okay, i set debag level 10 on 1 GS, i hope is this enough or do you need as many servers as possible?

We have 3 server with latest AdKats.

No just one layer that is freezing should get the very high debug level. When AdKats is placed at debug level 8 or higher all of the thread information is printed at the beginning of each log line. The log file will be enormous but it should catch any threading blockages or issues.

 

You said you started noticing this last month. Do you remember which version of AdKats you were on at the time?

 

All of AdKats functions are threaded away from the main UI, so they should not cause any blockages inside procon itself (i.e. you'd only see the plugin stop responding, not procon itself). Additionally, procon includes a 1 minute timeout when executing a plugin's custom functions, and kills the request to the plugin if the time expires, so that again shouldn't cause an issue. That makes this a very difficult issue to track.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

??? ?? ?????? ????? ? ?????? ?????? ??? ??? ??????????? ? ????_)))) Xenforo ???? ??? ??????

Where did you get this from? From which site? How to implement it on my forum Xenforo?

This is for Discord, not a forum.

[ImportBot]

Originally Posted by Timm*:

 

No just one layer that is freezing should get the very high debug level. When AdKats is placed at debug level 8 or higher all of the thread information is printed at the beginning of each log line. The log file will be enormous but it should catch any threading blockages or issues.

 

You said you started noticing this last month. Do you remember which version of AdKats you were on at the time?

 

All of AdKats functions are threaded away from the main UI, so they should not cause any blockages inside procon itself (i.e. you'd only see the plugin stop responding, not procon itself). Additionally, procon includes a 1 minute timeout when executing a plugin's custom functions, and kills the request to the plugin if the time expires, so that again shouldn't cause an issue. That makes this a very difficult issue to track.

Ah, no, my procon completely stops responding, not only Adkats.

 

It is started as a service, the service itself works, but Procon not responding and help only restart service.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ah, no, my procon completely stops responding, not only Adkats.

 

It is started as a service, the service itself works, but Procon not responding and help only restart service.

Do you remember what version you were on when you started seeing this?

 

Also, do you know if in-game actions still work when the UI stops responding?

 

EDIT: Also, do you have a memory monitor on the service? How much memory is it using by the time it freezes? Ruling out a memory leak being the problem.

[ImportBot]

Originally Posted by Timm*:

 

Do you remember what version you were on when you started seeing this?

 

Also, do you know if in-game actions still work when the UI stops responding?

No, i setup auto-update for Adkats and not remember on what version of Adkats this beggin.

 

We not use procon as UI, i only setup layer as service, and we never connect to procon as client for administration. Admins use chat or BFACP only.

 

However, I started logging on one of the servers and if you want I will provide you with logs in a couple of days.

 

PS. when procon stops responding, no one plugins work, not only Adkats, So I think our problems are different, and I did not correctly understand you post to which I originally responded.

[ImportBot]

Originally Posted by Timm*:

 

EDIT: Also, do you have a memory monitor on the service? How much memory is it using by the time it freezes? Ruling out a memory leak being the problem.

No, i not have memory monitor, Now I'll watch it.

Put I have an alert (push notifications) on ProCon machine like Pulseway, which notifies me about the lack of resources, I never received any notifications that there is not enough memory, so I think there are no problems with memory leaks.

[ImportBot]

Originally Posted by Chilace*:

 

??? ?? ?????? ????? ? ?????? ?????? ??? ??? ??????????? ? ????_)))) Xenforo ???? ??? ??????

Where did you get this from? From which site? How to implement it on my forum Xenforo?

?? ????????? ???????????? ??? ? ???????? ????? ????????? ????????? !report - ??? ?? ? ??????-???? ?????, ??? ? ??????? ???????? http ?????? ?? ?????? ? ????????.

? ???? ????? myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry42272 ? ?????? ??????, ??? ??? ????? ??????? ??????????? InsaneLimit (??? ?????? ??????, ???????????????? ?????, ??? ?????? ?????? ?????? ???????? ??? pushbullet).

?????? ? ??????? ??????? ? ?? ????????????? ?????????, ?????? ??? ???? ????????????? ?????????? ???????, ? ? ?? ????? ????????? ?? ???????????????? ??????.

 

??? ?? ?????? ?????? ?????? ?? ?????? ???????, ??? ?????? ?? ?????? ????????????

????? ??????? ??????? - ??? ????????? ? ??????? ??? ???????? ????? ????:

2017-05-24 02-40-13 #playground - Discord.png

(????? ????? - ??? ??????)

??????????? ??? ?????? IFTTT https://ifttt.com/discover

[ImportBot]

Originally Posted by )RAG()N*:

 

I have come across a bit of a problem yesterday,

 

When there is more then one player in your "User Settings" groups that play on the same IP it changes everyones soldier name to the first one in the list.

 

Version: 6.9.0.144

 

I'm also get chat spam of

"You have been assigned the authorized role Members"

every 5mins

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I have come across a bit of a problem yesterday,

 

When there is more then one player in your "User Settings" groups that play on the same IP it changes everyones soldier name to the first one in the list.

 

Version: 6.9.0.144

 

I'm also get chat spam of

"You have been assigned the authorized role Members"

every 5mins

I'll take a look at this soon. What happens if the two players are still in the server but only one is in the user list?

[ImportBot]

Originally Posted by Hodor*:

 

And ColColonCleaner can you give me SQL query to delete all bans except those in which there are words: Hacking/Cheating, Hacker, Cheater, Hack, Cheat, WH, AIM, Wallhack, Aimbot, Walling, ESP, Linked.

As for the bans i can write a query to disable those bans.

When you can do this?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

When you can do this?

Patience. Try this.

 

update adkats_bans

set ban_status = 'Disabled'

where ban_id in

(select ban_id

from adkats_bans

inner join adkats_records_main

on adkats_bans.latest_record_id = adkats_records_main.record_id

where adkats_records_main.record_message not like '%Hack%' and

adkats_records_main.record_message not like '%Cheat%' and

adkats_records_main.record_message not like '%WH%' and

adkats_records_main.record_message not like '%AIM%' and

adkats_records_main.record_message not like '%Aimbot%' and

adkats_records_main.record_message not like '%Walling%' and

adkats_records_main.record_message not like '%ESP%' and

adkats_records_main.record_message not like '%Linked%')

[ImportBot]

Originally Posted by Hodor*:

 

Patience. Try this.

 

update adkats_bans

set ban_status = 'Disabled'

where ban_id in

(select ban_id

from adkats_bans

inner join adkats_records_main

on adkats_bans.latest_record_id = adkats_records_main.record_id

where adkats_records_main.record_message not like '%Hack%' and

adkats_records_main.record_message not like '%Cheat%' and

adkats_records_main.record_message not like '%WH%' and

adkats_records_main.record_message not like '%AIM%' and

adkats_records_main.record_message not like '%Aimbot%' and

adkats_records_main.record_message not like '%Walling%' and

adkats_records_main.record_message not like '%ESP%' and

adkats_records_main.record_message not like '%Linked%')

I use Navicat, I try to send through console F6 I receive an error:

1093 - You can't specify target table 'adkats_bans' for update in FROM clause

 

May it help? I asked you before for something similar myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry42154

 

UPD:

 

Code:

update adkats_bans set ban_status = 'Disabled' where latest_record_id in (select record_id from adkats_records_main where record_message not like '%Hack%' and
record_message not like '%Cheat%' and
record_message not like '%HSK%' and
record_message not like '%DPS%' and
record_message not like '%KPM%' and
record_message not like '%Lang%' and
record_message not like '%Insult%' and
record_message not like '%Racism%' and
record_message not like '%Nazi%' and
record_message not like '%Suspect%' and
record_message not like '%WH%' and
record_message not like '%AIM%' and
record_message not like '%ESP%' and
record_message not like '%Aimbot%' and
record_message not like '%Walling%' and
record_message not like '%pbbans%' and
record_message not like '%ggc%' and
record_message not like '%aci%' and
record_message not like '%impossible%' and
record_message not like '%Glitch%' and
record_message not like '%Linked%');

I did like your first example. It seems to work

[ImportBot]

Originally Posted by )RAG()N*:

 

I'll take a look at this soon. What happens if the two players are still in the server but only one is in the user list?

no change,

Also when you delete a user sometimes the user stays in the list but the "delete User?" and "Add Soldier?" text is missing, So you have to pick the line and retype delete to remove them.

 

I don't know if this will help but I noticed that this is happening when there are players on the same IP are in different user group. I'll test a bit more today,

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I use Navicat, I try to send through console F6 I receive an error:

1093 - You can't specify target table 'adkats_bans' for update in FROM clause

 

May it help? I asked you before for something similar myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry42154

update adkats_bans

set ban_status = 'Disabled'

where latest_record_id in

(select latest_record_id

from adkats_records_main

where adkats_records_main.record_message not like '%Hack%' and

adkats_records_main.record_message not like '%Cheat%' and

adkats_records_main.record_message not like '%WH%' and

adkats_records_main.record_message not like '%AIM%' and

adkats_records_main.record_message not like '%Aimbot%' and

adkats_records_main.record_message not like '%Walling%' and

adkats_records_main.record_message not like '%ESP%' and

adkats_records_main.record_message not like '%Linked%')

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

no change,

Also when you delete a user sometimes the user stays in the list but the "delete User?" and "Add Soldier?" text is missing, So you have to pick the line and retype delete to remove them.

What do you mean the text is missing or 'pick the line'?

 

Also, run this on your database, what gets returned?

 

select * from adkats_commands where command_id in (65, 99)