Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by BriDawg*:

 

Ban ID's can be different, its the records and player ids that need to match.

 

Here is the script and line number where I do the merging. If you can follow the logic for it then it might help you do it now.

I am not very good with PHP anymore. But, it looks as though in this script it does copy over the BF3 bans. That's what my main concern was :-)

 

Don't want all the previous griefers/trollers & hackers unbanned in the switch.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi

Thx for AdKats! Today a player was banned because:

Hacking/Cheating HSK Automatic Ban [uMP45-73-141-103]

When i checked him bf4stats.com it shows me:

 

Name Top Time Kills Headshots HK % Kpm Shots Hits Accuracy % Stars Unlocks

UMP-45 13% 01:44:34 341 136 40% 3.26 3,523 844 24% 3 14 / 14

 

How that could be?

When AdKats grabs the weapon stats it is currently unable to say "update player" to bf4stats, so it grabs whatever is currently there. When AdKats grabbed his info he had 141 kills, and 103 headshots. When YOU looked him up on bf4stats it automatically updated and it showed 341 kills, 136 headshots.

 

In other words. From 0-141 kills he had a 73% HSK Ratio, and from 141-341 kills he had a 17% HSK ratio. He attempted to even out his stats after hacking the first 141 kills. It's a legit ban.

[Prophet731]

Originally Posted by Prophet731*:

 

I am not very good with PHP anymore. But, it looks as though in this script it does copy over the BF3 bans. That's what my main concern was :-)

 

Don't want all the previous griefers/trollers & hackers unbanned in the switch.

Bans, records, playerdata will be merged into the 4.0 schema with that script. So far it works great in all our 119k+ records for the 3.7 version. Lol. That's 2k+ bans as well.

[ImportBot]

Originally Posted by TMiland*:

 

Change your debug level to 3 and you will see it is not. If player died less than 5 seconds ago they are queued to be killed on spawn.

 

ALSO: Turn on procon kill events in the chat log, you will see only one death event for them

Colon, i checked the eventlog in procon, the player is killed 2 times, how many times do i have to tell you that the player is killed twice?

 

And why on earth would the player say "Why 2 kills_" if the player was only killed 1 time?

 

I am not giving up on this, i know what i see.

 

More proof:

 

https://myrcon.net/recovered/img/93571_attachment.php_attachmentid3069ampd1390126831

 

And the eventlog:

https://myrcon.net/recovered/img/93571_attachment.php_attachmentid3070ampd1390126853

 

AND a video of the same event:

 

 

 

Believe me now?

 

Attached Files:

• ScreenshotWin32-00190.png
• ziWS9zt.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Way to drill the point home. I know it's happening on your servers, you wouldn't be clamoring for this if it wasn't, but you didn't include the level 3 debug logs so i can see what is going on. My guess is you will be seeing negative numbers, and if that is the case I know where the issue is.

[ImportBot]

Originally Posted by PHX_Big_Deal*:

 

When AdKats grabs the weapon stats it is currently unable to say "update player" to bf4stats, so it grabs whatever is currently there. When AdKats grabbed his info he had 141 kills, and 103 headshots. When YOU looked him up on bf4stats it automatically updated and it showed 341 kills, 136 headshots.

 

In other words. From 0-141 kills he had a 73% HSK Ratio, and from 141-341 kills he had a 17% HSK ratio. He attempted to even out his stats after hacking the first 141 kills. It's a legit ban.

Thx for answer!

[Prophet731]

Originally Posted by Prophet731*:

 

I am not very good with PHP anymore. But, it looks as though in this script it does copy over the BF3 bans. That's what my main concern was :-)

 

Don't want all the previous griefers/trollers & hackers unbanned in the switch.

If you would like, I can do the merge for you now so you don't need to wait for script to come out in the v1.5.0 update. This goes for anyone else that would like to merge the AdKats 3.7 database into the 4.0 version. Just send me a PM here and we'll talk when you want to do this.

[ImportBot]

Originally Posted by TMiland*:

 

Way to drill the point home. I know it's happening on your servers, you wouldn't be clamoring for this if it wasn't, but you didn't include the level 3 debug logs so i can see what is going on. My guess is you will be seeing negative numbers, and if that is the case I know where the issue is.

Okay, i'll continue tomorrow, and provide you with debug info.

[ImportBot]

Originally Posted by glenn82*:

 

hi all

 

i try to add the adkat.sql to the xpkiller database and get this error:

 

Code:

Fout
SQL-query:

DROP TRIGGER IF EXISTS  `tbl_chatlog_player_id_insert` $$

MySQL meldt: Documentatie

#1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

dos any one have a idea?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hi all

 

i try to add the adkat.sql to the xpkiller database and get this error:

 

Code:

Fout
SQL-query:

DROP TRIGGER IF EXISTS  `tbl_chatlog_player_id_insert` $$

MySQL meldt: Documentatie

#1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

dos any one have a idea?

Your database provider has not allowed people to drop triggers. Please talk with them about getting access to do this.

