summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler
AgeCommit message (Collapse)AuthorFilesLines
2011-02-04Merge branch 'beta'2.17Yorhel10-472/+465
Conflicts: ChangeLog
2011-02-04Don't save uploaded image to a temporary location before checksYorhel1-37/+19
This takes less code and may (or may not) be more efficient since it does not require any HDD I/O while performing some checks.
2011-02-03TUWF: Replaced reqParam() with reqGet() or reqPost() where applicableYorhel3-5/+5
Cleaner this way. Also found two occurences of manually HTML-escaping text for textareas, which isn't necessary anymore.
2011-02-03Cleaner and more efficient method of checking for the &fil= paramYorhel2-4/+4
With the new TUWF, kv_validate() returns undef when the param isn't present and an empty string if it is, but left empty. This is a more efficient way to differentiate between empty and nonexistent than the previous YAWF-method of grepping all param names.
2011-02-02Added /t/all - a listing of all recently replied to threadsYorhel2-7/+8
2011-01-27Order "all notifications" with new notifications firstYorhel1-0/+1
That's more what you'd expect from a list that functions somewhat as a short-lived FIFO "archive".
2011-01-27L10N: Renamed _rbrowse_filters to _js_fil_filtersYorhel2-2/+2
2011-01-27TUWF: Added tag name to several end() callsYorhel10-76/+76
Haven't found any bugs this way, yet. I doubt there'll be any problems, but it's a nice new feature that could help quite a bit. :-D
2011-01-27TUWF: Cleanup IE check code using pre_request_handler return valueYorhel1-43/+0
No more ugly hacks in my code thanks to TUWF! (a browser check in itself is already ugly enough for my tastes...)
2011-01-27TUWF: Use the uri_escape() provided by TUWFYorhel3-3/+3
2011-01-27TUWF: Replaced resHeader('Set-Cookie', ..) with resCookie()Yorhel1-4/+2
Way more convenient. This also fixes several bugs with the previous commit, since the cookie_prefix wasn't used for *all* cookies. Since it is now, the 'l10n' cookie now also respects the configured prefix, which means some people will have to set their default language again. Configuration changes: 'cookie_domain' option has been removed, the 'cookie_defaults' option of TUWF should now be used.
2011-01-27TUWF: Made use of the new cookie_prefix featureYorhel2-2/+2
Configuration change: Make sure you more the cookie_prefix option from %S to %O. (It's now a TUWF option rather than a VNDB one)
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel10-286/+293
There may still be some bugs present and I've only converted the points where TUWF is incompatible with YAWF. The new TUWF features are not in use yet, I'll do that later on. Note that, in order to run the new code, TUWF must be installed on your system. The configuration for the TransAdmin plugin has also changed. Other than that there shouldn't be any issues.
2011-01-07Added 'released' release filterYorhel1-2/+2
Just an alias for the correct date_before or date_after filter. Allows bookmarking 'just released' or 'to be released' listings since the URL doesn't change now. Same for saved filters - it's now possible to permanently exclude future releases without having to change the filter each day.
2011-01-07DB::Releases: Inverted 'unreleased' option to dbReleaseGet()Yorhel1-2/+2
Makes more sense this way.
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-04Added checkboxes to VN tagmod and implemented the overrule logicYorhel1-10/+56
This finalizes the moderation tag vote overrule. And Damnit, the logic behind saving the tags to the database isn't fun, I hope I haven't made any mistakes there.
2011-01-03Added tag overrule indicators to tag link browser and VN tag editorYorhel1-2/+3
This is the second step in adding support for overruling tag votes by moderators. This required a different approach to calculating the score in dbTagStats(). For some reason this approach turns out to be slightly faster as well...
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