Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by jking54*:

 

NOOOO, i mentioned it to ONE person to attempt to fix their user problem, did not say for testers to install it. You will see the giant red "TESTERS ONLY" text above beta release posts. If you install the beta in its current state your layers will lock up, i'm still trying to find out why.

noted, ty

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

no its the stable one not the beta.

Hmmm, no others have noted extreme cpu usage with that version. It does perform a lot of database interaction, but has always been stable on our hosted layers and many others. I'll look into it further.

[ImportBot]

Originally Posted by TMiland*:

 

Just a question: Why isn't the webadmin users and soldiers reflected in the AdKats plugin?

I though the whole idea was to sync between the two?

[ImportBot]

Originally Posted by XRay206*:

 

i have this Problem

 

SQL-Befehl: Dokumentation

 

CREATE PROCEDURE addLogPlayerID() BEGIN -- add logPlayerID column safely IF NOT EXISTS( (SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='logPlayerID' AND TABLE_NAME='tbl_chatlog') ) THEN ALTER TABLE `tbl_chatlog` ADD COLUMN `logPlayerID` INT(10) UNSIGNED DEFAULT NULL; ALTER TABLE `tbl_chatlog` ADD INDEX (`logPlayerID`); ALTER TABLE `tbl_chatlog` ADD CONSTRAINT `tbl_chatlog_ibfk_player_id` FOREIGN KEY (`logPlayerID`) REFERENCES `tbl_playerdata` (`PlayerID`) ON DELETE CASCADE ON UPDATE CASCADE; UPDATE `tbl_chatlog` INNER JOIN `tbl_playerdata` ON `tbl_chatlog`.`logSoldierName` = `tbl_playerdata`.`SoldierName` SET `tbl_chatlog`.`logPlayerID` = `tbl_playerdata`.`PlayerID` WHERE `tbl_playerdata`.`SoldierName` 'AutoAdmin' AND `tbl_playerdata`.`SoldierName` 'AdKats' AND `tbl_playerdata`.`SoldierName` 'Server' AND `tbl_playerdata`.`SoldierName` 'BanEnforcer' AND `tbl_chatlog`.`logPlayerID[...]

 

MySQL meldet: Dokumentation

 

#1044 - Access denied for user 'BF4-Rush'@'%' to database 'bf4-rush'

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Just a question: Why isn't the webadmin users and soldiers reflected in the AdKats plugin?

I though the whole idea was to sync between the two?

Not my department, talk to prophet.

[ImportBot]

Originally Posted by lordicon*:

 

Deleted

[Prophet731]

Originally Posted by Prophet731*:

 

Just a question: Why isn't the webadmin users and soldiers reflected in the AdKats plugin?

I though the whole idea was to sync between the two?

It's separated because colons tables don't work with my setup or vice versa. In the next update the web admin will have an interface to manage AdKats better.

[ImportBot]

Originally Posted by BriDawg*:

 

Are we any closer to a script that will merge the old chat/stat logger and make it work in an existing database for the new chat/stat logger?

[ImportBot]

Originally Posted by TMiland*:

 

It's separated because colons tables don't work with my setup or vice versa. In the next update the web admin will have an interface to manage AdKats better.

Okay Chief! That sounds great!

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Are we any closer to a script that will merge the old chat/stat logger and make it work in an existing database for the new chat/stat logger?

I'm not developing that. That's up to XPKiller. Once you get all of your stat logger info updated, we can update the AdKats information.

[ImportBot]

Originally Posted by jking54*:

 

hey C3, I've gone HC on my server and as a result, I'm using tyger_007's punish/forgive enhancement, it works but I also get this from AdKats:

 

Your user role Default Guest does not have access to Punish Player.

[ImportBot]

Originally Posted by Hutchew*:

 

hey C3, I've gone HC on my server and as a result, I'm using tyger_007's punish/forgive enhancement, it works but I also get this from AdKats:

 

Your user role Default Guest does not have access to Punish Player.

You need to change the word "!punish" used in either adkats or the punish/forgive system. Both plugins are trying to issue a command every time someone says !punish, is all.

 

Hutchew

[ImportBot]

Originally Posted by AgentHawk*:

 

Some times the Tool is aksing me "Restart Current Round_" and when I typed /yes it dosent worked.....same with the kick or ban command....

 

Any tricks?

[Prophet731]

Originally Posted by Prophet731*:

 

Are we any closer to a script that will merge the old chat/stat logger and make it work in an existing database for the new chat/stat logger?

I have created a script with the web admin to merge the old AdKats from BF3 into the BF4 database. It doesn't merge chat or other data from the loggers table except for servers and player data. That will be in its next update.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Some times the Tool is aksing me "Restart Current Round_" and when I typed /yes it dosent worked.....same with the kick or ban command....

 

Any tricks?

You're probably running an official server, not ranked. You can't do those commands on official servers.

[ImportBot]

Originally Posted by AgentHawk*:

 

nono

 

the kick and ban works...but sometimes ask me the tool "do you mean Playerxyz" and I awnser with /yes and nothing happens

[ImportBot]

Originally Posted by jking54*:

 

You need to change the word "!punish" used in either adkats or the punish/forgive system. Both plugins are trying to issue a command every time someone says !punish, is all.

 

Hutchew

For now, I've enabled punish and forgive for guests but not sure exactly how this will conflict with the normal tk !punish and !forgive.

[ImportBot]

Originally Posted by Hutchew*:

 

For now, I've enabled punish and forgive for guests but not sure exactly how this will conflict with the normal tk !punish and !forgive.

Wait, wut?

 

You are going to allow regular guests to punish and forgive in the adkats system..............? Bad idea, mate.

 

Just change your commands in adkats for punish/forgive. We use !pp for punish, and !fgv for forgive. Quicker typing that way anyway, especially when combined with the reasons.

 

So "!pp playername 1" is equal to "!punish playername (for reason) Baserape is not allowed in our server!"

 

Make sense?

 

Hutchew

[ImportBot]

Originally Posted by jking54*:

 

Wait, wut?

 

You are going to allow regular guests to punish and forgive in the adkats system..............? Bad idea, mate.

 

Just change your commands in adkats for punish/forgive. We use !pp for punish, and !fgv for forgive. Quicker typing that way anyway, especially when combined with the reasons.

 

So "!pp playername 1" is equal to "!punish playername (for reason) Baserape is not allowed in our server!"

 

Make sense?

 

Hutchew

Yeppers, it was only temporary and yes of course it make sense

[ImportBot]

Originally Posted by HappyGotLucky*:

 

Don't suppose you have a magical SQL file somewhere that imports bans from the older "Ban Manager" plugin to the latest version of adkats do you?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Don't suppose you have a magical SQL file somewhere that imports bans from the older "Ban Manager" plugin to the latest version of adkats do you?

That code is already in AdKats man.

 

1. Only ONE instance of AdKats should be running this at any time. So shut down your instances.

2. Get those tables/data from the bf3 ban manager plugin onto the same schema/database you are running AdKats on.

3. Start up AdKats on ONE layer/server. You should see the bans start importing.

 

If you cancel the process mid-operation it cannot be restarted, a manual override needs to be done first via the database.

[Prophet731]

Originally Posted by Prophet731*:

 

That code is already in AdKats man.

 

1. Only ONE instance of AdKats should be running this at any time. So shut down your instances.

2. Get those tables/data from the bf3 ban manager plugin onto the same schema/database you are running AdKats on.

3. Start up AdKats on ONE layer/server. You should see the bans start importing.

 

If you cancel the process mid-operation it cannot be restarted, a manual override needs to be done first via the database.

Should I add this as well into the web admin?

[ImportBot]

Originally Posted by HappyGotLucky*:

 

That code is already in AdKats man.

 

1. Only ONE instance of AdKats should be running this at any time. So shut down your instances.

2. Get those tables/data from the bf3 ban manager plugin onto the same schema/database you are running AdKats on.

3. Start up AdKats on ONE layer/server. You should see the bans start importing.

 

If you cancel the process mid-operation it cannot be restarted, a manual override needs to be done first via the database.

Thank you! Didn't realize that was built in and I didn't have them in the same schema. See them importing now.

[ImportBot]

Originally Posted by Hutchew*:

 

Should I add this as well into the web admin?

Nah, you should get the server chat logs fixed and searchable, and reasons for ban fixed in full info......

 

jabjab.........

 

LOL, running like a champ, guys. Great job.

 

Hutchew

[ImportBot]

Originally Posted by TMiland*:

 

Okay, the doublekill bug is still present:

 

[15:42:10] ***** - Chinese Army - Charlie > /!punish ********** Bad Language

[15:41:46] AdKats > Say > ******** > Killed by admin for Bad Language [1pts]

[15:41:46] AdKats > Say > ******** > You KILLED ************ for Bad Language [1pts]

[15:41:47] AdKats > Say > ******** > Killed by admin for Bad Language [1pts]

[15:41:47] AdKats > Say > ******** > You KILLED ************ for Bad Language [1pts]

 

This is done from ingame.

 

Even got proof from ingame: https://myrcon.net/recovered/img/93531_attachment.php_attachmentid3068ampd1390065672

 

Attached Files:

• ScreenshotWin32-00171.png

[ImportBot]

Originally Posted by BriDawg*:

 

I have created a script with the web admin to merge the old AdKats from BF3 into the BF4 database. It doesn't merge chat or other data from the loggers table except for servers and player data. That will be in its next update.

I gotcha. So, I will have to figure out someway to manually change my ban IDs and copy them over myself then is what I am understanding?

[Prophet731]

Originally Posted by Prophet731*:

 

Okay, the doublekill bug is still present:

 

[15:42:10] ***** - Chinese Army - Charlie > /!punish ********** Bad Language

[15:41:46] AdKats > Say > ******** > Killed by admin for Bad Language [1pts]

[15:41:46] AdKats > Say > ******** > You KILLED ************ for Bad Language [1pts]

[15:41:47] AdKats > Say > ******** > Killed by admin for Bad Language [1pts]

[15:41:47] AdKats > Say > ******** > You KILLED ************ for Bad Language [1pts]

 

This is done from ingame.

 

Even got proof from ingame: https://myrcon.net/recovered/img/93533_attachment.php_attachmentid3068ampd1390065672

Correct me if i'm wrong colon, but, when you punish someone it goes through but if the player is already dead it will be moved into a loop until the player respawns then re-issues the punish (without double records) do effectively enforce the punish on the player.

[Prophet731]

Originally Posted by Prophet731*:

 

I gotcha. So, I will have to figure out someway to manually change my ban IDs and copy them over myself then is what I am understanding?

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.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Okay, the doublekill bug is still present:

 

[15:42:10] ***** - Chinese Army - Charlie > /!punish ********** Bad Language

[15:41:46] AdKats > Say > ******** > Killed by admin for Bad Language [1pts]

[15:41:46] AdKats > Say > ******** > You KILLED ************ for Bad Language [1pts]

[15:41:47] AdKats > Say > ******** > Killed by admin for Bad Language [1pts]

[15:41:47] AdKats > Say > ******** > You KILLED ************ for Bad Language [1pts]

 

This is done from ingame.

 

Even got proof from ingame: https://myrcon.net/recovered/img/93535_attachment.php_attachmentid3068ampd1390065672

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

[ImportBot]

Originally Posted by PHX_Big_Deal*:

 

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?