[Plugin Core] Admin System 1.0.3.1

Перенос групп

INSERT INTO as_groups (id, flags, name, immunity)
SELECT id, flags, name, immunity
FROM iks_groups;

Перенос админов

INSERT INTO as_admins (steamid, name)
SELECT sid, name
FROM iks_admins
WHERE sid NOT IN (SELECT steamid FROM as_admins);

Перенос прав

INSERT INTO as_admins_servers (admin_id, flags, immunity, expires, group_id, server_id)
SELECT
    (SELECT id FROM as_admins WHERE steamid = iks_admins.sid) AS admin_id,
    flags,
    immunity,
    `end` AS expires,
    CASE WHEN group_id = -1 THEN NULL ELSE group_id END AS group_id,
    TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(server_id, ';', numbers.n), ';', -1)) AS server_id
FROM
    iks_admins
JOIN (
    SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5
) numbers
ON CHAR_LENGTH(server_id) - CHAR_LENGTH(REPLACE(server_id, ';', '')) + 1 >= numbers.n
WHERE EXISTS (
    SELECT 1 FROM as_admins WHERE steamid = iks_admins.sid
);

Перенос банов

INSERT INTO as_punishments (name, steamid, ip, admin_id, created, expires, reason, unpunish_admin_id, server_id, punish_type)
SELECT
    name,
    `sid` AS steamid,
    CASE WHEN ip = 'Undefined' OR ip = NULL THEN '' ELSE ip END AS ip,
    (SELECT id FROM as_admins WHERE steamid = iks_bans.adminsid) AS admin_id,
    created,
    `end` AS expires,
    reason,
    CASE WHEN Unbanned = 1 THEN (SELECT id FROM as_admins WHERE steamid = iks_bans.UnbannedBy) ELSE NULL END AS unpunish_admin_id,
    CASE WHEN server_id = '' THEN -1 ELSE server_id END AS server_id,
    0
FROM iks_bans

Перенос гагов

INSERT INTO as_punishments (name, steamid, ip, admin_id, created, expires, reason, unpunish_admin_id, server_id, punish_type)
SELECT
    name,
    `sid` AS steamid,
    NULL,
    (SELECT id FROM as_admins WHERE steamid = iks_gags.adminsid) AS admin_id,
    created,
    `end` AS expires,
    reason,
    CASE WHEN Unbanned = 1 THEN (SELECT id FROM as_admins WHERE steamid = iks_gags.UnbannedBy) ELSE NULL END AS unpunish_admin_id,
    CASE WHEN server_id = '' THEN -1 ELSE server_id END AS server_id,
    2
FROM iks_gags

Перенос мутов

INSERT INTO as_punishments (name, steamid, ip, admin_id, created, expires, reason, unpunish_admin_id, server_id, punish_type)
SELECT
    name,
    `sid` AS steamid,
    NULL,
    (SELECT id FROM as_admins WHERE steamid = iks_mutes.adminsid) AS admin_id,
    created,
    `end` AS expires,
    reason,
    CASE WHEN Unbanned = 1 THEN (SELECT id FROM as_admins WHERE steamid = iks_mutes.UnbannedBy) ELSE NULL END AS unpunish_admin_id,
    CASE WHEN server_id = '' THEN -1 ELSE server_id END AS server_id,
    1
FROM iks_mutes