Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by 5YRU5*:

 

Hey ,

 

the key generator link for the admin cp doesn't work atm.

I opened a case on Github already but maybe you got access to it too ?

 

Thanks in advance.

 

Link: https://adkats.gamerethos.net/api/random_key

[ImportBot]

Originally Posted by sixpax12*:

 

Hey ,

 

the key generator link for the admin cp doesn't work atm.

I opened a case on Github already but maybe you got access to it too ?

 

Thanks in advance.

 

Link: https://adkats.gamerethos.net/api/random_key

Use any random key gen ... google 32 random key generator will pull up several.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hey ,

 

the key generator link for the admin cp doesn't work atm.

I opened a case on Github already but maybe you got access to it too ?

 

Thanks in advance.

 

Link: https://adkats.gamerethos.net/api/random_key

That key doesn't need to be generated by us, i think it just has to be a random base64 key that you keep secret once generated.

You can use sites like this to generate one: https://generate.plus/en/base64

[ImportBot]

Originally Posted by 5YRU5*:

 

That key doesn't need to be generated by us, i think it just has to be a random base64 key that you keep secret once generated.

You can use sites like this to generate one: https://generate.plus/en/base64

Thanks for your fast support. Then it's another problem I have to find out ^^

[ImportBot]

Originally Posted by TonyOffermans*:

 

Still have an issue with battlecries. If I set one for another player (setbattlecry) and want to remove it (setbattlecry soldiername with no text) it says I don't have any battlecries to remove. Same result when that player is online. I deleted the entries from the table but they persist, I take it I have to shut down AdKats before deleting then? And is there really no way to remove battlecries for other soldiers in-game?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Still have an issue with battlecries. If I set one for another player (setbattlecry) and want to remove it (setbattlecry soldiername with no text) it says I don't have any battlecries to remove. Same result when that player is online. I deleted the entries from the table but they persist, I take it I have to shut down AdKats before deleting then? And is there really no way to remove battlecries for other soldiers in-game?

Hmm, i'll give this a test tonight and see if I can replicate.

 

EDIT: Found the issue. Update to 7.5.0.51

 

https://github.com/AdKats/AdKats/com...64254dba7f0010

[ImportBot]

Originally Posted by tchum*:

 

Hi, is it possible to add a function to perma-mute some players ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi, is it possible to add a function to perma-mute some players ?

The best option right now is to have another system like proconrulz issue a /mute on a player when they first spawn into the game.

[ImportBot]

Originally Posted by sixpax12*:

 

myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry39160

 

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;

Another query: myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry39176

 

Looks like i never actually added that section to the manual with these queries.

Thanks !

[ImportBot]

Originally Posted by sixpax12*:

 

Any thoughts on why only once in a blue moon a report shows up on the BFACP in the section Reports when we get numerous reports everyday ? Not able to determine any differences between the ones that don't and the couple that have.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Any thoughts on why only once in a blue moon a report shows up on the BFACP in the section Reports when we get numerous reports everyday ? Not able to determine any differences between the ones that don't and the couple that have.

Perhaps you have it set to not send reports when admins are online in server? I don't know if the BFACP respects those settings but there is one for emails/discord etc that won't send reports if an admin is in the server. Perhaps your admins are seeding and it considers them online?

 

Other than that i'm not sure why.

[ImportBot]

Originally Posted by sixpax12*:

 

Perhaps you have it set to not send reports when admins are online in server? I don't know if the BFACP respects those settings but there is one for emails/discord etc that won't send reports if an admin is in the server. Perhaps your admins are seeding and it considers them online?

 

Other than that i'm not sure why.

Looks like I neglected to ever complete the Push Bullet settings ... many thanks.

[ImportBot]

Originally Posted by sixpax12*:

 

Is the token the APP ID, the KEY or the SECRET ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Looks like I neglected to ever complete the Push Bullet settings ... many thanks.

Are these pushbullet settings in AdKats or in the BFACP? Because i think the ones in AdKats are not used there, specifically the settings in section 8-2.

 

But if filling out those settings fixed your issue, that's great.

[ImportBot]

Originally Posted by sixpax12*:

 

I was referring to the settings in section 8.2 in Adkats ... the BFACFP push bullet settings are in the .ENV file ....

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I was referring to the settings in section 8.2 in Adkats ... the BFACFP push bullet settings are in the .ENV file ....

