wordpress-list-users will list users for all sites

1 files changed, 25 insertions, 3 deletions

diff --git a/wordpress/wordpress-list-users b/wordpress/wordpress-list-users
index ede3d3b..76432b6 100755
--- a/wordpress/wordpress-list-users
+++ b/wordpress/wordpress-list-users
@@ -1,7 +1,29 @@
 #!/bin/bash
 set -e
-prefix=$(wordpress-config-info "$1" | jq -r .table_prefix)
-wordpress-mysql "$1" <<END
-select id, user_login, user_pass from ${prefix}users;
+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