# [14-Aug-2024 15:12:41] /constantinoff/root/ 167.99.142.201

set names utf8

SELECT
                    *
    	        FROM
    	        	`pages`
    	    	WHERE
                    (`ExternalURL` IS NULL OR `ExternalURL` = '') AND
                    `Language` = 'bg'
             AND `Visible` = 1 AND `URLLabel` = 'index' LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

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

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

SELECT
                COUNT(`ID`)
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != ''
         AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Gold`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`Module` = 'events'
         AND `Visible` = 1 LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'bg'
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 2

SELECT
                `ID`,
                `Language`,
                `Gold`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`Module` = 'reviews'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'bg' AND `Visible` = 1

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1
# [14-Aug-2024 15:12:41] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1723637561416 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [14-Aug-2024 15:12:41] /constantinoff/root/bg/ajax/reservations/form.html?_=1723637561418 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMakeReservation','LName','LPhone','LEMail','LPeopleNum','LSpecifyDate','LSpecifyHour','LComment','LBookTable') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorGuests','ErrorDate','ErrorHour','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND (`Action` = '' OR `Action` IS NULL) AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('IAgreeGeneral') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Aug-2024 15:12:41] /constantinoff/root/bg/ajax/cookies.html?_=1723637561419 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'cookies' 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
# [14-Aug-2024 15:12:43] /constantinoff/root/cSN3dAd9/bg/ajax/users/form/login.html?_=1723637563102 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
# [14-Aug-2024 15:12:48] /constantinoff/root/cSN3dAd9/bg/ajax/users/login.html?_=1723637567706 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Aug-2024 15:12:48] /constantinoff/root/cSN3dAd9/bg/ajax/users/login.html?_=1723637568406 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` = 'QmH8lmXfDqhBDDRHhz33gTbGWnURxPI9R6pz7v314H5DkM3qGI4f9yQ0hpeu3H3f'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1462881452
            LIMIT 1
# [14-Aug-2024 15:12:48] /constantinoff/root/cSN3dAd9/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [14-Aug-2024 15:12:49] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1723637568760 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [14-Aug-2024 15:13:01] /constantinoff/root/cSN3dAd9/bg/staff/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Visible`
            FROM
                `staff`
         ORDER BY `staff`.`LastUpdate` DESC
# [14-Aug-2024 15:13:01] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1723637581191 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [14-Aug-2024 15:13:09] /constantinoff/root/cSN3dAd9/bg/ajax/staff/form/5.html?_=1723637589320 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `PassCode`,
                `Data`,
                `Visible`
            FROM
                `staff`
            WHERE
                `ID` = 5
            LIMIT 1
