Age | Commit message (Collapse) | Author | Files | Lines | |
---|---|---|---|---|---|
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. | |||||
2015-04-27 | Multi::API: Fix bug when querying stuff while logged in | Yorhel | 1 | -1/+1 | |
2015-04-27 | Multi::API: Fully implement the 'set' command with AnyEvent | Yorhel | 1 | -58/+59 | |
2015-04-27 | Multi::API: Fully implement 'get' command with AnyEvent | Yorhel | 2 | -510/+317 | |
2015-04-27 | Multi: Backport staff database changes from master branch | Yorhel | 2 | -7/+14 | |
Includes changes from 5926ce95395976456c0e15895d13491a81819087 and e20b19ce400ccf382a969a51777e0678ff8d44db | |||||
2014-12-21 | Multi: WIP Converting Multi::API to AnyEvent | Yorhel | 2 | -669/+636 | |
2014-10-31 | Multi::IRC: Converted to use AnyEvent | Yorhel | 2 | -525/+379 | |
It's not as fully featured as the previous implementation, but most of those features haven't been used for the past few years anyway. Also added a generic throttle implementation in Multi::Core, which can be re-used for the API. | |||||
2014-10-29 | Multi: Use AnyEvent::Pg's last_query_start_time() | Yorhel | 1 | -1/+2 | |
The solution that has been implemented upstream is a little different from my patch, but it works well. | |||||
2014-10-28 | Multi: More convenient error handling for one-shot queries | Yorhel | 2 | -10/+20 | |
2014-10-24 | Multi::Anime: Converted to use AnyEvent | Yorhel | 1 | -172/+176 | |
2014-10-22 | Multi::RG: Converted to use AnyEvent | Yorhel | 2 | -196/+190 | |
AnyEvent::Util::run_cmd() is a godsent. POE was such a hassle in that area. | |||||
2014-10-22 | Multi::APIDump: Converted to use AnyEvent | Yorhel | 1 | -94/+61 | |
2014-10-22 | Multi::Maintenance: Converted to use AnyEvent | Yorhel | 3 | -212/+152 | |
2014-10-22 | Multi: Add pg_cmd function for more robust error handling | Yorhel | 2 | -20/+49 | |
2014-10-22 | Multi::Feed: Log SQL times | Yorhel | 1 | -5/+4 | |
Requires a patch to AnyEvent::Pg: https://rt.cpan.org/Ticket/Display.html?id=99719 |