$database_xml = str_replace('<autocomplete>#Pending,Active,Disabled</autocomplete>', '<autocomplete>#Pending,Scheduled,Active,Disabled</autocomplete>', $database_xml);
file_put_contents(INCLUDES_DIR . '/database.xml', $database_xml);
// Force a reload of the schema
$schema = GetDBSchema(true);
#### Update database.xml ==========================================================================================================
#### Create database tables =======================================================================================================
// Create tbx_imported if doesn't already exist
$DB->Update(GetDBCreate('tbx_imported'));
// Create tbx_thumb_queue if doesn't already exist
$DB->Update(GetDBCreate('tbx_thumb_queue'));
// Create tbx_search_term_new if doesn't already exist
$DB->Update(GetDBCreate('tbx_search_term_new'));
#### Create database tables =======================================================================================================
#### Update database ==============================================================================================================
// Prepare for new QueueProcessor stats format
$stats = ThumbQueue::LoadStats();
if (!isset($stats[ThumbQueue::STAT_PROCESSED_ITEMS])) {
Cache_MySQL::Remove('thumb-queue-stats');
}
// Prepare for new QueueProcessor stats format
$stats = ConversionQueue::LoadStats();
if (!isset($stats[ConversionQueue::STAT_PROCESSED_ITEMS])) {
Cache_MySQL::Remove('conversion-queue-stats');
}
// Update sponsor video counts
if ($DB->QuerySingleColumn('SELECT MAX(`videos`) FROM `tbx_sponsor`') == 0) {
UpdateSponsorStats();
}
// Update status in tbx_video_feed
$DB->Update("ALTER TABLE `tbx_video_feed` MODIFY `status` ENUM('Pending','Scheduled','Active','Disabled') NOT NULL");
// Add image_id to tbx_category
<div id="dialog-help">
<a href="docs/cp-queues.html" target="_blank"><img src="images/help-22x22.png" alt="Help" title="Help" border="0" /></a>
</div>
<?php
$stats = ThumbQueue::LoadStats(true);
?>
<?php
echo ResizeableColumn('Queued Videos', $stats[ThumbQueue::STAT_QUEUED_ITEMS], true);
?>
<?php
echo ResizeableColumn('Estimated Time', $stats[ThumbQueue::STAT_ESTIMATED_TIME]);
?>
<?php
echo ResizeableColumn('Queue Processor', ThumbQueue::IsRunning() ? 'Running' : 'Stopped');
?>
<?php
echo ResizeableColumn('Last Started', $stats[ThumbQueue::STAT_LAST_STARTED]);
?>
<?php
echo ResizeableColumn('Videos Processed', $stats[ThumbQueue::STAT_PROCESSED_ITEMS], true);
?>
<?php
echo ResizeableColumn('Failed', $stats[ThumbQueue::STAT_FAILED_ITEMS], true);
?>
<?php
echo ResizeableColumn('Average Time', $stats[ThumbQueue::STAT_AVERAGE_TIME]);
?>
<?php
echo ResizeableColumn('Average Wait', $stats[ThumbQueue::STAT_AVERAGE_WAIT]);