Advanced In-Game Admin and Ban Enforcer - AdKats

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Please do it soon mate.

 

Let me know if i can be of any help.

Try this first.

 

Disable automatic updates. Section D99.

 

Download 6.0.0.0 from the sourceforge page. http://sourceforge.net/projects/adkats/files/

 

Run that on your layers for now, you should not see any errors. If you do see errors you may need to stay on 6.5.0.0.

 

Let me know if that fixes the issue temporarily.

[ImportBot]

Originally Posted by smogsy*:

 

Try this query. Replace the text that says "ReplaceThisWithPlayerName" leaving both percent signs in beginning and end of the string. You can do partal name search with this and it will return any player that has those matching names and was banned less than 2 week ago.

 

Code:

SELECT 
    `adkats_bans`.`ban_id`,
    `adkats_bans`.`player_id`,
    `tbl_playerdata`.`SoldierName`,
    `tbl_games`.`Name` AS 'Game',
    `adkats_bans`.`ban_status`,
    `adkats_bans`.`ban_startTime`,
    `adkats_bans`.`ban_endTime`
FROM
    `adkats_bans`
        INNER JOIN
    `tbl_playerdata` ON `adkats_bans`.`player_id` = `tbl_playerdata`.`PlayerID`
        INNER JOIN
    `tbl_games` ON `tbl_playerdata`.`GameID` = `tbl_games`.`GameID`
WHERE
    `adkats_bans`.`ban_startTime` >= DATE_SUB(UTC_TIMESTAMP(),
        INTERVAL 2 WEEK)
        AND `tbl_playerdata`.`SoldierName` LIKE '%ReplaceThisWithPlayerName%'
ORDER BY `adkats_bans`.`ban_status` , `adkats_bans`.`ban_startTime`

Their you go

ban_id player_id SoldierName Game ban_status ban_startTime ban_endTime

443 68359 Illicit_Stimpy BF4 Disabled 2015-02-28 18:18:01 2015-03-01 00:00:00

71 10064 Illicit_Stimpy BF4 Disabled 2015-03-08 18:16:00 2035-03-08 18:16:00

 

also seem interesting (2nd id)

ID

68359

Game

BF4

EAGUID

EA_4E42635A80336DE2EDCDFCC116224AEC

PBGUID

ec5cf0a35fb085afe77b8f0f29f64b99

IP

xxxxxxxxxx

Last Seen

3 days ago

 

ID

10064

Game

BF4

EAGUID

PBGUID

N/A

IP

N/A

Last Seen

N/A

Country

N/A

[ImportBot]

Originally Posted by DevilOmaxe*:

 

Try this first.

 

Disable automatic updates. Section D99.

 

Download 6.0.0.0 from the sourceforge page. http://sourceforge.net/projects/adkats/files/

 

Run that on your layers for now, you should not see any errors. If you do see errors you may need to stay on 6.5.0.0.

 

Let me know if that fixes the issue temporarily.

Hello, Do i need to run SQL Script too?

[Prophet731]

Originally Posted by Prophet731*:

 

Their you go

ban_id player_id SoldierName Game ban_status ban_startTime ban_endTime

443 68359 Illicit_Stimpy BF4 Disabled 2015-02-28 18:18:01 2015-03-01 00:00:00

71 10064 Illicit_Stimpy BF4 Disabled 2015-03-08 18:16:00 2035-03-08 18:16:00

 

also seem interesting (2nd id)

ID

68359

Game

BF4

EAGUID

EA_4E42635A80336DE2EDCDFCC116224AEC

PBGUID

ec5cf0a35fb085afe77b8f0f29f64b99

IP

xxxxxxxxxx

Last Seen

3 days ago

 

ID

10064

Game

BF4

EAGUID

PBGUID

N/A

IP

N/A

Last Seen

N/A

Country

N/A

Hmm... Can you PM database creds so I can see and hopefully fix your problem? From the looks of it the 2nd player is missing the EAGUID, which is an invalid player. If you have teamspeak you can hop on ADKs teamspeak if you would prefer that.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello, Do i need to run SQL Script too?

No, do not do that. If you run that script you will wipe your settings.

[ImportBot]

Originally Posted by HARAFAT69*:

 

hi, my problem is i can't use commands ( for server i guest role or i tape command and no reponse no info for adkats)

 

what the probleme ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hi, my problem is i can't use commands ( for server i guest role or i tape command and no reponse no info for adkats)

 

what the probleme ?

Add a user with your soldier name, and change your role to full admin.

[ImportBot]

Originally Posted by jking54*:

 

Hi Col, can you refresh me as to this email error?

 

used to know this but setting up emailing (using Gmail btw), I get this:

 

EXCEPTION: Line Unknown-6519: [EmailProcessingThreadLoop][Error occured in mail processing thread. skipping loop.]: System.Net.Mail.SmtpException: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. e1sm3712086igl.19 - gsmtp

at System.Net.Mail.MailCommand.CheckResponse(SmtpStat usCode statusCode, String response)

at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, String from)

at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)

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

at PRoConEvents.AdKats.EmailHandler.EmailProcessingTh readLoop()

 

