جزئیات آسیب‌پذیری

The Booking for Appointments and Events Calendar – Amelia Pro plugin for WordPress is vulnerable to time-based SQL Injection via the 'tag[] (array KEYS)' parameter in all versions up to, and including, 9.9.1 due to insufficient escaping on the user supplied parameter and lack of sufficient preparation on the existing SQL query. This makes it possible for unauthenticated attackers to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database. WordPress's wp_magic_quotes escapes array values but not array keys, meaning attacker-controlled tag[] array keys reach EventRepository::getFilteredIds() completely unescaped and can be crafted to defeat the plugin's Statement::execute placeholder binder via overlapping strtr() substitution keys.

• https://www.wordfence.com/threat-intel/vulnerabilities/id/31a12180-b51b-4d36-ac4f-f35243c5d770?source=cve
• https://plugins.trac.wordpress.org/browser/ameliabooking/trunk/src/Infrastructure/Repository/Booking/Event/EventRepository.php#L520
• https://plugins.trac.wordpress.org/browser/ameliabooking/trunk/src/Infrastructure/DB/WPDB/Statement.php#L101
• https://plugins.trac.wordpress.org/browser/ameliabooking/trunk/src/Application/Commands/Booking/Event/GetEventsCommandHandler.php#L72
• https://plugins.trac.wordpress.org/browser/ameliabooking/trunk/ameliabooking.php#L1337
• https://plugins.trac.wordpress.org/browser/ameliabooking/trunk/src/Application/Controller/Booking/Event/GetEventsController.php#L29
• https://wpamelia.com/documentation/changelog/