# [14-Mar-2025 13:36:43] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1741952203294 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'l2F6wt0Xb0h1JNqo2SWKGW5Vj41GKdUsxmjltP0Yrgei6jNglAIjU4LG9FzBJ7uq'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [14-Mar-2025 13:36:49] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1741952208885 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` = 'l2F6wt0Xb0h1JNqo2SWKGW5Vj41GKdUsxmjltP0Yrgei6jNglAIjU4LG9FzBJ7uq'
            LIMIT 1
# [14-Mar-2025 13:36:49] /processspace/www/psNr2S0b/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF((`MenuLabel` = '' OR `MenuLabel` IS NULL), IF((`SubMenuLabel` = '' OR `SubMenuLabel` IS NULL), `FooterLabel`, `SubMenuLabel`), `MenuLabel`) AS `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1
# [14-Mar-2025 13:36:52] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `TransactionID`,
                `PostDate`,
                `LastUpdate`,
                `Amount`,
                `Status`
            FROM
                `payments`
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:36:56] /processspace/www/psNr2S0b/bg/ajax/payments/27.html?_=1741952216351 167.99.142.201

set names utf8

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

SELECT
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 27
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 13:37:01] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741952221205 167.99.142.201

set names utf8

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

SELECT
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 13:42:09] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `TransactionID`,
                `PostDate`,
                `LastUpdate`,
                `Amount`,
                `Status`
            FROM
                `payments`
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:42:10] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `TransactionID`,
                `PostDate`,
                `LastUpdate`,
                `Amount`,
                `Status`
            FROM
                `payments`
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:43:45] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741952625281 167.99.142.201

set names utf8

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

SELECT
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 13:46:01] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ModuleID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:46:18] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:46:44] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:50:19] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:50:32] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:54:36] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [14-Mar-2025 13:54:51] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:55:32] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:55:58] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:57:07] /processspace/www/psNr2S0b/bg/payments/list.html?sort=31 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:57:13] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:57:37] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 13:59:52] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:00:06] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:00:47] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:10:40] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:10:41] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741954240734 167.99.142.201

set names utf8

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

SELECT
                `payment_info`.`PostDate`,
                `payments`.`Amount`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:11:22] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:11:24] /processspace/www/psNr2S0b/bg/ajax/payments/29.html?_=1741954284070 167.99.142.201

set names utf8

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

SELECT
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 29
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:12:00] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:12:02] /processspace/www/psNr2S0b/bg/ajax/payments/29.html?_=1741954322054 167.99.142.201

set names utf8

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

SELECT
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 29
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:12:28] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:12:30] /processspace/www/psNr2S0b/bg/ajax/payments/29.html?_=1741954349879 167.99.142.201

set names utf8

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

SELECT
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 29
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:17:06] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:17:08] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741954628325 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:26:10] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:26:12] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955172506 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:26:18] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:26:26] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:26:28] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:26:29] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955189339 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:28:39] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:28:41] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955321371 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:29:09] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:29:10] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955350633 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:29:13] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:29:15] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955355595 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:29:28] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:29:30] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955369690 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:30:52] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:30:55] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955454987 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:34:25] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:34:26] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955666353 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:35:44] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955744183 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:35:57] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:35:58] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955758057 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:37:27] /processspace/www/psNr2S0b/bg/payments/list.html?sort=30 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:37:29] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741955849209 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:38:11] /processspace/www/psNr2S0b/bg/ajax/users/logout.html?_=1741955891191 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [14-Mar-2025 14:38:11] /processspace/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 ('LReadMore','LPlayVideo','LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `HeaderFirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ImageHome` > '' AND
                `FirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URLLabel`,
                `Color`
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `NoIndex` = 0 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 67
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 68
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 14:38:14] /processspace/www/bg/приятелски-клуб.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'приятелски-клуб' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'приятелски-клуб'
         AND `Visible` = 1 LIMIT 1

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 14:38:15] /processspace/www/bg/club/corporate.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 14:38:16] /processspace/www/bg/ajax/club/form/corporate.html?_=1741955895923 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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 ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 14:38:21] /processspace/www/bg/ajax/club/submit/corporate.html?_=1741955901472 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 14:38:21', `Membership` = 'corporate', `Data` = 'PqZ-UXL9CxelpXjQFXRvRuCgqPsRFWjlAxRpzOMOFsTx-_Zi1pg8ZpaGoqqThOACj_37Uvy4cVvY7cW3ASgQt0H99OKSg0djG9e3SepCMcCuYCRL3xayyM6zEJbNtnzeGYGIMTSZ7dwSUrmJuRGxtppgHcH4sDVBxPaFj8Mg_wlnxPwRvCp4bLNu4t3ES8yu'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'KPgmgW0g5mQDq2G7dCgobMzRw3k=', `Description` = 'test transaction', `PostDate` = '2025-03-14 14:38:22', `LastUpdate` = '2025-03-14 14:38:22', `Module` = 'club', `ModuleID` = 36, `Amount` = 2, `Currency` = 'BGN', `Provider` = 'fibank'
# [14-Mar-2025 14:38:47] /processspace/www/bg/payments/fibank/response.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Module`,
                `ModuleID`
	        FROM
	        	`payments`
	    	WHERE
                `TransactionID` = 'KPgmgW0g5mQDq2G7dCgobMzRw3k=' AND
	    		`Provider` = 'fibank' AND
                `Status` = 0
            LIMIT 1

