diff options
author | root <root@vps-18a7a2b7.vps.ovh.ca> | 2023-05-23 20:30:24 -0400 |
---|---|---|
committer | root <root@vps-18a7a2b7.vps.ovh.ca> | 2023-05-23 20:34:17 -0400 |
commit | 393e339257771358c87601bed1de5663051c3b15 (patch) | |
tree | 1bb1a9cd2001a85181d9f401810d1588baae266d | |
parent | 736c00e3ab6f71eadfd6bde609b3656feaa954f0 (diff) |
simplify wordpress-config-info
-rwxr-xr-x | wordpress/wordpress-config-info | 59 | ||||
-rwxr-xr-x | wordpress/worduser-list-users | 5 |
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 | ||
14 | case "$1" in | 14 | find_wp_config() |
15 | --table_prefix) shift; TABLE_PREFIX_ONLY=y ;; | 15 | { |
16 | --) shift ;; | 16 | case "$1" in |
17 | -*) exit 1 ;; | 17 | */*) ;; |
18 | esac | 18 | *) set -- /srv/"$1" ;; |
19 | 19 | esac | |
20 | case "$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 ;; | ||
31 | esac | ||
32 | |||
33 | case "$SITE_DIR" in | ||
34 | /srv/*/*/*) exit 1 ;; | ||
35 | /srv/*/public_html) [ -d "$SITE_DIR" ] ;; | ||
36 | *) exit 1 ;; | ||
37 | esac | ||
38 | 30 | ||
39 | if [ -d "$SITE_DIR"/wordpress ] | 31 | [ $# = 1 ] |
40 | then | ||
41 | wp_config=$SITE_DIR/wordpress/wp-config.php | ||
42 | else | ||
43 | wp_config=$SITE_DIR/wp-config.php | ||
44 | fi | ||
45 | [ -f "$wp_config" ] | ||
46 | 32 | ||
47 | if [ "$TABLE_PREFIX_ONLY" ] | 33 | find_wp_config "$1" |
48 | then | ||
49 | wp_table_prefix_get | ||
50 | exit | ||
51 | fi | ||
52 | 34 | ||
53 | db_name=$(wp_config_get DB_NAME) | 35 | db_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 |
2 | prefix=$(./wordpress-mysql --table_prefix "$1") | 2 | set -e |
3 | prefix=$(wordpress-config-info "$1" | jq -r .table_prefix) | ||
3 | wordpress-mysql "$1" <<END | 4 | wordpress-mysql "$1" <<END |
4 | select id, user_login, user_pass from ${prefix}users; | 5 | select id, user_login, user_pass from ${prefix}users; |
5 | END | 6 | END |