summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2018-10-31VNEdit: Remove "import cast" functionalityYorhel3-57/+1
https://vndb.org/t950.521
2018-10-29Add U+201C to search normalize removalalto1-1/+1
2018-10-28Ignore hidden-by-CSS NSFW images in next/prev in image viewerYorhel1-1/+1
Broken in 0687115f99 Fixes https://vndb.org/t2520.277 The JS check is based on https://makandracards.com/makandra/1339-check-whether-an-element-is-visible-or-hidden-with-javascript
2018-10-28Code style: Keep the HTML structure explicit and indentation correctYorhel1-5/+3
2018-10-28Add JS-less NSFW screenshot togglezx143-23/+12
(cherry picked from commit 6446d7d185543440b97be009fdf2a1f0c379b26f)
2018-10-28Fix titles with commas getting truncated in VN relation tablealto1-1/+3
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 togglezx143-31/+35
2018-10-21Add curl to Dockerfile installationYorhel1-0/+1
Fixes #11
2018-10-07Handler::(Tags|Traits): Remember spoiler/filter settings when changing the otherYorhel2-3/+5
https://vndb.org/t950.517
2018-10-06Add 960x640 resolutionYorhel3-1/+3
https://vndb.org/t950.514
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 enumYorhel9-43/+83
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 bitYorhel2-2/+3
https://vndb.org/t950.512
2018-09-29Add default spoiler level to tags and use it in spoiler calculationYorhel5-17/+28
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 editYorhel6-9/+16
https://vndb.org/t11296
2018-08-12Add 1600x900 resolutionYorhel2-0/+4
https://vndb.org/t950.481 Also, the resolution should really be stored as an ENUM in the database, this integer thing is waay too fragile.
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-07-06CSS: Some minor fixes after font size increaseYorhel1-4/+4
2018-06-23CSS: Increase font size a bitYorhel1-33/+32
I'm sure this breaks styling of a few things, I'll adjust those as I find them.
2018-06-19Add uncensored iconYorhel2-0/+4
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-06-03Add development DB dump, remove old devdb, convert README to markdownYorhel9-553/+358
2018-05-25Add uncensored flag to release entriesYorhel7-15/+42
As discussed in https://vndb.org/t10665
2018-05-25Add privacy policy page - happy GDPR dayYorhel2-0/+5
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-05-03Docker: Update to Ubuntu Bionic + Postgres 10 !ACTION REQUIRED!Yorhel2-5/+5
If you don't really care about the data in your Docker's Postgres DB, then you can just update with: docker volume rm vndb-data docker volume create --name vndb-data docker build --pull --no-cache -t vndb . If you do want to keep your data, the process is roughly as follows: - Do a pg_dumpall from your current docker image to save the data. - Run the above commands to upgrade - Import the database in the new docker image (cherry picked from commit c278eec720b78624580f844d8289ddb575035138)
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-18Fix Docker init script for Mac + add some spacing around vndb-dev-server.pl ↵Yorhel2-10/+20
output
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+/votesYorhel2-21/+52
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 markdownYorhel38-3537/+428
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 aliasesYorhel4-8/+19
For consistency with the VN & character alias fields. It's also less ambiguous, as there are a few aliases that contain commas.
2018-02-04SQL: Load permissions after creating sequencesYorhel1-4/+4
Otherwise the vndb_site/_multi users won't have usage rights on those. Fixes https://vndb.org/t10218.6
2018-02-04Add "development database" for quick setup & testing purposesYorhel4-0/+369
+ a bit of tooling to make it work. The database was contributed by tigershark, with a few minor additions by me.
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 ↵TigerShark2-7/+9
inmediate container <abbr>.
2018-01-12vndb-dev-server.pl: Properly propagate connection closeYorhel1-2/+2
Should fix https://vndb.org/t9425.11
2018-01-08BBCode: Fix parsing of tags in [something[url=..]Yorhel2-9/+11
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.