summaryrefslogtreecommitdiff
path: root/lib
AgeCommit message (Collapse)AuthorFilesLines
2019-05-16Add password dictionary checkYorhel4-15/+213
This affects the following: - API login with a weak password is disallowed, affected users will have to change their password through the website to continue using the API. - Registration, password reset or password change forms require the new password to not be in the dictionary. - Attempting to log in to the website with a weak password will force-redirect to a password change form, allowing a new password to be set (using the weak-but-still-valid password as check).
2019-05-15Loosen restrictions on passwords a bitYorhel1-6/+6
Maximum length increased from 64 to 500 characters, and all Unicode characters are now allowed.
2018-12-06DB::Chars: Fix SQL operator precedence bug in search filterYorhel1-1/+1
This would cause other filters to sometimes be ignored, depending on the order in which the %where hash was being serialized. https://vndb.org/t11605.3 Broken in 8802eac4f.
2018-12-06Increase maximum post board lengthYorhel1-1/+1
2018-12-06Handler::Chars: Retain filters when switching initial characterYorhel1-1/+1
https://vndb.org/t11605
2018-11-07Fix "make" after removal of tagops.jsYorhel1-1/+0
2018-11-04JS-less tag visibility toggleszx141-17/+38
2018-11-02Change Multi to use separate setting for db_login and to use UNIX socket for ↵alto1-4/+1
Postgres Update README with basic information on Multi (cherry picked from commit 01188a82ab736a8975c73ac5ec12621426bf6bf2)
2018-10-31VNEdit: Remove "import cast" functionalityYorhel2-22/+1
https://vndb.org/t950.521
2018-10-29Add U+201C to search normalize removalalto1-1/+1
2018-10-28Code style: Keep the HTML structure explicit and indentation correctYorhel1-5/+3
2018-10-28Add JS-less NSFW screenshot togglezx141-4/+9
(cherry picked from commit 6446d7d185543440b97be009fdf2a1f0c379b26f)
2018-10-27VNPage: Hide vote dropdown when nothing has been released yetYorhel1-3/+9
This is a lazy implementation - it doesn't fully prevent voting on unreleased VNs, but it makes it much harder to do so by accident. Fixes #5
2018-10-25DB::Releases: Don't return duplicate releases in dbReleaseGet(vid => [...])Yorhel1-2/+1
In the special case where the releases of multiple VNs are requested, and those VNs have releases in common, dbReleaseGet() would return those releases multiple times. Using a JOIN in order to filter rows isn't safe if the join condition isn't unique - so use an "id IN(SELECT ..)" filter instead. (I found this while editing c15068 and noticing that some releases were listed twice in the edit form. Editing that entry without manually removing those duplicates would trigger an internal server error due to duplicate relations)
2018-10-23Add JS-less NSFW togglezx141-10/+17
2018-10-07Handler::(Tags|Traits): Remember spoiler/filter settings when changing the otherYorhel2-3/+5
https://vndb.org/t950.517
2018-10-04Fix release filter compatibility with multiple resolutionsYorhel1-3/+7
Compatability is hard...
2018-10-02Fix release filter compatibility handling on VN browserYorhel2-16/+13
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 enumYorhel4-20/+27
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 calculationYorhel2-6/+10
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 editYorhel2-6/+11
https://vndb.org/t11296
2018-08-01Also normalize Turkish ı in VN searchYorhel1-0/+1
This also handles the uppercase İ, as that is already converted to lowercase ı in an earlier step.
2018-07-14Some VN search normalization improvementsYorhel1-9/+9
https://vndb.org/t2520.265 - 270.
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-06-13Multi::API: Add "get characters instances"Yorhel1-1/+17
2018-05-25Add uncensored flag to release entriesYorhel3-11/+23
As discussed in https://vndb.org/t10665
2018-05-25Add privacy policy page - happy GDPR dayYorhel1-0/+1
2018-05-24DB::Chars: Ignore spaces when matching original namesYorhel1-1/+1
https://vndb.org/t950.432
2018-05-24Multi::APIDump: Fix boolifycation of "meta" in tags & traits dumpsYorhel1-2/+2
https://vndb.org/t2520.259
2018-05-12API: Make username in login command case-insensitiveYorhel1-0/+2
https://vndb.org/t3599.201
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 markdownYorhel11-112/+270
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 codesYorhel3-2/+3
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-08BBCode: Fix parsing of tags in [something[url=..]Yorhel1-5/+5
https://vndb.org/t2520.233 The old bb2html() blindly replaced [url=..] anywhere inside the matched token, and did not require that the [url=..] was itself the token. I've made the tag matching more strict to make sure that [something[url=..] is now properly tokenized. This also affects other tags, so it's likely that there's some input that the old bb2html() would still have handled differently.
2018-01-06Release filters: Fix handling of PC98 resolution iconYorhel1-0/+2
https://vndb.org/t9992.16
2018-01-06BBCode: Fix word boundary check when dblink is the first tokenYorhel1-2/+2
2018-01-06Add bb2text() and use it for release notes & open graph tagsYorhel7-11/+31
2018-01-06Use the new BBCode parser in bbSubstLinks()Yorhel1-44/+21
2018-01-06Rewrite bb2html() to be more flexibleYorhel4-144/+233
This is based on the API that I described in https://vndb.org/t5564.12 It's mostly bug-compatible with the old bb2html(), main differences: - <br /> -> <br> for no reason - Doesn't sporadically add a wrong </div> - $rmwhitespace now also after [/code] Most of the test cases were contributed by flan <flan@flande.re>