// Hubzilla-Umgebung laden
require_once '/var/www/my_webapp/www/boot.php';

// Kanal-ID und -name ermitteln
$channel_id = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : 51;
$channel_name = isset($a->channel['channel_name']) ? $a->channel['channel_name'] : 'pepechan';

// SQL-Abfrage: Nur eigene Postings (item_origin=1) mit mimetype='text/bbcode'
$sql = sprintf(
    "SELECT `id`, `mid`, `title`, `body` FROM `item`
     WHERE `uid` = %d
     AND `item_origin` = 1
     AND `verb` IN ('Create', 'Announce')
     AND `mimetype` = 'text/bbcode'
     ORDER BY `id` DESC LIMIT %d",
    intval($channel_id),
    3 // Anzahl der anzuzeigenden Postings
);

$result = q($sql);

// Ergebnisse verarbeiten
$items = [];
if (is_array($result)) {
    $items = $result;
} elseif ($result && property_exists($result, 'num_rows') && $result->num_rows > 0) {
    while ($item = $result->fetch()) {
        $items[] = $item;
    }
}

// Ausgabe
if (!empty($items)) {
    echo '<div class="container">';
    foreach ($items as $item) {
        $title = htmlspecialchars($item['title'] ?? '', ENT_QUOTES, 'UTF-8');
        $body = strip_tags($item['body'] ?? '');
        $summary = mb_substr($body, 0, 256, 'UTF-8');
        if (mb_strlen($body, 'UTF-8') > 256) {
            $summary .= '…';
        }

        // UUID aus der mid-URL extrahieren
        $mid = basename($item['mid'] ?? '');

        // Link zum Posting: /channel/[Kanalname]?mid=[UUID]
        $read_more_link = '<a href="/channel/' . htmlspecialchars($channel_name) . '?mid=' . urlencode($mid) . '">..::Weiterlesen::..</a>';

        echo '<div class="border border-light rounded p-3 mb-3 w-100">';
        if ($title) {
            echo '<h5 class="mb-2">' . $title . '</h5>';
        }
        echo '<p class="mb-1">' . $summary . '</p>';
        echo $read_more_link;
        echo '</div>';
    }
    echo '</div>';
} else {
    echo '<p class="text-muted">Keine Beiträge gefunden.</p>';
}