Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by AgentHawk*:

 

See if you can get access to create procedures. If you can't, let me know and i'll work on a workaround.

I think thats an Confixx error....Maybe you can help me with that?

 

Greetz

[ImportBot]

Originally Posted by p19blo*:

 

@ C3

 

since upgrading to version 4.0 adkats try connecting to a specific russian server and the database name isnt what ive entered to the config. any help would be appreciated.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Seriously? its your DB, your the one paying for it. If your host won't allow "alter" you may as well go find a better one.

It's not their DB though, it's just their schema, procedures are stored at the global level and run internally with root access which can be a security issue. I'll write a version for fresh installs only that doesn't require a procedure, but it will only work for first time installs.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@ C3

 

since upgrading to version 4.0 adkats try connecting to a specific russian server and the database name isnt what ive entered to the config. any help would be appreciated.

What do you mean it isn't what you entered?

[ImportBot]

Originally Posted by AgentHawk*:

 

awesome....

[ImportBot]

Originally Posted by p19blo*:

 

 

xpkillers stats logger has exact same info on, but no problems there. ive blanked out a few bits for privacy but if you need to see them bits i cant pm you an image link. this worked fine before 4.0

 

if i put the wrong password in then it shows which servers its tryring to connect me to.

InnerException: MySql.Data.MySqlClient.MySqlException: Access denied for user 'vanucci'@'t226.topaz.fastwebserver.de' (using password: YES)

 

thats not my url

 

im with hostgator and my primary domain is battlefieldbible.com for my vps.

[ImportBot]

Originally Posted by AgentHawk*:

 

I got the same error yesterday

[ImportBot]

Originally Posted by lordicon*:

 

 

xpkillers stats logger has exact same info on, but no problems there. ive blanked out a few bits for privacy but if you need to see them bits i cant pm you an image link. this worked fine before 4.0

 

if i put the wrong password in then it shows which servers its tryring to connect me to.

InnerException: MySql.Data.MySqlClient.MySqlException: Access denied for user 'vanucci'@'t226.topaz.fastwebserver.de' (using password: YES)

 

thats not my url

 

im with hostgator and my primary domain is battlefieldbible.com for my vps.

If I am not mistaken t226.topaz.fastwebserver.de is your hosts connection information. Just like with mine when I put my IP it returns my [email protected], 95% of the time it will never come back as your purchased url when using a host like hostgator. Also I would not name the database and user name the same thing, Switch that up a bit, I assume that vanucci? is required because your on a shared hosting and thats your host way of knowing who is who, however I would at least change the username.

 

Your main problem is not that you can not connect to your database because the host name is correct and its connecting fine, Its lookings more alone the issue of privliages not set right. Did you forget to give your new sql user access to that database? Access denied for user 'vanucci'@'t226.topaz.fastwebserver.de'_?

 

I just enlarged your image so I could see the error better. Did you do a backup copy of the database and transfer it to another server or something? Its showing user cpses_vaDgPzzNtg as the DEFINER has no access and not vanucci_adkats4 like you have in the MySQL Username field. If that is the case then your problem would be with the import you did to the hostgator vps database.

 

There was a post made somewhere about when you change a database from one server to another do the export then edit the .sql and change the username listed everywhere in the .sql that says something about the Definer, I am not sure where that post was cause it could help you if that is your problem.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

 

xpkillers stats logger has exact same info on, but no problems there. ive blanked out a few bits for privacy but if you need to see them bits i cant pm you an image link. this worked fine before 4.0

 

if i put the wrong password in then it shows which servers its tryring to connect me to.

InnerException: MySql.Data.MySqlClient.MySqlException: Access denied for user 'vanucci'@'t226.topaz.fastwebserver.de' (using password: YES)

 

thats not my url

 

im with hostgator and my primary domain is battlefieldbible.com for my vps.

Are you running the new webadmin?

 

The user definer error is described in the previous pages with a fix.

