From 372c8d2bc6a3bf3cdb49bdb66c9fa4780fceedcf Mon Sep 17 00:00:00 2001
From: root <root@vps-18a7a2b7.vps.ovh.ca>
Date: Wed, 24 Jan 2024 08:41:02 -0500
Subject: wordpress-list-users will list users for all sites

---
 wordpress/wordpress-list-users | 28 +++++++++++++++++++++++++---
 1 file changed, 25 insertions(+), 3 deletions(-)

(limited to 'wordpress')

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
 
-- 
cgit v1.2.3