exec( "CREATE TABLE IF NOT EXISTS blocked_usernames ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, created_by INT NULL, UNIQUE KEY unique_blocked_username (name), KEY idx_blocked_created_by (created_by) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" ); } catch (Throwable $e) { } $blockedRows = []; try { $stmt = $pdo->prepare( "SELECT b.id, b.name, b.created_at, b.created_by, u.username AS created_by_username FROM blocked_usernames b LEFT JOIN users u ON u.id = b.created_by ORDER BY b.created_at DESC, b.id DESC LIMIT 100" ); $stmt->execute(); $blockedRows = $stmt->fetchAll(PDO::FETCH_ASSOC) ?: []; } catch (Throwable $e) { $blockedRows = []; } ?>
| ID | Nazwa | Data dodania | Dodane przez |
|---|---|---|---|
| Brak zablokowanych nazw | |||
| 0) { echo '#' . $createdById; } else { echo '-'; } ?> | |||