Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by WhiteSammy*:

 

You can't create a command but you can do a mysql query for how many times it's been used. What command are you trying to track?

I want to make my own command such as on Twitch where it keep a log of how many times a command has been used in chat.

 

If i cannot make a command that also tracks how many times it has been used then i was clearly lied to.

 

9c1juNC.png

[Prophet731]

Originally Posted by Prophet731*:

 

I want to make my own command such as on Twitch where it keep a log of how many times a command has been used in chat.

 

If i cannot make a command that also tracks how many times it has been used then i was clearly lied to.

 

9c1juNC.png

No you weren't lied to. AdKats stores everything in a database so you can easily get the count of how many times a command has been issued. AdKats itself, as far as "!count kills" doesn't have anything like that nor would I think colon would add that.

 

Run this query on your database. It will count up all the results for each command.

 

Code:

SELECT
  adkats_commands.command_name AS 'Command',
  FORMAT(COUNT(adkats_records_main.record_id), 0) AS Total
FROM adkats_records_main
  INNER JOIN adkats_commands
    ON adkats_records_main.command_type = adkats_commands.command_id
WHERE `adkats_commands`.`command_active` = 'Active'
GROUP BY adkats_records_main.command_type

[ImportBot]

Originally Posted by WhiteSammy*:

 

Still doesn't have any "functionality" that allows me to make my own command with a simple text response with a built in counter like i was able to do with ProconRulz.

 

All I need is a way to keep it persistent.

 

EDIT: Just to make things clear, using proconrulz i can make a command to regurgitate words on command, that is not what i'm interested in.

[Prophet731]

Originally Posted by Prophet731*:

 

Still doesn't have any "functionality" that allows me to make my own command with a simple text response with a built in counter like i was able to do with ProconRulz.

 

All I need is a way to keep it persistent.

 

EDIT: Just to make things clear, using proconrulz i can make a command to regurgitate words on command, that is not what i'm interested in.

I'm not understanding what you're trying to accomplish here?

[ImportBot]

Originally Posted by Jamesonp*:

 

We are having a problem with adding new admins and them not being linked to their player IDs:

 

 

I know for sure that xGravy9 is in the server right now and has an ID of 969

 

Edit:

 

So I manually attempted to add the entry for xGravy9 in adkats_usersoldiers and got:

 

#1062 - Duplicate entry '85-969' for key 'PRIMARY'

and then it showed up in the table.

 

It's odd, it's like they are there but not displaying in the table till I manually attempt to add them.

 

Any ideas?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

You havent added their soldiers?

 

Add Soldier? --> Enter their IGN

 

[ImportBot]

Originally Posted by Jamesonp*:

 

I thought if it was the same name it automatically did it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I thought if it was the same name it automatically did it.

I can add that in... open an issue on github and ill add it

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

Updated. 4.0.9.10

 

Same database update script as 4.0.9.2.

 

Updated Source:

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

[ImportBot]

Originally Posted by Breakmaster*:

 

Hey,

 

Donate to an awesome Plugin Developer.

 

Best regards,

Breakmaster

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hey,

 

Donate to an awesome Plugin Developer.

 

Best regards,

Breakmaster

Thank you much!

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

All round bans added through procon now default to 1 hour temp bans if using ban enforcer.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

Updated. 4.0.9.12

 

Changes 4.0.9.10 -> 4.0.9.12

 

• Fixed major record update fault where in some cases debug record messages would overwrite main record messages of the same ID. This fault was introduced in 4.0.0.0 and was undetected until now.
• Added access to previously restricted Admin Assistant options.

• Admin assistants can now be disabled completely.
• AA's can now use the @admins command to get list of online admins.
• AA's when reporting are now told if there is an in-game admin looking at the reports.
• Trusted AA reports can now be acted on automatically by autoadmin.

• If the report message matches a specific list of trigger words, autoadmin will respond with a punish on the target player.
• If admins are in-game, a 45 second wait time is put on the automatic action. Admins can @accept, @deny, or @anyotheraction on the record and automatic action will cancel.
• This has been in testing for about a month on our servers and works very well.
• AA's and admins are protected from reports issued against them.

[*]Minor bugs fixed

Same database update script as 4.0.9.2.

 

Updated Source:

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

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

Updated. 4.0.9.13

 

Changes 4.0.9.12 -> 4.0.9.13

 

• Bug where name bans could fail on import for ban enforcer under certain conditions.

Same database update script as 4.0.9.2.

 

Updated Source:

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

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

With that last update all open tickets for 4.1.0.0 have been closed. If no new developments come in the next couple days 4.1.0.0 will be released publicly.

[ImportBot]

Originally Posted by mikedbom*:

 

i've been looking all over for the webadmin download but cant find it. unless its the one on the ADK website?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

i've been looking all over for the webadmin download but cant find it. unless its the one on the ADK website?

Correct, there is no download on this site for the webadmin. Download from the ADK website.

[ImportBot]

Originally Posted by Narf!*:

 

i've been looking all over for the webadmin download but cant find it. unless its the one on the ADK website?

