Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Chelrid*:

 

hey, it this is a bug?

 

everytimes i change a rolesetting for the groups the client jumps after changing the setting for the commands to the top of the list.

 

this is not very productive because i want change many settings for the groups and have to scroll down every times.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Chelrid* said:

hey, it this is a bug?

 

everytimes i change a rolesetting for the groups the client jumps after changing the setting for the commands to the top of the list.

 

this is not very productive because i want change many settings for the groups and have to scroll down every times.

Use the setting section selector at the top of the settings page.

 

There is nothing I can do about how the setting window operates. I dynamically change some visual setting names to provide more info to the user, but that can cause it to throw you back to the top of the setting window.

 

The selector at least lets you stay in the section you are currently working on.

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

 

Give me please MySQL query for cleaning "Monitor/Disperse Top Players"

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

@ColColonCleaner

 

Give me please MySQL query for the cleaning "Monitor/Disperse Top Players"

For those of you running the top player monitor, are you also noticing squad issues/autokilling at round end? If so i need to work on that.

 

But to your question, to clear that out correctly, you need to clear entries on the adkats_statistics table.

 

DELETE FROM adkats_statistics WHERE stat_type IN ('player_win', 'player_loss', 'player_top', 'player_baserape')

 

That will completely reset all stats from the top player monitor. You cannot just delete player_top entries.

[ImportBot]

Originally Posted by Dete96*:

 

  ColColonCleaner* said:

For those of you running the top player monitor, are you also noticing squad issues/autokilling at round end? If so i need to work on that.

 

But to your question, to clear that out correctly, you need to clear entries on the adkats_statistics table.

 

DELETE FROM adkats_statistics WHERE stat_type IN ('player_win', 'player_loss', 'player_top', 'player_baserape')

 

That will completely reset all stats from the top player monitor. You cannot just delete player_top entries.

We had the issue, too. But since .110 everything is normal again. Thank you for the fast fix.

 

A few days ago I setup the TS monitor. After a restart it usually works fine, but after an hour or so it stops working. Do you have any idea or already have heard of this problem?

 

Thank you!

[ImportBot]

Originally Posted by killengage*:

 

I'm sometimes getting these messages:

 

WARNING: Unable to find source weight for command 20|61

 

According @prophet, there have to be some changes in the reputation values as stated here ?

 

Prophets forum link: LINK

[ImportBot]

Originally Posted by Hodor*:

 

  ColColonCleaner* said:

For those of you running the top player monitor, are you also noticing squad issues/autokilling at round end? If so i need to work on that.

 

But to your question, to clear that out correctly, you need to clear entries on the adkats_statistics table.

 

DELETE FROM adkats_statistics WHERE stat_type IN ('player_win', 'player_loss', 'player_top', 'player_baserape')

 

That will completely reset all stats from the top player monitor. You cannot just delete player_top entries.

DELETE FROM adkats_statistics WHERE stat_type IN ('player_win', 'player_loss', 'player_top', 'player_baserape');

 

You forgot to add ;

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

DELETE FROM adkats_statistics WHERE stat_type IN ('player_win', 'player_loss', 'player_top', 'player_baserape');

 

You forgot to add ;

Single statements can be run in MySQL without semicolons.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Dete96* said:

We had the issue, too. But since .110 everything is normal again. Thank you for the fast fix.

 

A few days ago I setup the TS monitor. After a restart it usually works fine, but after an hour or so it stops working. Do you have any idea or already have heard of this problem?

 

Thank you!

I cannot do testing on the teamspeak monitor, I don't have any active TS server I can test it on. I would suggest making sure your TS server is not killing the connection. The base code is the same as Imisnew2's teamspeak plugin, so it should operate the same.

 

Any error messages?

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

 

When you will add this? https://github.com/AdKats/AdKats/issues/894

[ImportBot]

Originally Posted by Dete96*:

 

  ColColonCleaner* said:

I cannot do testing on the teamspeak monitor, I don't have any active TS server I can test it on. I would suggest making sure your TS server is not killing the connection. The base code is the same as Imisnew2's teamspeak plugin, so it should operate the same.

 

Any error messages?

It worked for about 5 hours yesterday. The days it stopped working I didn´t see any error messages. So as a workaround I will just stop and restart adkats every few hours... Or maybe just the TS monitor and not the whole plugin?

 

