Make memberlist sorting in phpBB case insensitive.

[tumba25]

In phpBB up to 3.0.4 (don't know about following versions yet) the sorting in memberlist.php is case sensitive. Thus giving A-Z followed by a-z if you sort by location or website.

Here is my fix to get the sorting case insensitive.

Open memberlist.php
Find

Code: Select all

$order_by .= $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');

replace with

Code: Select all

      $order_by .= (($sort_key != 'd' && $sort_key != 'm') ? 'LOWER(' : '') . $sort_key_sql[$sort_key] . (($sort_key != 'd') ? ') ' : ' ') . (($sort_dir == 'a' && $sort_key != 'm') ? 'ASC' : 'DESC');

[johnlee]

I try the phpBB case last time, im happy its work to me.