# [06-Sep-2023 10:10:08] /eventssp8/root/sp8DrnsAWf/bg/ajax/users/login.html?_=1693984208939 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '5t6uyy6YslGzk3ssHkVQ878O54lvdczg2YA17A6jk2HcR1BxwjotrN7QOhF2Fpmk'
            WHERE
                `UserKey` LIKE 'w4vDkcOXw4bCpcODw43DrMK-w5_DmcOAwrrCsMOXwoXCtsKx%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [06-Sep-2023 10:10:10] /eventssp8/root/sp8DrnsAWf/bg/ajax/users/login.html?_=1693984210852 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5t6uyy6YslGzk3ssHkVQ878O54lvdczg2YA17A6jk2HcR1BxwjotrN7QOhF2Fpmk'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 3
            LIMIT 1
# [06-Sep-2023 10:10:10] /eventssp8/root/sp8DrnsAWfbg/orders/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3677036609 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT * FROM `orders` WHERE `Status` & 8 ORDER BY `ID` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM `orders` WHERE `Status` & 8 ORDER BY `ID` DESC) AS CountTable
