summaryrefslogtreecommitdiff
path: root/lib/VNDB/Util/Misc.pm
AgeCommit message (Collapse)AuthorFilesLines
2021-01-20v2rw: Rewrite done, time to clean up old v2 codeYorhel1-93/+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.
2020-09-29v2rw/TraitEdit: Rewrite trait edit form + cleanup bunch of old codeYorhel1-8/+1
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-10v2rw/filters: Add experimental validation + move compat to VNWebYorhel1-16/+3
This is a minor start towards rewriting the filter logic in the new v2rw code. Filters were never validated before (I didn't have a good framework for it - now I do) and invalid filters would result in a 500. The new validation code is not yet applied, but failed validations will be logged so that I can see if it's working correctly. I mean, what better way to test than to throw it in production? I'll write new (and more flexible) SQL generation functions for these filters later, so that v2rw code can get filtered results and I can make a start on rewriting the pages that depend on the functionality. The validation schema can also be used to validate the filters stored in the DB, so I can use it to get rid of the complex handling of stored invalid filters.
2020-06-15Releases: Allow custom resolutions to be enteredYorhel1-9/+0
The resolution field now works much like the engine field.
2019-11-12v2rw: Move entryLinks() into separate VNDB::ExtLinks moduleYorhel1-84/+1
This is yak shaving. The new module doesn't have much value as it is, apart from having a central place to define link formats. This new enrich_extlinks() approach is also a bit more efficient in that it can avoid separate SQL queries for multiple objects. But the real reason for these changes is that I can use that %LINKS hash table to automatically generate the links part in the edit summary and it should (hopefully) also be useful to generate a more convenient/streamlined Elm edit form.
2019-11-08Wikidata: Add support for doujinshi.org author linksYorhel1-0/+2
2019-11-02Add character cup size field + conversion + filterYorhel1-1/+1
2019-10-26Fix Wikipedia URLs with a question markYorhel1-2/+2
https://vndb.org/t2520.307
2019-10-16v2rw: Convert staff adding/editing formYorhel1-46/+3
This is the first major editing form to be converted, so I'm expecting a little breakage. A good chunk of this code has been copied from v3. In terms of the UI there has been a small change: aliases that are still referenced do not have the 'remove' link and instead have a flag that shows that they are still referenced. This ought to be a bit friendlier than throwing an error message after the user has submitted the form. Some other things I'd like to improve in this form: - BBCode preview - Pasting in external links and letting the form figure out the Pixiv ID, etc. - Or perhaps even: Integrate AniDB/Wikidata search/autocompletion.
2019-09-12VNDB::Types: Convert medium & resolutionYorhel1-1/+2
2019-09-03Add Pixiv ID to staff entriesYorhel1-1/+2
2019-09-03Fetch some more IDs from Wikidata + display IGDB & Pixiv linksYorhel1-0/+2
2019-09-01Add ErogeTrailers.com links to releasesYorhel1-1/+2
2019-09-01Add EGS links to releasesYorhel1-0/+1
2019-08-27Display Twitter links from Wikidata on producer pagesYorhel1-0/+1
2019-08-26Display shop+price info on VN pages + delete old affiliate codeYorhel1-10/+9
The current affiliate links format doesn't display as much information as before but it's also a lot less messy.
2019-08-26Display PlayAsia links on release pages + use crawled info to correct shop linksYorhel1-4/+6
2019-08-22Typo fix to make sure JAST USA link shows upYorhel1-1/+1
2019-08-22Add JAST USA links to releasesYorhel1-0/+1
2019-08-21Remove protocol from l_dmm linksYorhel1-1/+1
It's redundant, and normalization is actually easier when removed.
2019-08-21Add Itch.io links to releasesYorhel1-0/+1
2019-08-21Make some shop URLs configurableYorhel1-5/+5
This allows for easy insertion of affiliate referral tag.
2019-08-21Add DMM links to releasesYorhel1-0/+1
Full URL, because DMM has too many little sub-shops, and handling them all is a pain. I assume for now that a release is only in a single DMM shop.
2019-08-19Add Getchu links to releasesYorhel1-0/+2
2019-08-19Add Mangagamer.com links to releasesYorhel1-0/+1
MG has an all-ages section at / and an adult section at /r18/, but the adult section includes everything, so we'll just link to that. Maybe I'll write a bot that figures out the correct link, but it's not something we have to bother our users with.
2019-08-19Add Melonbooks.com links to releases + minor edit form reorgYorhel1-0/+1
2019-08-19Add Digiket.com links to releasesYorhel1-0/+1
2019-08-19Add Gyutto.com links to releasesYorhel1-0/+1
2019-08-17Add J-List links to releasesYorhel1-0/+1
2019-08-17Add Denpasoft links to releasesYorhel1-0/+1
2019-08-17Add GOG.com links to releasesYorhel1-0/+1
2019-08-17Add DLSite links to releasesYorhel1-2/+4
2019-08-16Add Steam links to releasesYorhel1-1/+7
2019-08-15Fix display of official homepage on producer pagesYorhel1-1/+2
2019-08-14Support multiple values for each wikidata propertyYorhel1-46/+43
This ended up being more common than I had expected, so let's properly handle it now.
2019-08-09entryLinks: Link Wikidata from all entriesYorhel1-1/+1
I should not be coding when tired. Keep missing all kinds of details.
2019-08-09Add VNStat linksYorhel1-0/+2
2019-08-09Replace Wikipedia links with Wikidata IDsYorhel1-1/+55
+ Automatically fetch other links from Wikidata
2019-07-15Add engine field to releasesYorhel1-1/+1
Fixes #4.
2019-07-08Add Producer/Staff/Seiyuu filters to Release/VN/Char filtersYorhel1-3/+3
This also abstracts and changes the tag/trait filter selection interface a little bit. Non-searchable tags/traits are now simply not listed anymore in the dropdown search.
2019-06-26Tags: Split "meta" field into "searchable" and "applicable"Yorhel1-1/+1
As discussed in https://vndb.org/t12507 TODO: - Same conversion for traits - Re-add mod ability to delete all votes for a particular tag?
2018-10-04Fix release filter compatibility with multiple resolutionsYorhel1-3/+7
Compatability is hard...
2018-10-02Fix release filter compatibility handling on VN browserYorhel1-16/+12
filFetchDB() is not used for the release filter on the VN browsing interface, so I've moved the compatibility stuff into a separate filCompat() method that can be called from Handler::VNBrowse.
2018-10-02DB: Convert resolution into an enumYorhel1-2/+14
Been wanting to do this for a long time - using an integer index into an array that changes once in a while is way too fragile. Doubly so when said indices are also used in filters and URLs that can't be updated every time a new resolution is added.
2018-05-25Add uncensored flag to release entriesYorhel1-1/+1
As discussed in https://vndb.org/t10665
2018-01-06Use the new BBCode parser in bbSubstLinks()Yorhel1-44/+21
2017-03-03Add date filters to VN searchYorhel1-1/+1
2015-12-30Add release filters to VN browserYorhel1-1/+1
2015-11-10Add 'has screenshots' filter to VN browserYorhel1-1/+1
2015-11-10Add language filter to staff browserYorhel1-1/+1
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-20 12:54:43 +0000