Advanced In-Game Admin and Ban Enforcer - AdKats

ImportBot · May 17, 2015

Originally Posted by smogsy*:

i got a strange issue, you may be able to help me with

Player NEXUS-BOT was banned via procon before adkats was introduced

- Ban enforcer merged it across

- his never played with adkats enabled so has N/A for all information

- Mini-ban assistant shows 0 records for his ban across both servers

- when he joins he stays on for 2-3 minutes then gets kicked for the message that that ban enforcer indicated.

- tried editing bans in bfadmincp - no luck.

- check ban table & removed all bans on against his player ID

- no bans active in bfadmincp

- below is the line shown in commands issued & thats what he gets on kick,

Jan 14, 2015 6:34pm UTC BanEnforcer Anarchy UK #1 Conquest All Maps Permaban Player Previous Perm Ban WERE WARNED LAST TIME ABOUT UR BEHAVIOUR..PLEASE DONT COME BACK

not sure what to try next? to unban him he want to give him a second chance.

i was considering just wiping his player ID but i know it affects multiple tables.

if you cannot think of anything do you have a SQL query to wipe a player?

ColColonCleaner · May 17, 2015

Originally Posted by ColColonCleaner*:

i got a strange issue, you may be able to help me with

Player NEXUS-BOT was banned via procon before adkats was introduced

- Ban enforcer merged it across

- his never played with adkats enabled so has N/A for all information

- Mini-ban assistant shows 0 records for his ban across both servers

- when he joins he stays on for 2-3 minutes then gets kicked for the message that that ban enforcer indicated.

- tried editing bans in bfadmincp - no luck.

- check ban table & removed all bans on against his player ID

- no bans active in bfadmincp

- below is the line shown in commands issued & thats what he gets on kick,

Jan 14, 2015 6:34pm UTC BanEnforcer Anarchy UK #1 Conquest All Maps Permaban Player Previous Perm Ban WERE WARNED LAST TIME ABOUT UR BEHAVIOUR..PLEASE DONT COME BACK

not sure what to try next? to unban him he want to give him a second chance.

i was considering just wiping his player ID but i know it affects multiple tables.

if you cannot think of anything do you have a SQL query to wipe a player?

Sounds like someone else's ban is linking to him. Look for other players in the DB that match his current IP address and see if any of them are currently banned. If so, turn off IP enforcement for that ban.

ImportBot · May 17, 2015

Originally Posted by smogsy*:

Sounds like someone else's ban is linking to him. Look for other players in the DB that match his current IP address and see if any of them are currently banned. If so, turn off IP enforcement for that ban.

thats the trouble he has no stats at all even IP

ID

10014

Game

BF4

EAGUID

PBGUID

N/A

IP

N/A

Last Seen

N/A

Country

N/A

the other weird thing is his message is the exact message from the issued Command

Where are issued commands stored? maybe i can search that string for others with same message

ImportBot · May 17, 2015

Originally Posted by moacco07*:

Hello plugin developer, does the adkats plugin recognize mcoms in rush mode?

ColColonCleaner · May 17, 2015

Originally Posted by ColColonCleaner*:

thats the trouble he has no stats at all even IP

ID

10014

Game

BF4

EAGUID

PBGUID

N/A

IP

N/A

Last Seen

N/A

Country

N/A

the other weird thing is his message is the exact message from the issued Command

Where are issued commands stored? maybe i can search that string for others with same message

There is a bug with stat logger that sometimes makes it wipe player identification data but leave the player ID intact. It's rare but it happens. I posted a trigger that fixes the issue, run that.

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry45881

After that, do this to fix your ban issue:

DELETE FROM `adkats_bans` where `player_id` = 10014;

ImportBot · May 18, 2015

Originally Posted by smogsy*:

There is a bug with stat logger that sometimes makes it wipe player identification data but leave the player ID intact. It's rare but it happens. I posted a trigger that fixes the issue, run that.

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry45881

