Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Hodor*:

 

Code:

[14:52:15 21] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:52:26 06] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:52:32 58] [AdKats] User List Fetched from Database. [140 users, 5 Special Players, 292 Fetched Players]
[14:52:38 20] [AdKats] SQL updates fetched from backup location.
[14:52:42 08] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:52:53 22] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:04 79] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:15 72] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:26 59] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:37 35] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:48 55] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:59 50] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:10 44] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:21 53] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:32 32] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:43 29] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:54 18] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:05 19] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:16 01] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:27 04] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:38 27] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:49 71] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:56:01 22] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]

What is it and what threatens?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Code:

[14:52:15 21] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:52:26 06] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:52:32 58] [AdKats] User List Fetched from Database. [140 users, 5 Special Players, 292 Fetched Players]
[14:52:38 20] [AdKats] SQL updates fetched from backup location.
[14:52:42 08] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:52:53 22] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:04 79] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:15 72] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:26 59] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:37 35] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:48 55] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:53:59 50] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:10 44] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:21 53] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:32 32] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:43 29] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:54:54 18] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:05 19] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:16 01] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:27 04] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:38 27] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:55:49 71] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]
[14:56:01 22] [AdKats] EXCEPTION-6900-RunAction-ActionHandling38: [Command Previous Temp Ban not found in runAction. Record ID 446887]

What is it and what threatens?

You must be running an older version of the bfadmincp. That is an issue with that system. Run this. [update adkats_records_main set adkats_read = 'N' where record_id = 446887]

[ImportBot]

Originally Posted by Hodor*:

 

You must be running an older version of the bfadmincp. That is an issue with that system. Run this. [update adkats_records_main set adkats_read = 'N' where record_id = 446887]

I am using 2.0.3 version is it old?

 

UPD still flooded but when i change it to 'Y' - all stopped!

 

UPD 2 what is that meant?

Code:

[16:16:03 70] [AdKats] EXCEPTION-6900-D-FetchPlayerStatInformation-HackerChecker2859: [Error while parsing player stats data.][System.NullReferenceException: Object reference not set to an instance of an object
  at PRoConEvents.AdKats.FetchPlayerStatInformation (PRoConEvents.AdKatsPlayer aPlayer) [0x00000] in <filename unknown>:0 ]

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I am using 2.0.3 version is it old?

 

UPD still flooded but when i change it to 'Y' - all stopped!

 

UPD 2 what is that meant?

Code:

[16:16:03 70] [AdKats] EXCEPTION-6900-D-FetchPlayerStatInformation-HackerChecker2859: [Error while parsing player stats data.][System.NullReferenceException: Object reference not set to an instance of an object
  at PRoConEvents.AdKats.FetchPlayerStatInformation (PRoConEvents.AdKatsPlayer aPlayer) [0x00000] in <filename unknown>:0 ]

My bad, it was supposed to be changing it to Y. Tired brain. Anyway, regarding the other error, turn on debug mode on your layers so I can see a line number on that. No promises but i'll look into it.

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

Can you gimme SQL request which unbanned all who have 1-10 pts, please.

[ImportBot]

Originally Posted by ty_ger07*:

 

This should work:

Code:

UPDATE bans
SET bans.`ban_status` = 'Disabled'
FROM `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points
ON bans.`player_id` = points.`player_id`
WHERE points.`total_points` <= 10

[ImportBot]

Originally Posted by Hodor*:

 

This should work:

Code:

UPDATE bans
SET bans.`ban_status` = 'Disabled'
FROM `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points
ON bans.`player_id` = points.`player_id`
WHERE points.`total_points` <= 10

Code:

mysql> UPDATE bans
SET bans.`ban_status` = 'Expired'
FROM `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points
ON bans.`player_id` = points.`player_id`
WHERE points.`total_points` <= 10;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points
ON' at line 3
mysql>

[ImportBot]

Originally Posted by ty_ger07*:

 

It depends on your SQL environment and version.

 

Ok, try this instead:

Code:

UPDATE `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points ON bans.`player_id` = points.`player_id`
SET bans.`ban_status` = 'Disabled'
WHERE points.`total_points` <= 10

