Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Ruger*:

 

It doesn't work at all, or are there only 15 in the list? Did you enable automatic spectator slot for admins?

It doesnt work at all. There are 8 Users. I have both Feed Server Spectator List and Automatic Spectator Slot For User Cache set to True. Actually cant even set the latter to False.

 

Today was the first time for me to set these. I originally had the player names set in the spectator list but when I turned on the above it cleared out all names.

[Prophet731]

Originally Posted by Prophet731*:

 

What steps did you make to set it up? I tried that guide in here somewhere, but most of the plugins didn't work when i tried a while back.

Followed those same steps but im on Mono JIT compiler version 3.2.8 (Debian 3.2.8+dfsg-4ubuntu1). The plugins compile fine.

[ImportBot]

Originally Posted by Chelrid*:

 

Run this, and PM me the result:

 

Code:

SELECT TABLE_NAME as table_name
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = theirschemaname
AND 
ENGINE <> 'InnoDB';

Result: #1054 - Unknown column 'theirschemaname' in 'where clause'

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Result: #1054 - Unknown column 'theirschemaname' in 'where clause'

Forgot to mention you need to put your database name in there

 

for example

 

 

TABLE_SCHEMA = 'MyAdKatsDatabase'

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

It doesnt work at all. There are 8 Users. I have both Feed Server Spectator List and Automatic Spectator Slot For User Cache set to True. Actually cant even set the latter to False.

 

Today was the first time for me to set these. I originally had the player names set in the spectator list but when I turned on the above it cleared out all names.

Strange, i'll look into it. I remember back when it was first implemented it worked, but the BF4 servers have a 15 player spectator whitelist limit for some reason, so it was never used. Maybe something changed from then till now.

[ImportBot]

Originally Posted by MadSochi*:

 

Query:

ALTER TABLE `adkats_rolecommands`

ADD CONSTRAINT `adkats_rolecommands_fk_role` FOREIGN KEY (`role_id`) REFERENCES `adkats_roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE,

ADD CONSTRAINT `adkats_rolecommands_fk_command` FOREIGN KEY (`command_id`) REFERENCES `adkats_commands` (`command_id`) ON DELETE CASCADE ON UPDATE CASCADE

 

Error occured at:2014-11-01 15:31:15

Line no.:521

Error Code: 1452 - Cannot add or update a child row: a foreign key constraint fails (`adkats`., CONSTRAINT `adkats_rolecommands_fk_command` FOREIGN KEY (`command_id`) REFERENCES `adkats_commands` (`command_id`) ON DELETE CASCADE)

[ImportBot]

Originally Posted by Chelrid*:

 

Run this, and PM me the result:

 

Code:

SELECT TABLE_NAME as table_name
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = theirschemaname
AND 
ENGINE <> 'InnoDB';

Code:

MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen). ( die Abfrage dauerte 0.0008 sek. )
SELECT TABLE_NAME AS table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 's577441'
AND
ENGINE <> 'InnoDB';

LIMIT 0 , 30

[ImportBot]

Originally Posted by TMiland*:

 

Spewing out these errors now: Code:

[14:52:44 74] [AdKats] EXCEPTION: Line Unknown: [DamageHackCheck][Error running DPS hack check]: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.AdKats.DamageHackCheck(AdKatsPlayer aPlayer, Boolean debugMode)

[ImportBot]

Originally Posted by SmackDown*:

 

Those commands feed the adkats_specialplayers table.

When I go into my database and look in the adkats_specialplayers table, this is what I see: "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec)"

 

I manually entered a player into the admin assistant file by entering the code aawhitelist and players name. It accepted the command but I cannot see his name in the special player table. Also, He filed a @player report and the report does not have AA next to his name. Also, if I enter his name manually, is he always an admin assistant or does it end after the match ends? (Actually, I entered the players name through Procon. When I reentered his name, it says that the matching player is already in the admin Assistant whitelist. So I assume that he is still an admin assistant regardless if the round ends or not, is that correct?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Code:

MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen). ( die Abfrage dauerte 0.0008 sek. )
SELECT TABLE_NAME AS table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 's577441'
AND
ENGINE <> 'InnoDB';

LIMIT 0 , 30

No results?

[ImportBot]

Originally Posted by Chelrid*:

 

No results?

yes. nothing.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Spewing out these errors now: Code:

[14:52:44 74] [AdKats] EXCEPTION: Line Unknown: [DamageHackCheck][Error running DPS hack check]: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.AdKats.DamageHackCheck(AdKatsPlayer aPlayer, Boolean debugMode)

Please enable plugin debugging and reboot your layer.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

yes. nothing.

Strange. Looking into it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

yes. nothing.

Try this version. It should fix your issue: https://raw.githubusercontent.com/Co...ter/adkats.sql

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

When I go into my database and look in the adkats_specialplayers table, this is what I see: "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec)"

 

I manually entered a player into the admin assistant file by entering the code aawhitelist and players name. It accepted the command but I cannot see his name in the special player table. Also, He filed a @player report and the report does not have AA next to his name. Also, if I enter his name manually, is he always an admin assistant or does it end after the match ends? (Actually, I entered the players name through Procon. When I reentered his name, it says that the matching player is already in the admin Assistant whitelist. So I assume that he is still an admin assistant regardless if the round ends or not, is that correct?

Ok, i'll see if i can test this later today.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Query:

ALTER TABLE `adkats_rolecommands`

ADD CONSTRAINT `adkats_rolecommands_fk_role` FOREIGN KEY (`role_id`) REFERENCES `adkats_roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE,

