Файл: adultscript-2.0.3-pro/files/admin/modules/pornstar/components/assign.php
Строк: 47
<?php
defined('_VALID') or die('Restricted Access!');
class VComponent_Admin_pornstar_assign extends VModule_Admin_pornstar
{
public function __construct()
{
}
public function render()
{
$errors = array();
$messages = array();
$ids = array();
foreach ($_GET as $key => $value) {
if (strpos($key, 'checkbox_video_') !== FALSE) {
$ids[] = str_replace('checkbox_video_', '', $key);
}
}
if (empty($ids)) {
$errors[] = 'Please selected at least one video to assign!';
}
$db = VF::factory('database');
if (isset($_POST['pornstars'])) {
foreach ($_POST['pornstars'] as $pornstar) {
foreach ($ids as $video_id) {
$pornstar = (int) $pornstar;
$video_id = (int) $video_id;
$db->query("SELECT video_id
FROM #__model_videos
WHERE model_id = ".$pornstar."
AND video_id = ".$video_id."
LIMIT 1");
if (!$db->affected_rows()) {
$db->query("INSERT INTO #__model_videos
SET model_id = ".$pornstar.",
video_id = ".$video_id);
$db->query("UPDATE #__model
SET total_videos = total_videos+1
WHERE model_id = ".$pornstar."
LIMIT 1");
}
}
}
$messages[] = 'Videos assigned to pornstar(s)!';
}
$db->query("SELECT model_id, name
FROM #__model
WHERE name LIKE 'a%'
ORDER BY name ASC");
$pornstars = $db->fetch_rows();
$tpl = VF::factory('template');
$tpl->menu = 'pornstar';
$tpl->submenu = 'pornstar_manage';
$tpl->meta_title = 'Admin::Pornstar::Assign';
$tpl->errors = $errors;
$tpl->messages = $messages;
$tpl->pornstars = $pornstars;
$tpl->letters = range('a', 'z');
$tpl->load(array('header', 'pornstar_assign', 'footer'));
$tpl->display();
}
}