# [03-Nov-2022 13:08:27] /goodgo/www/gJ3dnAld/bg/ajax/users/form/login.html?_=1667473710827 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLoginEMail','EMailError','LSubmit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Nov-2022 13:08:30] /goodgo/www/gJ3dnAld/bg/ajax/users/login.html?_=1667473713768 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'tD7DR4iCj2Ou1mE7uzUXPz61q0b1ugqfar0xEkl7eBVjDjkpkb1Uyx7TdKR0ikXu'
            WHERE
                `UserKey` LIKE 'w4XCucOjw5nCvMKsw5nDlcOLwr_DnsK7w5XDk8ODw5LCgsK3wrk%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Nov-2022 13:08:31] /goodgo/www/gJ3dnAld/bg/ajax/users/login.html?_=1667473714570 167.99.142.201

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` = 'tD7DR4iCj2Ou1mE7uzUXPz61q0b1ugqfar0xEkl7eBVjDjkpkb1Uyx7TdKR0ikXu'
            LIMIT 1
# [03-Nov-2022 13:08:31] /goodgo/www/gJ3dnAldbg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1