SELECT * FROM `payment_info` LIMIT 1

SHOW COLUMNS FROM `payment_info`

INSERT INTO `payment_info` SET `PaymentID` = '30', `PostDate` = NOW(), `Result` = '{"RESULT":"OK","RESULT_CODE":"000","3DSECURE":"AUTHENTICATED","RRN":"507312450240","APPROVAL_CODE":"597255","CARD_NUMBER":"437851******2074"}'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

UPDATE `payments` SET `Status` = 1 WHERE `ID` = '30' AND `Provider` = 'fibank'
# [14-Mar-2025 14:38:47] /processspace/www/bg/club/success/36.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 14:38:47] /processspace/www/bg/ajax/club/send/36.html?_=1741955927487 167.99.142.201

set names utf8

SELECT
                `Membership`,
                `Data`
	        FROM
	        	`club`
	    	WHERE
	    		`ID` = 36 AND
                `Status` = 0
            LIMIT 1

SELECT
                `ID`
	        FROM
	        	`payments`
	    	WHERE
                `Module` = 'club' AND
	    		`ModuleID` = 36 AND
                `Status` = 1
            LIMIT 1

UPDATE
                `club`
            SET
                `LastUpdate` = NOW(),
                `Status` = `Status` | 1
            WHERE
                `ID` = 36
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubFriends','LName','LPhone','LEMail','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                `club`
            SET
                `LastUpdate` = NOW(),
                `Status` = `Status` | 2
            WHERE
                `ID` = 36
            LIMIT 1

UPDATE
                `club`
            SET
                `LastUpdate` = NOW(),
                `Status` = `Status` | 4
            WHERE
                `ID` = 36
            LIMIT 1
# [14-Mar-2025 14:38:58] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1741955938049 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'pAsWotbpK4fx0gf5J4JM8MUJ79Fd9IOI91nLuGX2BMh1AN4wuhzja729T82oP5eV'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [14-Mar-2025 14:39:01] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1741955940741 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` = 'pAsWotbpK4fx0gf5J4JM8MUJ79Fd9IOI91nLuGX2BMh1AN4wuhzja729T82oP5eV'
            LIMIT 1
