# [15-Aug-2024 06:44:10] /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
                `ListTitle` != '' AND
                `ParentID` = 0
         AND `Visible` = 1 ORDER BY `brands`.`Title` ASC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [15-Aug-2024 06:44:11] /maxxium/www/bg/ajax/cookies.html?_=1723693452074 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Aug-2024 06:44:11] /maxxium/www/bg/ajax/age.html?_=1723693452076 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LWelcome','LMinAge','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','ToOurSite') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Aug-2024 06:44:39] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1723693480000 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'eZpnB3tRL9gQl6guem3AeDEY0SBUEiQSUfbLNmrpGgImpz67KPGl9F6sw6LFq09a'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [15-Aug-2024 06:44:39] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1723693480789 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` = 'eZpnB3tRL9gQl6guem3AeDEY0SBUEiQSUfbLNmrpGgImpz67KPGl9F6sw6LFq09a'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Aug-2024 06:44:46] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1723693487008 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` = 'eZpnB3tRL9gQl6guem3AeDEY0SBUEiQSUfbLNmrpGgImpz67KPGl9F6sw6LFq09a'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Aug-2024 06:44:51] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1723693492530 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` = 'eZpnB3tRL9gQl6guem3AeDEY0SBUEiQSUfbLNmrpGgImpz67KPGl9F6sw6LFq09a'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [15-Aug-2024 06:44:51] /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
# [15-Aug-2024 06:44:56] /maxxium/www/mxD7ap2Va/bg/recipes/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
                `recipes`.`ID`,
                `recipes`.`Language`,
                `recipes`.`PostDate`,
                `recipes`.`LastUpdate`,
                `recipes`.`Title`,
                `recipes`.`Visible`,
                GROUP_CONCAT(`brands`.`Title` SEPARATOR ',') AS `Brands`
            FROM
                `recipes`
                LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
                LEFT JOIN `brands` ON `recipe_brands`.`BrandID` = `brands`.`ID`
            WHERE
                `recipes`.`Language` = 'bg'
                
            GROUP BY `recipes`.`ID`
            ORDER BY  `PostDate` ASC
# [15-Aug-2024 06:44:57] /maxxium/www/mxD7ap2Va/bg/ajax/recipes/form/23.html?_=1723693498641 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
                    *,
                    GROUP_CONCAT(`BrandID` SEPARATOR ',') AS `Brands`
                FROM
                    `recipes`
                    LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
                WHERE
                    `ID` = 23 AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `ID`,
                `ListTitle`
            FROM
                `brands`
            WHERE
                `ID` != 0 AND
                `ParentID` = 0
        
                ORDER BY
                    `ListTitle`
