#!/bin/bash

###############################################################################
# Step 5: Setup Ninanolte on NEW Server
# Run this on: NEW server (vps2.scala4.com)
###############################################################################

set -e

echo "=========================================="
echo "Step 5: Setting up Ninanolte on NEW Server"
echo "=========================================="
echo ""

# Check if running as root
if [ "$EUID" -ne 0 ]; then 
    echo "ERROR: Please run as root (use sudo)"
    exit 1
fi

DATE=$(date +%Y%m%d)
WORDPRESS_DIR="/var/www/html/ninanolte/wordpress"
DATABASE_NAME="nina"
BACKUP_FILE="/backup/applications/ninanolte-${DATE}.tar.gz"
DB_BACKUP="/backup/databases/nina-${DATE}.sql"

echo "WordPress Directory: $WORDPRESS_DIR"
echo "Database: $DATABASE_NAME"
echo ""

# Check if backups exist
if [ ! -f "$BACKUP_FILE" ]; then
    echo "ERROR: Backup file not found: $BACKUP_FILE"
    echo "Please copy the backup file first"
    exit 1
fi

if [ ! -f "$DB_BACKUP" ]; then
    echo "ERROR: Database backup not found: $DB_BACKUP"
    echo "Please copy the database backup first"
    exit 1
fi

# Step 1: Extract WordPress files
echo "Step 1: Extracting WordPress files..."
mkdir -p /var/www/html/ninanolte
cd /backup/applications
tar -xzf "$BACKUP_FILE" -C /var/www/html/
if [ $? -eq 0 ]; then
    echo "✓ Files extracted to /var/www/html/ninanolte/"
else
    echo "✗ ERROR: Extraction failed"
    exit 1
fi

# Step 2: Set permissions
echo ""
echo "Step 2: Setting file permissions..."
chown -R www-data:www-data "$WORDPRESS_DIR"
chmod -R 755 "$WORDPRESS_DIR"
echo "✓ Permissions set"

# Step 3: Create database
echo ""
echo "Step 3: Creating database..."
mysql -u root -e "CREATE DATABASE IF NOT EXISTS $DATABASE_NAME CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
if [ $? -eq 0 ]; then
    echo "✓ Database created"
else
    echo "✗ ERROR: Database creation failed"
    exit 1
fi

# Step 4: Create database user
echo ""
echo "Step 4: Creating database user..."
DB_PASSWORD="SunnySummer2022!"
mysql -u root -e "CREATE USER IF NOT EXISTS 'nina'@'localhost' IDENTIFIED BY '$DB_PASSWORD';"
mysql -u root -e "GRANT ALL PRIVILEGES ON $DATABASE_NAME.* TO 'nina'@'localhost';"
mysql -u root -e "FLUSH PRIVILEGES;"
echo "✓ Database user created"

# Step 5: Import database
echo ""
echo "Step 5: Importing database..."
mysql -u root "$DATABASE_NAME" < "$DB_BACKUP"
if [ $? -eq 0 ]; then
    echo "✓ Database imported"
else
    echo "✗ ERROR: Database import failed"
    exit 1
fi

# Step 6: Update wp-config.php
echo ""
echo "Step 6: Checking wp-config.php..."
if [ -f "$WORDPRESS_DIR/wp-config.php" ]; then
    echo "✓ wp-config.php exists"
    echo "  Database: $DATABASE_NAME"
    echo "  User: nina"
    echo ""
    echo "NOTE: You may need to update wp-config.php with:"
    echo "  - Database host (if different)"
    echo "  - Database password (already set: SunnySummer2022!)"
    echo "  - Site URL (if domain changed)"
else
    echo "⚠ WARNING: wp-config.php not found"
fi

echo ""
echo "=========================================="
echo "Step 5 Complete!"
echo "=========================================="
echo ""
echo "Next steps:"
echo "1. Create Apache virtual host for ninanolte.com"
echo "2. Update wp-config.php if needed"
echo "3. Test the site"
echo ""
echo "WordPress location: $WORDPRESS_DIR"
echo "Database: $DATABASE_NAME"
echo "Database user: nina"