id; //function comingevents(){ $temp_conf = $this->typolink_conf; $temp_conf["additionalParams"] .= "&tx_calevents2_pi1[cat]=$jahr_vor-$monat-1"; $temp_conf["useCacheHash"] = $this->allowCaching; $temp_conf["useCacheHash"] =1; $heute = mktime(); //$calcontenthead='

'.$this->pi_getLL('comingsoon').'

' ; // die betroffenen pids ermitteln rekursiv für program titles $starting_point_recursive=4; $starting_point=33; $pidList = $this->pi_getPidList($starting_point, $starting_point_recursive); // Get resource records mit pidliste $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery( "title,uid", "pages", "uid IN (" . $pidList . ")" . $criteria//extend that as you like . " order by title" ); //displaying retrieved records while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) { $programm_title_array[$row['uid']]=str_replace("|", " ", $row['title']); } // kategorien nur auf kategorien seite zeigen $res2=$GLOBALS['TYPO3_DB']->exec_SELECTquery( 'tx_calevents2_categories.uid, tx_calevents2_categories.title', #select 'tx_calevents2_categories ', #from 'tx_calevents2_categories.hidden=0 and tx_calevents2_categories.deleted=0 and sys_language_uid = '.$GLOBALS['TSFE']->sys_language_uid.'' , #where $groupBy='', $orderBy='title'); $categories_overview =''; $categories_counter=0; $cat_selecter_tmp=$this->piVars["cat"]+1-1; $temp_conf["additionalParams"] .= "&tx_calevents2_pi1[cat]=0"; if($cat_selecter_tmp==0){ $temp_conf["ATagParams"] .= 'class="pcatselected"';} $this->local_cObj->setCurrentVal($programs_category_page_uid); $categories_overview .= $this->local_cObj->typolink($this->pi_getLL('cat_all'), $temp_conf).', '; $temp_conf["ATagParams"] =''; while( $row2 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res2)) { $categories_overview_temp=$row2['title']; if($categories_counter>0){$categories_overview.= ', ';} $temp_conf["additionalParams"] .= "&tx_calevents2_pi1[cat]=".$row2['uid']; if($cat_selecter_tmp==$row2['uid']){$temp_conf["ATagParams"] = 'class="pcatselected"';}else{$temp_conf["ATagParams"] ="";} $categories_overview .= $this->local_cObj->typolink($categories_overview_temp, $temp_conf); $temp_conf["ATagParams"] =""; $categories_array[$row2['uid']]=$this->local_cObj->typolink($row2['title'], $temp_conf); $categories_counter++; } if($GLOBALS["TSFE"]->id==$programs_category_page_uid){ $categories_overview ='
'.$categories_overview.'
'; }else{ $categories_overview =''; } $temp_conf["additionalParams"] .= "&tx_calevents2_pi1[cat]=0"; /// recurrent improvment $teile = explode("-", date("Y-m-d") ); $aktueller_tag=mktime(0, 0, 0, ($teile[1]+1), $teile[2], $teile[0]); $aktueller_tag2=mktime(0, 0, 0, ($teile[1]), $teile[2], $teile[0]); $aktueller_tag3=mktime(0, 0, 0, ($teile[1]+1), $teile[2], $teile[0]); //echo("$erste_tag -- $aktueller_tag --- $letzter_tag $teile[0] $teile[1] $teile[2]"); if($tt==1)$aktueller_tag3=mktime(0, 0, 0, ($teile[1]), $teile[2], $teile[0]); $monat_name=date("F", $aktueller_tag); $day_anzahl=date("t", $aktueller_tag3);; $j = date('Y'); $m = date('m'); $d = date('d'); $unix_datum_s = mktime(0,0,0,$m,$d,$j); $unix_datum_e=mktime(23, 59, 59, $teile[1],$day_anzahl, $teile[0]); $tages_datum_s=mktime(); $tages_datum_e=mktime(23, 59, 59, $teile[1],$teile[2], $teile[0]); $unix_datum_start=mktime(23, 59, 59, 1,1, 2009); // ################## abfrage der recurent events $weekdays = array( 0 => "SON", 1 => "MON", 2 => "TUE", 3 => "WED", 4 => "THU", 5 => "FRI", 6 => "SAT"); $w=0; $select = 'tx_calevents2_events.pid, tx_calevents2_events.uid,tx_calevents2_events.recurrent, tx_calevents2_events.title, tx_calevents2_events.edate, tx_calevents2_events.previewtext, tx_calevents2_events.image, tx_calevents2_events.venue,tx_calevents2_events.categories, weekdays,recurrent_until,event_endtime,booking '; $table = 'tx_calevents2_events'; if($this->piVars["cat"]>0){ $cat_selecter_tmp=$this->piVars["cat"]+1-1; $cat_selecter=' and tx_calevents2_events_categories_mm.uid_foreign='.$cat_selecter_tmp.' and tx_calevents2_events_categories_mm.uid_local=tx_calevents2_events.uid'; $table = 'tx_calevents2_events,tx_calevents2_events_categories_mm'; } // we try to get the default language entry (normal behaviour) or, if not possible, currently the needed language (fallback if no default language entry is available) $where = 'sys_language_uid = '.$GLOBALS['TSFE']->sys_language_uid.$only_from_this_page .' and eventscat1=0 AND hidden = 0 AND deleted = 0 and ((recurrent=0 and edate<'.$unix_datum_s.') or ((edate<'.$unix_datum_s.' and recurrent_until<'.$unix_datum_s.') and recurrent>0)) '.$cat_selecter; // always (!) use TYPO3 default function for adding hidden = 0, deleted = 0, group and date statements //$where .= $GLOBALS['TSFE']->sys_page->enableFields($table); $order = 'edate'; $group = ''; $limit = ''; $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($select, $table, $where, $group, $order, $limit); $w=0; while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) { // image aus /* if($row['image']!=''){ //$image[$w]=''; $imgConf['file'] = 'uploads/tx_calevents2/' . $row['image']; $imgConf['file.']['width'] = 160 . 'm'; //$imgConf['file.']['height'] = 54 . 'm'; $imgOutput[$w] = $this->cObj->IMAGE($imgConf); $this->local_cObj->setCurrentVal(45); $temp_conf["ATagParams"] = 'class="singlecalcontentimg"'; $temp_conf["additionalParams"] = "&tx_calevents2_pi1[uid]=".$row['uid']; $imgOutput[$w]=$this->local_cObj->typolink($imgOutput[$w], $temp_conf); } */ // programme ausgeben $program_ausgabe=''; if($row['pid']!=29){ $this->local_cObj->setCurrentVal($row['pid']); $program_ausgabe='

