#!/bin/bash
echo "=== WordPress 用户扫描 ==="
for config in /www/wwwroot/*/wp-config.php; do
    if [ -f "$config" ]; then
        dir=$(dirname "$config")
        site=$(basename "$dir")
        
        db_name=$(grep "DB_NAME" "$config" | cut -d "'" -f 4)
        db_user=$(grep "DB_USER" "$config" | cut -d "'" -f 4)
        db_pass=$(grep "DB_PASSWORD" "$config" | cut -d "'" -f 4)
        
        if [ -n "$db_name" ]; then
            echo ""
            echo "站点: $site"
            mysql -u"$db_user" -p"$db_pass" "$db_name" -e "SELECT ID, user_login, user_email, user_registered FROM wp_users WHERE user_registered > '2026-02-01' ORDER BY user_registered DESC LIMIT 5;" 2>/dev/null
        fi
    fi
done