private function createMediaStorage($trans_name, $additional = '')
{
$existed = $this->db->getVideoByParam(array('path' => $trans_name));
if (!empty($existed)) {
$error = $this->setlocalization('Error: The folder with that name already exists');
} else {
$_SERVER['TARGET'] = 'ADM';
$master = new \VideoMaster();
try {
$master->createMediaDir($trans_name, $additional);
} catch (\MasterException $e) {
//var_dump($e->getMessage(), $e->getStorageName()); exit;
$moderator_storages = $master->getModeratorStorages();
if (!empty($moderator_storages[$e->getStorageName()])) {
$error = $this->setlocalization('Error creating the folder on moderator storage');
}
}
}
}
if (!empty($_GET['id'])) {
$video = Video::getById($_GET['id']);
}
if (@$_GET['save']) {
$trans_name = transliterate(@urldecode($_POST['name']));
if ($hd) {
$trans_name .= '_HD';
}
$existed = Mysql::getInstance()->from('video')->where(array('path' => $trans_name))->get()->first();
if (!empty($existed)) {
$error = _('Error: The folder with that name already exists');
}
if (@$_GET['name'] && !$error) {
$master = new VideoMaster();
try {
$master->createMediaDir($trans_name, !empty($_POST['year']) ? $_POST['year'] : '');
} catch (MasterException $e) {
//var_dump($e->getMessage(), $e->getStorageName()); exit;
$moderator_storages = $master->getModeratorStorages();
if (!empty($moderator_storages[$e->getStorageName()])) {
$error = _('Error creating the folder on moderator storage');
}
}
}
if (@$_GET['name'] && !$error) {
Admin::checkAccess(AdminAccess::ACCESS_CREATE);
$video_id = Mysql::getInstance()->insert('video', array('name' => trim($_POST['name']), 'series' => serialize($series), 'o_name' => trim($_POST['o_name']), 'censored' => $censored, 'hd' => $hd, 'for_sd_stb' => $for_sd_stb, 'protocol' => $protocol, 'rtsp_url' => $rtsp_url, 'time' => @$_POST['time'], 'description' => $_POST['description'], 'genre_id_1' => $genre_id_1, 'genre_id_2' => $genre_id_2, 'genre_id_3' => $genre_id_3, 'genre_id_4' => $genre_id_4, 'cat_genre_id_1' => $cat_genre_id_1, 'cat_genre_id_2' => $cat_genre_id_2, 'cat_genre_id_3' => $cat_genre_id_3, 'cat_genre_id_4' => $cat_genre_id_4, 'category_id' => $category_id, 'director' => $_POST['director'], 'actors' => $_POST['actors'], 'status' => $status, 'year' => $_POST['year'], 'volume_correction' => (int) $_POST['volume_correction'], 'kinopoisk_id' => $_POST['kinopoisk_id'], 'rating_kinopoisk' => $_POST['rating_kinopoisk'], 'rating_count_kinopoisk' => $_POST['rating_count_kinopoisk'], 'rating_imdb' => $_POST['rating_imdb'], 'rating_count_imdb' => $_POST['rating_count_imdb'], 'age' => $_POST['age'], 'rating_mpaa' => $_POST['rating_mpaa'], 'path' => $trans_name . (!empty($_POST['year']) ? "_{$_POST['year']}" : ''), 'high_quality' => $high_quality, 'low_quality' => $low_quality, 'comments' => $_POST['comments'], 'country' => $_POST['country'], 'added' => 'NOW()'))->insert_id();
if (!empty($_SESSION['upload'])) {
Mysql::getInstance()->query('DELETE from screenshots where media_id=' . intval($video_id) . ' and id not IN (' . @implode(',', $_SESSION['upload']) . ')');
Mysql::getInstance()->query('UPDATE screenshots SET media_id=' . intval($video_id) . ' WHERE id IN (' . @implode(',', $_SESSION['upload']) . ')');
unset($_SESSION['upload']);
}
if (@$_GET['save']) {
$trans_name = transliterate(@urldecode($_POST['name']));
if ($hd) {
$trans_name .= '_HD';
}
$sql = "select * from video where path='" . $trans_name . "'";
$rs = $db->executeQuery($sql);
$rows = @$rs->getRowCount();
if ($rows > 0) {
$error = _('Error: The folder with that name already exists');
}
if (@$_GET['name'] && !$error) {
$master = new VideoMaster();
try {
$master->createMediaDir($trans_name);
} catch (MasterException $e) {
//var_dump($e->getMessage(), $e->getStorageName()); exit;
$moderator_storages = $master->getModeratorStorages();
if (!empty($moderator_storages[$e->getStorageName()])) {
$error = _('Error creating the folder on moderator storage');
}
}
}
if (@$_GET['name'] && !$error) {
$name = mysql_escape_string(@$_POST['name']);
$o_name = mysql_escape_string(@$_POST['o_name']);
$director = mysql_escape_string(@$_POST['director']);
$year = @$_POST['year'];
$datetime = date("Y-m-d H:i:s");
$query = "insert into video (name,\n o_name,\n censored,\n hd,\n for_sd_stb,\n path,\n protocol,\n rtsp_url,\n time,\n description,\n genre_id_1,\n genre_id_2,\n genre_id_3,\n genre_id_4,\n cat_genre_id_1,\n cat_genre_id_2,\n cat_genre_id_3,\n cat_genre_id_4,\n category_id,\n director,\n actors,\n added,\n status,\n year,\n volume_correction,\n kinopoisk_id,\n rating_kinopoisk,\n rating_count_kinopoisk,\n rating_imdb,\n rating_count_imdb\n ) \n values ('" . trim(mysql_real_escape_string($name)) . "',\n '" . trim(mysql_real_escape_string($o_name)) . "',\n '" . $censored . "',\n '" . $hd . "',\n '" . $for_sd_stb . "',\n '" . $trans_name . "',\n '" . $protocol . "',\n '" . $rtsp_url . "',\n '" . @$_POST['time'] . "',\n '" . mysql_real_escape_string(@$_POST['description']) . "',\n '" . $genre_id_1 . "',\n '" . $genre_id_2 . "',\n '" . $genre_id_3 . "',\n '" . $genre_id_4 . "',\n '" . $cat_genre_id_1 . "',\n '" . $cat_genre_id_2 . "',\n '" . $cat_genre_id_3 . "',\n '" . $cat_genre_id_4 . "',\n '" . $category_id . "',\n '" . $director . "',\n '" . mysql_real_escape_string(@$_POST['actors']) . "',\n '" . $datetime . "',\n {$status},\n '" . $year . "',\n " . intval($_POST['volume_correction']) . ",\n '" . $_POST['kinopoisk_id'] . "',\n '" . $_POST['rating_kinopoisk'] . "',\n '" . $_POST['rating_count_kinopoisk'] . "',\n '" . $_POST['rating_imdb'] . "',\n '" . $_POST['rating_count_imdb'] . "'\n )";
