new commands

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 @@
+#!/bin/bash
+set -e
+
+wp_config_get()
+{
+        sed -n "s/^define( *'$1', *'\([^']*\)' *);/\1/p" < "$wp_config"
+}
+
+wp_table_prefix_get()
+{
+        sed -ne "s/^\$table_prefix *= *'\\([^']*\\)';$/\\1/p"  "$wp_config"
+}
+
+case "$1" in
+        --table_prefix) shift; TABLE_PREFIX_ONLY=y ;;
+        --) shift ;;
+        -*) exit 1 ;;
+esac
+
+case "${1%/}" in
+        '') exit 1 ;;
+        /srv/*/*/*) exit 1 ;;
+        /srv/*/public_html) SITE_DIR=${1%/} ;;
+        /srv/*/*) exit 1;;
+        /srv/*) SITE_DIR=${1%/}/public_html ;;
+        */*) exit 1 ;;
+        .*) exit 1 ;;
+        *) SITE_DIR=/srv/${1%/}/public_html ;;
+esac
+
+case "$SITE_DIR" in
+        /srv/*/*/*) exit 1 ;;
+        /srv/*/public_html) [ -d "$SITE_DIR" ] ;;
+        *) exit 1 ;;
+esac
+
+wp_config=$SITE_DIR/wordpress/wp-config.php
+[ -f "$wp_config" ]
+
+if [ "$TABLE_PREFIX_ONLY" ]
+then
+        wp_table_prefix_get
+        exit
+fi
+
+db_name=$(wp_config_get DB_NAME)
+[ "$db_name" ]
+db_host=$(wp_config_get DB_HOST)
+[ "$db_host" ]
+db_user=$(wp_config_get DB_USER)
+[ "$db_user" ]
+db_password=$(wp_config_get DB_PASSWORD)
+[ "$db_password" ]
+
+mysql --host="$db_host" --user="$db_user" --password="$db_password" "$db_name"
+
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 @@
-#!/bin/bash
-set -ex
-
-domain=freetailtherapy.com
-
-[ "$domain" ]
-[ -d /srv/"$domain" ]
-
-dbname=${domain//./_}
-username=wordpress_$dbname
-password=6vtptrfwsngmczcgrmkll
-
-myqsl "$dbname" <<END
-grant all privileges on `$dbname`.* to "$username" identified by "$password";
+#!/bin/bash -e
+prefix=$(./wordpress-mysql --table_prefix "$1")
+wordpress-mysql "$1" <<END
+select id, user_login, user_pass from ${prefix}users;
 END