require "configs/infoskjerm.php";
if (!isset($_GET['skjerm_id']) || !is_numeric($_GET['skjerm_id'])) {
echo 'Ingen skjerm spesifisert.';
exit;
}
$Q_skjermer = mysql_query("select * from `skjermer` where `skjerm_id` = '" . (int) $_GET['skjerm_id'] . "'");
if (!mysql_num_rows($Q_skjermer)) {
echo 'Fant ikke skjermen.';
exit;
}
$skjerm = mysql_fetch_assoc($Q_skjermer);
if (!isset($_GET['dato'])) {
$tid = time();
$dag = 'Nåværende slides';
} else {
$tid = behandleDato($_GET['dato'], array('y', 'm', 'd'));
$dag = date('H:i d-m-Y', $tid);
}
$slides_nu = array();
$slides_andre = array();
for ($i = 1; $i <= $skjerm['skjerm_slidenr']; $i++) {
$slides_nu[$i] = array();
$slides_andre[$i] = array();
/* ## Nåværende slide ## */
$Q_slides = mysql_query("\n\tSELECT\n\t\ts.slide_id as slide_id, \n\t\ts.slide_navn as slide_navn,\n\t\tc.skjerm_id as skjerm_id,\n\t\tc.slide_fra as slide_fra,\n\t\tc.slide_til as slide_til,\n\t\tc.slide_nr as slide_nr,\n\t\tc.slide_pri as slide_pri,\n\t\ts.slide_innhold_heading, \n\t\ts.slide_innhold \n\tFROM `slides` s, `slides_connect` c\n\tWHERE\n\t\ts.`slide_id` = c.`slide_id` AND\n\t\tc.`skjerm_id` = '" . $skjerm['skjerm_id'] . "' AND\n\t\tc.`slide_nr` = '" . $i . "' AND\n\t\t(\n\t\t\t(\n\t\t\t\tc.slide_fra <= '" . $tid . "' and\n\t\t\t\tc.slide_til >= '" . $tid . "'\n\t\t\t) or (\n\t\t\t\tc.slide_fra <= '" . $tid . "' and\n\t\t\t\tc.slide_til = '0'\n\t\t\t) or (\n\t\t\t\tc.slide_fra = '0' and\n\t\t\t\tc.slide_til >= '" . $tid . "'\n\t\t\t) or (\n\t\t\t\tc.slide_fra = '0' and\n\t\t\t\tc.slide_til = '0'\n\t\t\t)\n\t\t)\n\tORDER BY\n\t\tc.slide_pri desc");
if (!mysql_num_rows($Q_slides)) {
$slides_nu[$i] = array('slide_id' => '', 'slide_navn' => 'Standardslide for skjerm', 'slide_pri' => '0');
} else {
$slides_nu[$i] = mysql_fetch_assoc($Q_slides);
while ($a = mysql_fetch_assoc($Q_slides)) {
$slides_andre[$i][$a['slide_id']] = $a;
function processInput_Date($var, $input)
{
return behandleDato($input, array('y', 'm', 'd', 'h', 'i'));
}