# [14-Mar-2025 14:39:01] /processspace/www/psNr2S0b/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF((`MenuLabel` = '' OR `MenuLabel` IS NULL), IF((`SubMenuLabel` = '' OR `SubMenuLabel` IS NULL), `FooterLabel`, `SubMenuLabel`), `MenuLabel`) AS `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1
# [14-Mar-2025 14:39:03] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:39:08] /processspace/www/psNr2S0b/bg/ajax/payments/30.html?_=1741955947936 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 30
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:40:40] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:42:36] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:42:42] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:43:07] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:43:09] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:44:12] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:47:20] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 14:47:28] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741956448374 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:47:52] /processspace/www/psNr2S0b/bg/ajax/payments/26.html?_=1741956472534 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 26
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 14:51:03] /processspace/www/bg 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 ('LReadMore','LPlayVideo','LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `HeaderFirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ImageHome` > '' AND
                `FirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URLLabel`,
                `Color`
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `NoIndex` = 0 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 67
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 68
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 16:43:06] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1741963497583 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'Aeacx2ft6kgMBvcQE8VID56jC1IjhR7hG159MWg738gQexN3QUXD5BEuTotJbVQn'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOSw5XDlsK0w4bDl8KIw4fDkg%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [14-Mar-2025 16:43:18] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1741963509289 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` = 'Aeacx2ft6kgMBvcQE8VID56jC1IjhR7hG159MWg738gQexN3QUXD5BEuTotJbVQn'
            LIMIT 1
# [14-Mar-2025 16:43:18] /processspace/www/psNr2S0b/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF((`MenuLabel` = '' OR `MenuLabel` IS NULL), IF((`SubMenuLabel` = '' OR `SubMenuLabel` IS NULL), `FooterLabel`, `SubMenuLabel`), `MenuLabel`) AS `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1
# [14-Mar-2025 16:43:23] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 16:43:36] /processspace/www/psNr2S0b/bg/ajax/payments/30.html?_=1741963527759 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 30
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:43:59] /processspace/www/psNr2S0b/bg/ajax/payments/29.html?_=1741963550319 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 29
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:44:29] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 16:44:29] /processspace/www/bg/ajax/club/form/individual.html?_=1741963580808 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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 ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 16:44:59] /processspace/www/bg/ajax/club/submit/individual.html?_=1741963610366 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 16:44:59', `Membership` = 'individual', `Data` = 'q7E6eYLvf9mALc64K2rIx9nQ5iWKQVJkQXvMrkGERij5OxZcs5Tcmwstg4bZVjFeA7V-aF9DggUPRmKKxvrEngE_6vZHcGu1gfMSO_kgW-oNTMTd6AOUlUR0vAs3gx51AnMwJO2sgrgLKwxuUHcJLKTsoOaatfJBygocfh1Qko2kRycrKB4Dx-Iyc6mFUqYO'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'aS6ZUGsazjWt37ndfGexKNlfBi0=', `Description` = 'test transaction', `PostDate` = '2025-03-14 16:44:59', `LastUpdate` = '2025-03-14 16:44:59', `Module` = 'club', `ModuleID` = 37, `Amount` = 1, `Currency` = 'BGN', `Provider` = 'fibank'
# [14-Mar-2025 16:46:11] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 16:46:17] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741963688838 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:46:20] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741963690942 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:46:20] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741963691866 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:46:22] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741963693368 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:46:23] /processspace/www/psNr2S0b/bg/ajax/payments/30.html?_=1741963694462 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 30
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:47:20] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741963751489 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:47:21] /processspace/www/psNr2S0b/bg/ajax/payments/30.html?_=1741963752644 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 30
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:50:29] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 16:50:30] /processspace/www/bg/ajax/club/form/individual.html?_=1741963941188 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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 ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 16:51:02] /processspace/www/bg/ajax/club/submit/individual.html?_=1741963973729 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 16:51:02', `Membership` = 'individual', `Data` = 'klrwHKaqAH4qnxZOzz1S3O9AG0nfuE0ox8Q9rSKYrgXmS2wiLpoTa8jXZPjhPcVrs2ynCFBD9yX00Hp1CY2Cqrm_3Kk--kv1W-KQ7vwAqsOAM_r_a6J9WUBEjGWSxXj6swIwCpeTgqVJmSLYX4MW50hQhjwgDFoMKrkjMomZftZhnGXsBqD7Qj9vxdfyn7-1'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'RfSMCaTYva4iqhcFZK4WULbzu0M=', `Description` = 'test transaction', `PostDate` = '2025-03-14 16:51:03', `LastUpdate` = '2025-03-14 16:51:03', `Module` = 'club', `ModuleID` = 38, `Amount` = 1, `Currency` = 'BGN', `Provider` = 'fibank'
# [14-Mar-2025 16:51:34] /processspace/www/bg/payments/fibank/response.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Module`,
                `ModuleID`
	        FROM
	        	`payments`
	    	WHERE
                `TransactionID` = 'RfSMCaTYva4iqhcFZK4WULbzu0M=' AND
	    		`Provider` = 'fibank' AND
                `Status` = 0
            LIMIT 1

SELECT * FROM `payment_info` LIMIT 1

SHOW COLUMNS FROM `payment_info`

INSERT INTO `payment_info` SET `PaymentID` = '32', `PostDate` = NOW(), `Result` = '{"RESULT":"OK","RESULT_CODE":"000","3DSECURE":"AUTHENTICATED","RRN":"507314450383","APPROVAL_CODE":"721488","CARD_NUMBER":"437851******2074"}'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

