[feladat @ 159]
Bugfix for ticket:16: A minor glitch in the query caused partially owned records not to be shown.
--- 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";