After that, do this to fix your ban issue:

DELETE FROM `adkats_bans` where `player_id` = 10014;

Getting the Following: [ MySQL client version: 5.0.77]

#1064 - You have an error in your SQL syntax

What i sent to MYSQL

<div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:276px;"><code><code><span style="color: #000000">
<span style="color: #0000BB">DELIMITER </span><span style="color: #007700">$$</span><span style="color: #0000BB">CREATE TRIGGER    Player_Update_BlankDataFixBEFORE UPDATE ON    tbl_playerdata</span><span style="color: #007700">FOR </span><span style="color: #0000BB">EACH ROWBEGIN    </span><span style="color: #007700">IF (NEW.</span><span style="color: #0000BB">SoldierName IS NULL </span><span style="color: #007700">OR </span><span style="color: #0000BB">CHAR_LENGTH</span><span style="color: #007700">(NEW.</span><span style="color: #0000BB">SoldierName</span><span style="color: #007700">) = </span><span style="color: #0000BB">0</span><span style="color: #007700">) AND </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">SoldierName IS NOT NULL        THEN SET </span><span style="color: #007700">NEW.</span><span style="color: #0000BB">SoldierName </span><span style="color: #007700">= </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">SoldierName</span><span style="color: #007700">;    </span><span style="color: #0000BB">END </span><span style="color: #007700">IF;    IF (NEW.</span><span style="color: #0000BB">EAGUID IS NULL </span><span style="color: #007700">OR </span><span style="color: #0000BB">CHAR_LENGTH</span><span style="color: #007700">(NEW.</span><span style="color: #0000BB">EAGUID</span><span style="color: #007700">) = </span><span style="color: #0000BB">0</span><span style="color: #007700">) AND </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">EAGUID IS NOT NULL        THEN SET </span><span style="color: #007700">NEW.</span><span style="color: #0000BB">EAGUID </span><span style="color: #007700">= </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">EAGUID</span><span style="color: #007700">;    </span><span style="color: #0000BB">END </span><span style="color: #007700">IF;    IF (NEW.</span><span style="color: #0000BB">PBGUID IS NULL </span><span style="color: #007700">OR </span><span style="color: #0000BB">CHAR_LENGTH</span><span style="color: #007700">(NEW.</span><span style="color: #0000BB">PBGUID</span><span style="color: #007700">) = </span><span style="color: #0000BB">0</span><span style="color: #007700">) AND </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">PBGUID IS NOT NULL        THEN SET </span><span style="color: #007700">NEW.</span><span style="color: #0000BB">PBGUID </span><span style="color: #007700">= </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">PBGUID</span><span style="color: #007700">;    </span><span style="color: #0000BB">END </span><span style="color: #007700">IF;    IF (NEW.</span><span style="color: #0000BB">IP_Address IS NULL </span><span style="color: #007700">OR </span><span style="color: #0000BB">CHAR_LENGTH</span><span style="color: #007700">(NEW.</span><span style="color: #0000BB">IP_Address</span><span style="color: #007700">) = </span><span style="color: #0000BB">0</span><span style="color: #007700">) AND </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">IP_Address IS NOT NULL        THEN SET </span><span style="color: #007700">NEW.</span><span style="color: #0000BB">IP_Address </span><span style="color: #007700">= </span><span style="color: #0000BB">OLD</span><span style="color: #007700">.</span><span style="color: #0000BB">IP_Address</span><span style="color: #007700">;    </span><span style="color: #0000BB">END </span><span style="color: #007700">IF;</span><span style="color: #0000BB">END</span><span style="color: #007700">;$$ 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>

i done your second sql query eariler today before you posted.

DELETE FROM `adkats_bans` where `player_id` = 10014;

waiting on word from the player to see how it going for him.

Thank you for your continued help Edited August 7, 2019 by maxdralle

ColColonCleaner · May 18, 2015

Originally Posted by ColColonCleaner*:

