#!/bin/bash
URL='172.105.3.13'
echo ""
clear
echo -e "\033[1;31m INSTALANDO PAINEL CSPADMIN + MARIADB GHOSTCS UBUNTU 20.4. \033[0m"
echo -e "\033[1;31m AGUARDE A INSTALAÇÃO É DEMORADA! \033[0m"
apt-get update -y > /dev/null
sleep 1s
apt-get install -y software-properties-common > /dev/null
sleep 1s
echo -e "\033[1;31m APERTE ENTER PARA COMEÇAR INSTALAR. \033[0m"
add-apt-repository ppa:nginx/stable > /dev/null
LC_ALL=C.UTF-8 add-apt-repository ppa:ondrej/php
apt-get update > /dev/null
echo -e "\033[1;31m AGUARDE..... \033[0m"
apt-get install -y curl iputils-ping nginx unzip memcached php7.0-fpm php7.0-cli php7.0-gd php7.0-mcrypt php7.0-mysql php7.0-zip php7.0-mbstring php7.0-curl php7.0-pdo-mysql php7.0-sockets php7.0-fileinfo php7.0-exif php7.0-opcache php7.0-xml php7.0-intl php-memcache
apt-get clean && rm -rf /var/lib/apt/lists/* >> /dev/null 2>&1
apt-get install -y tzdata && mkdir -p /var/run/php && usermod -u 1000 www-data && chown -R www-data:www-data /usr/share/nginx/html
sleep 1s
echo America/Sao_Paulo > /etc/timezone && rm /etc/localtime && ln -snf /usr/share/zoneinfo/America/Sao_Paulo /etc/localtime
sleep 1s
echo -e "\033[1;31m AGUARDE........ \033[0m"
cd /etc/php/7.0/fpm/conf.d 
sleep 1s
rm custom.ini
sleep 1s
wget  http://$URL/csp/conf/custom.zip
unzip custom.zip
rm custom.zip
sleep 1s
cd /etc/php/7.0/fpm/pool.d
sleep 1s
rm custom.pool.conf
echo -e "\033[1;31m AGUARDE............... \033[0m"
sleep 1s
wget http://$URL/csp/conf/custom.pool.zip
unzip custom.pool.zip
rm custom.pool.zip
sleep 1s
cd /etc/nginx
sleep 1s
rm nginx.conf
echo -e "\033[1;31m AGUARDE.................... \033[0m"
sleep 1s
wget http://$URL/csp/conf/nginx2.zip
unzip nginx2.zip
rm nginx2.zip
sleep 1s
cd /usr/share/nginx/html
rm -f /usr/share/nginx/html/index.html
sleep 1s
wget http://$URL/csp/wget/painel2.7.zip
sleep 1s
unzip painel2.7.zip
rm painel2.7.zip
sleep 1s
chown -R www-data /usr/share/nginx/html/
cd /root
printf '%s\n' '#!/bin/bash' 'exit 0' | sudo tee -a /etc/rc.local
sed --in-place '/exit 0/d' /etc/rc.local
echo "sleep 1" >> /etc/rc.local
echo "/etc/init.d/php7.0-fpm stop" >> /etc/rc.local
echo "sleep 5" >> /etc/rc.local
echo "/usr/sbin/php-fpm7.0 & nginx" >> /etc/rc.local
echo "exit 0" >> /etc/rc.local
systemctl enable rc-local
cd /etc/systemd/system
echo -e "\033[1;31m Caso o arquivo rc.local.service já existir ele perguntara se quer substituir coloque a letra n e aperte enter. \033[0m"
wget http://$URL/csp/conf/rc-local.zip
unzip rc-local.zip 
rm rc-local.zip
chmod +x /etc/systemd/system/rc-local.service
chmod +x /etc/rc.local
systemctl enable rc-local
cd /root
sleep 1s
echo -e "\033[1;31m AGUARDE............................ \033[0m"
#apt -y install software-properties-common dirmngr apt-transport-https
#apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sleep 1s
#add-apt-repository 'deb [arch=amd64] http://mirror.zol.co.zw/mariadb/repo/10.3/ubuntu xenial main'
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-10.3"
apt update
sleep 1s
apt -y install mariadb-server mariadb-client 
sleep 1s
echo -e "\033[1;31m Digite sua senha do mysql. \033[0m" ; read senha
mysql -u root -p$senha  mysql -e "GRANT ALL ON *.* TO 'admin'@'%' IDENTIFIED BY '$senha' WITH GRANT OPTION; FLUSH PRIVILEGES;"
mysql -u root -p$senha -e "DROP DATABASE IF EXISTS painel_acessos; CREATE DATABASE IF NOT EXISTS painel_acessos;"
mysql -u root -p$senha -e "DROP DATABASE IF EXISTS painel_geral; CREATE DATABASE IF NOT EXISTS painel_geral;"
mysql -u root -p$senha -e "DROP DATABASE IF EXISTS painel_user; CREATE DATABASE IF NOT EXISTS painel_user;"
mysql -u root -p$senha painel_acessos < /usr/share/nginx/html/db/banco_acessos.sql
mysql -u root -p$senha painel_geral < /usr/share/nginx/html/db/banco_geral.sql
mysql -u root -p$senha painel_user < /usr/share/nginx/html/db/banco_user.sql
mysql -u root -p$senha painel_acessos < /usr/share/nginx/html/db/Atualizacao_Acesso.sql
mysql -u root -p$senha painel_geral < /usr/share/nginx/html/db/Atualizacao_Geral.sql
mysql -u root -p$senha painel_user < /usr/share/nginx/html/db/Atualizacao_User.sql
sed -i "/senha/ s/123456/$senha/" /usr/share/nginx/html/DadosServidor.php
sleep 1s
sed -i "/bind-address/ s/127.0.0.1/0.0.0.0/" /etc/mysql/my.cnf
sleep 1s
/etc/init.d/mysql restart
chown -R www-data /usr/share/nginx/html/

echo "* * * * * root curl --request GET 'http://gerencia.xevolution.pro/crontab.php' >/dev/null 2>&1" >> /etc/crontab
echo "#*/5 * * * * root sh /opt/checkstatus5.sh >/dev/null 2>&1" >> /etc/crontab
echo "#00 * * * * root sh /opt/uploadbackup.sh >/dev/null 2>&1" >> /etc/crontab
echo "#05 * * * * root sh /opt/limparmemoria.sh" >> /etc/crontab

echo -e "\033[1;31m Instalação do Painel e MYSQL Concluido. \033[0m"
echo -e "\033[1;31m Usuario: admin \033[0m"
echo -e "\033[1;31m Senha: admin \033[0m"
echo -e "\033[1;31m A maquina foi reiniciada quando voltar já estara tudo online! \033[0m"
rm installpainel	
reboot