# [05-Jan-2024 05:29:15] /eventssp8/root/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT * FROM `lecturers` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Videos`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [05-Jan-2024 05:29:15] /eventssp8/root/bg/ajax/cookies.html?_=1704425358525 108.61.209.243

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
# [05-Jan-2024 05:29:23] /eventssp8/root/sp8DrnsAWf/bg/ajax/users/login.html?_=1704425365706 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '1oqbt9T898f1YM5SeMOp05wfCLmOEZ0zh2Tp9193gM9GwRwZTez55HZ1t1uuR4Ux'
            WHERE
                `UserKey` LIKE 'w4vDkcOXw4bCpcODw43DrMK-w5_DmcOAwrrCsMOXwoXCtsKx%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [05-Jan-2024 05:29:24] /eventssp8/root/sp8DrnsAWf/bg/ajax/users/login.html?_=1704425366786 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` = '1oqbt9T898f1YM5SeMOp05wfCLmOEZ0zh2Tp9193gM9GwRwZTez55HZ1t1uuR4Ux'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 3
            LIMIT 1
# [05-Jan-2024 05:29:24] /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
# [05-Jan-2024 05:29:32] /eventssp8/root/sp8DrnsAWf/bg/gallery/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 `gallery`
# [05-Jan-2024 05:29:35] /eventssp8/root/sp8DrnsAWf/bg/ajax/gallery/form/6.html?_=1704425378512 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
                `gallery`
            WHERE
                `ID` = 6 AND
                `Language` = 'bg'
            LIMIT 1
# [05-Jan-2024 05:29:46] /eventssp8/root/sp8DrnsAWf/bg/exhibitors/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
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `Visible`
            FROM
                `exhibitors`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC
# [05-Jan-2024 05:29:49] /eventssp8/root/sp8DrnsAWf/bg/program/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
                `program`.`ID`,
                `program`.`Language`,
                `program`.`PanelDate`,
                `program`.`LastUpdate`,
                `program`.`PanelStart`,
                `program`.`PanelEnd`,
                `program`.`Title`,
                `program`.`Visible`,
                `lecturers`.`FullName` AS `Lecturer`
            FROM
                `program`
                LEFT JOIN `lecturers` ON
                    `program`.`LecturerID` = `lecturers`.`ID` AND
                    `program`.`Language` = `lecturers`.`Language`
            WHERE
                `program`.`Language` = 'bg'
                
            ORDER BY  `program`.`ID` ASC
# [05-Jan-2024 05:29:52] /eventssp8/root/sp8DrnsAWf/bg/lecturers/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
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `FullName`,
                `Visible`
            FROM
                `lecturers`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC
# [05-Jan-2024 05:29:54] /eventssp8/root/sp8DrnsAWf/bg/pages/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
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC
# [05-Jan-2024 05:29:57] /eventssp8/root/sp8DrnsAWf/bg/tickets/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
                `tickets`.`ID`,
                `tickets`.`OrderID`,
                `tickets`.`PostDate`,
                `tickets`.`SeatID`,
                `tickets`.`Price`,
                `tickets`.`Status`,
                `orders`.`Data`
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
            WHERE
                `orders`.`Status` & 4
         ORDER BY `tickets`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `tickets`.`ID`,
                `tickets`.`OrderID`,
                `tickets`.`PostDate`,
                `tickets`.`SeatID`,
                `tickets`.`Price`,
                `tickets`.`Status`,
                `orders`.`Data`
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
            WHERE
                `orders`.`Status` & 4
         ORDER BY `tickets`.`PostDate` DESC) AS CountTable
# [05-Jan-2024 05:30:00] /eventssp8/root/sp8DrnsAWf/bg/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
# [05-Jan-2024 05:30:02] /eventssp8/root/sp8DrnsAWf/bg/qrscan.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
