<?php
    include('db.php');
    $count = 0;
	$date = date('Y-m-d'); 
    $results = dbQuery("SELECT * FROM `content` WHERE `enabled` = 0 AND `approved` = 2 AND scheduled_date = '$date'", false);		
	if(is_array($results)) {
		foreach ($results as $row) {
			dbQuery("UPDATE `content` SET `encoded_date` = NOW(), `scheduled_date` = NOW(), `enabled` = 1 WHERE `record_num` = '$row[record_num]'");
			updateRelatedVideos($row['record_num']);
			$count++;
		}		
	}	
    exit("$count video(s) published");
?>