# [29-Jul-2024 07:56:20] /spisanie8/root/ajax/banners/sc_MSw5LDIsMw.html?_=1722228980416 108.61.209.243

set names utf8

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Section` = 9 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Section` = 2 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Section` = 3 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 566 LIMIT 1
# [29-Jul-2024 07:56:20] /spisanie8/root/ajax/banners/impress.html?_=1722228980594 108.61.209.243

set names utf8

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN (566) LIMIT 1

SELECT `Impressions` FROM `banner_stats` WHERE `BannerID` = 566 AND `PostDate` = CURDATE()

INSERT INTO `banner_stats` (`BannerID`, `PostDate`, `Impressions`) VALUES (566, CURDATE(), 1)