Your client is having issues with delimiters. Try using MySQL Workbench.

ImportBot · May 18, 2015

Originally Posted by madman72*:

I made a 'user role' called ViP for reserved slot owners. But when they enter the server, server says: Admin joined the server.

Is there a way to let it say: ViP joined the server?

I guess it's done with 3-2 Special player display? But when I enter ViP there, it changes back to 'All Groups Empty'

can you tell me if I am looking in the right direction and if yes, what is going wrong?

ColColonCleaner · May 18, 2015

Originally Posted by ColColonCleaner*:

I made a 'user role' called ViP for reserved slot owners. But when they enter the server, server says: Admin joined the server.

Is there a way to let it say: ViP joined the server?

I guess it's done with 3-2 Special player display? But when I enter ViP there, it changes back to 'All Groups Empty'

can you tell me if I am looking in the right direction and if yes, what is going wrong?

You gave that role access to an admin command, that's why it's announcing to other admins that they joined the server. Remove the command from their role that is making them be considered admin by the system.

ImportBot · May 18, 2015

Originally Posted by smogsy*:

Your client is having issues with delimiters. Try using MySQL Workbench.

i was using phpmyadmin fixed now with workbench 0 affected rows though

let see when he tries see if its fixed!

ColColonCleaner · May 18, 2015

Originally Posted by ColColonCleaner*:

i was using phpmyadmin fixed now with workbench 0 affected rows though

let see when he tries see if its fixed!

0 rows affected is great, it's added, you won't see players having their information wiped by the stat logger plugin anymore.

I would suggest looking through your DB for other players who have had their info wiped.

ImportBot · May 18, 2015

Originally Posted by smogsy*:

0 rows affected is great, it's added, you won't see players having their information wiped by the stat logger plugin anymore.

I would suggest looking through your DB for other players who have had their info wiped.

i checked the table colum & it says EAGUID

for reference this worked

<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:144px;"><code><code><span style="color: #000000">
<span style="color: #0000BB">SELECT     </span><span style="color: #007700">* </span><span style="color: #0000BB">FROM     </span><span style="color: #007700">`</span><span style="color: #DD0000">tbl_playerdata</span><span style="color: #007700">` </span><span style="color: #0000BB">WHERE    </span><span style="color: #007700">`</span><span style="color: #DD0000">EAGUID</span><span style="color: #007700">` </span><span style="color: #0000BB">IS NULL </span><span style="color: #007700">OR     </span><span style="color: #0000BB">CHAR_LENGTH</span><span style="color: #007700">(`</span><span style="color: #DD0000">EAGUID</span><span style="color: #007700">`) = </span><span style="color: #0000BB">0</span><span style="color: #007700">;</span><span style="color: #0000BB">theirs quite a lot</span><span style="color: #007700">. 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>
</div>

could it not be they have never joined our server since for example they got banned? & ban enforcer imported their ban & made a "fake" player entry?

every player from 9998 to 10261 has blank values

we had 4 servers you see, i setup server 1 let it running it for a day or so then done same for each server. Then imported the bans afterwards

alsso will this work? was not sure how to do multiple months
warn
kill
kick
kick
tban60
tban120
tbanday
tban2days
tban3days
tbanweek
tban2weeks
tbanmonth
!ban12weeks Edited August 7, 2019 by maxdralle

ImportBot · May 18, 2015

Originally Posted by ColColonCleaner*:

i checked the table colum & it says EAGUID

for reference this worked
<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:144px;"><code><code>
SELECT     * FROM     `tbl_playerdata` WHERE    `EAGUID` IS NULL OR     CHAR_LENGTH(`EAGUID`) = 0;theirs quite a lot. 


</code></code></div>
</div>
could it not be they have never joined our server since for example they got banned? & ban enforcer imported their ban & made a "fake" player entry?

every player from 9998 to 10261 has blank values

we had 4 servers you see, i setup server 1 let it running it for a day or so then done same for each server. Then imported the bans afterwards

