Age | Commit message (Collapse) | Author | Files | Lines | |
---|---|---|---|---|---|
2017-12-31 | Multi::Maintenance: Update cron timings | Yorhel | 1 | -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-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-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 | 1 | -9/+27 | |
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-03 | API: Add traits filter to get character | Yorhel | 1 | -0/+4 | |
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 | API: Fix Unicode password login + some messages | Yorhel | 1 | -3/+3 | |
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-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 | 1 | -0/+1 | |
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 | API: Support array mathing in "get character" vn filter | Yorhel | 1 | -0/+1 | |
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-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 | |
2016-01-29 | Multi::API: added 'screens' flag to 'get vn' | Yorhel | 1 | -0/+18 | |
2016-01-17 | Use Tie::IxHash for some global.pl lists | Yorhel | 1 | -6/+6 | |
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-17 | L10N: Intern VN/producer relations + update relation graphs | Yorhel | 1 | -10/+13 | |
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-16 | L10N: Intern languages/platforms/resolutions/media/ptype/rtype/vnlength | Yorhel | 1 | -4/+4 | |
2016-01-10 | Multi::IRC: Make sure we keep our nick | Yorhel | 1 | -0/+18 | |
2016-01-10 | Multi::Anime: Regularly resolve the AniDB API DNS | Yorhel | 1 | -15/+26 | |
The API IP address doesn't change often, but we don't want months of downtime when it does. | |||||
2015-12-29 | Multi::API: Add support for TLS | Yorhel | 1 | -8/+23 | |
2015-11-26 | Multi::IRC: Fix auth bypass bug + make !quote admin-only | Yorhel | 1 | -2/+2 | |
2015-11-01 | Switch to HTML5 doctype + s/acronym/abbr/ + s/ / /e | Yorhel | 1 | -5/+3 | |
I'd have preferred to stick with XHTML 1.0, but unfortunately browsers won't allow you to use modern Javascript APIs with an older doctype. Note that most pages don't actually validate correctly as HTML5, I'm relying on browsers to be lenient. In either case, I'd like VNDB to stay valid XML (XHTML5, then), and luckily that shouldn't be a problem. | |||||
2015-11-01 | Removed support for sha256-hashed passwords | Yorhel | 1 | -5/+1 | |
They had to be deleted from the database at some point, otherwise we still have thousands of easily-cracked password hashes in the database. Note that I could have opted to use scrypt on top of the sha256 hashes so the passwords would remain secure without needing to reset everything, but doing that after one year of switching to scrypt is likely not worth it. Everyone who still actively uses his account has already been converted to scrypt, everyone else should just reset their password whevener they decide to come back. | |||||
2015-10-25 | Multi::Anime: Avoid dead state when trying to fetch anime info | Yorhel | 1 | -2/+2 | |
Turns out the anime data hasn't been updated in a few months. Oops. | |||||
2015-10-21 | SQL: Fix Multi to use the new DB schema | Yorhel | 5 | -163/+145 | |
That should be the last thing to convert to the new schema. | |||||
2015-10-12 | Notifications: Allow max 500 notifies per user + add SQL index on uid | Yorhel | 1 | -0/+2 | |
Turns out that fetching whether or not you have unread notifications (done on every pageview if you're logged in) was pretty slow. The index speeds up both that query and the "my notifications" view. The extra purge for old notifications for users with more than 500 notifications ensures that the index stays effective for the unread notifications count. Otherwise it'll have to read half of the notifications table anyway to check the 'unread' filter. | |||||
2015-09-08 | Multi::API: Set keepalive on sockets to detect dead TCP connections | Yorhel | 1 | -0/+1 | |
Hopefully prevents issues like https://vndb.org/t3599.53 | |||||
2015-07-21 | Multi::API: Support IPv6 | Yorhel | 1 | -1/+5 | |
This was more trivial than I had expected. I already took ipv6 into account when rewriting the API for AnyEvent (including the use of norm_ip()), so that part was fine. The only part I had to fix was the listening socket, and I had to ensure that the $c->{ip} was correct. The first was easy, and the latter was properly handled by AnyEvent automatically. Looks like AnyEvent automatically 'unpacks' IPv4-mapped IPv6 addresses, so I didn't have to deal with that myself. | |||||
2015-07-20 | Multi::API: Throttle "throttled" error replies | Yorhel | 1 | -3/+13 | |
This is to save system resources when a misbehaving client keeps sending commands while it's being throttled. It also protects against trivial DoS attacks. | |||||
2015-07-18 | Multi::Maintenance: Fix bug in calculating timer for monthly cron | Yorhel | 1 | -1/+1 | |
AE::timer accepts a time interval as argument, not a complete timestamp. So the monthly cron job hasn't run in a while... | |||||
2015-06-21 | Multi::IRC: Increase delay between random quotes | Yorhel | 1 | -1/+1 | |
2015-06-15 | Multi::IRC: Some fixes wrt. chat logging | Yorhel | 1 | -8/+6 | |
2015-05-13 | Add staff statistic to main menu | Yorhel | 1 | -0/+1 | |
2015-05-11 | Multi::{Core,Anime}: More fixes regarding UTF-8 | Yorhel | 2 | -11/+14 | |
2015-04-29 | Multi::(API:IRC): Fix some unicode handling issues | Yorhel | 2 | -6/+8 | |
I forgot that AnyEvent::Handle works with bytes rather than unicode strings, even though that is kind of obvious. I expected that AnyEvent::IRC would automatically handle the conversion between byte strings and Unicode strings, but it doesn't, so that has to be done manually. | |||||
2015-04-27 | Multi::IRC: Properly handle connection issues | Yorhel | 1 | -5/+28 | |
2015-04-27 | Multi::Core: Make log level configurable | Yorhel | 1 | -1/+1 | |
I probably don't want to have the 'trace' log level on the actual server. | |||||
2015-04-27 | Multi::API: Fixed various bugs found while testing | Yorhel | 1 | -4/+7 | |
Ugh I wish I had proper unit tests. Ugh writing proper unit tests is a loooot more work than just doing a bunch of quick manual tests. |