home sibiu 2007
.
ROMÂNA
ENGLISH
Sibiu 2007 . calendarul 2007 . Dimensiunea europeana . Orasul Sibiu . Comunicare
.
.
.
.
.
sibiu 2007
KALENDER 2007
.

Januar

 

Februar

 

März

 

April

 

Mai

 

Juni

 

Juli

 

August

 

September

 

Oktober

 

November

 

Dezember

.

Events mit Luxemburg

 
SUCHE
 
 
Erweiterte Suche
Projekte 2007
 
.
DEZEMBER
Luxembourg";} if($iddomeniu>0) { $domeniu= " and p.iddomeniu=$iddomeniu "; $res=mysql_query("select domeniu from domenii where id=$iddomeniu"); $dom=mysql_result($res,0,'domeniu'); $Titlu.=" from domain $dom"; } if($idlocatie>0) { $locatia=" and e.idlocatia=$idlocatie "; $res=mysql_query("select locatia from locatii where id=$idlocatie"); $loc=mysql_result($res,0,'locatia'); $Titlu.=" that take place at $loc"; } $query="select e.titlueveniment_de, e.id as ideveniment , l.locatia , p.organizatori , p.titluproiect_de , p.id as idproiect from evenimente e, locatii l , proiecte p where e.idlocatia=l.id and p.id=e.idproiect and e.titlueveniment_de like '%$titlueveniment_de%'and e.vizibil='1' $locatia $luxembourg $domeniu $vizibil $order "; if($_GET[ziua1]!='' && $_GET[ziua2]!='') { $ziua1=$_GET[ziua1]; $ziua2=$_GET[ziua2]; $Titlu.=" $ziua1 - $ziua2"; $datasql1=substr($ziua1,6,4)."-".substr($ziua1,3,2)."-".substr($ziua1,0,2); $datasql2=substr($ziua2,6,4)."-".substr($ziua2,3,2)."-".substr($ziua2,0,2); $query="select distinct e.titlueveniment_de, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_de, p.id as idproiect from evenimente e, locatii l , proiecte p , zileocupate z where e.idlocatia=l.id and p.id=e.idproiect and e.id=z.ideveniment and e.titlueveniment_de like '%$titlueveniment_de%' and z.ziua >= '$datasql1' and z.ziua <= '$datasql2' and e.vizibil='1' $locatia $luxembourg $domeniu $vizibil $order "; } if($idorganizator > 0) { $query="select organizator from organizatori where id=$idorganizator"; $res=mysql_query($query); $organizator=mysql_result($res,0,'organizator'); $Titlu.=" organized by $organizator"; $query="select e.titlueveniment_de, e.id as ideveniment , l.locatia, p.organizatori, p.titluproiect_de, p.id as idproiect , o.organizator from evenimente e, locatii l, proiecte p , organizatori o where e.idlocatia=l.id and e.idproiect=p.id and e.titlueveniment_de like '%$titlueveniment_de%' and find_in_set(o.id,p.organizatori) > 0 and o.organizator='$organizator' and e.vizibil='1' $locatia $luxembourg $domeniu $vizibil $order "; } if(($_GET[ziua1]!='')&&($_GET[ziua2]!='')&&($idorganizator > 0)) { $ziua1=$_GET[ziua1]; $ziua2=$_GET[ziua2]; $datasql1=substr($ziua1,6,4)."-".substr($ziua1,3,2)."-".substr($ziua1,0,2); $datasql2=substr($ziua2,6,4)."-".substr($ziua2,3,2)."-".substr($ziua2,0,2); $query="select organizator from organizatori where id=$idorganizator"; $res=mysql_query($query); $organizator=mysql_result($res,0,'organizator'); $query="select distinct e.titlueveniment_de, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_de, p.id as idproiect , o.organizator from evenimente e, locatii l, proiecte p , organizatori o , zileocupate z where e.idlocatia=l.id and e.idproiect=p.id and e.id=z.ideveniment and z.ziua>='$datasql1' and z.ziua<='$datasql2' and find_in_set(o.id,p.organizatori) > 0 and o.organizator='$organizator' and e.titlueveniment_de like '%$titlueveniment_de%' and e.vizibil='1' $locatia $luxembourg $domeniu $vizibil $order "; } $query=str_replace("from", ", recurType, dailyOptions, dailyDays, recWeekly, concat( if(length(recWeeklyDay1)>0,'Montag',''),' ', if(length(recWeeklyDay2)>0,'Dienstag',''),' ', if(length(recWeeklyDay3)>0,'Mittwoch',''),' ', if(length(recWeeklyDay4)>0,'Donnerstag',''),' ', if(length(recWeeklyDay5)>0,'Freitag',''),' ', if(length(recWeeklyDay6)>0,'Samstag',''),' ', if(length(recWeeklyDay7)>0,'Sonntag','') ) saptamana , concat(startTimeHour,':',startTimeMins) orastart, concat(endTimeHour,':',endTimeMins) orastop from", $query); // print $query; $res=mysql_query($query); $numar=mysql_num_rows($res); print "$numar $Titlu"; ?>

