Advanced In-Game Admin and Ban Enforcer - AdKats

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

You can run it without the web admin, you just wont have the easy ability to edit bans and view a player history.

AdKats can be run completely without the webadmin. The chat log player IDs are both for that and future planned in-game commands working with chat. I'll change it for now though so people wont have issues with their providers.

 

Here is the heart of the problem:

I need to run a logical setup, it needs to adapt to different circumstances considering i support two game versions, two versions of stat logger, and need an additional column in an existing table.

I can't run triggers from the plugin, it's a bug in the current version of MySQL connector, but i can run those in the setup script.

I cant put procedures in the sql setup script because people have permission issues with those, but i can put that logic in the plugin.

It turns into one huge codependency problem. I'll figure it out though...

[ImportBot]

Originally Posted by jking54*:

 

AdKats can be run completely without the webadmin. The chat log player IDs are both for that and future planned in-game commands working with chat. I'll change it for now though so people wont have issues with their providers.

 

Here is the heart of the problem:

I need to run a logical setup, it needs to adapt to different circumstances considering i support two game versions, two versions of stat logger, and need an additional column in an existing table.

I can't run triggers from the plugin, it's a bug in the current version of MySQL connector, but i can run those in the setup script.

I cant put procedures in the sql setup script because people have permission issues with those, but i can put that logic in the plugin.

It turns into one huge codependency problem. I'll figure it out though...

Ok John at NFO ran the update on my MySQL and now your script in post#823 works now, showing 26 tables.

 

3.9.9.2 up and running, I'm added and all seems good so far.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ok John at NFO ran the update on my MySQL and now your script in post#823 works now, showing 26 tables.

 

3.9.9.2 up and running, I'm added and all seems good so far.

It may just have been your particular database...Schmoove back a few pages was also running an NFO database and he could run the testing script just fine from the start. "Ran fine for me, no errors, NFO." So i'm gonna wait on removing it, it solves far too many other issues keeping it there to draw conclusion from one person.

 

Please tell me exactly what John had to do for you in order for this to work on your system.

[ImportBot]

Originally Posted by jking54*:

 

It may just have been your particular database...Schmoove back a few pages was also running an NFO database and he could run the testing script just fine from the start. "Ran fine for me, no errors, NFO." So i'm gonna wait on removing it, it solves far too many other issues keeping it there to draw conclusion from one person.

 

Please tell me exactly what John had to do for you in order for this to work on your system.

Hi yeah I'll get that for you asap on what he did but question, does the ban enforcer work yet? I've enabled it but not sure it's actually doing anything, also, how does the email system work again? Doesn't it send emails to us similar to Notify Me? Or does it just send to you guys, thanks.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi yeah I'll get that for you asap on what he did but question, does the ban enforcer work yet? I've enabled it but not sure it's actually doing anything, also, how does the email system work again? Doesn't it send emails to us similar to Notify Me? Or does it just send to you guys, thanks.

• Yes, ban enforcer works.
• Yes, the email system sends the same way notifyme does, in fact a large portion of that code is directly used from the notifyme plugin and stated as such. I included the adkatsbattlefield smtp creds so you dont need your own server for that. It will send emails to all of your user's email addresses who have access to player interaction commands. Player interaction commands are any command that can directly affect what a player sees or does. e.g. @say and @kill are player interaction commands, @rules and @report are not.

[ImportBot]

Originally Posted by jking54*:

 

• Yes, ban enforcer works.
• Yes, the email system sends the same way notifyme does, in fact a large portion of that code is directly used from the notifyme plugin and stated as such. I included the adkatsbattlefield smtp creds so you dont need your own server for that. It will send emails to all of your user's email addresses who have access to player interaction commands. Player interaction commands are any command that can directly affect what a player sees or does. e.g. @say and @kill are player interaction commands, @rules and @report are not.

Ahh ok, I just noticed the email setting under users, so I added mine.

 

Now my ban list on one server in procon is short compared to the other, aren't they supposed to align up or do I have this function wrong?

 

Also, what is a suitable debug setting to use?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ahh ok, I just noticed the email setting under users, so I added mine.

 

Now my ban list on one server in procon is short compared to the other, aren't they supposed to align up or do I have this function wrong?

 

Also, what is a suitable debug setting to use?

If you've enabled ban enforcer then all procon bans will be imported and you wont see any in procon anymore aside from the "ban count" fields next to the ban settings (those settings are on a delay to save bandwidth so don't worry). But if you refresh your ban tabs on each server they should be completely empty.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Posting again to un-bury it.

 

TESTERS ONLY

 

Updated. 3.9.9.2

 

https://raw.github.com/ColColonClean...test/AdKats.cs

