protalk/protalk — pull request #155 by Tocacar (2013-02-07 16:51:03+00:00)
Title: [WIP]  Automated Content Gathering

PHPNW (Bliptv) and Kings of Code (YouTube) feeds import correctly with the code here. DPC podcast feeds to follow shortly. Note, I had to add the Kings of Code feed manually - the feed url is as follows (for testing): http://gdata.youtube.com/feeds/api/videos?q=kingsofcodefestival&max-results=50&v=2

After updating the db schema (to add the necessary new Feed/ Media properties) I had to run these statements in MySQL:

UPDATE media SET isImported=0; //as none of the existing items were imported
UPDATE media SET status="pub"; // to set all existing media as 'published'
UPDATE feed SET mediatype_id=2; //after this, I went through the Feed records and corrected the podcast feeds to show the correct mediatype

Feedback on this initial code most welcome!