[ImportBot]

Originally Posted by kcuestag*:

 

Two questions, I believe I asked them before but can't find them.

 

1. Does the plugin do EA Guid bans or PB Guid bans? I'd like to have "compatibility" with Metabans which I believe is EA GUID Bans?

 

2. Can I now use the plugin without it breaking the chat logging of my web stats like it happened in previous 3.x.x.x versions?

 

Many thanks.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Two questions, I believe I asked them before but can't find them.

 

1. Does the plugin do EA Guid bans or PB Guid bans? I'd like to have "compatibility" with Metabans which I believe is EA GUID Bans?

 

2. Can I now use the plugin without it breaking the chat logging of my web stats like it happened in previous 3.x.x.x versions?

 

Many thanks.

1. There are no PB systems in AdKats. EA GUID is primary.

2. It should not affect your chat in web stats anymore.

[ImportBot]

Originally Posted by glenn82*:

 

Your database provider has not allowed people to drop triggers. Please talk with them about getting access to do this.

i do can set triggers my self i can see on my phpmyadmin can you give me some records?

[ImportBot]

Originally Posted by kcuestag*:

 

1. There are no PB systems in AdKats. EA GUID is primary.

2. It should not affect your chat in web stats anymore.

Awesome, many thanks.

[ImportBot]

Originally Posted by FlippedOut*:

 

Colon, i checked the eventlog in procon, the player is killed 2 times, how many times do i have to tell you that the player is killed twice?

Yep i also confirmed this happening in our server but got no reply: myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry37404

 

The only time i noticed it didnt happen the other night was when i killed a guy, he didnt respawn straight away but was having a bitch in chat for a bit then respawned.. it only killed him once

 

So its almost like if users respawns straight away after getting playerkilled they get killed twice... if they wait a bit then respawn they only get killed once... I havent tried the level 3 debug but will next time server is populated

[ImportBot]

Originally Posted by BriDawg*:

 

So, I have a crap ton of server and over 40 admins. After admin 35, users are being appropriately added to the adkats_users table with correct user_role.... But, their user_id is not being added into adkats_usersoldiers and thus have no in-game access. Not sure if anyone else has experienced this?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

So, I have a crap ton of server and over 40 admins. After admin 35, users are being appropriately added to the adkats_users table with correct user_role.... But, their user_id is not being added into adkats_usersoldiers and thus have no in-game access. Not sure if anyone else has experienced this?

Assuming you're using the "Add Soldier" field by each user to add their soldiers?

[ImportBot]

Originally Posted by BriDawg*:

 

Yup, I go in and add user, then assign them the role I want..... They show up in the plugin with the correct role and everything. But, it says they don't have da powa when they use in-game commands :-(

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yup, I go in and add user, then assign them the role I want..... They show up in the plugin with the correct role and everything. But, it says they don't have da powa when they use in-game commands :-(

No, there is an "Add Soldier" field on each user. You need to assign the soldiers to the users. Users can have multiple soldiers.

 

So you added "somerandomadmin" as a user. Type their in-game name in the Add Soldier field and it will assign the soldier to that user. The reason for this is that if people change their soldier names, they don't have to tell you they did, it will automatically update their powers with the new soldier name.

[ImportBot]

Originally Posted by BriDawg*:

 

ah man. I see what you are saying now. I don't recall doing this when I first set this up with our original admins. But, sweet, thanks!

[ImportBot]

Originally Posted by TMiland*:

 

[13:45:40 24] [AdKats] OnBanList fired

[13:45:50 34] [AdKats] player_punish upload for player TommyMiland by TommyMiland SUCCESSFUL!

[13:45:50 57] [AdKats] Killing player. Player last died 746 seconds ago.

[13:45:51 31] [AdKats] player_kill_lowpop update for player TommyMiland by TommyMiland SUCCESSFUL!

[13:46:05 21] [AdKats] OnBanList fired

[13:46:05 33] [AdKats] User List Fetched from Database. User Count: 49

[13:46:27 14] [AdKats] OnBanList fired

[13:46:46 20] [AdKats] player_forgive upload for player TommyMiland by TommyMiland SUCCESSFUL!

[13:46:46 87] [AdKats] player_forgive update for player TommyMiland by TommyMiland SUCCESSFUL!

[13:46:57 64] [AdKats] OnBanList fired

[13:47:01 34] [AdKats] player_punish upload for player TommyMiland by TommyMiland SUCCESSFUL!

[13:47:01 56] [AdKats] player_punish upload for player TommyMiland by TommyMiland SUCCESSFUL!

[13:47:01 79] [AdKats] Killing player. Player last died -3528 seconds ago.

[13:47:02 21] [AdKats] player_kill_lowpop update for player TommyMiland by TommyMiland SUCCESSFUL!

[13:47:23 64] [AdKats] OnBanList fired

[13:47:45 24] [AdKats] OnBanList fired

*Edit:

[16:30:52 19] [AdKats] player_punish upload for player tabmy by TommyMiland SUCCESSFUL!

