"; $i = 0; do { echo 'function new_window_'. $i . '(URL)'; echo "{"; echo "InfoWindow=window.open(URL,'Client',"; echo '"width=' . $entree_window_width[$i] . ',height=' . $entree_window_height[$i] . ',directories=no,location=no,menubar=no,status=no,toolbar=no,resizable=yes,left=' . $entree_window_left[$i] . ',top=' . $entree_window_top[$i] . ',screenX=0,screenY=0")'; echo "}"; $i++; } while ($entree_window_height[$i]<>""); echo ""; if ($banneron == "yes") { // if ($type == 3) //{ //$javatarget = 'QDBANNER'; //$javalink = 'banner.php3?name=' . $name . // '&language=' . $language . // '&countrycode=' . $countrycode; //include 'includes/javaloadpage.inc'; //} } echo '
'; echo $bgmain; // variables passed from the previous page // common $taal = $language; // The chosen language $soort = $type; // The agenda type // local variables $testdatum = "x"; // dummy voor overslaan van $regels = 0; // dummy voor niets gevonden regel // per agenda type switch ($soort) { case 1: $selectmonth = $month; // The number of the month to display $selectyear = $year; // Same, but year break; case 2: $selectprovincie = "'" . $state . "'"; break; case 3: $selectcircus = "'" . $name . "'"; break; } switch ($soort) { case 1: $query = "SELECT distinct klantcode FROM " . $prefile . "agenda WHERE month(datum) = $selectmonth and land = '" . $countrycode . "' and year(datum) = $selectyear and TO_DAYS(NOW()) - TO_DAYS(datum) < 1 and TO_DAYS(datum) - TO_DAYS(NOW()) < 365"; $result = mysql_db_query($dbname, $query); while ($r = mysql_fetch_array($result)) { // hier de hit counter $klant = $r["klantcode"]; $counttype = 'agenda1'; include '../includes/hitcounter.inc'; // einde hitcounter } $query = "SELECT a.klantcode, c.naam, plaats, datum, locatie, tijden, a.klantcode as circ, month(datum) as mnd, weekday(datum) as dg, year(datum) as yr, DAYOFMONTH(datum) as mdg FROM " . $prefile . "agenda a, " . $prefile . "circus c WHERE month(datum) = $selectmonth and a.land = '" . $countrycode . "' and year(datum) = $selectyear and TO_DAYS(NOW()) - TO_DAYS(datum) < 1 and TO_DAYS(datum) - TO_DAYS(NOW()) < 365 and c.circus = a.klantcode ORDER by datum"; break; case 2: $query = "SELECT distinct klantcode FROM " . $prefile . "agenda WHERE provincie = $selectprovincie and land = $countrycode and TO_DAYS(NOW()) - TO_DAYS(datum) < 1 and TO_DAYS(datum) - TO_DAYS(NOW()) < 365"; $result = mysql_db_query($dbname, $query); while ($r = mysql_fetch_array($result)) { // hier de hit counter $klant = $r["klantcode"]; $counttype = 'agenda2'; include '../includes/hitcounter.inc'; // einde hitcounter } $query = "SELECT a.klantcode, c.naam, plaats, datum, locatie, tijden, month(datum) as mnd, weekday(datum) as dg, year(datum) as yr, DAYOFMONTH(datum) as mdg FROM " . $prefile . "agenda a, " . $prefile . "circus c WHERE a.provincie = $selectprovincie and a.land = $countrycode and TO_DAYS(NOW()) - TO_DAYS(datum) < 1 and TO_DAYS(datum) - TO_DAYS(NOW()) < 365 and c.circus = a.klantcode ORDER by plaats, datum"; break; case 3: //$query = "SELECT distinct klantcode // FROM " . $prefile . "agenda // WHERE klantcode = $selectcircus and // land = $countrycode and // TO_DAYS(NOW()) - TO_DAYS(datum) < 1 and // TO_DAYS(datum) - TO_DAYS(NOW()) < 365"; //$result = mysql_db_query($dbname, $query); //$r = mysql_fetch_array($result); // hier de hit counter $klant = $name; $counttype = 'agenda3'; include '../includes/hitcounter.inc'; // einde hitcounter $query = "SELECT c.naam, plaats, c.herkomst, datum, locatie, tijden, klantcode, c.link, c.email, infodir, infopage, extinfopage, logofile, month(datum) as mnd, weekday(datum) as dg, year(datum) as yr, DAYOFMONTH(datum) as mdg FROM " . $prefile . "agenda a, " . $prefile . "circus c WHERE klantcode = $selectcircus and a.land = $countrycode and TO_DAYS(NOW()) - TO_DAYS(datum) < 1 and TO_DAYS(datum) - TO_DAYS(NOW()) < 365 and c.circus = a.klantcode ORDER by datum"; break; } $result = mysql_db_query($dbname, $query); switch ($soort) { case 1: if ($result) { echo $kop_font_start, $agendaheadtext, $monthtxt[$selectmonth], " ", $selectyear, $kop_font_stop, $agendaheadfiller, $sub_kop_font_start, $agendaheadsubtext, $sub_kop_font_stop; Echo ""; //@M 595 while ($r = mysql_fetch_array($result)) { if ($testdatum <> $r["datum"]) // test of een nieuwe datum regel gemaakt moet worden { //if ($testdatum <> "x") $testdatum = $r["datum"]; $feestdag = ''; $query = "SELECT feest FROM feestdagen WHERE land = '" . $countrycode . "' and taal = '" . $language . "' and datum = '" . $testdatum . "'"; $resultfd = mysql_db_query($dbname, $query); if ($resultfd) { $fd = mysql_fetch_array($resultfd); $feestdag = $fd["feest"]; if ($feestdag <> '') { $feestdag = ' (' . $feestdag . ')'; } } $dat[0] = $daytxt[$r["dg"]]; $dat[1] = $r["mdg"]; $dat[2] = $monthtxt[$r["mnd"]]; $dat[3] = $r["yr"]; echo "
"; Echo ""; //@M 595 echo ''; } $regels = 1; $crcs = $r["klantcode"]; $circus = $r["naam"]; $plaats = $r["plaats"]; $locatie = $r["locatie"]; $tijden = $r["tijden"]; $datum = $r["datum"]; // hier bezig $query = " select count(*) as aantal from " . $prefile . "entree where klantcode = '" . $crcs . "' and land = '" . $countrycode . "' and datum = '" . $datum . "' order by volw desc"; $resultet = mysql_db_query($dbname, $query); $et = mysql_fetch_array($resultet); $aantal = $et["aantal"]; mysql_free_result($resultet); if ($aantal == 0) { $query = " select count(*) as aantal from " . $prefile . "entree where klantcode = '" . $crcs . "' and land = '" . $countrycode . "' and datum = '0001-01-01' order by volw desc"; $resultet = mysql_db_query($dbname, $query); $et = mysql_fetch_array($resultet); $aantal = $et["aantal"]; mysql_free_result($resultet); //$datetarif = 'n'; } $query = "Select klantcode, restel, REPLACE(opm,CHAR(13),'
') as tekst FROM " . $prefile . "resinfo where klantcode = '" . $crcs . "' and land = '" . $countrycode . "'"; $resulte = mysql_db_query($dbname, $query); $e = mysql_fetch_array($resulte); $restel = $e["restel"]; $tekst = $e["tekst"]; echo ''; if ($clwsw == 1) $clwsw = 2; else $clwsw = 1; if ($aantal > 0 or $restel <> "" or $tekst <> "") { if ($restel <> "") if ($tekst <> "") $aantal = $aantal + 2; $eventval = '?name=' . $crcs . '&language=' . $language . '&countrycode=' . $countrycode . '&date=' . $testdatum; echo ''; } else { echo ''; } // hier bezig echo ''; if ($locatie == "*)") $unreliable = 1; } echo "
'; Echo "$datum_kop_font_start$dat[$datpos1]$datposf1 $dat[$datpos2] $datposf2 $dat[$datpos3]$datposf3 $dat[$datpos4]$feestdag $datum_kop_font_stop"; echo '
' . $restext2 . '', $item_regel_font_start, $circus, $item_regel_font_stop, '', $item_regel_font_start, $plaats, $item_regel_font_stop, '', $item_regel_font_start, $locatie, $item_regel_font_stop, '', $item_regel_font_start, $tijden, $item_regel_font_stop, '
"; } break; case 2: if ($result) { echo $kop_font_start, $agendaheadtext, $state, $kop_font_stop, $agendaheadfiller, $sub_kop_font_start, $agendaheadsubtext, $sub_kop_font_stop; Echo ""; //@M 595 while ($r = mysql_fetch_array($result)) { if ($testdatum <> $r["plaats"]) // test of een nieuwe plaats regel gemaakt moet worden { //if ($testdatum <> "x") $testdatum = $r["plaats"]; echo "
"; Echo ""; //@M 595 echo ''; } $circus = $r["naam"]; $crcs = $r["klantcode"]; $regels = 1; $locatie = $r["locatie"]; $tijden = $r["tijden"]; $datum = $r["datum"]; $dat[0] = $daytxtkrt[$r["dg"]]; $dat[1] = $r["mdg"]; $dat[2] = $r["mnd"]; $dat[3] = $r["yr"]; // hier bezig $query = " select count(*) as aantal from " . $prefile . "entree where klantcode = '" . $crcs . "' and land = '" . $countrycode . "' and datum = '" . $datum . "' order by volw desc"; $resultet = mysql_db_query($dbname, $query); $et = mysql_fetch_array($resultet); $aantal = $et["aantal"]; mysql_free_result($resultet); if ($aantal == 0) { $query = " select count(*) as aantal from " . $prefile . "entree where klantcode = '" . $crcs . "' and land = '" . $countrycode . "' and datum = '0001-01-01' order by volw desc"; $resultet = mysql_db_query($dbname, $query); $et = mysql_fetch_array($resultet); $aantal = $et["aantal"]; mysql_free_result($resultet); } $query = "Select klantcode, restel, REPLACE(opm,CHAR(13),'
') as tekst FROM " . $prefile . "resinfo where klantcode = '" . $crcs . "'"; $resulte = mysql_db_query($dbname, $query); $e = mysql_fetch_array($resulte); $restel = $e["restel"]; $tekst = $e["tekst"]; if ($clwsw == 1) $clwsw = 2; else $clwsw = 1; echo ''; if ($aantal > 0 or $restel <> "" or $tekst <> "") { if ($restel <> "") if ($tekst <> "") $aantal = $aantal + 2; $eventval = '?name=' . $crcs . '&language=' . $language . '&countrycode=' . $countrycode . '&date=' . $datum; echo ''; } else { echo ''; } // hier bezig echo ''; if ($locatie == "*)") $unreliable = 1; } } echo "
'; Echo "$datum_kop_font_start$testdatum$datum_kop_font_stop"; echo '
' . $restext2 . '', $item_regel_font_start,$dat[$datpos1], ' ', $dat[$datpos2], $datposf4, $dat[$datpos3], $datposf4, $dat[$datpos4], $item_regel_font_stop, '', $item_regel_font_start, $circus, $item_regel_font_stop, '', $item_regel_font_start, $locatie, $item_regel_font_stop, '', $item_regel_font_start, $tijden, $item_regel_font_stop, '
"; break; case 3: if ($result) { while ($r = mysql_fetch_array($result)) { if ($regels < 1) { //echo '

'; //if ($sender <> "info") //{ //echo '

', $kop_font_start, $agendaheadtext, $r["naam"], // $kop_font_stop, ''; //} // if ($sender == "info") //{ //echo '
', $sub_kop_font_start, $agendaheadsubtext, $sub_kop_font_stop, '
'; //} //else //{ //} //echo ''; //if ($sender == "info") //{ $name = $r["klantcode"]; $naam = $r["naam"]; $herkomst = $r["herkomst"]; $link = $r["link"]; $email = $r["email"]; $infodir = $r["infodir"]; $infopage = $r["infopage"]; $extinfopage = $r["extinfopage"]; $logofile = $r["logofile"]; $sender = "ag3"; include '../includes/kop_circus.inc'; include '../includes/info_select.inc'; Echo ""; //@M 595 //echo ''; //echo ''; //} Echo "
', $sub_kop_font_start, $agendaheadsubtext, $sub_kop_font_stop, '
',$sub_kop_font_start, $agendareturntext, // $sub_kop_font_stop, '
"; //@M 595 echo ''; } $plaats = $r["plaats"]; $regels = 1; $locatie = $r["locatie"]; $tijden = $r["tijden"]; $datum = $r["datum"]; $crcs = $r["klantcode"]; $dat[0] = $daytxtkrt[$r["dg"]]; $dat[1] = $r["mdg"]; $dat[2] = $r["mnd"]; $dat[3] = $r["yr"]; // hier bezig $query = " select count(*) as aantal from " . $prefile . "entree where klantcode = '" . $crcs . "' and land = '" . $countrycode . "' and datum = '" . $datum . "' order by volw desc"; $resultet = mysql_db_query($dbname, $query); $et = mysql_fetch_array($resultet); $aantal = $et["aantal"]; mysql_free_result($resultet); if ($aantal == 0) { $query = " select count(*) as aantal from " . $prefile . "entree where klantcode = '" . $crcs . "' and land = '" . $countrycode . "' and datum = '0001-01-01' order by volw desc"; $resultet = mysql_db_query($dbname, $query); $et = mysql_fetch_array($resultet); $aantal = $et["aantal"]; mysql_free_result($resultet); } $query = "Select klantcode, restel, REPLACE(opm,CHAR(13),'
') as tekst FROM " . $prefile . "resinfo where klantcode = '" . $crcs . "'"; $resulte = mysql_db_query($dbname, $query); $e = mysql_fetch_array($resulte); $restel = $e["restel"]; $tekst = $e["tekst"]; if ($clwsw == 1) $clwsw = 2; else $clwsw = 1; if ($aantal > 0 or $restel <> "" or $tekst <> "") { if ($restel <> "") if ($tekst <> "") $aantal = $aantal + 2; $eventval = '?name=' . $crcs . '&language=' . $language . '&countrycode=' . $countrycode . '&date=' . $datum; echo ''; } else { echo ''; } // hier bezig echo ''; if ($locatie == "*)") $unreliable = 1; } echo "
' . $restext2 . '', $item_regel_font_start,$dat[$datpos1], ' ', $dat[$datpos2], $datposf4, $dat[$datpos3], $datposf4, $dat[$datpos4], $item_regel_font_stop, '', $item_regel_font_start, $plaats, $item_regel_font_stop, '', $item_regel_font_start, $locatie, $item_regel_font_stop, '', $item_regel_font_start, $tijden, $item_regel_font_stop, '
"; } break; } //switch if ($type == 3) { Echo "
"; //@M 595 echo ''; //echo ''; //echo ''; //echo ''; //echo ''; //echo ''; echo '
', $sub_kop_font_start, $agendaheadsubtext, $sub_kop_font_stop, '
'; //echo $sub_kop_font_start, $agendaheadsubtext, // $sub_kop_font_stop, '
'; //echo $countertext1 . $teller . $countertext2; //echo '
' . $linkbanner_font_start . 'Beschikbaar gesteld door www.circus-web.nl' . $linkbanner_font_stop . '
'; } if ($unreliable > 0) echo $extravhb; //mysql_free_result($result); if ($regels < 1) echo "$item_regel_font_start

$nothingfoundtext[$type]

"; ?>