ADD CONSTRAINT `adkats_rolecommands_fk_command` FOREIGN KEY (`command_id`) REFERENCES `adkats_commands` (`command_id`) ON DELETE CASCADE ON UPDATE CASCADE

 

Error occured at:2014-11-01 15:31:15

Line no.:521

Error Code: 1452 - Cannot add or update a child row: a foreign key constraint fails (`adkats`., CONSTRAINT `adkats_rolecommands_fk_command` FOREIGN KEY (`command_id`) REFERENCES `adkats_commands` (`command_id`) ON DELETE CASCADE)

Try this version of the setup script: https://raw.githubusercontent.com/Co...ter/adkats.sql

[ImportBot]

Originally Posted by Chelrid*:

 

Try this version. It should fix your issue: https://raw.githubusercontent.com/Co...ter/adkats.sql

Update: The SQL Script worked without Error, but when i was enable AdKats in Procon the hole Layer crashed and was unreachable.

[ImportBot]

Originally Posted by Chelrid*:

 

Update: The SQL Script worked without Error, but when i was enable AdKats in Procon the hole Layer crashed and was unreachable.

Code:

[19:46:29 62] [AdKats] ENABLED! Beginning startup sequence...
[19:46:30 83] [AdKats] SUCCESS: Populated reputation dictionaries.
[19:46:30 94] [AdKats] SUCCESS: Populated group dictionaries.
[19:46:30 94] [AdKats] SUCCESS: Server IP is 5.101.165.101:30300
[19:46:31 03] [AdKats] SUCCESS: Database connection open.
[19:46:31 33] ProconRulz: JuliderBosss killed xXxNIgHtCorexXx with SMG U_Scorpion
[19:46:31 61] [AdKats] SUCCESS: Database confirmed functional for AdKats use.
[19:46:31 69] [AdKats] EXCEPTION: Line Unknown: [GetGlobalUTCTimestamp][Error while getting global UTC Timestamp]: System.ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value
   at System.DateTime.Add(Double value, Int32 scale)
   at PRoConEvents.AdKats.DateTimeFromEpochSeconds(Double epochSeconds)
   at PRoConEvents.AdKats.GetGlobalUTCTimestamp(DateTime& UTCTime)