[16:30:52 42] [AdKats] Killing player. Player last died -3515 seconds ago.

[16:30:52 42] [AdKats] Queueing player for kill on spawn. (-3515)&(Kill Player (Low Population))

[16:30:52 84] [AdKats] player_kill_repeat update for player tabmy by TommyMiland SUCCESSFUL!

[16:31:01 55] [insane Limits] Thread(enforcer): Set preset to Normal

[16:31:01 55] [insane Limits] Thread(enforcer): Preset is now Normal

[16:31:05 48] [AdKats] Killing player. Player last died -3587 seconds ago.

[16:31:06 13] [AdKats] player_kill_repeat update for player tabmy by TommyMiland SUCCESSFUL!

[16:31:16 91] [AdKats] OnBanList fired

Player killed twice today as well

 

Do you see anything weird in here Col?

[ImportBot]

Originally Posted by LumPenPacK*:

 

Since we've rolling back to BF3 I'm trying to set up AdKats with BF3 again but I've got these errors. Any ideas whats the problem with DB?

 

Code:

[17:33:38 95] [AdKats] Enabled! Beginning startup sequence...
[17:33:38 95] [AdKats] Waiting a few seconds for requirements and other plugins to initialize, please wait...
[17:33:38 95] [AdKats] 5...
[17:33:39 98] [AdKats] 4...
[17:33:40 99] [AdKats] 3...
[17:33:42 00] [AdKats] 2...
[17:33:43 01] [AdKats] 1...
[17:33:43 54] [AdKats] Entering OnServerInfo
[17:33:43 54] [AdKats] Exiting OnServerInfo
[17:33:43 57] [AdKats] Reserved slots listed.
[17:33:43 78] [AdKats] Reserved slots listed.
[17:33:44 04] [AdKats] SUCCESS: Server IP is 176.57.133.48:47200!
[17:33:44 06] [AdKats] Entering StartThreads
[17:33:44 06] [AdKats] Exiting StartThreads
[17:33:44 06] [AdKats] DBCOMM: Starting Database Comm Thread
[17:33:44 06] [AdKats] DBCOMM: Entering Database Comm Thread Loop
[17:33:44 07] [AdKats] fetchCommands starting!
[17:33:44 07] [AdKats] databaseConnectionActive starting!
[17:33:44 07] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 07] [AdKats] databaseConnectionActive finished!
[17:33:44 07] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 07] [AdKats] fetchRoles starting!
[17:33:44 07] [AdKats] databaseConnectionActive starting!
[17:33:44 07] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 07] [AdKats] databaseConnectionActive finished!
[17:33:44 07] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 07] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 09] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 09] [AdKats] WARNING: Not updating database, new records already found.
[17:33:44 09] [AdKats] fetchServerID starting!
[17:33:44 09] [AdKats] databaseConnectionActive starting!
[17:33:44 09] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 09] [AdKats] databaseConnectionActive finished!
[17:33:44 09] [AdKats] MySql Connection capable. All variables in place.
[17:33:44 09] [AdKats] fetchServerID finished!
[17:33:44 09] [AdKats] ERROR: Database Server info could not be fetched! Make sure XpKiller's Stat Logger is running on this server!
[17:33:44 21] [AdKats] DBCOMM: Ending Database Comm Thread
[17:33:44 61] [AdKats] Threads still exiting: 
[17:33:44 75] [AdKats] AdKats 4.0.0.0 Disabled! =(

EDIT: problem solved, a procon restart works wonders

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

*Edit:

 

 

Player killed twice today as well

 

Do you see anything weird in here Col?

Yep suspicions were correct, negative values. I never ran into this bug since i'm west of UTC time.

 

Fix until i release the change, go to line 3070.

 

victim.lastDeath = kKillerVictimDetails.TimeOfDeath;

 

change it to

 

victim.lastDeath = DateTime.UtcNow;

 

Problem gone.

[Prophet731]

Originally Posted by Prophet731*:

 

That's very weird colon. Why is it doing that? Shouldn't matter since everything is in UTC.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

That's very weird colon. Why is it doing that? Shouldn't matter since everything is in UTC.

kKillerVictimDetails has elements in procon layer time, not UTC time.

[Prophet731]

Originally Posted by Prophet731*:

 

kKillerVictimDetails has elements in procon layer time, not UTC time.

Well guess you should fix that.

[ImportBot]

Originally Posted by TMiland*:

 

Thank you ColColonCleaner! I have changed the code on all 6 servers, gonnna test right away!

[ImportBot]

Originally Posted by TMiland*:

 

Nothing happens!

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Nothing happens!

Lol what do you mean nothing happens? If you are running 4.0.0.0 that should work.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

i do can set triggers my self i can see on my phpmyadmin can you give me some records?

What do you mean give you some records? The triggers in the adkats.sql file are what need to be run on your database, but it needs to be in the same order they are in that file. I would still suggest talking with your provider about acquiring access to those so you can just run the script.