Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by HARDCOREBF*:

 

On ADK servers we run a modification of the hacker-checker, and I'm wondering if some people would want the mod released publicly...

 

Basically, for damage mod bans, and high level aimbot bans, we don't ban people right away, we wait a short amount of time. If you ban them right away, before they spawn, players have no idea the server is protecting them.

 

So, when a player who would be banned first spawns, we start a short timer. During that time the hacker can run around killing a few people with their damage mod or aimbot, and a few of them will notice it, then they see autoadmin ban the guy. Basically lets the server know the autoadmin is protecting them.

 

Anyone interested in this?

yes yes and one more time yesss . plz !!!!!

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Query for 5.2.4.9+, when setting B26 'Post Map Benefit/Detriment Statistics' is enabled.

 

Returns how beneficial certain maps are to your server's population.

 

map_benefit: The number of players that join the server from server level load, until the round ends. This is the time the map is visible on battlelog.

map_detriment: The number of players who leave once the next map is seen. It goes from server level load, until 2 minutes into the round.

 

These two values can be used to compare maps and see what players like.

 

Code:

SELECT 
	`InnerResults`.*,
	ROUND((`map_benefit` - `map_detriment`)/`map_rounds`, 2) AS `map_benefit_numeric`
FROM
(
SELECT
	`server_id` AS `server`,
	`tbl_server`.`ServerName` AS `server_name`,
	`target_name` AS `map_code`,
	(
		SELECT 
			count(`stat_id`)
		FROM 
			`adkats_statistics`
		WHERE
			`server_id` = `server`
		AND
			`target_name` = `map_code`
		AND
			`stat_type` = 'map_benefit'
	) AS `map_rounds`,
	(
		SELECT 
			SUM(`stat_value`)
		FROM 
			`adkats_statistics`
		WHERE
			`server_id` = `server`
		AND
			`target_name` = `map_code`
		AND
			`stat_type` = 'map_benefit'
	) AS `map_benefit`,
	(
		SELECT 
			SUM(`stat_value`)
		FROM 
			`adkats_statistics`
		WHERE
			`server_id` = `server`
		AND
			`target_name` = `map_code`
		AND
			`stat_type` = 'map_detriment'
	) AS `map_detriment`
FROM
	`adkats_statistics`
INNER JOIN
	`tbl_server`
ON
	`server_id` = `tbl_server`.`ServerID`
WHERE
	`stat_type` = 'map_benefit'
	OR
	`stat_type` = 'map_detriment'
GROUP BY
	`server_id`, `target_name`
) AS `InnerResults`
ORDER BY
	`InnerResults`.`server` ASC, `map_benefit_numeric` DESC;

Iam i missing something?

 

Error

SQL query: Documentation

 

 

SELECT

`InnerResults`.*,

ROUND((`map_benefit` - `map_detriment`)/`map_rounds`, 2) AS `map_benefit_numeric`

FROM

