Difference between revisions of "Character Tags"
Jump to navigation
Jump to search
(→Notes) |
|||
Line 38: | Line 38: | ||
[https://www.animecharactersdatabase.com/acdb_tags.php acdb_tags.php] is the only places where a proper INNER JOIN based multiple tag approach was attempted. It can now be deployed any place else that uses tags and should support multiple tags in searches and filtering. | [https://www.animecharactersdatabase.com/acdb_tags.php acdb_tags.php] is the only places where a proper INNER JOIN based multiple tag approach was attempted. It can now be deployed any place else that uses tags and should support multiple tags in searches and filtering. | ||
− | Previously I used either single ='s matching, or a limited form | + | Previously I used either single ='s matching, or a limited form of IN() or some wacky join that didn't quite work. |
Revision as of 16:01, 7 June 2022
Tags are a bit of a mess. I'll try documenting what we have here, then work towards improving it.
Tag Links
All Character Tags Search Character Tags Combine Tags Multiple Tag Search ( up to 3 )
acdb_tags.php allctags.php mobile_pubtags.php mobile_tags.php mycharactertags.php newtags.php pubtags.php rapidsearchtags.php sitemap_tagcloud.php tagcloud.php tagcp.php tagdescriptions.php taglist.php taglist2.php tagmoderation.php tags_sitemap.php title_tags.php
Tag Change History
lazytaghistory.php saved_tags.php
Require a ref to work
anime_tags.php c_tags.php lazytag.php
Dev side only
kona_tags.php myquotetags.php notags.php test-tagbubbles.php
Notes
acdb_tags.php is the only places where a proper INNER JOIN based multiple tag approach was attempted. It can now be deployed any place else that uses tags and should support multiple tags in searches and filtering.
Previously I used either single ='s matching, or a limited form of IN() or some wacky join that didn't quite work.