'.$program_head.' /

'.$this->local_cObj->typolink($programm_title_array[$row['pid']], $temp_conf); } $booking_tmp=''; // variante mit places:$booking_tmp='booking! '.$row['booking_places']; // venues $venue_tmp=$row['venue']; if($row['venue']>0){ $row['venue']=$row['venue']+1-1; $link_text_tmp=$this->pagesets[$row['venue']]; }else{ $link_text_tmp=$row['venue']; } $temp_conf["ATagParams"]= ''; $temp_conf["additionalParams"] = ''; $this->local_cObj->setCurrentVal($row['venue']); if($row['venue']){ if($pagesetsnav[$row['venue']]>0){$venue_tmp = '

'.$venue_head.' /

'.$pagesettitle[$row['venue']];}else{ $venue_tmp = '

'.$venue_head.' /

'.$this->local_cObj->typolink($link_text_tmp, $temp_conf); } }else{ $venue_tmp =''; } $temp_conf["ATagParams"] =""; $this->local_cObj->setCurrentVal($detail_page_pid); $temp_conf["ATagParams"]= ''; $temp_conf["additionalParams"] = "&tx_calevents2_pi1[uid]=".$row['uid'].'&tx_calevents2_pi1[recurrent]='.$row['recurrent'].'&tx_calevents2_pi1[edate]='.$aktueller_tag2; $titles_tmp = '

'.$this->local_cObj->typolink($row['title'], $temp_conf).'