UPDATE `payments` SET `Status` = 1 WHERE `ID` = '32' AND `Provider` = 'fibank'
# [14-Mar-2025 16:51:34] /processspace/www/bg/club/success/38.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 16:51:34] /processspace/www/bg/ajax/club/send/38.html?_=1741964005812 167.99.142.201

set names utf8

SELECT
                `Membership`,
                `Data`
	        FROM
	        	`club`
	    	WHERE
	    		`ID` = 38 AND
                `Status` = 0
            LIMIT 1

SELECT
                `ID`
	        FROM
	        	`payments`
	    	WHERE
                `Module` = 'club' AND
	    		`ModuleID` = 38 AND
                `Status` = 1
            LIMIT 1

UPDATE
                `club`
            SET
                `LastUpdate` = NOW(),
                `Status` = `Status` | 1
            WHERE
                `ID` = 38
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubFriends','LName','LPhone','LEMail','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                `club`
            SET
                `LastUpdate` = NOW(),
                `Status` = `Status` | 2
            WHERE
                `ID` = 38
            LIMIT 1

UPDATE
                `club`
            SET
                `LastUpdate` = NOW(),
                `Status` = `Status` | 4
            WHERE
                `ID` = 38
            LIMIT 1
# [14-Mar-2025 16:51:46] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 16:52:00] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 16:52:00] /processspace/www/bg/ajax/club/form/individual.html?_=1741964031832 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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 ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 16:52:23] /processspace/www/bg/ajax/club/submit/individual.html?_=1741964054523 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 16:52:23', `Membership` = 'individual', `Data` = 'mGGvTfOAIPv1NN6bUeqJYQKnkAGcDgakUoxhNIB1KhBtKWath3MJRscy1A8uhqvRTfsAzTiFf9HFSM4IJB4ZFbmNpFmkng5_M0ZKE7lGxrOuBUi8I6rxiLvqyXs4b2CFNiS0_bq2xQvj14VsMz6jX8-YkWb8QJmBx62-yE1l2yAYSlErpZl7_ImVHrGKinal'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'dxcUDj2z0rmbLnNjizvukfKR5gw=', `Description` = 'test transaction', `PostDate` = '2025-03-14 16:52:23', `LastUpdate` = '2025-03-14 16:52:23', `Module` = 'club', `ModuleID` = 39, `Amount` = 1, `Currency` = 'BGN', `Provider` = 'fibank'
# [14-Mar-2025 16:52:42] /processspace/www/bg/payments/fibank/response.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Module`,
                `ModuleID`
	        FROM
	        	`payments`
	    	WHERE
                `TransactionID` = 'dxcUDj2z0rmbLnNjizvukfKR5gw=' AND
	    		`Provider` = 'fibank' AND
                `Status` = 0
            LIMIT 1

SELECT * FROM `payment_info` LIMIT 1

SHOW COLUMNS FROM `payment_info`

