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