summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler
AgeCommit message (Collapse)AuthorFilesLines
2011-01-07Bugfix: Don't allow empty edit on releases with multiple producersYorhel1-1/+1
Caused by an errorneous sort statement when comparing the producer values.
2011-01-02Bugfix: Correctly randomize screenshots on homepage with filtersYorhel1-1/+1
2011-01-02Fixed perl warning on /u+/votes batchedit with nothing selectedYorhel1-1/+1
2011-01-01Also apply permanent VN filters to the random screenshots on /Yorhel1-1/+7
2011-01-01V|R Browse: Don't apply saved filters when an empty filter string is givenYorhel2-2/+4
2011-01-01Bugfix: properly escape search query in links query stringYorhel2-4/+6
2011-01-01Added saving notes to filter selector and applied filFetchDB()Yorhel3-6/+7
This finalizes the permanent filters feature.
2011-01-01More infrastructural changes to accomodate for the permanent filtersYorhel3-4/+23
- Added a 'prefs' option to htmlFooter() to add preference data for use by Javascript. - Added an /xml/prefs.xml URL for setting preferences from JS. - Added 'filter_*' keys to the prefs_key ENUM - Load filters by default on VN and Release browser
2011-01-01Implemented filFetchDB() and converted the VN/Release browser to use itYorhel2-57/+34
This will correctly handle fetching stuff from the database when permanent filters are enabled. This update also removes compatibility with some old VN browse URLs. The old 'ti' and 'te' (tag include/exclude) query parameters are now ignored, and searching for a language in the query string (e.g. "q=English") won't enable the language filter.
2010-12-28Bugfix: translate screen resolutions on release revision pagesYorhel1-1/+1
2010-12-28Bugfix: *properly* check for access priviledge on users' listsYorhel1-3/+3
Bug introduced in 6ff1efe0d07e24e9fb2db199c308c6cbed51e578.
2010-12-28Bugfix: check for validness of form arguments on /[uv]+/votesYorhel1-0/+1
2010-12-23Store l10n preference in the database for logged-in usersYorhel1-2/+9
2010-12-23Converted the notify_announce and notify_dbedit preferencesYorhel1-10/+7
And renamed notify_dbedit to notify_nodbedit, since the default is to provide a notify on a database edit. Also fixed a few bugs along the way.
2010-12-23Converted the show_list pref. to users_prefs and inverted the valueYorhel4-23/+23
In the users_prefs table, the default value should evaluate to 'false' in Perl, so show_list had to be inverted to hide_list.
2010-12-23Converted the show_nsfw preference to use the users_prefs tableYorhel2-18/+16
2010-12-23Added users_prefs table and removed users.(skin|customcss)Yorhel1-4/+4
Will convert the other preferences later.
2010-12-22Don't allow page > 100 or sorting on username or title on tag link browserYorhel1-4/+4
Performance. Those featues are hardly used, but they can block other visitors when used in bad combinations.
2010-12-21Pass VN tag filters by ID rather than nameYorhel2-33/+23
This makes the UI slightly uglier and less intuitive. I'll see if I can find a way around that. This update is required for the permanent browsing filters to be fast and reliable.
2010-12-21Added vnlists.status filter to /u+/listYorhel1-1/+8
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.
2010-12-21Added notes field to the user VN listYorhel1-4/+11
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.
2010-12-20Added ability to batch-edit votes to /u+/votesYorhel1-2/+40
2010-12-20Added advanced page-browsing tabs to threadsYorhel1-2/+2
2010-12-19ULists::votelist: Added first character selectionYorhel1-4/+10
2010-12-19ULists::votelist: Don't give a 404 on /u+/votes when no votes foundYorhel1-2/+3
2010-12-19RFC-01: Code/DB cleanup and renamed some stuff for consistencyYorhel3-16/+16
2010-12-19RFC-01: Added VN list selection box to VN pagesYorhel2-3/+34
2010-12-19RFC-01: Fixed release list updating dropdown on VN pagesYorhel2-9/+5
2010-12-19RFC-01: Fixed release list selection thing on release pagesYorhel2-17/+10
2010-12-19RFC-01: Updated and improved /u+/listYorhel1-43/+62
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.
2010-12-17Check for editsum = description and give an easier to understand errorYorhel3-3/+7
The check is quite basic and you can easily get around it. It's just intended to warn about common mistakes.
2010-12-17Don't allow NULL for rr.minage and use -1 for unknownYorhel3-12/+10
This can be seen as a partial revert of 0a4f97f0186d6941a4cab2e3bd05201f1fed1441. I used to think using NULL for special values is more "correct" in database terms. But in the end I guess I should be aiming for whatever solution is easier. Both are "correct" in a sense anyway.
2010-12-16Fixed perl warning on /v/search redirect without search queryYorhel1-1/+1
2010-12-15Handler::Users: Link the vote count on /u+ to /u+/votes instead of /u+/listYorhel1-1/+1
2010-12-15Handler::ULists: Added noindex to /[vu]+/votesYorhel1-1/+1
In line with the noindex on other ulists pages. And it's not very interesting for googling users anyway.
2010-12-14Handler::Tags: Added noindex to /g/linksYorhel1-1/+1
It's mostly a moderation thing, shouldn't get indexed.
2010-12-14L10N: Extracted screen resolution strings from the codeYorhel1-2/+3
A somewhat ugly approach, but couldn't think of something better.
2010-12-13Disable "Don't update last modified field" by default for modsYorhel1-1/+0
2010-12-13Added links to /g/links from /g and /g+Yorhel1-0/+2
That should be all relevant pages, I guess.
2010-12-13Added "who voted on this tag"-links on /v+/tagmod (to /g/links)Yorhel1-2/+6
2010-12-13Removed /u+/tags and replaced/added links to /g/links?u=XYorhel3-85/+13
The new tag link browser has replaced the crappy old user-tags-browser.
2010-12-13Added advanced tag link browserYorhel1-0/+117
Still need to add some links to the browser to parts of the site.
2010-12-10Added vote listings for VNs and users (/[uv]+/votes)Yorhel3-5/+63
2010-12-10Added a "general discussions" boardYorhel1-8/+9
So that the "db" board is useful again.
2010-12-09Removed expand/collapse from /u+/posts and switched to a combined viewYorhel1-6/+4
And removed some shared code that is now unused
2010-12-09Handler::Misc: Fixed perl warning and redirect bug for old /v/search URLsYorhel1-1/+1
We can't redirect to unencoded and unescaped URLs containing unicode characters.
2010-12-04Handler::Releases: Fixed perl warning in _fil_compat()Yorhel1-1/+1
2010-11-28Merge branch 'beta'Yorhel6-237/+117
Conflicts: lib/VNDB/Handler/Discussions.pm
2010-11-28Release filter selector: Added original language filterYorhel1-1/+1
I'm surprised I haven't been able to find a combination of filters that would generate an SQL query that would run more than 300ms or so. PostgreSQL is amazing!
2010-11-28Handler::VNBrowse: Fixed bug with assigning to $fil->{lang}Yorhel1-1/+1
This caused the search to break when no language filters were set.