convertmarkdown.php

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
$sqlpath = $_SERVER['DOCUMENT_ROOT'];
$sqlpath .= "/sql-connect.php";
include_once($sqlpath);

$parsepath = $_SERVER['DOCUMENT_ROOT'];
$parsepath .= "/plugins/Parsedown.php";
include_once($parsepath);

$parsedown = new Parsedown();

// Fetch the data from your database
$sql = "SELECT * FROM notes";
$sqldata = mysqli_query($dbcon, $sql) or die('Error getting data');

// Loop through each record
while ($row = mysqli_fetch_assoc($sqldata)) {
    $noteID = $row['id'];  // Assuming there's an 'id' column in your 'notes' table
    $markdownContent = $row['body'];  // Now using 'body' column instead of 'content'

    // First, remove any existing processed comments (<!--processed...-->)
    $markdownContent = preg_replace('/<!--processed-.*?-->/s', '', $markdownContent);

    // This step will convert any other Markdown into HTML without affecting our custom data-mention spans
    $htmlContent = $parsedown->text($markdownContent);

// Use regular expression to replace anchor tags that start with '@' with a span tag
$newHtmlContent = preg_replace_callback(
    '/<a[^>]*>(@[^<]+)<\/a>/',
    function($matches) {
        // Check if this mention has already been processed (this avoids re-processing)
        if (strpos($matches[1], '@') === 0) {
            // Replace anchor tag with a span tag and add data-mention attribute and mention class
            return '<span class="mention" data-mention="' . htmlspecialchars($matches[1]) . '">' . htmlspecialchars($matches[1]) . '</span>';
        }
        return $matches[0]; // Return unchanged if already processed
    },
    $htmlContent
);

// Replace Markdown checkboxes with HTML checkboxes
$htmlContent = preg_replace_callback(
    '/\[\s?([x ]?)\]/',  // Match [ ] or [x]
    function($matches) {
        // Check if the box is checked or unchecked
        $checked = ($matches[1] === 'x') ? 'checked' : '';
        return '<input type="checkbox" ' . $checked . ' disabled>';
    },
    $htmlContent
);

    // Update the content in the database with the new HTML (without the onclick)
    $updateSql = "UPDATE notes SET body = ? WHERE id = ?";
    $stmt = $dbcon->prepare($updateSql);
    if (!$stmt) {
        die('Statement preparation failed: ' . $dbcon->error);
    }
    $stmt->bind_param("si", $newHtmlContent, $noteID);  // 's' for string, 'i' for integer
    $stmt->execute();

    if ($stmt->affected_rows > 0) {
        echo "Note ID $noteID updated successfully.<br>";
    } else {
        echo "Error updating Note ID $noteID.<br>";
    }
}

echo "All selected notes processed and updated with new mention method.";
?>