Файл: adultscript-2.0.3-pro/files/admin/modules/tools/components/rebuild_pornstars.php
Строк: 19
<?php
defined('_VALID') or die('Restricted Accesss!');
class VComponent_Admin_tools_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 WHERE 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");
}
$db->query("SELECT cat_id FROM #__photo_categories");
$categories = $db->fetch_rows();
foreach ($categories as $category) {
$cat_id = (int) $category['cat_id'];
$db->query("SELECT COUNT(*) AS total_albums FROM #__photo_category WHERE cat_id = ".$cat_id);
$db->query("UPDATE #__photo_categories SET total_albums = ".(int) $db->fetch_field('total_albums')." WHERE cat_id = ".$cat_id." LIMIT 1");
}
$tpl = VF::factory('template');
$tpl->menu = 'main';
$tpl->submenu = 'tools';
$tpl->meta_title = 'Admin::Tools::Rebuild';
$tpl->load(array('header', 'tools_rebuild', 'footer'));
$tpl->display();
}
}