[19:46:31 69] [AdKats] EXCEPTION: Line Unknown: [DatabaseCommunicationThreadLoop][Error occured in Database Comm thread. Skipping current loop.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at PRoConEvents.AdKats.HandleException(AdKatsException aException)
   at PRoConEvents.AdKats.GetGlobalUTCTimestamp(DateTime& UTCTime)
   at PRoConEvents.AdKats.TestDatabaseConnection()
   at PRoConEvents.AdKats.DatabaseCommunicationThreadLoop()
[19:46:31 69] [AdKats] EXCEPTION: Line Unknown: [DatabaseCommunicationThreadLoop][Error occured in database comm thread.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at PRoConEvents.AdKats.HandleException(AdKatsException aException)
   at PRoConEvents.AdKats.DatabaseCommunicationThreadLoop()
[19:47:08 52] [AdKats] SUCCESS: Database connection open.
[19:47:09 02] [AdKats] SUCCESS: Database confirmed functional for AdKats use.
[19:47:09 04] [AdKats] EXCEPTION: Line Unknown: [GetGlobalUTCTimestamp][Error while getting global UTC Timestamp]: System.ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value
   at System.DateTime.Add(Double value, Int32 scale)
   at PRoConEvents.AdKats.DateTimeFromEpochSeconds(Double epochSeconds)
   at PRoConEvents.AdKats.GetGlobalUTCTimestamp(DateTime& UTCTime)
[19:47:09 05] [AdKats] EXCEPTION: Line Unknown: [DatabaseCommunicationThreadLoop][Error occured in Database Comm thread. Skipping current loop.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at PRoConEvents.AdKats.HandleException(AdKatsException aException)
   at PRoConEvents.AdKats.GetGlobalUTCTimestamp(DateTime& UTCTime)
   at PRoConEvents.AdKats.TestDatabaseConnection()
   at PRoConEvents.AdKats.DatabaseCommunicationThreadLoop()
[19:47:09 05] [AdKats] EXCEPTION: Line Unknown: [DatabaseCommunicationThreadLoop][Error occured in database comm thread.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at PRoConEvents.AdKats.HandleException(AdKatsException aException)
   at PRoConEvents.AdKats.DatabaseCommunicationThreadLoop()

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Update: The SQL Script worked without Error, but when i was enable AdKats in Procon the hole Layer crashed and was unreachable.

Some people had this issue after the latest patch. Try this version: https://raw.githubusercontent.com/Co...ster/AdKats.cs

 

Getting all the kinks out before i push a new one.

[ImportBot]

Originally Posted by Chelrid*:

 

Some people had this issue after the latest patch. Try this version: https://raw.githubusercontent.com/Co...ster/AdKats.cs

 

Getting all the kinks out before i push a new one.

Seems to works.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Seems to works.

Great. Some people are having trouble with the global timing confirmation, and even with the DB time confirmation, so i needed to change how they worked.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

It doesnt work at all. There are 8 Users. I have both Feed Server Spectator List and Automatic Spectator Slot For User Cache set to True. Actually cant even set the latter to False.

 

Today was the first time for me to set these. I originally had the player names set in the spectator list but when I turned on the above it cleared out all names.

Ok, i found the issue. I'll post the update after i get a few more tickets done.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

When I go into my database and look in the adkats_specialplayers table, this is what I see: "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec)"

 

I manually entered a player into the admin assistant file by entering the code aawhitelist and players name. It accepted the command but I cannot see his name in the special player table. Also, He filed a @player report and the report does not have AA next to his name. Also, if I enter his name manually, is he always an admin assistant or does it end after the match ends? (Actually, I entered the players name through Procon. When I reentered his name, it says that the matching player is already in the admin Assistant whitelist. So I assume that he is still an admin assistant regardless if the round ends or not, is that correct?

I just tested it, at least with the latest version, and it works. I didn't change anything, to my knowledge anyway, so when i post the latest update just try that version.

[ImportBot]

Originally Posted by SmackDown*:

 

ok thx

[ImportBot]

Originally Posted by naurel*:

 

I might be dumb but weren't there a command like !help to list all command available for the man who's asking them ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I might be dumb but weren't there a command like !help to list all command available for the man who's asking them ?

Yes, it's !help

 

Read here: https://github.com/ColColonCleaner/AdKats#commands

[ImportBot]

Originally Posted by AgentHawk*:

 

any tips for DOM and the auto surrender?

 

my last rly unbalanced round was [23:41:49] AdKats > US Rate: -6.46 t/m | CN Rate: -48.32 t/m

 

Thanks

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

any tips for DOM and the auto surrender?

 

my last rly unbalanced round was [23:41:49] AdKats > US Rate: -6.46 t/m | CN Rate: -48.32 t/m

 

Thanks

I would suggest placing the values as follows:

 

min ticket gap: your choice, depending on your server's total ticket count. nothing less than 100, unless you're running like 200 ticket DOM.

winning max: 0

winning min: -10

losing max: -45

losing min: -100

trigger count: 3-5 depending on your findings

 

Play around with the values after a while and see if it's triggering too soon or too late.

[ImportBot]

Originally Posted by AgentHawk*:

 

we playing tdm and dom. - do you think that could be problems? (because one gametype is with + tickets and the other one with -)

 

Thy

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

we playing tdm and dom. - do you think that could be problems? (because one gametype is with + tickets and the other one with -)

 

Thy

Never run auto-surrender on mixed mode.

 

EDIT: To clarify, don't run it on mixed mode of the same ticket loss type, for example DOM and conquest, because they will be different values to trigger. Running it on DOM and TDM specifically shouldn't be an issue.