btw, what happened to the whitelists? I don't see them.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi Col, can you refresh me as to this email error?

 

used to know this but setting up emailing (using Gmail btw), I get this:

 

EXCEPTION: Line Unknown-6519: [EmailProcessingThreadLoop][Error occured in mail processing thread. skipping loop.]: System.Net.Mail.SmtpException: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. e1sm3712086igl.19 - gsmtp

at System.Net.Mail.MailCommand.CheckResponse(SmtpStat usCode statusCode, String response)

at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, String from)

at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)

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

at PRoConEvents.AdKats.EmailHandler.EmailProcessingTh readLoop()

 

btw, what happened to the whitelists? I don't see them.

Remember to use port 587 for gmail, not the standard 465. Also, make sure you've authorized your procon layer on gmail.

 

Which whitelists are you referring to?

[ImportBot]

Originally Posted by jking54*:

 

Remember to use port 587 for gmail, not the standard 465. Also, make sure you've authorized your procon layer on gmail.

 

Which whitelists are you referring to?

with 587 you're referring to external clients such as Outlook? I'm in my Gmail right now, but don't as yet see where you would auth procon layer.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Please do it soon mate.

 

Let me know if i can be of any help.

How often do you use the following commands:

 

Nuke

Countdown

SwapNuke

KickAll

[ImportBot]

Originally Posted by smogsy*:

 

Hmm... Can you PM database creds so I can see and hopefully fix your problem? From the looks of it the 2nd player is missing the EAGUID, which is an invalid player. If you have teamspeak you can hop on ADKs teamspeak if you would prefer that.

Could this happen if someone banned him through procon ui vs in-game Or in the webpage?

 

Just curious as I believe one member has banned that way.

Cheers for help try to get on TS tonight

[ImportBot]

Originally Posted by jking54*:

 

Just got this:

 

[08:44:29 00] [AdKats] ERROR: AdKats.cs (Line: 1, C: 2) CS1056: Unexpected character '»'

[08:44:29 00] [AdKats] ERROR: AdKats.cs (Line: 1, C: 3) CS1056: Unexpected character '¿'

[08:44:29 00] [AdKats] ERROR: AdKats.cs (Line: 1, C: 1) CS0116: A namespace does not directly contain members such as fields or methods

[08:44:31 89] [AdKats] ERROR: Authorized soldier fetch canceled. Authorized soldiers requested before user list fetched.

 

also, I noticed most of my Full Admin role settings are set to Deny? Why aren't they all set to Allow? Perhaps I fubar'd a setting?

 

still cannot get email to work, have allow less secure apps in gmail, still no joy

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Just got this:

 

[08:44:29 00] [AdKats] ERROR: AdKats.cs (Line: 1, C: 2) CS1056: Unexpected character '»'

[08:44:29 00] [AdKats] ERROR: AdKats.cs (Line: 1, C: 3) CS1056: Unexpected character '¿'

[08:44:29 00] [AdKats] ERROR: AdKats.cs (Line: 1, C: 1) CS0116: A namespace does not directly contain members such as fields or methods

[08:44:31 89] [AdKats] ERROR: Authorized soldier fetch canceled. Authorized soldiers requested before user list fetched.

 

also, I noticed most of my Full Admin role settings are set to Deny? Why aren't they all set to Allow? Perhaps I fubar'd a setting?

 

still cannot get email to work, have allow less secure apps in gmail, still no joy

