# [24-Jul-2023 07:40:27] /maxxium/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0
         AND `Visible` = 1 ORDER BY `brands`.`Title` ASC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [24-Jul-2023 07:40:37] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1690173637798 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'A77tVmLMbb5L898PENA78M0HX98v05c1dx2S9aXAO0EFZAVs2u9ZkHmf813o3vO3'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [24-Jul-2023 07:40:38] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1690173638724 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` = 'A77tVmLMbb5L898PENA78M0HX98v05c1dx2S9aXAO0EFZAVs2u9ZkHmf813o3vO3'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [24-Jul-2023 07:40:38] /maxxium/www/mxD7ap2Va/bg/pages/list.html 167.99.142.201

set names utf8

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

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