Thank you anyway for this great tool!

[ImportBot]

Originally Posted by EntraVenuS*:

 

oo this is an error im running 6.8.1.111

 

 

 

 

[17:07:33 32] [AdKats] SELECT

`InnerResults`.*,

ROUND(`top_count`/REPLACE(`round_count`, 0, 1), 2) AS `top_round_ratio`

FROM

(

SELECT

`server_id` AS `server`,

`target_id` AS `player_id`,

`target_name` AS `player_name`,

(SELECT

COUNT(`stat_id`)

FROM

`adkats_statistics`

WHERE

`server_id` = `server`

AND

`target_id` = `player_id`

AND

`stat_time` > DATE_SUB(UTC_TIMESTAMP, INTERVAL 86400 MINUTE)

AND

(

`stat_type` = 'player_win'

OR

`stat_type` = 'player_loss'

)) AS `round_count`,

(SELECT

COUNT(`stat_id`)

FROM

`adkats_statistics`

WHERE

`server_id` = `server`

AND

`target_id` = `player_id`

AND

`stat_time` > DATE_SUB(UTC_TIMESTAMP, INTERVAL 86400 MINUTE)

AND

`stat_type` = 'player_top') AS `top_count`

FROM

`adkats_statistics`

WHERE

`server_id` = 4

AND

`stat_type` = 'player_top'

GROUP BY

`target_id`, `server_id`

ORDER BY

`top_count` DESC

) AS `InnerResults`

WHERE

`top_count` >= 3

AND

`top_count`/REPLACE(`round_count`, 0, 1) >= 0.55

ORDER BY

`top_round_ratio` DESC,

`player_name` ASC

LIMIT 6000

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

@ColColonCleaner

 

When you will add this? https://github.com/AdKats/AdKats/issues/894

The latest test versions should already be allowing squads to stay together. I haven't had much time to monitor testing of it though.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  EntraVenuS* said:

oo this is an error im running 6.8.1.111

Is there another error next to that one? Just the query itself doesn't help much, it's useful once i know the error message.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Timm* said:

Hello.

 

How i can delete Autobalance whitelist Verbouse players?

Attachment 4367

 

them there 320 people, I do not know how they got there, at least the majority of them

 

I use TeamSpeak monitor settings, and enabled perk "Autobalance" may be they join to our TS, but nevertheless, how to clear the list?

many of them probably once join to TS, and got autobalance protect.

You have the top player monitor enabled. This system takes control of those players away from multibalancer, which means they are whitelisted from the other plugin. They are still being balanced, just not by multibalancer.

[ImportBot]

Originally Posted by Hodor*:

 

  ColColonCleaner* said:

The latest test versions should already be allowing squads to stay together. I haven't had much time to monitor testing of it though.

Okay should it work on 6.8.1.111? And what about things that I added in the commentary? It will be implemented in the future?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

Okay should it work on 6.8.1.111? And what about things that I added in the commentary? It will be implemented in the future?

It may not need to be once the base functionality works as intended.

[ImportBot]

Originally Posted by leandro-motta*:

 

ColColonCleaner takes me one doubt I updated to the latest version AdKats - Advanced In-Game Admin - 6.8.1.111 and is giving this message: [AdKats] SUCCESS: SQL Update 'fixEmptyPlayerIPs' completed execution (Fixed empty player PIs). every 5 minutes would have to remove this message.

[ImportBot]

Originally Posted by EntraVenuS*:

 

  ColColonCleaner* said:

Is there another error next to that one? Just the query itself doesn't help much, it's useful once i know the error message.

there wasnt an error message but i got an extra line on the bottom of the code when it happend again

 

[07:28:43 33] [AdKats] SELECT

`InnerResults`.*,

ROUND(`top_count`/REPLACE(`round_count`, 0, 1), 2) AS `top_round_ratio`

FROM

