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 Prodigy of Nature
info
  • Menu
  • Menu
  • Menu
  • Menu

The Prodigy of Nature

Once a week, during the exhibition, Chiara Fumai embodies the nineteenth-century bearded lady Annie Jones and reads a selection of letters of admiration sent to Mrs. Jones by twentyfirst century artists and writers. A spirit cabinet containing all the texts received via mediumistic writing, as well as all the thought forms produced during this mediumistic transmission is used as a freak-show scenario.

Words by: Mario Bellatin, Gabriel Lester, Stefano Chiodi, Antonio Cataldo, Pier Vittorio Tondelli, Ingo Niermann, Valentinas Klimasauskas, Antonio Pezzuto, Vanessa Hodgkinson, Filip Adrian Dziegielewski, Audrey Cottin, Nicola Setari, Marcos Lutyens, Lino Sinibaldi, Ruta Juneviciute, N.H. Francesco Urbano Ragazzi, Milovan Farronato, Monika Lipsic, Olof Olsson.

 

 

Events

 

  • Menu
  • Menu
  • Menu
  • Menu
print