summaryrefslogtreecommitdiff
path: root/lib/VNDB
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-07Don't update the 'date' when changing a VN voteYorhel1-1/+1
Reverted back to the old behaviour.
2011-01-03Bugfix: Secondary order by title or username on vote listingsYorhel1-1/+1
2011-01-02Bugfix: Don't show NSFW screenshots on homepage with filtersYorhel1-1/+1
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 /Yorhel2-4/+29
2011-01-01V|R Browse: Don't apply saved filters when an empty filter string is givenYorhel3-6/+8
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 filtersYorhel5-7/+37
- 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 itYorhel4-58/+135
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 usersYorhel2-2/+13
2010-12-23Converted the notify_announce and notify_dbedit preferencesYorhel4-18/+16
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 valueYorhel7-29/+33
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 tableYorhel4-21/+19
2010-12-23Added users_prefs table and removed users.(skin|customcss)Yorhel4-13/+44
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 nameYorhel4-43/+39
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+/listYorhel2-1/+9
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 listYorhel2-11/+21
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-20Update the votes.date column when changing a voteYorhel1-1/+1
2010-12-20Added ability to batch-edit votes to /u+/votesYorhel2-5/+45
2010-12-20Added advanced page-browsing tabs to threadsYorhel2-15/+32
2010-12-19ULists::votelist: Added first character selectionYorhel2-4/+16
2010-12-19Added tab and link for /u+/votes to user tabs & main menuYorhel2-0/+5
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 consistencyYorhel5-36/+21
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+/listYorhel2-89/+132
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 errorYorhel4-4/+8
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 unknownYorhel5-23/+12
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=XYorhel5-92/+14
The new tag link browser has replaced the crappy old user-tags-browser.
2010-12-13Added advanced tag link browserYorhel2-4/+151
Still need to add some links to the browser to parts of the site.
2010-12-10Keep track of last modification date for tag<->vn linksYorhel1-4/+27
Currently unused, but this will be useful in the future. dbTagLinkEdit() is now a lot more complex, since the last modification date will be incorrect for unmodified tag links when we simply delete and re-insert all related links like the old function did.
2010-12-10Added vote listings for VNs and users (/[uv]+/votes)Yorhel5-9/+83
2010-12-10Added a "general discussions" boardYorhel1-8/+9
So that the "db" board is useful again.