equal
deleted
inserted
replaced
1032 domains.name AS domainname |
1032 domains.name AS domainname |
1033 FROM domains, record_owners,records, zones |
1033 FROM domains, record_owners,records, zones |
1034 WHERE record_owners.user_id = ".$db->quote($_SESSION["userid"])." |
1034 WHERE record_owners.user_id = ".$db->quote($_SESSION["userid"])." |
1035 AND (records.id = record_owners.record_id |
1035 AND (records.id = record_owners.record_id |
1036 AND domains.id = records.domain_id) |
1036 AND domains.id = records.domain_id) |
1037 $andnot |
1037 $andnot"; |
1038 AND substring(domains.name,1,1) ".$sql_regexp." '^[[:digit:]]' |
1038 if ($letterstart != 'all') { |
1039 AND (zones.domain_id != records.domain_id AND zones.owner!=".$db->quote($_SESSION["userid"]).") |
1039 $sqlq .= " AND substring(domains.name,1,1) ".$sql_regexp." '^[[:digit:]]'"; |
|
1040 } |
|
1041 $sqlq .= "AND (zones.domain_id != records.domain_id AND zones.owner!=".$db->quote($_SESSION["userid"]).") |
1040 GROUP BY domainname, domains.id |
1042 GROUP BY domainname, domains.id |
1041 ORDER BY domainname"; |
1043 ORDER BY domainname"; |
1042 |
1044 |
1043 $result_extra[$i] = $db->query($sqlq); |
1045 $result_extra[$i] = $db->query($sqlq); |
1044 |
1046 |