Jump to content

Advanced In-Game Admin and Ban Enforcer - AdKats

ColColonCleaner

By ColColonCleaner
in Plugins

Prophet731
Message added by Prophet731,

If you've been banned from a server then you will need to appeal the ban with the owners/community of that server. We do not control any bans done on servers that utilize AdKats as all bans are local to that server.

Recommended Posts

  • Replies 8k
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Prophet731
Prophet731

I did a increase on the limit and pushed it up. You can get the updated minor version here..  

maddog
maddog

Thanks for all your help on this, with the def being correct, then the live HSK should not have triggered a sniper rifle? Could be anything to do with my post below and github? I have seen someone els

Hedius
Hedius

LOL. just lol. this has nothing to do with your procon version. The connection from your server to github fails. This is neither related to the plugin nor to procon.

Posted Images

ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by kcuestag*:

 

Can anyone else confirm when Adkats detects the database is down and then the connection is restored that the "Enable Live Scoreboard in DB" option is automatically disabled?

That happened to me yesterday, the web stats stopped working until I noticed that.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by Backapcker*:

 

hi,

 

after release 2nd assault we got an error on adkats. when we want to nuke the russian-team we type: !nuke rus answer from adkats: nuke us?

same when we wrote: russian.

 

best regards

 

Backpacker

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by tbird412*:

 

Getting these errors ever since the update ...

 

[10:36:02 64] UltimateMapManager: WORK -> Level loaded. Setting server preset to Normal.

[10:36:14 40] [AdKats] Enabled! Beginning startup sequence...

[10:36:14 40] [AdKats] Waiting a few seconds for requirements and other plugins to initialize, please wait...

[10:36:19 56] [AdKats] SUCCESS: Server IP is 108.61.100.72:30000!

[10:36:19 91] [AdKats] Attempting database connection. Attempt 1 of 5.

[10:36:19 93] [AdKats] SUCCESS: Database connection open.

[10:36:20 96] [AdKats] SUCCESS: Database confirmed functional for AdKats use.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:22 77] [AdKats] SUCCESS: Database Server Info Fetched. Server ID is 1!

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 50] [AdKats] EXCEPTION: Line 0: [FetchUserList][Error while fetching access list.]: MySql.Data.MySqlClient.MySqlException: Table 'c1071925_bf4stats.adkats_specialplayers' doesn't exist

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( )

at PRoConEvents.AdKats.FetchUserList()

[10:36:23 85] [AdKats] Running! Version: 4.1.0.0

* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer
ColColonCleaner Advanced Member

ColColonCleaner

Posted
  • Author
  • Plugin Developer
Posted

Originally Posted by ColColonCleaner*:

 

hi,

 

after release 2nd assault we got an error on adkats. when we want to nuke the russian-team we type: !nuke rus answer from adkats: nuke us?

same when we wrote: russian.

 

best regards

 

Backpacker

Please read the documentation. Nuke is either us, ru, cn, or all. You are typing in rus which contains both ru, and us, which is confusing the system.
Link to comment
  • Plugin Developer
ColColonCleaner Advanced Member

ColColonCleaner

Posted
  • Author
  • Plugin Developer
Posted

Originally Posted by ColColonCleaner*:

 

Can anyone else confirm when Adkats detects the database is down and then the connection is restored that the "Enable Live Scoreboard in DB" option is automatically disabled?

Strange. The only thing i call for stat logger on db disconnect is disable, then enable once connection is restored. I'll look into it.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by JR8355*:

 

Can anyone else confirm when Adkats detects the database is down and then the connection is restored that the "Enable Live Scoreboard in DB" option is automatically disabled?

confirmed, also my web admin live scoreboard has stopped working, no updates
* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer
ColColonCleaner Advanced Member

ColColonCleaner

Posted
  • Author
  • Plugin Developer
Posted

Originally Posted by ColColonCleaner*:

 

Any ideas why this is happening? ->

 

The player says he is banned, when he's not... :huh:

First, have you updated to 4.1? If not, do that, this is related to an issue that was fixed.

 

Then to repair what the issue caused in 4.0 run this:

 

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)
);
The player might be getting an enforce ban because his account is being linked to a banned player's account by the database. If this is working incorrectly I will need to look further.

 

This is why i wish i had more testers :sad:, as soon as a full release happens obscure bugs start to surface.

Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by TMiland*:

 

First, have you updated to 4.1? If not, do that, this is related to an issue that was fixed.

 

Then to repair what the issue caused in 4.0 run this:

 

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)
);
The player might be getting an enforce ban because his account is being linked to a banned player's account by the database. If this is working incorrectly I will need to look further.

 

This is why i wish i had more testers :sad:, as soon as a full release happens obscure bugs start to surface.

I have updated to 4.1, yesterday morning. :smile:

 

