load('CALENDAR,KINOPRE');
if (!$wbbuserdata['can_kinopre_view']) {
access_error();
} else {
if ($_REQUEST[searchart]=="searchactor"){
$searchactorsel="selected";
}
elseif($_REQUEST[searchart]=="searchregie"){
$searchregiesel="selected";
}
else{
$searchfilmsel="selected";
}
eval ("\$kinopre_header = \"".$tpl->get("kinopre_header")."\";");
eval ("\$kinopre_footer = \"".$tpl->get("kinopre_footer")."\";");
if ($_GET[action]== '') {
list($current_month, $current_year, $prev_month, $prev_year, $prev_monthname, $next_month, $next_year, $next_monthname) = kinopre_check_date($_GET['month'], $_GET['year']);
$kinoday = "";
$kinoday = array();
$result = $db->query("SELECT * FROM bb".$n."_kinopre WHERE date LIKE '%$current_year-".(($current_month < 10) ? ("0") : (""))."$current_month-%' ORDER BY date ASC");
while ($rowday = $db->fetch_array($result)) {
$kinodaytemp = ereg_replace(".*\-0", "", $rowday['date']);
$kinodaytemp = ereg_replace(".*\-", "", $rowday['date']);
$kinoday[]= $kinodaytemp;
$datum_day = makedatum($rowday[uhrzeit]);
$day_id = $kinodaytemp;
$filme_day = "";
$sql3n=$db->query("SELECT * FROM bb".$n."_kinopre_filme WHERE dayid='$rowday[dayid]'");
$anzahl3 = mysql_num_rows($sql3n);
if($anzahl3>0){
while($rown=$db->fetch_array($sql3n))
{
$titel = stripslashes($rown['titel']);
$filmid = $rown['filmid'];
$sql4n=$db->query("SELECT * FROM bb".$n."_kinopre_filme_info WHERE filmid='$filmid'");
$anzahln=mysql_num_rows($sql4n);
if($anzahln>0)
{
while($sql6n=$db->fetch_array($sql4n))
{
$infoid = $sql6n['infoid'];
eval ("\$info_day = \"".$tpl->get("kinopre_day_info")."\";");
$filmtitel_day = "$titel";
}
}
else
{
$info_day = " ";
$filmtitel_day = "$titel";
}
eval ("\$imdb_day = \"".$tpl->get("kinopre_day_imdb")."\";");
eval ("\$filme_day .= \"".$tpl->get("kinopre_day_bit")."\";");
}
}
else{
eval ("\$filme_day .= \"".$tpl->get("kinopre_day_bit_nomovie")."\";");
}
eval ("\$day .= \"".$tpl->get("kinopre_day")."\";");
}
$start_day = intval($wbbuserdata['startweek']);
$current_day = $today_day;
$days_in_month = date("t", mktime(0,0,0, $current_month, "1", $current_year));
$first_day = date("w", mktime(0,0,0,$current_month,1,$current_year));
$weekCtr = $start_day;
for ($i = 0; $i < 7; $i++)
{
if ($weekCtr >= 7) { $weekCtr = $weekCtr - 7; }
$week[$i] = substr(getday($weekCtr), 0, 2);
$weekCtr++;
}
$first_day = $first_day - $start_day;
if ($first_day < 0) { $first_day = $first_day + 7; }
$current_month_name = getmonth($current_month);
$anzeige_monat = "$current_month_name $current_year";
$month_options = '';
for ($i = 1; $i < 13; $i++) $month_options .= makeoption($i, getmonth($i), '', 0);
$lastyearresult = $db->query("SELECT uhrzeit FROM bb".$n."_kinopre ORDER BY uhrzeit ASC LIMIT 0 , 1");
$anzahllastyear=mysql_num_rows($lastyearresult);
if($anzahllastyear>0){
while ($rowlastyear = $db->fetch_array($lastyearresult)) {
$lastyear = date("Y",$rowlastyear[uhrzeit]);
}
}
else{
$lastyear=$current_year;
}
$yearbits = '';
for ($i = $lastyear; $i < $today_year + 4; $i++) $yearbits .= makeoption($i , $i , '', 0);
eval("\$anzeige_monatwechsel = \"".$tpl->get("kinopre_calendar_goto")."\";");
for ($i=0;$i<7;$i++) {
eval("\$anzeige_tagenamen .= \"".$tpl->get("kinopre_calendar_weekday")."\";");
}
$day_counter = 1;
while($day_counter <= $days_in_month) {
$anzeige_tagenummer .= " \n";
for($i = 0; $i < 7; $i++) {
if ((($day_counter <= $days_in_month) && ($first_day != 0) && ($first_day == $i)) || (($day_counter <= $days_in_month) && ($first_day == 0))) {
if (($day_counter == $current_day)&&($current_month == $today_month)&&($current_year == $today_year)&&(in_array ($day_counter, $kinoday))) {
eval("\$anzeige_tagenummer .= \"".$tpl->get("kinopre_calendar_markday_kinoday")."\";");
}
elseif (($day_counter == $today_day)&&($current_month == $today_month)&&($current_year == $today_year)&&(!in_array ($day_counter, $kinoday))) {
eval("\$anzeige_tagenummer .= \"".$tpl->get("kinopre_calendar_markday")."\";");
}
elseif( in_array ($day_counter, $kinoday) )
{
eval("\$anzeige_tagenummer .= \"".$tpl->get("kinopre_calendar_kinoday")."\";");
}
else {
eval("\$anzeige_tagenummer .= \"".$tpl->get("kinopre_calendar_normalday")."\";");
}
$first_day = 0;
$day_counter++;
}
else {
eval("\$anzeige_tagenummer .= \"".$tpl->get("kinopre_calendar_blankday")."\";");
}
}
$anzeige_tagenummer .= "
\n";
}
eval("\$tagauswahl .= \"".$tpl->get("kinopre_calendar_klein")."\";");
eval ("\$kinofilme = \"".$tpl->get("kinopre_filme")."\";");
eval ("\$tpl->output(\"".$tpl->get("kinopre_haupt")."\");");
}
if ($_GET[action]=="infoview")
{
$infoid = addslashes(intval($_REQUEST['infoid']));
$sql1=$db->query("SELECT * FROM bb".$n."_kinopre_filme_info WHERE infoid='$infoid'");
while($row = $db->fetch_array($sql1)) {
$daten = stripslashes($row[daten]);
$regie = stripslashes($row[regie]);
$mit = stripslashes($row[mit]);
$mitb = stripslashes($row[mitb]);
$story = stripslashes($row[story]);
$sql2=$db->query("SELECT * FROM bb".$n."_kinopre_filme WHERE filmid='".$row['filmid']."'");
while($row1 = $db->fetch_array($sql2))
{
$filmname = stripslashes($row1[titel]);
$buttons = "![\"{$lang-](\"images/kinopre/imdb_big.gif\")
items['LANG_GLOBAL_KINO7']}\" title=\"{$lang->items['LANG_GLOBAL_KINO7']}\" />";
$timestampjetzt = time();
}
$sql3=$db->query("SELECT * FROM bb".$n."_kinopre_filme_bild WHERE filmid='".$row['filmid']."'");
$anzahl5=mysql_num_rows($sql3);
if($anzahl5>0) {
while($row2 = $db->fetch_array($sql3)) {
$bild = $row2[datei];
}
}
else{
$bild = "./images/kinopre/noimage.gif";
}
}
eval ("\$tpl->output(\"".$tpl->get("kinopre_filme_infoview")."\");");
}
}
if ($_GET[action]=="az")
{
$maxperpage = $kinopre_option[azperpage];
if(!$_GET['sortby']){
$sortby="titel";
}
else{
$sortby=addslashes($_GET['sortby']);
}
if(!$_GET['order']){
$order="ASC";
}
else{
$order=addslashes($_GET['order']);
}
if (isset($_GET['page'])) {
$page = addslashes(intval($_GET['page']));
if ($page < 1) $page = 1;
}
else $page = 1;
if(!$_GET['letter']){
$letter="";
}
else{
$letter = addslashes(urldecode($_GET['letter']));
}
if(!$letter==''){
if ($letter == "#"){
$letter='%23';
$sqlanz = $db->query("SELECT count(*) FROM bb".$n."_kinopre_filme WHERE SUBSTRING(".$sortby.",1,1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')");
$rowanz = mysql_fetch_row($sqlanz);
$countanz = $rowanz[0];
$pages = ceil($countanz / $maxperpage);
if ($page > $pages) $page = 1;
$limitfirst = ($page * $maxperpage) - $maxperpage;
$limitanz= " LIMIT ".$limitfirst.", ".$maxperpage;
$sqln = $db->query("SELECT * FROM bb".$n."_kinopre_filme WHERE SUBSTRING(".$sortby.",1,1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') ORDER BY $sortby $order $limitanz");
}
else {
$sqlanz = $db->query("SELECT count(*) FROM bb".$n."_kinopre_filme WHERE SUBSTRING(".$sortby.",1,1)='$letter'");
$rowanz = mysql_fetch_row($sqlanz);
$countanz = $rowanz[0];
$pages = ceil($countanz / $maxperpage);
if ($page > $pages) $page = 1;
$limitfirst = ($page * $maxperpage) - $maxperpage;
$limitanz= " LIMIT ".$limitfirst.", ".$maxperpage;
$sqln = $db->query("SELECT * FROM bb".$n."_kinopre_filme WHERE SUBSTRING(".$sortby.",1,1)='$letter' ORDER BY $sortby $order $limitanz");
}
}
else{
$sqlanz = $db->query("SELECT count(*) FROM bb".$n."_kinopre_filme");
$rowanz = mysql_fetch_row($sqlanz);
$countanz = $rowanz[0];
$pages = ceil($countanz / $maxperpage);
if ($page > $pages) $page = 1;
$limitfirst = ($page * $maxperpage) - $maxperpage;
$limitanz= " LIMIT ".$limitfirst.", ".$maxperpage;
$sqln = $db->query("SELECT * FROM bb".$n."_kinopre_filme ORDER BY $sortby $order $limitanz");
}
$link = "kinopre.php?action=az&letter=".$letter."&order=".$order."&sortby=".$sortby.$SID_ARG_2ND;
if ($pages > 1) $pagelink = makepagelink($link, $page, $pages, $showpagelinks - 1);
if($countanz>0) {
while($row=$db->fetch_array($sqln))
{
$titel = stripslashes($row[titel]);
$sql4n=$db->query("SELECT * FROM bb".$n."_kinopre_filme_info WHERE filmid='$row[filmid]'");
$anzahln=mysql_num_rows($sql4n);
if($anzahln>0)
{
while($sql6n=$db->fetch_array($sql4n))
{
$infoid = $sql6n[infoid];
eval ("\$info_day = \"".$tpl->get("kinopre_day_info")."\";");
$filmtitel_day = "$titel";
}
}
else
{
$info_day = " ";
$filmtitel_day = "$titel";
}
eval ("\$imdb_day = \"".$tpl->get("kinopre_day_imdb")."\";");
eval ("\$filme .= \"".$tpl->get("kinopre_day_bit")."\";");
}
}
else{
eval ("\$filme .= \"".$tpl->get("kinopre_search_noresult_movie")."\";");
}
eval ("\$tpl->output(\"".$tpl->get("kinopre_az")."\");");
}
if ($_GET[action]=="search"){
if ($_REQUEST[searchart]=="searchfilm" || $_REQUEST[searchart]=="searchregie" || $_REQUEST[searchart]=="searchactor"){
$searchart=$_REQUEST[searchart];
$searchstring=addslashes($_REQUEST['searchstring']);
$searchstring2=$_REQUEST['searchstring'];
$maxperpage = $kinopre_option[azperpage];
if(!$_GET['sortby']){
$sortby="titel";
}
else{
$sortby=addslashes($_GET['sortby']);
}
if(!$_GET['order']){
$order="ASC";
}
else{
$order=addslashes($_GET['order']);
}
if (isset($_GET['page'])) {
$page = addslashes(intval($_GET['page']));
if ($page < 1) $page = 1;
}
else $page = 1;
}
if ($_REQUEST[searchart]=="searchregie"){
eval ("\$searchresulttitel = \"".$tpl->get("kinopre_search_result_titel_regie")."\";");
$sqlanz = $db->query("SELECT count(*) FROM bb".$n."_kinopre_filme_info WHERE regie LIKE '%$searchstring%'");
$rowanz = mysql_fetch_row($sqlanz);
$countanz = $rowanz[0];
$pages = ceil($countanz / $maxperpage);
if ($page > $pages) $page = 1;
$limitfirst = ($page * $maxperpage) - $maxperpage;
$limitanz= " LIMIT ".$limitfirst.", ".$maxperpage;
$lang->items['LANG_KINOPRE_SEARCH_RESULT_MOVIE'] = $lang->get("LANG_KINOPRE_SEARCH_RESULT_MOVIE", array('$countanz' => $countanz));
$lang->items['LANG_KINOPRE_SEARCH_RESULT_MOVIE'] = $lang->get("LANG_KINOPRE_SEARCH_RESULT_MOVIE", array('$searchstring2' => $searchstring2));
if($countanz>0) {
$link = "kinopre.php?action=search&searchart=searchregie&searchstring=".$searchstring2."&order=".$order."&sortby=".$sortby.$SID_ARG_2ND;
if ($pages > 1) $pagelink = makepagelink($link, $page, $pages, $showpagelinks - 1);
$sql3=$db->query("SELECT filmid FROM bb".$n."_kinopre_filme_info WHERE regie LIKE '%$searchstring%'");
while($row3=$db->fetch_array($sql3)){
$filmids[]=$row3[filmid];
}
while (list($key, $resultfilmid) = each($filmids)) {
$sql2=$db->query("SELECT * FROM bb".$n."_kinopre_filme WHERE filmid = $resultfilmid");
while($row2=$db->fetch_array($sql2)){
$titel = stripslashes($row2['titel']);
$filmid = $row2['filmid'];
$dayid = $row2['dayid'];
$rowclass = getone($count++, 'firstrow', 'secondrow');
$sql4n=$db->query("SELECT * FROM bb".$n."_kinopre_filme_info WHERE filmid='$filmid'");
$anzahln=mysql_num_rows($sql4n);
if($anzahln>0)
{
while($sql6n=$db->fetch_array($sql4n))
{
$infoid = $sql6n[infoid];
eval ("\$info_day = \"".$tpl->get("kinopre_day_info")."\";");
$filmtitel_day = "$titel";
}
}
else
{
$info_day = " ";
$filmtitel_day = "$titel";
}
eval ("\$imdb_day = \"".$tpl->get("kinopre_day_imdb")."\";");
eval ("\$moviesearch_bit .= \"".$tpl->get("kinopre_day_bit")."\";");
}
}
}
else{
eval ("\$moviesearch_bit .= \"".$tpl->get("kinopre_search_noresult_movie")."\";");
}
eval ("\$search_result = \"".$tpl->get("kinopre_search_result_movie")."\";");
eval ("\$tpl->output(\"".$tpl->get("kinopre_search")."\");");
}
elseif ($_REQUEST[searchart]=="searchfilm"){
eval ("\$searchresulttitel = \"".$tpl->get("kinopre_search_result_titel_film")."\";");
$sqlanz = $db->query("SELECT count(*) FROM bb".$n."_kinopre_filme WHERE titel LIKE '%$searchstring%'");
$rowanz = mysql_fetch_row($sqlanz);
$countanz = $rowanz[0];
$pages = ceil($countanz / $maxperpage);
if ($page > $pages) $page = 1;
$limitfirst = ($page * $maxperpage) - $maxperpage;
$limitanz= " LIMIT ".$limitfirst.", ".$maxperpage;
$lang->items['LANG_KINOPRE_SEARCH_RESULT_MOVIE'] = $lang->get("LANG_KINOPRE_SEARCH_RESULT_MOVIE", array('$countanz' => $countanz));
$lang->items['LANG_KINOPRE_SEARCH_RESULT_MOVIE'] = $lang->get("LANG_KINOPRE_SEARCH_RESULT_MOVIE", array('$searchstring2' => $searchstring2));
if($countanz>0) {
$link = "kinopre.php?action=search&searchart=searchfilm&searchstring=".$searchstring2."&order=".$order."&sortby=".$sortby.$SID_ARG_2ND;
if ($pages > 1) $pagelink = makepagelink($link, $page, $pages, $showpagelinks - 1);
$sql2=$db->query("SELECT * FROM bb".$n."_kinopre_filme WHERE titel LIKE '%$searchstring%' ORDER BY $sortby $order $limitanz");
while($row2=$db->fetch_array($sql2)){
$titel = stripslashes($row2['titel']);
$filmid = $row2['filmid'];
$dayid = $row2['dayid'];
$rowclass = getone($count++, 'firstrow', 'secondrow');
$sql4n=$db->query("SELECT * FROM bb".$n."_kinopre_filme_info WHERE filmid='$filmid'");
$anzahln=mysql_num_rows($sql4n);
if($anzahln>0)
{
while($sql6n=$db->fetch_array($sql4n))
{
$infoid = $sql6n[infoid];
eval ("\$info_day = \"".$tpl->get("kinopre_day_info")."\";");
$filmtitel_day = "$titel";
}
}
else
{
$info_day = " ";
$filmtitel_day = "$titel";
}
eval ("\$imdb_day = \"".$tpl->get("kinopre_day_imdb")."\";");
eval ("\$moviesearch_bit .= \"".$tpl->get("kinopre_day_bit")."\";");
}
}
else{
eval ("\$moviesearch_bit .= \"".$tpl->get("kinopre_search_noresult_movie")."\";");
}
eval ("\$search_result = \"".$tpl->get("kinopre_search_result_movie")."\";");
eval ("\$tpl->output(\"".$tpl->get("kinopre_search")."\");");
}
elseif ($_REQUEST[searchart]=="searchactor"){
eval ("\$searchresulttitel = \"".$tpl->get("kinopre_search_result_titel_actor")."\";");
$sqlanz = $db->query("SELECT count(*) FROM bb".$n."_kinopre_filme_info WHERE mit LIKE '%$searchstring%'");
$rowanz = mysql_fetch_row($sqlanz);
$countanz = $rowanz[0];
$pages = ceil($countanz / $maxperpage);
if ($page > $pages) $page = 1;
$limitfirst = ($page * $maxperpage) - $maxperpage;
$limitanz= " LIMIT ".$limitfirst.", ".$maxperpage;
$lang->items['LANG_KINOPRE_SEARCH_RESULT_MOVIE'] = $lang->get("LANG_KINOPRE_SEARCH_RESULT_MOVIE", array('$countanz' => $countanz));
$lang->items['LANG_KINOPRE_SEARCH_RESULT_MOVIE'] = $lang->get("LANG_KINOPRE_SEARCH_RESULT_MOVIE", array('$searchstring2' => $searchstring2));
if($countanz>0) {
$link = "kinopre.php?action=search&searchart=searchactor&searchstring=".$searchstring2."&order=".$order."&sortby=".$sortby.$SID_ARG_2ND;
if ($pages > 1) $pagelink = makepagelink($link, $page, $pages, $showpagelinks - 1);
$sql3=$db->query("SELECT filmid FROM bb".$n."_kinopre_filme_info WHERE mit LIKE '%$searchstring%'");
while($row3=$db->fetch_array($sql3)){
$filmids[]=$row3[filmid];
}
while (list($key, $resultfilmid) = each($filmids)) {
$sql2=$db->query("SELECT * FROM bb".$n."_kinopre_filme WHERE filmid = $resultfilmid");
while($row2=$db->fetch_array($sql2)){
$titel = stripslashes($row2['titel']);
$filmid = $row2['filmid'];
$dayid = $row2['dayid'];
$rowclass = getone($count++, 'firstrow', 'secondrow');
$sql4n=$db->query("SELECT * FROM bb".$n."_kinopre_filme_info WHERE filmid='$filmid'");
$anzahln=mysql_num_rows($sql4n);
if($anzahln>0)
{
while($sql6n=$db->fetch_array($sql4n))
{
$infoid = $sql6n[infoid];
eval ("\$info_day = \"".$tpl->get("kinopre_day_info")."\";");
$filmtitel_day = "$titel";
}
}
else
{
$info_day = " ";
$filmtitel_day = "$titel";
}
eval ("\$imdb_day = \"".$tpl->get("kinopre_day_imdb")."\";");
eval ("\$moviesearch_bit .= \"".$tpl->get("kinopre_day_bit")."\";");
}
}
}
else{
eval ("\$moviesearch_bit .= \"".$tpl->get("kinopre_search_noresult_movie")."\";");
}
eval ("\$search_result = \"".$tpl->get("kinopre_search_result_movie")."\";");
eval ("\$tpl->output(\"".$tpl->get("kinopre_search")."\");");
}
else{
eval ("\$tpl->output(\"".$tpl->get("kinopre_search")."\");");
}
}
?>