#!/bin/bash
echo "=== 开始清理恶意用户 ==="

# 1. 删除 joyrun.cn 的 SEO 垃圾账户
echo ""
echo "【1/2】清理 joyrun.cn (40,979 个账户)..."
mysql -uzhuoyuns -p'zhuo2019yun18' zhuoyuns -e "DELETE FROM wp_users WHERE user_login LIKE '%blogspot%' AND user_registered > '2026-02-01';" 2>/dev/null
mysql -uzhuoyuns -p'zhuo2019yun18' zhuoyuns -e "DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users);" 2>/dev/null
echo "✓ joyrun.cn 清理完成"

# 2. 删除 topcheersoftware.com 的恶意管理员
echo ""
echo "【2/2】清理 topcheersoftware.com (adminbackup)..."
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)

mysql -u"$db_user" -p"$db_pass" "$db_name" -e "DELETE FROM wp_users WHERE ID = 2;" 2>/dev/null
mysql -u"$db_user" -p"$db_pass" "$db_name" -e "DELETE FROM wp_usermeta WHERE user_id = 2;" 2>/dev/null
echo "✓ topcheersoftware.com 清理完成"

echo ""
echo "=== 清理完成 ==="