(

SELECT

`server_id` AS `server`,

`tbl_server`.`ServerName` AS `server_name`,

`target_name` AS `map_code`,

(

SELECT

count(`stat_id`)

FROM

`adkats_statistics`

WHERE

`server_id` = `server`

AND

`target_name` = `map_code`

AND

`stat_type` = 'map_benefit'

) AS `map_rounds`,

(

SELECT

SUM(`stat_value`)

FROM

`adkats_statistics`

WHERE

`server_id` = `server`

AND

`target_name` = `map_code`

AND

`stat_type` = 'map_benefit'

) AS `map_benefit`,

(

SELECT

SUM(`stat_value`)

FROM

`adkats_statistics`

WHERE

`server_id` = `server`

AND

`target_name` = `map_code`

AND

`stat_type` = 'map_detriment'

) AS `map_detriment`

FROM

`adkats_statistics`

INNER JOIN

`tbl_server`

ON

`server_id` = `tbl_server`.`ServerID`

WHERE

`stat_type` = 'map_benefit'

OR

`stat_type` = 'map_detriment'

GROUP BY

`server_id`, `target_n[...]

MySQL said: Documentation

 

#1146 - Table 'dgns.adkats_statistics' doesn't exist

[ImportBot]

Originally Posted by iraqiboy90*:

 

Issue

 

- The auto lock feature

 

Roles with no access to the lock command, when they issue for example a report on the player, the player will be locked.

Now, the second issue is: Why cannot another admin unlock a player using the unlock command?

[ImportBot]

Originally Posted by TMiland*:

 

I'll be adding a 'Useful Queries' section to the AdKats manual so some of the queries I run can be used by others.

 

Firstly, i updated the map statistics query for 5.2.5.2. It now contains a numeric for how helpful the map is when it's in your rotation, independent of how many rounds are played on it. Column map_benefit_numeric. Updated query will have the same performance as the previous.

 

Code:

SELECT 
	`InnerResults`.*,
	ROUND((`map_benefit` - `map_detriment`)/`map_rounds`, 2) AS `map_benefit_numeric`
FROM
(
SELECT
	`server_id` AS `server`,
	`tbl_server`.`ServerName` AS `server_name`,
	`target_name` AS `map_code`,
	(
		SELECT 
			count(`stat_id`)
		FROM 
			`adkats_statistics`
		WHERE
			`server_id` = `server`
		AND
			`target_name` = `map_code`
		AND
			`stat_type` = 'map_benefit'
	) AS `map_rounds`,
	(
		SELECT 
			SUM(`stat_value`)
		FROM 
			`adkats_statistics`
		WHERE
			`server_id` = `server`
		AND
			`target_name` = `map_code`
		AND
			`stat_type` = 'map_benefit'
	) AS `map_benefit`,
	(
		SELECT 
			SUM(`stat_value`)
		FROM 
			`adkats_statistics`
		WHERE
			`server_id` = `server`
		AND
			`target_name` = `map_code`
		AND
			`stat_type` = 'map_detriment'
	) AS `map_detriment`
FROM
	`adkats_statistics`
INNER JOIN
	`tbl_server`
ON
	`server_id` = `tbl_server`.`ServerID`
WHERE
	`stat_type` = 'map_benefit'
	OR
	`stat_type` = 'map_detriment'
GROUP BY
	`server_id`, `target_name`
) AS `InnerResults`
ORDER BY
	`InnerResults`.`server` ASC, `map_benefit_numeric` DESC;

We need a page for that in either the webadmin tool, or the stats page provided by Ty_ger07 or maybe both?

 

Sure, I can create a new special player group for that, and post the top 10 populators.

 

Two groups will be created.

 

statlist_populatorpastweek_top10

statlist_populatorpastweek_top10_users

 

The first will contain all players who have populated. The second will contain only players who are also on the user list, so admins and whatever other roles you've created.

 

All entries for these two groups will be overwritten in the db when the new ones are posted.

 

HOWEVER, i need to first update the special player table to accept groups longer than 30 characters.

As long as the specialplayers table works as before, i have just gotten the zero dates issue fixed, and i don't want another breakdown of the slots system!

 

Besides that, it sounds good.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Iam i missing something?

Yes, you're missing that version of the plugin. Test update to get the table that supports that query.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Issue

 

- The auto lock feature

 

Roles with no access to the lock command, when they issue for example a report on the player, the player will be locked.

Now, the second issue is: Why cannot another admin unlock a player using the unlock command?

First is a bug, which is now fixed.

Second, is the point of locking, only the locking admin (or the lock timing out) can unlock them.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Yes, you're missing that version of the plugin. Test update to get the table that supports that query.

ogh i see , sorry , i missed it some how , will go back and find it:smile:

[Prophet731]

Originally Posted by Prophet731*:

 

We need a page for that in either the webadmin tool, or the stats page provided by Ty_ger07 or maybe both?

That's actually why the query/table was made. It's going to be added to the bfacp

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Query for any version of AdKats after 5.0.0.0.

 

Selects the kill/kick/ban statistics for your servers, given as a percentage of your playerbase.

 

Code:

SELECT 
	COUNT(`PlayerID`) AS `UniquePlayers`,
	ROUND((
		SELECT 
			DISTINCT COUNT(`target_id`) 
		FROM 
			`adkats_records_main` 
		WHERE 
		(
			`command_action` = 3 or 
			`command_action` = 4 or 
			`command_action` = 5 or
			`command_action` = 54
		)
		AND
			`target_id` IS NOT NULL
	)/COUNT(`PlayerID`)*100, 3) AS `PercentageKilled`,
	ROUND((
		SELECT 
			DISTINCT COUNT(`target_id`) 
		FROM 
			`adkats_records_main` 
		WHERE 
		(
			`command_action` = 3 or 
			`command_action` = 4 or 
			`command_action` = 5 or
			`command_action` = 54
		)
		AND
		(
			`source_name` <> 'AutoAdmin'
		)
		AND
			`target_id` IS NOT NULL
	)/COUNT(`PlayerID`)*100, 3) AS `PercentageKilled_Admins`, 
	ROUND((
		SELECT 
			DISTINCT COUNT(`target_id`) 
		FROM 
			`adkats_records_main` 
		WHERE 
		(
			`command_action` = 6
		)
		AND
		(
			`source_name` <> 'AFKManager'
		)
		AND
			`target_id` IS NOT NULL
	)/COUNT(`PlayerID`)*100, 3) AS `PercentageKicked`, 
	ROUND((
		SELECT 
			DISTINCT COUNT(`target_id`) 
		FROM 
			`adkats_records_main` 
		WHERE 
		(
			`command_action` = 6
		)
		AND
		(
			`source_name` <> 'AFKManager'
			AND
			`source_name` <> 'AutoAdmin'
		)
		AND
			`target_id` IS NOT NULL
	)/COUNT(`PlayerID`)*100, 3) AS `PercentageKicked_Admins`,
	ROUND((
		SELECT 
			DISTINCT COUNT(`target_id`) 
		FROM 
			`adkats_records_main` 
		WHERE 
		(
			`command_action` = 7 or 
			`command_action` = 8 or 
			`command_action` = 72 or
			`command_action` = 73
		)
		AND
			`target_id` IS NOT NULL
	)/COUNT(`PlayerID`)*100, 3) AS `PercentageBanned`,
	ROUND((
		SELECT 
			DISTINCT COUNT(`target_id`) 
		FROM 
			`adkats_records_main` 
		WHERE 
		(
			`command_action` = 7 or 
			`command_action` = 8 or 
			`command_action` = 72 or
			`command_action` = 73
		)
		AND
		(
			`source_name` <> 'BanEnforcer'
			AND
			`source_name` <> 'AutoAdmin'
		)
		AND
			`target_id` IS NOT NULL
	)/COUNT(`PlayerID`)*100, 3) AS `PercentageBanned_Admins`,
	ROUND((
		SELECT 
			COUNT(`ban_id`) 
		FROM 
			`adkats_bans` 
		WHERE 
			`ban_status` = 'Active'
		AND
			`ban_endTime` > UTC_TIMESTAMP()
	)/COUNT(`PlayerID`)*100, 3) AS `PercentageBanned_Active`
FROM
	`tbl_playerdata`;

[ImportBot]

Originally Posted by iraqiboy90*:

 

First is a bug, which is now fixed.

Second, is the point of locking, only the locking admin (or the lock timing out) can unlock them.

Thanks for the fix.

[ImportBot]

Originally Posted by imcoolanj*:

 

the best game online believe me

try this http://gamerpussy.ga

[ImportBot]

Originally Posted by TMiland*:

 

That's actually why the query/table was made. It's going to be added to the bfacp

Hooah!

[ImportBot]

Originally Posted by 2GooDforU-FNO*:

 

Hello, me again .

Just wanted to tell you that I managed to install AdKats on all of my servers.

Even if I reinstalled procon layers, I think the only thing I had to do is , delete AdKats.cfg file and upload the new .cs file.

I still want to thank you once again ColColonCleaner for your help that day.

 

Best regards

2GooDforU-FNO-

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Hi , we have strange issue that when Auto AFK Enabled , system kicks players while they playing . And receiving multi reports on that , that players getting kicked for AFK . I disabled it for few days and no report then. Just wanted to let you know . For now sadly we have to disable this function . May be there is some outages with communicating with server , but everything else (commands etc )works very fast ...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi , we have strange issue that when Auto AFK Enabled , system kicks players while they playing . And receiving multi reports on that , that players getting kicked for AFK . I disabled it for few days and no report then. Just wanted to let you know . For now sadly we have to disable this function . May be there is some outages with communicating with server , but everything else (commands etc )works very fast ...

Is anyone else seeing this issue?

 

The AFK manager has been running for 3 months on our 8 servers without issue.

 

Have you modified the plugin source?

[ImportBot]

Originally Posted by HARDCOREBF*:

 

No , no mods were made . We running procon server on VM. But as sad adkats running flawlessly.. Just we noticed this afk problem...

 

 

Sent from my iPad using Tapatalk

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

No , no mods were made . We running procon server on VM. But as sad adkats running flawlessly.. Just we noticed this afk problem...

 

 

Sent from my iPad using Tapatalk

What is your time to afk kick?

[ImportBot]

Originally Posted by TMiland*:

 

Is anyone else seeing this issue?

 

The AFK manager has been running for 3 months on our 8 servers without issue.

 

Have you modified the plugin source?

No problems here.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

What is your time to afk kick?

Its 3 min . I gonna enable it and try debug , i hope to catch player who rejoins and report about this and ill see what is the output . Cs mostly they send masg via website , but i saw several asking "why i was kicked for AFK while playng "

 

00b9b2431d4c5904ac1b77293fd8cad9.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Its 3 min . I gonna enable it and try debug , i hope to catch player who rejoins and report about this and ill see what is the output . Cs mostly they send masg via website , but i saw several asking "why i was kicked for AFK while playng "

 

00b9b2431d4c5904ac1b77293fd8cad9.png

I detect score changes, spawns, kills, deaths, and chat messages as not being AFK. If none of those happen in the time slot, they are AFK. 3 minutes is very fast for an AFK kick on public servers.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

I detect score changes, spawns, kills, deaths, and chat messages as not being AFK. If none of those happen in the time slot, they are AFK. 3 minutes is very fast for an AFK kick on public servers.

Ok , ill increase it to 8 . but thing is , t hey say they got kicked for AFK while playing , i doubt score didnt changed in 3 min (was in Dom gamemode) , but you might be right , 3 min is fast . Ill keep you posted

[ImportBot]

Originally Posted by SmackDown*:

 

Is anyone else seeing this issue?

 

The AFK manager has been running for 3 months on our 8 servers without issue.

 

Have you modified the plugin source?

Working just fine for us.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I created an organization on Github for AdKats, and moved the repository ownership to that organization.

 

All links to ColColonCleaner/AdKats/? will still work, the redirect system they run is pretty in-depth, even for source and raw files too.

 

Org link: https://github.com/AdKats

 

Repo link: https://github.com/AdKats/AdKats

[ImportBot]

Originally Posted by wdfstryfe*:

 

[19:51:17 77] [AdKats] EXCEPTION: Line Unknown: [FetchIPLocation][Error while parsing IP response information.]: System.InvalidCastException: Unable to cast object of type 'System.Double' to type 'System.String'.

at PRoConEvents.AdKats.FetchIPLocation(String ip)

 

 

Getting this error ever since upgrading to the latest version.

[ImportBot]

Originally Posted by wdfstryfe*:

 

I've also noticed a lot of lag between the server and reports in the server. Is there anything new that has been written to the SQL in 5.2.2.5?

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

 

I have a server Locker on 32 slots and 800 tickets

"Auto-Surrender Use Optimal Values for Locker Conquest" - no good for me, too long to wait before starting AutoNuke, please help with the values, I would appreciate if you write that there put to Custom settings, thanks.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@ColColonCleaner

 

I have a server Locker on 32 slots and 800 tickets

"Auto-Surrender Use Optimal Values for Locker Conquest" - no good for me, too long to wait before starting AutoNuke, please help with the values, I would appreciate if you write that there put to Custom settings, thanks.

Which version are you running? Please update to the latest test version, there are some auto-surrender changes. It tells the trigger count left until auto-surrender fires to admins. Let me know if this helps.

[ImportBot]

Originally Posted by Hodor*:

 

Which version are you running? Please update to the latest test version, there are some auto-surrender changes. It tells the trigger count left until auto-surrender fires to admins. Let me know if this helps.

5.2.2.5

I do not quite understand at the Custom setting, there the numbers 999

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

5.2.2.5

I do not quite understand at the Custom setting, there the numbers 999

Please update to the latest test version, there are some auto-surrender changes. It tells the trigger count left until auto-surrender fires to admins. Let me know if this helps.

^^^

[ImportBot]

Originally Posted by Hodor*:

 

^^^

Where can I get a test version?