#!/bin/bash

###############################################################################
# Step 2: Find Which WordPress is scala4.com
# Run this on: OLD server
###############################################################################

echo "=========================================="
echo "Step 2: Finding scala4.com WordPress"
echo "=========================================="
echo ""

echo "Searching for scala4.com in Apache configs..."
echo ""

# Check Apache virtual hosts
echo "=== Apache Virtual Hosts ==="
grep -r "scala4.com" /etc/apache2/sites-available/ 2>/dev/null | head -20
echo ""

# List WordPress directories
echo "=== WordPress Directories ==="
echo "Checking /var/www/html/wordpress6/:"
ls -la /var/www/html/wordpress6/ 2>/dev/null | head -10
echo ""

echo "Checking /var/www/html/mainsite/:"
ls -la /var/www/html/mainsite/ 2>/dev/null | head -10
echo ""

# Check for wp-config.php files
echo "=== WordPress Config Files ==="
find /var/www/html -name "wp-config.php" 2>/dev/null
echo ""

# Check database names in wp-config.php
echo "=== Database Names ==="
for config in $(find /var/www/html -name "wp-config.php" 2>/dev/null); do
    echo "File: $config"
    grep "DB_NAME" "$config" | head -1
    echo ""
done

echo "=========================================="
echo "Step 2 Complete!"
echo "=========================================="
echo ""
echo "Look at the output above to find:"
echo "  1. Which directory contains scala4.com WordPress"
echo "  2. What the database name is"
echo ""
echo "Common locations:"
echo "  - /var/www/html/wordpress6/"
echo "  - /var/www/html/mainsite/"
echo ""
echo "Next: Go to Step 3 - Backup WordPress files"