function next_foto($db, $programm)
{
global $config;
global $text;
$user = $db->real_escape_string($_SESSION['us']);
$starter = 0;
switch ($programm) {
// ignored
case "0":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 0 ORDER BY `votefiles`.`sorttime` DESC";
break;
// 1 star
// 1 star
case "1":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 1 ORDER BY `votefiles`.`sorttime` DESC";
break;
// 2 stars
// 2 stars
case "2":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 2 ORDER BY `votefiles`.`sorttime` DESC";
break;
// 3 stars
// 3 stars
case "3":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 3 ORDER BY `votefiles`.`sorttime` DESC";
break;
// 4 stars
// 4 stars
case "4":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 4 ORDER BY `votefiles`.`sorttime` DESC";
break;
// 5 stars
// 5 stars
case "5":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 5 ORDER BY `votefiles`.`sorttime` DESC";
break;
// unseen
// unseen
default:
// offset in three-torus universe
if (isset($_GET["n"])) {
$starter = $_GET["n"];
$sql = "SELECT count(*) AS max FROM (SELECT `name`, `vote` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0) AND `user` != '{$user}' ORDER BY `" . $config['dbprefix'] . "fotos`.`vote` ASC) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` IS NULL";
$res = $db->query($sql);
$row = $res->fetch_array(MYSQLI_ASSOC);
if ($starter >= $row['max']) {
$starter = 0;
}
if ($starter < 0) {
$starter = $row['max'] + $starter;
}
} else {
$starter = 0;
}
// unseen
// use this and delete the line after for random order (code from removed feature)
// $sql = "SELECT * FROM (SELECT `name`, `vote` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '$user') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0) AND `user` != '$user' ORDER BY `" . $config['dbprefix'] . "fotos`.`vote` ASC, `" . $config['dbprefix'] . "fotos`.`url` ASC) votefotos ON `votefiles`.`name` LIKE `votefotos`.`name` WHERE `votefiles`.`vote` IS NULL LIMIT $starter, 1";
$sql = "SELECT * FROM (SELECT `name`, `vote` FROM `" . $config['dbprefix'] . "v_votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`online` = 1 OR `online` = 2) AND (`exclude` = 0) AND `user` != '{$user}' ORDER BY `" . $config['dbprefix'] . "fotos`.`vote` ASC) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` IS NULL LIMIT {$starter}, 1";
$programm = "";
break;
}
return display_foto($db, $sql, $programm, $starter);
}
function next_foto($db, $programm)
{
global $config;
global $text;
$user = $db->real_escape_string($_SESSION['us']);
$starter = 0;
switch ($programm) {
case "gemerkt":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "votes` WHERE `user` = '{$user}' AND `vote` = 1) votefiles LEFT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`jury` = 1)) votefotos ON `votefiles`.`name` = `votefotos`.`name` ORDER BY `votefiles`.`sorttime` DESC";
break;
case "selected":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`jury` = 1)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 2 ORDER BY `votefiles`.`sorttime` DESC";
break;
case "notselected":
$sql = "SELECT * FROM (SELECT `name`, `vote`, `time` AS `sorttime` FROM `" . $config['dbprefix'] . "votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`jury` = 1)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` = 10 ORDER BY `votefiles`.`sorttime` DESC";
break;
case "ungelesen":
$sql = "SELECT * FROM (SELECT `name`, `vote` FROM `" . $config['dbprefix'] . "votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`jury` = 1)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` IS NULL";
break;
default:
if (isset($_GET["n"])) {
$starter = $_GET["n"];
$sql = "SELECT count(*) AS max FROM (SELECT `name`, `vote` FROM `" . $config['dbprefix'] . "votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`jury` = 1)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` IS NULL";
$res = $db->query($sql);
$row = $res->fetch_array(MYSQLI_ASSOC);
if ($starter >= $row['max']) {
$starter = 0;
}
if ($starter < 0) {
$starter = $row['max'] + $starter;
}
} else {
$starter = 0;
}
$sql = "SELECT * FROM (SELECT `name`, `vote` FROM `" . $config['dbprefix'] . "votes` WHERE `user` = '{$user}') votefiles RIGHT JOIN (SELECT * FROM `" . $config['dbprefix'] . "fotos` WHERE (`jury` = 1)) votefotos ON `votefiles`.`name` = `votefotos`.`name` WHERE `votefiles`.`vote` IS NULL LIMIT {$starter}, 1";
$programm = "";
break;
}
return display_foto($db, $sql, $programm, $starter);
}
