summaryrefslogtreecommitdiff
path: root/lib
AgeCommit message (Collapse)AuthorFilesLines
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>
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-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-16Fix query debugging output with new TUWFYorhel1-4/+6
2017-11-17Fix display of char measurements when only weight is knownYorhel1-1/+1
Fixes https://vndb.org/t2520.229
2017-08-14API: Some additions to the "get *list" commandsYorhel1-6/+16
2017-06-21API: Various additionsYorhel1-2/+18
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-05-25API: Add some hidden checks to staff stuffYorhel1-4/+11
2017-05-22API: Add some flags to query staff/seiyuu dataYorhel1-0/+47
2017-04-28API: Made a start on "get staff" supportYorhel1-0/+75
2017-03-26Multi::RG: Fix inverse check for non-official relationsYorhel1-1/+1
2017-03-26Multi::RG: Remove unofficial relations from graph if #vns > 30Yorhel2-9/+28
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-03Add date filters to VN searchYorhel2-2/+7
2017-03-03VNBrowse: Remember sort options when changing query or filtersYorhel1-2/+2
2017-03-03API: Add traits filter to get characterYorhel1-0/+4
2017-03-03Don't allow deleted or unapproved traits to be linked to char entriesYorhel2-0/+4
Fixes https://vndb.org/t2520.213
2017-02-20APIDump: Add votes2.gz with dates, update sizes in d14Yorhel1-1/+9
2017-02-20Multi::IRC: Whitelist c64 in id detectionYorhel1-1/+1
2017-01-29IRC: Remove eval commandYorhel1-9/+0
I never use it. And it's scary.
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-25API: Fix Unicode password login + some messagesYorhel1-3/+3
2017-01-21Don't omit metadata with a value of '0'flan1-1/+1
2017-01-19Add Open Graph tags for the main page and vrspcflan7-10/+70
2016-12-04API: Add username filter to "get user" + d11 updatesYorhel1-0/+5
2016-11-27SQL: Use separate role for Multi2.26Yorhel1-25/+24
2016-11-27SQL: Use separate role for the website + disallow access to user dataYorhel3-135/+170
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 releaseYorhel2-5/+29