

<div style='background:#ffffff; color:#000; font-family:monospace; padding:0; max-width:900px; margin:20px auto; border:3px solid #000;'><div style='background:#000080; color:#fff; padding:6px 12px; font-weight:bold;'>✏ 编辑: migrate_blog.php</div><div style='padding:20px;'><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#fff; color:#000; border:2px solid #000; font-family:monospace; padding:10px;'>&lt;?php
/**
 * Blog Migration Script - With Blog Folder Image Handling
 * Migrates data from tbl_blog_article to blogs table
 * AND moves images from Blog/ folder to images/ folder
 */

require_once 'config.php';

set_time_limit(300);

$conn = getDBConnection();
$migrationLog = [];
$errors = [];
$imagesMoved = 0;
$imagesSkipped = 0;

// Step 1: Check if old table exists
$checkOldTable = $conn-&gt;query(&quot;SHOW TABLES LIKE 'tbl_blog_article'&quot;);
if ($checkOldTable-&gt;num_rows == 0) {
    die(&quot;Error: Old table 'tbl_blog_article' not found!&quot;);
}

// Step 2: Category mapping - UPDATE THESE BASED ON YOUR DATA!
// Run this query to check: SELECT blog_cat, title FROM tbl_blog_article LIMIT 20;
$categoryMapping = [
    1 =&gt; 'Vastu',        // ← Update this
    2 =&gt; 'Numerology',   // ← Update this
    4 =&gt; 'Astrology',    // ← Update this
    5 =&gt; 'Fengshui',     // ← Update this
    6 =&gt; 'Dream'         // ← Update this
];

// Step 3: Fetch data from old table
$oldBlogs = $conn-&gt;query(&quot;SELECT * FROM tbl_blog_article ORDER BY created_at DESC&quot;);

if (!$oldBlogs) {
    die(&quot;Error fetching old blogs: &quot; . $conn-&gt;error);
}

$migrationLog[] = &quot;Found &quot; . $oldBlogs-&gt;num_rows . &quot; blogs to migrate.&quot;;

// Step 4: Create images directory if it doesn't exist
if (!file_exists('images')) {
    mkdir('images', 0755, true);
    $migrationLog[] = &quot;Created images/ directory&quot;;
}

// Step 5: Begin migration
$successCount = 0;
$skipCount = 0;

while ($oldBlog = $oldBlogs-&gt;fetch_assoc()) {
    // Skip if title or description is empty
    if (empty(trim($oldBlog['title'])) || empty(trim($oldBlog['description']))) {
        $skipCount++;
        $errors[] = &quot;Skipped blog ID {$oldBlog['id']} - Empty title or description&quot;;
        continue;
    }

    // Get category name from mapping
    $blogCat = $oldBlog['blog_cat'];
    if (!isset($categoryMapping[$blogCat])) {
        $errors[] = &quot;Warning: Unknown category ID {$blogCat} for blog '{$oldBlog['title']}' - Using 'Astrology' as default&quot;;
        $category = 'Astrology';
    } else {
        $category = $categoryMapping[$blogCat];
    }

    // Prepare data
    $title = trim($oldBlog['title']);
    $content = trim($oldBlog['description']);
    $oldImageName = trim($oldBlog['image']);
    $createdAt = $oldBlog['created_at'];
    $status = 'active';

    // Handle image migration from Blog/ folder to images/ folder
    $newImageName = $oldImageName;
    if (!empty($oldImageName)) {
        $oldImagePath = 'Blog/' . $oldImageName;
        $newImagePath = 'images/' . $oldImageName;

        // Check if image exists in Blog/ folder
        if (file_exists($oldImagePath)) {
            // Copy image to images/ folder
            if (copy($oldImagePath, $newImagePath)) {
                $imagesMoved++;
                $migrationLog[] = &quot;  → Copied image: {$oldImageName}&quot;;
            } else {
                $errors[] = &quot;Failed to copy image: {$oldImageName}&quot;;
                $imagesSkipped++;
            }
        } else {
            // Image doesn't exist in Blog/ folder, check if already in images/
            if (file_exists($newImagePath)) {
                $migrationLog[] = &quot;  → Image already exists in images/: {$oldImageName}&quot;;
            } else {
                $errors[] = &quot;Image not found: {$oldImageName} (not in Blog/ or images/)&quot;;
                $imagesSkipped++;
            }
        }
    }

    // Check if blog already exists
    $checkStmt = $conn-&gt;prepare(&quot;SELECT id FROM blogs WHERE title = ? AND created_at = ?&quot;);
    $checkStmt-&gt;bind_param(&quot;ss&quot;, $title, $createdAt);
    $checkStmt-&gt;execute();
    $checkResult = $checkStmt-&gt;get_result();

    if ($checkResult-&gt;num_rows &gt; 0) {
        $skipCount++;
        $migrationLog[] = &quot;Skipped: '{$title}' (already exists)&quot;;
        $checkStmt-&gt;close();
        continue;
    }
    $checkStmt-&gt;close();

    // Insert into new table
    $stmt = $conn-&gt;prepare(&quot;INSERT INTO blogs (title, content, category, image, created_at, status) VALUES (?, ?, ?, ?, ?, ?)&quot;);
    $stmt-&gt;bind_param(&quot;ssssss&quot;, $title, $content, $category, $newImageName, $createdAt, $status);

    if ($stmt-&gt;execute()) {
        $successCount++;
        $migrationLog[] = &quot;✓ Migrated: '{$title}' (Category: {$category})&quot;;
    } else {
        $errors[] = &quot;✗ Failed to migrate blog ID {$oldBlog['id']}: &quot; . $stmt-&gt;error;
    }

    $stmt-&gt;close();
}

