# HG changeset patch
# User rejo
# Date 1206741463 0
# Node ID fee925b9bdefee498d5725b0abbde7846159ea69
# Parent  41d05ff53708cdc28296cf312a490c146daa315a
[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.

diff -r 41d05ff53708 -r fee925b9bdef 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();