summaryrefslogtreecommitdiff
path: root/wordpress/wordpress-list-users
blob: 76432b64fb21a59ede83936646719c7fde8c91db (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
#!/bin/bash
set -e
set -o pipefail
PATH=$(dirname "$0"):$PATH

for_each_wordpress_site()
{
	wordpress-config-info |
	jq -r '.[] | .site' |
	while read d
	do
		("$@" "$d") || continue
	done
}
if [ $# = 0 ]
then
	for_each_wordpress_site "$0"
	exit
fi

usertable=$(wordpress-config-info "$1" | jq -r .table_prefix)users
wordpress-mysql -- "$1" -t <<END
select
	id,
	user_login as '${1//\'/\'\'} login',
	user_pass as 'pass'
from ${usertable};
END