INSERT INTO `payment_info` SET `PaymentID` = '33', `PostDate` = NOW(), `Result` = '{"RESULT":"FAILED","RESULT_CODE":"129","3DSECURE":"AUTHENTICATED","RRN":"507314450386","APPROVAL_CODE":"201820","CARD_NUMBER":"437851******2074"}'
# [14-Mar-2025 16:52:42] /processspace/www/bg/club/failed.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 16:52:56] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 16:52:59] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741964090533 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:53:00] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741964091453 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:53:01] /processspace/www/psNr2S0b/bg/ajax/payments/32.html?_=1741964092262 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 32
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 16:54:57] /processspace/www/psNr2S0b/bg/ajax/payments/31.html?_=1741964207990 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 31
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 17:01:57] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 17:01:58] /processspace/www/bg/ajax/club/form/individual.html?_=1741964629263 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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 ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 17:02:25] /processspace/www/bg/ajax/club/submit/individual.html?_=1741964656250 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 17:02:25', `Membership` = 'individual', `Data` = 'useNplToqjOQhudUt-gnoet_epPIFMh2ekqQsm5LhdZqC3Pe7_9CFoXQJnyuDld3ig4GOehko_-7hh6qCT47K2Q-Lso87ob2mGM6PAl3VSDL9MOjbTBYn5Q0GqIoKd6IcjFncnfh_81HJ2vt1kbA35gJpvwykU_cxA3HVax5Xicyt_drfecdy-9L-fgfCcy-'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'TUNk3lzQ5GzzieDv7ukpoCL1SM4=', `Description` = 'test transaction', `PostDate` = '2025-03-14 17:02:25', `LastUpdate` = '2025-03-14 17:02:25', `Module` = 'club', `ModuleID` = 40, `Amount` = 1, `Currency` = 'BGN', `Provider` = 'fibank'
# [14-Mar-2025 17:04:09] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 17:04:10] /processspace/www/bg/ajax/club/form/individual.html?_=1741964761016 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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 ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 17:04:40] /processspace/www/bg/ajax/club/submit/individual.html?_=1741964791487 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 17:04:40', `Membership` = 'individual', `Data` = 's_DSix4FcjHhzEY9sVKRb79Ptre1U6tkn5aw4Hrh9RrZLauxwDj3QUNeSfPYScSS5UTl8rXZ4jwLAh1a0FP-F16-CkPi4-C1jVMTuUWSZ5H26c2_9RVkKHb0K6bY639jEkgAAxORp1q_i8pEcBKeVM-mhJiwuQw5SqmG46I25ZpXeZTPlMXL0GQsJpQq5R3Y'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'oAVhOmyMonqdncOepWJGnpswskg=', `Description` = 'test transaction', `PostDate` = '2025-03-14 17:04:40', `LastUpdate` = '2025-03-14 17:04:40', `Module` = 'club', `ModuleID` = 41, `Amount` = 1, `Currency` = 'BGN', `Provider` = 'fibank'
# [14-Mar-2025 17:06:31] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 17:06:57] /processspace/www/psNr2S0b/bg/payments/list.html?sort=10 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 17:06:58] /processspace/www/psNr2S0b/bg/payments/list.html?sort=11 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 17:06:59] /processspace/www/psNr2S0b/bg/payments/list.html?sort=10 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 17:07:00] /processspace/www/psNr2S0b/bg/payments/list.html?sort=11 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 17:07:23] /processspace/www/psNr2S0b/bg/ajax/payments/fibank/refund/32.html?_=1741964954089 167.99.142.201

set names utf8

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

SELECT `TransactionID` FROM `payments` WHERE `ID` = 32 AND `Provider` = 'fibank' AND `Status` = 1

UPDATE `payments` SET `LastUpdate` = NOW(), `Status` = '2' WHERE `ID` = 32

SELECT * FROM `payment_info` LIMIT 1

SHOW COLUMNS FROM `payment_info`

INSERT INTO `payment_info` SET `PaymentID` = '32', `PostDate` = NOW(), `Result` = '{"RESULT":"OK","RESULT_CODE":"000","REFUND_TRANS_ID":"AP4B22txv9taTIaZNbcvbu6QQ58="}'
# [14-Mar-2025 17:07:28] /processspace/www/psNr2S0b/bg/payments/list.html?sort=11 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 17:12:28] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [14-Mar-2025 17:12:28] /processspace/www/bg/ajax/club/form/individual.html?_=1741965259516 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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 ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 17:12:52] /processspace/www/bg/ajax/club/submit/individual.html?_=1741965283302 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 17:12:52', `Membership` = 'individual', `Data` = 'DDw8cqdg1EUT5k1bs5vHq7ePKnEHTmCq-hf1lwOW10fC873ejY7Ji_c63b3oNpmITRHdfBxwQ0F5KrAlF4PGWssw1tOGNPLscDypKjEzelFnaimCuWRl9i56_ySrJJwi6UZ3X0eRhQMHTKiB_tMPSuRzU-1pgn0KX6XUsseaL9UAuxdt7j-Ik49de2c95p6l'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'nJ5EGPGUPZWTe7MJXh2SDyUejf0=', `Description` = 'test transaction', `PostDate` = '2025-03-14 17:12:52', `LastUpdate` = '2025-03-14 17:12:52', `Module` = 'club', `ModuleID` = 42, `Amount` = 1, `Currency` = 'BGN', `Provider` = 'fibank'
# [14-Mar-2025 17:13:32] /processspace/www/psNr2S0b/bg/payments/list.html?sort=11 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [14-Mar-2025 17:15:34] /processspace/www/psNr2S0b/bg/ajax/payments/36.html?_=1741965445820 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 36
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 17:18:05] /processspace/www/psNr2S0b/bg/ajax/payments/32.html?_=1741965595992 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 32
            ORDER BY
                `payment_info`.`PostDate` ASC
# [14-Mar-2025 17:18:22] /processspace/www/psNr2S0b/bg/ajax/payments/33.html?_=1741965613429 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                INNER JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 33
            ORDER BY
                `payment_info`.`PostDate` ASC
