summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
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.
2018-01-06d7 updateYorhel1-0/+2
2018-01-06Release icons: Use disc image for UMDYorhel1-1/+1
https://vndb.org/t9992.21
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 tokenYorhel2-2/+7
2018-01-06Add bb2text() and use it for release notes & open graph tagsYorhel8-19/+70
2018-01-06Use the new BBCode parser in bbSubstLinks()Yorhel1-44/+21
2018-01-06Rewrite bb2html() to be more flexibleYorhel5-144/+418
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>
2018-01-05Release icons: Let's use cartridge icon for 'other' after allYorhel1-1/+1
This was already the case in the original patch, I broke it with the code style changes.
2018-01-05d10: Change tag guideline as per t10091Yorhel1-1/+1
2018-01-05Fix static file URL for release iconsYorhel1-1/+1
2018-01-05Code style changes to release icons codeYorhel2-83/+73
These are just style consistency changes, functionally equivalent.
2018-01-05Various fixes to the release icons featureYorhel4-5/+11
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.TigerShark19-1/+266
2017-12-31Multi::Maintenance: Update cron timingsYorhel1-4/+4
The database has grown and we're on SSDs now, so it's good to revisit these timings and see what needs optimizing, if anything.
2017-12-29SQL: Don't inherit trait/tag childs if parent is mentioned directlyYorhel1-2/+7
Should fix https://vndb.org/t10082
2017-12-29Experimenting with PostgreSQL 10: "UNENCRYPTED" keyword has been removedYorhel3-7/+7
2017-12-16Fix query debugging output with new TUWFYorhel1-4/+6
2017-12-09Add vndb-dev-server.pl, an autoreloading http serverYorhel4-2/+158
2017-12-09Add Docker configYorhel5-2/+147
2017-12-06Add instructions for running VNDB as standalone web serverYorhel3-27/+17
2017-11-26Add language: Bulgarian and Platforms: Nintendo Switch & Wii UYorhel6-2/+12
2017-11-25perms.sql: Revoke all permissions before re-assigningYorhel1-0/+2
This makes perms.sql the definitive place for all permissions assigned to these roles. The DROP OWNED does require superuser privileges, but that's alright - the statement is simply skipped when run as 'vndb'.
2017-11-25Remove broken SQL functions from Makefile + add install instructionsYorhel3-123/+57
2017-11-17Fix display of char measurements when only weight is knownYorhel1-1/+1
Fixes https://vndb.org/t2520.229
2017-11-17Fix typo in d11Yorhel1-3/+3
2017-08-14Some minor doc changesYorhel2-6/+15
2017-08-14API: Some additions to the "get *list" commandsYorhel2-16/+71
2017-08-14Remove useless NOT NULL in schema.sqlYorhel1-1/+1