alsso will this work? was not sure how to do multiple months
warn
kill
kick
kick
tban60
tban120
tbanday
tban2days
tban3days
tbanweek
tban2weeks
tbanmonth
!ban12weeks

Try running this instead, let me know if the results change.

Also, that punishment hierarchy won't work. Valid values are documented here: https://github.com/AdKats/AdKats#punishment-hierarchy Edited August 7, 2019 by maxdralle

ImportBot · May 18, 2015

Originally Posted by smogsy*:

the query worked with EAGUID but not EA_GUID Results = 0 for above

OK cheers for the update on the punishment, i thought that was just an example i was hoping it was the Numbers was Changeable but never mind.

ColColonCleaner · May 18, 2015

Originally Posted by ColColonCleaner*:

the query worked with EAGUID but not EA_GUID Results = 0 for above

OK cheers for the update on the punishment, i thought that was just an example i was hoping it was the Numbers was Changeable but never mind.

Sorry, wrote the query from memory, didn't remember the column name. Regardless, what do you mean "worked", yes it's a select, what did it return?

ImportBot · May 18, 2015

Originally Posted by smogsy*:

sorry i meant it shows 0 records with your below statement

<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:120px;"><code><code><span style="color: #000000">
<span style="color: #0000BB">SELECT 
    </span><span style="color: #007700">* 
</span><span style="color: #0000BB">FROM 
    </span><span style="color: #007700">`</span><span style="color: #DD0000">tbl_playerdata</span><span style="color: #007700">` 
</span><span style="color: #0000BB">WHERE
    </span><span style="color: #007700">`</span><span style="color: #DD0000">EA_GUID</span><span style="color: #007700">` </span><span style="color: #0000BB">IS NOT NULL 
</span><span style="color: #007700">AND
    </span><span style="color: #0000BB">CHAR_LENGTH</span><span style="color: #007700">(`</span><span style="color: #DD0000">EA_GUID</span><span style="color: #007700">`) = </span><span style="color: #0000BB">0</span><span style="color: #007700">; 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>
</div>

that good right? Edited August 7, 2019 by maxdralle

ImportBot · May 18, 2015

Originally Posted by MRniceGuy*:

Wait, crap, that doesn't include the command type/action, also the formatting on that SQL is terrible.

Here is an updated one.

Code:

SELECT 
  `tbl_games`.`Name` AS `Game`, 
  left(`tbl_server`.`ServerName`, 25) AS `Server`, 
  `adkats_records_main`.`source_name` AS `Source`, 
  `adkats_records_main`.`target_name` AS `Target`, 
  `type_command`.`command_name` AS `Command`,
  `action_command`.`command_name` AS `Action`,
  `adkats_records_main`.`record_message` AS `Reason`, 
  CONCAT(
    TIMESTAMPDIFF(HOUR, `adkats_records_main`.`record_time`, UTC_TIMESTAMP()), 
    'h ', 
    (TIMESTAMPDIFF(MINUTE, `adkats_records_main`.`record_time`, UTC_TIMESTAMP()) - 
		(TIMESTAMPDIFF(HOUR, `adkats_records_main`.`record_time`, UTC_TIMESTAMP()) * 60)), 
    'm') AS `Age` 
FROM 
	`adkats_records_main` 
	LEFT JOIN 
		`tbl_server` ON
		`adkats_records_main`.`server_id` = `tbl_server`.`ServerID`
	LEFT JOIN 
		`tbl_games` ON
		`tbl_server`.`GameID` = `tbl_games`.`GameID`
	LEFT JOIN 
		`adkats_commands` `type_command` ON
		`type_command`.`command_id` = `adkats_records_main`.`command_type`
	LEFT JOIN 
		`adkats_commands` `action_command` ON
		`action_command`.`command_id` = `adkats_records_main`.`command_action`