Yeah, those settings in AdKats are for custom pushbullet configurations, not related to the BFACP. Someone wanted notifications on their phone IIRC so they asked for pushbullet support. I don't think that's the source of your problem, might be something else. i'm not sure what it could be at the moment.

[ImportBot]

Originally Posted by sixpax12*:

 

Yeah, those settings in AdKats are for custom pushbullet configurations, not related to the BFACP. Someone wanted notifications on their phone IIRC so they asked for pushbullet support. I don't think that's the source of your problem, might be something else. i'm not sure what it could be at the moment.

ahh gotcha. will continue poking around. thank you for response.

[ImportBot]

Originally Posted by sixpax12*:

 

I am an idiot ... in adkats it is pushbullet ... in BFACP it is pusher ... two completely different things.

[ImportBot]

Originally Posted by TonyOffermans*:

 

So. CCC. I activated your 51 beta by !pupdate. THANKS! It works, I can now remove battlecries I have set for other players. One battlecry I left for one specific player may still cause an issue (player stuck in a move loop): https://cdn.discordapp.com/attachmen...44/unknown.png

Note that this player changed his soldiername before joining again, don't know if this may be of any importance. These messages lasted for a few seconds.

 

I also noticed today while trying to ban a cheater, it took about 30 seconds before my command was executed. This was a multihack cheater with invisibility, magic bullets, the works. Before and after that there was no delay. Never saw such delay before. Between the issuing and execute this cheater ragekilled 25 more players.....omg.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

So. CCC. I activated your 51 beta by !pupdate. THANKS! It works, I can now remove battlecries I have set for other players. One battlecry I left for one specific player may still cause an issue (player stuck in a move loop): https://cdn.discordapp.com/attachmen...44/unknown.png

Note that this player changed his soldiername before joining again, don't know if this may be of any importance. These messages lasted for a few seconds.

 

I also noticed today while trying to ban a cheater, it took about 30 seconds before my command was executed. This was a multihack cheater with invisibility, magic bullets, the works. Before and after that there was no delay. Never saw such delay before. Between the issuing and execute this cheater ragekilled 25 more players.....omg.

Those move loop messages are from AdKats fighting with your auto-balancer when you move a player with an admin command or they move themselves via !assist. Both plugins want the player to be on opposite teams so they fight over the player, but i made AdKats detect the loop and stop fighting. You can ignore those messages when they happen.

 

As for the delayed ban, in section 13-2 turn off BF4 lenient kick. In BF4 for people joining through the in-game client they can't see ban messages, why they were banned, so by default it spams them with say/yell messages before kicking them out of the server. But turning off that leniency will make it immediately eject them.

[ImportBot]

Originally Posted by TonyOffermans*:

 

Those move loop messages are from AdKats fighting with your auto-balancer when you move a player with an admin command or they move themselves via !assist. Both plugins want the player to be on opposite teams so they fight over the player, but i made AdKats detect the loop and stop fighting. You can ignore those messages when they happen.

 

As for the delayed ban, in section 13-2 turn off BF4 lenient kick. In BF4 for people joining through the in-game client they can't see ban messages, why they were banned, so by default it spams them with say/yell messages before kicking them out of the server. But turning off that leniency will make it immediately eject them.

Okido CCC, thanks. Extreme coincidence this message was regarding the only player (of 35.000) with an active battlecry. I immediately assumed it had something to do with it. BF4 lenient kick was already set to false, normally a ban is immediate (it is now too), but in this case I issued the command three times (different reason texts) and even tried banning via procon before the first command was in effect (perma ban message was shown with first reason text). Weird. Would not expect the hack to have such an impact on either server or layer performance.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Okido CCC, thanks. Extreme coincidence this message was regarding the only player (of 35.000) with an active battlecry. I immediately assumed it had something to do with it. BF4 lenient kick was already set to false, normally a ban is immediate (it is now too), but in this case I issued the command three times (different reason texts) and even tried banning via procon before the first command was in effect (perma ban message was shown with first reason text). Weird. Would not expect the hack to have such an impact on either server or layer performance.

Yeah, if procon itself wasn't able to kick them out properly then that's not something my plugin can handle either. We had a similar problem in BF3 where you were unable to kick players but that was from a glitch they abused with their player names where the name on the server side didn't match what was displayed in game so any name-driven commands you tried to issue against them would fail. On top of this they utilized a secondary glitch that let them connect to the server without a valid GUID so you couldn't ban them that way either. After those issues were patched though i haven't seen it, but there might be other newer hacks that have put in kick blocking.

[ImportBot]

Originally Posted by sixpax12*:

 