Yep, it's the one on ADK. Current version is 1.4.2. You can grab it from here.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

To anyone who was noticing exception messages or server crash messages showing up in record messages or ban reasons please run the following query after you update to 4.1.0.0. The bug that caused this was fixed in 4.0.9.12

 

Code:

UPDATE    adkats_records_main
SET
    record_message = "Record Message Invalid"
WHERE 
    record_message <> "Record Message Invalid"
AND
(
    (command_action = 20 AND command_type <> 20)
    OR 
    (command_action = 35 AND command_type <> 35)
);

[ImportBot]

Originally Posted by mikedbom*:

 

Correct, there is no download on this site for the webadmin. Download from the ADK website.

registered to download but no confirmation email has arrived. checked spam/junk and resent validation. should i contact a forum admin?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

registered to download but no confirmation email has arrived. checked spam/junk and resent validation. should i contact a forum admin?

Our systems recently underwent a major update, so some things might still be in limbo. Did you try requesting it to resend the email?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

4.1.0.0 (14-FEB-2014)

 

Changes

 

• TeamSwap Auto-Whitelisting per round has been removed as an option.

Enhancements

 

• Added @accept and @deny, for acting on round reports. No actions against players will be taken when using these commands, they are for helping or hindering AA status for a player. A system coming currently under testing on our servers for automatic report actions will make use of this.
• Added @admins command Accessible to to admins and admin assistants by default. Returns the list of online admins in the server.
• Added @lead command Lead command will give the speaker leader of their current squad.
• Team Enhancements Team names are now detected every match, so factions US, RU, and CN for nuke and kickall now hit the correct team.
• Command Enhancements Target player names entered with 1 character will no longer be automatically acted on. Will require a confirm.
• Email Enhancements All emails sent through AdKats are now sent as blind carbon copy. Emails are now added to a queue when multiple need to be sent in succession.
• List Enhancements Added adkats_specialplayers database table. This table can be used for assigning special whitelists, access, and blacklists. Valid groups are currently slot_reserved, slot_spectator, whitelist_multibalancer, blacklist_dispersion, and whitelist_hackerchecker. Players can be added by ID, or by identifier (name, guid, or IP), and can be assigned, a game and server to apply the list to. If you use player IDs then you wont need to update player names if they change their names, the player names will automatically update when they join the server.
• Orchestration Enhancements Default In-Game Admin is automatically disabled when AdKats is running. Had some issues where people accidentally had both plugins running.
• User Enhancements Game type is now displayed for players connected to users. Add Soldier now checks across all games and fetches up to 10 matching player names. When adding a new user an automatic check for players of the same name is performed.
• Player Info Enhancements All custom messages in AdKats, when targeted at a player, player information string replacements will be parsed. e.g. %player_name%, or %player_id%
• Admin Assistant Enhancements Completely reconstructed system with previous private features released to the public. Also added grandfathering for Admin Assistants; >75 confirmed reports overall will also grant admin assistant status.
• MatchCommand Enhancements AdKats is now callable from other plugins like InsaneLimits for issuing commands and fetching current synced admin list.
• Ban Enforcer Enhancements All bans are now enforced on a server group basis. If a ban is issued on one server group, it will only be enforced on other servers in that server group. Added ban reason and banning admin name to mini-ban-management.
• Hacker-Checker Enhancements Added KPM check to hacker checker.
• Procon Ban Enhancements When using procon bans, the banning admin name is now added to the front of the reason.

Bugfixes

 

• Stability Some issues with thread deadlock injected in previous versions have been resolved.
• Commands All in-game commands are rejected with message during AdKats startup/reboot until full player list has been processed, this avoids killer/victim null case. Punishment timeout now blocks action, not just upload, matching spec. Kill-on-spawn for players now happens at the appropriate time, avoiding a previous double-kill issue. Players spamming @rules will no-longer spawn multiple rule printers. Rules command now shows the current rule # and total, e.g. (1/10)...(2/10)...etc...
• Ban Enforcer Linked accounts were causing ID issues with ban enforcer, this is now fixed. Name bans through Procon sometimes failed propagation, this has been fixed. Unsupported round bans caused permabans in ban enforcer since type was not recognized, this has been changed to 1 hour temp-ban.
• Records Logic hole where debug/exception record messages could overwrite main record messages of the same ID has been closed.
• Hacker-Checker Bug where hacker-checker mesh with BF3Stats was failing has been fixed.
• Chat All chat messages are now trimmed before handling, both before and after command prefix parsing.

Upgrade SQL from 4.0.0.0 to 4.1.0.0

Code:

REPLACE INTO `adkats_commands` VALUES(38, 'Active', 'self_admins', 'Log', 'Request Online Admins', 'admins', FALSE);
REPLACE INTO `adkats_commands` VALUES(39, 'Active', 'self_lead', 'Log', 'Lead Current Squad', 'lead', FALSE);
REPLACE INTO `adkats_commands` VALUES(40, 'Active', 'admin_accept', 'Log', 'Accept Round Report', 'accept', TRUE);
REPLACE INTO `adkats_commands` VALUES(41, 'Active', 'admin_deny', 'Log', 'Deny Round Report', 'deny', TRUE);
REPLACE INTO `adkats_commands` VALUES(42, 'Invisible', 'player_report_deny', 'Log', 'Report Player (Denied)', 'denyreport', TRUE);