[ImportBot]

Originally Posted by Hodor*:

 

Works but a lot of hackers was unbanned because in Previouse bans they has bans of punishment system adkats

How to unban current bans pts bans_

[ImportBot]

Originally Posted by Hodor*:

 

I see that 'adkats_bans' has 'latest_record_id' It may be possible to somehow check if 'latest_record_id' has 'record_message' which contains "pts" word and remove ban if is_!

[ImportBot]

Originally Posted by ty_ger07*:

 

Be careful what you ask for. You asked; I gave what you asked for. How to re-ban the players you just un-banned? The easiest way is to restore a backup of your stats database from before you executed the query. Do you have recent backups?

 

 

This will ban every player which has a 'record_message' containing the letters 'pts':

Code:

UPDATE `adkats_bans` AS bans
INNER JOIN `adkats_records_main` AS records ON bans.`player_id` = records.`target_id`
SET bans.`ban_status` = 'Active'
WHERE records.`record_message` LIKE '%pts%'

Is that what you want? Warning! It will also ban/re-ban any player who had a record_message containing any other word with pts in it. Such as "accepts".

 

 

This will un-ban every player which has a 'record_message' containing the letters 'pts':

Code:

UPDATE `adkats_bans` AS bans
INNER JOIN `adkats_records_main` AS records ON bans.`player_id` = records.`target_id`
SET bans.`ban_status` = 'Disabled'
WHERE records.`record_message` LIKE '%pts%'

Is that what you want? Warning! It will also un-ban/re-un-ban any player who had a record_message containing any other word with pts in it. Such as "accepts".

 

 

Warning! The more generic queries you apply globally to your ban list, the more you will start grouping people into larger and larger groups affected by your choices. I suggest that you think long and hard about what you really want before continuing to request global changes to your adkats ban list.

[ImportBot]

Originally Posted by Hodor*:

 

I have backup and i restored all bans

And again we are unbanned players who hacked and has currently ban with reason "Hacking/Cheating or Hacks or WH" because they also has `record_message` (previouse bans) with pts.

 

We need to use somehow 'latest_record_id' from 'adkats_bans' to confirm if it is currently ban with pts word

[ImportBot]

Originally Posted by ty_ger07*:

 

We need to use somehow 'latest_record_id' from 'adkats_bans' to confirm if it is currently ban with pts word

This query would un-ban every player who has 10 or less points and has a record message containing the letters 'pts'.

Code:

UPDATE `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points ON bans.`player_id` = points.`player_id`
INNER JOIN `adkats_records_main` AS records ON bans.`player_id` = records.`target_id`
SET bans.`ban_status` = 'Disabled'
WHERE points.`total_points` <= 10
AND records.`record_message` LIKE '%pts%'

[ImportBot]

Originally Posted by Hodor*:

 

And again we are unbanned players who hacked and has currently ban with reason "Hacking/Cheating or Hacks or WH" because they also has `record_message` (previouse bans) with pts.

 

Look at screenshots:

 

a8e80dad1a.jpg

 

jordy2811 has Previouse bans or records with pts word but current ban was Hacking/Cheating (unbanned)

NikitaVermaRAO has no Previouse bans or records with pts word current ban was Hacking/Cheating (still banned)

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't see the problem. To me, it seems that it is doing exactly what you asked. Maybe I do not understand your question or do not understand your words.

 

jordy2811 has previous bans or records with pts word but current ban was Hacking/Cheating (unbanned)

That is why he was un-banned. Just like you requested.

 

NikitaVermaRAO has no Previouse bans or records with pts word current ban was Hacking/Cheating (still banned)

That is why he was not un-banned. Just like you requested.

 

 

You asked for everyone to be un-banned if they have 10 or less points and have a ban record message containing 'pts'. If the player has ANY record message containing 'pts' and 10 or less points, they are unbanned. If the player has NO record message containing 'pts', they will not be un-banned no matter how few points they have.

 

Like I said, you need to think very carefully about what you want. You keep requesting certain things and then are unhappy when the results are exactly as you requested.

 

 

So now you want it to only consider the latest record message?

 

Will set ban status to 'Disabled' for all players who have 10 or less points and have the most recent record message containing the letters 'pts':

Code:

UPDATE `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points ON bans.`player_id` = points.`player_id`
INNER JOIN `adkats_records_main` AS records ON bans.`player_id` = records.`target_id`
SET bans.`ban_status` = 'Disabled'
WHERE points.`total_points` <= 10
AND records.`record_message` LIKE '%pts%'
AND bans.`latest_record_id` = records.`record_id`

