[feladat @ 207]
authorrejo
Fri, 28 Mar 2008 21:57:43 +0000
changeset 107 fee925b9bdef
parent 106 41d05ff53708
child 108 b1015b3055af
[feladat @ 207] Bugfix. The letters shown just above the list of zones was showing clickable letters, even if there were no zones starting with such a letter.
inc/toolkit.inc.php
--- a/inc/toolkit.inc.php	Fri Mar 28 21:40:42 2008 +0000
+++ b/inc/toolkit.inc.php	Fri Mar 28 21:57:43 2008 +0000
@@ -153,12 +153,10 @@
         $query = "SELECT 
 			domains.id AS domain_id,
 			zones.owner,
-			records.id,
 			domains.name AS domainname
 			FROM domains
 			LEFT JOIN zones ON domains.id=zones.domain_id 
-			LEFT JOIN records ON records.domain_id=domains.id
-			AND substring(domains.name,1,1) ".$sql_regexp." ".$db->quote("^".$letter);
+			WHERE substring(domains.name,1,1) ".$sql_regexp." ".$db->quote("^".$letter);
 	$db->setLimit(1);
         $result = $db->query($query);
         $numrows = $result->numRows();