WHERE 
(
	(`adkats_records_main`.`source_id` IS NULL AND `adkats_records_main`.`source_name` = 'ProconAdmin')
	OR
	`adkats_records_main`.`source_id` IN (SELECT `player_id` FROM `adkats_usersoldiers`)
) 
ORDER BY 
  `adkats_records_main`.`record_time` DESC 
LIMIT 1000;

its ok

thanks man i appreciate it

ImportBot · May 18, 2015

Originally Posted by ColColonCleaner*:

sorry i meant it shows 0 records with your below statement

<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:120px;"><code><code><span style="color: #000000">
<span style="color: #0000BB">SELECT     </span><span style="color: #007700">* </span><span style="color: #0000BB">FROM     </span><span style="color: #007700">`</span><span style="color: #DD0000">tbl_playerdata</span><span style="color: #007700">` </span><span style="color: #0000BB">WHERE    </span><span style="color: #007700">`</span><span style="color: #DD0000">EA_GUID</span><span style="color: #007700">` </span><span style="color: #0000BB">IS NOT NULL </span><span style="color: #007700">AND    </span><span style="color: #0000BB">CHAR_LENGTH</span><span style="color: #007700">(`</span><span style="color: #DD0000">EA_GUID</span><span style="color: #007700">`) = </span><span style="color: #0000BB">0</span><span style="color: #007700">; 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>
</div>

that good right?

Yes that's good. Thanks. Edited August 7, 2019 by maxdralle

ImportBot · May 18, 2015

Originally Posted by smogsy*:

Yes that's good. Thanks.

so that player i found him someone gave me the wrong name.
Here he is

<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:36px;"><code><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #DD0000">'82074'</span><span style="color: #007700">, </span><span style="color: #DD0000">'1'</span><span style="color: #007700">, </span><span style="color: #DD0000">'OcUK'</span><span style="color: #007700">, </span><span style="color: #DD0000">'BOT-AMISH'</span><span style="color: #007700">, </span><span style="color: #DD0000">'140'</span><span style="color: #007700">, </span><span style="color: #DD0000">'f7b121f14b3bf49b0886e3372a9dd58d'</span><span style="color: #007700">, </span><span style="color: #DD0000">'EA_A5608D6AB1C29A30729E2B9C5D7B88D3'</span><span style="color: #007700">, </span><span style="color: #DD0000">'82.0.104.102'</span><span style="color: #007700">, _, </span><span style="color: #DD0000">'gb' 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>
</div>

he has no bans against him, what else can i check why hes getting kicked on join? Edited August 7, 2019 by maxdralle

ImportBot · May 19, 2015

Originally Posted by ColColonCleaner*:

so that player i found him someone gave me the wrong name.
Here he is

<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:36px;"><code><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #DD0000">'82074'</span><span style="color: #007700">, </span><span style="color: #DD0000">'1'</span><span style="color: #007700">, </span><span style="color: #DD0000">'OcUK'</span><span style="color: #007700">, </span><span style="color: #DD0000">'BOT-AMISH'</span><span style="color: #007700">, </span><span style="color: #DD0000">'140'</span><span style="color: #007700">, </span><span style="color: #DD0000">'f7b121f14b3bf49b0886e3372a9dd58d'</span><span style="color: #007700">, </span><span style="color: #DD0000">'EA_A5608D6AB1C29A30729E2B9C5D7B88D3'</span><span style="color: #007700">, </span><span style="color: #DD0000">'82.0.104.102'</span><span style="color: #007700">, _, </span><span style="color: #DD0000">'gb' 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>
</div>

he has no bans against him, what else can i check why hes getting kicked on join?

So this wasn't due to invalid player information, alright, probably a linked account like i suspected previously.

SELECT * FROM `adkats_records_main` WHERE `target_id` = 82074 ORDER BY `record_id` DESC;

Look at the records for command type 36, those are enforced bans. Look for 'LINKED' in the message. Edited August 7, 2019 by maxdralle

ImportBot · May 19, 2015

