Are you a genius?
Are you a genius? Code monkey? Alpha geek? Good. I need your help.
I need an sql query that will search the MT db and extract the following:
across the entire database (for several blogs on the same MT mySQL database).
If you can do that – in my book – you’re a genius. And I owe you a beer.
Still need help? I have a code monkey genius alpha geek at my disposal! Let me know…
(Who, by the way, said it’s “not hard, not a problem.”)
Kevin are you going to utilze this information inside PHP or perl? Here is the basic query you want:
SELECT author_name, entry_title, blog_archive_url, entry_id, blog_file_extension
FROM `mt_entry` , mt_author, mt_blog
WHERE entry_author_id = author_id and entry_blog_id = blog_id
That will return all the parts that you need to do something with the information.
I wrote some quick php and get the follwing:
http://www.10500bc.org/forkev/list.php
You are a bad-ass mofo. I’ll email you. The sucky part is I thought for sure that someone from far away would hook me up and I’d be off the hook for the beer. Damn!