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) - Time/Bank: Give Yourself Credit
info

GIVE YOURSELF CREDIT

Get What You Need Without Euros Or Dollars Or Pounds

When stock markets and governments fail to distribute enough money to feed, fuel, house and heal us, we make our own money.  Step A is barter: connecting directly.  Step B is issuing tokens or electrons to count trades.  Step C is becoming the bank: making interest-free loans.  This workshop prepares you to start an independent credit system that meets your community's needs.

Paul Glover is a community organizer based in Philadelphia. After thirty-five years organizing communities, he created a consultancy called GreenPlanners. He is founder of the local currency Ithaca Hours and a dozen other mutual-aid systems for food, fuel, housing, and health care, and his publications include Hometown Money (1995). http://www.paulglover.org/

 

 

Events

 


  • Menu
  • Menu
  • Menu
  • Menu
print