<% require("../dbdetails.php"); $query="none"; if (!$bgimg) $bgimg="../../images/hintergrund.jpg"; if (!$colde) $colde="#008000"; if (!$colus) $colus="#8000FF"; if (!$coltxt) $coltxt="#000000"; if (!$rtxt) $rtxt=$rtxt_default; if (!$rurl) $rurl="de/index.htm"; if (!$etxt) $etxt=$etxt_default; if (!$eurl) $eurl="de/sqlmeetform.htm"; %> DLPfan.ORG Countdown- and Meeting-List <% # Fehlerbehandlung ohne Ausgabe von Warnings! # error_reporting (2037); if (!$showlang) $showlang='en'; # english as default-language if (file_exists("./text-$showlang.php")): require("./text-$showlang.php"); else: include("./text-en.php"); endif; %>

<% echo $sitename; %>

<% echo $presented; %>DisneyLand Paris FAN Organization

<% echo $here_results; %>

<% $time_memo = 0; settype($time_memo, "double"); function micro_timer() { $tm_1 = microtime( "H:i:s", time()); $tm_2 = explode( " ", $tm_1); $tm_3 = explode( ".", $tm_2[0]); return doubleval($tm_2[1]. ".".$tm_3[1]); } function stoppuhr_on() { global $time_memo; $time_memo = micro_timer(); return; } function stoppuhr_off() { global $time_memo; $milli_sec = (1000 * (micro_timer() - $time_memo)). "000"; $tm_len = strpos($milli_sec, ".") + 4; return substr($milli_sec, 0, $tm_len). " ms"; } stoppuhr_on(); if (!$from): if($withold): $query="select * from gtab ORDER BY von DESC, bis DESC"; $text="

$m_all

"; else: $today = date("Y-m-d"); $query="select * from gtab where (bis >= '$today') ORDER BY von DESC, bis DESC"; $text="

$m_all (>= $today)

"; endif; if ($type == "monthyear"): $von = $year . "-" . $month . "-" . "01"; $bistime = mktime(0,0,0,$month+1,1,$year)-86400; $bis = date("Y-m-d", $bistime); if ($month =="month" or $year=="year"): echo "

$e_m_y

"; else: $query="select * from gtab where (((von >= '$von') and (von <= '$bis')) or ((bis >= '$von') and (bis <= '$bis'))) ORDER BY von DESC, bis DESC"; $text="

$m_from $von $m_to $bis

"; endif; endif; elseif ($type =="onedate"): $oneday=$year . "-" . $month . "-" . $day; if ($month =="month" or $year=="year" or $day=="day"): echo "

$e_d_m_y

"; else: $query="select * from gtab where ((von <= '$oneday') and (bis >= '$oneday')) ORDER BY von DESC, bis DESC"; $text="

$m_for_date $oneday:

"; endif; elseif ($type =="string"): if (!$string): echo "

$e_search

"; else: $searchstring = "%" . addslashes($string) . "%"; $query="select * from gtab where (fan like '$searchstring') ORDER BY von DESC, bis DESC"; $text="

$m_search $searchstring

"; endif; elseif (!$to): $query="select * from gtab where ((von <= '$from') and (bis >= '$from')) ORDER BY von DESC, bis DESC"; $text="$m_from"; else: $query="select * from gtab where (((von >= '$from') and (von <= '$to')) or ((bis >= '$from') and (bis <= '$to'))) ORDER BY von DESC, bis DESC"; $text="$m_from_to"; endif; if ($query == "none"): echo "

$e_invalid

"; else: mysql_connect($host,$user,$pw); $result = mysql($db, "select * from gtab"); $total = mysql_numrows($result); $result=mysql($db,"select MIN(von) from gtab"); $gvon=mysql_result($result,0,"min(von)"); $result=mysql($db,"select MAX(bis) from gtab"); $gbis=mysql_result($result,0,"max(bis)"); $result = mysql($db , $query); $num = mysql_numrows($result); echo $text; echo "

$num $m_number $total

"; echo "

$m_range $gvon $m_to $gbis

"; %> <% include("./tabheader.php"); $i=0; while ($i < $num): $vdatum= mysql_result($result,$i,"von"); $vjahr=substr($vdatum,0,4); $vmonat=substr($vdatum,5,2); $vtag=substr($vdatum,8,2); $vondat=mktime(0,0,0,$vmonat,$vtag,$vjahr); $bdatum= mysql_result($result,$i,"bis"); $bjahr=substr($bdatum,0,4); $bmonat=substr($bdatum,5,2); $btag=substr($bdatum,8,2); $bisdat=mktime(0,0,0,$bmonat,$btag,$bjahr); $id= mysql_result($result,$i,"id"); %> <% $i++; endwhile; echo "\n"; $zeit = stoppuhr_off(); echo "$m_time $zeit"; endif; %>

<%= date("j. M Y", $vondat) %>

<%= date("j. M Y", $bisdat) %>

<%= round((($vondat-mktime(0,0,0,date("m"),date("d"),date("Y")))/86400)) %>

<%= mysql_result($result,$i,"fan") %>

<%= mysql_result($result,$i,"kommentar") %>

<%= mysql_result($result,$i,"comment") %>

<%= mysql_result($result,$i,"hotel") %>

<%= mysql_result($result,$i,"sprachen") %>

<% echo $etxt; %>

The DLPfan-Countdown - a service from the
DisneyLand Paris FAN Organization

Der DLPfan-Countdown - ein Service der
DisneyLand Paris FAN Organisation

<% echo $rtxt; %>