Age | Commit message (Collapse) | Author | Files | Lines | |
---|---|---|---|---|---|
2017-11-17 | Fix display of char measurements when only weight is known | Yorhel | 1 | -1/+1 | |
Fixes https://vndb.org/t2520.229 | |||||
2017-08-14 | API: Some additions to the "get *list" commands | Yorhel | 1 | -6/+16 | |
2017-06-21 | API: Various additions | Yorhel | 1 | -2/+18 | |
2017-06-15 | Fixup variable rename in last commit | Yorhel | 1 | -2/+2 | |
2017-06-15 | Handler::Chars: Hide instances block when hidden by spoiler settings | Yorhel | 1 | -2/+5 | |
https://vndb.org/t950.339 | |||||
2017-06-05 | Fix "All except characters" to show staff | Yorhel | 1 | -1/+1 | |
Fixes https://vndb.org/t2520.222 | |||||
2017-05-25 | API: Add some hidden checks to staff stuff | Yorhel | 1 | -4/+11 | |
2017-05-22 | API: Add some flags to query staff/seiyuu data | Yorhel | 1 | -0/+47 | |
2017-04-28 | API: Made a start on "get staff" support | Yorhel | 1 | -0/+75 | |
2017-03-26 | Multi::RG: Fix inverse check for non-official relations | Yorhel | 1 | -1/+1 | |
2017-03-26 | Multi::RG: Remove unofficial relations from graph if #vns > 30 | Yorhel | 2 | -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-05 | Fix 500 when editing character entry without traits | Yorhel | 1 | -1/+1 | |
Fixes https://vndb.org/t2520.215 | |||||
2017-03-03 | Add date filters to VN search | Yorhel | 2 | -2/+7 | |
2017-03-03 | VNBrowse: Remember sort options when changing query or filters | Yorhel | 1 | -2/+2 | |
2017-03-03 | API: Add traits filter to get character | Yorhel | 1 | -0/+4 | |
2017-03-03 | Don't allow deleted or unapproved traits to be linked to char entries | Yorhel | 2 | -0/+4 | |
Fixes https://vndb.org/t2520.213 | |||||
2017-02-20 | APIDump: Add votes2.gz with dates, update sizes in d14 | Yorhel | 1 | -1/+9 | |
2017-02-20 | Multi::IRC: Whitelist c64 in id detection | Yorhel | 1 | -1/+1 | |
2017-01-29 | IRC: Remove eval command | Yorhel | 1 | -9/+0 | |
I never use it. And it's scary. | |||||
2017-01-25 | Ignore duplicate board IDs in threat edit | Yorhel | 1 | -1/+1 | |
https://vndb.org/t2520.209 | |||||
2017-01-25 | Disable links to AnimeNFO for the moment | Yorhel | 1 | -4/+5 | |
https://vndb.org/t2520.210 | |||||
2017-01-25 | API: Fix Unicode password login + some messages | Yorhel | 1 | -3/+3 | |
2017-01-21 | Don't omit metadata with a value of '0' | flan | 1 | -1/+1 | |
2017-01-19 | Add Open Graph tags for the main page and vrspc | flan | 7 | -10/+70 | |
2016-12-04 | API: Add username filter to "get user" + d11 updates | Yorhel | 1 | -0/+5 | |
2016-11-27 | SQL: Use separate role for Multi2.26 | Yorhel | 1 | -25/+24 | |
2016-11-27 | SQL: Use separate role for the website + disallow access to user data | Yorhel | 3 | -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-03 | List deleted releases when adding a new release | Yorhel | 2 | -5/+29 | |
2016-11-03 | Add duplicate check to producer entry | Yorhel | 3 | -12/+76 | |
2016-10-16 | Support more than 100 characters per VN | Yorhel | 2 | -2/+2 | |
2016-10-16 | VNPage: Add gender icons to character summary | Yorhel | 1 | -0/+1 | |
2016-10-16 | Doc update + IRC bot language fix | Yorhel | 1 | -1/+1 | |
2016-09-18 | Suppress silly Perl 5.22 warnings about extra sprintf args | Yorhel | 3 | -0/+3 | |
2016-09-11 | API: Add VN relations "official" field | Yorhel | 1 | -5/+2 | |
2016-09-11 | Fix http->https in d14 + increase IRC quote spam interval | Yorhel | 1 | -1/+1 | |
2016-08-31 | API: Add simple "get user" command | Yorhel | 1 | -4/+24 | |
2016-07-31 | Handler::VNEdit: Fix bug with new staff/cast being removed on form error | Yorhel | 1 | -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-31 | API: Support array mathing in "get character" vn filter | Yorhel | 1 | -0/+1 | |
2016-07-03 | Generalize substring search relevance + apply to most dropdown searches | Yorhel | 8 | -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-03 | DB::Tags::dbTTTree: Use hash lookup for parent IDs | Yorhel | 1 | -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-03 | Charedit/traits: Prioritize exact match when finding traits | Yorhel | 2 | -2/+15 | |
2016-07-03 | Various staff search improvements | Yorhel | 3 | -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-02 | JS: Use alias ID in dropdown search to fix selection | Yorhel | 1 | -1/+1 | |
2016-07-02 | Util::ValidateTemplates: Fix forgotten import of kv_validate | Yorhel | 1 | -0/+1 | |
2016-07-02 | Validate release dates + move validation out of vndb.pl | Yorhel | 3 | -1/+104 | |
2016-06-19 | API: Add "tags" filter to "get vn" + increase throttle throttle | Yorhel | 1 | -4/+8 | |
2016-06-12 | API: Increase some limits + set custom TCP keepalive values | Yorhel | 1 | -3/+15 | |
2016-06-05 | Fix typo on release page. | Albin Bernhardsson | 1 | -1/+1 | |
2016-05-15 | API: Allow sorting 'get vn' on stats fields | Yorhel | 1 | -1/+4 | |
2016-04-11 | API: Added "vns" flag and member to "get character" | Yorhel | 1 | -0/+9 | |