home sibiu 2007
.
ROMĀNA
DEUTSCH
Sibiu 2007 . calendarul 2007 . Dimensiunea europeana . Orasul Sibiu . Comunicare
.
.
.
.
.
sibiu 2007
CALENDAR 2007
events by month
.

January

 

February

 

March

 

April

 

May

 

June

 

July

 

August

 

September

 

October

 

November

 

December

. Events with Luxembourg
QUICK SEARCH
 
 
Advanced search
PROJECTS
 
.
AUGUST
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_en, e.id as ideveniment , l.locatia , p.organizatori , p.titluproiect_en , p.id as idproiect from evenimente e, locatii l , proiecte p where e.idlocatia=l.id and p.id=e.idproiect and e.titlueveniment_en like '%$titlueveniment_en%'and e.vizibil='1' $locatia $luxembourg $domeniu $vizibil $order "; if($_GET[ziua1]!='' && $_GET[ziua2]!='') { $ziua1=$_GET[ziua1]; $ziua2=$_GET[ziua2]; $Titlu.=" from $ziua1 to $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_en, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_en, 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_en like '%$titlueveniment_en%' 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_en, e.id as ideveniment , l.locatia, p.organizatori, p.titluproiect_en, 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_en like '%$titlueveniment_en%' 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_en, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_en, 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_en like '%$titlueveniment_en%' and e.vizibil='1' $locatia $luxembourg $domeniu $vizibil $order "; } $query=str_replace("from", ", recurType, dailyOptions, dailyDays, recWeekly, concat( if(length(recWeeklyDay1)>0,'Lu',''),' ', if(length(recWeeklyDay2)>0,'Ma',''),' ', if(length(recWeeklyDay3)>0,'Mi',''),' ', if(length(recWeeklyDay4)>0,'Jo',''),' ', if(length(recWeeklyDay5)>0,'Vi',''),' ', if(length(recWeeklyDay6)>0,'Sa',''),' ', if(length(recWeeklyDay7)>0,'Du','') ) 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"; ?>

NOTE: The Calendar of events for 2007 is not in final stage. Some changes may occur.

"; } $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="every ".$row[dailyDays]." day"; } else { $repeta="everyday";} } } if($row[recurType]=="w") { if((int)$row[recWeekly]>1) {$repeta="$row[saptamana] every ".$row[recWeekly]." week"; } else { $repeta="everyday $row[saptamana]";} } $data="$repeta
from $primazi to $ultimazi
$row[orastart] "; } if(strstr($row[titlueveniment],"'")){$g1='"';$g2="'";} else if(strstr($row[titlueveniment],'"')){$g1="'";$g2='"';} else {$g1='"';$g2="'"; } print ""; } ?>
Title
(click for details)
Date and time Location Organizers Calendar print','','width=790,scrollbars = yes,toolbar=no,location=no,menubar=yes,resizable=no,status=no')">
$row[titlueveniment_en]  $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.=" from location $loc"; } $query="select e.titlueveniment_en, e.id as ideveniment , l.locatia , p.organizatori , p.titluproiect_en , p.id as idproiect from evenimente e, locatii l , proiecte p where e.idlocatia=l.id and p.id=e.idproiect and e.titlueveniment_en like '%$titlueveniment_en%' $locatia $luxembourg $domeniu $vizibil $order "; if($_GET[ziua1]!='' && $_GET[ziua2]!='') { $ziua1=$_GET[ziua1]; $ziua2=$_GET[ziua2]; $Titlu.=" from $ziua1 to $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_en, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_en, 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_en like '%$titlueveniment_en%' 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_en, e.id as ideveniment , l.locatia, p.organizatori, p.titluproiect_en, 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_en like '%$titlueveniment_en%' 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_en, e.id as ideveniment , l.locatia , p.organizatori, p.titluproiect_en, 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_en like '%$titlueveniment_en%' $locatia $luxembourg $domeniu $vizibil $order "; } $query=str_replace("from", ", recurType, dailyOptions, dailyDays, recWeekly, concat( if(length(recWeeklyDay1)>0,'Lu',''),' ', if(length(recWeeklyDay2)>0,'Ma',''),' ', if(length(recWeeklyDay3)>0,'Mi',''),' ', if(length(recWeeklyDay4)>0,'Jo',''),' ', if(length(recWeeklyDay5)>0,'Vi',''),' ', if(length(recWeeklyDay6)>0,'Sa',''),' ', if(length(recWeeklyDay7)>0,'Du','') ) 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 : CONTACT : SITEMAP
Design by MB Solutions © 2005 - 2007, All Rights Reserved
 
<