17 lines
574 B
PHP
17 lines
574 B
PHP
<?php
|
|
/** admin2/api/dm.php — Direct messages (kind 4/14/15). */
|
|
require_once __DIR__ . '/../lib/helpers.php';
|
|
$pdo = db();
|
|
|
|
$limit = min(200, intval($_GET['limit'] ?? 50));
|
|
$rows = $pdo->prepare("SELECT id, pubkey, kind, created_at, content FROM events WHERE kind IN (4, 14, 15) ORDER BY created_at DESC LIMIT $limit");
|
|
$rows->execute();
|
|
$messages = $rows->fetchAll();
|
|
|
|
foreach ($messages as &$m) {
|
|
$m['created_at'] = date('Y-m-d H:i:s', intval($m['created_at']));
|
|
$m['content'] = substr($m['content'] ?? '', 0, 300);
|
|
}
|
|
|
|
json_response(['messages' => $messages]);
|