CREATE TABLE IF NOT EXISTS `adkats_specialplayers`( 
  `specialplayer_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `player_group` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `player_id` int(10) UNSIGNED DEFAULT NULL,
  `player_game` tinyint(4) UNSIGNED DEFAULT NULL,
  `player_server` smallint(5) UNSIGNED DEFAULT NULL,
  `player_identifier` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`specialplayer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='AdKats - Special Player List';
ALTER TABLE `adkats_specialplayers`
  ADD CONSTRAINT `adkats_specialplayers_game_id` FOREIGN KEY (`player_game`) REFERENCES `tbl_games`(`GameID`) ON UPDATE NO ACTION ON DELETE CASCADE, 
  ADD CONSTRAINT `adkats_specialplayers_server_id` FOREIGN KEY (`player_server`) REFERENCES `tbl_server`(`ServerID`) ON UPDATE NO ACTION ON DELETE CASCADE, 
  ADD CONSTRAINT `adkats_specialplayers_player_id` FOREIGN KEY (`player_id`) REFERENCES `tbl_playerdata`(`PlayerID`) ON UPDATE NO ACTION ON DELETE CASCADE;

Install Instructions: https://github.com/ColColonCleaner/A...e-installation

[ImportBot]

Originally Posted by ixnorp*:

 

thanks!

 

[19:23:24 89] [AdKats] WARNING: CQTV01 auto-banned for KPM. [M98B-13.19-102-0]

 

that's fast.... The minute i turn on KPM checker, this guy got banned, look more like stat padding?

 

I don't see the special players list or hackerchecker whitelist in the plugin after i update?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

thanks!

 

[19:23:24 89] [AdKats] WARNING: CQTV01 auto-banned for KPM. [M98B-13.19-102-0]

 

that's fast.... The minute i turn on KPM checker, this guy got banned, look more like stat padding?

 

Btw C3, what happen to the hacker checker whitelist? I don't see it in the plugin anymore after i update.

https://github.com/ColColonCleaner/A...l-player-lists

 

The whitelist is now across all servers, you need to add your whitelisted players to the adkats_specialplayers table with the group whitelist_hackerchecker.

 

I dont have a UI control for that yet...

 

EDIT: and no, that's a legit ban. 100+ kills using a sniper rifle with 0 headshots at 13KPM is impossible.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Would like to see if someone else finds the new automation portions of the admin assistant system as useful as we have. https://github.com/ColColonCleaner/A...min-assistants

[ImportBot]

Originally Posted by ixnorp*:

 

https://github.com/ColColonCleaner/A...l-player-lists

 

The whitelist is now across all servers, you need to add your whitelisted players to the adkats_specialplayers table with the group whitelist_hackerchecker.

 

I dont have a UI control for that yet...

 

EDIT: and no, that's a legit ban. 100+ kills using a sniper rifle with 0 headshots at 13KPM is impossible.

my bad, I was just reading the doc when you replied. thanks!

 

 

C3, I wrote whitelist_hackerchecker at player_group, then i wrote the player id in the player id column, i still have to add in the player's name in player identifier?

 

I added only player id, the player still got banned by hacker checker, only when i add his name in the player identifier column then it worked.

[ImportBot]

Originally Posted by AgentHawk*:

 

Nice Update...

 

Quick question --> how can I disable this "[16:43:03 11] [AdKats] WARNING: Could not find m60-e4 in BF4 library of 64 weapons.

"

 

Debug level is "0"

 

Greetz

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Nice Update...

 

Quick question --> how can I disable this "[16:43:03 11] [AdKats] WARNING: Could not find m60-e4 in BF4 library of 64 weapons.

"

 

Debug level is "0"

 

Greetz

It gets removed once damage stats for the m60e4 are found. If someone links me a reliable source i'll add it right away.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

my bad, I was just reading the doc when you replied. thanks!

 

 

C3, I wrote whitelist_hackerchecker at player_group, then i wrote the player id in the player id column, i still have to add in the player's name in player identifier?

 

I added only player id, the player still got banned by hacker checker, only when i add his name in the player identifier column then it worked.

It should work by ID just as well if not better than by name... i'll look into it.

 

Also, identifier can be name, guid, or IP; Doesn't have to be just their name.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

my bad, I was just reading the doc when you replied. thanks!

 

 

C3, I wrote whitelist_hackerchecker at player_group, then i wrote the player id in the player id column, i still have to add in the player's name in player identifier?

 

I added only player id, the player still got banned by hacker checker, only when i add his name in the player identifier column then it worked.

I just checked again, and it works:

 

 

Debug level 2

 

[11:04:30 66] [AdKats] guneddown protected from hacker checker by database ID.

 

Perhaps you entered the wrong ID?