I haven't done the above sql query before, and the upgrade sql query was the same as i got from you earlier or no? :tongue:

 

When i ran:

Code: 

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;
I got this error:

Code: 

#1005 - Can't create table 'nbfc_bf4log.#sql-dc7_36d48' (errno: 121)
* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer
ColColonCleaner Advanced Member

ColColonCleaner

Posted
  • Author
  • Plugin Developer
Posted

Originally Posted by ColColonCleaner*:

 

I have updated to 4.1, yesterday morning. :smile:

 

I haven't done the above sql query before, and the upgrade sql query was the same as i got from you earlier or no? :tongue:

 

When i ran:

Code: 

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;
I got this error:

Code: 

#1005 - Can't create table 'nbfc_bf4log.#sql-dc7_36d48' (errno: 121)
So many people are getting that error when running the update...

 

It doesn't stop the program from working when the error happens, but i'm wondering why it's happening. That error means the foreign key you are trying to add already exists...which should only happen if you accidentally run it twice. I've tried to replicate the error on my machines, and it only happens when i do it twice.

 

But yes, run that fix query then have that player attempt to join again. If the enforce ban record has "LINKED ACCOUNT *some ID here*" in it, then it's the linked account system keeping him out.

Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by TMiland*:

 

So many people are getting that error when running the update...

 

It doesn't stop the program from working when the error happens, but i'm wondering why it's happening. That error means the foreign key you are trying to add already exists...which should only happen if you accidentally run it twice. I've tried to replicate the error on my machines, and it only happens when i do it twice.

 

But yes, run that fix query then have that player attempt to join again. If the enforce ban record has "LINKED ACCOUNT *some ID here*" in it, then it's the linked account system keeping him out.

Okay, thanks for clearing that up. :smile:

 

I'll check if he has gotten in or not tomorrow. :smile:

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by _CH_KeyserSoze*:

 

Definitely a problem with the webadmin live scoreboard..The "Enable live Scoreboard in DB" will not stay on. I turn it on for all our servers and within a minute it shuts off again. The started after upgrading Adkats. Though this maybe something with stats logger but I haven't made any changes to that.

* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer
ColColonCleaner Advanced Member

ColColonCleaner

Posted
  • Author
  • Plugin Developer
Posted

Originally Posted by ColColonCleaner*:

 

Definitely a problem with the webadmin live scoreboard..The "Enable live Scoreboard in DB" will not stay on. I turn it on for all our servers and within a minute it shuts off again. The started after upgrading Adkats. Though this maybe something with stats logger but I haven't made any changes to that.

Just to keep my sanity on this....do you all have "Feed stat logger settings" set to True? Because if you do, yes those settings will be changed. If that is set to true, then set it to false, turn enable live scoreboard in DB on in stat logger, then tell me if the issue continues.

 

EDIT: If this does end up resolving the issue, then i will remove the "Enable live Scoreboard in DB" "False" setting feed.

Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by _CH_KeyserSoze*:

 

It was set to true and had been even before the update with no issues. I have now set it to false and enabled live scoreboard in Statslogger. It is sticking on yes now, However..No live scoreboard. Chat is feeding to webmin properly

* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer
ColColonCleaner Advanced Member

ColColonCleaner

Posted
  • Author
  • Plugin Developer
Posted

Originally Posted by ColColonCleaner*:

 

It was set to true and had been even before the update with no issues. I have now set it to false and enabled live scoreboard in Statslogger. It is sticking on yes now, However..No live scoreboard. Chat is feeding to webmin properly

Yes, in 4.1 the variables fed to stat logger changed. I will modify them so they do not impede your live DB settings.

 

The live scoreboard issues is on our end as well, and unfortunately i do not control/develop that element, that is prophet's domain. We are waiting on him to fix it on our end as well.

Link to comment
  • Plugin Developer
ColColonCleaner Advanced Member

ColColonCleaner

Posted
  • Author
  • Plugin Developer
Posted

Originally Posted by ColColonCleaner*:

 

Loaded up, see version 4.1.0.4, no joy on Live Scoreboard :sad:

Like i said, live scoreboard is not under my control. I'm not sure why it is not working, but i am not the developer of that component.

 

The live scoreboard is a direct RCON link to the server just like procon is, it does not rely on the live scoreboard in the database to function, something else is making it malfunction.

Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by JR8355*:

 

Like i said, live scoreboard is not under my control. I'm not sure why it is not working, but i am not the developer of that component.

 

The live scoreboard is a direct RCON link to the server just like procon is, it does not rely on the live scoreboard in the database to function, something else is making it malfunction.

Well nothing has changed since 4.0.0.0, worked fine then, then updated to the new version and now it doesn't.
* Restored post. It could be that the author is no longer active.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing


×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.