https://raw.github.com/ColColonClean...est/adkats.sql

[ImportBot]

Originally Posted by jking54*:

 

If you've enabled ban enforcer then all procon bans will be imported and you wont see any in procon anymore aside from the "ban count" fields next to the ban settings (those settings are on a delay to save bandwidth so don't worry). But if you refresh your ban tabs on each server they should be completely empty.

Odd, yes Ban enforcer is on on both servers but the bans are still showing in procon, get this error:

 

[23:36:41 13] [AdKats] OnBanList fired

[23:36:41 13] [AdKats] Bans found

[23:36:41 15] [AdKats] EXCEPTION: [FetchPlayer][Error while fetching player.]: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`EAGUID`

 

) ' at line 5

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.ExecuteNonQuer y()

at PRoConEvents.AdKats.FetchPlayer(Boolean requireExisting, Int64 playerID, String playerName, String playerGUID, String playerIP)

[23:36:41 16] [AdKats] EXCEPTION: [DatabaseCommThreadLoop][Error occured in database comm thread.]: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.AdKats.DatabaseCommThreadLoop()

[ImportBot]

Originally Posted by Jasonpb*:

 

Meh, why change it, people that are having the problem could just purchase a small vps and host procon and mysql themselves.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Odd, yes Ban enforcer is on on both servers but the bans are still showing in procon, get this error:

 

[23:36:41 13] [AdKats] OnBanList fired

[23:36:41 13] [AdKats] Bans found

[23:36:41 15] [AdKats] EXCEPTION: [FetchPlayer][Error while fetching player.]: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`EAGUID`

 

) ' at line 5

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.ExecuteNonQuer y()

at PRoConEvents.AdKats.FetchPlayer(Boolean requireExisting, Int64 playerID, String playerName, String playerGUID, String playerIP)

[23:36:41 16] [AdKats] EXCEPTION: [DatabaseCommThreadLoop][Error occured in database comm thread.]: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.AdKats.DatabaseCommThreadLoop()

Error reproduced on my end. A section of ban enforcer i hadn't tested. Fixing.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

Updated. 3.9.9.3

 

Fixed playerFetch issue when fetching based on IP only.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

Same setup script as 3.9.9.2

https://raw.github.com/ColColonClean...est/adkats.sql

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Meh, why change it, people that are having the problem could just purchase a small vps and host procon and mysql themselves.

Yeah, i'm leaving it unless a lot of people have permission issues.

[ImportBot]

Originally Posted by Jasonpb*:

 

Where's my "nextmap" feature? I've probably donated the most to date and I want want want it.....

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Where's my "nextmap" feature? I've probably donated the most to date and I want want want it.....

Doesn't ultimate map manager do that? That's what i said when someone asked about this before.

 

EDIT: Ah i see, permissions for the !nextmap commands wouldn't be distributed if you used that plugin. I'll add it to the burner. Did you already submit a ticket on github for this?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thank you for the donation Schropp

[ImportBot]

Originally Posted by TMiland*:

 

Or i could just add another table for reserved slots to make things simple . All users on the user list still get reserved slots, but also the people from this extra table. It will just be one column. adkats_reservedslots player_name.

That could work.

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

Thank you for the donation Schropp

Your welcome dude

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

Bugs:

 

1. IRO does not work .... setting use iro punishment is set to true

 

iro punish.png

 

2. email does not work ... ist correctly set up

[15:30:35 09] [AdKats] ERROR: Error while sending email: System.InvalidOperationException: Es muss ein Empfänger angegeben werden.

bei System.Net.Mail.SmtpClient.Send(MailMessage message)

bei PRoConEvents.AdKats.EmailHandler.EmailWrite(String subject, String body)

 

3. Feature Request:

 

---> Switch off Server Rules Settings

 

cause if you use another plugin and dont write something into the server rule list you get this error

[15:37:46 18] [AdKats] ERROR: target or message null in playerSayMessage

 

4. 2 excatly same names should be prohibited or not possible to be added

 

same names.png

 

btw i cant delete user out of adkats..only via DB

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

Updated. 3.9.9.4

 

Fixed IRO Punish

Fixed email settings (gave more informative error message)

Fixed command disable settings

 

@Battleplay

Fixed IRO that was broken.

The email error you were getting was because you didn't set up any recipients (None of your users with access to player interaction commands had an email assigned to them).

When wanting to disable a command AdKats has, you aren't supposed to just delete things from it, you change it from "Active" to "Disabled" in the command list then AdKats will ignore the command.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

Same setup script as 3.9.9.2

https://raw.github.com/ColColonClean...est/adkats.sql

[ImportBot]