(

SELECT

`server_id` AS `server`,

`target_id` AS `player_id`,

`target_name` AS `player_name`,

(SELECT

COUNT(`stat_id`)

FROM

`adkats_statistics`

WHERE

`server_id` = `server`

AND

`target_id` = `player_id`

AND

`stat_time` > DATE_SUB(UTC_TIMESTAMP, INTERVAL 86400 MINUTE)

AND

(

`stat_type` = 'player_win'

OR

`stat_type` = 'player_loss'

)) AS `round_count`,

(SELECT

COUNT(`stat_id`)

FROM

`adkats_statistics`

WHERE

`server_id` = `server`

AND

`target_id` = `player_id`

AND

`stat_time` > DATE_SUB(UTC_TIMESTAMP, INTERVAL 86400 MINUTE)

AND

`stat_type` = 'player_top') AS `top_count`

FROM

`adkats_statistics`

WHERE

`server_id` = 4

AND

`stat_type` = 'player_top'

GROUP BY

`target_id`, `server_id`

ORDER BY

`top_count` DESC

) AS `InnerResults`

WHERE

`top_count` >= 3

AND

`top_count`/REPLACE(`round_count`, 0, 1) >= 0.55

ORDER BY

`top_round_ratio` DESC,

`player_name` ASC

LIMIT 6000

[07:28:43 33] [AdKats] Attempted to handle database timeout when threads not running.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  EntraVenuS* said:

there wasnt an error message but i got an extra line on the bottom of the code when it happend again

 

 

[07:28:43 33] [AdKats] Attempted to handle database timeout when threads not running.

Uh, how long has your layer been online for?

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

 

Tell me how do it work? If true - Top Player Monitor will not touch the VIP players?

9feb6db686.jpg

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

@ColColonCleaner

 

Tell me how do it work? If true - Top Player Monitor will not touch the VIP players?

9feb6db686.jpg

That list does not do anything at this time, dev is in process.

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

 

Is it joke with Top Players Monitor? Why in the end of the round, he began to split all squads? - wrong way! For this I have had scramble by RoundScore with Keep squads together (multibalancer)

 

[ImportBot]

Originally Posted by itsteve*:

 

  Locheed* said:

Any ideas why Adkat is spamming "Adkatsinstancecheck..." text to Rconnet's chat? Didn't find any info about it. :/

Hi I'm getting this as well is appearing as a chat in the server is there a way to switch it off ?

 

Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2367

2016-06-06 13:37:52 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2336

2016-06-06 13:37:22 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2306

2016-06-06 13:36:51 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2275

2016-06-06 13:36:20 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2244

2016-06-06 13:35:50 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2214

2016-06-06 13:35:19 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2183

2016-06-06 13:34:49 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2153

2016-06-06 13:34:18 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2122

2016-06-06 13:33:48 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2091

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

@ColColonCleaner

 

Is it joke with Top Players Monitor? Why in the end of the round, he began to split all squads? - wrong way! For this I have had scramble by RoundScore with Keep squads together (multibalancer)

 

Still in development. I could move the removal of squads to during level load instead of immediately at round end.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  itsteve* said:

Hi I'm getting this as well is appearing as a chat in the server is there a way to switch it off ?

 

Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2367

2016-06-06 13:37:52 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2336

2016-06-06 13:37:22 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2306

2016-06-06 13:36:51 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2275

2016-06-06 13:36:20 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2244

2016-06-06 13:35:50 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2214

2016-06-06 13:35:19 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2183

2016-06-06 13:34:49 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2153

2016-06-06 13:34:18 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2122

2016-06-06 13:33:48 - Chat Server to all: /AdKatsInstanceCheck VioNJikkBBwkB05OSw0MAlJBN1BaOzoTQTk2QgE7Llo= 2091

Issue #910 funded to add an option to disable instance checks.

[ImportBot]

Originally Posted by Hodor*:

 

  ColColonCleaner* said:

Still in development. I could move the removal of squads to during level load instead of immediately at round end.

The problem is that you often do not give your users a choice.. Maybe in the future I want to turn it off, but you did not do this function (true/false)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

The problem is that you often do not give your users a choice.. Maybe in the future I want to turn it off, but you did not do this function (true/false)

Top Player Monitor - Enable/Disable

[ImportBot]

Originally Posted by Hodor*:

 

  ColColonCleaner* said:

Top Player Monitor - Enable/Disable

Haha

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

  Hodor* said:

Haha

No i mean seriously, it's a feature still in development. If something isn't going the way you like it, tell me about it, disable it, and we can move from there.

 

Before these recent changes it destroyed squads no matter what. I'm looking to stop that from happening. And i don't mean removing them at round end and rebuilding them at the start of next round, that's, for the most part, intended. Just need to get the timings correct.