#!/bin/bash
# info: change db password to all wordpress databases
# options:
#
# The command is used for changing db password to all wordpress databases on the server.


#----------------------------------------------------------#
#                    Variable&Function                     #
#----------------------------------------------------------#

# Importing system variables
source /etc/profile

# Includes
source $VESTA/func/main.sh

only_user='';
if [ ! -z "$1" ]; then
    only_user=$1
fi

#----------------------------------------------------------#
#                       Action                             #
#----------------------------------------------------------#

touch /root/remember-db-user-pass.txt

for user in $(grep '@' /etc/passwd |cut -f1 -d:); do
    if [ ! -f "/usr/local/vesta/data/users/$user/user.conf" ]; then
        continue;
    fi

    if [ ! -z "$only_user" ]; then
        if [ "$only_user" != "$user" ]; then
            continue;
        fi
    fi

    for domain in $(/usr/local/vesta/bin/v-list-web-domains $user plain |cut -f 1); do
        if [ -f "/home/$user/web/$domain/public_html/wp-config.php" ]; then
            /usr/local/vesta/bin/v-change-database-password-for-wordpress $domain $user
            echo "--------------------------------"
        fi
    done

    if [ ! -z "$only_user" ]; then
        break;
    fi

done

# cat /root/remember-db-user-pass.txt
rm /root/remember-db-user-pass.txt

#----------------------------------------------------------#
#                       Vesta                              #
#----------------------------------------------------------#

# Logging
log_event "$OK" "$ARGUMENTS"

exit