User:Subfader/ignorecase titlematch

From FollowTheScore
< User:Subfader
Revision as of 16:36, 16 November 2014 by Subfader (talk | contribs)
Jump to: navigation, search
{{#dpl:
 |debug=3
 |namespace=
 |titlematch=%LoadTest%
 |count=10
}}

{{#dpl:
 |debug=3
 |namespace=
 |titlematch=%loadtest%
 |ignorecase=true
 |count=10
}}

Extension:DynamicPageList (DPL), version 3.2.1: Warning: No results.

Solution

Add WHERE BINARY instead of LOWER(CAST(...)): http://stackoverflow.com/questions/7857669/mysql-case-sensitive-query

For titlematch:

if ($bIgnoreCase) $sSqlWhere .= ' BINARY ' . $sPageTable.'.page_title' . $sTitleMatchMode .  $dbr->addQuotes($link) ;

Would need to be added to every $bIgnoreCase I guess.