#!/bin/bash

#################################################################
###     bash <(curl -fsSL https://raw.lhy.life/discard/phpmyadmin.sh)  
#################################################################

#install phpMyAdmin
apt install curl zip

version=$(curl https://www.phpmyadmin.net/home_page/version.txt)
IFS=$'\n'
array=($version)
version=${array[0]}

wget https://files.phpmyadmin.net/phpMyAdmin/$version/phpMyAdmin-$version-all-languages.zip
unzip phpMyAdmin-$version-all-languages.zip
mkdir -p /etc/nginx/webroot/phpMyAdmin/
mv phpMyAdmin-$version-all-languages/* /etc/nginx/webroot/phpMyAdmin

rm -rf phpMyAdmin-$version-all-languages.zip phpMyAdmin-$version-all-languages

mkdir -p /etc/nginx/webroot/phpMyAdmin/tmp
chmod 777 /etc/nginx/webroot/phpMyAdmin/tmp

#Allow login to arbitrary servers
cat << 'EOF' > /etc/nginx/webroot/phpMyAdmin/config.inc.php
<?php
$cfg['AllowArbitraryServer'] = true;
EOF

#set phpMyAdmin nginx conf
cat << 'EOF' > /etc/nginx/conf.d/phpMyAdmin.conf
## server {
##     listen 80;
##     listen [::]:80;
##     server_name mqsql.exp.com;
##     return 301 https://mqsql.exp.com$request_uri;
## }
server {
    listen 8084;## ssl http2 proxy_protocol;## 
    server_name mqsql.exp.com;
    index index.html index.php;
    root /etc/nginx/webroot/phpMyAdmin;

    ## set_real_ip_from 127.0.0.1;
    ## real_ip_header proxy_protocol;

    ## ssl_certificate /etc/nginx/cert/mqsql.exp.com/cert.pem;
    ## ssl_certificate_key /etc/nginx/cert/mqsql.exp.com/key.pem;
    ## ssl_session_timeout 1d;
    ## ssl_session_cache shared:MozSSL:10m;
    ## ssl_session_tickets off;
    ## ssl_protocols TLSv1.2 TLSv1.3;
    ## ssl_ciphers ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384;
    ## ssl_prefer_server_ciphers off;

    include enable-php.conf;

    location ~ ^/(\.user.ini|\.htaccess|\.git|\.svn|\.project|LICENSE|README.md) {
        return 404;
    }

    location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$ {
        expires 5d;
        error_log off;
    }

    location ~ .*\.(js|css)?$ {
        expires 12h;
        error_log off;
    }

    location = /favicon.ico {
        access_log off;
        log_not_found off;
    }

    location = /robots.txt {
        access_log off;
        log_not_found off;
    }

    ## access_log /etc/nginx/logs/mqsql.exp.com.log;
    error_log /etc/nginx/logs/mqsql.exp.com.error.log;
}
EOF
nginx -t