Home   ◦   About   ◦   Archive   ◦   Feed

Disclosure is a lightweight internal news management system. Designed as a centralized update log, it provides a simple and maintainable way to create, organize, search, and manage studio entries. The script focuses on performance, security, simplicity, and maintainability, while demonstrating practical backend development concepts using PHP and MySQL.

NOTES: Disclosure is an internal project intended for private use within the Celestial Oracle Studio. There are no current plans to release the source code or make the system publicly available.

Features

  • PHP & MySQL support
    Fully compatible with PHP 8.3 and MySQL 8.4, providing a modern and reliable foundation for the application.
  • Lightweight architecture
    Minimal dependencies for faster load times, simpler deployment, and easier long-term maintenance.
  • Full CRUD functionality
    Create, read, update, and delete blog entries through a centralized administration system.
  • Responsive frontend
    Built with semantic HTML and custom CSS to provide a clean, accessible, and mobile-friendly interface without relying on a frontend framework.
  • Single-admin dashboard
    Centralized control panel for managing entries, categories, and studio updates efficiently.
  • Category management
    Organize entries into categories and provide dedicated category pages for browsing related content.
  • Advanced search
    Search entry titles, full content, and categories with support for multiple search terms, quoted phrases, and exact-word matching.
  • Search highlighting
    Matching search terms are highlighted in results while preserving the original HTML structure of entry content.
  • Pagination
    Entry and search results are divided into manageable pages to improve navigation and reduce the amount of content displayed at once.
  • Clean URLs
    Human-readable URLs are used for entries, categories, and search results to provide a cleaner and more accessible site structure.
  • Secure database queries
    Uses parameterized queries and prepared statements to improve database security and reduce the risk of SQL injection.
  • Preserved entry formatting
    Search results display complete entries while preserving the existing HTML structure and presentation of the blog content.
  • Minimalist design
    Focuses on usability, readability, and straightforward navigation with a distraction-free presentation.

Changelogs

  • Disclosure v1.2.2 Alpha
    • Added full search support for categories, entry titles, and content with multiple terms, quoted phrases, and highlighting.
    • Updated search matching to use whole-word and whole-phrase matching, eliminating unintended partial-word results.
    • Added full entry results with archive-style formatting, five-entry pagination, and clean search URLs.
  • Disclosure v1.2.1 Alpha
    • Added a new RSS 2.0 feed for distributing the latest update log entries to RSS readers and external applications.
    • RSS feeds now include entry titles, publication dates, permalinks, authors, categories, and full entry content.
    • Added a cleaner /feed.xml URL for accessing the RSS feed.
    • Added XML escaping and CDATA handling to safely preserve existing HTML content within the RSS feed.
    • Updated database and connection handling to use utf8mb4, providing full Unicode and modern emoji support.
    • Validated the generated RSS feed through the W3C Feed Validation Service.
  • Disclosure v1.2.0 Alpha
    • Replaced the category and monthly blocks and added safer GET handling and error reporting.
    • Implemented PDO compatibility.
    • Updated the listing page to support real category relations using a normalized many-to-many table.
    • Implemented edge-case handling by binding parameters using bind_param('is', $yearParam, $monthname).
    • Converted database queries to prepared statements.
    • Fixed pagination logic bugs involving $page vs. $screen, $next_page assignment, $adjacents type handling, and the current page remaining clickable.
    • Fixed SQL and HTML output vulnerabilities caused by missing casting and escaping.
    • Added error checking for areas where mysqli_query results were not previously checked.
  • Disclosure v1.0.1 Alpha
    • Fully functional with PHP 8.x and MySQL 8.x.
    • Various code fixes and pagination improvements.
  • Disclosure v1.0.0 Alpha
    • Initial development version of Disclosure.
Disclosure © 2009-2026 by Aelyn. Rooms: An Illustration and Comic Collection, illustrated by Umishima Senbon. A star part of the Celestial Oracle Studio. All images remain the property of their respective owners. Powered by Disclosure v1.2.2 Alpha.