Advanced In-Game Admin and Ban Enforcer - AdKats

[eliiitex]

8 hours ago, Hedius said:

p.s.: short server name means = short version of your server name

Aha okey ill check when i get home. Where do I find this? Is it at the start also where the database info is?

[ColColonCleaner]

6 hours ago, eliiitex said:

Aha okey ill check when i get home. Where do I find this? Is it at the start also where the database info is?

It's in the server settings section.

[eliiitex]

5 hours ago, ColColonCleaner said:

It's in the server settings section.

Its working now thanks!

[GK_Nico]

hello there is a volunteer for the settings because I unfortunately do not see what I can or should adjust

everything is already installed

because I want to ban a few weapons

[ColColonCleaner]

1 hour ago, GK_Nico said:

hello there is a volunteer for the settings because I unfortunately do not see what I can or should adjust

everything is already installed

because I want to ban a few weapons

If you're just looking to ban a few weapons then AdKats is overkill, other plugins like proconrulz or insanelimits are easier to configure for that. And those plugins are able to send punishments through AdKats if you configure them to do so.

There is a 'weapon limiter' in AdKats but it's really only designed for no-explosive servers. https://github.com/AdKats/AdKats#c31-weapon-limiter-settings

[GK_Nico]

10 minutes ago, ColColonCleaner said:

If you're just looking to ban a few weapons then AdKats is overkill, other plugins like proconrulz or insanelimits are easier to configure for that. And those plugins are able to send punishments through AdKats if you configure them to do so.

There is a 'weapon limiter' in AdKats but it's really only designed for no-explosive servers. https://github.com/AdKats/AdKats#c31-weapon-limiter-settings

 

 

Okay yes I know but I don't have the best knowledge of English because I am from Germany

[eliiitex]

11 hours ago, GK_Nico said:

 

 

Okay yes I know but I don't have the best knowledge of English because I am from Germany

Hei, i could do it. If you want to you can dm me on discord Eliiitex#6068

[piupiupiu]

Hi, is it possible to send a sql request to the myphpadmin database to execute for example a ban player?

[ColColonCleaner]

52 minutes ago, piupiupiu said:

Hi, is it possible to send a sql request to the myphpadmin database to execute for example a ban player?

You can insert a record into the adkats_records_main table with all the required info for the ban command, but set adkats_read = N instead of Y. When AdKats detects the new record for your server it will execute the command. To see what the fields should be set to in that table you can issue a permaban on yourself and look at the values that get inserted into adkats_records_main. Don't worry about the record_id, that gets automatically set on insert.

[piupiupiu]

ColColonCleaner 
you can help me there is an idea but so far it’s not possible to implement it through your plugin.
How to find you in a discord?

[ColColonCleaner]

28 minutes ago, piupiupiu said:

ColColonCleaner 
you can help me there is an idea but so far it’s not possible to implement it through your plugin.
How to find you in a discord?

Please either post about it in this thread or send a private message via these forums if you'd like to discuss it privately. Thank you.

[Hodor]

@ColColonCleaner

Hi, how to fix it?
 

[20:37:06 94] [AdKats] EXCEPTION-7604-A22.48-D-FetchUserList-AccessFetching25: [Error while fetching user list.][MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime
   at MySql.Data.Types.MySqlDateTime.GetDateTime()
   at MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(Int32 i)
   at MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(String column)
   at PRoConEvents.AdKats.FetchUserList()]

 

[gooseharrison]

Hey, I cant play on a few servers and a friend said i should check here. Is there a list i can check to see if adkats banned my account?

[Hedius]

7 hours ago, gooseharrison said:

Hey, I cant play on a few servers and a friend said i should check here. Is there a list i can check to see if adkats banned my account?

What's your kick reason? No, there is not. AdKats bans are local on servers only.

Edited March 8, 2020 by Hedius

[Hedius]

Anyways, I found your kick reason. You are globally banned by Battlefield Agency for cheating. Appeal your ban there. https://battlefield.agency/player/0115ee69-be30-4780-8bd9-f0408d42004b

Their discord: https://discord.gg/jPWs6tU

Also you should discuss AdKats bans with the server owner.

[ColColonCleaner]

On 3/7/2020 at 11:38 AM, Hodor said:

@ColColonCleaner

Hi, how to fix it?
 

[20:37:06 94] [AdKats] EXCEPTION-7604-A22.48-D-FetchUserList-AccessFetching25: [Error while fetching user list.][MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime
   at MySql.Data.Types.MySqlDateTime.GetDateTime()
   at MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(Int32 i)
   at MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(String column)
   at PRoConEvents.AdKats.FetchUserList()]

 

Not sure, perhaps your version of mysql updated to a version that the mysql connector in procon doesn't support.

[Hodor]

