public function generateAjax() { $this->contentType = Kernel::CONTENT_TYPE_XML; $removeNode = Util::tagToXml('remove', $this->rootNode); if (isset($this->url->getPageParams()->filter)) { if (!empty($_POST)) { //Kernel::addInfo(Kernel::INFOBOX_INFO, "Filter test! ".$_POST['filter']." ".$_POST['timelimit']); AVM::setFilter($_POST['filter']); AVM::setTimelimit($_POST['timelimit']); $this->feedList(); } } else { if (isset($this->url->getPageParams()->watched)) { if (isset($this->url->getPageParams()->id)) { $id = $this->url->getPageParams()->id; $type = $this->url->getPageParams()->watched; if ($type == 'movie') { Kernel::mysqli()->query("INSERT INTO movie (id, name, year, url, format, watched, file, torrent, ver)\n\t\t\t\t\t\t\t\t\t\t\t SELECT id, name, year, url, format, NOT watched, file, torrent, (ver + 1) FROM movie WHERE id={$id} ORDER BY ver DESC LIMIT 1"); Kernel::addInfo(Kernel::INFOBOX_OK, "Watched status changed!"); Util::objToXml((object) array('id' => $id), $removeNode, 'movie'); } else { if ($type == 'episode') { Kernel::mysqli()->query("INSERT INTO episode (id, serieid, seasonid, episode, title, format, watched, file, torrent, ver)\n\t\t\t\t\t\t\t\t\t\t\t SELECT id, serieid, seasonid, episode, title, format, NOT watched, file, torrent, (ver + 1) FROM episode WHERE id={$id} ORDER BY ver DESC LIMIT 1"); Kernel::addInfo(Kernel::INFOBOX_OK, "Watched status changed!"); Util::objToXml((object) array('id' => $id), $removeNode, 'episode'); } } } } } }
public static function mysqli() { if (!isset(Kernel::$mysqli)) { Kernel::$mysqli = new mysqli(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE); Kernel::$mysqli->set_charset('utf8'); if (Kernel::$mysqli->connect_error) { Kernel::addInfo(INFOBOX_ERROR, 'MySQLi connection failed.'); } } return Kernel::$mysqli; }
public function generateAjax() { $this->contentType = Kernel::CONTENT_TYPE_XML; if (isset($this->url->getPageParams()->edit)) { $this->template = NULL; // No xsl transform! $this->contentType = Kernel::CONTENT_TYPE_PLAIN; if (!empty($_POST)) { if (!isset($_POST['id']) || !isset($_POST['value'])) { return; } $elementInfo = explode(':', $_POST['id']); $id = Kernel::mysqli()->escape_string($elementInfo[1]); $value = Kernel::mysqli()->escape_string($_POST['value']); $seekResult = Kernel::mysqli()->query("SELECT * FROM seek WHERE id = {$id} LIMIT 1"); $seekObj = $seekResult->fetch_object(); $seekResult->close(); $element = Kernel::mysqli()->escape_string($elementInfo[0]); if ($element == 'name') { $seekObj->name = $value; } else { if ($element == 'year') { $seekObj->year = $value; } else { if ($element == 'url') { $seekObj->url = $value; } } } Kernel::mysqli()->query("UPDATE seek SET name='{$seekObj->name}', year={$seekObj->year}, url='{$seekObj->url}' WHERE id={$id}"); echo $value; } } else { if (isset($this->url->getPageParams()->add)) { if (!empty($_POST)) { if (empty($_POST['name'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter name.'); } else { $name = Kernel::mysqli()->escape_string($_POST['name']); $year = Kernel::mysqli()->escape_string($_POST['year']); $url = Kernel::mysqli()->escape_string($_POST['url']); Kernel::mysqli()->query("INSERT INTO seek (name, year, url)\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$name}','{$year}','{$url}')"); $this->seekList(0, 15); Kernel::addInfo(Kernel::INFOBOX_OK, "{$name} ({$year}) added!"); } } } } }
public function generate() { if (isset($this->url->getPageParams()->logout)) { Sessionmanager::logout(); $this->url->setPage('Login'); $this->url->clearPageParams(); header('Location: ' . $this->url->buildUrlString()); } else { if (!empty($_POST)) { if (Sessionmanager::login($_POST['username'], $_POST['password'])) { header('Location: ' . $this->url->buildUrlString()); } else { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'Login failed.'); } } } }
public function generateAjax() { $this->template = 'AVM'; if (isset($this->url->getPageParams()->getserielist)) { $this->template = NULL; // No xsl transform! $this->contentType = Kernel::CONTENT_TYPE_JSON; $serieArray = array(array('id' => '0', 'name' => '-- Select serie')); $seriesResult = Kernel::mysqli()->query("SELECT a.* FROM serie a WHERE a.ver IN (SELECT MAX(b.ver) FROM serie b WHERE b.id = a.id)"); if (is_object($seriesResult)) { while ($serieObj = $seriesResult->fetch_object()) { $serieArray[] = $serieObj; } $seriesResult->close(); } echo json_encode($serieArray); } else { if (isset($this->url->getPageParams()->getseasonlist)) { $this->template = NULL; // No xsl transform! $this->contentType = Kernel::CONTENT_TYPE_JSON; $this->template = null; if (isset($this->url->getPageParams()->id)) { $id = Kernel::mysqli()->escape_string($this->url->getPageParams()->id); $details = $this->getFileDetailsObjFromUrl(); $seasonArray = array(); $seasonsResult = Kernel::mysqli()->query("SELECT a.id, a.season FROM season a WHERE a.ver IN (SELECT MAX(b.ver) FROM season b WHERE b.id = a.id AND serieid = {$id})"); if (is_object($seasonsResult)) { while ($seasonObj = $seasonsResult->fetch_object()) { if ($details->season == $seasonObj->season) { $seasonObj->selected = true; } $seasonArray[] = $seasonObj; } $seasonsResult->close(); } echo json_encode($seasonArray); } } else { if (isset($this->url->getPageParams()->addserie)) { if (!empty($_POST)) { if (empty($_POST['name'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter serie name.'); } else { if (empty($_POST['year'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter serie year.'); } else { $name = Kernel::mysqli()->escape_string($_POST['name']); $year = Kernel::mysqli()->escape_string($_POST['year']); $url = Kernel::mysqli()->escape_string($_POST['url']); $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO serie (name, year, url, file, torrent)\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$name}','{$year}','{$url}','{$file}','{$torrent}')"); Kernel::addInfo(Kernel::INFOBOX_OK, "Serie {$name} ({$year}) added!"); } } } } else { if (isset($this->url->getPageParams()->addseason)) { if (!empty($_POST)) { if (empty($_POST['serieid'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must select serie.'); } else { if (empty($_POST['season'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter season number.'); } else { $serieid = Kernel::mysqli()->escape_string($_POST['serieid']); $season = Kernel::mysqli()->escape_string($_POST['season']); $state = Kernel::mysqli()->escape_string($_POST['state']); $watched = Kernel::mysqli()->escape_string($_POST['watched']); $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO season (serieid, season, state, watched, file, torrent)\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$serieid}','{$season}','{$state}','{$watched}','{$file}','{$torrent}')"); Kernel::addInfo(Kernel::INFOBOX_OK, "Season {$season} added!"); } } } } else { if (isset($this->url->getPageParams()->addepisode)) { if (!empty($_POST)) { if (empty($_POST['serieid'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must select serie.'); } else { if (empty($_POST['seasonid'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must select season.'); } else { if (empty($_POST['episode'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter episode number.'); } else { if (empty($_POST['title'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter title.'); } else { if (!isset($_POST['format'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter format.'); } else { $serieid = Kernel::mysqli()->escape_string($_POST['serieid']); $seasonid = Kernel::mysqli()->escape_string($_POST['seasonid']); $episode = Kernel::mysqli()->escape_string($_POST['episode']); $title = Kernel::mysqli()->escape_string($_POST['title']); $format = AVM::$videoFormat[Kernel::mysqli()->escape_string($_POST['format'])]; $watched = Kernel::mysqli()->escape_string($_POST['watched']); $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO episode (serieid, seasonid, episode, title, format, watched, file, torrent)\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$serieid}','{$seasonid}','{$episode}', '{$title}', '{$format}','{$watched}','{$file}','{$torrent}')"); Kernel::addInfo(Kernel::INFOBOX_OK, "Episode {$title} ({$episode}) [{$format}] added!"); } } } } } } } else { if (isset($this->url->getPageParams()->addmovie)) { if (!empty($_POST)) { if (empty($_POST['name'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter movie name.'); } else { if (empty($_POST['year'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter year.'); } else { if (!isset($_POST['format'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter format.'); } else { $name = Kernel::mysqli()->escape_string($_POST['name']); $year = Kernel::mysqli()->escape_string($_POST['year']); $url = Kernel::mysqli()->escape_string($_POST['url']); $format = AVM::$videoFormat[Kernel::mysqli()->escape_string($_POST['format'])]; $watched = Kernel::mysqli()->escape_string($_POST['watched']); $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO movie (name, year, url, format, watched, file, torrent)\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$name}','{$year}','{$url}','{$format}','{$watched}','{$file}','{$torrent}')"); Kernel::addInfo(Kernel::INFOBOX_OK, "{$name} ({$year}) [{$format}] added!"); } } } } } } } } } } }
public function generateAjax() { $this->contentType = Kernel::CONTENT_TYPE_XML; if (isset($this->url->getPageParams()->edit)) { $this->template = NULL; // No xsl transform! $this->contentType = Kernel::CONTENT_TYPE_PLAIN; if (!empty($_POST)) { if (!isset($_POST['id']) || !isset($_POST['value'])) { return; } $elementInfo = explode(':', $_POST['id']); $id = Kernel::mysqli()->escape_string($elementInfo[1]); $value = Kernel::mysqli()->escape_string($_POST['value']); $movieResult = Kernel::mysqli()->query("SELECT * FROM movie WHERE id = {$id} ORDER BY ver DESC LIMIT 1"); $movieObj = $movieResult->fetch_object(); $movieResult->close(); $element = Kernel::mysqli()->escape_string($elementInfo[0]); if ($element == 'name') { $movieObj->name = $value; } else { if ($element == 'year') { $movieObj->year = $value; } else { if ($element == 'url') { $movieObj->url = $value; } else { if ($element == 'format') { $value = AVM::$videoFormat[$value]; $movieObj->format = $value; } else { if ($element == 'watched') { $movieObj->watched = $value; } else { if ($element == 'file') { $movieObj->file = $value; } else { if ($element == 'torrent') { $movieObj->torrent = $value; } } } } } } } Kernel::mysqli()->query("INSERT INTO movie (id, name, year, url, format, watched, file, torrent, ver)\r\n\t\t\t\t\t\t\t\t\t\t SELECT {$movieObj->id}, '{$movieObj->name}', {$movieObj->year}, '{$movieObj->url}', '{$movieObj->format}', {$movieObj->watched}, '{$movieObj->file}', '{$movieObj->torrent}', (coalesce(max(ver), 0) + 1) FROM movie WHERE id={$id}"); echo $value; } } else { if (isset($this->url->getPageParams()->watched)) { if (isset($this->url->getPageParams()->id)) { $id = $this->url->getPageParams()->id; Kernel::mysqli()->query("INSERT INTO movie (id, name, year, url, format, watched, file, torrent, ver)\r\n\t\t\t\t\t\t\t\t\t\t SELECT id, name, year, url, format, NOT watched, file, torrent, (ver + 1) FROM movie WHERE id={$id} ORDER BY ver DESC LIMIT 1"); Kernel::addInfo(Kernel::INFOBOX_OK, "Watched status changed!"); $movieResult = Kernel::mysqli()->query("SELECT * FROM movie WHERE id = {$id} ORDER BY ver DESC LIMIT 1"); $movieObj = $movieResult->fetch_object(); $movieResult->close(); Util::objToXml($movieObj, $this->rootNode, 'movie'); } } else { if (isset($this->url->getPageParams()->add)) { if (!empty($_POST)) { if (empty($_POST['name'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter movie name.'); } else { if (empty($_POST['year'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter year.'); } else { $name = Kernel::mysqli()->escape_string($_POST['name']); $year = Kernel::mysqli()->escape_string($_POST['year']); $url = Kernel::mysqli()->escape_string($_POST['url']); $format = AVM::$videoFormat[Kernel::mysqli()->escape_string($_POST['format'])]; $watched = empty($_POST['watched']) ? 0 : 1; $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO movie (name, year, url, format, watched, file, torrent)\r\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$name}','{$year}','{$url}','{$format}','{$watched}','{$file}','{$torrent}')"); //$id = Kernel::mysqli()->insert_id; $this->movieList(0, 15); Kernel::addInfo(Kernel::INFOBOX_OK, "{$name} ({$year}) [{$format}] added!"); /* $movieResult = Kernel::mysqli()->query("SELECT * FROM movie WHERE id = $id ORDER BY ver DESC LIMIT 1"); $movieObj = $movieResult->fetch_object(); $movieResult->close(); Util::objToXml($movieObj, $this->rootNode, 'movie'); */ } } } } } } }
public function generateAjax() { if (isset($this->url->getPageParams()->seed)) { if (isset($this->url->getPageParams()->serie)) { $id = $this->url->getPageParams()->serie; Kernel::addInfo(Kernel::INFOBOX_OK, "Seeding started!"); } else { if (isset($this->url->getPageParams()->season)) { $id = $this->url->getPageParams()->season; Kernel::addInfo(Kernel::INFOBOX_OK, "Seeding started!"); } else { if (isset($this->url->getPageParams()->episode)) { $id = $this->url->getPageParams()->episode; Kernel::addInfo(Kernel::INFOBOX_OK, "Seeding started!"); } } } } else { if (isset($this->url->getPageParams()->watched)) { if (isset($this->url->getPageParams()->season)) { $id = $this->url->getPageParams()->season; Kernel::mysqli()->query("INSERT INTO season (id, serieid, season, state, watched, file, torrent, ver)\r\n\t\t\t\t\t\t\t\t\t\t SELECT id, serieid, season, state, NOT watched, file, torrent, (ver + 1) FROM season WHERE id={$id} ORDER BY ver DESC LIMIT 1"); Kernel::addInfo(Kernel::INFOBOX_OK, "Watched status changed!"); $this->getSeason($id); } else { if (isset($this->url->getPageParams()->episode)) { $id = $this->url->getPageParams()->episode; Kernel::mysqli()->query("INSERT INTO episode (id, serieid, seasonid, episode, title, format, watched, file, torrent, ver)\r\n\t\t\t\t\t\t\t\t\t\t SELECT id, serieid, seasonid, episode, title, format, NOT watched, file, torrent, (ver + 1) FROM episode WHERE id={$id} ORDER BY ver DESC LIMIT 1"); Kernel::addInfo(Kernel::INFOBOX_OK, "Watched status changed!"); $this->getEpisode($id); } } } else { if (isset($this->url->getPageParams()->getserielist)) { $this->template = NULL; // No xsl transform! $this->contentType = Kernel::CONTENT_TYPE_JSON; $serieArray = array(array('id' => '0', 'name' => '-- Select serie')); $seriesResult = Kernel::mysqli()->query("SELECT a.* FROM serie a WHERE a.ver IN (SELECT MAX(b.ver) FROM serie b WHERE b.id = a.id) ORDER BY name"); if (is_object($seriesResult)) { while ($serieObj = $seriesResult->fetch_object()) { $serieArray[] = $serieObj; } $seriesResult->close(); } echo json_encode($serieArray); } else { if (isset($this->url->getPageParams()->getseasonlist)) { $this->template = NULL; // No xsl transform! $this->contentType = Kernel::CONTENT_TYPE_JSON; if (isset($this->url->getPageParams()->id)) { $id = Kernel::mysqli()->escape_string($this->url->getPageParams()->id); $seasonArray = array(); $seasonsResult = Kernel::mysqli()->query("SELECT a.id, a.season FROM season a WHERE a.ver IN (SELECT MAX(b.ver) FROM season b WHERE b.id = a.id AND serieid = {$id}) ORDER BY season"); if (is_object($seasonsResult)) { while ($seasonObj = $seasonsResult->fetch_object()) { $seasonArray[] = $seasonObj; } } $seasonsResult->close(); echo json_encode($seasonArray); } } else { if (isset($this->url->getPageParams()->edit)) { $this->template = NULL; // No xsl transform! $this->contentType = Kernel::CONTENT_TYPE_PLAIN; if (!empty($_POST)) { $typeInfo = explode(':', $this->url->getPageParams()->id); $type = Kernel::mysqli()->escape_string($typeInfo[0]); if ($type == 'serie') { if (!isset($_POST['id']) || !isset($_POST['value'])) { return; } $elementInfo = explode(':', $_POST['id']); $id = Kernel::mysqli()->escape_string($elementInfo[0]); $value = Kernel::mysqli()->escape_string($_POST['value']); $serieResult = Kernel::mysqli()->query("SELECT * FROM serie WHERE id = {$id} ORDER BY ver DESC LIMIT 1"); $serieObj = $serieResult->fetch_object(); $serieResult->close(); $element = Kernel::mysqli()->escape_string($elementInfo[1]); if ($element == 'name') { $serieObj->name = $value; } else { if ($element == 'year') { $serieObj->year = $value; } else { if ($element == 'url') { $serieObj->url = $value; } else { if ($element == 'file') { $serieObj->file = $value; } else { if ($element == 'torrent') { $serieObj->torrent = $value; } } } } } Kernel::mysqli()->query("INSERT INTO serie (id, name, year, url, file, torrent, ver)\r\n\t\t\t\t\t\t\t\t\t\t\t SELECT {$serieObj->id}, '{$serieObj->name}', {$serieObj->year}, '{$serieObj->url}', '{$serieObj->file}', '{$serieObj->torrent}', (coalesce(max(ver), 0) + 1) FROM serie WHERE id={$id}"); echo $value; } else { if ($type == 'season') { if (!isset($_POST['id']) || !isset($_POST['value'])) { return; } $elementInfo = explode(':', $_POST['id']); $id = Kernel::mysqli()->escape_string($elementInfo[0]); $value = Kernel::mysqli()->escape_string($_POST['value']); $seasonResult = Kernel::mysqli()->query("SELECT * FROM season WHERE id = {$id} ORDER BY ver DESC LIMIT 1"); $seasonObj = $seasonResult->fetch_object(); $seasonResult->close(); $element = Kernel::mysqli()->escape_string($elementInfo[1]); if ($element == 'season') { $seasonObj->season = $value; } else { if ($element == 'state') { $seasonObj->state = $value; } else { if ($element == 'watched') { $seasonObj->watched = $value; } else { if ($element == 'file') { $seasonObj->file = $value; } else { if ($element == 'torrent') { $seasonObj->torrent = $value; } } } } } Kernel::mysqli()->query("INSERT INTO season (id, serieid, season, state, watched, file, torrent, ver)\r\n\t\t\t\t\t\t\t\t\t\t\t SELECT {$seasonObj->id}, {$seasonObj->serieid}, {$seasonObj->season}, '{$seasonObj->state}', {$seasonObj->watched}, '{$seasonObj->file}', '{$seasonObj->torrent}', (coalesce(max(ver), 0) + 1) FROM season WHERE id={$id}"); echo $value; } else { if ($type == 'episode') { if (!isset($_POST['id']) || !isset($_POST['value'])) { return; } $elementInfo = explode(':', $_POST['id']); $id = Kernel::mysqli()->escape_string($elementInfo[0]); $value = Kernel::mysqli()->escape_string($_POST['value']); $episodeResult = Kernel::mysqli()->query("SELECT * FROM episode WHERE id = {$id} ORDER BY ver DESC LIMIT 1"); $episodeObj = $episodeResult->fetch_object(); $episodeResult->close(); $element = Kernel::mysqli()->escape_string($elementInfo[1]); if ($element == 'episode') { $episodeObj->episode = $value; $value = str_pad($value, 2, "0", STR_PAD_LEFT); } else { if ($element == 'title') { $episodeObj->title = $value; } else { if ($element == 'format') { $value = AVM::$videoFormat[$value]; $episodeObj->format = $value; } else { if ($element == 'watched') { $episodeObj->watched = $value; } else { if ($element == 'file') { $episodeObj->file = $value; } else { if ($element == 'torrent') { $episodeObj->torrent = $value; } } } } } } Kernel::mysqli()->query("INSERT INTO episode (id, serieid, seasonid, episode, title, format, watched, file, torrent, ver)\r\n\t\t\t\t\t\t\t\t\t\t\t SELECT {$episodeObj->id}, {$episodeObj->serieid}, {$episodeObj->seasonid}, {$episodeObj->episode}, '{$episodeObj->title}', '{$episodeObj->format}', {$episodeObj->watched}, '{$episodeObj->file}', '{$episodeObj->torrent}', (coalesce(max(ver), 0) + 1) FROM episode WHERE id={$id}"); echo $value; } } } } } else { if (isset($this->url->getPageParams()->addserie)) { if (!empty($_POST)) { if (empty($_POST['name'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter serie name.'); } else { if (empty($_POST['year'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter serie year.'); } else { $name = Kernel::mysqli()->escape_string($_POST['name']); $year = Kernel::mysqli()->escape_string($_POST['year']); $url = Kernel::mysqli()->escape_string($_POST['url']); $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO serie (name, year, url, file, torrent)\r\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$name}','{$year}','{$url}','{$file}','{$torrent}')"); $this->serieList(0, 15); Kernel::addInfo(Kernel::INFOBOX_OK, "Serie {$name} ({$year}) added!"); } } } } else { if (isset($this->url->getPageParams()->addseason)) { if (!empty($_POST)) { if (empty($_POST['serieid'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must select serie.'); } else { if (empty($_POST['season'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter season number.'); } else { $serieid = Kernel::mysqli()->escape_string($_POST['serieid']); $season = Kernel::mysqli()->escape_string($_POST['season']); $state = Kernel::mysqli()->escape_string($_POST['state']); $watched = empty($_POST['watched']) ? 0 : 1; $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO season (serieid, season, state, watched, file, torrent)\r\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$serieid}','{$season}','{$state}','{$watched}','{$file}','{$torrent}')"); $this->serieList(0, 15); Kernel::addInfo(Kernel::INFOBOX_OK, "Season {$season} added!"); } } } } else { if (isset($this->url->getPageParams()->addepisode)) { if (!empty($_POST)) { if (empty($_POST['serieid'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must select serie.'); } else { if (empty($_POST['seasonid'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must select season.'); } else { if (empty($_POST['episode'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter episode number.'); } else { if (empty($_POST['title'])) { Kernel::addInfo(Kernel::INFOBOX_ERROR, 'You must enter title.'); } else { $serieid = Kernel::mysqli()->escape_string($_POST['serieid']); $seasonid = Kernel::mysqli()->escape_string($_POST['seasonid']); $episode = Kernel::mysqli()->escape_string($_POST['episode']); $title = Kernel::mysqli()->escape_string($_POST['title']); $format = AVM::$videoFormat[Kernel::mysqli()->escape_string($_POST['format'])]; $watched = empty($_POST['watched']) ? 0 : 1; $file = Kernel::mysqli()->escape_string($_POST['file']); $torrent = Kernel::mysqli()->escape_string($_POST['torrent']); Kernel::mysqli()->query("INSERT INTO episode (serieid, seasonid, episode, title, format, watched, file, torrent)\r\n\t\t\t\t\t\t\t\t\t\t\tVALUES('{$serieid}','{$seasonid}','{$episode}', '{$title}', '{$format}','{$watched}','{$file}','{$torrent}')"); $this->serieList(0, 15); Kernel::addInfo(Kernel::INFOBOX_OK, "Episode {$title} ({$episode}) [{$format}] added!"); } } } } } } } } } } } } } }