Home   ◦   About   ◦   Archives   ◦   Aelysia

Enhancements and Fixes

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.
  1. {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.
  2. 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.
  3. 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.
  4. 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.
  5. 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).



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.