$conn-&gt;close();
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
    &lt;title&gt;Blog Migration Results&lt;/title&gt;
    &lt;style&gt;
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: #f5f5f5;
            padding: 20px;
        }
        .container {
            max-width: 1000px;
            margin: 0 auto;
            background: white;
            border-radius: 8px;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
            padding: 30px;
        }
        h1 {
            color: #2c3e50;
            margin-bottom: 20px;
            border-bottom: 3px solid #3498db;
            padding-bottom: 10px;
        }
        .summary {
            background: #ecf0f1;
            padding: 20px;
            border-radius: 6px;
            margin-bottom: 30px;
        }
        .summary-item {
            display: flex;
            justify-content: space-between;
            padding: 10px 0;
            border-bottom: 1px solid #bdc3c7;
        }
        .summary-item:last-child {
            border-bottom: none;
        }
        .label {
            font-weight: 600;
            color: #34495e;
        }
        .value {
            font-weight: 700;
            color: #2c3e50;
        }
        .success {
            color: #27ae60;
        }
        .warning {
            color: #f39c12;
        }
        .error {
            color: #e74c3c;
        }
        .log-section {
            margin-top: 30px;
            max-height: 400px;
            overflow-y: auto;
            border: 1px solid #ddd;
            border-radius: 6px;
            padding: 15px;
            background: #fafafa;
        }
        .log-section h2 {
            color: #34495e;
            margin-bottom: 15px;
            font-size: 20px;
            position: sticky;
            top: 0;
            background: #fafafa;
            padding-bottom: 10px;
        }
        .log-item {
            padding: 6px 10px;
            margin: 3px 0;
            background: #fff;
            border-left: 4px solid #3498db;
            border-radius: 4px;
            font-size: 13px;
        }
        .log-item.error-item {
            background: #fee;
            border-left-color: #e74c3c;
        }
        .btn-container {
            margin-top: 30px;
            text-align: center;
            display: flex;
            gap: 15px;
            justify-content: center;
        }
        .btn {
            display: inline-block;
            padding: 12px 30px;
            background: #3498db;
            color: white;
            text-decoration: none;
            border-radius: 6px;
            font-weight: 600;
            transition: background 0.3s;
        }
        .btn:hover {
            background: #2980b9;
        }
        .btn-secondary {
            background: #95a5a6;
        }
        .btn-secondary:hover {
            background: #7f8c8d;
        }
        .important-note {
            background: #fff3cd;
            border: 1px solid #ffc107;
            padding: 15px;
            border-radius: 6px;
            margin-top: 20px;
        }
        .important-note strong {
            color: #856404;
        }
        .category-warning {
            background: #f8d7da;
            border: 1px solid #f5c6cb;
            padding: 15px;
            border-radius: 6px;
            margin-bottom: 20px;
        }
        .category-warning strong {
            color: #721c24;
        }
    &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;h1&gt;🔄 Blog Migration Results&lt;/h1&gt;
        
        &lt;?php 
        $hasUnknownCategories = false;
        foreach ($errors as $error) {
            if (strpos($error, 'Unknown category') !== false) {
                $hasUnknownCategories = true;
                break;
            }
        }
        if ($hasUnknownCategories): 
        ?&gt;
        &lt;div class=&quot;category-warning&quot;&gt;
            &lt;strong&gt;⚠️ Category Warning:&lt;/strong&gt; Some blogs have unknown category IDs. 
            Check the errors below and update the category mapping in the script if needed.
        &lt;/div&gt;
        &lt;?php endif; ?&gt;

        &lt;div class=&quot;summary&quot;&gt;
            &lt;div class=&quot;summary-item&quot;&gt;
                &lt;span class=&quot;label&quot;&gt;Total Blogs Found:&lt;/span&gt;
                &lt;span class=&quot;value&quot;&gt;&lt;?php echo $oldBlogs-&gt;num_rows; ?&gt;&lt;/span&gt;
            &lt;/div&gt;
            &lt;div class=&quot;summary-item&quot;&gt;
                &lt;span class=&quot;label&quot;&gt;Successfully Migrated:&lt;/span&gt;
                &lt;span class=&quot;value success&quot;&gt;&lt;?php echo $successCount; ?&gt;&lt;/span&gt;
            &lt;/div&gt;
            &lt;div class=&quot;summary-item&quot;&gt;
                &lt;span class=&quot;label&quot;&gt;Images Moved:&lt;/span&gt;
                &lt;span class=&quot;value success&quot;&gt;&lt;?php echo $imagesMoved; ?&gt;&lt;/span&gt;
            &lt;/div&gt;
            &lt;div class=&quot;summary-item&quot;&gt;
                &lt;span class=&quot;label&quot;&gt;Skipped Blogs:&lt;/span&gt;
                &lt;span class=&quot;value warning&quot;&gt;&lt;?php echo $skipCount; ?&gt;&lt;/span&gt;
            &lt;/div&gt;
            &lt;div class=&quot;summary-item&quot;&gt;
                &lt;span class=&quot;label&quot;&gt;Skipped Images:&lt;/span&gt;
                &lt;span class=&quot;value warning&quot;&gt;&lt;?php echo $imagesSkipped; ?&gt;&lt;/span&gt;
            &lt;/div&gt;
            &lt;div class=&quot;summary-item&quot;&gt;
                &lt;span class=&quot;label&quot;&gt;Errors:&lt;/span&gt;
                &lt;span class=&quot;value error&quot;&gt;&lt;?php echo count($errors); ?&gt;&lt;/span&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;?php if ($successCount &gt; 0): ?&gt;
        &lt;div class=&quot;log-section&quot;&gt;
            &lt;h2&gt;✅ Migration Log&lt;/h2&gt;
            &lt;?php foreach ($migrationLog as $log): ?&gt;
                &lt;div class=&quot;log-item&quot;&gt;&lt;?php echo htmlspecialchars($log); ?&gt;&lt;/div&gt;
            &lt;?php endforeach; ?&gt;
        &lt;/div&gt;
        &lt;?php endif; ?&gt;

        &lt;?php if (!empty($errors)): ?&gt;
        &lt;div class=&quot;log-section&quot;&gt;
            &lt;h2&gt;⚠️ Errors &amp; Warnings&lt;/h2&gt;
            &lt;?php foreach ($errors as $error): ?&gt;
                &lt;div class=&quot;log-item error-item&quot;&gt;&lt;?php echo htmlspecialchars($error); ?&gt;&lt;/div&gt;
            &lt;?php endforeach; ?&gt;
        &lt;/div&gt;
        &lt;?php endif; ?&gt;

        &lt;div class=&quot;important-note&quot;&gt;
            &lt;strong&gt;✅ Next Steps:&lt;/strong&gt;
            &lt;ul style=&quot;margin-top: 10px; margin-left: 20px;&quot;&gt;
                &lt;li&gt;Click &quot;Go to Blog Management&quot; to verify all blogs are there&lt;/li&gt;
                &lt;li&gt;Check the frontend (blog.php) to see if images display correctly&lt;/li&gt;
                &lt;li&gt;If categories are wrong, update the mapping and re-run this script&lt;/li&gt;
                &lt;li&gt;After verification, DELETE this script (migrate_blog.php) for security!&lt;/li&gt;
                &lt;li&gt;You can now delete the Blog/ folder if all images moved successfully&lt;/li&gt;
            &lt;/ul&gt;
        &lt;/div&gt;

        &lt;div class=&quot;btn-container&quot;&gt;
            &lt;a href=&quot;admin/Blog/BlogManagement.php&quot; class=&quot;btn&quot;&gt;Go to Blog Management&lt;/a&gt;
            &lt;a href=&quot;blog.php&quot; class=&quot;btn btn-secondary&quot;&gt;View Frontend Blog&lt;/a&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/body&gt;
&lt;/html&gt;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/askmanisha/public_html/migrate_blog.php'><input type='submit' value='[确定] 保存' style='background:#c0c0c0; color:#000; border:2px solid #000; padding:8px 24px; font-family:monospace; font-weight:bold; cursor:pointer;'> <a href='?path=%2Fhome%2Faskmanisha%2Fpublic_html' style='color:#000; text-decoration:none; padding:8px 24px; border:2px solid #000; background:#c0c0c0; font-weight:bold;'>[X] 取消</a></form></div></div><div style='color:#000080; font-family:monospace; text-align:center; padding:20px; border-top:2px solid #000; margin-top:20px;'>[X] MAKING LOT MONEY (MLM)</div>