summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler/Tags.pm
AgeCommit message (Collapse)AuthorFilesLines
2016-07-03Generalize substring search relevance + apply to most dropdown searchesYorhel1-1/+1
This is a generalization of the search improvements made in 7da2edeaa0f6cf7794f4f8f68960497dc1be893c and 92235222dba4e5d0c7713d53ef12e0f10e371b83 And has been applied to the dropdown searches for producers, staff, tags and traits. For all those searches, exact matches are listed first, followed by prefix matches, and then substring matches. Relevance is currently only based on the primary name/title and ignores aliases (except for staff). This is fixable, but not trivial, and I'm not sure it's all that useful.
2016-01-23L10N: Intern all VNDB::Handler::* stuffYorhel1-100/+115
Most of these replacements were automated. This ended up being less work than I had anticipated. I also fixed a few minor bugs along the way, but probably introduced more than I fixed.
2016-01-20L10N: Intern all VNDB::Util::* stuffYorhel1-6/+3
With some related edits in other parts of the code, mostly due to interface changes to htmlRevision() and htmlFormError(). Trivial replacements were automated by a super awesome script.
2016-01-19Move some VNDB::L10N stuff to VNDB::Func + intern VNDB::FuncYorhel1-7/+5
2016-01-17Use Tie::IxHash for some global.pl listsYorhel1-2/+2
This removes the reliance on sort() to provide meaningful ordering (the keys aren't always good for ordering) and removes the 'order' hack used for (vn|prod)_relations.
2016-01-17L10N: Intern tag_cats/voiced/animated/*_statusYorhel1-5/+5
2015-12-30Add release filters to VN browserYorhel1-2/+4
2015-09-20Update usage kv_validate() to upcoming TUWF 1.0Yorhel1-8/+8
And added new 'page' and 'id' templates for more strict validation.
2015-07-21Add profile option for the default spoiler settingYorhel1-6/+4
This fixes the unexpected behaviour that changing the spoiler setting on one page will change it for all pages. All manual spoiler changing options are temporary now.
2015-07-21L10N: Combine spoiler setting stringsYorhel1-3/+3
2015-05-12Handler::Tags: Don't allow adding deleted tags to a VNYorhel1-0/+3
2014-12-01Replace some 'onclick' attributes with JS-generated eventsYorhel1-3/+3
I think this was the last piece of inline JS.
2014-12-01Don't use inline script tag to pass pref_code to JSYorhel1-1/+1
This also simplifies the code a bit, as the value of the preference data was never used so doesn't need to be included now. Primary reason for this change is to work towards disabling inline JS with a CSP header. There's still more stuff to fix before the CSP header can be applied, though.
2012-01-25Do most of the table striping in CSSYorhel1-3/+3
Using CSS3 selectors. This is a more elegant approach, and since browser support for CSS3 selectors isn't as crap as it used to be I can finally make use of them.
2011-08-30Changed "remove"- and "add"-like words to a single lang.txt entryQCyph1-3/+3
2011-03-30Merge branch 'meh' of g.blicky.net:vndb into beta2.19Yorhel1-0/+1
Conflicts: data/lang.txt
2011-03-09Auto-set category when creating new child tagYorhel1-0/+1
2011-02-21chardb: char-by-trait lookup + trait usage count + tag-code sharingYorhel1-8/+8
I'll have to optimize the updating of traits_chars as soon as I have some data to test with. Also renamed tags.c_vns to c_items, to have it share the same name as traits.c_items. This makes it a lot easier to re-use code for both tags and traits, such as what I did with dbTagTree/dbTraitTree -> dbTTTree and the childtags() and parenttags() functions.
2011-02-20L10N: Globalized spoiler levelsYorhel1-1/+1
They're going to be re-used at several more places now.
2011-02-14chardb: Added trait index and searchYorhel1-1/+1
2011-02-13chardb: Added notes file and started implementing the traitsYorhel1-65/+3
2011-02-07Added tooltip to the overruled-exclamation-markYorhel1-1/+1
2011-02-06Added filter selector to tag pages (excl. tags tab)Yorhel1-6/+17
2011-02-05Group tags on /v+/tagmod by their categoryYorhel1-24/+39
2011-02-04Allow setting tag category for all child tags recursivelyYorhel1-0/+28
Takes the burden out of our dear tag moderators to edit *all* tags manually on the next update.
2011-02-04Added category field to tags (content/ero/technical)Yorhel1-1/+10
Not very useful at the moment, but will be used to improve several other things.
2011-02-04Fixed two perl warning related to reqCookie() returning undefYorhel1-1/+1
A TUWF change I forgot to check.
2011-01-27TUWF: Added tag name to several end() callsYorhel1-18/+18
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: Made use of the new cookie_prefix featureYorhel1-1/+1
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 TUWFYorhel1-43/+47
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-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-01Added saving notes to filter selector and applied filFetchDB()Yorhel1-2/+3
This finalizes the permanent filters feature.
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 nameYorhel1-6/+10
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-14Handler::Tags: Added noindex to /g/linksYorhel1-1/+1
It's mostly a moderation thing, shouldn't get indexed.
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=XYorhel1-83/+1
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-11-06Fixed cross-site request forgery vulnerabilitiesYorhel1-0/+2
2010-11-02Prefix all cookies with a configurable cookie_prefixYorhel1-1/+1
This replaces the "cookie_auth" setting, and applies to all cookies in use by VNDB.
2010-03-13Handler::Tags: Re-added /g/debugYorhel1-0/+31
2010-02-10Handler::Tags: Increased maxlength of the tag descriptionsYorhel1-1/+1
2010-01-24Handler::Tags: Only allow tagmods to create top-level tagsYorhel1-1/+1
The current error message isn't really intuitive, though...
2010-01-11Tags: Another bugfix in the parent tags SQL query and displayYorhel1-8/+3
It should work perfectly now...
2010-01-10Handler::Tags: Fixed major bug with parent tag display on tag pagesYorhel1-14/+22
2010-01-09Handler::Tags: Don't display empty VN listYorhel1-1/+1
Minor bug introduced in e69b417f
2009-11-29Tags: Replaced tag_tree() with WITH .. SELECT queries, and removed /g/debugYorhel1-51/+11
The return value of dbTagTree() is also somewhat easier to work with.
2009-11-27DB: Abstracted all ORDER BY clauses in the DB abstraction layerYorhel1-17/+9
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.