public function get_main()
{
$type = Check::isUserType();
if ($type == 'admin') {
$sql = 'SELECT * FROM `films-info` WHERE status = \'OK\' ORDER BY date_add DESC';
} elseif ($type == 'user') {
$sql = 'SELECT * FROM `films-info` WHERE permission = \'user\' OR permission = \'all\' AND status = \'OK\' ORDER BY date_add DESC';
} else {
$sql = 'SELECT * FROM `films-info` WHERE permission = \'all\' AND status = \'OK\' ORDER BY date_add DESC';
}
$result = mysql_query($sql);
if ($result) {
$content = '<h1 class="video-title">Новинки мирового кинопроката и блокбастеры</h1>';
while ($film = mysql_fetch_object($result)) {
$genre = explode(',', $film->genre);
$content .= '<div class="video">
<img src="' . $film->image . '">
<div class="video_content">
<p><a class="" href="/film/index/' . $film->href . '">' . $film->name . '</a></p>
<p class="video_info">' . $film->year . ', ' . $film->country . ', ' . $genre[0] . '</p>
</div>
</div>';
}
$json['header'] = 'main';
$json['content'] = $content;
return json_encode($json);
} else {
echo mysql_error();
}
}
public function get_films()
{
$type = Check::isUserType();
if ($type == 'admin') {
$sql = 'SELECT * FROM `films-info` WHERE status = \'OK\' AND type = \'film\' ORDER BY date_add DESC';
} elseif ($type == 'user') {
$sql = 'SELECT * FROM `films-info` WHERE permission = \'user\' OR permission = \'all\' AND type = \'film\' AND status = \'OK\' ORDER BY date_add DESC';
} else {
$sql = 'SELECT * FROM `films-info` WHERE permission = \'all\' AND status = \'OK\' AND type = \'film\' ORDER BY date_add DESC';
}
$result = mysql_query($sql);
if ($result) {
return $result;
} else {
echo mysql_error();
}
}
