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) - Winning Hearts and Minds
info
  • Menu
  • Menu
  • Menu
  • Menu

Winning Hearts and Minds

Winning Hearts and Minds, eines der zwei Projekte des Critical Art Ensemble, ist eine täglicher Treffpunkt, der einzelnen Personen die Möglichkeit bietet, Vorträge zu frei gewählten Themen zu halten. Der Veranstaltungsort ist ein Gebäude neben den Eisenbahngleisen am hinteren Ende des Hauptbahnhofs. An diesem Ort, der dank seiner Abgeschiedenheit an die sogenannten "free speech zones" erinnert, die sich in jüngster Zeit in den USA etabliert haben (wie beispielsweise Camp X-Ray in Guantanamo), findet an jedem der 100 Tage der dOCUMENTA (13) mittags ein Vortrag statt. Die Vortragenden können sich über ein "Open call"-System auf www.critical-art.net/WinningHeartsAndMinds/ anmelden.

 

 

Veranstaltungen

 

  • Menu
  • Menu
  • Menu
  • Menu
print