Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Timm*:

 

As I understand it, I can add a player by editing the date of his joining to the server.

I not found date on tbl_playerdata table. Can you tell me in which table I can find it?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

As I understand it, I can add a player by editing the date of his joining to the server.

I not found date on tbl_playerdata table. Can you tell me in which table I can find it?

Code:

SELECT    tbl_playerstats .*
FROM
tbl_server_player
    INNER JOIN
tbl_playerstats ON tbl_playerstats.StatsID = tbl_server_player.StatsID
WHERE
tbl_server_player.PlayerID = (select PlayerID from tbl_playerdata where SoldierName = 'ColColonCleaner')
ORDER BY 
tbl_playerstats.FirstSeenOnServer
LIMIT 1

You can edit the FirstSeenOnServer value on this record for the player you want able to join. Just change my name to their name.

 

The update query would be

Code:

update tbl_playerstats set FirstSeenOnServer = '2018-10-9' where StatsID = whateveryougotpreviously

EDIT: Added tbl_playerstats table name to the select section.

[ImportBot]

Originally Posted by Timm*:

 

So, SQL request must next?

Code:

SELECT    *

FROM

tbl_server_player

    INNER JOIN

tbl_playerstats ON tbl_playerstats.StatsID = tbl_server_player.StatsID

WHERE

tbl_server_player.PlayerID = (select PlayerID from tbl_playerdata where SoldierName = 'Player1')

ORDER BY

tbl_playerstats set FirstSeenOnServer = '2018-10-9' where StatsID = whateveryougotpreviously

LIMIT 1

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

No, run this to get his StatsID.

 

Code:

SELECT  tbl_playerstats .StatsID
FROM
tbl_server_player
    INNER JOIN
tbl_playerstats ON tbl_playerstats.StatsID = tbl_server_player.StatsID
WHERE
tbl_server_player.PlayerID = (select PlayerID from tbl_playerdata where SoldierName = 'Player1')
ORDER BY 
tbl_playerstats.FirstSeenOnServer
LIMIT 1

Plug that StatsID into this query to update when he joined.

 

Code:

UPDATE tbl_playerstats SET FirstSeenOnServer = '2018-10-9' WHERE StatsID = 999999999

[ImportBot]

Originally Posted by Timm*:

 

Sorry, but it's not help.

 

On BFACP player's page his first joined date changed, but player can't join to server.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Sorry, but it's not help.

 

On BFACP player's page his first joined date changed, but player can't join to server.

Problem 1: That data might be cached in AdKats memory. Try rebooting your procon layer and have them join again.

 

Problem 2: It might be a timezone issue. The dates are shown in UTC time so perhaps make the date they joined a little further in the past. (the format of that date is year-month-day)

 

If none of those work let me know.

[ImportBot]

Originally Posted by Timm*:

 

So, restarting layers helped.

Looks like cached in Adkats memory, becuase i added 1 month.

 

Thank you, it's work perfect now.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

So, restarting layers helped.

Looks like cached in Adkats memory, becuase i added 1 month.

 

Thank you, it's work perfect now.

Cool. Yeah it doesn't expect that data to change so I have it cached to avoid extra calls to the DB. I keep player objects in memory for 2 hours after they go offline.

[ImportBot]

Originally Posted by Hodor*:

 

Two people were banned with this cause.

KPM Ban [LIVE][5-L25-27] What does L25 mean?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Two people were banned with this cause.

KPM Ban [LIVE][5-L25-27] What does L25 mean?

5-L25-27

 

There are two durations for the LIVE KPM auto ban, low and high, 60 seconds and 120 seconds respectively.

L here means low, so looking at the past 60 seconds of gameplay. 25 means that's how many kills they need to get to trigger the script, changes based on a few metrics.

 

Your player got 27 kills in 1 minute so the script banned him.

[ImportBot]

Originally Posted by xloneshadowx*:

 

Hello, what am I doing wrong here with email settings I went through this forum and changed things and changed again still getting nothing I don't even get any error messages from adkats. I'm sure it's something stupid I mised. I am using Procon layer btw

Screenshot (79)_LI.jpg

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello, what am I doing wrong here with email settings I went through this forum and changed things and changed again still getting nothing I don't even get any error messages from adkats. I'm sure it's something stupid I mised. I am using Procon layer btw

Screenshot (79)_LI.jpg

For applications to access gmail now you need to create an application password and give that password to adkats, if i remember correctly.

[ImportBot]

Originally Posted by xloneshadowx*:

 

For applications to access gmail now you need to create an application password and give that password to adkats, if i remember correctly.

well I am getting an error message now that i never got Screenshot (80).png

[ImportBot]

Originally Posted by spatieman*:

 

yhm, as i know gmail is using a higer security level, i am unable to connect to gmail with thunderbird to it, due the lack of thunderbird suporting this layer.

i had to lower the security lvl on gmail to access it.

i guess, this could be the case here.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