[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.

Consider for the moment, why raise it artificially higher when you'd miss these supposed bans, better to be able to retro unban on a case by case then let a bunch thru? Wouldn't it be better to have it ban by weapon stats, instead of a global setting?

 

I got this one a day ago for the sar-21 with DPS @ 25:

 

Hacking/Cheating DPS Automatic Ban [sAR21-33-87-12]

 

"id":"sar-21",

"damage_max":25,

"damage_min":18

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Consider for the moment, why raise it artificially higher when you'd miss these supposed bans, better to be able to retro unban on a case by case then let a bunch thru? Wouldn't it be better to have it ban by weapon stats, instead of a global setting?

 

I got this one a day ago for the sar-21 with DPS @ 25:

 

Hacking/Cheating DPS Automatic Ban [sAR21-33-87-12]

 

"id":"sar-21",

"damage_max":25,

"damage_min":18

Because of hardcore mode. People play on hardcore servers and their weapons do more damage than normal. Health is only 60% on hardcore, so LMGs that deal 34 damage can be 2-hit-kills on those servers. All weapons in hardcore automatically do 40% more damage than normal. Like i said, 50% has worked very well for us, not one single false positive, you will rarely find a damage modder who only adds a few % to their weapon's damage.

[ImportBot]

Originally Posted by jking54*:

 

Because of hardcore mode. People play on hardcore servers and their weapons do more damage than normal. Health is only 60% on hardcore, so LMGs that deal 34 damage can be 2-hit-kills on those servers. All weapons in hardcore automatically do 40% more damage than normal. Like i said, 50% has worked very well for us, not one single false positive, you will rarely find a damage modder who only adds a few % to their weapon's damage.

Some valid points but couldn't it be adjusted for either mode, HC or Normal? Percentages in either case? There will always be the hackers that will come in with a load, but I suspect that many are brighter than this and would want to fly under the radar as it were, to not attract attention with normal damage plus a little bit more...

[ImportBot]

Originally Posted by IAF-SDS*:

 

Because of hardcore mode. People play on hardcore servers and their weapons do more damage than normal. Health is only 60% on hardcore, so LMGs that deal 34 damage can be 2-hit-kills on those servers. All weapons in hardcore automatically do 40% more damage than normal. Like i said, 50% has worked very well for us, not one single false positive, you will rarely find a damage modder who only adds a few % to their weapon's damage.

Hey ColColon.

 

I have to disagree with you on the statement that people who play on Hardcore have weapons that do more damage.

 

Weapons on Hardcore servers do NOT do more damage. They do the same damage whether on normal or hardcore. The only time a weapon will do more damage on one server versus another is if someone plays on an unranked or custom server where the server owner has changed the default 100% bullet damage variable (vars.bulletDamage).

 

It takes less damage to kill on hardcore because you start out with 60% health instead of 100% health, but a bullet fired from a particular gun will do the same damage whether it is fired on hardcore or normal. So your statement that weapons in hardcore do 40% more damage is not the right way to think about it.

 

To illustrate my point: if a player has only 60% health remaining on a normal server after being wounded in a gunfight, the next weapon to shoot him on that normal server cannot be considered as being 40% more powerful than the rest of the weapons on that normal server. It's the same weapon, doing the same damage. The only difference is the player had less health, not the weapon does more damage.

[ImportBot]

Originally Posted by Hutchew*:

 

Actually, just meandering through my NyQuil induced stupor, you could consider the 1st "bullet" in a hardcore server does do a theoretical 40% more damage (of the 100% normally available), but after that first round, then remaining hits would be normal. Purely from a dps/kill perspective, of course.

 

I'll just be over here slobbering in the corner. Happy pneumoniatoc New Year!

 

Hutchew

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hey ColColon.

 

I have to disagree with you on the statement that people who play on Hardcore have weapons that do more damage.

 

Weapons on Hardcore servers do NOT do more damage. They do the same damage whether on normal or hardcore. The only time a weapon will do more damage on one server versus another is if someone plays on an unranked or custom server where the server owner has changed the default 100% bullet damage variable (vars.bulletDamage).

 

It takes less damage to kill on hardcore because you start out with 60% health instead of 100% health, but a bullet fired from a particular gun will do the same damage whether it is fired on hardcore or normal. So your statement that weapons in hardcore do 40% more damage is not the right way to think about it.

 

To illustrate my point: if a player has only 60% health remaining on a normal server after being wounded in a gunfight, the next weapon to shoot him on that normal server cannot be considered as being 40% more powerful than the rest of the weapons on that normal server. It's the same weapon, doing the same damage. The only difference is the player had less health, not the weapon does more damage.

You didn't understand what i said. What i said is from the stats point of view and is correct. For example, if someone plays exclusively hardcore servers, 60% health is 100% to them. According to the stats the SCAR-H does 30 damage, and the headshot bonus is 200%, so a headshot at close range is 60 DPS. In hardcore that = 100 DPS, 40% more than normal.

[ImportBot]

Originally Posted by Hutchew*:

 

You didn't understand what i said. What i said is from the stats point of view and is correct. For example, if someone plays exclusively hardcore servers, 60% health is 100% to them. According to the stats the SCAR-H does 30 damage, and the headshot bonus is 200%, so a headshot at close range is 60 DPS. In hardcore that = 100 DPS, 40% more than normal.

Yeah, I think that's what I was trying to say, but it only "counts" from a dps/kill standpoint on the first shot that hits the target, where it takes the advantage of the reduced player health in HC to generate the initial damage %.

 

Or am I over-thinking this?

 

Hutchew

[ImportBot]

Originally Posted by jking54*:

 

What's the sitrep on the mtar-21 and rpk-74m? I'm getting a boatload of these, tnx.

[ImportBot]

Originally Posted by AgentHawk*:

 

It's not their DB though, it's just their schema, procedures are stored at the global level and run internally with root access which can be a security issue. I'll write a version for fresh installs only that doesn't require a procedure, but it will only work for first time installs.

normally I dont wanna ask...but I need to rent my old DB and Server...So maybe you can give me a approximate time indication?

Thanks alot for your work!

 

btw HAPPY NEW YEAR

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yeah, I think that's what I was trying to say, but it only "counts" from a dps/kill standpoint on the first shot that hits the target, where it takes the advantage of the reduced player health in HC to generate the initial damage %.

 

Or am I over-thinking this?

 

Hutchew

Hmm, rethinking my math here... what is the actual % difference over normal?

 

Lets say a bullet does 25 damage in normal to players with 100 health, 25/100 = 25% of the player's health, leading to a kill/hit calculation of 25 DPS.

 

In hardcore, bullet still does 25 damage, but players have 60 health, 25/60 = 41.6% of the player's health. That would in theory lead to a kill/hit calculation of 42 DPS, not 25. However, the gun is still a "3 hit kill" on average, since the last shot just drops them from 10 HP to 0 instead of -15. So 3 hits to kill equates to 33% of the players health instead of 25%. So bullets for 25 DPS guns will deal 32% more damage than normal according to stats on average.

 

What about higher damage guns? LMGs deal 34 damage. In hardcore that is a "2 hit kill", so according to stats it will be dealing 50% damage. So those weapons deal 47% more damage than normal according to stats.

 

What about lower damage guns? Lower damage guns like auto-pistols deal 18 damage, so they are 6-hit-kills in normal play, 4-hit-kills in hardcore. 4-hit-kill = 25 DPS according to stats so they deal on average 38% more damage than normal.

 

1 hit kill weapons, and weapons that deal 50% or more damage normally are not included in the calculation so those can be ignored.

 

The default trigger level 50 is higher than all of these values, and these are the extremes for someone who plays exclusively hardcore servers and averages head/body/leg shots. So my math checks out.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

What's the sitrep on the mtar-21 and rpk-74m? I'm getting a boatload of these, tnx.

Simple solution, get together with a friend and chest shot each other at close range in single-fire mode. Tell me the DPS and i'll add them. Have not had a reliable source for those guns yet.

[ImportBot]

Originally Posted by IAF-SDS*:

 

You didn't understand what i said. What i said is from the stats point of view and is correct. For example, if someone plays exclusively hardcore servers, 60% health is 100% to them. According to the stats the SCAR-H does 30 damage, and the headshot bonus is 200%, so a headshot at close range is 60 DPS. In hardcore that = 100 DPS, 40% more than normal.

I understood what you said, and it is a common misconception which is why Im trying to help. It is still not correct as stated, even from a stats point of view, which I believe is what you're focusing on here (to determine when someone is cheating based on the amount of damage his weapon does). If we took the SCAR-H and went into a normal server to let you shoot me, and then we went into a hardcore server to let me shoot you, that weapon's damage would be identical for both of us, even though it would take more bullets for you to kill me in the normal server.

 

Otherwise, weapons charts and cheat-o-meters would all be completely out of whack for hardcore players, and all of the those players would look like they were literally using damage hacks because every single one of them would do 40% more damage from your perspective.

 

When cheat detection is used while looking at a player's stats, it technically checks the weapon's bullet damage (regardless of what health the player has at the time he was shot) right? So why does it matter what the player's health is for purposes of checking for a damage hack's bullet damage?

[ImportBot]

Originally Posted by p19blo*:

 

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:

 

 

 

to

 

 

 

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.

ok im a noob. so when you say dump im assuming youre telling me to export the tables to an .sql file and then open it in an editor.

 

I have done this but DEFINER= isnt in it anywhere

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I understood what you said, and it is a common misconception which is why Im trying to help. It is still not correct as stated, even from a stats point of view, which I believe is what you're focusing on here (to determine when someone is cheating based on the amount of damage his weapon does). If we took the SCAR-H and went into a normal server to let you shoot me, and then we went into a hardcore server to let me shoot you, that weapon's damage would be identical for both of us, even though it would take more bullets for you to kill me in the normal server.

 

Otherwise, weapons charts and cheat-o-meters would all be completely out of whack for hardcore players, and all of the those players would look like they were literally using damage hacks because every single one of them would do 40% more damage from your perspective.

 

When cheat detection is used while looking at a player's stats, it technically checks the weapon's bullet damage (regardless of what health the player has at the time he was shot) right? So why does it matter what the player's health is for purposes of checking for a damage hack's bullet damage?

Please read the longer post i made today discussing the full breakdown. Please correct my math if i'm wrong.

[ImportBot]

Originally Posted by p19blo*:

 

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

how do i do this ? is it similar to what is suggested in two posts up ?

[ImportBot]

Originally Posted by AgentHawk*:

 

I got this error....

 

: Line 0: [uploadRecord][unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`sid95555_1`.`adkats_records_debug`, CONSTRAINT `adkats_records_debug_fk_server_id` FOREIGN KEY (`server_id`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE CASCADE)

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.UploadRecord(AdKatsRecord record)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I got this error....

I'll look into it, thanks for posting!

[ImportBot]

Originally Posted by Tomgun*:

 

I really want to use this, where do I get a free host to do it?

[ImportBot]

Originally Posted by 101st-chicago*:

 

Battlelog shows

 

MTAR-21 Damage 30

RPK-74m Damage 30

 

joined normal server and seen the RPK-74m did 25 damage, one shot to the chest.

 

need to unlock the MTAR-21

 

 

is that what u need ?

 

Simple solution, get together with a friend and chest shot each other at close range in single-fire mode. Tell me the DPS and i'll add them. Have not had a reliable source for those guns yet.

[ImportBot]

Originally Posted by p19blo*:

 

only 1 procon layer is giving this back

 

[06:42:36 13] [AdKats] ERROR: player role was null in hasAccess.

[06:42:36 13] [AdKats] EXCEPTION: Line 0: [CompleteRecordInformation][Error occured while completing record information.]: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.AdKats.CompleteRecordInformation(AdKa tsRecord record, String message)

 

any ideas?

 

all 5 server we have running this share same everything. so im a bit fuzzled why only 1 server gives this back ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Battlelog shows

 

MTAR-21 Damage 30

RPK-74m Damage 30

 

joined normal server and seen the RPK-74m did 25 damage, one shot to the chest.

 

need to unlock the MTAR-21

 

 

is that what u need ?

Added. 500 servers are relying on your numbers man