Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by jking54*:

 

All valid, although you might want to look into the L85 one just to confirm it further. The rest of them are blatant.

Thanks C3, will look into that one but nice to know the 25 setting seems to nab a fair amount. HSK seems fine at 50 though from my experiences.

 

EDIT: if you don't mind us putting up some more of these to properly gauge these settings, here's a few more:

 

Hacking/Cheating DPS Automatic Ban [TYPE88LMG-33-114-24]

Hacking/Cheating DPS Automatic Ban [G18-28-105-20]

Hacking/Cheating DPS Automatic Ban [G18-24-271-43]

 

Also, not sure if you touched on this previously but why not equipment, sniper rifles, shotguns, and heavy-hitting pistols like the magnum/rex from calculations? Many pistols, shotty only servers etc. that are out of control with many hackers, would be nice to have these available at some point.

[ImportBot]

Originally Posted by p19blo*:

 

not sure whats causing this to happen whether its adkats or adkatswebadmin so i'll go here first

 

when someone gets banned on our pistol and knife server the webadmin reason for there ban is

Code:

UploadRecord][Unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('cpses_vaDgPzzNtg'@'localhost') does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean f

if this isnt by the plugin here and its webadmin then let me know and i'll ask prophet

[ImportBot]

Originally Posted by mal0mod0*:

 

Getting this error on trying to import. I am at NFO and did see the topic on search..but never really saw a solution if possible? I did contact support and they suggested I post here:

 

Error

 

SQL query:

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

 

MySQL said: Documentation

#1548 - Cannot load from mysql.proc. The table is probably corrupted

 

Looking at the replies in that thread, it seems like your problem is being caused by the procedure command being restricted, due to its global nature. Do you have the newest version of that plugin?

[ImportBot]

Originally Posted by Jamesonp*:

 

Getting this error on trying to import. I am at NFO and did see the topic on search..but never really saw a solution if possible? I did contact support and they suggested I post here:

 

Error

 

SQL query:

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

 

MySQL said: Documentation

#1548 - Cannot load from mysql.proc. The table is probably corrupted

 

Looking at the replies in that thread, it seems like your problem is being caused by the procedure command being restricted, due to its global nature. Do you have the newest version of that plugin?

Did you upgrade the mysql version without upgrading the databases recently (or your host)?

[ImportBot]

Originally Posted by p19blo*:

 

not sure whats causing this to happen whether its adkats or adkatswebadmin so i'll go here first

 

when someone gets banned on our pistol and knife server the webadmin reason for there ban is

Code:

UploadRecord][Unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('cpses_vaDgPzzNtg'@'localhost') does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean f

if this isnt by the plugin here and its webadmin then let me know and i'll ask prophet

also get this when a bans happening. it doesnt upload the ban

Code:

EXCEPTION: Line 0: [UploadRecord][Unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('cpses_vaDgPzzNtg'@'localhost') does not exist

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thanks C3, will look into that one but nice to know the 25 setting seems to nab a fair amount. HSK seems fine at 50 though from my experiences.

 

EDIT: if you don't mind us putting up some more of these to properly gauge these settings, here's a few more:

 

Hacking/Cheating DPS Automatic Ban [TYPE88LMG-33-114-24]

Hacking/Cheating DPS Automatic Ban [G18-28-105-20]

Hacking/Cheating DPS Automatic Ban [G18-24-271-43]

 

Also, not sure if you touched on this previously but why not equipment, sniper rifles, shotguns, and heavy-hitting pistols like the magnum/rex from calculations? Many pistols, shotty only servers etc. that are out of control with many hackers, would be nice to have these available at some point.

The whole point of us creating this system was to avoid false positives at all costs. The type 88 does 25 damage, they were getting 33. G18 does 18 damage, they were getting 28/24. They appear to be legit bans, but i'm not 100% positive. I would honestly suggest raising your trigger level back to at least 40 on DPS.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

not sure whats causing this to happen whether its adkats or adkatswebadmin so i'll go here first

 

when someone gets banned on our pistol and knife server the webadmin reason for there ban is

Code:

UploadRecord][Unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('cpses_vaDgPzzNtg'@'localhost') does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean f

if this isnt by the plugin here and its webadmin then let me know and i'll ask prophet

Wait...that's the ban reason? Or is that what you see in the console? Either way it's because of a table you copied with user information still attached to it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

also get this when a bans happening. it doesnt upload the ban

Code:

EXCEPTION: Line 0: [UploadRecord][Unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('cpses_vaDgPzzNtg'@'localhost') does not exist

That error is from someone copying a previous table and keeping the creation data with it. I don't remember the exact fix but it's simple. I'll get prophet to answer that one since he's run into it before.

[Prophet731]

Originally Posted by Prophet731*:

 

also get this when a bans happening. it doesnt upload the ban

Code:

EXCEPTION: Line 0: [UploadRecord][Unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('cpses_vaDgPzzNtg'@'localhost') does not exist

That error is from someone copying a previous table and keeping the creation data with it. I don't remember the exact fix but it's simple. I'll get prophet to answer that one since he's run into it before.

Yea you need to remove the user definer from the trigger or procedure. I've ran into that so many times its not funny.

[ImportBot]

Originally Posted by jking54*:

 

The whole point of us creating this system was to avoid false positives at all costs. The type 88 does 25 damage, they were getting 33. G18 does 18 damage, they were getting 28/24. They appear to be legit bans, but i'm not 100% positive. I would honestly suggest raising your trigger level back to at least 40 on DPS.

Thanks yes I'll probably adjust it some, but if I may do you have a list of the damages by all weapons so far for reference?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thanks yes I'll probably adjust it some, but if I may do you have a list of the damages by all weapons so far for reference?

Grabbed from here:

http://symthic.com/bf4-weapon-charts...one&attc2=None

 

Imported to AdKats here:

https://github.com/ColColonCleaner/A...aponstats.json

[ImportBot]

Originally Posted by Chilace*:

 

Can you explain how the calculation is performed. Is this just kill/hit ratio ?

[ImportBot]

Originally Posted by jking54*:

 

Grabbed from here:

http://symthic.com/bf4-weapon-charts...one&attc2=None

 

Imported to AdKats here:

https://github.com/ColColonCleaner/A...aponstats.json

Nice, thank you Colonel

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Can you explain how the calculation is performed. Is this just kill/hit ratio ?

kill/hit * 100 = DPS

[ImportBot]

Originally Posted by Chilace*:

 

And how to calculate for the damage multiplier (headshot) or 60% health on hardcore ?

SCAR-H oneshot in head on hardcore = 100 DPS ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

And how to calculate for the damage multiplier (headshot) or 60% health on hardcore ?

That's why the default trigger is +50% over normal. We've tested this on over 700,000 players across our 15 servers on that level without issuing a single false positive ban. If you leave the default settings, you're golden. If you're still worried about false positives at 50, raise the trigger level, that's why it's changeable.

[ImportBot]

Originally Posted by Jamesonp*:

 

not sure whats causing this to happen whether its adkats or adkatswebadmin so i'll go here first

 

when someone gets banned on our pistol and knife server the webadmin reason for there ban is

Code:

UploadRecord][Unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('cpses_vaDgPzzNtg'@'localhost') does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean f

if this isnt by the plugin here and its webadmin then let me know and i'll ask prophet

Just recreate the cpses_vaDgPzzNtg user and grant it permissions to the db. That's the easiest fix.

[ImportBot]

Originally Posted by Chilace*:

 

That's why the default trigger is +50% over normal. We've tested this on over 700,000 players across our 15 servers on that level without issuing a single false positive ban. If you leave the default settings, you're golden. If you're still worried about false positives at 50, raise the trigger level, that's why it's changeable.

"Over 700,000 players" sounds convincing. In any case, can be further tested banned player stats.

[ImportBot]

Originally Posted by Kinsman*:

 

Could not find mtar-21 in BF4 library of 62 weapons

 

There are some stats for the Mtar here, possibly what you need?

 

http://battlefield.wikia.com/wiki/MTAR-21

 

As a newbie I'm also not understanding how to add server rules it seems.

 

https://github.com/ColColonCleaner/A...rules-settings

 

Everytime I add three rules, it reverts back to 3 lines saying "This server has not set rules yet."

 

Is there something I'm missing to make them stick? I also have no idea how to use pre-message ID's there either.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Could not find mtar-21 in BF4 library of 62 weapons

 

There are some stats for the Mtar here, possibly what you need?

 

http://battlefield.wikia.com/wiki/MTAR-21

 

As a newbie I'm also not understanding how to add server rules it seems.

 

https://github.com/ColColonCleaner/A...rules-settings

 

Everytime I add three rules, it reverts back to 3 lines saying "This server has not set rules yet."

 

Is there something I'm missing to make them stick? I also have no idea how to use pre-message ID's there either.

Wikia shows a damage chart that is from the BF3 version of that gun. Although i could add it at the assumed 25 DPS i want to be sure.

 

And for your rules problem (I'm glad you actually read the docs before posting by the way, so many people refuse to do that and it's really annoying.), you are attempting to change the rules in-line. There is a button on the right side of "String[] Array" that just has three dots in it, you need to click that to edit the collection of rules; Add one per line then click ok.

 

For the premessage IDs, it links to what you have set in the premessage list. So for example if in game a "@say 3" means admin say "Don't baserape", then putting a 3 in a line for the rules will add "Don't baserape" to the list when printed in-game.

[ImportBot]

Originally Posted by lordicon*:

 

I am still getting messages about weapons not being there like this.

 

Code:

[AdKats] WARNING: Could not find rpk-74m in BF4 library of 62 weapons.

Still the same 5 weapons. Is there something I need to do to get it fixed? I have restarted Procon many times the past few days and nothing updates that I see.

 

Also Emails only go out from time to time, However I have been getting server crashs after turning on the email system and in the logs during the crash I see this.

 

Code:

[<SendReport>b__70][Error in email sending thread.]: System.NullReferenceException: Object reference not set to an instance of an object. at PRoConEvents.AdKats.EmailHandler.<>c__DisplayClass73.<SendReport>b__70()

Ideas?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I am still getting messages about weapons not being there like this.

 

Code:

[AdKats] WARNING: Could not find rpk-74m in BF4 library of 62 weapons.

Still the same 5 weapons. Is there something I need to do to get it fixed? I have restarted Procon many times the past few days and nothing updates that I see.

 

Also Emails only go out from time to time, However I have been getting server crashs after turning on the email system and in the logs during the crash I see this.

 

Code:

[<SendReport>b__70][Error in email sending thread.]: System.NullReferenceException: Object reference not set to an instance of an object. at PRoConEvents.AdKats.EmailHandler.<>c__DisplayClass73.<SendReport>b__70()

Ideas?

All weapons i have damage stats for are here: https://raw.github.com/ColColonClean...aponstats.json

 

If you find reliable damage stats for the missing weapons i will add them right away.

 

For your email issue, are you saying it crashes when someone send a report? What crashes exactly, you didn't say.

[ImportBot]

Originally Posted by p19blo*:

 

Just recreate the cpses_vaDgPzzNtg user and grant it permissions to the db. That's the easiest fix.

any user i create always has vanucci? prefix and i dont know how to change that

[ImportBot]

Originally Posted by lordicon*:

 

All weapons i have damage stats for are here: https://raw.github.com/ColColonClean...aponstats.json

 

If you find reliable damage stats for the missing weapons i will add them right away.

 

For your email issue, are you saying it crashes when someone send a report? What crashes exactly, you didn't say.

Users send reports and I receive them from time to time, What I am thinking is happening is more then one user sends the report to the server at the same time which causes the problem.

 

Also does the plugin auto update the weapons list or do I have to do something to update it because I cant figure that part out.

[ImportBot]

Originally Posted by Kinsman*:

 

Seems to be up and running, whats the best way to manage the bans etc apart from PhPmyAdmin?

 

Please don't tell me its this, as i just lost 12 hours of my life, and totally rebuilt a webserver from scratch trying to make it work.

 

http://www.adkgamers.com/topic/44514-downloadweb-admin/

[ImportBot]

Originally Posted by Jamesonp*:

 

any user i create always has vanucci? prefix and i dont know how to change that

If that's the case and you don't have direct access to mysql command line tools, you're going to need to create a dump of the database and manually edit each definer line in the sql dump. You will need to specify a user which exists and will access to the db.

 

For example, change:

 

/*!50003 CREATE*/ /*!50017 DEFINER=cpses_vaDgPzzNtg@localhost*/ /*!50003 TRIGGER `adkats_update_point_insert` BEFORE INSERT ON `adkats_records`

to

 

/*!50003 CREATE*/ /*!50017 DEFINER=new_user@localhost*/ /*!50003 TRIGGER `adkats_update_point_insert` BEFORE INSERT ON `adkats_records`

Make sure you change every line in the sql dump which references DEFINER= and then re-import it.

 

Make sure you keep a backup of the original dump just in case you screw it up.

[ImportBot]

Originally Posted by lordicon*:

 

Aside from my last post that has not been answered yet I figured I would post again with this one. I keep getting crash's on the server every time it crash's I get this message.

 

Seems to happen on players using or spamming the /!admin command to call a admin on a player.

Code:

Server Crashed / Blaze Disconnected (65 Players Lost)

What exactly is going on to cause this?

[ImportBot]

Originally Posted by Jamesonp*:

 

Aside from my last post that has not been answered yet I figured I would post again with this one. I keep getting crash's on the server every time it crash's I get this message.

 

Seems to happen on players using or spamming the /!admin command to call a admin on a player.

Code:

Server Crashed / Blaze Disconnected (65 Players Lost)

What exactly is going on to cause this?

This is going to be related to EA Online going down earlier this morning. Blaze is the backend stats reporting system for Battelog.

[ImportBot]

Originally Posted by Kinsman*:

 

Odd, as we got the same message on 1 server twice, the other remained full all morning. We also get the exact same email error too Lordicon.

 

Once more for luck, is there a working webpage to administer this?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Users send reports and I receive them from time to time, What I am thinking is happening is more then one user sends the report to the server at the same time which causes the problem.

 

Also does the plugin auto update the weapons list or do I have to do something to update it because I cant figure that part out.

Alright i may need to add a queuing system for the emails. I'll look into it.