diff options
author | root <root@vps-18a7a2b7.vps.ovh.ca> | 2023-05-22 22:38:14 -0400 |
---|---|---|
committer | root <root@vps-18a7a2b7.vps.ovh.ca> | 2023-05-22 22:38:14 -0400 |
commit | ac729728f372713dfd0262d93cc0ba6f401e7797 (patch) | |
tree | 79807b09e4f74afb6ea8a29ac5c3a1904a67d3dc | |
parent | a80b6938f438c6be9fc3ba13de70dca2e150f9e7 (diff) |
new commands
-rwxr-xr-x | other/wordpress-mysql | 56 | ||||
-rwxr-xr-x | other/worduser-list-users | 18 |
2 files changed, 60 insertions, 14 deletions
diff --git a/other/wordpress-mysql b/other/wordpress-mysql new file mode 100755 index 0000000..5c69693 --- /dev/null +++ b/other/wordpress-mysql | |||
@@ -0,0 +1,56 @@ | |||
1 | #!/bin/bash | ||
2 | set -e | ||
3 | |||
4 | wp_config_get() | ||
5 | { | ||
6 | sed -n "s/^define( *'$1', *'\([^']*\)' *);/\1/p" < "$wp_config" | ||
7 | } | ||
8 | |||
9 | wp_table_prefix_get() | ||
10 | { | ||
11 | sed -ne "s/^\$table_prefix *= *'\\([^']*\\)';$/\\1/p" "$wp_config" | ||
12 | } | ||
13 | |||
14 | case "$1" in | ||
15 | --table_prefix) shift; TABLE_PREFIX_ONLY=y ;; | ||
16 | --) shift ;; | ||
17 | -*) exit 1 ;; | ||
18 | esac | ||
19 | |||
20 | case "${1%/}" in | ||
21 | '') exit 1 ;; | ||
22 | /srv/*/*/*) exit 1 ;; | ||
23 | /srv/*/public_html) SITE_DIR=${1%/} ;; | ||
24 | /srv/*/*) exit 1;; | ||
25 | /srv/*) SITE_DIR=${1%/}/public_html ;; | ||
26 | */*) exit 1 ;; | ||
27 | .*) exit 1 ;; | ||
28 | *) SITE_DIR=/srv/${1%/}/public_html ;; | ||
29 | esac | ||
30 | |||
31 | case "$SITE_DIR" in | ||
32 | /srv/*/*/*) exit 1 ;; | ||
33 | /srv/*/public_html) [ -d "$SITE_DIR" ] ;; | ||
34 | *) exit 1 ;; | ||
35 | esac | ||
36 | |||
37 | wp_config=$SITE_DIR/wordpress/wp-config.php | ||
38 | [ -f "$wp_config" ] | ||
39 | |||
40 | if [ "$TABLE_PREFIX_ONLY" ] | ||
41 | then | ||
42 | wp_table_prefix_get | ||
43 | exit | ||
44 | fi | ||
45 | |||
46 | db_name=$(wp_config_get DB_NAME) | ||
47 | [ "$db_name" ] | ||
48 | db_host=$(wp_config_get DB_HOST) | ||
49 | [ "$db_host" ] | ||
50 | db_user=$(wp_config_get DB_USER) | ||
51 | [ "$db_user" ] | ||
52 | db_password=$(wp_config_get DB_PASSWORD) | ||
53 | [ "$db_password" ] | ||
54 | |||
55 | mysql --host="$db_host" --user="$db_user" --password="$db_password" "$db_name" | ||
56 | |||
diff --git a/other/worduser-list-users b/other/worduser-list-users index 8d92847..049de68 100755 --- a/other/worduser-list-users +++ b/other/worduser-list-users | |||
@@ -1,16 +1,6 @@ | |||
1 | #!/bin/bash | 1 | #!/bin/bash -e |
2 | set -ex | 2 | prefix=$(./wordpress-mysql --table_prefix "$1") |
3 | 3 | wordpress-mysql "$1" <<END | |
4 | domain=freetailtherapy.com | 4 | select id, user_login, user_pass from ${prefix}users; |
5 | |||
6 | [ "$domain" ] | ||
7 | [ -d /srv/"$domain" ] | ||
8 | |||
9 | dbname=${domain//./_} | ||
10 | username=wordpress_$dbname | ||
11 | password=6vtptrfwsngmczcgrmkll | ||
12 | |||
13 | myqsl "$dbname" <<END | ||
14 | grant all privileges on `$dbname`.* to "$username" identified by "$password"; | ||
15 | END | 5 | END |
16 | 6 | ||