Advanced In-Game Admin and Ban Enforcer - AdKats

[Prophet731]

Originally Posted by Prophet731*:

 

  ColColonCleaner* said:

Sounds like you didn't move over the infraction triggers.

 

Make sure you add those triggers back to your adkats_records_main table.

shut down your layers.

Back up your bans and records table.

truncate your records table, both infractions tables, and your bans table.

reimport your records table, reimport your bans table

enable your layers.

 

The infractions system was unfortunately designed in a way that does not allow easy backup/import.

Blame the 2 year old ColonCleaner decision for this design. We really need to sit down and figure out a new DB schema.

[ImportBot]

Originally Posted by Hodor*:

 

  ColColonCleaner* said:

Feedback does not send emails. I can look into that email error soon-ish.

Where can i see all feedback? And thank you for taking care of email linux

[ImportBot]

Originally Posted by Mr_Shishacolic*:

 

  ColColonCleaner* said:

He's averaging 65 damage per shot on the G36C over 61 kills.

 

There is a reason that setting section is now enabled by default for all users of AdKats and can't be disabled. I can count on one hand the known false positives with that system over the ~2 years it's been active. But....that's not to say it's impossible to trigger falsely, there is one way i've known for it to be triggered without warrant. There is a backup system BF servers have to store player's kills to battlelog in case of a server crash, which would be great if they also stored hit stats as well. A couple people have gotten banned by the system because a server crashed and uploaded their 30-70 kills with a weapon but 0 hits accounted for and no battlereport, which inflates their damage stats significantly. This is the only way that system trigger falsely.

Thank you for the explanation Colonel.

We kicked him now out of the platoon.

We dont support or accept such hacks/mods.

[ImportBot]

Originally Posted by wdfstryfe*:

 

  ColColonCleaner* said:

Sounds like you didn't move over the infraction triggers.

 

Make sure you add those triggers back to your adkats_records_main table.

shut down your layers.

Back up your bans and records table.

truncate your records table, both infractions tables, and your bans table.

reimport your records table, reimport your bans table

enable your layers.

 

The infractions system was unfortunately designed in a way that does not allow easy backup/import.

They way I did the move was do a full export of the database in Mysql workbench. Then I did an import on the other server. Not sure how anything would of gotten deleted or changed?

[ImportBot]

Originally Posted by wdfstryfe*:

 

I decided to just start over because of all the problems I've had. The problem i got now is I can set the server ID to something else in adkats. :-/ So it imported one servers settings and when I attempt to change it it fails.

[ImportBot]

Originally Posted by wdfstryfe*:

 

To clarify both servers say Display 1 instead of 1 and 2.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  wdfstryfe* said:

I decided to just start over because of all the problems I've had. The problem i got now is I can set the server ID to something else in adkats. :-/ So it imported one servers settings and when I attempt to change it it fails.

You can't change the server id in AdKats, that's why it says display, it's just telling you the id of the current server.

 

What you can do is type another server's id into the import field and it will import all settings from that server into this one.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  wdfstryfe* said:

They way I did the move was do a full export of the database in Mysql workbench. Then I did an import on the other server. Not sure how anything would of gotten deleted or changed?

Database backups don't work the way you think, and it's unfortunate the way i wrote it makes for full backup /restore messing with the infraction triggers. Will take that into account if a redesign still ends up happening, however slim a chance that may be.

[ImportBot]

Originally Posted by Chilace*:

 

  ColColonCleaner* said:

Not for the procon ban list, it would cause issues for people importing to the ban enforcer. I would suggest enabling that if you have many bans, there is a mini ban manager in the settings section that allows ban management if you don't have the web admin by prophet. I would need to design some way to make those two work together, if you really need it I would suggest opening a ticket for it.

I'm curious what issues it would cause if I enable ban enforcer, because there are some bans with player names in the reason in my banList.txt (some plugins puts the player name into reason and i have modified HC's ban messages with %player_name%)?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Chilace* said:

I'm curious what issues it would cause if I enable ban enforcer, because there are some bans with player names in the reason in my banList.txt (some plugins puts the player name into reason and i have modified HC's ban messages with %player_name%)?

It's not really serious, just makes messages get lengthened when they don't need to be. So you'll see stuff like this when it starts enforcing bans:

 

Enforcing permanent ban on manbearpig for manbearpig Hacking

 

Because 'manbearpig Hacking' is the reason procon had for the ban, instead of just having the real reason 'Hacking' there.

 

If i was to allow adding player names in the procon ban list and someone was to enable then disable the ban enforcer it would get even worse, you'd end up with:

 

manbearpig manbearpig Hacking

 

as the ban reason since it would keep adding the name to the front of it. Not to mention if they changed their name at some point and it ended up with two different player names then the Hacking reason. Your ban list would get really messy as a result, and i'm trying to avoid people shooting themselves in the foot with that.

[ImportBot]

Originally Posted by wdfstryfe*:

 

  ColColonCleaner* said:

Database backups don't work the way you think, and it's unfortunate the way i wrote it makes for full backup /restore messing with the infraction triggers. Will take that into account if a redesign still ends up happening, however slim a chance that may be.

Yeah I was hoping it would be like a M$ SQL backup and restore. None the less I started over and I was able to get around the other issue I was having (I think it had to do with the database server i was trying to use).

[ImportBot]

Originally Posted by Chilace*:

 

  ColColonCleaner* said:

It's not really serious, just makes messages get lengthened when they don't need to be. So you'll see stuff like this when it starts enforcing bans:

 

Enforcing permanent ban on manbearpig for manbearpig Hacking

 

Because 'manbearpig Hacking' is the reason procon had for the ban, instead of just having the real reason 'Hacking' there.

 

If i was to allow adding player names in the procon ban list and someone was to enable then disable the ban enforcer it would get even worse, you'd end up with:

 

manbearpig manbearpig Hacking

 

as the ban reason since it would keep adding the name to the front of it. Not to mention if they changed their name at some point and it ended up with two different player names then the Hacking reason. Your ban list would get really messy as a result, and i'm trying to avoid people shooting themselves in the foot with that.

It would be helpful to include this information and the need to delete %playername% from the ban messages of the plugins that puts player name into reason of the ban into Readme under BanEnforcer section.

[ImportBot]

Originally Posted by nbtc971*:

 

Does this:

 

'Baserape Causing Players (Display)' - Current display of baserape causing players using the below options.

 

Mean you can add a cmd like !baseraper and it will display a list of people currently in the db as possible baserapers?

 

EDIT

Well now it looks like it's just a list of who adkats has in it's DB as being tracked.

[ImportBot]

Originally Posted by Hodor*:

 

What is that meant?

 

Code:

] [AdKats] INFO: STATDIFF - [MoFu]DARIUZ_DARK - G18 [3/3][100 DPS][+456%]

+457%

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Chilace* said:

It would be helpful to include this information and the need to delete %playername% from the ban messages of the plugins that puts player name into reason of the ban into Readme under BanEnforcer section.

Yeah, including the player name in ban reasons was a crutch added because the server ban lists can't separate name from reason when doing bans by GUID.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  nbtc971* said:

Does this:

 

'Baserape Causing Players (Display)' - Current display of baserape causing players using the below options.

 

Mean you can add a cmd like !baseraper and it will display a list of people currently in the db as possible baserapers?

 

EDIT

Well now it looks like it's just a list of who adkats has in it's DB as being tracked.

I should have removed that section from the plugin, it helped balance but was too abusive to players.

 

If you want a balance helping script I would suggest using the top player monitor, after enabling posting of win/loss stats. It works along side multibalancer and has greatly helped balance on all of our BF4 servers.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

What is that meant?

 

Code:

] [AdKats] INFO: STATDIFF - [MoFu]DARIUZ_DARK - G18 [3/3][100 DPS][+456%]

+457%

He was using his G18 as a finisher for people he's already shot. Notice only 3 kills with 3 hits. Nothing to worry about.

[ImportBot]

Originally Posted by Hodor*:

 

How can I view all messages from players who used /feedback

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

How can I view all messages from players who used /feedback

You can query the database.

 

Code:

select 
  `tbl_games`.`Name` AS `Game`, 
  left(`tbl_server`.`ServerName`, 25) AS `Server`, 
  `adkats_records_main`.`source_name` AS `Source`, 
  `adkats_records_main`.`record_message` AS `Feedback`, 
  concat(
    timestampdiff(
      HOUR, 
      `adkats_records_main`.`record_time`, 
      utc_timestamp()
    ), 
    'h ', 
    (
      timestampdiff(
        MINUTE, 
        `adkats_records_main`.`record_time`, 
        utc_timestamp()
      ) - (
        timestampdiff(
          HOUR, 
          `adkats_records_main`.`record_time`, 
          utc_timestamp()
        ) * 60
      )
    ), 
    'm'
  ) AS `Age` 
from 
  (
    (
      (
        `adkats_records_main` 
        left join `tbl_server` on(
          (
            `adkats_records_main`.`server_id` = `tbl_server`.`ServerID`
          )
        )
      ) 
      left join `tbl_games` on(
        (
          `tbl_server`.`GameID` = `tbl_games`.`GameID`
        )
      )
    ) 
    left join `adkats_commands` `type_command` on(
      (
        `type_command`.`command_id` = `adkats_records_main`.`command_type`
      )
    )
  ) 
where 
  (
    `adkats_records_main`.`command_type` = 118
  ) 
order by 
  `adkats_records_main`.`record_time` desc 
limit 
  1000

[ImportBot]

Originally Posted by Hodor*:

 

  ColColonCleaner* said:

You can query the database.

 

Code:

select 
  `tbl_games`.`Name` AS `Game`, 
  left(`tbl_server`.`ServerName`, 25) AS `Server`, 
  `adkats_records_main`.`source_name` AS `Source`, 
  `adkats_records_main`.`record_message` AS `Feedback`, 
  concat(
    timestampdiff(
      HOUR, 
      `adkats_records_main`.`record_time`, 
      utc_timestamp()
    ), 
    'h ', 
    (
      timestampdiff(
        MINUTE, 
        `adkats_records_main`.`record_time`, 
        utc_timestamp()
      ) - (
        timestampdiff(
          HOUR, 
          `adkats_records_main`.`record_time`, 
          utc_timestamp()
        ) * 60
      )
    ), 
    'm'
  ) AS `Age` 
from 
  (
    (
      (
        `adkats_records_main` 
        left join `tbl_server` on(
          (
            `adkats_records_main`.`server_id` = `tbl_server`.`ServerID`
          )
        )
      ) 
      left join `tbl_games` on(
        (
          `tbl_server`.`GameID` = `tbl_games`.`GameID`
        )
      )
    ) 
    left join `adkats_commands` `type_command` on(
      (
        `type_command`.`command_id` = `adkats_records_main`.`command_type`
      )
    )
  ) 
where 
  (
    `adkats_records_main`.`command_type` = 118
  ) 
order by 
  `adkats_records_main`.`record_time` desc 
limit 
  1000

What should I do with this code?

[ImportBot]

Originally Posted by nbtc971*:

 

I just want something that monitors baseraping.. are you saying your plugin doesn't do that any longer? If so, is there a good baserape plugin?

[ImportBot]

Originally Posted by wdfstryfe*:

 

I have a strange thing that's occurring since I started over with a new database. Basically during the round the top players and continually being moved between the 2 teams over and over. I've tried turning all the Top Player monitoring and adding those players to the auto assist list but it keeps doing it. Doesn't even bother if the player is in teamspeak or not it still moves them multiple times in one round.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  nbtc971* said:

I just want something that monitors baseraping.. are you saying your plugin doesn't do that any longer? If so, is there a good baserape plugin?

You can turn on posting of win/loss/baserape statistics and it will post those to the database. It looks at the top 10% of the baseraping team. I would just not suggest using the system to act on that info.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

What should I do with this code?

Run it on your database.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  wdfstryfe* said:

I have a strange thing that's occurring since I started over with a new database. Basically during the round the top players and continually being moved between the 2 teams over and over. I've tried turning all the Top Player monitoring and adding those players to the auto assist list but it keeps doing it. Doesn't even bother if the player is in teamspeak or not it still moves them multiple times in one round.

Putting someone on the auto-assist list basically means they will never win a round on your server again, it will move them a lot, use that list with caution. I added it mainly because i'm a masochist and don't like being on the winning team in metro, but if others want to use it they are free to do so.

 

When people are on the top player list they are excluded from all balance activities during a round. The only time it can switch them is if they join mid-round and it assigns them to the opposite team.

 

Which balancer are you using?

[ImportBot]

Originally Posted by wdfstryfe*:

 

  ColColonCleaner* said:

Putting someone on the auto-assist list basically means they will never win a round on your server again, it will move them a lot, use that list with caution. I added it mainly because i'm a masochist and don't like being on the winning team in metro, but if others want to use it they are free to do so.

 

When people are on the top player list they are excluded from all balance activities during a round. The only time it can switch them is if they join mid-round and it assigns them to the opposite team.

 

Which balancer are you using?

OH, Ok maybe I need to RTFM more. THe bad part is since it's a new database no one is on the top players list yet, I just see adkats moving the player. And I'm using MULTIbalancer.

[ImportBot]

Originally Posted by wdfstryfe*:

 

  wdfstryfe* said:

OH, Ok maybe I need to RTFM more. THe bad part is since it's a new database no one is on the top players list yet, I just see adkats moving the player. And I'm using MULTIbalancer.

I think I found what I did. I set my 2 admin groups to Auto Assist Blacklist - Assign.

[ImportBot]

Originally Posted by wdfstryfe*:

 

Maybe I didn't fix it.

 

[15:44:29] AdKats > Say > PLAYER > Swapping you from team Russian Army to team US Army

[15:44:29] AdKats > Say > PLAYER, thank you for assisting US Army!

 

I see nothing on the multibalancer side that asked for a swap, adkats just did it to do it.

[ImportBot]

Originally Posted by EntraVenuS*:

 

  wdfstryfe* said:

Maybe I didn't fix it.

 

[15:44:29] AdKats > Say > PLAYER > Swapping you from team Russian Army to team US Army

[15:44:29] AdKats > Say > PLAYER, thank you for assisting US Army!

 

I see nothing on the multibalancer side that asked for a swap, adkats just did it to do it.

i had this problem i had this to allow

 

 

took it off and all seems well

[ImportBot]

Originally Posted by wdfstryfe*:

 

adkats_settings.JPG

 

All the settings are turned off so I don't know what's moving people back and forth.