vndb - Source code of VNDB.org

Age	Commit message (Collapse)	Author	Files	Lines
2017-11-17	Fix typo in d11	Yorhel	1	-3/+3

2017-08-14	Some minor doc changes	Yorhel	2	-6/+15

2017-08-14	API: Some additions to the "get *list" commands	Yorhel	2	-16/+71

2017-08-14	Remove useless NOT NULL in schema.sql	Yorhel	1	-1/+1

2017-07-17	Makefile: Ensure static/f directory exists	Yorhel	1	-7/+7
	Fixes a 'make' on a clean checkout
2017-06-21	API: Various additions	Yorhel	2	-5/+69

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-06-01	Add script to remove unused images	Yorhel	1	-0/+108
	This saves about 1GiB.
2017-05-28	Fix Saturn icon size	Yorhel	1	-0/+0

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	2	-0/+103

2017-04-30	d13: Add ShareX guide	Yorhel	1	-2/+22
	Draft text & screenshots provided by https://vndb.org/u118842
2017-04-28	API: Made a start on "get staff" support	Yorhel	2	-0/+216

2017-04-28	Replace d13 image links with self-hosted ones	Yorhel	1	-3/+3
	Yes I abused the screenshot-uploading trick rather than storing those images on the git repo. I'd rather not have many images in git.
2017-04-21	Add 1366x768 resolution	Yorhel	2	-0/+4
	https://vndb.org/t950.317
2017-03-26	Multi::RG: Fix inverse check for non-official relations	Yorhel	1	-1/+1

2017-03-26	d5: Fix spelling error	Yorhel	1	-1/+1
	Reported at https://vndb.org/t2520.217
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	3	-3/+11

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	2	-0/+23

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	2	-9/+17

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-29	Fix HTML error on d11	Yorhel	1	-1/+2

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	8	-10/+71

2017-01-19	Change the default DB username to "vndb_site" to match changes from 6a04b32	flan	1	-1/+1

2016-12-04	API: Add username filter to "get user" + d11 updates	Yorhel	2	-61/+24

2016-12-01	SQL: Fix adding vndb_multi role and grant on rlists	Yorhel	2	-1/+4

2016-11-27	SQL: Use separate role for Multi2.26	Yorhel	3	-27/+93

2016-11-27	SQL: Use separate role for the website + disallow access to user data	Yorhel	9	-139/+377
	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	2	-2/+8

2016-09-18	Suppress silly Perl 5.22 warnings about extra sprintf args	Yorhel	4	-2/+5

2016-09-11	API: Add VN relations "official" field	Yorhel	2	-6/+5

2016-09-11	Fix http->https in d14 + increase IRC quote spam interval	Yorhel	2	-4/+4

2016-08-31	API: Add simple "get user" command	Yorhel	2	-4/+72

2016-08-09	Add Croatian language	Yorhel	4	-1/+6

2016-07-31	SQL: Improve trait cache update from 206 to 16 seconds	Yorhel	3	-4/+12
	VNDB tends to get unresponsive for a few minutes when the daily cron is run. This should help somewhat.