|
Home ◦
About ◦
Archives ◦
Aelysia
Disclosure is an internal news management system and update log developed for all entries under the Celestial Oracle Studio.
It is designed as a lightweight, modular, and easily maintainable PHP application with a focus on performance, security, and simplicity.
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.
Changelogs
- Disclosure v1.2.0
- Replaced the category and monthly blocks and add safer GET handling and error reporting.
- Implemented PDO compatibility
- Updated listing page to support real category relations (normalized many-to-many table).
- Implemented edge case handling by binding parameters using bind_param('is', $yearParam, $monthname).
- Converted queries to prepared statements.
Bugs and Fixes
- Fixed logic bugs: $page vs $screen, $next_page assignment, $adjacents as int, current page non-clickable.
- Fixed SQL and HTML output are vulnerable to injection/XSS (no casting/escaping).
- Fixed areas where some mysqli_query results are not checked for errors.
- Disclosure v1.0.1
- Fully functional in PHP 8.x and MySQL 8.x
- Various code fixes + pagination fixes
- Disclosure v1.0.0
Future Plans
- Polished admin UI
- Search feature for users
- RSS feed aggregator
- Fix bugs within the admin panel
Features
- Lightweight architecture: Minimal dependencies for faster load times and easier deployment.
- Responsive frontend: Built with Bootstrap, ensuring a clean, mobile-friendly interface.
- Single-admin dashboard: Centralized control panel for managing entries and updates efficiently.
- PDO-compatible backend: Uses PHP Data Objects (PDO) for secure, parameterized MySQL database queries, improving both security and portability.
- Minimalist design: Focuses on usability and readability with a distraction-free layout.
Technical Stack
- Frontend: HTML5, CSS3, Bootstrap 5
- Backend: PHP (PDO-compatible), MySQL
- Architecture: Single-admin, monolithic structure
- Compatibility: Tested under PHP 8.x
|