ownCloud : outil d'affichage des partages pour un compte donné

diff --git a/ownCloud/owncloud-shares-for b/ownCloud/owncloud-shares-for
new file mode 100755 (executable)
index 0000000..bbc7e58
--- /dev/null
+++ b/ownCloud/owncloud-shares-for
@@ -0,0 +1,17 @@
+#!/bin/sh
+# /usr/local/sbin/owncloud-shares-for 
+if [ $# != 1 ]
+then
+  echo "Usage : $0 <username>"
+  exit 1
+fi
+
+username="$1"
+if ! expr match "${username}" ".*@.*" >/dev/null 2>&1
+then
+  username="${username}@auf.org"
+fi
+
+owncloud_home="/srv/data"
+
+echo "SELECT s.uid_owner AS 'Owner',CONCAT(REPLACE(st.id,'home::','${owncloud_home}'),'/',fc.path) AS 'Path' FROM oc_share s LEFT JOIN oc_filecache fc ON s.item_source=fc.fileid LEFT JOIN oc_storages st ON fc.storage=st.numeric_id WHERE s.share_with='${username}';" | mysql owncloud