summaryrefslogtreecommitdiff
path: root/lib/VNDB
AgeCommit message (Collapse)AuthorFilesLines
2016-11-03Add duplicate check to producer entryYorhel3-12/+76
2016-10-16Support more than 100 characters per VNYorhel2-2/+2
2016-10-16VNPage: Add gender icons to character summaryYorhel1-0/+1
2016-09-18Suppress silly Perl 5.22 warnings about extra sprintf argsYorhel2-0/+2
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 searchesYorhel8-51/+40
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-03DB::Tags::dbTTTree: Use hash lookup for parent IDsYorhel1-3/+4
Reduces page load time of the trait index from 200ms to 20ms. Also provides a slight improvement for other tag/trait tree views.
2016-07-03Charedit/traits: Prioritize exact match when finding traitsYorhel2-2/+15
2016-07-03Various staff search improvementsYorhel3-19/+25
- 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-02Util::ValidateTemplates: Fix forgotten import of kv_validateYorhel1-0/+1
2016-07-02Validate release dates + move validation out of vndb.plYorhel3-1/+104
2016-06-05Fix typo on release page.Albin Bernhardsson1-1/+1
2016-04-11Handler::Discussions: Increase boards limitYorhel1-1/+1
2016-02-12Minor fixes / behaviour reverts related to the removal of L10NYorhel4-7/+7
- Fix mouse-over text of language flag on homepage - Capitalize release types in edit form - Use plural form of character roles on VN page listing
2016-01-26Handler::Misc: Fix perl warning on 404 */histYorhel1-1/+1
2016-01-23L10N: Remove all remaining traces of the interface translation featureYorhel2-410/+0
...unless I missed something.
2016-01-23L10N: Intern all VNDB::Handler::* stuffYorhel14-812/+911
Most of these replacements were automated. This ended up being less work than I had anticipated. I also fixed a few minor bugs along the way, but probably introduced more than I fixed.
2016-01-20L10N: Intern all VNDB::Util::* stuffYorhel16-269/+309
With some related edits in other parts of the code, mostly due to interface changes to htmlRevision() and htmlFormError(). Trivial replacements were automated by a super awesome script.
2016-01-19Move some VNDB::L10N stuff to VNDB::Func + intern VNDB::FuncYorhel15-102/+104
2016-01-18Fix display of spoiler in chartraits.js + warning in Handler/Chars.pmYorhel1-1/+1
2016-01-17L10N: Intern all Javascript strings and rename main JS fileYorhel1-1/+1
This has been mostly automated.
2016-01-17L10N: Intern blood_types/genders/(char|staff)_roles/discussion_boardsYorhel7-46/+41
I definitely needed the Tie::IxHash thing for these.
2016-01-17Use Tie::IxHash for some global.pl listsYorhel7-19/+20
This removes the reliance on sort() to provide meaningful ordering (the keys aren't always good for ordering) and removes the 'order' hack used for (vn|prod)_relations.
2016-01-17L10N: Intern VN/producer relations + update relation graphsYorhel3-12/+6
Now that graphviz knows the actual strings, it has a better opportunity to create better graphs. (Most of them still look messy tho)
2016-01-17L10N: Intern tag_cats/voiced/animated/*_statusYorhel7-57/+54
2016-01-16L10N: Intern languages/platforms/resolutions/media/ptype/rtype/vnlengthYorhel10-108/+100
2016-01-16L10N: Remove all translationsYorhel2-96/+3
TODO: Intern strings again to simplify the code. The immediate effect of this commit is that starting the util/vndb.pl script and generating the JS file is much faster now and that vndb.pl uses less memory. Translations have already been disabled on the main VNDB for a week now.
2016-01-14Handler::Discussions: Some search query normalization fixesYorhel1-0/+3
2016-01-10Add 'more'/'less' buttons to staff/character boxes on VN pagesYorhel1-2/+2
2016-01-10DB::Users: Perform case-insensitive email matchingYorhel1-1/+1
This fixes two things: - It's not possible to create two accounts with the same mail address with different case (although the user+xyz@domain trick still works). - The password reset form is now case-insensitive as well. Some people had problems with the case-sensitive behavior in the past.
2016-01-10Require current password on /u+/edit + only hash password once on /u+/setpassYorhel2-14/+31
2016-01-10DB::(VN|Producers): Don't decode_utf8() xml valuesYorhel2-4/+0
Newer versions of DBD::Pg do this automatically.
2015-12-31DB::Releases: Don't match non-patch fields for patch releasesYorhel1-6/+6
Fixes https://vndb.org/t950.210
2015-12-30Add release filters to VN browserYorhel9-33/+71
2015-11-28VNPage: Generalize seiyuu listing to character summary listingYorhel3-74/+80
The comment already suggested this: I wonder whether it's better to just ask database for character list instead of doing this manual group/sort So yeah, let's just do that.
2015-11-26Modified cast block layout.morkt1-18/+24
2015-11-26Handler::VNPage: Fix character listing tabYorhel1-1/+1
2015-11-26Handler::Discussions: Fix display of username when editing postYorhel1-1/+1
2015-11-26Handler::VNPage: Move staff tab into main VN page + some styling changesYorhel2-51/+24
The styling of the staff info can be a bit awkward at times, but it looks slightly better than a table, IMO. I didn't really know what to do with the the seiyuu info - it wastes a lot of screen space in its current implementation, but I can't think of anything better at the moment.
2015-11-26Handler::Releases: Fix bug when editing release with lots of VNsYorhel1-1/+1
2015-11-14DB::VN: Fix undeterministic ordering on tag score in VN listingsYorhel1-1/+1
2015-11-11Misc poll improvementsYorhel4-210/+173
- Merged polls table into threads table. Not much of a storage/performance difference, and it's a bit simpler this way. - Merged DB::Polls into DB::Discussions. Mainly because of the above change in DB structure. - Add option to remove an existing poll. - Allow preview and recast to be changed without deleting the votes - Set preview option by default. Because personal preferences. :) - Minor form validation differences
2015-11-10Merge branch 'poll' of https://github.com/morkt/vndb into pollsYorhel4-1/+259
2015-11-10various fixes.morkt1-45/+46
2015-11-10Show full date/time at edit history and thread listingsYorhel2-2/+2
Having the time display is quite useful. It does make the listings look more cluttered, but meh.
2015-11-10Merge branch 'master' into pollmorkt24-592/+669
2015-11-10Add 'has screenshots' filter to VN browserYorhel1-1/+1
2015-11-10Add language filter to staff browserYorhel2-1/+2
2015-11-02DB::VN: Fix dbVNHasStaff() query when VN has only seiyuu and no staffYorhel1-1/+1