[ImportBot]

Originally Posted by Hodor*:

 

@ty_ger07, i need to unban players only with current ban who have reason in ban with pts word.

@ColColonCleaner, this would be easier if table 'adkats_bans' would have a column 'ban_reason'.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@ty_ger07, i need to unban players only with current ban who have reason in ban with pts word.

@ColColonCleaner, this would be easier if table 'adkats_bans' would have a column 'ban_reason'.

Bans reference a record, and the record contains the message, there is no reason to have a message on the ban table. Also, there is only one banfor each player, previous ban records are just for logs. It looks at the latest_record_id column to get the message for the ban, who issued the ban, etc....

 

This will disable every single ban that was caused by the punish command, leaving [X pts] at the end of the ban message. That is if you haven't been nuking tuples from the adkats_records_main table.

 

update adkats_bans set ban_status = 'Disabled' where latest_record_id in (select record_id from adkats_records_main where record_message like '%pts]%')

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner This is exactly what I was looking for! Thank you man!

Have adkats function like dont sync pts bans? Because i have No explosives server where i using PTS and one without weapon rules, but if someone get bans at No Explosives server then they cant join to server "All Weapons".

[ImportBot]

Originally Posted by ty_ger07*:

 

Yeah, whatever dude! "This is exactly what I was looking for!". You asked for 3 different things and I gave you what you asked for each time you changed your mind. The last thing I gave you was the exact same thing except that I included "10 or less points" which is what you asked for.

 

Remove the part below in red (which you wanted) and you have the exact same solution.

UPDATE `adkats_bans` AS bans

INNER JOIN `adkats_infractions_global` AS points ON bans.`player_id` = points.`player_id`

INNER JOIN `adkats_records_main` AS records ON bans.`player_id` = records.`target_id`

SET bans.`ban_status` = 'Disabled'

WHERE points.`total_points`

AND

records.`record_message` LIKE '%pts%'

AND bans.`latest_record_id` = records.`record_id`

So now you are un-banning everyone with "pts" in their ban reason event if "pts" is part of a larger word such as "accepts", "adapts", "adepts", "interrupts", "intercepts", "attempts", has "pts" in their player name and their player name is in the ban reason, and so forth? And you don't care about how many points they have, even though you said that you do? Screw off, jackwagon.

[ImportBot]

Originally Posted by Hodor*:

 

Yeah, whatever dude! "This is exactly what I was looking for!". You asked for 3 different things and I gave you what you asked for each time you changed your mind. The last thing I gave you was the exact same thing except that I included "10 or less points" which is what you asked for.

 

Remove the part below in red (which you wanted) and you have the exact same solution.

 

 

So now you are un-banning everyone with "pts" in their ban reason event if "pts" is part of a larger word such as "accepts", "adapts", "adepts", and so forth and they have 1000 points? Screw off, jackwagon.

I said:

Works but a lot of hackers was unbanned because in Previouse bans they has bans of punishment system adkats

How to unban current bans pts bans?

It meant that i was needed unban current bans with pts word! Like Enabled bans with pts word

Your code unbanned all who has in history pts bans including Enabled Hacking/Cheating bans because they have history pts bans (Previous bans).

I'm sorry if you did not understand me because of my English

[ImportBot]

Originally Posted by ty_ger07*:

 

I said:

It meant that i was needed unban current bans with pts word! Like Enabled bans with pts word

Your code unbanned all who has in history pts bans including Enabled Hacking/Cheating bans because they have history pts bans (Previous bans).

I'm sorry if you did not understand me because of my English

Ok? You did read this, right?

Will set ban status to 'Disabled' for all players who have 10 or less points and have the most recent record message containing the letters 'pts':

Code:

