Home   ◦   About   ◦   Archives   ◦   Aelysia

Archive for the category "Update"



Script Consolidation Progress

After extensive testing and refinement, the long-standing issue with multiple categories has been fully resolved. This improvement now allows the use of multiple favorite fields without errors and enables members to update several favorites as desired.

The update required modifications across multiple files, significant code adjustments, and cleanup to ensure stable performance. Comprehensive testing has been completed to verify that the affected areas function correctly. Further script improvements are planned, but for now, the multi-favorites feature for both the join and update forms is fully operational.
    Listing Admin Updates: Multi-Favorites Fix
  1. Database: normalized existing rows and changed mExtra to VARCHAR(255) NOT NULL DEFAULT '' (removed the "None" sentinel).
  2. members.php: removed logic that wrote the 'NONE' sentinel; now writes empty-string or pipe-delimited favourites and preserves existing values when appropriate.
  3. fun-members.inc.php (newfave): made the select render an explicit empty-value placeholder (<option value="">— Leave Unchanged —</option>) and stopped forcing required on update controls so browsers submit "" for placeholder.
  4. show-update.php:
    • Added robust placeholder detection and merge logic that loads the current mExtra, merges submitted slots with existing slots (per-index), treats placeholder as "leave unchanged", and treats empty text inputs as explicit erase.
    • Added a strict guard so mExtra is only included in the UPDATE when the merged result actually differs or when an explicit erase is requested.
    • Inserted conditional UPDATE building that omits mExtra entirely when no change is needed.
    • Temporarily enabled DEBUG logging to inspect $_POST and the generated SQL during testing.
  5. Testing: cleared cache and verified that updating a single favourite preserves the other slots, leaving placeholder preserves existing values, and explicit erase clears the field.
Following this major bug fix, Cerine and I have decided to consolidate all cliques into a single script. This change will make it easier to implement future updates and enhancements to the Listing Admin system. Similar to the fanlistings hosted under Enamour, all cliques will be relocated to a new domain earlier as expected.

We are currently in the process of migrating content, with additional checks and testing underway before the new public link is released. Further updates regarding the transition will be shared later this month.



Disclosure Updates

There are no new content updates for November. However, over the past few days, I’ve focused on completing updates to my blogging script, Disclosure. The system is now at version 1.2.0, featuring numerous bug fixes and several long-awaited add-ons. While these changes may not be visible to end users, they represent significant improvements on the backend—enhancing performance, stability, and overall developer experience. The about section has also been updated regarding the applied patch (replaces unsafe GETs, queries and pagination generation), and found several problems and fixed the important ones (input handling, SQL safety, pagination bugs, inconsistent vars, XSS notes) for this update.
    Disclosure v1.2.0
  • 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.
  • Replaced the category and monthly blocks and add safer GET handling and error reporting.

  • 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.



Master of Action

Good day, everyone. I am pleased to share my final update for the month as I prepare to begin the new position mentioned in my previous post. I am delighted to announce that the Jackie Chan fanlisting has been approved and is now live. If you are a fan of this legendary actor, you are welcome to join and show your support.
  1. Jackie Chan – I genuinely enjoyed creating this design. I selected a palette of earthy tones, including deep greens, browns, taupes, and creams, and incorporated natural textures through background images and design elements. The subtle greens complement the paper accents, stone textures, and organic imagery. I chose a simple, elegant layout to evoke a sense of warmth and authenticity.
Future Updates
Cerine and I have also had several discussions about launching one or two new sites and are considering the possibility of consolidating similar projects into a single domain. Grouping related projects under one site could simplify management and improve organization. However, this idea is still under review, as we are mindful of domain expenses—these can accumulate quickly when managing multiple sites, particularly if their level of activity is uncertain. A final decision is expected to be announced in early 2026, so please stay tuned for updates.



Page 1 of 9
News script, coding, design, and contents on Disclosure © by Aelyn since 2009 - 2025. Rooms: An Illustration and Comic Collection illustrated by Umishima Senbon. Part of the Celestial Oracle Studio.