#!/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 ' /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