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) - DIMIs Re-connected
info

DIMIs Re-connected

In the performance DIMIs Re-connected, sound artist Tarek Atoui and three professional musicians from Helsinki play several historical electronic instruments designed and developed by the Finnish electronicmusic pioneer Erkki Kurenniemi. The performance takes place in a larger installation of instruments and apparatuses built by Kurenniemi and a 99 presentation of archival material centering on him and his Electronic Music Studio in Helsinki. Some of the electronic instruments on display can also be played by visitors.

In addition, a conference and open workshop is held on September 14 under the title “Online Archive: Erkki Kurenniemi (In 2048).” Constant (Nicolas Malevé and Michael Murtaugh) discuss a series of experiments in connection with the archive of Erkki Kurenniemi that they have developed. This session, which takes place at sound artist Tarek Atoui’s workshop space La Lutherie (see p. 74), introduces the project and invites participants to explore the alternative interpretations together with Constant.

 

 

Events

 


  • Menu
  • Menu
  • Menu
  • Menu
print