Changeset 12543

Timestamp:

04/14/2023 04:47:35 PM (3 years ago)

Author:

Otto42

Message:

Photo directory: Switch limit matching to use a regular expression for the query. The extra backslashes are because of the ridiculous escaping necessary for both PHP and mySQL. Fixes #6934. Related #6569

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/photo-directory/inc/search.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/plugins/photo-directory/inc/search.php

@@ -107 +107 @@
                         $where = preg_replace(
                                 "/LIKE '(\{\w+\})([^\{]+)(\{\w+\})'/",
-                                "LIKE '$2$1'",
+                                "REGEXP '\\\\\\\\b$2.*'",
                                 $where
                         );