# HG changeset patch
# User peter
# Date 1205354756 0
# Node ID c72d6d51f3d31dd708254f46ec4438a14ec7ec96
# Parent  48b5f7021aaaf84f8ea64616381d76276307b5a0
[feladat @ 159]
Bugfix for ticket:16: A minor glitch in the query caused partially owned records not to be shown.

diff -r 48b5f7021aaa -r c72d6d51f3d3 inc/record.inc.php
--- a/inc/record.inc.php	Wed Mar 12 19:47:25 2008 +0000
+++ b/inc/record.inc.php	Wed Mar 12 20:45:56 2008 +0000
@@ -1034,9 +1034,11 @@
 		WHERE record_owners.user_id = ".$db->quote($_SESSION["userid"])."
 		AND (records.id = record_owners.record_id
 		AND domains.id = records.domain_id)
-		$andnot 
-		AND substring(domains.name,1,1) ".$sql_regexp." '^[[:digit:]]'
-		AND (zones.domain_id != records.domain_id AND zones.owner!=".$db->quote($_SESSION["userid"]).")
+		$andnot";
+		if ($letterstart != 'all') { 
+			$sqlq .= " AND substring(domains.name,1,1) ".$sql_regexp." '^[[:digit:]]'";
+		}
+		$sqlq .= "AND (zones.domain_id != records.domain_id AND zones.owner!=".$db->quote($_SESSION["userid"]).")
 		GROUP BY domainname, domains.id
 		ORDER BY domainname";