summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler
AgeCommit message (Collapse)AuthorFilesLines
2021-01-20v2rw: Rewrite done, time to clean up old v2 codeYorhel9-1288/+0
Yay! There are no more request handlers in the VNDB::* namespace and no more Javascript in data/js/. This cleans up a lot of old legacy code that wasn't fun to maintain.
2021-01-19v2rw: Convert VN releases tabYorhel1-1/+1
This is the last page in the old v2 code that hadn't been rewritten yet. It's a fairly direct and ugly conversion as I've not decided what the future holds for this page, but at least this will allow me to clean up a lot of old and ugly code.
2021-01-18Staff::List: Convert to new AdvSearch systemYorhel1-4/+4
Mostly copy-paste, nothing special going on here.
2021-01-16TraitPage: Rewrite to use new AdvSearch systemYorhel1-1/+1
Largely a copy-paste from TagPage.
2021-01-16Chars::List: Switch to new AdvSearch systemYorhel1-4/+4
TODO: Add VN subquery and migrate trait pages.
2021-01-10v2rw: Convert /opensearch.xml description + ancient typo fixYorhel1-20/+0
2021-01-10v2rw: Convert /r/engines (+ make it link to new AdvSearch system)Yorhel1-30/+0
2021-01-10Replace references to old /v/all pathYorhel1-2/+2
Old /v/<char> URLs are still supported, but the main listing is at /v.
2021-01-10AdvSearch: Time to put this live.2.29Yorhel3-14/+15
Moved old release browser, VN browser and tag pages to /old/, moved /experimental/ pages to /, removed warnings and updated some references.
2020-10-16v2rw: Convert producers listing & searchYorhel1-58/+0
Now featuring full pagination & flexible columns.
2020-10-02v2rw: Move redirects + cleanup some moreYorhel2-20/+0
2020-09-30v2rw/Tags::Index: Re-use tag index for trait indexYorhel1-80/+0
This code is pretty easy to re-use.
2020-09-30v2rw/Tags::Index: Rewrite the tag indexYorhel1-79/+0
Nothing new, but I do see more avenues for consolidation with traits.
2020-09-29v2rw/Tag::List: Re-use tag listing to implement trait listingYorhel1-72/+0
Duplicating that code was really too much, the listings are way too similar.
2020-09-29v2rw/TraitEdit: Rewrite trait edit form + cleanup bunch of old codeYorhel1-140/+0
This was the last form in the old v2 code, so this allowed me to get rid of the old form validation and generation abstractions. The form is mostly a duplicate of the tag editing form, as expected. It's really annoying to have to maintain pretty much duplicate code for tags and traits, but there are just enough differences that the complexity of sharing code or creating a new abstraction outweigh the benefits. :(
2020-09-27v2rw/Tags::List: Re-implement & improve the tag listYorhel2-70/+1
Now supports full pagination, displaying & sorting on VN count and displaying & filtering the searchable and applicable flags.
2020-09-27v2rw: Delete old tag edit formYorhel1-167/+0
2020-09-27v2rw/TagEdit: Rewrite tag edit form to elmYorhel1-4/+4
It's still missing a few mod features, will add those later.
2020-09-12v2rw: Add new filter querying framework + rewrite homepageYorhel1-229/+0
The new filter framework hasn't been extensively tested yet, but seems to mostly work. No real changes to the homepage, but I did manage to make a few queries a little bit faster. The most significant source of slowness is the releases listing, but I can't optimize that without adding indices.
2020-09-02BBCode: Consolidate bb2html & bb2text + only convert ids in thread titlesYorhel4-4/+4
Fixing bb2html to only convert ids would complicate options a lot, adding a new formatting function to only convert ids would make sense, but then all formatting functions kind of look alike, so I figured a single bb_format() to support all use cases may be a better approach. Trigger for this was that people do (understandably) put [spoiler] in thread titles, and that should not be interpreted as the spoiler tag.
2020-09-01Handler::Misc: Bring back random VNs, split new reviews and add recent commentsYorhel1-11/+68
2020-08-31Handler::Misc: Replace "Random VNs" section with "New Reviews"Yorhel1-7/+12
Still need a place to dump "latest review comments". Perhaps merge with "recent posts"? Not sure...
2020-08-24reviews: Get rid of summary field & split mini/full reviewsYorhel1-1/+1
Much to my disappointment, people don't write proper summaries and, as such, summaries are not useful to be considered a "short review" on their own right. This necessitates splitting the reviews onto different pages.
2020-08-06Discussions: Allow discontinuous post numbers + ignore hidden posts in ↵Yorhel1-1/+1
counts/lastpost This solves a few problems: - 'hidden' posts will no longer cause the thread to be bumped to the front page. - Deleting posts will no longer cause other posts to be renumbered (and hence will not break existing links to posts) - Numbers of deleted posts will no longer be re-used (except when they were the last post in the thread - fixing this would require an additional column in 'threads', but it didn't seem worth the trouble)
2020-08-06Discussions: Make /t#.# load the correct page without redirectYorhel1-1/+1
This removes the need for the post_url() function. This is a small step towards supporting non-continuous post numbers.
2020-08-06SQL: Use vndbid for thread identifiersYorhel1-1/+1
Also drop the thread_poll_votes.tid column, as it's not really necessary. And add ON DELETE CASCADEs to threads_posts and threads_boards to simplify thread deletion. Relatively invasive change, prolly broke something.
2020-07-21Delete old producer edit form + a few more cleanupsYorhel2-239/+0
2020-07-19Producers::Edit: v2rw rewrite producer add/edit formYorhel1-4/+4
The copy-pasting here is ridiculous. But at the same time, that did allow me to quickly rewrite the form in a single commit. Here's hoping I didn't introduce too many copy-paste errors.
2020-07-19Delete old VN edit form + some other unreferenced codeYorhel1-541/+0
There's a lot more unreferenced code in VNDB::DB::*, but I'll not spend too much effort cleaning that up right now. All of it can be deleted in bulk at some point.
2020-06-29VN::Edit: Start rewrite of the VN edit formYorhel1-4/+4
This is mostly a copy-paste of the Char::Edit form.
2020-06-15Releases: Allow custom resolutions to be enteredYorhel1-4/+2
The resolution field now works much like the engine field.
2020-06-12v2rw: Convert producer pages & consolidate release row HTMLYorhel1-164/+1
The release listing on producer pages now uses the same HTML as on VN pages, so it comes with the same information & features. Unfortunately, it also comes with the same messiness... The page is kind of large and slow for producers with lots of releases, not sure what to do with that.
2020-06-04Delete old character edit formYorhel1-228/+0
Not used anymore.
2020-05-28Drop ReleaseExtLinks.elm in favor of pure CSS solutionYorhel2-31/+1
It's the only Elm module used on VN pages for not-logged-in visitors, so doing this in CSS makes it possible to not load an Elm bundle on those pages (when I get to splitting up the JS files). This solution also simplifies code reuse with the producer pages, but a v2rw migration of that page would have taken care of that as well.
2020-05-25Chars::Edit: Character creation + copyingYorhel1-1/+1
This removes the 'Add character' link from the main menu, need some data to see if it's used.
2020-05-12Char::Edit: Initial rewrite of the character edit form, general info firstYorhel1-1/+1
2020-04-24v2rw/VN::Page: Remove old and unused codeYorhel3-794/+2
There's a lot of unused code in VNDB::DB::{VN,Release} still, but I'll not fiddle with that for now.
2020-04-17v2rw/VN::Page: Start conversion of VN pagesYorhel1-1/+1
Currently implemented: - Revision diff - Info box & tags (already implemented from /v+/chars page) - Stats There's a few annoying TODO's left, this conversion will take some effort.
2020-04-13UList.VNPage: Allow setting notes from the VN pageYorhel1-1/+2
2020-04-11v2rw: Convert VN char pages (/v+/chars)Yorhel2-191/+3
This also reimplements the VN infobox part of the page - a good first step into converting the main VN pages to v2rw. The new '?view=' parameter is used for spoiler and sexual hiding. Also fixes a bug on character pages where release-specific roles weren't displayed correctly.
2020-04-01VN::Graph: Also generate VN graphs on-demandYorhel1-23/+0
Same change as with Producers::Graph before. This also adds an option to show/hide unofficial relations. Restructured the code a bit to allow for sharing code between Producers::Graph and VN::Graph.
2020-03-30Producers::Graph: Experiment with dynamically generating relation graphsYorhel1-22/+0
The producers.rgraph column still exists and the old graphs are still being generated - that will be removed if this new approach works out.
2020-03-22Delete old release edit formYorhel1-321/+0
So that I can now work on adding a few more fields.
2020-03-22Handler::Producers: Explicitly mention primary language on producer pagesYorhel1-1/+3
To avoid confusion - https://vndb.org/t950.693 .. 696.
2020-03-12SQL: Keep track of dimensions for all images in the DBYorhel2-3/+3
Ought to simplify the image flagging UI.
2020-02-29Revert "Handler::Chars: don't automatically remove non-applicable traits ↵Yorhel1-3/+1
when editing" This reverts commit 486ce0910818ea4b8bc7ef42592915c775f1f45f. Turns out that was considered a feature rather than a bug... https://vndb.org/t3314.2009
2020-02-29Merge branch 'reledit'Yorhel1-3/+3
2020-02-28v2rw/RelEdit: Allow creating a new releaseYorhel1-1/+1
Not totally super happy with this solution; I'd rather automatically create an empty entry and send that to 'RelEdit.Main', but initializing all fields in Perl is tricky. At least in Elm we get some sort of type checking (though Elm can't tell whether the default value makes sense) and doing this in Elm makes it possible to initialize to something invalid that the user has to change (not currently done yet). It's messy either way.
2020-02-28Handler::Chars: don't automatically remove non-applicable traits when editingYorhel1-1/+3
2020-02-21v2rw/WIP: Incremental rewrite of the release edit formYorhel1-2/+2
The new form does change a few things to the UI, so I'll keep the old form around for a while so that people have something to fallback to when it doesn't work (like, right now). I'm also doing this rewrite in multiple commits as it's a pretty large change.