#!/bin/sh
info="Webspace einrichten mit php8 apache2 mariadb"
echocol 1 "$info\n"
export LANGUAGE='C'
export LC_ALL='C'
go_xampp8
go_mariadb
if [ "$1" == "" ]; then 
	echocol 2 "Call this Script with webspacename\n"
	echocol 1 "go_wordpress webspacename\n";
	exit
fi
if [ -e /var/www/ ]; then 
	cd /var/www
else
	cd /usr/local/apache2/htdocs
fi
if [ ! -e /usr/local/bin/curl ] ; then
	tce-load -iw curl
fi
echocol 3 "Lege Webspace fuer Wordpress an: "; echocol 2 "$1\n"
myip=$(myip)
echocol 3 "http://$myip/$1\n"
mkdir $1
cd $1
echocol 3 "Hole latest Version von WordPress.org\n"
curl -d .  https://de.wordpress.org/latest-de_DE.tar.gz --output wordpress.tar.gz
echocol 3 "Entpacke Wordpress\n"
tar -xf wordpress.tar.gz
mv wordpress/* -t .
echocol 3 "Listing /var/www/"; echocol 2 "$1\n"
ls -la
echocol 3 "Erzeuge SQL-Script fuer WP-Datenbank-USER\n"
sqlpw=$(pwgen 8 1)
cat <<EOSQL >/home/tc/create_user.sql
CREATE DATABASE bank_db_$1;
CREATE USER 'db_$1'@'localhost' IDENTIFIED BY '$sqlpw';
GRANT ALL PRIVILEGES ON bank_db_$1.* TO db_$1@localhost;
FLUSH PRIVILEGES;
SHOW DATABASES;
SELECT User,Host,Password FROM mysql.user;
SELECT Host,Db,User       FROM mysql.db;
EOSQL
mysql </home/tc/create_user.sql
echocol 3 "Navigate now to "; echocol 2 "http://$myip/$1\n"
echocol 3 "Datenbank-Name: "; echocol 2 "bank_db_$1\n"
echocol 3 "Datenbank-User: "; echocol 2 "db_$1\n"
echocol 3 "Datenbank-Pass: "; echocol 2 "$sqlpw\n"
echocol 3 "Datenbank-Serv: "; echocol 2 "localhost\n"