diff -r e858e7e1aab4 -r a885f557678f inc/toolkit.inc.php --- a/inc/toolkit.inc.php Thu Dec 27 12:36:04 2007 +0000 +++ b/inc/toolkit.inc.php Sat Dec 29 14:42:34 2007 +0000 @@ -146,6 +146,7 @@ function zone_letter_start($letter,$userid=true) { global $db; + global $sql_regexp; $sqlq = "SELECT domains.id AS domain_id, zones.owner, records.id, @@ -153,7 +154,7 @@ FROM domains LEFT JOIN zones ON domains.id=zones.domain_id LEFT JOIN records ON records.domain_id=domains.id - WHERE 1"; + WHERE 1=1"; if((!level(5) || !$userid) && !level(10) && !level(5)) { // First select the zones for which we have ownership on one or more records. @@ -171,7 +172,7 @@ } $sqlq .= ')'; } - $sqlq .= " AND substring(domains.name,1,1) REGEXP '^".$letter."' LIMIT 1"; + $sqlq .= " AND substring(domains.name,1,1) ".$sql_regexp." '^".$letter."' LIMIT 1"; $result = $db->query($sqlq); $numrows = $result->numRows(); if ( $numrows == "1" )