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