Файл: adultscript-2.0.3-pro/files/admin/modules/tools/components/orphans.php
Строк: 22
<?php
defined('_VALID') or die('Restricted Accesss!');
class VComponent_Admin_tools_orphans
{
public function __construct()
{
}
public function render()
{
$db = VF::factory('database');
$db->query("SELECT video_id, title FROM #__video ORDER BY video_id ASC");
$videos = $db->fetch_rows();
$orphans = array();
foreach ($videos as $video) {
$video_id = (int) $video['video_id'];
$db->query("SELECT cat_id FROM #__video_category WHERE video_id = ".$video_id." LIMIT 1");
if (!$db->affected_rows()) {
$orphans[] = $video;
}
}
$tpl = VF::factory('template');
$tpl->menu = 'main';
$tpl->submenu = 'tools';
$tpl->meta_title = 'Admin::Tools::Rebuild';
$tpl->orphans = $orphans;
$tpl->load(array('header', 'tools_orphans', 'footer'));
$tpl->display();
}
}