Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by 101st-chicago*:

 

did u just add the RPK-74m ?

 

I have the MTAR unlocked now will check

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

did u just add the RPK-74m ?

 

I have the MTAR unlocked now will check

I added the mtar with 25max 18min.

[ImportBot]

Originally Posted by 101st-chicago*:

 

MTAR-21 is also 25

[ImportBot]

Originally Posted by jking54*:

 

Out of all the automatic bans I've had, only one has applied to have his ban lifted, here is his situation:

 

DPS set to 25:

 

Hacking/Cheating DPS Automatic Ban [93R-24-160-28]

 

also, experimented with HSK at 38, too low?

 

here's a few with that setting:

 

Hacking/Cheating HSK Automatic Ban [uMP45-75-114-86]

 

Hacking/Cheating HSK Automatic Ban [ACE23-43-367-159]

 

I'll move HSK back to 50 if this is for the best

[ImportBot]

Originally Posted by ixnorp*:

 

hey c3, under which mysql table can i find which admin used the in game commands? Couldn't find anything in my xpkiller chatlog, or adkats record main. I'm lost.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Out of all the automatic bans I've had, only one has applied to have his ban lifted, here is his situation:

 

DPS set to 25:

 

Hacking/Cheating DPS Automatic Ban [93R-24-160-28]

 

also, experimented with HSK at 38, too low?

 

here's a few with that setting:

 

Hacking/Cheating HSK Automatic Ban [uMP45-75-114-86]

 

Hacking/Cheating HSK Automatic Ban [ACE23-43-367-159]

 

I'll move HSK back to 50 if this is for the best

Like I told others, dont TRY to get people banned. We have caught countless hackers with the default settings (50 and 50) with very very minimal false positives, and I would suggest those settings to all others who use the system.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hey c3, under which mysql table can i find which admin used the in game commands? Couldn't find anything in my xpkiller chatlog, or adkats record main. I'm lost.

It would be in adkats_records_main, look through the source_name column for the admin names issuing the commands.

[ImportBot]

Originally Posted by MarcoV1980*:

 

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.

Can this be used if i am getting the error

 

Code:

SQL-query:

DROP TRIGGER IF EXISTS  `tbl_chatlog_player_id_insert` $$

MySQL :

#1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

It does create the procedure, i can execute it manually, but for some reason it refuses to work when i try to run the full query in the .sql file.

 

Already contacted host, they said they can't give more rights to the admin user i am already running

[ImportBot]

Originally Posted by 101st-chicago*:

 

50 for DPS

50 for HSK

 

is that the recommend setting ?

 

Like I told others, dont TRY to get people banned. We have caught countless hackers with the default settings (50 and 50) with very very minimal false positives, and I would suggest those settings to all others who use the system.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

50 for DPS

50 for HSK

 

is that the recommend setting ?

Correct 50 and 50. I have it as 70 in the actual plugin default for HSK but 50 is best for that too.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Can this be used if i am getting the error

 

Code:

SQL-query:

DROP TRIGGER IF EXISTS  `tbl_chatlog_player_id_insert` $$

MySQL :

#1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

It does create the procedure, i can execute it manually, but for some reason it refuses to work when i try to run the full query in the .sql file.

 

Already contacted host, they said they can't give more rights to the admin user i am already running

That trigger is the most important part, it actually fills the IDs. Try just this, maybe it's just blocking your ability to drop triggers, not create them:

 

DELIMITER $$

CREATE TRIGGER `tbl_chatlog_player_id_insert` BEFORE INSERT ON `tbl_chatlog`

FOR EACH ROW BEGIN

SET NEW.logPlayerID = (SELECT `PlayerID` FROM `tbl_playerdata` WHERE `SoldierName` = NEW.logSoldierName LIMIT 1);

END

$$

DELIMITER ;

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

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 ?

Hmmm, the roles weren't loaded, database lag during startup most likely. I'm assuming you tried restarting the layer and that hasn't fixed the issue?

[ImportBot]

Originally Posted by MarcoV1980*:

 

That trigger is the most important part, it actually fills the IDs. Try just this, maybe it's just blocking your ability to drop triggers, not create them:

 

DELIMITER $$

CREATE TRIGGER `tbl_chatlog_player_id_insert` BEFORE INSERT ON `tbl_chatlog`

FOR EACH ROW BEGIN

SET NEW.logPlayerID = (SELECT `PlayerID` FROM `tbl_playerdata` WHERE `SoldierName` = NEW.logSoldierName LIMIT 1);

END

$$

DELIMITER ;

Hey, thanks.

 

But unfortunately i am getting the same error. Do you have any other options to try by any chance? I asked the hoster about this, and they said they can't give more rights since it's a shared platform.

 

Even tried setting up a local mysql and setting everything up on there. Which went fine, but as soon as i try to export it over, i am getting the same errors again

[ImportBot]

Originally Posted by jking54*:

 

Correct 50 and 50. I have it as 70 in the actual plugin default for HSK but 50 is best for that too.

70 would've been ridiculous, you'd miss a s**t ton of hacks but I have mine at 40 and DPS at 30, DPS I may raise up a bit more, just experimenting with how to read the auto bans correctly. I get how to read the DPS now but how do you correctly read the HSK from the numbers?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hey, thanks.

 

