summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
33 hoursFix searchtabs taking over the query when switching tabsHEADmasterYorhel2-1/+14
Fixes https://vndb.org/t2520.505
7 daysChars::Page: "Hip" -> "Hips" for consistencyYorhel1-1/+1
https://vndb.org/t2520.504
8 daysv2rw: Convert producers listing & searchYorhel3-60/+63
Now featuring full pagination & flexible columns.
8 daysreviews: Fix vote calculation when uid=NULLYorhel1-2/+2
The anonymous votes ended up not getting counted at all.
9 daysimgflag: Experiment with making average calculation more conservativeYorhel1-2/+4
If an imgmod voted a more conservative option than the average, then the imgmod's vote will be used as average. This is to catch cases where most voters didn't notice a subtle suggestive or explicit part of the image. I mean, if a mod votes more conservative, they must be on to something.
9 daysreviews: Actually, use norm_ip() here rather than raw IPsYorhel3-3/+3
To not make it ~too~ easy to get fake votes in. (On the other hand, this may leak people's votes to other people on the same ISP. Sorry about that. That risk also exists without norm_ip() if people have dynamic IPs.)
9 daysreviews: Allow anonymous voting + display overrule countingYorhel10-20/+20
Anonymous votes count for 0.01, regular votes for 1 and overrule votes for 1000. It's a bit crude, but ought to do the job. Reason for this change is that most reviews don't seem to get any votes at all. With this anonymous voting we can do some sort of scoring/ordering even with potentially less reliable votes.
11 daysnotifications: Add subscribing for (un)applications of traitsYorhel7-18/+48
11 daysReviews::Page: Add some space before the voteYorhel1-1/+1
Fixes https://vndb.org/t2520.500
2020-10-08notifications: Add subscription management UI + finalize DB migrationYorhel7-9/+179
Seems to be working so far. I'll find the actual bugs in production.
2020-10-07notifications: Mark as read when opening page + delete when deleting ↵Yorhel9-16/+46
posts/reviews The mark as read functionality was already present in some form for threads, but is now made consistent among all notification types. This removes the need for the redirect from the notification listing. The deletion of notifications is intended to avoid pointless notifications, especially in case of spam.
2020-10-07notifications: Add backend for subscriptions and new notification typesYorhel7-17/+108
+ (un)subscription for new posts/edits on individual threads, reviews and DB entries. + Subscribing to VNs to get notifications for new reviews. + The users.notify_posts setting now also includes comments on reviews the user has commented on. While this is all very nice and such, it's just the data model and backend. The hard part is the user interface.
2020-10-05notifications: Consolidate and simplify creation of notificationsYorhel6-177/+142
Preparing to extend the notification types, but with the old individual-trigger-for-each-type that would easily turn into an unmanagaeble mess. The new approach also correctly handles events that may trigger multiple notification types. Also removed the title and uid cache from the notifications table, they don't simplify things and aren't necessary for performance. On the other hand, doing a generic information lookup for vndbids is kind of annoying. I now wrote an item_type() function to help with that, but it's not sufficient to solve the broader problem. One regression(?): Users will keep getting notifications for new posts on threads even if they haven't read older notifications for the same thread yet. I /think/ this behavior is more intuitive and expected, so maybe I'll keep it. (And possibly more regressions as well, who knows...)
2020-10-04Reviews::VNTab: Move "Full review" button to "Read more" after the summaryYorhel1-2/+1
2020-10-03Tagmod: Remove title attribute of comment buttonYorhel1-1/+0
No need when it's repeated right next to the button, anyway. https://vndb.org/t2520.497
2020-10-02v2rw: Move redirects + cleanup some moreYorhel5-71/+45
2020-10-01VNEdit: Upload screenshots one-by-one to preserve id orderYorhel1-10/+25
Attempt to fix https://vndb.org/t2520.494
2020-09-30TraitEdit: Fix setting of group columnYorhel1-3/+3
2020-09-30Fix old reference to VNWeb::Tags::*Yorhel1-1/+1
2020-09-30refactoring: Merge Tags/ and Traits/ into TT/Yorhel9-37/+30
There ended up being more code reuse than I had expected. The only functionality that's still missing is the main tag/trait pages themselves, but I think they're similar enough to share code as well. (I might even be able to merge TagEdit & TraitEdit, but that'll be a more involved change)
2020-09-30v2rw/Tags::Index: Re-use tag index for trait indexYorhel4-109/+53
This code is pretty easy to re-use.
2020-09-30v2rw/Tags::Index: Rewrite the tag indexYorhel2-79/+117
Nothing new, but I do see more avenues for consolidation with traits.
2020-09-29v2rw/Tag::List: Re-use tag listing to implement trait listingYorhel3-94/+28
Duplicating that code was really too much, the listings are way too similar.
2020-09-29TagEdit/TraitEdit: Bump "added" date on approvalYorhel3-6/+5
This functionality was also present in the old forms. (+ irrelevant cleanup in TagEdit.elm)
2020-09-29v2rw/TraitEdit: Rewrite trait edit form + cleanup bunch of old codeYorhel7-553/+351
This was the last form in the old v2 code, so this allowed me to get rid of the old form validation and generation abstractions. The form is mostly a duplicate of the tag editing form, as expected. It's really annoying to have to maintain pretty much duplicate code for tags and traits, but there are just enough differences that the complexity of sharing code or creating a new abstraction outweigh the benefits. :(
2020-09-27Report: Add option to report NSFW imageYorhel1-1/+6
Images can't be reported directly, yet, but this ought to help as well.
2020-09-27v2rw/Tags::List: Re-implement & improve the tag listYorhel4-72/+105
Now supports full pagination, displaying & sorting on VN count and displaying & filtering the searchable and applicable flags.
2020-09-27TagEdit: Re-add message about moderator approvalYorhel1-0/+13
2020-09-27v2rw: Delete old tag edit formYorhel2-221/+1
2020-09-27v2rw/TagEdit: Add vote wiping/merging and audit loggingYorhel2-1/+66
Only feature missing from the new form is to recursively edit the tag category, but that's rarely used and going to be a pain when we get edit histories for tags, so let's not.
2020-09-27v2rw/TagEdit: Rewrite tag edit form to elmYorhel7-5/+336
It's still missing a few mod features, will add those later.
2020-09-26Elm/Extlinks: Use case sensitive url matching in formsYorhel1-1/+1
As the server side does the same. Partial fix for https://vndb.org/t2520.492
2020-09-22CSS: Make review boxes look less messy + make better use of spaceYorhel1-3/+2
2020-09-21Images::Vote: Remove the 90% vote count limitYorhel1-12/+0
This is a bit of an experiment. Performance seems to be alright so far, so let's see if we can bump it up a bit. Downside is that people who've on voted almost all may sporadically get no more new images. A fair trade-off, for now. If performance allows I could add a 'just get all non-voted images and order by random()' fallback.
2020-09-21Report: Fix display of edit-yourself messageYorhel1-1/+1
It was being displayed for entries users could not edit themselves but hidden for users that could...
2020-09-20SQL: Fix vn.c_lang when multiple first releases on the same dateYorhel1-12/+18
https://vndb.org/t2520.485
2020-09-20Hide flagged reviews from the home pageYorhel1-1/+2
2020-09-20Reviews: Add mod option to lock reviews for commentsYorhel5-8/+30
2020-09-17Misc::Feeds: Set correct content-type headerYorhel1-0/+1
2020-09-17Feeds: Move feed generation form Multi to VNWebYorhel11-166/+83
This means the feeds are now generated on demand rather than every 15 minutes. Main reason for originally implementing this into Multi was because RSS feeds tended to get requested a *lot* and I didn't want those requests to impact site performance, but now that RSS is almost dead it doesn't really matter that much anymore. A caching layer can still be added anyway. Be sure to restart Multi and delete www/feeds/ after this change.
2020-09-15Reviews::VNTab: Hide box if there are no reviews to be displayedYorhel1-0/+1
2020-09-15Reviews::Edit: Bump reviews/day/account limit to 5Yorhel1-2/+2
2020-09-15Reviews::VNTab: Put all reviews on a single page if there are 4 or less ↵Yorhel2-7/+16
mini-reviews Not that much value in splitting them into different pages if there's not many reviews in the first place.
2020-09-15HomePage: Discard date filters in upcoming/just released boxesYorhel1-4/+6
And honor saved filters in the links to the full listings.
2020-09-14JS: Add hoverable previous/next to image viewer.xy2_2-2/+48
Adds previous/next hoverable panes, right above the image, to the text viever. These previous/next buttons have the same behavior as the current previous/next, but are easier to click than the small text, making it useful for large images, large screens, or on mobile. Change the JS behavior around the image to only delete the image instead of the entire div, so that the buttons could be positionned absolutely on top, in the same div as the image.
2020-09-12Reviews::Edit: Adjust throttle timeoutYorhel1-1/+1
So that you don't have to wait a full 24 hours to post a new review. In practice, and with people who have a regular sleep interval, 18 hours between reviews also counts as "once per day".
2020-09-12Misc::HomePage: Load thumbnails rather than full-size screenshotsYorhel1-1/+1
Oops.
2020-09-12v2rw: Add new filter querying framework + rewrite homepageYorhel7-524/+333
The new filter framework hasn't been extensively tested yet, but seems to mostly work. No real changes to the homepage, but I did manage to make a few queries a little bit faster. The most significant source of slowness is the releases listing, but I can't optimize that without adding indices.
2020-09-11v2rw/filters: Fixed a few more validation errorsYorhel1-6/+6
2020-09-10v2rw/filters: Fix two validation errors found (instantly) in prodYorhel1-5/+5
Yay for getting some real-life testing without anyone noticing \o/