function tbxFeedRead()
{
$DB = GetDB();
$feed = $DB->Row('SELECT * FROM `tbx_video_feed` WHERE `feed_id`=?', array(Request::Get('id')));
if ($feed) {
$vf = Video_Feed::Create($feed);
$imported = $vf->Import();
$output = array();
$output['message'] = 'Feed has been read successfully; ' . $imported . ' imported';
$output['feed_id'] = $feed['feed_id'];
$output['date_last_read'] = date(DATETIME_FRIENDLY, strtotime($DB->QuerySingleColumn('SELECT `date_last_read` FROM `tbx_video_feed` WHERE `feed_id`=?', array($feed['feed_id']))));
$output['eval'] = file_get_contents('js/cp-video-feed-read.js');
JSON::Success($output);
} else {
JSON::Failure('This video feed no longer exists in the database');
}
}
function ReadFromFields()
{
$args = ParseCommandLine();
$query = 'SELECT * FROM `tbx_video_feed`';
if (isset($args['feeds'])) {
$ids = array();
foreach (explode(',', $args['feeds']) as $id) {
$id = trim($id);
$range = explode('-', $id);
if (count($range) == 2) {
$ids = array_merge($ids, range($range[0], $range[1]));
} else {
$ids[] = $id;
}
}
$ids = preg_grep('~^\\d+$~', $ids);
if (!empty($ids)) {
$query .= ' WHERE `feed_id` IN (' . join(',', $ids) . ')';
}
}
$DB = GetDB();
$result = $DB->Query($query);
while ($feed = $DB->NextRow($result)) {
$vf = Video_Feed::Create($feed);
$imported = $vf->Import();
}
$DB->Free($result);
}
