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!");
}
}
}
}
}
}
}
}
}
}
}
}
}
}
