#!/bin/bash
#
# Desired domain
echo Insert desired domain
read domain

# Random password for SQL
randompw=$(tr -cd '[:alnum:]' < /dev/urandom | fold -w10 | head -n1)

# Mysql settings
Dotfix=$(echo "$domain"|sed 's/\./_/g')
Dotfixdb=$(echo "$Dotfix"|sed 's/\-/_/g')
MyUSER="****HIDDEN****"
MyPASS="****HIDDEN****"
MyHOST="localhost"
MyCONNECT="mysql -u $MyUSER -h $MyHOST -p$MyPASS"
MyCONPASS="mysql $Dotfixdb -u $MyUSER -h $MyHOST -p$MyPASS"

# Adding FTP account in mysql
MyCONFTP="mysql vsftpd -u $MyUSER -h $MyHOST -p$MyPASS"
$MyCONFTP -e 'INSERT INTO accounts (id, username, pass) VALUES (NULL, '$domain', PASSWORD("'$randompw'"))'

# Info
echo
echo
echo
echo
echo FTP User: $domain
echo FTP Pass: $randompw
echo
echo
echo
echo