'; if(date("j-n",$row['edate'])=='6-6' or date("j-n",$row['edate'])=='7-6' or date("j-n",$row['edate'])=='8-6'){ $titles_tmp=''.$this->pi_getLL('professional_preview').'
'.$titles_tmp;} $temp_conf["ATagParams"]= 'class="nobrclass"'; //$more_tmp =''. $this->local_cObj->typolink($this->pi_getLL('more'), $temp_conf).''; $more_tmp = $this->local_cObj->typolink($this->pi_getLL('more'), $temp_conf); $previewtext_tmp=$row['previewtext'] .' '.$more_tmp; $more_tmp = $this->local_cObj->typolink($this->pi_getLL('more'), $temp_conf); $previewtext_tmp=$row['previewtext'] .' '.$more_tmp; // +++++++++++ participants $res2=$GLOBALS['TYPO3_DB']->exec_SELECTquery( 'pages.tx_participants_p_surename,pages.tx_participants_p_name, pages.uid', #select 'pages, tx_calevents2_events_participants_mm', #from 'pages.hidden=0 and pages.deleted=0 and pages.pid=30 and pages.uid=tx_calevents2_events_participants_mm.uid_foreign and tx_calevents2_events_participants_mm.uid_local='.$row['uid'], #where $groupBy='', $orderBy='tx_participants_p_name'); //$participants =''; $participants_counter=0; $participants_tmp=''; $participants_tmp_link=''; while( $row2 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res2)) { $tmp_rowuid=$row2['uid']; $this->local_cObj->setCurrentVal($tmp_rowuid); $temp_conf["additionalParams"] = ""; $temp_conf["ATagParams"] = ''; $participants_temp=$row2['tx_participants_p_name'].' '.$row2['tx_participants_p_surename']; if($participants_counter>0){$participants_tmp_link .= ', ';} $participants_tmp_link .= $this->local_cObj->typolink($participants_temp, $temp_conf); $participants_counter++; } $participants_head=$this->pi_getLL('Participants'); if($participants_counter>0){ $participants_tmp ='

'.$participants_head.' /

