nautilus-scripts : compression de PDF
[progfou.git] / ownCloud / owncloud-shares-for
CommitLineData
ee00026e
P
1#!/bin/sh
2# /usr/local/sbin/owncloud-shares-for
3if [ $# != 1 ]
4then
5 echo "Usage : $0 <username>"
6 exit 1
7fi
8
9username="$1"
10if ! expr match "${username}" ".*@.*" >/dev/null 2>&1
11then
12 username="${username}@auf.org"
13fi
14
15owncloud_home="/srv/data"
16
17echo "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