summaryrefslogtreecommitdiff
path: root/lib/VNWeb/TT/TagPage.pm
AgeCommit message (Collapse)AuthorFilesLines
2022-04-21TT::TagPage: Fix VN listing length column on tag pagesYorhel1-1/+2
Fixes https://vndb.org/t2520.647
2022-02-08VN: Add support for multiple titles in different languagesYorhel1-2/+2
This implements the main database model part of custom title languages (https://vndb.org/t12465). Selecting the right title for display is done in SQL through the 'vnt' VIEW, which can be overridden in each session with a TEMPORARY VIEW in order to support user title preferences, but that part has not been implemented yet. I had started out using an sql_vn() function that returned a subquery instead of using a VIEW, but then ran into trouble with the item_info() SQL function. This VIEW approach also happened to simplify much of the code. I did have to get rid of the Discusssions::Lib::sql_boards() function, as Postgres was unable to optimize the subquery inside a UNION inside a subquery for some reason. Haven't run into any other noticeable performance regressions yet. TODO: - Implement actual user title preferences - Add the correct 'lang' HTML attributes everywhere a title is displayed (we do have the information now, though it still isn't trivial) - Add title fetching support to API
2021-06-17TT::TagPage: Fix display of VN image in card modeYorhel1-1/+1
Fixes https://vndb.org/t2520.567
2021-06-04VN listing: Add table options + developer and raw average columnsYorhel1-21/+15
With additional VN cache columns for the new developers and average table columns. The developers cache is also used by the AdvSearch to potentially speed up some queries (and slow down others). I also changed the popularity and rating caches to smallint. Doesn't save anything with the current padding, but there's not much point in using a floating point type when the values get rounded anyway.
2021-05-21Tags/Traits: Add main/primary flag to parents listYorhel1-1/+2
This way there is always a single canonical path for each tag/trait, which fixes the problem with traits that could belong to multiple groups yet you couldn't control which one was selected, and this also removes duplication in the VN->tags tab, which now doesn't have to non-canonical tag paths.
2021-03-23HTML: Use hiddenmsg for tags/traits and to display awaiting moderation stateYorhel1-17/+1
This also fixes the issue that the reason for deletion is not displayed if it's in the message of the last change, which is the case for newly rejected tags/traits. The edit message is not displayed if the entry was deleted in the first revision, as that's most likely an import.
2021-03-11TT::TagPage: Fix tag id comparison check in old URLsYorhel1-1/+1
I obviously forgot to test this one.
2021-03-11Tags: Convert to vndbids + add edit historiesYorhel1-13/+30
Another commit with changes all across the tree. But at least we have a tangible improvement now: edit histories for tags.
2021-03-02CSS: Fix formatting of block elements in entry descriptionsYorhel1-1/+1
Fixes https://vndb.org/t2520.542
2021-01-29AdvSearch: Convert old-url redirects into permanent redirectsYorhel1-1/+1
I had them as temporary redirects in order to safely handle a rollback, but that won't be necessary anymore.
2021-01-21AdvSearch: Stop logging filter compatibility conversion errorsYorhel1-5/+1
I think I've seen all the possible errors by now, what remains are invalid/corrupted filter strings that aren't very interesting to handle.
2021-01-16TraitPage: Rewrite to use new AdvSearch systemYorhel1-33/+3
Largely a copy-paste from TagPage.
2021-01-15TagPage: Fix display of tag propertiesYorhel1-1/+1
2021-01-10AdvSearch: Improve error reporting when query validation failedYorhel1-1/+1
Amazing how can browsers(?) and bots mangle URLs sometimes. Anyway, the user will now get a friendly error message instead of a 500, and I get to see log messages. Everyone happy. I hope.
2021-01-10TagPage: Fix URL compatibility conversion for URLS with a tag filterYorhel1-2/+7
2021-01-10AdvSearch: Time to put this live.2.29Yorhel1-2/+2
Moved old release browser, VN browser and tag pages to /old/, moved /experimental/ pages to /, removed warnings and updated some references.
2021-01-09AdvSearch: Apply new saved default queries to listings instead of old filtersYorhel1-4/+1
2021-01-09v2rw/TagPage: Add /experimental/ tag page rewrite with AdvSearch supportYorhel1-0/+185