Originally Posted by smogsy*:

So this wasn't due to invalid player information, alright, probably a linked account like i suspected previously.

SELECT * FROM `adkats_records_main` WHERE `target_id` = 82074 ORDER BY `record_id` DESC;

Look at the records for command type 36, those are enforced bans. Look for 'LINKED' in the message.

i'm at work but I have been informed his had a few names over the years,

Should i repeat this for each player ID he has?

i've found 2-3 different names with different ID's in our records.

The only one that suggests a ban in bf-admin is Ban enforcer for server 1. with the exact message he is getting.

which makes sense as he said server 2 is fine

server 1 is not & the ban enforcer would not of linked to server 2. as it didn't exist at that time.

however Checking that name in mini-bans does not exist.

i shall check back here tonight in case you suggest something else

ImportBot · May 19, 2015

Originally Posted by smogsy*:

So this wasn't due to invalid player information, alright, probably a linked account like i suspected previously.
SELECT * FROM `adkats_records_main` WHERE `target_id` = 82074 ORDER BY `record_id` DESC;
Look at the records for command type 36, those are enforced bans. Look for 'LINKED' in the message.

i ran your script on all the ID's i know he has.
i checked bunch of his names & searched for the exact message he gets on kick

i see these only. i already removed the bans a while back using the database.
as this name is no longer used is there a script to remove all entries of this playerid?

'72134', '4', '7', '7', '2558', 'NEXUS-BOT', '10014', 'Smogsy', '808', 'testing', '2015-05-14 18:34:01', 'Y', '1'

'72130', '4', '7', '72', '10518878', 'NEXUS-BOT', '10014', 'Smogsy', '808', 'WERE WARNED LAST TIME ABOUT UR BEHAVIOUR..PLEASE DONT COME BACK', '2015-05-14 18:34:00', 'Y', '1'

'961', '4', '8', '73', '0', 'NEXUS-BOT', '10014', 'BanEnforcer', NULL, 'WERE WARNED LAST TIME ABOUT UR BEHAVIOUR..PLEASE DONT COME BACK', '2015-01-14 18:34:26', 'Y', '0'

script i used

<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:36px;"><code><code><span style="color: #000000">
<span style="color: #0000BB">SELECT </span><span style="color: #007700">* </span><span style="color: #0000BB">FROM </span><span style="color: #007700">`</span><span style="color: #DD0000">adkats_records_main</span><span style="color: #007700">` </span><span style="color: #0000BB">WHERE </span><span style="color: #007700">`</span><span style="color: #DD0000">record_message</span><span style="color: #007700">` = </span><span style="color: #DD0000">'WERE WARNED LAST TIME ABOUT UR BEHAVIOUR..PLEASE DONT COME BACK' </span><span style="color: #0000BB">ORDER BY </span><span style="color: #007700">`</span><span style="color: #DD0000">record_id</span><span style="color: #007700">` </span><span style="color: #0000BB">DESC</span><span style="color: #007700">; 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>
</div>

Edited August 7, 2019 by maxdralle

ImportBot · May 19, 2015

Originally Posted by ColColonCleaner*:

i ran your script on all the ID's i know he has.
i checked bunch of his names & searched for the exact message he gets on kick

i see these only. i already removed the bans a while back using the database.
as this name is no longer used is there a script to remove all entries of this playerid?

script i used

<div class="bbcode_container">
    <div class="bbcode_description">PHP Code:</div>
    <div class="bbcode_code" style="height:36px;"><code><code><span style="color: #000000">
