summaryrefslogtreecommitdiff
path: root/lib/VNDB/Util/Misc.pm
AgeCommit message (Collapse)AuthorFilesLines
2018-10-04Fix release filter compatibility with multiple resolutionsYorhel1-3/+7
Compatability is hard...
2018-10-02Fix release filter compatibility handling on VN browserYorhel1-16/+12
filFetchDB() is not used for the release filter on the VN browsing interface, so I've moved the compatibility stuff into a separate filCompat() method that can be called from Handler::VNBrowse.
2018-10-02DB: Convert resolution into an enumYorhel1-2/+14
Been wanting to do this for a long time - using an integer index into an array that changes once in a while is way too fragile. Doubly so when said indices are also used in filters and URLs that can't be updated every time a new resolution is added.
2018-05-25Add uncensored flag to release entriesYorhel1-1/+1
As discussed in https://vndb.org/t10665
2018-01-06Use the new BBCode parser in bbSubstLinks()Yorhel1-44/+21
2017-03-03Add date filters to VN searchYorhel1-1/+1
2015-12-30Add release filters to VN browserYorhel1-1/+1
2015-11-10Add 'has screenshots' filter to VN browserYorhel1-1/+1
2015-11-10Add language filter to staff browserYorhel1-1/+1
2015-07-19Remove the MSIE browser check & warning pageYorhel1-47/+1
It's a relic of the past. IE 6 & 7 are very rarely used nowadays, and people still using it will quickly realize why things don't quite work - they'll be used to it.
2015-02-02Add filters to staff browsers + minor layout fix on staff pagesmorkt1-1/+2
2015-01-28bbSubstLinks: Replace staff IDs with namesYorhel1-4/+7
2015-01-12bbSubstLinks: Increase titles to fetch to 50 + tweak matching patternmorkt1-8/+9
Patch from https://vndb.org/t2520.116
2014-12-23bbSubstLinks: Fix minor parsing issuemorkt1-2/+2
Patch from https://vndb.org/t5564.18
2014-12-22DB: Merge name/title fetching in main fetching functionsYorhel1-3/+3
And call bbSubstLinks() from Handler::Discussions rather than DB::Discussions - it's not a transformation that the DB layer should do, IMO.
2014-12-22bbcode: Replace [vcpgi][0-9]+ links with a [url] tagmorkt1-1/+70
Patch from https://vndb.org/t5564.13
2014-10-21Use TUWF's reqBaseURI() instead of $self->{uri} on site linksYorhel1-1/+2
TUWF properly detects HTTPS and includes this in the returned URL, so this change ensures that all URLs adopt properly to HTTP and HTTPS.
2014-08-29API: Make sure to honor the new login throttleYorhel1-22/+1
2014-08-29Strengthen formcode for non-logged-in visitors + CSRF protect login formYorhel1-1/+21
formcode is strengthened by including the IP (-prefix) into the hash, ensuring that the code can't be obtained by someone on a different network. I also removed the login form of every page. Felt kinda pointless.
2011-10-24Added 'role' filter to character browserYorhel1-1/+1
2011-08-27Added filters to character browse page and trait pageQCyph1-2/+3
2011-02-06Added new VN filter: on user VN list or notYorhel1-1/+1
2011-02-06Added new VN filter: voted on or notYorhel1-1/+1
2011-02-06Added new VN filters: wish/blacklistYorhel1-1/+1
2011-02-06Added filter selector to tag pages (excl. tags tab)Yorhel1-4/+1
2011-02-03TUWF: Replaced reqParam() with reqGet() or reqPost() where applicableYorhel1-1/+1
Cleaner this way. Also found two occurences of manually HTML-escaping text for textareas, which isn't necessary anymore.
2011-01-27TUWF: Added tag name to several end() callsYorhel1-3/+3
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-1/+50
No more ugly hacks in my code thanks to TUWF! (a browser check in itself is already ugly enough for my tastes...)
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel1-1/+1
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-1/+1
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-01V|R Browse: Don't apply saved filters when an empty filter string is givenYorhel1-4/+4
2011-01-01More infrastructural changes to accomodate for the permanent filtersYorhel1-1/+1
- 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 itYorhel1-0/+100
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.
2009-08-05Removed last traces of the shared memory processing queueYorhel1-32/+0
Everything has now finally been converted to use the PgSQL LISTEN/NOTIFY feature. This commit removes the last Tie::ShareLite dependency.
2009-07-23Implemented relgraph notify from PgSQL triggerYorhel1-20/+2
This finishes the new relation graph generator, as it'll now regenerate graphs as soon as is needed. This obsletes the VNDB::Util::Misc::vnCacheUpdate() function, this functionality is provided by triggers within PostgreSQL. The update_vncache(0) procedure is now significantly slower due to the trigger on the vn table. It'd be a good idea to rewrite this procedure by using triggers and conditional updates, to drastically lower the number of rows that need to be updated.
2009-01-15Don't forget to update the vn.c_* columns when hiding/unhiding a releaseYorhel1-1/+23
2008-11-13Forgot to upload new file *sigh*Yorhel1-0/+28