wp-install.sh

#!/bin/bash
pwd=`dirname $0`

read -e -p "Target directory: " -i "/var/www/html" dir
dir=${dir:-"/var/www/html"}

read -e -p "Database Name: " -i "wpxp" db
db=${db:-"wpxp"}
read -e -p "Database Username: " -i "usxp" user
user=${user:-"usxp"}
read -e -p "Password User: " -i "Xpanel2023" pass
pass=${pass:-"Xpanel2023"}

if [ ! -d "$dir" ]; then
	sudo mkdir -p $dir
fi
Q1="CREATE DATABASE $db;"
Q2="CREATE USER '$user'@'localhost' IDENTIFIED BY '$pass';"
Q3="GRANT ALL ON $db.* TO '$user'@'localhost' IDENTIFIED BY '$pass';"
Q4="FLUSH PRIVILEGES;"
SQL=${Q1}${Q2}${Q3}${Q4}

`mysql -u root -p -e "$SQL"`

cd $dir
sudo wget http://wordpress.org/latest.zip
sudo unzip latest.zip > /dev/null
sudo cp example/sync.php sync.php 
sudo rm -rf example

sudo mv wordpress example
sudo cp sync.php example/sync.php 
sudo chown -R www-data:www-data $dir
sudo chmod -R 775 $dir

u=$SUDO_USER
if [ -z $u ]; then
	u=$USER
fi

if !(groups $u | grep >/dev/null www-data); then
	sudo adduser $u www-data
fi
clear
echo ""
echo "Database Name: $db"
echo "Database Username: $user"
echo "Database User Password: $pass"
echo ""