#### 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
$columns = $DB->GetColumns('tbx_category');
if (!in_array('image_id', $columns)) {
$DB->Update('ALTER TABLE `tbx_category` ADD COLUMN `image_id` INT UNSIGNED');
}
// Add image_id to tbx_video_feed
<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 = ConversionQueue::LoadStats(true);
?>
<?php
echo ResizeableColumn('Queued Videos', $stats[ConversionQueue::STAT_QUEUED_ITEMS], true);
?>
<?php
echo ResizeableColumn('Estimated Time', $stats[ConversionQueue::STAT_ESTIMATED_TIME]);
?>
<?php
echo ResizeableColumn('Queue Processor', ConversionQueue::IsRunning() ? 'Running' : 'Stopped');
?>
<?php
echo ResizeableColumn('Last Started', $stats[ConversionQueue::STAT_LAST_STARTED]);
?>
<?php
echo ResizeableColumn('Videos Processed', $stats[ConversionQueue::STAT_PROCESSED_ITEMS], true);
?>
<?php
echo ResizeableColumn('Failed', $stats[ConversionQueue::STAT_FAILED_ITEMS], true);
?>
<?php
echo ResizeableColumn('Average Time', $stats[ConversionQueue::STAT_AVERAGE_TIME]);
?>
<?php
echo ResizeableColumn('Average Wait', $stats[ConversionQueue::STAT_AVERAGE_WAIT]);
