summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Tags.pm
AgeCommit message (Collapse)AuthorFilesLines
2010-12-21Pass VN tag filters by ID rather than nameYorhel1-1/+1
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-13Added advanced tag link browserYorhel1-4/+34
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-10-31Remove duplicate votes when merging tags (fixes a 500)Yorhel1-0/+4
2010-01-11Tags: Another bugfix in the parent tags SQL query and displayYorhel1-1/+1
It should work perfectly now...
2009-11-29Tags: Replaced tag_tree() with WITH .. SELECT queries, and removed /g/debugYorhel1-5/+30
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-6/+20
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.
2009-11-27Display VN ratings on tag pages as wellYorhel1-27/+1
With this method I managed to reuse the VN list table code for the lists on both the VN browser and the tag pages. And optimized away the dbTagVNs() function while I was at it (dbVNGet() is powerful enough)
2009-11-27Changed VN score on tags pages to display plain averagesYorhel1-5/+5
For three reasons: - Speed tag_vn_calc() is now more than 10 times faster (granted, it could have been a lot faster even with the bayesian rating, but whatever) - Consistency with the tag scores displayed on the VN pages (which are raw averages as well) - It didn't always make sense
2009-08-08Don't show hidden VN items on g+ pagesYorhel1-0/+1
Ideally, all tag relations should be removed when hiding a VN, but that would make hiding a destructive action, while currently it can still be reverted easilily.
2009-08-08Converted tags.added to timestamptzYorhel1-2/+3
2009-07-08Keep track of users who requested tagsYorhel1-5/+11
2009-03-28Fixed and re-organized tag<->vn calculationYorhel1-1/+1
Fixed major performance bug caused by referencing the wrong table, moved all intermediate views to tag_vn_calc() as temporary views (similar to update_vnpopularity()) and renamed tags_vn_stored to tags_vn_bayesian.
2009-03-18Experimenting with a location for tags on v+ pagesYorhel1-2/+4
2009-03-15Some more content on the tag indexYorhel1-1/+3
2009-03-15Bugfix: Copy old tag names over to new tag on mergeYorhel1-0/+2
2009-03-15Removed tag deletion featureYorhel1-9/+1
There's no need for that anymore with the merge and state options
2009-03-15Tag mergingYorhel1-1/+10
2009-03-14Expanded the tag list with a search, and more for use by non-tagmodsYorhel1-2/+3
2009-03-14Added tag list (/g/list) to browse tags by status, mostly for moderator useYorhel1-3/+4
2009-03-14Separated table for tag aliases + proper checking of unique aliases and namesYorhel1-13/+28
2009-03-14Added tag states for pending/deleted/acceptedYorhel1-5/+10
2009-03-08(Kind-of) finalized the tag indexYorhel1-3/+10
Couldn't think of anything more useful to display than simply all tags without parents and a few of their subtags.
2009-03-08Added caching of tags_vn_bayesian and the VN count for tagsYorhel1-13/+4
Updated hourly by Multi. May want to look for a better way to update this cache, because I'm afraid the current tags_vn_calc() is going to perform very badly on larger databases.
2009-03-08Added user taglistYorhel1-10/+43
2009-03-07Hiding spoilers on tag pagesYorhel1-3/+9
2009-03-07Replacing random VN counts with actual data on tag pagesYorhel1-1/+4
Just prototyping, current implementation is too slow for actual use.
2009-03-07Adding list of VNs to tag pagesYorhel1-1/+21
2009-02-28Voting on spoilerness of a tag worksYorhel1-2/+4
(interface is somewhat on the half-hearted side, but oh well)
2009-02-28Improvements in vntagmod table layout, and saving votes in the DB worksYorhel1-2/+10
And a "Don't forget to submit" text, and various important bugfixes, and... geez, time for a coke with some cookies!
2009-02-22vntagmod: Adding tags using dropdown searchYorhel1-1/+5
The usual: it's still pretty much useless and unfinished, will polish up things later.
2009-02-22Renaming tags.aliases to tags.aliasYorhel1-4/+4
Consistent with all other aliases field
2009-02-22Very basic, unfinished and non-working interface for VN/tag linkingYorhel1-1/+27
But it already starts to look like something that might work.
2009-02-15Tag deletionYorhel1-1/+9
2009-02-15Check for existing tag with the same name on tag creation or editYorhel1-1/+3
2009-02-15Basic adding and editing of tagsYorhel1-3/+27
2009-02-14Made a start on the tagging systemYorhel1-0/+55
Mostly playing around with the possibilities, tag page layout & database scheme are far from final