#!/bin/bash
PATH=/sbin:/usr/sbin:/bin:/usr/bin
: ${DIALOG=dialog}
#################### CREATE DATABASE
clear
if [ -d "/var/lib/mysql/web" ]; then
     echo "注意 !! Web 的資料庫己存在"
     read WAIT
     find /root/.bash_profile -type f -exec perl -i -pe s/databas.sh/clear/g {} \;
else
#########變數設定
DAUSER=""
DAPASSWD=""
exec 3>&1
USERDATE=`$DIALOG --title "Web 資料庫" --inputbox "請輸入使用者帳號 \n預設為(webadmin)" 0 0 2>&1 1>&3`
code=$?
exec 3>&-

case $code in
  0)
    DAUSER=$USERDATE;;
  1)
   DAUSER="webadmin";;
  255)
   DAUSER="webadmin";;
esac
exec 3>&1
PASSDATE=`$DIALOG --title "Web 資料庫" --insecure \
	--passwordbox "請輸入使用者密碼 \n預設為(superuser)" 0 0 2>&1 1>&3`
code=$?
exec 3>&-

case $code in
  0)
   DAPASSWD=$PASSDATE;;
  1)
   DAPASSWD="superuser";;
  255)
   DAPASSWD="superuser";;
esac
clear
echo ""
printf "[Web 資料名稱為] = %s$DAUSER%s" `echo -en "\\033[1;32m"` `echo -en "\\033[0;39m"`
echo ""
printf "\n[Web 資料密碼為] = %s$DAPASSWD%s" `echo -en "\\033[1;32m"` `echo -en "\\033[0;39m"`
echo ""

###################產生/var/www/html/program/commonsetup.php
echo '<?php' > /var/www/html/program/commonsetup.php
echo '//整合程式共用！ ' >> /var/www/html/program/commonsetup.php
echo 'include "DBClass.php";			//勿更動！' >> /var/www/html/program/commonsetup.php
echo '$objDB=new DBClass;' >> /var/www/html/program/commonsetup.php
echo '$objDB->server="localhost";		//資料庫主機名稱' >> /var/www/html/program/commonsetup.php
echo '$objDB->stduser='\"$DAUSER\"';		//資料庫使用者名稱' >> /var/www/html/program/commonsetup.php
echo '$objDB->stdpass='\"$DAPASSWD\"';		//資料庫使用者密碼' >> /var/www/html/program/commonsetup.php
echo '$objDB->db="web"; 			//資料庫名稱' >> /var/www/html/program/commonsetup.php
echo '$ADMIN='\"$DAUSER\"';			//管理員帳號' >> /var/www/html/program/commonsetup.php
echo '$PASSWORD='\"$DAPASSWD\"';		//管理員密碼' >> /var/www/html/program/commonsetup.php
echo '?>' >> /var/www/html/program/commonsetup.php
echo ""
echo "建立 Web 資料庫中,請稍候............................."
echo ""
echo "建立完成 ,請按任一建繼續............................."
read WAIT
      command="mysql -u root  -psuperuser"
      (echo "create database web;"; echo "grant all on web.* to '$DAUSER'@localhost identified by '$DAPASSWD';"; echo "use web;"; cat /etc/X11/web.sql) |$command
      find /root/.bash_profile -type f -exec perl -i -pe s/databas.sh/clear/g {} \;
fi