tplPath = $style."/"; $styleArr = array("style1"=>1, "style2"=>2, "style3"=>2); $sql_stored_procedure = mysql_connect($mysqlHost,$mysqlUser,$mysqlPwd) or die ("Keine Verbindung zur Datenbank möglich: " .mysql_error(). "\n\n"); @mysql_select_db($mysqlDB, $sql_stored_procedure) or die("Auswahl der Datenbank fehlgeschlagen\n\n"); if(empty($_GET['channel'])) $channel = $defaultChannel; else $channel = $_GET['channel']; $sql = "CALL proc_sendeplan2('".$radioKey."', ".mysql_real_escape_string($channel).", 0); "; $res = mysql_query($sql); ######################################################################### ######## HOCHFORMAT ############################# HOCHFORMAT ############ ######################################################################### if($styleArr[$style] == 1) { $sql = "SELECT *, weekday(tdatum) AS weekday FROM temp_sendeplan2 ORDER BY tdatum, ttime; "; $res = mysql_query($sql); $newArrDate = array(); $content = ""; $lastDate = ""; $x = 1; $tplArr = array($tpl->load($tpl->tplPath."header.tpl"), $tpl->load($tpl->tplPath."oneTime1.tpl"), $tpl->load($tpl->tplPath."oneTime2.tpl"), $tpl->load($tpl->tplPath."text.tpl"), $tpl->load($tpl->tplPath."modOnAir.tpl")); while($row = mysql_fetch_array($res, MYSQL_ASSOC)) { if($lastDate != $row['tdatum']) { switch($row['weekday']) { case 0: $day = "Montag"; break; case 1: $day = "Dienstag"; break; case 2: $day = "Mittwoch"; break; case 3: $day = "Donnerstag"; break; case 4: $day = "Freitag"; break; case 5: $day = "Samstag"; break; case 6: $day = "Sonntag"; break; } $formatedDay = explode("-", $row['tdatum']); $formatedDay = $formatedDay[2].".".$formatedDay[1].".".$formatedDay[0]; $content .= $tpl->parse(array("day"=>$formatedDay, "tag"=>$day, "tplPath"=>$tpl->tplPath), $tplArr[0]); } if(file_exists("mods/".strtolower($row['tmod']).".jpg")) $pic = strtolower($row['tmod']); else $pic = "nopic"; if(!empty($row['ttxt'])) $text = $tpl->parse(array("text"=>$row['ttxt'], "tplPath"=>$tpl->tplPath), $tplArr[3]); else $text = ""; if($row['tdatum'] == date('Y-m-d', time())) { $today = ""; } else $today = ""; if( (substr($row['ttime'], 0, 2) == date("H") && $row['tdatum'] == date('Y-m-d', time())) || ((substr($row['ttime'], 0, 2)+1) == date("H") && $row['tdatum'] == date('Y-m-d', time()) && $row['tintervall'] == 2 )) { $mod = $tpl->parse(array("mod"=>$row['tmod']), $tplArr[4]); } else $mod = $row['tmod']; if(strlen(substr($row['ttime'], 0, 2)+$row['tintervall']) == 1) $addZero = "0"; else $addZero = ""; $content .= $tpl->parse(array("mod"=>$mod, "text"=>$text, "modpic"=>$pic, "modpictitle"=>$row['tmod'], "today"=>$today, "von"=>substr($row['ttime'], 0, 2), "bis"=>$addZero.(substr($row['ttime'], 0, 2)+$row['tintervall']), "tplPath"=>$tpl->tplPath), $tplArr[$x]); if($x == 1) $x = 2; else $x = 1; $lastDate = $row['tdatum']; } $toParse = $tpl->parse(array("content"=>$content), $tpl->load($tpl->tplPath."index.tpl")); } ######################################################################### ######## QUERFORMAT ############################# QUERFORMAT ############ ######################################################################### elseif($styleArr[$style] == 2) { $sql = "SELECT *, weekday(tdatum) AS weekday FROM temp_sendeplan2 ORDER BY ttime; "; $res = mysql_query($sql); $newArrTime = array(); $newArrTimeDateArr = array(); $lastTime = 0; $content = ""; $colums = 0; $f = 1; $tplArr = array($tpl->load($tpl->tplPath."newRow.tpl"), $tpl->load($tpl->tplPath."oneTime1.tpl"), $tpl->load($tpl->tplPath."oneTime2.tpl"), $tpl->load($tpl->tplPath."modPic.tpl"), $tpl->load($tpl->tplPath."time1.tpl"), $tpl->load($tpl->tplPath."time2.tpl")); while($row = mysql_fetch_array($res, MYSQL_ASSOC)) { if($lastTime != $row['ttime']) { if($colums <= 6) { for($u = $colums; $u <= 6; $u++) { $content .= $tpl->parse(array("mod"=>"", "modPic"=>""), $tplArr[$f]); } } $content .= $tplArr[0]; if($f == 1) $f = 2; else $f = 1; $colums = 0; } if($colums == 0) { $to = substr($row['ttime']+$row['tintervall'], 0, 2); if(strlen($to) == 1) $to = "0".$to; $content .= $tpl->parse(array("time"=>substr($row['ttime'], 0, 2)."-".$to." Uhr"), $tplArr[$f+3]); } for($y = $colums; $row['weekday'] > $y; $y++) { $content .= $tpl->parse(array("mod"=>"", "modPic"=>""), $tplArr[$f]); } if(file_exists("mods/".strtolower($row['tmod']).".jpg")) $pic = strtolower($row['tmod']); else $pic = "nopic"; if(!empty($row['ttxt'])) $text = $row['ttxt']; else $text = "N/A"; $content .= $tpl->parse(array("mod"=>$row['tmod'], "title"=>$text, "modPic"=>$tpl->parse(array("mod"=>$row['tmod'], "modPic"=>$pic), $tplArr[3])), $tplArr[$f]); $colums = $row['weekday']+1; $lastTime = $row['ttime']; } if((6-$colums) >= 0) for($d = 0; $d <= (6-$colums); $d++) $content .= $tpl->parse(array("mod"=>"", "modPic"=>""), $tplArr[$f]); $toParse = $tpl->parse(array("content"=>$content, "tplPath"=>$tpl->tplPath), $tpl->load($tpl->tplPath."index.tpl")); } echo $toParse; ?>