#!/bin/bash
echo "=== 恶意用户统计 ==="

# joyrun.cn
config="/www/wwwroot/joyrun.cn/wp-config.php"
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)

echo ""
echo "【joyrun.cn】"
echo "SEO 垃圾账户（blogspot 模式）:"
mysql -u"$db_user" -p"$db_pass" "$db_name" -e "SELECT COUNT(*) as count FROM wp_users WHERE user_login LIKE '%blogspot%' AND user_registered > '2026-02-01';" 2>/dev/null

# topcheersoftware.com
config="/www/wwwroot/topcheersoftware.com/wp-config.php"
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)

echo ""
echo "【topcheersoftware.com】"
echo "恶意管理员账户:"
mysql -u"$db_user" -p"$db_pass" "$db_name" -e "SELECT ID, user_login, user_email, user_registered FROM wp_users WHERE user_login LIKE '%admin%' AND user_registered > '2026-02-01';" 2>/dev/null