Weinfelden
Home  | Impressum  | Kontakt  | Sidemap  | Gästebuch  | Admin Login  | Webmail  |
Archive
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
Umzug 05
Frauenfeld 05
2016
Sie befinden sich hier: Home > Archive > 2006
Archive 2006 Diese Seite empfehlen Diesen Artikel im Druckformat darstellen RSS News abonieren
  Informationen und Resultate des Jahres 2006
query($query); $db->next_record(); $frontendpath = $db->f("frontendpath"); $startarton = "AND CATART.is_start = '0' AND"; //soll der startartikel mit ausgegeben werden?. $print_startartikel = "$C13"; if($print_startartikel !=""){ $startarton = "AND"; } //die Überschrift wird ausgegeben wenn sie nicht leer ist. $print_mainheadline = ""; //soll headline ausgegeben werden? $print_headline = "on"; //soll subheadline ausgegeben werden? $print_subheadline = "on"; //soll text ausgegeben werden? $print_text = "on"; //soll ein thumnail ausgegeben werden? $print_thumbnail = "on"; //thumbnail breite $thumbnail_width = "$C13"; //wenn thumbnails = 0 $imagetag = ""; // second db class instance $db2 = new DB_Contenido; // selected category $selcat = "98"; if($selcat!="0" && $selcat!=""){ // select all articles in category widthout start article $query = "SELECT ARTLANG.idart, ARTLANG.idartlang, ARTLANG.lastmodified FROM ".$cfg["tab"]["cat_art"]." AS CATART, ". $cfg["tab"]["art_lang"]." AS ARTLANG ". "WHERE CATART.idcat = '$selcat' AND ARTLANG.idart = CATART.idart AND ARTLANG.idlang = '$lang' "." $startarton " ."ARTLANG.online = '1' ORDER BY ARTLANG.lastmodified DESC"; // execute query $db->query($query); unset($articleID); unset($linkID); // get id's of sub articles while ($db->next_record()) { $articleID[] = $db->f("idartlang"); $linkID[] = $db->f("idart"); } // end while /****************** start table **************************/ echo ' '; // Loop through articles if (is_array($articleID)) { foreach ($articleID as $key => $value) { // select all CMS variables of the article if($print_headline!="0" && $print_headline!=""){ $sql = "SELECT * FROM ".$cfg["tab"]["content"]." WHERE idartlang = '$value' AND idtype = '1' AND typeid = '1'"; $db->query($sql); $db->next_record(); $headline = urldecode($db->f("value")); for ($j="50"; $j < "50"+20; $j++) { $headline1 = substr($headline , 0, $j); $cut = substr($headline, $j); if ((ord ($cut) == 32)||(ord ($cut) == 44)||(ord ($cut) == 45)) { $headline= substr($headline , 0, $j); $headline .= ' ...'; } } } $Tab_art_lang = $cfg['tab']['art_lang']; $Tab_content = $cfg['tab']['content']; $sql = "SELECT A.author AS author, B.lastmodified AS lastmod FROM $Tab_art_lang AS A, $Tab_content AS B WHERE A.idart='$value' AND B.idartlang=A.idartlang ORDER BY B.lastmodified DESC"; $db->query($sql);$db->next_record(); $modifydate= date("d.m.y",strtotime($db->f("lastmod"))); $modifytime= date("H:i",strtotime($db->f("lastmod"))); if($print_subheadline!="0" && $print_subheadline!=""){ $sql_subheadline = "SELECT * FROM ".$cfg["tab"]["content"]." WHERE idartlang = '$value' AND idtype = '1' AND typeid = '2'"; $db->query($sql_subheadline); $db->next_record(); $subheadline = urldecode($db->f("value")); for ($i="50"; $i < "50"+20; $i++) { $subheadline1 = substr($subheadline , 0, $i); $cut = substr($subheadline, $i); if ((ord ($cut) == 32)||(ord ($cut) == 44)||(ord ($cut) == 45)) { $subheadline= substr($subheadline , 0, $i); $subheadline .= ' ...'; } } } if($print_text!="0" && $print_text!=""){ $sql_text = "SELECT * FROM ".$cfg["tab"]["content"]." WHERE idartlang = '$value' AND idtype = '2' AND typeid = '1'"; $db->query($sql_text); $db->next_record(); $text = urldecode($db->f("value")); for ($i="200"; $i < "200"+20; $i++) { $text1 = substr($text , 0, $i); $cut = substr($text, $i); if ((ord ($cut) == 32)||(ord ($cut) == 44)||(ord ($cut) == 45)) { $text= substr($text , 0, $i); $text .= ' ...'; } } } /******************* begin thumbnails **********************************/ if($print_thumbnail !="0" && $print_thumbnail !=""){ // select and resolve image path $imagesql="select value from ".$cfg["tab"]["content"]." where idartlang='$value' and idtype='4' and typeid='1'"; $db2->query($imagesql); $db2->next_record(); $image_id= $db2->f("value"); // get image name and path $imagesql="select * from ".$cfg["tab"]["upl"]." where idupl='$image_id'"; $db2->query($imagesql); $db2->next_record(); $webdir='upload/'; $thumbdir='bilder/Thumbnails/'; $filedir=$frontendpath; $imagelocation=$filedir.$webdir.$db2->f('dirname').$db2->f('filename'); $thumblocation=$filedir.$webdir.$thumbdir.$db2->f('filename'); if (!file_exists($thumblocation)){ // create thunbnail $fileinformation=getimagesize($imagelocation); $imagewidth = $fileinformation[0]; $imageheight = $fileinformation[1]; $imagetype=$db2->f('filetype'); $imageattributes = $fileinformation[3]; //$newfile= $last_id."-image.".$imagetype; $target=$thumblocation; if ( !(copy($imagelocation,$target))) { echo "Could not copy file to destintaion., Command returned Error Message. Please check your log files. ".$imagelocation." ".$target; die; } //create thumbnails 80xrelational height; neu $thumbnail_width x proportionale Höhe // Determine what filetype and set pointer to source image $original_image=ImageCreateFromJPEG($target); if (!$original_image){ echo 'Error getting image from '.$target.'.'; } $palette_image =$filedir.$webdir.$thumbdir.'vorlage.jpg'; $thumbsize = getImageSize($palette_image); $maxdim = $thumbsize[0]; $draw_from = $imagelocation; $dim = GetImageSize($draw_from); if($dim[0]>$dim[1]) { $to_w = $maxdim; $to_h = round($dim[1]*($maxdim/$dim[0])); $to_x = 0; $to_y = round($maxdim-$to_h)/2; } else { $to_h = $maxdim; $to_w = round($dim[0]*($maxdim/$dim[1])); $to_y = 0; $to_x = round($maxdim-$to_w)/2; } if($dim[2]==1) {$from = ImageCreateFromGIF($draw_from);} elseif($dim[2]==2) {$from = ImageCreateFromJPEG($draw_from);} elseif($dim[2]==3) {$from = ImageCreateFromPNG($draw_from);} $thumb = ImageCreateFromJPEG($palette_image); // $set_bg_colour = ImageColorAllocate($thumb,255,0,0); // $fill_bg_colour = ImageFill($thumb,0,0,$set_bg_colour); imagecopyresampled($thumb, $from, $to_x, $to_y, 0, 0, $to_w, $to_h, $dim[0], $dim[1]); //echo $target; // set image width and height of thunbnail and put pointer for filesytsem $thumbfile= $db2->f('filename'); $target_thumb=$thumblocation; $t_width=$thumbnail_width; // calculating height to maintain ratio $t_height=($thumbnail_width/$imagewidth)*$imageheight; // remove digits to get solid number list ($t_height,$notimportand)=explode('.',$t_height); // create blank image $thumb_image=imagecreatetruecolor($t_width,$t_height); // $thumb_image=imagecreate($t_width,$t_height); // $thumb_image=ImageCreateFromJPEG($palette_image); // resize image based on height and width imagecopyresampled($thumb_image,$original_image,0,0,0,0,$t_width,$t_height,$imagewidth,$imageheight); // store image on file system // requires different functionf for either gif or jpeg imagejpeg($thumb,$target_thumb); imagedestroy($thumb); imagedestroy($original_image); } $image=$webdir.$thumbdir.$db2->f('filename'); //wenn Artikel kein Bild hat if (!$db2->f('filename')){ $image=$webdir.$thumbdir.'vorlage.jpg'; } //Ende $imagetag=""; } // ende wenn keine thumbs gewünscht /**************** Ende Thumbnails ***********************/ // link $link = $sess->url("/?m=%24m&s=%24s"); /***********************Anfang Tablezeile für Artikelliste**********************/ echo ' '; } // end while unset($headline); unset($headline1); unset($subheadline); unset($subheadline1); unset($text); unset($textl); } // end foreach } // end if (is_array) echo '
'.$headline.' '.$modifydate.'
  '.$subheadline.'
'.$imagetag.' '.$text.'
'; /***********************ende Table**********************/ ?>

Jugend und Sport
Letzte Änderungen
Bezirksschiessen fuer Junioren 2018 (02.09.2018)
Bezirksschiessen fuer Junioren 2018 (02.09.2018)
Junioren (02.09.2018)
Vorstand (02.09.2018)
Thurgauer Meisterschaft A-Match (08.07.2018)
nächste Termine
03.11.2018
Andwiler Käseschiessen
Verfasst von : Thomas Schalch   Letzte Änderung: 19.03.2007                                   [ Impressum] nach oben