|
Home ◦
About ◦
Archives ◦
Aelysia
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.
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).
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.
Page 2 of 10
|
