🔧 إصلاح جداول المنشورات
";
$errors = [];
$success = [];
try {
// 1. تحديث جدول posts القديم
echo "
1️⃣ تحديث جدول posts...
";
// فحص الأعمدة الموجودة
$columns = $conn->query("SHOW COLUMNS FROM posts")->fetchAll(PDO::FETCH_COLUMN);
// إضافة الأعمدة الناقصة (فحص قبل الإضافة)
$new_columns = [
'title' => "ALTER TABLE posts ADD COLUMN title VARCHAR(255) AFTER id",
'slug' => "ALTER TABLE posts ADD COLUMN slug VARCHAR(255) AFTER title",
'excerpt' => "ALTER TABLE posts ADD COLUMN excerpt TEXT AFTER slug",
'content' => "ALTER TABLE posts ADD COLUMN content LONGTEXT AFTER excerpt",
'featured_image' => "ALTER TABLE posts ADD COLUMN featured_image VARCHAR(255) AFTER content",
'author_id' => "ALTER TABLE posts ADD COLUMN author_id INT AFTER featured_image",
'category' => "ALTER TABLE posts ADD COLUMN category VARCHAR(100) AFTER author_id",
'tags' => "ALTER TABLE posts ADD COLUMN tags VARCHAR(255) AFTER category",
'status' => "ALTER TABLE posts ADD COLUMN status ENUM('draft', 'published', 'scheduled') DEFAULT 'draft' AFTER tags",
'is_featured' => "ALTER TABLE posts ADD COLUMN is_featured TINYINT(1) DEFAULT 0 AFTER status",
'views_count' => "ALTER TABLE posts ADD COLUMN views_count INT DEFAULT 0 AFTER is_featured",
'likes_count' => "ALTER TABLE posts ADD COLUMN likes_count INT DEFAULT 0 AFTER views_count",
'comments_count' => "ALTER TABLE posts ADD COLUMN comments_count INT DEFAULT 0 AFTER likes_count",
'published_at' => "ALTER TABLE posts ADD COLUMN published_at DATETIME AFTER comments_count"
];
foreach ($new_columns as $col_name => $sql) {
if (!in_array($col_name, $columns)) {
try {
$conn->exec($sql);
echo "
✅ تم إضافة عمود: $col_name
";
} catch (Exception $e) {
echo "
❌ خطأ في إضافة $col_name: " . $e->getMessage() . "
";
}
}
}
// نقل البيانات القديمة (بعد إضافة الأعمدة)
try {
$conn->exec("UPDATE posts SET content = caption WHERE content IS NULL OR content = ''");
} catch (Exception $e) {}
try {
$conn->exec("UPDATE posts SET title = SUBSTRING(caption, 1, 100) WHERE title IS NULL OR title = ''");
} catch (Exception $e) {}
try {
$conn->exec("UPDATE posts SET slug = CONCAT('post-', id) WHERE slug IS NULL OR slug = ''");
} catch (Exception $e) {}
try {
$conn->exec("UPDATE posts SET status = 'published' WHERE status IS NULL");
} catch (Exception $e) {}
try {
$conn->exec("UPDATE posts SET featured_image = image WHERE featured_image IS NULL AND image IS NOT NULL");
} catch (Exception $e) {}
$success[] = "تم تحديث جدول posts بنجاح";
// 2. إنشاء جدول post_categories
echo "
2️⃣ إنشاء جدول post_categories...
";
$sql = "CREATE TABLE IF NOT EXISTS post_categories (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
slug VARCHAR(100) UNIQUE NOT NULL,
description TEXT,
icon VARCHAR(50),
color VARCHAR(20),
posts_count INT DEFAULT 0,
is_active TINYINT(1) DEFAULT 1,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
$conn->exec($sql);
$success[] = "تم إنشاء جدول post_categories";
// إضافة فئات افتراضية
$categories = [
['أخبار المتجر', 'store-news', 'آخر أخبار وتحديثات المتجر', '📰', '#E57393'],
['نصائح جمالية', 'beauty-tips', 'نصائح للعناية بالبشرة والجمال', '💡', '#9B59B6'],
['عروض خاصة', 'special-offers', 'أحدث العروض والخصومات', '🔥', '#E74C3C'],
['منتجات جديدة', 'new-products', 'تعرفي على أحدث منتجاتنا', '✨', '#3498DB'],
['قصص نجاح', 'success-stories', 'تجارب عملائنا الناجحة', '⭐', '#2ECC71'],
['دليل الاستخدام', 'how-to', 'طرق استخدام المنتجات', '📚', '#F39C12']
];
$stmt = $conn->prepare("INSERT IGNORE INTO post_categories (name, slug, description, icon, color) VALUES (?, ?, ?, ?, ?)");
foreach ($categories as $cat) {
$stmt->execute($cat);
}
$success[] = "تم إضافة الفئات الافتراضية";
// 3. إنشاء جدول post_comments
echo "
3️⃣ إنشاء جدول post_comments...
";
$sql = "CREATE TABLE IF NOT EXISTS post_comments (
id INT AUTO_INCREMENT PRIMARY KEY,
post_id INT NOT NULL,
user_id INT,
author_name VARCHAR(100),
author_email VARCHAR(100),
comment TEXT NOT NULL,
is_approved TINYINT(1) DEFAULT 0,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
INDEX idx_post (post_id),
INDEX idx_approved (is_approved)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
$conn->exec($sql);
$success[] = "تم إنشاء جدول post_comments";
// 4. إنشاء جدول post_likes
echo "
4️⃣ إنشاء جدول post_likes...
";
$sql = "CREATE TABLE IF NOT EXISTS post_likes (
id INT AUTO_INCREMENT PRIMARY KEY,
post_id INT NOT NULL,
user_id INT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY unique_like (post_id, user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
$conn->exec($sql);
$success[] = "تم إنشاء جدول post_likes";
// 5. إنشاء مجلد الصور
$upload_dir = '../uploads/posts';
if (!file_exists($upload_dir)) {
mkdir($upload_dir, 0755, true);
$success[] = "تم إنشاء مجلد uploads/posts";
}
// عرض النتائج
echo "
";
echo "
✅ تم الإصلاح بنجاح!
";
echo "
";
foreach ($success as $msg) {
echo "- $msg
";
}
echo "
";
echo "
";
echo "
";
echo "
📊 الإحصائيات:
";
$count = $conn->query("SELECT COUNT(*) FROM posts")->fetchColumn();
echo "
عدد المنشورات: $count
";
$count = $conn->query("SELECT COUNT(*) FROM post_categories")->fetchColumn();
echo "
عدد الفئات: $count
";
echo "
";
echo "
";
} catch (Exception $e) {
echo "
";
echo "
❌ حدث خطأ:
";
echo "
" . $e->getMessage() . "
";
echo "
";
}
echo "
";
?>