public function getToplist()
{
$dt = time() - 86400 * 90;
// Display toplists for movies added during the last XX days
$sth = $this->db->query("SELECT COUNT(*) AS cnt, bevaka.id, bevaka.typ, bevaka.imdbid as iamwatching, bevaka.imdbid AS imdbinfoid, imdbinfo.photo, imdbinfo.imdbid, imdbinfo.seasoncount, imdbinfo.title, imdbinfo.year, imdbinfo.imdbid AS imdbid2, (SELECT bevaka.id FROM bevaka WHERE bevaka.userid = " . $this->user->getId() . " AND bevaka.imdbid = iamwatching) AS myBevakId FROM `bevaka` JOIN imdbinfo ON bevaka.imdbid = imdbinfo.id WHERE bevaka.typ = 0 AND bevaka.datum > FROM_UNIXTIME(" . $dt . ") GROUP BY imdbid ORDER BY cnt DESC LIMIT 50");
$movies = $sth->fetchAll(PDO::FETCH_ASSOC);
$dt = time() - 86400 * 180;
// Display toplists for movies added during the last XX days
$sth = $this->db->query("SELECT COUNT(*) AS cnt, bevaka.id, bevaka.typ, bevaka.imdbid as iamwatching, bevaka.imdbid AS imdbinfoid, imdbinfo.photo, imdbinfo.imdbid, imdbinfo.seasoncount, imdbinfo.title, imdbinfo.year, imdbinfo.imdbid AS imdbid2, (SELECT bevaka.id FROM bevaka WHERE bevaka.userid = " . $this->user->getId() . " AND bevaka.imdbid = iamwatching) AS myBevakId FROM `bevaka` JOIN imdbinfo ON bevaka.imdbid = imdbinfo.id WHERE bevaka.typ = 1 AND bevaka.datum > FROM_UNIXTIME(" . $dt . ") GROUP BY imdbid ORDER BY cnt DESC LIMIT 50");
$tvseries = $sth->fetchAll(PDO::FETCH_ASSOC);
return array("movies" => $movies, "tvseries" => $tvseries);
} break;
case validateRoute('POST', 'users/\\d+/watching'):
$watching = new Watching($db, $user);
httpResponse($watching->create($params[1], $postdata));
break;
case validateRoute('PATCH', 'users/\\d+/watching/\\d+'):
$watching = new Watching($db, $user);
httpResponse($watching->update($params[1], $params[3], $postdata));
break;
case validateRoute('DELETE', 'users/\\d+/watching/\\d+'):
$watching = new Watching($db, $user);
httpResponse($watching->delete($params[1], $params[3]));
break;
case validateRoute('GET', 'users/\\d+/watching/toplist'):
$watching = new Watching($db, $user);
httpResponse($watching->getToplist());
break;
case validateRoute('GET', 'watching-subtitles'):
$watchSubtitles = new WatchingSubtitles($db, $user);
httpResponse($watchSubtitles->query(null));
break;
case validateRoute('GET', 'watching-subtitles/\\d+'):
$watchSubtitles = new WatchingSubtitles($db, $user);
httpResponse($watchSubtitles->get($params[1]));
break;
case validateRoute('POST', 'watching-subtitles'):
$watchSubtitles = new WatchingSubtitles($db, $user);
httpResponse($watchSubtitles->create($postdata));
break;
case validateRoute('DELETE', 'watching-subtitles/\\d+'):
$watchSubtitles = new WatchingSubtitles($db, $user);