Is there a safe way to delete a particular soldier's record out of the database ? we have one that never can display anything properly in the dashboard ( blade errors ) and can't see anything different anywhere ... so thought maybe we could just blast him as though he never visited.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Is there a safe way to delete a particular soldier's record out of the database ? we have one that never can display anything properly in the dashboard ( blade errors ) and can't see anything different anywhere ... so thought maybe we could just blast him as though he never visited.

Run these, in order, with their player id, and you should be good.

 

delete from adkats_bans where player_id = ?

delete from adkats_records_debug where source_id = ?

delete from adkats_records_debug where target_id = ?

delete from adkats_records_main where source_id = ?

delete from adkats_records_main where target_id = ?

delete from tbl_playerdata where playerid = ?

[ImportBot]

Originally Posted by spatieman*:

 

ah, now this is more as use full !!!

thnxs for the tip CCC !

[ImportBot]

Originally Posted by sixpax12*:

 

Run these, in order, with their player id, and you should be good.

 

delete from adkats_bans where player_id = ?

delete from adkats_records_debug where source_id = ?

delete from adkats_records_debug where target_id = ?

delete from adkats_records_main where source_id = ?

delete from adkats_records_main where target_id = ?

delete from tbl_playerdata where playerid = ?

I completed the above with no issues shortly after you posted this. The offending player_id revisited a server a short time ago and somehow re-inherited the same player_id that was removed ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I completed the above with no issues shortly after you posted this. The offending player_id revisited a server a short time ago and somehow re-inherited the same player_id that was removed ?

Perhaps cached in the BFACP somewhere? Not sure how that could happen otherwise. Unless you kept your procon layers running while you deleted the records so they were still there in your running instance. If you did that delete without shutting down AdKats first it probably just realized something weird happened and re-loaded the player into the database.

[ImportBot]

Originally Posted by ty_ger07*:

 

The recommendation to stop the AdKats plugin (or the layer altogether) before making the change makes sense. But even if you already did that (or do that in the future), I have noticed that SQL servers seem to have a memory and refill old rows when similar data reappears, instead of starting a new auto-incremented row. In my experience, after deleting a row, a user with the same information, unexpectedly repopulated an old deleted row, while new users properly populated new auto-incremented rows as expected. Old deleted rows should normaly remain a gap in auto-incremented numbering instead of being filled back in. But it seems that something to do with the index caching causes auto-incrementing to stop working properly when the same information is given to the database which matches an old user/data which used to occupy a deleted row. In my experience, to avoid the oddity of the SQL server repopulating an old deleted auto-incremented row, after deleting the row(s) in the respective table(s), run the SQL optimize table query. That seems to take care of that problem. Optimizing the tables seems to clear the index cache and causes it to auto-increment new rows instead of re-filling old rows. The Optimize table process is real easy inside phpMyAdmin. You don't even need to know the SQL command(s). Just check-mark all tables, click the "with selected:" dropdown, and click Optimize table.

[ImportBot]

Originally Posted by sixpax12*:

 

The recommendation to stop the AdKats plugin (or the layer altogether) before making the change makes sense. But even if you already did that (or do that in the future), I have noticed that SQL servers seem to have a memory and refill old rows when similar data reappears, instead of starting a new auto-incremented row. In my experience, after deleting a row, a user with the same information, unexpectedly repopulated an old deleted row, while new users properly populated new auto-incremented rows as expected. Old deleted rows should normaly remain a gap in auto-incremented numbering instead of being filled back in. But it seems that something to do with the index caching causes auto-incrementing to stop working properly when the same information is given to the database which matches at old user/data which used to occupy a deleted row. In my experience, to avoid the oddity of the SQL server repopulating an old deleted auto-incremented row, after deleting the row(s) in the respective table(s), run the SQL optimize table query. That seems to take care of that problem. Optimizing the tables seems to clear the index buffer and causes it to auto-increment new rows instead of re-filling old rows. The Optimize table process is real easy inside phpMyAdmin. You don't even need to know the SQL command(s). Just check-mark all tables, click the "with selected:" dropdown, and click Optimize table.

most awesome info, thanks !

[ImportBot]

Originally Posted by keb2*:

 

hi

in the console are constantly warnings

[20:37:49 45] [AdKats] WARNING: Ahmed_AJ spawned without being in player list.

[20:37:49 55] [AdKats] WARNING: nikhilxx18 spawned without being in player list.

these warnings appear every second for different players.How to fix it?