DbConnOpen()) echo "connection failed
".$db->DbComGetLastError()."
"; if(!$DbID->DbConnSelectDb()) echo "selection of database failed
".$db->DbComGetLastError()."
"; $ConnectArray = get_object_vars($DbID); $ConnectID = $ConnectArray[ConnectID]; // Übersetzung if (!$lang) $lang = "de"; include ("lib/lang_choose_eventitem.inc.php"); // DIE HTML VARS include ("lib/html_vars_event.inc.php"); // DAS LAYOUT include ("lib/template.inc.php"); // SESSION AUSLESEN //include("lib/class_session.inc.php"); //$Sess = new Session; //$Sess->Read($S, $ID, $ConnectID); // FORM BAUEN require("../lib/class_form.inc.php"); // NEUES OBJEKT ERSTELLEN $sform = new Form("Searchform"); // FEHLERMELDUNGEN $sform->ERRFormfieldEmpty = ""; // Event holen $dbEvent = new DbCom; if(!$dbEvent->DbComQuery("SELECT * FROM atrEvent WHERE EvID=".$evid,$ConnectID)) echo "query failed
".$dbEvent->DbComGetLastError()."
"; extract($dbEvent ->DBComGetNextResult(),EXTR_PREFIX_ALL, "event"); if ($lang == "en") $eventDetail = $event_DetailEN; else $eventDetail = $event_DetailDE; // GIBT ES EIN BILD? if (($event_Image == "0") || ($event_Image == "")) $event_Image = "spacer.gif"; $myRows = $myRows." ".nl2br($eventDetail)." "; // Veranstalter holen if ($event_TOID > 0) { $dbOperator = new DbCom; if(!$dbOperator->DbComQuery("SELECT * FROM atrTourOperator WHERE TOID=".$event_TOID." LIMIT 1",$ConnectID)) echo "query failed
".$dbOperator->DbComGetLastError()."
"; extract($dbOperator ->DBComGetNextResult(),EXTR_PREFIX_ALL, "operator"); if ($operator_TermsConditions && $operator_TermsConditions != "") $operatorterms="".$step3operatorterms.""; $myRows = $myRows." ".$step3operator." ".$operator_Name." ".$operatorterms." "; } // Carrier holen if ($event_TCID > 0) { $dbCarrier = new DbCom; if(!$dbCarrier->DbComQuery("SELECT * FROM atrTourCarrier WHERE TCID=".$event_TCID." LIMIT 1",$ConnectID)) echo "query failed
".$dbCarrier->DbComGetLastError()."
"; extract($dbCarrier ->DBComGetNextResult(),EXTR_PREFIX_ALL, "carrier"); if ($carrier_TermsConditions && $carrier_TermsConditions != "") $carrierterms="".$step3carrierterms.""; $myRows = $myRows." ".$step3carrier." ".$carrier_Name." ".$carrierterms." "; } // COUNTRY holen if ($event_TTID > 0) { $dbCountry = new DbCom; if(!$dbCountry->DbComQuery("SELECT * FROM atrTourCountry WHERE TTID=".$event_TTID,$ConnectID)) echo "query failed
".$dbEvent->DbComGetLastError()."
"; extract($dbCountry ->DBComGetNextResult(),EXTR_PREFIX_ALL, "country"); $myRows = $myRows." ".$step6countryreq." ".$country_Name." "; } // WELCHE Items GIBT ES DENN $dbItem = new DbCom; if(!$dbItem->DbComQuery("SELECT * FROM atrEventItem WHERE EvID=".$evid." AND atrEventItem.StopDate>CURRENT_DATE AND atrEventItem.DepartureDate>CURRENT_DATE ORDER BY atrEventItem.DepartureDate ASC",$ConnectID)) echo "query failed
".$dbItem->DbComGetLastError()."
"; $matchingItem = $dbItem->DbComGetCount(); //print $matchingItem; if ($matchingItem == 0) { $myRows=$myRows."   sorry, no Items available - leider keine Veranstaltungen vorhanden   "; } else { $myRows=$myRows."   ".$step3gruen." ".$step3gelb." ".$step3rot."   "; for ($i=0; $i<$matchingItem; $i++) { extract($dbItem ->DBComGetNextResult(),EXTR_PREFIX_ALL, "item"); if ($lang == "en") $itemDetail = $item_DetailEN; else $itemDetail = $item_DetailDE; if ($item_ArrivalDate != "") $itemArrivalDate = $step3To." ".convertDate($item_ArrivalDate, $lang); else $itemArrivalDate = ""; // AMPEL SCHALTEN, LINK SETZEN if ($item_AvailableItems < 1) { $ampelImage = ""; $ampelLink = "
".$step3noBooking."  ".$step3Booking."  "; } elseif ($item_AvailableItems < $event_ItemLow) { $ampelImage = ""; $ampelLink = "".$step3noBooking."  ".$step3Booking."  "; } else { $ampelImage = ""; $ampelLink = "".$step3noBooking."  ".$step3Booking."  "; } $myRows = $myRows." ".$ampelImage." ".$step3From." ".convertDate($item_DepartureDate, $lang)." ".$itemArrivalDate."
".$ampelLink."
"; } } $mainTable = " ".$myRows."
".$event_Name."


"; $html = getLayout($HTML_TITLE, $step1PageTitle, $step1PageSubtitle, $step3Heading, $step3Hint, $mainTable, $FOOT_NOTE, $evid); print $html; ?>