HINWEIS: Der Veranstaltungskalender für das Jahr 2007 ist nicht endgültig, die Informationen auf dieser Seite werden aktualisiert

"; } $organiz=substr($organiz,0,strlen($organiz)-4); $data=""; if($row[recurType]!="w" && $row[recurType]!="d" ) { $query4="select date_format(ziua,'%d.%m.%Y') zi , time_format(orastart ,'%H:%i') orastart ,time_format(orastop ,'%H:%i') orastop from zileocupate where ideveniment=".$row[ideveniment]." order by ziua"; $res4=mysql_query($query4); while($row4=mysql_fetch_array($res4)) { $data.=$row4[zi]." ".$row4[orastart]."
"; } mysql_free_result($res4); } else { $query5="select date_format(min(ziua),'%d.%m.%Y') zi from zileocupate where ideveniment=".$row[ideveniment]; $res5=mysql_query($query5); $primazi=mysql_result($res5,0,"zi"); $query6="select date_format(max(ziua),'%d.%m.%Y') zi from zileocupate where ideveniment=".$row[ideveniment]; $res6=mysql_query($query6); $ultimazi=mysql_result($res6,0,"zi"); if($row[recurType]=="d") { if($row[dailyOptions]=="WeekdaysOnly") { $repeta="in working days"; } if($row[dailyOptions]=="EveryXDays") { if((int)$row[dailyDays]>1) {$repeta="Jeden ".$row[dailyDays]." tag"; } else { $repeta="Täglich";} } } if($row[recurType]=="w") { if((int)$row[recWeekly]>1) {$repeta="$row[saptamana] Jeden ".$row[recWeekly]." Woche"; } else { $repeta="Jeden $row[saptamana]";} } $data="$repeta
Vom $primazi bis zum $ultimazi
$row[orastart] "; } if(strstr($row[titlueveniment],"'")){$g1='"';$g2="'";} else if(strstr($row[titlueveniment],'"')){$g1="'";$g2='"';} else {$g1='"';$g2="'"; } print ""; } ?>
Event
(Klick für Details)
Datum Veranstaltungsort Organisator Kalender print','','width=790,scrollbars = yes,toolbar=no,location=no,menubar=yes,resizable=no,status=no')">
$row[titlueveniment_de]  $data  $row[locatia]  $organiz 
Luxembourg";} if($iddomeniu>0) { $domeniu= " and p.iddomeniu=$iddomeniu "; $res=mysql_query("select domeniu from domenii where id=$iddomeniu"); $dom=mysql_result($res,0,'domeniu'); $Titlu.=" from domain $dom"; } if($idlocatie>0) { $locatia=" and e.idlocatia=$idlocatie "; $res=mysql_query("select locatia from locatii where id=$idlocatie"); $loc=mysql_result($res,0,'locatia'); $Titlu.=" $loc"; } $query="select e.titlueveniment_de, e.id as ideveniment , l.locatia , p.organizatori , p.titluproiect_de , p.id as idproiect from evenimente e, locatii l , proiecte p where e.idlocatia=l.id and p.id=e.idproiect and e.titlueveniment_de like '%$titlueveniment_de%' $locatia $luxembourg $domeniu $vizibil $order "; if($_GET[ziua1]!='' && $_GET[ziua2]!='') { $ziua1=$_GET[ziua1]; $ziua2=$_GET[ziua2]; $Titlu.=" von $ziua1 bis $ziua2"; $datasql1=substr($ziua1,6,4)."-".substr($ziua1,3,2)."-".substr($ziua1,0,2); $datasql2=substr($ziua2,6,4)."-".substr($ziua2,3,2)."-".substr($ziua2,0,2); $query="select distinct e.titlueveniment_de, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_de, p.id as idproiect from evenimente e, locatii l , proiecte p , zileocupate z where e.idlocatia=l.id and p.id=e.idproiect and e.id=z.ideveniment and e.titlueveniment_de like '%$titlueveniment_de%' and z.ziua >= '$datasql1' and z.ziua <= '$datasql2' $locatia $luxembourg $domeniu $vizibil $order "; } if($idorganizator > 0) { $query="select organizator from organizatori where id=$idorganizator"; $res=mysql_query($query); $organizator=mysql_result($res,0,'organizator'); $Titlu.=" organized by $organizator"; $query="select e.titlueveniment_de, e.id as ideveniment , l.locatia, p.organizatori, p.titluproiect_de, p.id as idproiect , o.organizator from evenimente e, locatii l, proiecte p , organizatori o where e.idlocatia=l.id and e.idproiect=p.id and e.titlueveniment_de like '%$titlueveniment_de%' and find_in_set(o.id,p.organizatori) > 0 and o.organizator='$organizator' $locatia $luxembourg $domeniu $vizibil $order "; } if(($_GET[ziua1]!='')&&($_GET[ziua2]!='')&&($idorganizator > 0)) { $ziua1=$_GET[ziua1]; $ziua2=$_GET[ziua2]; $datasql1=substr($ziua1,6,4)."-".substr($ziua1,3,2)."-".substr($ziua1,0,2); $datasql2=substr($ziua2,6,4)."-".substr($ziua2,3,2)."-".substr($ziua2,0,2); $query="select organizator from organizatori where id=$idorganizator"; $res=mysql_query($query); $organizator=mysql_result($res,0,'organizator'); $query="select distinct e.titlueveniment_de, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_de, p.id as idproiect , o.organizator from evenimente e, locatii l, proiecte p , organizatori o , zileocupate z where e.idlocatia=l.id and e.idproiect=p.id and e.id=z.ideveniment and z.ziua>='$datasql1' and z.ziua<='$datasql2' and find_in_set(o.id,p.organizatori) > 0 and o.organizator='$organizator' and e.titlueveniment_de like '%$titlueveniment_de%' $locatia $luxembourg $domeniu $vizibil $order "; } $query=str_replace("from", ", recurType, dailyOptions, dailyDays, recWeekly, concat( if(length(recWeeklyDay1)>0,'Montag',''),' ', if(length(recWeeklyDay2)>0,'Dienstag',''),' ', if(length(recWeeklyDay3)>0,'Mittwoch',''),' ', if(length(recWeeklyDay4)>0,'Donnerstag',''),' ', if(length(recWeeklyDay5)>0,'Freitag',''),' ', if(length(recWeeklyDay6)>0,'Samstag',''),' ', if(length(recWeeklyDay7)>0,'Sonntag','') ) saptamana , concat(startTimeHour,':',startTimeMins) orastart, concat(endTimeHour,':',endTimeMins) orastop from", $query); // print $query; $res=mysql_query($query); $numar=mysql_num_rows($res); //print "
$numar $Titlu

"; ?> top
HOME : SITEMAP : KONTAKT
Design by MB Solutions © 2005 - 2007, All Rights Reserved