CMS Donate Engine

mysqli://mariadb:3306/cde_test

            SELECT
                s.`data` AS data,
                s.`userid` AS userid,
                s.`user` AS user,
                m.`balance` AS coins,
                m.`posts` AS posts,
                r.`cash` AS cash,
                IFNULL(d.pm_count, 0) AS pm,
                IFNULL(b.ban_count, 0) AS banned
            FROM `ms_session` s
            LEFT JOIN `ms_money` m ON m.`username` = s.`user`
            LEFT JOIN `ms_realmoney` r ON r.`name` = s.`user`
            LEFT JOIN (
                SELECT user_id, COUNT(*) AS pm_count
                FROM `ms_dialogs_user`
                WHERE `flags` = "1"
                GROUP BY user_id
            ) d ON d.user_id = s.`userid`
            LEFT JOIN (
                SELECT `name`, COUNT(*) AS ban_count
                FROM `ms_banlist`
                WHERE `type` IN ("1","0","10","11","12")
                AND (`temptime` > 1764993139 OR `temptime` = 0)
                GROUP BY `name`
            ) b ON b.`name` = s.`user`
            WHERE s.`id` = "bfcba70964335b5061629a0402285ace"
            LIMIT 1
        

		SELECT
			`a`.`user` as user,
			`u`.`email` as mail
		FROM
			`cde_test`.`ms_acl_users` as a,
			`cde_test`.`ms_members` as u
		WHERE
			`a`.`user` = `u`.`usr` AND
			(
				`a`.`msmod` LIKE '%"view_on_contact":"1"%' OR
				`a`.`owner` = "1"
			)