But unfortunately i am getting the same error. Do you have any other options to try by any chance? I asked the hoster about this, and they said they can't give more rights since it's a shared platform.

 

Even tried setting up a local mysql and setting everything up on there. Which went fine, but as soon as i try to export it over, i am getting the same errors again

Ask them if they can run the setup script on your database.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

70 would've been ridiculous, you'd miss a s**t ton of hacks but I have mine at 40 and DPS at 30, DPS I may raise up a bit more, just experimenting with how to read the auto bans correctly. I get how to read the DPS now but how do you correctly read the HSK from the numbers?

I released with those values since it would cause 0 false positives, a safe release value. It's your job to find the values you deem valid. The suggested values are 50 and 50.

[ImportBot]

Originally Posted by MarcoV1980*:

 

Ask them if they can run the setup script on your database.

Either that or hoping they can set it too--log-bin-trust-function-creators which would eliminate the need for the SUPER. Fingers crossed.

 

Awesome to see how far you have come with your plugin compared to the early releases.

 

Thanks again.

[ImportBot]

Originally Posted by KTFO-SGTmoody*:

 

just wondering. has anyone else had these erros spew out of adkats. They happen quite often. This is a new install and a new database. Instructions where follows as to how to instll adkats.

 

Line 0: [PlayerListingThreadLoop][Error occured in player listing thread.]: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.AdKats.PlayerListingThreadLoop()

[10:27:53 12] [AdKats] EXCEPTION: Line 0: [FetchPlayer][Error while fetching player.]: MySql.Data.MySqlClient.MySqlException: Unknown column 'GameID' in 'field list'

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.ExecuteReader( )

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

 

Thanks

[ImportBot]

Originally Posted by MarcoV1980*:

 

[10:27:53 12] [AdKats] EXCEPTION: Line 0: [FetchPlayer][Error while fetching player.]: MySql.Data.MySqlClient.MySqlException: Unknown column 'GameID' in 'field list'

Seems the install wasn't complete. You are missing a column.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

just wondering. has anyone else had these erros spew out of adkats. They happen quite often. This is a new install and a new database. Instructions where follows as to how to instll adkats.

 

Line 0: [PlayerListingThreadLoop][Error occured in player listing thread.]: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.AdKats.PlayerListingThreadLoop()

[10:27:53 12] [AdKats] EXCEPTION: Line 0: [FetchPlayer][Error while fetching player.]: MySql.Data.MySqlClient.MySqlException: Unknown column 'GameID' in 'field list'

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.ExecuteReader( )

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

 

Thanks

Which version of stat logger are you using?

[ImportBot]

Originally Posted by Narf!*:

 

Hello =)

 

I had the option "Feed Stat Logger Settings" enabled but after that I've noticed that the stats aren't submitted right. I don't think this was related to all users stats, but all guys that are set up as admin didn't get any stats logged. Disabled this function and stats logging is running fine now again. Just want to tell you.

 

Greetz

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello =)

 

I had the option "Feed Stat Logger Settings" enabled but after that I've noticed that the stats aren't submitted right. I don't think this was related to all users stats, but all guys that are set up as admin didn't get any stats logged. Disabled this function and stats logging is running fine now again. Just want to tell you.

 

Greetz

The only thing i feed for the general public is "Server Time Offset", which is changed to operate in UTC time. That setting will not affect which players get their stats logged. Also, when you turn it off the setting stays, so disabling "Feed Stat Logger Settings" would not have changed your logging in any way.

[ImportBot]

Originally Posted by Narf!*:

 

Well, just can say what happened. Option enabled -> Admin accounts got no stats logging. Disabled this option, stats logging for the admin accounts started being normally. Just thought about this because of you told me the thing with the reserved slots in another thread. This is why I tried this option. And it works. I don't know why...

[ImportBot]

Originally Posted by AgentHawk*:

 

a Ban Propagation to Metabans and Twitter will be nice...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

a Ban Propagation to Metabans and Twitter will be nice...

Planned.

[ImportBot]

Originally Posted by Hutchew*:

 

JabJab...........

 

Ban button and premessages for reasons in Webadmin..............

 

JabJab..........

 

 

 

[ImportBot]

Originally Posted by jking54*:

 

I had a guy who got DPS banned today using the G18, my setting is still at 30 but his ban was...

 

G18-29-51-47

 

which is 150%, of course he swears up and down he was using no hacks.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

JabJab...........

 

Ban button and premessages for reasons in Webadmin..............

 

JabJab..........

 

 

 

Why are you jabbing my sides for prophet's problems? lol

[Prophet731]

Originally Posted by Prophet731*:

 

JabJab...........

 

Ban button and premessages for reasons in Webadmin..............

 

JabJab..........

 

 

 

Jab back at you.

 

It's already there. Did you update to the latest version here

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I had a guy who got DPS banned today using the G18, my setting is still at 30 but his ban was...

 

G18-29-51-47

 

which is 150%, of course he swears up and down he was using no hacks.

Right... 150% > 130%, not seeing the issue here. I'm more worried about his 92% hsk with an automatic pistol.