The first is a problem with automatic updates, i'll look into it but it's not priority right now (doesn't affect operation), i think the line encoding is messed up. I'm not seeing them on my end, but if you continue to see those let me know, disabling automatic updates will stop that process.

 

The second should not happen, i'm not sure where it's trying to fetch admins before users, but it can be safely ignored for now.

 

Third, if you recently updated after being away so long you probably fetched a couple new commands which have been added since you left. I think we're up to around 100 usable commands in-game now. When a new command is discovered it is enabled but denied for all roles by default because I can't predict what people want on their servers. All new commands need to be manually allowed for each role you want to access them.

[ImportBot]

Originally Posted by jking54*:

 

The first is a problem with automatic updates, i'll look into it but it's not priority right now (doesn't affect operation), i think the line encoding is messed up. I'm not seeing them on my end, but if you continue to see those let me know, disabling automatic updates will stop that process.

 

The second should not happen, i'm not sure where it's trying to fetch admins before users, but it can be safely ignored for now.

 

Third, if you recently updated after being away so long you probably fetched a couple new commands which have been added since you left. I think we're up to around 100 usable commands in-game now. When a new command is discovered it is enabled but denied for all roles by default because I can't predict what people want on their servers. All new commands need to be manually allowed for each role you want to access them.

rgr that, yep lotta ketchin up to do, thanks for your help in pm's

[Prophet731]

Originally Posted by Prophet731*:

 

Could this happen if someone banned him through procon ui vs in-game Or in the webpage?

 

Just curious as I believe one member has banned that way.

Cheers for help try to get on TS tonight

No, all bans leading up to AdKats 7.0 requires a player and the player MUST have a EA GUID. So if the EAGUID got wiped from a player then they are Invalid unless you can find their original EA GUID and update that player in the database.

 

Just let me know when you're getting on.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

No, all bans leading up to AdKats 7.0 requires a player and the player MUST have a EA GUID. So if the EAGUID got wiped from a player then they are Invalid unless you can find their original EA GUID and update that player in the database.

 

Just let me know when you're getting on.

That stat logger bug is getting really annoying...

 

I'll just add guid logging so we can auto-recover guids.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

The automatic update issue should be fixed.

[ImportBot]

Originally Posted by HARAFAT69*:

 

Add a user with your soldier name, and change your role to full admin.

tried and don't work i tape command no answer for adkats...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

tried and don't work i tape command no answer for adkats...

Please post your AdKats startup messages shown in the plugin section.

[ImportBot]

Originally Posted by DevilOmaxe*:

 

How often do you use the following commands:

 

Nuke

Countdown

SwapNuke

KickAll

I never used any of these.

[ImportBot]

Originally Posted by EntraVenuS*:

 

does nuke even work as we have tried it and it dont work

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

does nuke even work as we have tried it and it dont work

It's been used by many communities through AdKats for over a year. Some even use the auto-nuke functionality.

 

How are you attempting to call the nuke?

[ImportBot]

Originally Posted by EntraVenuS*:

 

!nuke, /nuke @nuke etc

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

!nuke, /nuke @nuke etc

What is the response? It will tell you to specify a team to nuke.

[ImportBot]

Originally Posted by EntraVenuS*:

 

i will try later

[ImportBot]

Originally Posted by DevilOmaxe*:

 

This is something I was worried about seeing again. One person had the error before and now two. I'll be looking into this quickly now.

 

How long will the plugin run until you see this happen?

This issue did not happen on Previous version of Plugin.. I am going to Test new version again Today to see if it still gives errors.

 

P.S. I quoted wrong post lol.. I am talking about "source player not found for in game command" Issue..

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Instead of releasing a patched version of stat logger to fix the empty player data update bug we created a trigger to block the bug at the database level.

 

Basically if stat logger attempts to empty out or nullify soldier names, guids, pbguids, or IPs on an existing player, this trigger will block it from doing so.

 

All current users of this plugin should apply the following trigger to their databases.

 

Code:

DELIMITER $$
CREATE TRIGGER
    Player_Update_BlankDataFix
BEFORE UPDATE ON
    tbl_playerdata
FOR EACH ROW
BEGIN
    IF (NEW.SoldierName IS NULL OR CHAR_LENGTH(NEW.SoldierName) = 0) AND OLD.SoldierName IS NOT NULL
        THEN SET NEW.SoldierName = OLD.SoldierName;
    END IF;
    IF (NEW.EAGUID IS NULL OR CHAR_LENGTH(NEW.EAGUID) = 0) AND OLD.EAGUID IS NOT NULL
        THEN SET NEW.EAGUID = OLD.EAGUID;
    END IF;
    IF (NEW.PBGUID IS NULL OR CHAR_LENGTH(NEW.PBGUID) = 0) AND OLD.PBGUID IS NOT NULL
        THEN SET NEW.PBGUID = OLD.PBGUID;
    END IF;
    IF (NEW.IP_Address IS NULL OR CHAR_LENGTH(NEW.IP_Address) = 0) AND OLD.IP_Address IS NOT NULL
        THEN SET NEW.IP_Address = OLD.IP_Address;
    END IF;
END;
$$

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

UPDATE

 

Firstly, a big thank you to those who donated or purchased plugins/features from me over the past couple months. Those donations were enough to keep me alive and under a roof when between jobs at the end of college. I have now graduated, and just completed my first week employed as a full-time software engineer.

 

Secondly, the AdKats plugin is being updated to function on Battlefield Hardline servers. That compatibility release will happen either the 17th or 18th after Procon releases their official updates and I've tested some of the new logic on live hardline servers. Some back end logic for distinction of functions between BF3/BF4/BFH needs to happen. This compatibility release will be version 6.6.0.0.

 

Thirdly, after that compatibility release is complete all AdKats related products will be under code freeze until the alpha/beta version of AdKats 7 is ready. The plugin is being completely rebuilt from the ground up to operate as an engine for other plugin's functionality. This means the advanced in-game admin, ban enforcer, loadout enforcer, anti-cheat, spambot, ping enforcer, etc, etc, will not be part of the AdKats plugin itself anymore. They will all be separate plugins utilizing the AdKats API. A full post containing details about this change is being prepared, but it will contain a lot of information so please be patient while design is completed. Basically AdKats will no longer be a monolith. A good analogy of what i'm going for is an amped up InsaneLimits for entire plugins, a buffer between Procon and plugins where a lot more functionality and features are made easily available. The first set of such plugins will be the current functionality groups AdKats has.

[ImportBot]

Originally Posted by DevilOmaxe*:

 

Hello, Sorry for Posting this

 

Will 6.6.0.0 Version address the "source player not Found" issue?

 

And thanks for your Great work mate i would love to donate once my Bank (f&*@ s$#t) reactivates my International Transactions..

 

GG