(bug 20275) Fixed LIKE queries on SQLite backend

[lhc/web/wiklou.git] / includes / LinkFilter.php

diff --git a/includes/LinkFilter.php b/includes/LinkFilter.php
index dc4c125..af90a9b 100644 (file)
--- a/includes/LinkFilter.php
+++ b/includes/LinkFilter.php
@@ -49,8 +49,10 @@ class LinkFilter {
         * @static
         * @param $filterEntry String: domainparts
         * @param $prot        String: protocol
+        * @deprecated Use makeLikeArray() and pass result to Database::buildLike() instead
         */
         public static function makeLike( $filterEntry , $prot = 'http://' ) {
+               wfDeprecated( __METHOD__ );
                $db = wfGetDB( DB_MASTER );
                if ( substr( $filterEntry, 0, 2 ) == '*.' ) {
                        $subdomains = true;
@@ -105,4 +107,99 @@ class LinkFilter {
                }
                return $like;
        }
+
+       /**
+        * Make an array to be used for calls to Database::like(), which will match the specified
+        * string. There are several kinds of filter entry:
+        *     *.domain.com    -  Produces http://com.domain.%, matches domain.com
+        *                        and www.domain.com
+        *     domain.com      -  Produces http://com.domain./%, matches domain.com
+        *                        or domain.com/ but not www.domain.com
+        *     *.domain.com/x  -  Produces http://com.domain.%/x%, matches
+        *                        www.domain.com/xy
+        *     domain.com/x    -  Produces http://com.domain./x%, matches
+        *                        domain.com/xy but not www.domain.com/xy
+        *
+        * Asterisks in any other location are considered invalid.
+        * 
+        * @static
+        * @param $filterEntry String: domainparts
+        * @param $prot        String: protocol
+        */
+        public static function makeLikeArray( $filterEntry , $prot = 'http://' ) {
+               $db = wfGetDB( DB_MASTER );
+               if ( substr( $filterEntry, 0, 2 ) == '*.' ) {
+                       $subdomains = true;
+                       $filterEntry = substr( $filterEntry, 2 );
+                       if ( $filterEntry == '' ) {
+                               // We don't want to make a clause that will match everything,
+                               // that could be dangerous
+                               return false;
+                       }
+               } else {
+                       $subdomains = false;
+               }
+               // No stray asterisks, that could cause confusion
+               // It's not simple or efficient to handle it properly so we don't
+               // handle it at all.
+               if ( strpos( $filterEntry, '*' ) !== false ) {
+                       return false;
+               }
+               $slash = strpos( $filterEntry, '/' );
+               if ( $slash !== false ) {
+                       $path = substr( $filterEntry, $slash );
+                       $host = substr( $filterEntry, 0, $slash );
+               } else {
+                       $path = '/';
+                       $host = $filterEntry;
+               }
+               // Reverse the labels in the hostname, convert to lower case
+               // For emails reverse domainpart only
+               if ( $prot == 'mailto:' && strpos($host, '@') ) {
+                       // complete email adress 
+                       $mailparts = explode( '@', $host );
+                       $domainpart = strtolower( implode( '.', array_reverse( explode( '.', $mailparts[1] ) ) ) );
+                       $host = $domainpart . '@' . $mailparts[0];
+                       $like = array( "$prot$host", $db->anyString() );
+               } elseif ( $prot == 'mailto:' ) {
+                       // domainpart of email adress only. do not add '.'
+                       $host = strtolower( implode( '.', array_reverse( explode( '.', $host ) ) ) );   
+                       $like = array( "$prot$host", $db->anyString() );                        
+               } else {
+                       $host = strtolower( implode( '.', array_reverse( explode( '.', $host ) ) ) );   
+                       if ( substr( $host, -1, 1 ) !== '.' ) {
+                               $host .= '.';
+                       }
+                       $like = array( "$prot$host" );
+
+                       if ( $subdomains ) {
+                               $like[] = $db->anyString();
+                       }
+                       if ( !$subdomains || $path !== '/' ) {
+                               $like[] = $path;
+                               $like[] = $db->anyString();
+                       }
+               }
+               return $like;
+       }
+
+       /**
+        * Filters an array returned by makeLikeArray(), removing everything past first pattern placeholder.
+        * @static
+        * @param $arr array: array to filter
+        * @return filtered array
+        */
+       public static function keepOneWildcard( $arr ) {
+               if( !is_array( $arr ) ) {
+                       return $arr;
+               }
+
+               foreach( $arr as $key => $value ) {
+                       if ( $value instanceof LikeMatch ) {
+                               return array_slice( $arr, 0, $key + 1 );
+                       }
+               }
+
+               return $arr;
+       }
 }