--- /dev/null
+#!/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