summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler
AgeCommit message (Collapse)AuthorFilesLines
2018-10-02Fix release filter compatibility handling on VN browserYorhel1-0/+1
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 enumYorhel2-17/+12
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-10-01Lower the average vote requirement for tag spoilers a bitYorhel1-1/+2
https://vndb.org/t950.512
2018-09-29Add default spoiler level to tags and use it in spoiler calculationYorhel1-1/+5
https://vndb.org/t11296.3 (And I forgot to add update_20180929.sql in the previous commit)
2018-09-29Add default spoiler level to traits and use it on character editYorhel1-2/+7
https://vndb.org/t11296
2018-07-07Handler::Traits: Fix link in duplicate trait creationYorhel1-1/+1
https://vndb.org/t950.456
2018-06-19Add uncensored iconYorhel1-0/+2
Icon created by fuukanou: https://vndb.org/t10665.49 File size reduced a bit further by removing metadata and using scour Closes #3
2018-05-25Add uncensored flag to release entriesYorhel1-4/+15
As discussed in https://vndb.org/t10665
2018-05-25Add privacy policy page - happy GDPR dayYorhel1-0/+1
2018-04-12Handler::Chars: "Gender" -> "Sex"Yorhel1-2/+2
https://vndb.org/t10472
2018-04-08Char edit: Display linked VNs even if VN & releases have been deletedYorhel1-15/+6
There's still a glitch that, when a character is linked to a deleted release, the release selection will not show up in the form. But that's much easier to work around.
2018-03-27Add platform icons to VN screenshot listingYorhel1-0/+1
https://vndb.org/t950.416
2018-03-10Handler::Tags: Remember sort option when changing spoilers in VN listingYorhel1-3/+3
Fixes https://vndb.org/t2520.250
2018-03-04Allow decimal voting from /u+/votesYorhel1-5/+6
2018-02-24d8 is backYorhel1-0/+1
2018-02-09Increase VN page staff/cast cutoff thing to 200pxYorhel1-2/+2
https://vndb.org/t950.410
2018-02-08Store d+ pages in the DB as versioned entries + use markdownYorhel4-77/+190
This touches a bunch of things: - Adds a new first-class database entry type - Removes the d+.+.+ BBCode link syntax, adds a new d+#+ and d+#+.+ link syntax (references have been updated where possible) - Adds a new dependency on Text::MultiMarkdown
2018-02-07Use newline separation for producer aliasesYorhel1-6/+10
For consistency with the VN & character alias fields. It's also less ambiguous, as there are a few aliases that contain commas.
2018-01-13Handler::Chars: Fix setting of og:image tagYorhel1-1/+1
2018-01-12Don't allow unlikely short GTIN codesYorhel1-1/+1
Should fix https://vndb.org/t2520.237
2018-01-12Truly unique names for release icons and pushed those classes to the ↵TigerShark1-2/+2
inmediate container <abbr>.
2018-01-06Release filters: Fix handling of PC98 resolution iconYorhel1-0/+2
https://vndb.org/t9992.16
2018-01-06Add bb2text() and use it for release notes & open graph tagsYorhel5-9/+6
2018-01-05Fix static file URL for release iconsYorhel1-1/+1
2018-01-05Code style changes to release icons codeYorhel1-63/+55
These are just style consistency changes, functionally equivalent.
2018-01-05Various fixes to the release icons featureYorhel1-3/+6
It's been a while since I had static/f/ in git, so I had to adjust .gitignore a bit. The CSS changes are purely opinion, but it does integrate better with the existing layout. Everything else are bug fixes.
2018-01-05Add info icons for each release in vn page.TigerShark1-1/+64
2017-11-17Fix display of char measurements when only weight is knownYorhel1-1/+1
Fixes https://vndb.org/t2520.229
2017-06-15Fixup variable rename in last commitYorhel1-2/+2
2017-06-15Handler::Chars: Hide instances block when hidden by spoiler settingsYorhel1-2/+5
https://vndb.org/t950.339
2017-06-05Fix "All except characters" to show staffYorhel1-1/+1
Fixes https://vndb.org/t2520.222
2017-03-26Multi::RG: Remove unofficial relations from graph if #vns > 30Yorhel1-0/+1
This makes the relation graphs useful again for several large (mostly) independent graphs that are sometimes linked together by unofficial relations. e.g. https://vndb.org/t8985
2017-03-05Fix 500 when editing character entry without traitsYorhel1-1/+1
Fixes https://vndb.org/t2520.215
2017-03-03VNBrowse: Remember sort options when changing query or filtersYorhel1-2/+2
2017-03-03Don't allow deleted or unapproved traits to be linked to char entriesYorhel2-0/+4
Fixes https://vndb.org/t2520.213
2017-01-25Ignore duplicate board IDs in threat editYorhel1-1/+1
https://vndb.org/t2520.209
2017-01-25Disable links to AnimeNFO for the momentYorhel1-4/+5
https://vndb.org/t2520.210
2017-01-19Add Open Graph tags for the main page and vrspcflan6-8/+50
2016-11-27SQL: Use separate role for the website + disallow access to user dataYorhel1-32/+35
Previously the website was connected to the database with a "database owner" user, which has far too many permissions. Now there's a special vndb_site user with only the necessary permissions. The primary reason to do this is to decrease the impact if the site process is compromised. E.g. it's now no longer possible to delete or modify old entry revisions. An attacker can still do a lot of damage, however. Additionally (and this was the main reason to implement this change in the first place), the user sessions, passwords and email data is now not easily accessible anymore. Hopefully, the new user management abstractions will prevent email and password dumps in case of an SQL injection or RCE vulnerability in the site code. Of course, this only works if my implementation is fully correct and there's no privilige escalation vulnerability somewhere. Furthermore, changing your password now invalidates any existing sessions, and the password reset function is disabled for 'usermods' (because usermods can list email addresses from the database, and the password reset function could still allow an attacker to gain access to anyone's account). I also changed the format of the password reset tokens, as they totally don't need to be salted.
2016-11-03List deleted releases when adding a new releaseYorhel1-0/+23
2016-11-03Add duplicate check to producer entryYorhel1-6/+70
2016-10-16Support more than 100 characters per VNYorhel2-2/+2
2016-10-16VNPage: Add gender icons to character summaryYorhel1-0/+1
2016-07-31Handler::VNEdit: Fix bug with new staff/cast being removed on form errorYorhel1-6/+5
The names of the staff were fetched from the existing VN entry, so any newly added staff were not present in that list, and would thus not show up when the form validation failed. This fix makes sure to always fetch the required data from the database.
2016-07-03Generalize substring search relevance + apply to most dropdown searchesYorhel4-32/+6
This is a generalization of the search improvements made in 7da2edeaa0f6cf7794f4f8f68960497dc1be893c and 92235222dba4e5d0c7713d53ef12e0f10e371b83 And has been applied to the dropdown searches for producers, staff, tags and traits. For all those searches, exact matches are listed first, followed by prefix matches, and then substring matches. Relevance is currently only based on the primary name/title and ignores aliases (except for staff). This is fixable, but not trivial, and I'm not sure it's all that useful.
2016-07-03Charedit/traits: Prioritize exact match when finding traitsYorhel1-1/+13
2016-07-03Various staff search improvementsYorhel2-17/+22
- Exact match is now case-insensitive - Main staff search supports exact match with =-prefix - On VN edit dropdown: exact matches are sorted before other matches - VN edit dropdown now also displays original name
2016-07-02JS: Use alias ID in dropdown search to fix selectionYorhel1-1/+1
2016-07-02Validate release dates + move validation out of vndb.plYorhel1-1/+1
2016-06-05Fix typo on release page.Albin Bernhardsson1-1/+1