Файл: adultscript-2.0.3-pro/files/admin/modules/video/components/category_rebuild.php
Строк: 17
<?php
defined('_VALID') or die('Restricted Accesss!');
class VComponent_Admin_video_category_rebuild
{
public function __construct()
{
}
public function render()
{
$db = VF::factory('database');
$db->query("SELECT cat_id FROM #__video_categories");
$categories = $db->fetch_rows();
foreach ($categories as $category) {
$cat_id = (int) $category['cat_id'];
$db->query("SELECT COUNT(*) AS total_videos
FROM #__video_category AS c
INNER JOIN #__video AS v ON (v.video_id = c.video_id AND v.status = 1)
WHERE c.cat_id = ".$cat_id);
$db->query("UPDATE #__video_categories SET total_videos = ".(int) $db->fetch_field('total_videos')." WHERE cat_id = ".$cat_id." LIMIT 1");
}
$tpl = VF::factory('template');
$tpl->menu = 'video';
$tpl->submenu = 'video_tools';
$tpl->extramenu = 'video_category_rebuild';
$tpl->meta_title = 'Admin::Video::Category::Rebuild';
$tpl->load(array('header', 'video_category_rebuild', 'footer'));
$tpl->display();
}
}