7 minutes ago, ColColonCleaner said:

Not sure, perhaps your version of mysql updated to a version that the mysql connector in procon doesn't support.

mysql  Ver 15.1 Distrib 5.5.64-MariaDB, for Linux (x86_64) using readline 5.1

[ColColonCleaner]

6 minutes ago, Hodor said:

mysql  Ver 15.1 Distrib 5.5.64-MariaDB, for Linux (x86_64) using readline 5.1

I'm not sure of the differences between each version, haven't kept up with those releases. Try running a previous version of the DB to see if that solves the issue, or just run mysql instead of mariadb.

[Hodor]

2 minutes ago, ColColonCleaner said:

I'm not sure of the differences between each version, haven't kept up with those releases. Try running a previous version of the DB to see if that solves the issue, or just run mysql instead of mariadb.

There are no other ways to fix this?

[ColColonCleaner]

11 minutes ago, Hodor said:

There are no other ways to fix this?

I see a couple other people mentioned this back in 2014. But i can't see the full posts for some reason. Clicking the links takes me to pages without the posts its mentioning.

https://myrcon.net/search/?q=MySqlConversionException&quick=1

@Prophet731 Any idea what's going on with the search?

[Hodor]

6 minutes ago, ColColonCleaner said:

I see a couple other people mentioned this back in 2014. But i can't see the full posts for some reason. Clicking the links takes me to pages without the posts its mentioning.

https://myrcon.net/search/?q=MySqlConversionException&quick=1

@Prophet731 Any idea what's going on with the search?

Here is: 

 

[ColColonCleaner]

18 minutes ago, Hodor said:

Here is: 

 

Look in your adkats_users table. Are there real dates in the expiration column? Or are they all zeros? If they are, then fixing that might be the solution.

[Hodor]

Just now, ColColonCleaner said:

Look in your adkats_users table. Are there real dates in the expiration column? Or are they all zeros? If they are, then fixing that might be the solution.

Yes i had zeros. Fixed.

[maddog]

Hey there,

 

We are getting these exceptions in Hardline, we have updated the stats logger with the correct guys, have the correct BFH.def but i cannot get rid of these errors, also used a blank DB again to see if it could get rid of the errors. Any pointers would be great

 

Thanks

 

[ColColonCleaner]

3 minutes ago, maddog said:

Hey there,

 

We are getting these exceptions in Hardline, we have updated the stats logger with the correct guys, have the correct BFH.def but i cannot get rid of these errors, also used a blank DB again to see if it could get rid of the errors. Any pointers would be great

 

Thanks

 

Just as a sanity check, does your BFHL.def file contain a U_SCORPION code? Or any of the ones that AdKats is claiming are missing?

[maddog]

2 hours ago, ColColonCleaner said:

Just as a sanity check, does your BFHL.def file contain a U_SCORPION code? Or any of the ones that AdKats is claiming are missing?

Thanks for the reply, yes it does. I attached the BHFL.def, if you need to have a look

 

BFHL.def

[ColColonCleaner]

14 hours ago, maddog said:

Thanks for the reply, yes it does. I attached the BHFL.def, if you need to have a look

 

BFHL.def 102.82 kB · 1 download

Hmm. Disable adkats, make sure the auto-enable is off, then reboot your layer. Wait for everything to come online again, then boot up AdKats. Do you see any errors in the plugin console before these messages about the missing definitions?

[maddog]

No errors

68 BFHL weapon stats should that be more?

Thanks for all your help

[Hodor]

What is FreeFall it is BF3:
 

[17:00:28 00] [AdKats] EXCEPTION-7604-A11.9-GetDamageTypeByWeaponCode-KillProcessing37: [No weapon defined for code FreeFall when fetching damage type. Is your DEF file updated?]

 

BF3.def

[ColColonCleaner]

21 hours ago, maddog said:

No errors

68 BFHL weapon stats should that be more?

Thanks for all your help

Weapon stat definitions are different. Those are the damage stats of each weapon and they come from the AdKats github repo. I would suggest checking if proconrulz or similar plugins are able to limit things. For example if you make proconrulz admin kill players for using damage type ProjectileExplosive that should trigger when people use one of the different RPGs in the game. If that works properly then it's AdKats fault, if that doesn't work then there is a larger problem and procon doesn't know the weapon damage types either.

27 minutes ago, Hodor said:

What is FreeFall it is BF3:
 

[17:00:28 00] [AdKats] EXCEPTION-7604-A11.9-GetDamageTypeByWeaponCode-KillProcessing37: [No weapon defined for code FreeFall when fetching damage type. Is your DEF file updated?]

 

BF3.def 192.41 kB · 0 downloads

Hodor, the def file you attached doesn't contain a line for FreeFall. You'll need to add it.