⌜ update log. ⌟ ✧ cradle of the astralspire network

Welcome to Disclosure, an update log for the Cradle of the Astralspire Network. Like any long-term project, I aim to keep a record of the activities and key changes made on this domain. This log serves as a space to track announcements and general updates. All entries are archived on a single page, allowing for easier navigation through individual categories. Please note that as you explore older entries, some links may be outdated or no longer accessible.

Aquarel.nu Transition Notice

Posted on 03 Dec '25 filed under Aquarel.nu, Clique, Updates

Hi everyone. Cerine and I would like to share an important update with you, and we appreciate your understanding in advance. For our first update of December, we are working on moving our cliques -again- to a new domain; a transition that was originally scheduled for November. Unfortunately, due to an unexpected issue with the domain's server being on hold, the updates did not proceed as intended. While our other .nu domains propagated their DNS without issue, this particular one encountered complications, forcing us to operate temporarily under aquarels.net rather than our main domain, aquarel.nu.

Before this move, we had already consolidated our cliques into a single unit, making the transition both necessary and time-sensitive. However, the issues with aquarel.nu delayed this process.

To avoid any confusion caused by the mass email sent a few weeks ago, we will be sending another update to clarify that all cliques will ultimately remain under Aquarel.nu. With this change, we are providing a new three-month grace period starting today for everyone to update their links. This adjustment will ensure that all cliques are properly linked, consistently aligned with the domain's long-term direction, and reliably maintained by a single script.

We understand that this news may come as a surprise, especially to those who have already updated their links, and we sincerely apologize for any inconvenience it may cause. Nevertheless, we hope this explanation clarifies the reasons for the changes and the direction in which we are moving.

Enhancements and Fixes

Posted on 16 Nov '25 filed under Enamour.nu, Updates

This will be the final update for November, as most of my time this month has been dedicated to addressing various fixes. This update is based on the script nested within Enamour.nu. I have added several new features that were missed by Listing Admin, which I find beneficial from Enthusiast. Moving forward, I will continue updating all fanlistings with these minor improvements.

{country_count} now injected into templates where it was previously left unreplaced.
- show-stats.php: Computes the distinct country count for the current listing and applies str_replace('{country_count}', $la_fl_country) in the template path.
- For non-template paths, the $la_fl_country variable is now set for downstream code when templates are not used.
Enhanced show-owned.php to render templates with the country count.
- Replaced the direct echo of getTemplate_Listings($id) with template rendering and str_replace('{country_count}', $la_fl_country, $tmpl).
- Each listing object is now retrieved, and the distinct-country SQL is computed per listing before injection.
- Resolved issue with membersSort() country case handling.
Corrected membersSort() country case handling.
- Fixed incorrect variable usage ($listing->dblist used instead of $listing->dbtabl).
- Replaced misuse of mysqli_num_rows() with the proper scorpions wrapper and COUNT(*) query to return the total across all pages (not just the paged result).
- Separated the paged SELECT query (with LIMIT) from the COUNT(*) query to ensure the displayed total reflects the full count.
- Corrected member identifier/format argument selection for cross-listed database types (Enthusiast, Fanbase, ListingAdmin), ensuring correct rendering of member rows.
Improved per-country counting in membersDefault().
- Utilizes the correct table name and DB-type-aware COUNT(*) SQL query.
- Escapes country values appropriately and reads the count via scorpions->obj, ensuring reliable display of per-country totals.
Miscellaneous improvements.
- Consistent usage of scorpions->query, scorpions->obj, and scorpions->total where applicable.
- Applied basic SQL escaping and branching for different external database types (Enthusiast, Fanbase/Fanupdate, ListingAdmin).

Script Consolidation Progress

Posted on 07 Nov '25 filed under Updates

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

Database: normalized existing rows and changed mExtra to VARCHAR(255) NOT NULL DEFAULT '' (removed the "None" sentinel).
members.php: removed logic that wrote the 'NONE' sentinel; now writes empty-string or pipe-delimited favourites and preserves existing values when appropriate.
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.
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.

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

Posted on 05 Nov '25 filed under 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

Posted on 23 Oct '25 filed under Fanlisting, New, Updates

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.

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 3 of 14

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



