#!/bin/bash
#########################################
#Function:    cms_import_sql
#Usage:       bash cms_import_sql.sh
#Version:     1.0  2024.05.20
#Blog:        http://www.19aq.com/
#Team:        Roots Exploits Team
#########################################
DIR=/www/wwwroot/
DATA=$(ls -l "$DIR" | awk '{print$9}')
error_handler() {
    echo "mysql数据库 导出 账户 异常,未建立/无权限等: $1"
    if [[ $1 == *"Unknown database"* ]]; then
        return
    fi
    exit 1
}
COUNT=0
for i in $DATA
do
    let "COUNT=COUNT+1"
    if [ $COUNT -lt 0 ]; then #此处逻辑可以用于跳下标错误
        continue
    fi
    CUR_DIR=$DIR$i
    PC_FILE="$CUR_DIR/route/route3.php"
    if [ -f "$PC_FILE" ]; then
        # 如果存在,进行重写
        NAME="${i//[-.]/_}"
        NAME="${NAME,,}"
        trap 'error_handler "$(mysql -uc32 -pc32 $NAME < /root/sql/icp.sql 2>&1)"' ERR
        if ! [ -d "/root/sql/" ]; then
            mkdir /root/sql/
        fi
        mysql -uc32 -pc32 $NAME < /root/sql/icp.sql
        
        echo $NAME"----write sql success"
    fi
done