Age | Commit message (Collapse) | Author | Files | Lines |
|
Reverted back to the old behaviour.
|
|
|
|
In the users_prefs table, the default value should evaluate to 'false'
in Perl, so show_list had to be inverted to hide_list.
|
|
Can only filter on one option. If there are more things to filter on it
would make sense to use the filter selector, but for now this will do.
|
|
The interface to set this could be more dynamic, since it'll be a lot of
work to set different notes for each VN. But oh well, let's first see
how many people will use this feature.
|
|
|
|
|
|
|
|
|
|
I'm sure I broke all vnlist/rlist-related features on the rest of the
site since I modified the DB abstractions. But these will all have to
be updated/rewritten anyway.
|
|
|
|
Crawlers would often find such pages, and the query would often take
more than a second to finish, in some extreme cases even 10 seconds.
This fix converts an intermediate result into an array, forcing the
query planner to evaluate the subquery first, resulting in a far more
optimal query plan.
|
|
And changed vn.c_languages to an array type while I was at it. This
required some changes in the Perl code, and I found a bug in DBD::Pg
while I was at it:
https://rt.cpan.org/Ticket/Display.html?id=54224
Luckily, there's an easy workaround for that.
|
|
That table isn't always joined in the query, resulting in a 500 when the
order isn't specified or meaningless. (i.e. VN pages)
|
|
The ORDER BY was previously specified using an 'order' argument, which
would then be directly inserted into the query. The new method is the
same as what I used for the public API: two 'sort' and 'reverse'
arguments. This should be less error-prone and more readable.
This changes quite a lot of code, so I hope I haven't forgotten to
update something along the way.
|
|
|
|
|
|
|
|
|
|
I like how the rlists.added column isn't used anywhere in the code,
makes the conversion a lot easier. :-)
|
|
The 'language' column in releases_rev has been replaced with a
releases_lang table. As this is quite a big change, there may still
be bugs floating around somewhere.
|
|
Only fetch information we actually need.
|
|
These changes are all pretty much related, so couldn't really do
that in multiple commits.
|
|
|
|
DB/{Votes,VNList,WishList}.pm into ULists.pm
|