Changeset 2819 for alternc/trunk/src/dns.sh

Timestamp:

01/29/11 16:12:26 (2 years ago)

Author:

fufroma

Message:

Conf web : CREATION ok

File:

• alternc/trunk/src/dns.sh (modified) (1 diff)

alternc/trunk/src/dns.sh

@@ -94 +94 @@
     file=$(
         echo -e "$file"
-        $MYSQL_DO "select replace(replace(dt.entry,'%TARGET%',sd.valeur), '%SUB%', if(length(sd.sub)>0,sd.sub,'@')) from sub_domaines sd,domaines_type dt where sd.type=dt.name and sd.domaine='$domain';"|sort
+        $MYSQL_DO "select distinct replace(replace(dt.entry,'%TARGET%',sd.valeur), '%SUB%', if(length(sd.sub)>0,sd.sub,'@')) as entry from sub_domaines sd,domaines_type dt where sd.type=dt.name and sd.domaine='$domain' order by entry ;"
     )
 
 
     # Get some usefull vars
-    local mx=$( $MYSQL_DO "select mx from domaines where domaine='$domain';")
+    local mx=$( $MYSQL_DO "select mx from domaines where domaine='$domain' limit 1;")
 
     # Replace the vars by their values