UPDATE `adkats_bans` AS bans
INNER JOIN `adkats_infractions_global` AS points ON bans.`player_id` = points.`player_id`
INNER JOIN `adkats_records_main` AS records ON bans.`player_id` = records.`target_id`
SET bans.`ban_status` = 'Disabled'
WHERE points.`total_points` <= 10
AND records.`record_message` LIKE '%pts%'
AND bans.`latest_record_id` = records.`record_id`

Like I said, you keep changing your mind on what you want. Every time, I gave exactly what you asked for.

Jackwagon.

Sorry ColColonCleaner; he's all yours.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hodor is hard to understand sometimes ty_ger, even I was guessing at what he actually wanted when I posted that, just happened to be what he was looking for originally. Thank you for what you did in my absence.

 

Also, hodor, if you don't want bans to be enforced across servers then make your servers different server group numbers in the tbl_server table. This applies to ALL bans however, not just bans for breaking rules.

[ImportBot]

Originally Posted by Hodor*:

 

Ok? You did read this, right?

I was tired i am so sorry i didnt see that

[ImportBot]

Originally Posted by XeroLogic*:

 

So I'm having this issue with the plugin where it doesn't send email. I had to enable debugging to catch it, and as far as I've gotten is

 

[02:24:16 72] [AdKats] ERROR-6900: [Error while sending email: System.ArgumentException: The specified string is not in the form required for a subject.

at System.Net.Mail.Message.set_Subject(String value)

at System.Net.Mail.MailMessage.set_Subject(String value)

at PRoConEvents.AdKats.EmailHandler.EmailWrite(String subject, String body)]

 

email being used to send is a generic gmail account created for the purpose, only letters in the email field, and port number being used is 465

 

E:

 

If there's any other information I can attach, let me know.

 

E2:

 

I changed it from the default adkats gmail and the port that shipped with the plugin based on some google-fu, in hopes of fixing the error, but it seems i'm still stuck on square one.

[ImportBot]

Originally Posted by )RAG()N*:

 

Here is something I have not seen before

 

I'm getting flooded with this message in the plugin log

 

[18:14:43 81] [AdKats] EXCEPTION-6904-FetchPlayerBattlelogInformation-BattlelogComm40: [Could not find persona ID for sniperpro17240]

[ImportBot]

Originally Posted by PotatoKiller*:

 

Hello, i was banned on the 1 Russian server for DPS on G36c when i was with my friend on heli (littlebird or z11) and we was shoot to the same enemy. but im not a cheater and i think its a mistake... can u help me with that?

P.S. it was year ago...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello, i was banned on the 1 Russian server for DPS on G36c when i was with my friend on heli (littlebird or z11) and we was shoot to the same enemy. but im not a cheater and i think its a mistake... can u help me with that?

P.S. it was year ago...

Please contact the admin at the server where you are banned. Get me the full ban message, along with your player name and a link to your battlelog stats. I'll see what happened.

[ImportBot]

Originally Posted by PotatoKiller*:

 

potatokiller1224

DPS Automatic Ban [LIVE][G36C-102-12-3-7]

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hey Col.

Im admin of server where he banned.

He banned 1 year ago on our adkats runned server, March 22, 2016 12:48:58 Night Permaban Player Permaban Player PotatoKiller1224 AutoAdmin [XL] #5 Conquest | Hardcore | XL-GAMES.RU DPS Automatic Ban [LIVE][G36C-102-12-3-7]

 

BL http://battlelog.battlefield.com/bf4.330862223/pc/

 

He come to us and ask unban, but i say he cheating, and we can not unban because we trust to DPS ban. But he asked the one who invented this anti-cheat system, and he here

I'm glad you linked the report. The report shows it matches with the 12 kills detected by the plugin. Very very rarely battlelog can report incorrect hit count data, and this appears to be the case here. On the stat side it saw that 12 people were killed by 7 hits with the G36, but this does not match up with the 148 total hits on the battlereport for all weapons he used that round. This does appear to be an invalid ban, it should be safe to unban him. The chance of this happening is very low, but glitches do happen in battlelog's system.

[ImportBot]

Originally Posted by PotatoKiller*:

 

Thank you )