Changeset 2611

Timestamp:

11/29/09 00:01:03 (3 years ago)

Author:

anarcat

Message:

also show the subdir in get_path output

File:

• alternc/trunk/tools/alternc_get_path (modified) (1 diff)

alternc/trunk/tools/alternc_get_path

@@ -5 +5 @@
 relpath=`echo "$path" | sed 's#/var/alternc/html/./[^/]*##'`
 
-request="SELECT membres.login AS user, CONCAT(s.sub, '.', s.domaine) AS fqdn FROM sub_domaines s INNER JOIN membres ON s.compte=uid WHERE login='$account' AND s.type = 0 AND '$relpath' LIKE CONCAT(s.valeur,'%') ORDER BY sub ASC;"
+request="SELECT membres.login AS user, CONCAT(s.sub, '.', s.domaine, s.valeur) AS fqdn FROM sub_domaines s INNER JOIN membres ON s.compte=uid WHERE login='$account' AND s.type = 0 AND '$relpath' LIKE CONCAT(s.valeur,'%') ORDER BY sub ASC;"
 
 mysql --defaults-file=/etc/alternc/my.cnf -B -e "$request"