<span style="color: #0000BB">SELECT </span><span style="color: #007700">* </span><span style="color: #0000BB">FROM </span><span style="color: #007700">`</span><span style="color: #DD0000">adkats_records_main</span><span style="color: #007700">` </span><span style="color: #0000BB">WHERE </span><span style="color: #007700">`</span><span style="color: #DD0000">record_message</span><span style="color: #007700">` = </span><span style="color: #DD0000">'WERE WARNED LAST TIME ABOUT UR BEHAVIOUR..PLEASE DONT COME BACK' </span><span style="color: #0000BB">ORDER BY </span><span style="color: #007700">`</span><span style="color: #DD0000">record_id</span><span style="color: #007700">` </span><span style="color: #0000BB">DESC</span><span style="color: #007700">; 
</span><span style="color: #0000BB"></span>
</span>
</code></code></div>
</div>

It doesn't matter if they change their name, their player ID stays the same and the new name is linked to that player ID. Bans are enforced against IDs not names. Old names are still held in the records because that was their name at the time of the admin action.

Those records you see are for two temp bans and a permaban. The permaban and one of the temp bans were lifted, and the last temp ban was for 2558 minutes, so it's expired by now.

If this player is still being kicked for that enforced ban I'd make sure you don't have any other services the ban was pushed to, like metabans, which would still be enforcing the ban if it wasn't lifted there. The unban command in AdKats does lift metabans bans, but if that wasn't set up at the time then it would not have pushed updates there. Edited August 7, 2019 by maxdralle

ImportBot · May 19, 2015

Originally Posted by smogsy*:

It doesn't matter if they change their name, their player ID stays the same and the new name is linked to that player ID. Bans are enforced against IDs not names. Old names are still held in the records because that was their name at the time of the admin action.

Those records you see are for two temp bans and a permaban. The permaban and one of the temp bans were lifted, and the last temp ban was for 2558 minutes, so it's expired by now.

If this player is still being kicked for that enforced ban I'd make sure you don't have any other services the ban was pushed to, like metabans, which would still be enforcing the ban if it wasn't lifted there. The unban command in AdKats does lift metabans bans, but if that wasn't set up at the time then it would not have pushed updates there.

what your saying does make sense however your saying their player ID stays the same, & their new name links to that player ID

his 3 names all have unique Player Id's? or are these "fake" and linked in the background?

but thank you so much ill look else where to

ColColonCleaner · May 19, 2015

Originally Posted by ColColonCleaner*:

what your saying does make sense however your saying their player ID stays the same, & their new name links to that player ID

his 3 names all have unique Player Id's? or are these "fake" and linked in the background?

but thank you so much ill look else where to

When someone changes their name, AdKats detects that by EAGUID then takes their previous name and stores it in a player_changename record, i don't remember the command ID for that. Then it changes the name on their main player entry to the updated name.

Either he has separate accounts, or he was a victim of the wiped player data problem with stat logger.

ImportBot · May 20, 2015

Originally Posted by smogsy*:

When someone changes their name, AdKats detects that by EAGUID then takes their previous name and stores it in a player_changename record, i don't remember the command ID for that. Then it changes the name on their main player entry to the updated name.

Either he has separate accounts, or he was a victim of the wiped player data problem with stat logger.

would that do the same even if it was bans/names were before adkats?

side question the ban from infractions does the player get length of the ban or does the admin have to put in his msg?

ColColonCleaner · May 20, 2015

Originally Posted by ColColonCleaner*:

would that do the same even if it was bans/names were before adkats?

side question the ban from infractions does the player get length of the ban or does the admin have to put in his msg?

It could be incorrect if you were previously banning by player name and he changed it before joining back again, but I would hope you weren't banning by player name.

Any ban while using ban enforcer tells the player how long the ban is (and when they attempt to rejoin it tells them how long they have left), the admin who issued the ban, and optionally the dispute message. When banning anyone just include the reason you are banning them, all other info is taken care of by the system.

EDIT: Remember, 80 characters is the maximum length of a kick message, so don't make your reasons too long. AdKats will truncate your ban reason to include the important information if needed (your database will still have the full reason, but it might be shortened for the player). Turn on join/leave messages and disconnect messages in the procon chat tab to see the messages for issued/enforced bans (BF4/BFH only).

ImportBot · May 20, 2015