'.$participants_tmp_link .'
'; //$participants[$w] =$participants_temp; } // +++++++++++ categories $caldate[$w]=''.strftime("%d %b %Y",$row['edate']) .''; $event_endtime_tmp=''; if($row['event_endtime'])$event_endtime_tmp=' - '.$row['event_endtime']; $caltime_tmp=''.strftime("%H:%M",$row['edate']).$event_endtime_tmp.''; $uid_temp=$row['uid']; // +++++++++++ categories // kategorien $categories_tmp= ' '; $res2=$GLOBALS['TYPO3_DB']->exec_SELECTquery( 'uid_foreign', #select 'tx_calevents2_events_categories_mm', #from 'uid_local='.$row['uid'], #where $groupBy='', $orderBy=''); while( $row2 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res2)) { $categories_tmp.= $categories_array[$row2['uid_foreign']].' '; $catnn=1; } if($catnn==1)$categories_tmp.='
'; $temp_conf["ATagParams"] =""; if($row['recurrent']){ /// test // $titleausgabe_tmp[$w]='
'.$caldate[$w].'
'.$caltime_tmp.'
'.$booking_tmp.' 
'.$titles_tmp.'
'.$venue_tmp.''.$program_ausgabe. '
'.$participants_tmp.$previewtext_tmp.'
$row['edate'])) { $tmp_date=$count_days; // muss um die zeit angepasst werden $temp_conf["ATagParams"] =""; $this->local_cObj->setCurrentVal($detail_page_pid); $temp_conf["ATagParams"]= ''; $temp_conf["additionalParams"] = "&tx_calevents2_pi1[uid]=".$row['uid'].'&tx_calevents2_pi1[recurrent]='.$row['recurrent'].'&tx_calevents2_pi1[edate]='.$tmp_date; $caldate[$w]=' '.strftime("%d %b %Y",$tmp_date).''; $temp_conf["ATagParams"]= ''; $temp_conf["additionalParams"] = "&tx_calevents2_pi1[uid]=".$row['uid'].'&tx_calevents2_pi1[recurrent]='.$row['recurrent'].'&tx_calevents2_pi1[edate]='.$tmp_date; $titles_tmp = '

'.$this->local_cObj->typolink($row['title'], $temp_conf).'

'; if(date("j-n",$tmp_date)=='6-6' or date("j-n",$tmp_date)=='7-6' or date("j-n",$tmp_date)=='8-6' ){ $titles_tmp=''.$this->pi_getLL('professional_preview').'
'.$titles_tmp;} $temp_conf["ATagParams"]= 'class="nobrclass"'; //$more_tmp =''. $this->local_cObj->typolink($this->pi_getLL('more'), $temp_conf).''; $more_tmp = $this->local_cObj->typolink($this->pi_getLL('more'), $temp_conf); $previewtext_tmp=$row['previewtext'] .' '.$more_tmp; // umbau listenansicht!!! // $titleausgabe_tmp[$tt]='
'.$imgOutput[$w].' '.$caldate[$w].' '.$caltime_tmp.$event_endtime_tmp.$venue[$w].'
'.$titles_tmp.' '.$previewtext_tmp. ' '.$image[$w].$participants_tmp.'
'; $tmp_counter_set=($tmp_date+$caltime_tmp_solo).str_pad($w, 4 ,'0', STR_PAD_LEFT); $titleausgabe_tmp[$tmp_counter_set]='
'.$caldate[$w].'
'.$caltime_tmp.'
'.$booking_tmp.' 
'.$titles_tmp.'
'.$categories_tmp.$program_ausgabe.' '.$venue_tmp. '
'.$participants_tmp.$previewtext_tmp.'
'.strftime("%d %b %Y",$tmp_edate).''; $temp_conf["ATagParams"]= ''; $temp_conf["additionalParams"] = "&tx_calevents2_pi1[uid]=".$row['uid'].'&tx_calevents2_pi1[recurrent]='.$row['recurrent'].'&tx_calevents2_pi1[edate]='.$tmp_edate; $titles_tmp = '

'.$this->local_cObj->typolink($row['title'], $temp_conf).'

'; $temp_conf["ATagParams"]= 'class="nobrclass"'; //$more_tmp =''. $this->local_cObj->typolink($this->pi_getLL('more'), $temp_conf).''; $more_tmp = $this->local_cObj->typolink($this->pi_getLL('more'), $temp_conf); $previewtext_tmp=$row['previewtext'] .' '.$more_tmp; // umbau listenansicht!!! // $titleausgabe_tmp[$tt]='
'.$imgOutput[$w].' '.$caldate[$w].' '.$caltime_tmp.$event_endtime_tmp.$venue[$w].'
'.$titles_tmp.' '.$previewtext_tmp. ' '.$image[$w].$participants_tmp.'
'; $titleausgabe_tmp[$w]='
'.$caldate[$w].'
'.$caltime_tmp.'
'.$booking_tmp.' 
'.$titles_tmp.'
'.$venue_tmp.''.$program_ausgabe. '
'.$participants_tmp.$previewtext_tmp.'
'.$caldate[$w].'
'.$caltime_tmp.'
'.$booking_tmp.' 
'.$titles_tmp.'
'.$categories_tmp.$program_ausgabe.' '.$venue_tmp. '
'.$participants_tmp.$previewtext_tmp.'
local_cObj->setCurrentVal($GLOBALS["TSFE"]->id); $selected_page=$page_set+1; $selected_page_link=$page_set+1; $pre_page=$page_set-1; if($pre_page<0){$pre_page=0;} $pages_total=floor($gesamttitle/$items_on_page_set); if($selected_page_link>$pages_total){$selected_page_link=$pages_total;} $temp_conf = $this->typolink_conf; $temp_conf["ATagParams"]= 'class="left pagination-item"'; $temp_conf["additionalParams"] = "&page=".$pre_page; $link_back = $this->local_cObj->typolink('', $temp_conf); $temp_conf["additionalParams"] = "&page=".$selected_page_link; $link_pre = $this->local_cObj->typolink('', $temp_conf); //$temp_conf["additionalParams"] = "&page=0"; //$link_first = $this->local_cObj->typolink("1", $temp_conf); $temp_conf["additionalParams"] = "&page=$pages_total"; $pages_total_real=$pages_total+1; $link_last = $this->local_cObj->typolink($pages_total_real, $temp_conf); $temp_conf["additionalParams"] = "&page=".$page_set; $link_point = $this->local_cObj->typolink('...', $temp_conf); $temp_conf["additionalParams"] = "&page=".$page_set; $temp_conf["ATagParams"]= 'class="left pagination-item current"'; $link_this = $this->local_cObj->typolink($selected_page, $temp_conf); $show_browser=7; $start_browser=1; if($pages_total_real>9){ $start_browser=$selected_page-($show_browser/2); } if($start_browser>$pages_total_real){$start_browser=$pages_total_real-$show_browser+1;} if($start_browser<1){$start_browser=1;} $end_browser=$start_browser+$show_browser; if($end_browser>$pages_total_real){$end_browser=$pages_total_real;$start_browser=$pages_total_real-$show_browser+1; } if($selected_page>($pages_total_real-$show_browser+1)){ $end_browser=$pages_total_real; $start_browser=$pages_total_real-$show_browser-1; $link_point=""; } if($start_browser<1)$start_browser=1; for($i = $start_browser; $i < $end_browser; $i++){ $page_set_tmp=$i-1; if($selected_page==$i){ $temp_conf["ATagParams"]= 'class="left pagination-item current"'; }else{ $temp_conf["ATagParams"]= 'class="left pagination-item"'; } $temp_conf["additionalParams"] = "&page=".$page_set_tmp; $link_tmp = $this->local_cObj->typolink($i, $temp_conf); $page_browser_numbers.=' '.$link_tmp; } $page_browser=''; if($pages_total_real<2){$page_browser='';} if($page_set>0){$start_lauf=$page_set*$items_on_page_set;}else{$start_lauf=0;} $bis_lauf=$start_lauf+$items_on_page_set+1; $title_pro_spalte=floor($gesamttitle/3); $title_pro_erstespalte=ceil($gesamttitle/3); $titleausgabe=$categories_overview; $titleausgabe.='
'; for($x=$start_lauf;$x<$bis_lauf;$x++){ //$titleausgabe.='
'.$imgOutput[$x].$categories[$x].$program_ausgabe[$x].$caldate[$x].$titles[$x].$previewtext[$x]. ' '.$image[$x].$participants[$x].'
'; $titleausgabe.=$titleausgabe_new[$x]; } $titleausgabe.='
'.$page_browser; // neu ////$titleausgabe='
'.$calcontenthead.'
'; //for($x=0;$x<$gesamttitle;$x++){ //$titleausgabe.='
'.$imgOutput[$x].$categories[$x].$caldate[$x].$titles[$x].$previewtext[$x]. ' '.$image[$x].'
'; //} $content= $titleausgabe; ?> dOCUMENTA (13) - The Origins of Art and Music 40,000 Years Ago
info
  • Menu
  • Menu
  • Menu
  • Menu

Der Ursprung von Kunst und Musik vor 40.000 Jahren

Als Teil von Jennifer Alloras und Guillermo Calzadillas künstlerischer Arbeit für die dOCUMENTA (13) handelt dieser Vortrag des Archäologen Nicholas Conard vom ältesten Musikinstrument der Welt: einer Flöte aus der Zeit des Jungpaläolithikums, die in der "Hohle Fels"-Höhle in Süddeutschland gefunden wurde. Die Flöte aus dem Knochen eines prähistorischen Gänsegeiers wird in dem Film des Künstlerduos einem lebenden Gänsegeier vorgespielt. In seinem Vortrag erläutert Professor Conard von der Universität Tübingen die Funktion der Musik im Leben der Menschen des Jungpaläolithikums, die, wie es scheint, den sozialen Zusammenhalt stärkte und neue Formen der Kommunikation ermöglichte; dadurch trug sie indirekt zur demografischen Ausbreitung des modernen Menschen im Vergleich zu den kulturell konservativeren Neandertalern bei.

 

 

Veranstaltungen

 

  • Menu
  • Menu
  • Menu
  • Menu
print