Originally Posted by jking54*:

 

Hi C3, my version now shows 3.9.9.4 and seems to be working well, I did notice with Ban Enforcer that it works with EA GUID bans so all of those have been taken care of off my procon list. I've been banning most though by PB GUID but will do it from now on by EA GUID.

 

Question on setting up admins, my main admin I can trust like a brother so I'm guessing make him full? Or are there other settings?

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

TESTERS ONLY

 

Updated. 3.9.9.4

 

Fixed IRO Punish

Fixed email settings (gave more informative error message)

Fixed command disable settings

 

@Battleplay

Fixed IRO that was broken.

The email error you were getting was because you didn't set up any recipients (None of your users with access to player interaction commands had an email assigned to them).

When wanting to disable a command AdKats has, you aren't supposed to just delete things from it, you change it from "Active" to "Disabled" in the command list then AdKats will ignore the command.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

Same setup script as 3.9.9.2

https://raw.github.com/ColColonClean...est/adkats.sql

ok..thx

 

IRO works

Email works

 

THX

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi C3, my version now shows 3.9.9.4 and seems to be working well, I did notice with Ban Enforcer that it works with EA GUID bans so all of those have been taken care of off my procon list. I've been banning most though by PB GUID but will do it from now on by EA GUID.

 

Question on setting up admins, my main admin I can trust like a brother so I'm guessing make him full? Or are there other settings?

You can add new roles and allow usage of commands as you see fit. The two that are in there by default are basically all and nothing, you create everything in between.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

Updated. 3.9.9.5

 

Fixed users able to be added with duplicate names.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

Same setup script as 3.9.9.2

https://raw.github.com/ColColonClean...est/adkats.sql

[ImportBot]

Originally Posted by jking54*:

 

TESTERS ONLY

 

Updated. 3.9.9.5

 

Fixed users able to be added with duplicate names.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

Same setup script as 3.9.9.2

https://raw.github.com/ColColonClean...est/adkats.sql

Same setup script as 3.9.9.2, same as one in post #823? This what I used.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Same setup script as 3.9.9.2, same as one in post #823? This what I used.

If you can run it, you ran the right script.

[ImportBot]

Originally Posted by jking54*:

 

If you can run it, you ran the right script.

Ok good, yes it ran fine thanks to John

 

Also, is this just normal operation for the hacker checks?

 

[10:30:41 13] [AdKats] BANENF: No inbound ban checks. Waiting for Input.

[10:30:42 04] [AdKats] HCKCHK: begin reading player

[10:30:43 78] [AdKats] Players with BF4Stats: 22.83%

[10:30:43 78] [AdKats] HCKCHK: No inbound hacker checks. Waiting 10 seconds or for input.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ok good, yes it ran fine thanks to John

 

Also, is this just normal operation for the hacker checks?

 

[10:30:41 13] [AdKats] BANENF: No inbound ban checks. Waiting for Input.

[10:30:42 04] [AdKats] HCKCHK: begin reading player

[10:30:43 78] [AdKats] Players with BF4Stats: 22.83%

[10:30:43 78] [AdKats] HCKCHK: No inbound hacker checks. Waiting 10 seconds or for input.

I stated that the hacker checker is in debug mode right now until the full release. It will spit out the percent of players in your server who have stats on BF4Stats, and also any missing weapons. Currently i don't have damages for the l85, mp7, mtar, and a couple others since those damages are not released yet.

[ImportBot]

Originally Posted by jking54*:

 

I stated that the hacker checker is in debug mode right now until the full release. It will spit out the percent of players in your server who have stats on BF4Stats, and also any missing weapons. Currently i don't have damages for the l85, mp7, mtar, and a couple others since those damages are not released yet.

Ok just wondering what the output meant is all, np

[ImportBot]

Originally Posted by wonz*:

 

[19:25:00 80] [AdKats] Waiting a few seconds for requirements and other plugins to initialize, please wait...

[19:25:00 80] [AdKats] 5...

[19:25:01 80] [AdKats] 4...

[19:25:02 80] [AdKats] 3...

[19:25:03 80] [AdKats] 2...

[19:25:04 80] [AdKats] 1...

[19:25:05 80] [AdKats] Initializing AdKats 3.7.0.1 components.

[19:25:05 80] [AdKats] SUCCESS: Server IP is 198.xx.xxx.xxx:47200!

[19:25:05 91] [AdKats] ERROR: Database connection FAILED with EXCEPTION. Bad credentials, invalid hostname, or invalid port.

[19:25:06 00] [AdKats] AdKats 3.7.0.1 Disabled! =(

i did put the hostname right and the port 3306

been working on this for hours i cant get it to work