summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorroot <root@vps-18a7a2b7.vps.ovh.ca>2023-05-23 20:30:24 -0400
committerroot <root@vps-18a7a2b7.vps.ovh.ca>2023-05-23 20:34:17 -0400
commit393e339257771358c87601bed1de5663051c3b15 (patch)
tree1bb1a9cd2001a85181d9f401810d1588baae266d
parent736c00e3ab6f71eadfd6bde609b3656feaa954f0 (diff)
simplify wordpress-config-info
-rwxr-xr-xwordpress/wordpress-config-info59
-rwxr-xr-xwordpress/worduser-list-users5
2 files changed, 21 insertions, 43 deletions
diff --git a/wordpress/wordpress-config-info b/wordpress/wordpress-config-info
index bee8a4c..f7f19f9 100755
--- a/wordpress/wordpress-config-info
+++ b/wordpress/wordpress-config-info
@@ -11,44 +11,26 @@ wp_table_prefix_get()
11 sed -e 's/\r//g' -ne "s/^\$table_prefix *= *'\\([^']*\\)';$/\\1/p" "$wp_config" 11 sed -e 's/\r//g' -ne "s/^\$table_prefix *= *'\\([^']*\\)';$/\\1/p" "$wp_config"
12} 12}
13 13
14case "$1" in 14find_wp_config()
15 --table_prefix) shift; TABLE_PREFIX_ONLY=y ;; 15{
16 --) shift ;; 16 case "$1" in
17 -*) exit 1 ;; 17 */*) ;;
18esac 18 *) set -- /srv/"$1" ;;
19 19 esac
20case "$1" in 20
21 '') exit 1 ;; 21 for wp_config in "$1" "$1"/wp-config.php "$1"/wordpress/wp-config.php "$1"/public_html/wp-config.php "$1"/public_html/wordpress/wp-config.php
22 /srv/*/*/*/*) exit 1 ;; 22 do
23 /srv/*/public_html/wp-config.php) SITE_DIR=${1%/wp-config.php} ;; 23 if [ -f "$wp_config" ]
24 /srv/*/*/*) exit 1 ;; 24 then
25 /srv/*/public_html) SITE_DIR=$1 ;; 25 return
26 /srv/*/*) exit 1;; 26 fi
27 /srv/*) SITE_DIR=$1/public_html ;; 27 done
28 */*) exit 1 ;; 28 false
29 .*) exit 1 ;; 29}
30 *) SITE_DIR=/srv/$1/public_html ;;
31esac
32
33case "$SITE_DIR" in
34 /srv/*/*/*) exit 1 ;;
35 /srv/*/public_html) [ -d "$SITE_DIR" ] ;;
36 *) exit 1 ;;
37esac
38 30
39if [ -d "$SITE_DIR"/wordpress ] 31[ $# = 1 ]
40then
41 wp_config=$SITE_DIR/wordpress/wp-config.php
42else
43 wp_config=$SITE_DIR/wp-config.php
44fi
45[ -f "$wp_config" ]
46 32
47if [ "$TABLE_PREFIX_ONLY" ] 33find_wp_config "$1"
48then
49 wp_table_prefix_get
50 exit
51fi
52 34
53db_name=$(wp_config_get DB_NAME) 35db_name=$(wp_config_get DB_NAME)
54[ "$db_name" ] 36[ "$db_name" ]
@@ -72,8 +54,3 @@ jq -n \
72 , db_name: $n 54 , db_name: $n
73 , table_prefix: $prefix 55 , table_prefix: $prefix
74 }' 56 }'
75
76#jq -n --arg h test '{ db_host: $h }'
77#jq --arg h test '{ .db_host = $h }'
78#mysql --host="$db_host" --user="$db_user" --password="$db_password" "$db_name"
79
diff --git a/wordpress/worduser-list-users b/wordpress/worduser-list-users
index 049de68..ede3d3b 100755
--- a/wordpress/worduser-list-users
+++ b/wordpress/worduser-list-users
@@ -1,5 +1,6 @@
1#!/bin/bash -e 1#!/bin/bash
2prefix=$(./wordpress-mysql --table_prefix "$1") 2set -e
3prefix=$(wordpress-config-info "$1" | jq -r .table_prefix)
3wordpress-mysql "$1" <<END 4wordpress-mysql "$1" <<END
4select id, user_login, user_pass from ${prefix}users; 5select id, user_login, user_pass from ${prefix}users;
5END 6END