yhm, as i know gmail is using a higer security level, i am unable to connect to gmail with thunderbird to it, due the lack of thunderbird suporting this layer.

i had to lower the security lvl on gmail to access it.

i guess, this could be the case here.

Probably the case. If thunderbird doesn't support it, and that's a dedicated email application, I don't think AdKats has a chance with it. Especially since we're still on .NET 3.5 which is ancient at this point.

[ImportBot]

Originally Posted by serialkillerz82*:

 

Hi, ok so im looking to add a challenge along the following lines:

 

A player is on a killing streak of 'x' amount so the challenge starts. Who ever kills the player on the streak gets 24 hours free VIP (for example).

 

I don't know if anyone can help with this? I have adkats working & also VIP slot manager.

 

Thanks again

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi, ok so im looking to add a challenge along the following lines:

 

A player is on a killing streak of 'x' amount so the challenge starts. Who ever kills the player on the streak gets 24 hours free VIP (for example).

 

I don't know if anyone can help with this? I have adkats working & also VIP slot manager.

 

Thanks again

That is not how this challenge system works. It sounds like something you could do with insane limits though. Tag it onto the an existing basic challenge script from there.

 

The challenge system in AdKats is much more complicated, it doesn't use kill streaks.

[ImportBot]

Originally Posted by serialkillerz82*:

 

Thanks for the reply I will ask there. Thanks again.

[ImportBot]

Originally Posted by sixpax12*:

 

[06:24:10 83] [AdKats] EXCEPTION-7500-A61.56-GetDamageTypeByWeaponCode-KillProcessing3: [No matching weapon in dictionary for XP7/Objects/Bridge_Repairable/Bridge_E/bridge_E_repairable_R when fetching damage type.]

 

... anything to worry about ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

[06:24:10 83] [AdKats] EXCEPTION-7500-A61.56-GetDamageTypeByWeaponCode-KillProcessing3: [No matching weapon in dictionary for XP7/Objects/Bridge_Repairable/Bridge_E/bridge_E_repairable_R when fetching damage type.]

 

... anything to worry about ?

I assume this is a glitch. Unless you see this quite a bit I don't think it's likely someone was killing people with a bridge object.

[ImportBot]

Originally Posted by leibhold*:

 

I assume this is a glitch. Unless you see this quite a bit I don't think it's likely someone was killing people with a bridge object.

But that I would love to see in action...

[ImportBot]

Originally Posted by xloneshadowx*:

 

Trying out the Challenge system put in place this Error shows up all the time, however, I think its working though. This error might not even br realated to the challenge system not sure.

 

[12:37:01 72] [AdKats] ERROR-7500: [Loaded round ID was invalid when assigning entry.]

 

Screenshot (126).png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Trying out the Challenge system put in place this Error shows up all the time, however, I think its working though. This error might not even br realated to the challenge system not sure.

 

[12:37:01 72] [AdKats] ERROR-7500: [Loaded round ID was invalid when assigning entry.]

 

Screenshot (126).png

Hmm. Try rebooting your procon layer. It appears to have loaded an old round ID. If that doesn't fix it let me know.

[ImportBot]

Originally Posted by xloneshadowx*:

 

i have rebooted both servers procons still the same and this is happening on both servers. I do run the AdminCP as well

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

i have rebooted both servers procons still the same and this is happening on both servers. I do run the AdminCP as well

If you set "Use Challenge System" to false, wait a little bit, then change it back to true, do you see any different errors?

[ImportBot]

Originally Posted by xloneshadowx*:

 

These are errors I get when starting it back up.. and same errors come through

 

Screenshot (127).png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

These are errors I get when starting it back up.. and same errors come through

 

Screenshot (127).png

You're having global round ID trouble. Under section 1, server settings, what is the value of "Server Round (Display)"?

Also, how old is this server, did you just start it?

[ImportBot]

Originally Posted by xloneshadowx*:

 

Server ID is 1. I took ownership of these servers about two weeks ago they were the "Best In The West" Servers. Same error on both servers server ID is 1 on both. I have them on different data bases

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Server ID is 1. I took ownership of these servers about two weeks ago they were the "Best In The West" Servers. Same error on both servers server ID is 1 on both. I have them on different data bases

Okay, i assume you meant round ID not server ID when you said that. Have there been rounds played on the servers since you got them? If not, spawn into the server and walk around for a bit, then use the !endround 1 command. The round ID should advance at that point and your errors will as a consequence go away.

 

Why do you have them on separate databases? They don't need to be, in fact they shouldn't be as that wrecks some of the features in stat logger/AdKats.

[ImportBot]

Originally Posted by xloneshadowx*:

 

yeah, the servers have been full all day and night most of the time. Yes, I meant round ID... I just didn't get around to moving them to one database they were on seperate ones when i took over. and because im not sure how to do all of that. One is in L.A other is in N.Y. So i figured just keep them seperate for now. But this error only started happening in both of them