Пример #1
0
 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');
                     }
                 }
             }
         }
     }
 }
Пример #2
0
 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;
 }
Пример #3
0
 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!");
                 }
             }
         }
     }
 }
Пример #4
0
 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.');
             }
         }
     }
 }
Пример #5
0
 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!");
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
 }
Пример #6
0
 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');
                             */
                         }
                     }
                 }
             }
         }
     }
 }
Пример #7
0
 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!");
                                                     }
                                                 }
                                             }
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
 }