#!/bin/bash
# Bash script written by Alberto Iglesias - aigaliana@gmail.com
clear
echo "######################################################################"
echo "# Wordpress + MySql Database + Plugins                               #"
echo "# Alberto Iglesias (aigaliana@gmail.com)                             #"
echo "# July/2022                                                          #"
echo "######################################################################"
echo ""
echo "List of websites already created"
echo "--------------------------------"
ls -l /var/www/html | grep '^d'
echo ""
#echo "Please enter the NAME of the new wordpress website (example: wordpress1)"
#read wordpressname

wordpressname=$1;

dbname="db$wordpressname"
mysql -u root -p'Linux2022!MySql' -e "CREATE DATABASE $dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci";

unzip -qq -o /var/www/html/admin/package/wordpress.zip -d /var/www/html/${wordpressname}

chmod +777 -R /var/www/html/${wordpressname}

sed -i "s/@DATABASE@/$dbname/g" /var/www/html/${wordpressname}/wp-config.php

echo ""
echo "Your new website is available in: https://visualnet.ddns.me/$wordpressname"
echo ""