nightlyfe
El Presidente
Just Getting Started
Member Likes (0)
I'm looking keep a list of those posts that actually have an mp3 linked, and those that have either vimeo or youtube embeded.
I can make changes to the post process to "register" a post in a table if it meets either of these conditions, or I can parse all posts and find them (ala post indexer).
I'd prefer to not use tags because some users may tag a post, for instance, about mp3 but not actually having an mp3 -- I suppose a filter on the output could work as well.
Would the post indexer work for this? Whats the best solution to do this across all MU blogs?
My use case will be a "playlist".

Responses (1)
Erstwhile founder (joined May 2007) Likes (0)
You should be able to pull the posts from the site_posts table (post indexer) using a regular expression select query.
http://www.tech-recipes.com/rx/484/use-regular-expressions-in-mysql-select-statements/
I would definitely cache the data for a while though instead of running the query every few seconds.
Thanks,
Andrew
Become a member