Home ◦ About ◦ Archives ◦ Aelysia Welcome to Disclosure, an update log for the Cradle of the Astralspire Network. Like any long-term project, I aim to keep a record of the activities and key changes made on this domain. This log serves as a space to track announcements and general updates. All entries are archived on a single page, allowing for easier navigation through individual categories. Please note that as you explore older entries, some links may be outdated or no longer accessible. Aquarel.nu Transition Notice Posted on 03 Dec '25 filed under Aquarel.nu, Clique, Updates Hi everyone. Cerine and I would like to share an important update with you, and we appreciate your understanding in advance. For our first update of December, we are working on moving our cliques -again- to a new domain; a transition that was originally scheduled for November. Unfortunately, due to an unexpected issue with the domain's server being on hold, the updates did not proceed as intended. While our other .nu domains propagated their DNS without issue, this particular one encountered complications, forcing us to operate temporarily under aquarels.net rather than our main domain, aquarel.nu. Before this move, we had already consolidated our cliques into a single unit, making the transition both necessary and time-sensitive. However, the issues with aquarel.nu delayed this process. To avoid any confusion caused by the mass email sent a few weeks ago, we will be sending another update to clarify that all cliques will ultimately remain under Aquarel.nu. With this change, we are providing a new three-month grace period starting today for everyone to update their links. This adjustment will ensure that all cliques are properly linked, consistently aligned with the domain's long-term direction, and reliably maintained by a single script. We understand that this news may come as a surprise, especially to those who have already updated their links, and we sincerely apologize for any inconvenience it may cause. Nevertheless, we hope this explanation clarifies the reasons for the changes and the direction in which we are moving. Enhancements and Fixes Posted on 16 Nov '25 filed under Enamour.nu, Updates This will be the final update for November, as most of my time this month has been dedicated to addressing various fixes. This update is based on the script nested within Enamour.nu. I have added several new features that were missed by Listing Admin, which I find beneficial from Enthusiast. Moving forward, I will continue updating all fanlistings with these minor improvements. {country_count} now injected into templates where it was previously left unreplaced. show-stats.php: Computes the distinct country count for the current listing and applies `str_replace('{country_count}', $la_fl_country)` in the template path. For non-template paths, the `$la_fl_country` variable is now set for downstream code when templates are not used. Enhanced `show-owned.php` to render templates with the country count. Replaced the direct echo of `getTemplate_Listings($id)` with template rendering and `str_replace('{country_count}', $la_fl_country, $tmpl)`. Each listing object is now retrieved, and the distinct-country SQL is computed per listing before injection. Resolved issue with `membersSort()` country case handling. Corrected `membersSort()` country case handling. Fixed incorrect variable usage (`$listing->dblist` used instead of `$listing->dbtabl`). Replaced misuse of `mysqli_num_rows()` with the proper scorpions wrapper and `COUNT()` query to return the total across all pages (not just the paged result). Separated the paged `SELECT` query (with `LIMIT`) from the `COUNT()` query to ensure the displayed total reflects the full count. Corrected member identifier/format argument selection for cross-listed database types (Enthusiast, Fanbase, ListingAdmin), ensuring correct rendering of member rows. Improved per-country counting in `membersDefault()`. Utilizes the correct table name and DB-type-aware `COUNT()` SQL query. Escapes country values appropriately and reads the count via `scorpions->obj`, ensuring reliable display of per-country totals. Miscellaneous improvements. Consistent usage of `scorpions->query`, `scorpions->obj`, and `scorpions->total` where applicable. Applied basic SQL escaping and branching for different external database types (Enthusiast, Fanbase/Fanupdate, ListingAdmin). Script Consolidation Progress Posted on 07 Nov '25* filed under Updates 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 Database: normalized existing rows and changed mExtra to VARCHAR(255) NOT NULL DEFAULT '' (removed the "None" sentinel). members.php: removed logic that wrote the 'NONE' sentinel; now writes empty-string or pipe-delimited favourites and preserves existing values when appropriate. 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. 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. 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 Posted on 05 Nov '25 filed under 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 Posted on 23 Oct '25 filed under Fanlisting, New, Updates 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. 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 3 of 14 First«12345...14»Last
News script, coding, design, and contents on Disclosure © by Aelyn since 2009 - 2026. Rooms: An Illustration and Comic Collection illustrated by Umishima Senbon. Part of the Celestial Oracle Studio.