OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/26/2025 04:20:38 AM	rwxr-xr-x
📄 12-03-25social_navbar.php	24.95 KB	03/26/2025 04:20:38 AM	rw-r--r--
📁 PHPMailer	-	03/26/2025 04:21:23 AM	rwxr-xr-x
📄 backup-navbar.php	27.21 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 backupnavbar.php	21.14 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 blockAccount.php	2.23 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 bnavbar.php	35.74 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 bottom_navbar.php	6.18 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 common.js	46.89 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 config.php	9.43 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 db_config.php	3.42 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 db_connect.php	305 bytes	03/26/2025 05:01:45 AM	rw-r--r--
📄 delete_account.php	3.5 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 edit_post.php	2.23 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 footer.php	1.28 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 function.php	19.88 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 go_backbar.php	4.01 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 handler.php	3.46 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 indexFooter.php	597 bytes	03/26/2025 04:20:38 AM	rw-r--r--
📄 mail.php	2.67 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 navbar.php	24.01 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 process_data.php	3.87 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 readert_validate.logged.php	481 bytes	03/26/2025 04:20:38 AM	rw-r--r--
📄 report_account.php	1.42 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 report_stream.php	2.08 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 savePost.php	2.38 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 sidebar.php	18.88 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 siginupProcess.php	5.24 KB	03/26/2025 04:20:38 AM	rw-r--r--
📁 simplepie	-	03/26/2025 04:22:22 AM	rwxr-xr-x
📄 social_navbar.php	24.83 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 stream_post_handler.php	3.68 KB	03/26/2025 04:20:38 AM	rw-r--r--
📄 validate.logged.php	1.01 KB	03/26/2025 04:20:38 AM	rw-r--r--

Editing: savePost.php

<?
include "validate.logged.php";
include "db_config.php";

// if($reqType)
    // $query = "INSERT INTO stream_saved (user_id, post_id) VALUES (?, ?)";
    // $stmt = $readerdb->prepare($query);
    // $stmt->bind_param('ii', $gUserId, $postId);
    // if ($stmt->execute()) {
    //     echo json_encode(['success' => true]);
    // } else {
    //     echo json_encode(['success' => false, 'error' => 'Failed to save post.']);
    // }

function deleteSave($conn, $userId, $streamId) {
    $query = "DELETE FROM stream_saved WHERE user_id = ? AND post_id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ii", $userId, $streamId);
    return $stmt->execute();
}

function hasUserSaved($conn, $userId, $streamId) {
    $query = "SELECT 1 FROM stream_saved WHERE user_id = ? AND post_id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ii", $userId, $streamId);
    $stmt->execute();
    $stmt->store_result();

return $stmt->num_rows > 0;  // Return true if the user has already liked, else false
}
function insertSave($conn, $userId, $streamId) {
    $query = "INSERT INTO stream_saved (user_id, post_id) VALUES (?, ?)";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ii", $userId, $streamId);
    return $stmt->execute();
}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    header('Content-Type: application/json');
    $postId = $_POST['id'];
    $request=$_POST['request'];
if ($request === 'save') {
    // Check if the user has already liked this post
    if (!hasUserSaved($readerdb, $gUserId, $postId)) {
        // User has not liked yet, so insert a new like
        if (insertSave($readerdb, $gUserId, $postId)) {
            $response = ['status' => 'success'];
        } else {
            $response = ['status' => 'error', 'message' => 'Unable to save post'];
        }
    } else {
        $response = ['status' => 'error', 'message' => 'You already saved this post'];
    }
} elseif ($request === 'unsave') {
    // User has liked this post, so remove the like
    if (deleteSave($readerdb, $gUserId, $postId)) {
        $response = ['status' => 'success'];
    } else {
        $response = ['status' => 'error', 'message' => 'Unable to unlike post'];
    }
} else {
    // Invalid request type
    $response = ['status' => 'error', 'message' => 'Invalid request'];
}
}
echo json_encode($response);
?>