summaryrefslogtreecommitdiff
path: root/wordpress/wordpress-list-users
blob: 006d2c914d465e48b7bed39d529ad9aaa64e44ea (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
30
31
32
33
34
35
36
37
#!/bin/bash
set -e
set -o pipefail
PATH=$(dirname "$0"):$PATH

if [ $# = 0 ]
then
	wordpress-config-info |
	while read -r
	do
		"$0" "$REPLY" || continue
	done
	exit
fi

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