[feladat @ 159]
authorpeter
Wed, 12 Mar 2008 20:45:56 +0000
changeset 81 c72d6d51f3d3
parent 80 48b5f7021aaa
child 82 c255196bc447
[feladat @ 159] Bugfix for ticket:16: A minor glitch in the query caused partially owned records not to be shown.
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";