Advanced In-Game Admin and Ban Enforcer - AdKats

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

when i create a new role i cant allow any commands

it jsut gives me this error

[04:30:04 37] [AdKats] EXCEPTION-6600-D-HandleException-DatabaseComm33: [Error while uploading role.][system.InvalidOperationException: Collection was modified; enumeration operation may not execute.

at System.ThrowHelper.ThrowInvalidOperationException( ExceptionResource resource)

at System.Collections.Generic.Dictionary`2.ValueColle ction.Enumerator.MoveNext()

at PRoConEvents.AdKats.UploadRole(AdKatsRole aRole)]

i havent touched anything from db

run /pupdate from procon chat while the plugin is running. After the update finishes, reboot your layer. Let me know if it continues.

[ImportBot]

Originally Posted by w262035635*:

 

auto nuke cant work

 

Test again today.. Still can't work normally

 

222.jpg

 

223.jpg

 

 

US lossing... no any flag

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

auto nuke cant work

 

Test again today.. Still can't work normally

 

222.jpg

 

223.jpg

 

 

US lossing... no any flag

Did you modify the ticket bleed rates of your server?

 

On lockers, CN team with all flags taken results in -50 adjusted tickets lost per minute for US.

 

You say all flags were taken, but according to the tickets (-38.7) in your screenshot it only thinks they have 4/5, so it won't fire.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Wait... Procon says US and RU. AdKats says US and CN. That's odd. Run /pupdate if you haven't already. If you have already and are running 6.6.9.0+ that's an issue i need to look at.

[ImportBot]

Originally Posted by w262035635*:

 

Wait... Procon says US and RU. AdKats says US and CN. That's odd. Run /pupdate if you haven't already. If you have already and are running 6.6.9.0+ that's an issue i need to look at.

yeah ...i set team 1 is US Team 2 is CN

but procon show team 2 is RU

 

and i set ticket bleed rates:75%

 

and adkats ver is 6.6.0.0

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

yeah ...i set team 1 is US Team 2 is CN

but procon show team 2 is RU

 

and i set ticket bleed rates:75%

 

and adkats ver is 6.6.0.0

Exactly, you modified the bleed rate, of course the default optimal settings aren't going to work...

 

If you want to keep your bleed rate lower you'll need to use the manual options. Why not just increase your ticket count instead of changing the bleed rate?

[ImportBot]

Originally Posted by Taman*:

 

hi

i want to see a list or something to check commands used by other admins

can you guide me how to do it please

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hi

i want to see a list or something to check commands used by other admins

can you guide me how to do it please

You can either run the BFAdminCP made by prophet, or look at the records in the adkats_records_main table.

 

I'll write a query for this tonight when I get home so you can use it.

[ImportBot]

Originally Posted by w262035635*:

 

Exactly, you modified the bleed rate, of course the default optimal settings aren't going to work...

 

If you want to keep your bleed rate lower you'll need to use the manual options. Why not just increase your ticket count instead of changing the bleed rate?

i set tickets is 1600Tickets...and set ticket bleed rates:75%

 

If I need to keep these parameters. How do I need to manually parameters for AutoNuke? Can you give me a reference?

[ImportBot]

Originally Posted by Taman*:

 

You can either run the BFAdminCP made by prophet, or look at the records in the adkats_records_main table.

 

I'll write a query for this tonight when I get home so you can use it.

thank you so much it would be really useful to see and check commands used by admins

i wait for the query

thank you

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

i set tickets is 1600Tickets...and set ticket bleed rates:75%

 

If I need to keep these parameters. How do I need to manually parameters for AutoNuke? Can you give me a reference?

The settings are here: https://github.com/AdKats/AdKats#b25...ender-settings

 

However, i would suggest setting your ticket count to 2100 with default 100% ticket bleed rate instead of modifying that. Those settings will make your rounds last the same amount of time as they do now.

 

Modifying your ticket bleed rate means your server goes custom instead of normal or hardcore, which means far fewer players will join your server.

[ImportBot]

Originally Posted by smogsy*:

 

Current Version 6.6.9.9

i told our admins to use !punish in future

however, even after 2 infractions in 10 minutes the players still stay on 0 points.

Do i need to set-up anything else other than the punishment tab?

 

in Command list Should their bea a:

logging line for CDE9 & CDEH10, we do not have one.

 

Settings:

Punishment: warn

kill

kick

tban60

tban120

tbanday

tban2days

tban3days

tbanweek

tban2weeks

tbanmonth

 

Combine Server = true

Forgives = False

Only Kill on low pop = False (now)

Use IRO Punishment = true

IRO Timeout Minutes = 2 (also tested 10)

Iro Punishment Overrides low pop = True

 

Log from BFAdminCP

May 15, 2015 8:30pm UTC ASBO28 Anarchy UK #1 Conquest All Maps Punish Player Warn Player language [0pts] No

May 15, 2015 8:16pm UTC ASBO28 Anarchy UK #1 Conquest All Maps Punish Player Warn Player language [0pts]

 

 

i think "only kick on low population" causing this, turned it off now. but need to test to see if its fixed it.

 

after editing Kill option

 

May 15, 2015 10:00pm UTC ASBO28 Punish Player Warn Player test 2 [iRO 0pts] No

May 15, 2015 10:00pm UTC ASBO28 Punish Player Punish Player test 2 [iRO] No

May 15, 2015 9:59pm UTC ASBO28 Punish Player Warn Player test [0pts]

[ImportBot]

Originally Posted by virusdead*:

 

hello this morning I have adkat error

 

[07:35:28 11] [AdKats] SUCCESS: Fetched special player group definitions.

[07:35:28 16] [AdKats] ERROR-6600: [unable to confirm global timing. Global UTC Timestamp could not be fetched.]

[07:35:28 16] [AdKats] SUCCESS: Server IP is 94.250.194.179:47200

[07:35:28 16] [AdKats] Starting Database Comm Thread

[07:35:28 16] [AdKats] ERROR-6600: [Database connection FAILED with EXCEPTION. Bad credentials, invalid hostname, or invalid port.]

[07:35:28 16] [AdKats] INFO: Shutting down AdKats.

[07:35:28 16] [AdKats] Starting Battlelog Comm Thread

[07:35:28 16] [AdKats] Starting IP API Comm Thread

[07:35:28 16] [AdKats] Ending Battlelog Comm Thread

[07:35:28 16] [AdKats] Ending IP API Comm Thread

[07:35:28 67] [AdKats] Threads still exiting: DatabaseComm[39]

[07:35:29 11] [AdKats] Ending Database Comm Thread

[07:35:29 89] [AdKats] AdKats 6.6.0.0 Disabled! =(

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Current Version 6.6.9.9

i told our admins to use !punish in future

however, even after 2 infractions in 10 minutes the players still stay on 0 points.

Do i need to set-up anything else other than the punishment tab?

 

in Command list Should their bea a:

logging line for CDE9 & CDEH10, we do not have one.

 

Settings:

Punishment: warn

kill

kick

tban60

tban120

tbanday

tban2days

tban3days

tbanweek

tban2weeks

tbanmonth

 

Combine Server = true

Forgives = False

Only Kill on low pop = False (now)

Use IRO Punishment = true

IRO Timeout Minutes = 2 (also tested 10)

Iro Punishment Overrides low pop = True

 

Log from BFAdminCP

May 15, 2015 8:30pm UTC ASBO28 Anarchy UK #1 Conquest All Maps Punish Player Warn Player language [0pts] No

May 15, 2015 8:16pm UTC ASBO28 Anarchy UK #1 Conquest All Maps Punish Player Warn Player language [0pts]

 

 

i think "only kick on low population" causing this, turned it off now. but need to test to see if its fixed it.

 

after editing Kill option

 

May 15, 2015 10:00pm UTC ASBO28 Punish Player Warn Player test 2 [iRO 0pts] No

May 15, 2015 10:00pm UTC ASBO28 Punish Player Punish Player test 2 [iRO] No

May 15, 2015 9:59pm UTC ASBO28 Punish Player Warn Player test [0pts]

How many entries are in your adkats_records_main, and adkats_infractions_global tables?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hello this morning I have adkat error

 

[07:35:28 11] [AdKats] SUCCESS: Fetched special player group definitions.

[07:35:28 16] [AdKats] ERROR-6600: [unable to confirm global timing. Global UTC Timestamp could not be fetched.]

[07:35:28 16] [AdKats] SUCCESS: Server IP is 94.250.194.179:47200

[07:35:28 16] [AdKats] Starting Database Comm Thread

[07:35:28 16] [AdKats] ERROR-6600: [Database connection FAILED with EXCEPTION. Bad credentials, invalid hostname, or invalid port.]

[07:35:28 16] [AdKats] INFO: Shutting down AdKats.

[07:35:28 16] [AdKats] Starting Battlelog Comm Thread

[07:35:28 16] [AdKats] Starting IP API Comm Thread

[07:35:28 16] [AdKats] Ending Battlelog Comm Thread

[07:35:28 16] [AdKats] Ending IP API Comm Thread

[07:35:28 67] [AdKats] Threads still exiting: DatabaseComm[39]

[07:35:29 11] [AdKats] Ending Database Comm Thread

[07:35:29 89] [AdKats] AdKats 6.6.0.0 Disabled! =(

So your database is offline?

[ImportBot]

Originally Posted by virusdead*:

 

So your database is offline?

ok server support me fix it:smile:

[ImportBot]

Originally Posted by smogsy*:

 

How many entries are in your adkats_records_main, and adkats_infractions_global tables?

Adkats Records_main

59,129

 

Global

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0008 sec )

 

also the table

Action Keyname Type Unique Packed Field Cardinality Collation Null Comment

Edit Drop PRIMARY BTREE Yes No player_id 0 A

 

does procon command list need logging for the punish?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Adkats Records_main

59,129

 

Global

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0008 sec )

 

also the table

Action Keyname Type Unique Packed Field Cardinality Collation Null Comment

Edit Drop PRIMARY BTREE Yes No player_id 0 A

 

does procon command list need logging for the punish?

So whoever set up your database for AdKats didn't run the script correctly. You are missing the triggers for punish/forgive points.

[ImportBot]

Originally Posted by smogsy*:

 

So whoever set up your database for AdKats didn't run the script correctly. You are missing the triggers for punish/forgive points.

ok, that makes sense. i have re-read the instructions. i guess theirs no way to do it now without losing data.

no problem cheers for the reply. we been running without it for 5 months, dont think we will miss this feature

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

ok, that makes sense. i have re-read the instructions. i guess theirs no way to do it now without losing data.

no problem cheers for the reply. we been running without it for 5 months, dont think we will miss this feature

That system was one of the starting reasons this plugin was built lol, you can still set it up.

 

It's simple, just add the triggers and drop your already existing punishment records.

 

Code:

DELETE FROM `adkats_records_main` WHERE `command_type` = 9;

Then

 

Code:

DELIMITER ;
DROP TRIGGER IF EXISTS `adkats_infraction_point_delete`;
DELIMITER $$
CREATE TRIGGER `adkats_infraction_point_delete` AFTER DELETE ON `adkats_records_main`
 FOR EACH ROW BEGIN 
        DECLARE command_type VARCHAR(45);
        DECLARE server_id INT(11);
        DECLARE player_id INT(11);
        SET command_type = OLD.command_type;
        SET server_id = OLD.server_id;
        SET player_id = OLD.target_id;


        IF(command_type = 9) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` - 1, 
                `total_points` = `total_points` - 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` - 1, 
                `total_points` = `total_points` - 1;
        ELSEIF (command_type = 10) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` - 1, 
                `total_points` = `total_points` + 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` - 1, 
                `total_points` = `total_points` + 1;
        END IF;
    END
$$
DELIMITER ;
DROP TRIGGER IF EXISTS `adkats_infraction_point_insert`;
DELIMITER $$
CREATE TRIGGER `adkats_infraction_point_insert` BEFORE INSERT ON `adkats_records_main`
 FOR EACH ROW BEGIN 
        DECLARE command_type VARCHAR(45);
        DECLARE server_id INT(11);
        DECLARE player_id INT(11);
        SET command_type = NEW.command_type;
        SET server_id = NEW.server_id;
        SET player_id = NEW.target_id;


        IF(command_type = 9) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 1, 0, 1) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` + 1, 
                `total_points` = `total_points` + 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 1, 0, 1) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` + 1, 
                `total_points` = `total_points` + 1;
        ELSEIF (command_type = 10) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 0, 1, -1) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` + 1, 
                `total_points` = `total_points` - 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 0, 1, -1) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` + 1, 
                `total_points` = `total_points` - 1;
        END IF;
    END
$$
DELIMITER ;

[ImportBot]

Originally Posted by MRniceGuy*:

 

Hello

did you write me a query to check commands used by admins?

i got a lot of issues right now that some of my admins are abusing players

i really really need to check the latest commands used by admins

[ImportBot]

Originally Posted by smogsy*:

 

That system was one of the starting reasons this plugin was built lol, you can still set it up.

 

It's simple, just add the triggers and drop your already existing punishment records.

 

Code:

DELETE FROM `adkats_records_main` WHERE `command_type` = 9;

Then

 

Code:

DELIMITER ;
DROP TRIGGER IF EXISTS `adkats_infraction_point_delete`;
DELIMITER $$
CREATE TRIGGER `adkats_infraction_point_delete` AFTER DELETE ON `adkats_records_main`
 FOR EACH ROW BEGIN 
        DECLARE command_type VARCHAR(45);
        DECLARE server_id INT(11);
        DECLARE player_id INT(11);
        SET command_type = OLD.command_type;
        SET server_id = OLD.server_id;
        SET player_id = OLD.target_id;


        IF(command_type = 9) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` - 1, 
                `total_points` = `total_points` - 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` - 1, 
                `total_points` = `total_points` - 1;
        ELSEIF (command_type = 10) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` - 1, 
                `total_points` = `total_points` + 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 0, 0, 0) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` - 1, 
                `total_points` = `total_points` + 1;
        END IF;
    END
$$
DELIMITER ;
DROP TRIGGER IF EXISTS `adkats_infraction_point_insert`;
DELIMITER $$
CREATE TRIGGER `adkats_infraction_point_insert` BEFORE INSERT ON `adkats_records_main`
 FOR EACH ROW BEGIN 
        DECLARE command_type VARCHAR(45);
        DECLARE server_id INT(11);
        DECLARE player_id INT(11);
        SET command_type = NEW.command_type;
        SET server_id = NEW.server_id;
        SET player_id = NEW.target_id;


        IF(command_type = 9) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 1, 0, 1) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` + 1, 
                `total_points` = `total_points` + 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 1, 0, 1) 
            ON DUPLICATE KEY UPDATE 
                `punish_points` = `punish_points` + 1, 
                `total_points` = `total_points` + 1;
        ELSEIF (command_type = 10) THEN
            INSERT INTO `adkats_infractions_server` 
                (`player_id`, `server_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, server_id, 0, 1, -1) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` + 1, 
                `total_points` = `total_points` - 1;
            INSERT INTO `adkats_infractions_global` 
                (`player_id`, `punish_points`, `forgive_points`, `total_points`) 
            VALUES 
                (player_id, 0, 1, -1) 
            ON DUPLICATE KEY UPDATE 
                `forgive_points` = `forgive_points` + 1, 
                `total_points` = `total_points` - 1;
        END IF;
    END
$$
DELIMITER ;

thank you,

 

even though we done it wrong you still helped us!,

 

thank you where can i donate to the progression of this & future projects?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

thank you,

 

even though we done it wrong you still helped us!,

 

thank you where can i donate to the progression of this & future projects?

Well lets make sure it's working for you again first lol. Glad to help.

 

There is a donation link in the first post of this thread. Thank you.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello

did you write me a query to check commands used by admins?

i got a lot of issues right now that some of my admins are abusing players

i really really need to check the latest commands used by admins

Sorry, had a lot going on last night.

 

This will fetch the last 1000 admin actions, ordered from latest to earliest.

 

Code:

select   `tbl_games`.`Name` AS `Game`, 
  left(`tbl_server`.`ServerName`, 25) AS `Server`, 
  (`adkats_records_main`.`source_name`) AS `Source`, 
  (`adkats_records_main`.`target_name`) AS `Target`, 
  `adkats_records_main`.`record_message` AS `Reason`, 
  concat(
    timestampdiff(
      HOUR, 
      `adkats_records_main`.`record_time`, 
      utc_timestamp()
    ), 
    'h ', 
    (
      timestampdiff(
        MINUTE, 
        `adkats_records_main`.`record_time`, 
        utc_timestamp()
      ) - (
        timestampdiff(
          HOUR, 
          `adkats_records_main`.`record_time`, 
          utc_timestamp()
        ) * 60
      )
    ), 
    'm'
  ) AS `Age` 
from 
  (
    (
      (
        (
          `adkats_records_main` 
          left join `tbl_server` on(
            (
              `adkats_records_main`.`server_id` = `tbl_server`.`ServerID`
            )
          )
        ) 
        left join `tbl_games` on(
          (
            `tbl_server`.`GameID` = `tbl_games`.`GameID`
          )
        )
      ) 
      left join `adkats_commands` `type_command` on(
        (
          `type_command`.`command_id` = `adkats_records_main`.`command_type`
        )
      )
    ) 
    left join `adkats_commands` `action_command` on(
      (
        `action_command`.`command_id` = `adkats_records_main`.`command_action`
      )
    )
  ) 
where 
  (
    `adkats_records_main`.`source_id` in (select player_id from adkats_usersoldiers)
  ) 
order by 
  `adkats_records_main`.`record_time` desc 
limit 
  1000

[ImportBot]

Originally Posted by smogsy*:

 

Well lets make sure it's working for you again first lol. Glad to help.

 

There is a donation link in the first post of this thread. Thank you.

i checked before posting

 

Cool i will sort you out in a bit.

 

PS. in the future updates of adkats or future Tools

 

do you think You could ever add the following:

 

If New player to server group

options:

Say

Yell

 

i know the procon logger does new players but not new server group players.

 

just a thought

cheers!

smogsy

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

i checked before posting

 

Cool i will sort you out in a bit.

 

PS. in the future updates of adkats or future Tools

 

do you think You could ever add the following:

 

If New player to server group

options:

Say

Yell

 

i know the procon logger does new players but not new server group players.

 

just a thought

cheers!

smogsy

All new features for AdKats 6.X are on hold at the moment except for funded features, i'm working on version 7 of AdKats which is a complete rewrite from he ground up. So if you are looking to donate, i would suggest opening a ticket for your feature and using the donation there.

 

You can open a new issue here: https://github.com/AdKats/AdKats/iss...pen+is%3Aissue

 

Here are the current unassigned feature requests: https://github.com/AdKats/AdKats/mil...ure%20Requests

 

Completed funded features: https://github.com/AdKats/AdKats/iss...ed+is%3Aclosed

[ImportBot]

Originally Posted by smogsy*:

 

cool i just donated but ill look through the list & possibly donate again in the future!

 

i personally looked at the "kill players till read rules thing" thats the outcome i wanted to read the rules but, i think just saying/yelling rules to to new players to server group this much better solution for the player.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

cool i just donated but ill look through the list & possibly donate again in the future!

Thank you for the contribution. Cheers.

[ImportBot]

Originally Posted by MRniceGuy*:

 

Sorry, had a lot going on last night.

 

This will fetch the last 1000 admin actions, ordered from latest to earliest.

 

Code:

select   `tbl_games`.`Name` AS `Game`, 
  left(`tbl_server`.`ServerName`, 25) AS `Server`, 
  (`adkats_records_main`.`source_name`) AS `Source`, 
  (`adkats_records_main`.`target_name`) AS `Target`, 
  `adkats_records_main`.`record_message` AS `Reason`, 
  concat(
    timestampdiff(
      HOUR, 
      `adkats_records_main`.`record_time`, 
      utc_timestamp()
    ), 
    'h ', 
    (
      timestampdiff(
        MINUTE, 
        `adkats_records_main`.`record_time`, 
        utc_timestamp()
      ) - (
        timestampdiff(
          HOUR, 
          `adkats_records_main`.`record_time`, 
          utc_timestamp()
        ) * 60
      )
    ), 
    'm'
  ) AS `Age` 
from 
  (
    (
      (
        (
          `adkats_records_main` 
          left join `tbl_server` on(
            (
              `adkats_records_main`.`server_id` = `tbl_server`.`ServerID`
            )
          )
        ) 
        left join `tbl_games` on(
          (
            `tbl_server`.`GameID` = `tbl_games`.`GameID`
          )
        )
      ) 
      left join `adkats_commands` `type_command` on(
        (
          `type_command`.`command_id` = `adkats_records_main`.`command_type`
        )
      )
    ) 
    left join `adkats_commands` `action_command` on(
      (
        `action_command`.`command_id` = `adkats_records_main`.`command_action`
      )
    )
  ) 
where 
  (
    `adkats_records_main`.`source_id` in (select player_id from adkats_usersoldiers)
  ) 
order by 
  `adkats_records_main`.`record_time` desc 
limit 
  1000

Thank you so much its really useful and helped me a lot :*

and sorry i always get confused with another account i have here.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thank you so much its really useful and helped me a lot :*

and sorry i always get confused with another account i have here.

Wait, crap, that doesn't include the command type/action, also the formatting on that SQL is terrible.

 

Here is an updated one.

 

Code:

SELECT 
  `tbl_games`.`Name` AS `Game`, 
  left(`tbl_server`.`ServerName`, 25) AS `Server`, 
  `adkats_records_main`.`source_name` AS `Source`, 
  `adkats_records_main`.`target_name` AS `Target`, 
  `type_command`.`command_name` AS `Command`,
  `action_command`.`command_name` AS `Action`,
  `adkats_records_main`.`record_message` AS `Reason`, 
  CONCAT(
    TIMESTAMPDIFF(HOUR, `adkats_records_main`.`record_time`, UTC_TIMESTAMP()), 
    'h ', 
    (TIMESTAMPDIFF(MINUTE, `adkats_records_main`.`record_time`, UTC_TIMESTAMP()) - 
		(TIMESTAMPDIFF(HOUR, `adkats_records_main`.`record_time`, UTC_TIMESTAMP()) * 60)), 
    'm') AS `Age` 
FROM 
	`adkats_records_main` 
	LEFT JOIN 
		`tbl_server` ON
		`adkats_records_main`.`server_id` = `tbl_server`.`ServerID`
	LEFT JOIN 
		`tbl_games` ON
		`tbl_server`.`GameID` = `tbl_games`.`GameID`
	LEFT JOIN 
		`adkats_commands` `type_command` ON
		`type_command`.`command_id` = `adkats_records_main`.`command_type`
	LEFT JOIN 
		`adkats_commands` `action_command` ON
		`action_command`.`command_id` = `adkats_records_main`.`command_action`
WHERE 
(
	(`adkats_records_main`.`source_id` IS NULL AND `adkats_records_main`.`source_name` = 'ProconAdmin')
	OR
	`adkats_records_main`.`source_id` IN (SELECT `player_id` FROM `adkats_usersoldiers`)
) 
ORDER BY 
  `adkats_records_main`.`record_time` DESC 
LIMIT 1000;