Originally Posted by smogsy*:

It could be incorrect if you were previously banning by player name and he changed it before joining back again, but I would hope you weren't banning by player name.

Any ban while using ban enforcer tells the player how long the ban is (and when they attempt to rejoin it tells them how long they have left), the admin who issued the ban, and optionally the dispute message. When banning anyone just include the reason you are banning them, all other info is taken care of by the system.

EDIT: Remember, 80 characters is the maximum length of a kick message, so don't make your reasons too long. AdKats will truncate your ban reason to include the important information if needed (your database will still have the full reason, but it might be shortened for the player). Turn on join/leave messages and disconnect messages in the procon chat tab to see the messages for issued/enforced bans (BF4/BFH only).[bfadmin

Your a legend!

To be honest I only joined the clan recently & first thing I done was move the site off enjin to a real host and setup a website and proper forum software in this case SMF. Then adkats bfadmin & web stats were done.

Shall look through their previous bans just to see what was setup.

BTW how do you use your punish system?

Looking your experience on punish list and if you ever forgive etc & other than server management anything else that bypasses the system

We have a rule on one server no RPG on onf which can be very hard to judge for example

ColColonCleaner · May 20, 2015

Originally Posted by ColColonCleaner*:

Your a legend!

To be honest I only joined the clan recently & first thing I done was move the site off enjin to a real host and setup a website and proper forum software in this case SMF. Then adkats bfadmin & web stats were done.

Shall look through their previous bans just to see what was setup.

BTW how do you use your punish system?

Looking your experience on punish list and if you ever forgive etc & other than server management anything else that bypasses the system

We have a rule on one server no RPG on onf which can be very hard to judge for example

The docs contain much more info on the punish system details than I can give here. Can give some info on our configuration for it though.

Our punishment hierarchy if i remember correctly:

kill

kick

tban120

kill

kick

tbanday

kick

tbanweek

kick

tban2weeks

kick

tbanmonth

ban

IRO punishments are activated at the default 10 minutes.

Auto-forgives are issued after 30 days since last punish and 14 days since last forgive while they maintain positive reputation.

Depends on what you mean by bypasses the system. The only thing that would block a punish is an admin with a lower power level trying to issue that command on another admin with an equal or higher power level. If you are talking about admin abuse, don't keep someone on staff if they are abusing their powers. We've had admins like that in the past, it's bad news for you and your group.

If your one rule is no RPGs, i'd suggest blocking people spawning with it using the loadout enforcer, that's easy to block.

ImportBot · May 20, 2015

Originally Posted by smogsy*:

The docs contain much more info on the punish system details than I can give here. Can give some info on our configuration for it though.

Our punishment hierarchy if i remember correctly:

kill

kick

tban120

kill

kick

tbanday

kick

tbanweek

kick

tban2weeks

kick

tbanmonth

ban

IRO punishments are activated at the default 10 minutes.

Auto-forgives are issued after 30 days since last punish and 14 days since last forgive while they maintain positive reputation.

Depends on what you mean by bypasses the system. The only thing that would block a punish is an admin with a lower power level trying to issue that command on another admin with an equal or higher power level. If you are talking about admin abuse, don't keep someone on staff if they are abusing their powers. We've had admins like that in the past, it's bad news for you and your group.

If your one rule is no RPGs, i'd suggest blocking people spawning with it using the loadout enforcer, that's easy to block.

we have no RPG on infantry

your list is interesting our is

warn

kill

kick

tban60

tban120

tbanday

tban2days

tban3days

tbanweek

tban2weeks

!ban2weeks

tbanmonth

lot more heavy... maybe to heavy.

thats why i wanted to see yours.

Sign In

Advanced In-Game Admin and Ban Enforcer - AdKats

Recommended Posts

Link to comment

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Prophet731

maddog

Hedius

Posted Images

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Join the conversation

Our picks

Picked By

Picked By

Picked By

Picked By

Picked By

Important Information