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 > 2005
Archive 2005 Diese Seite empfehlen Diesen Artikel im Druckformat darstellen RSS News abonieren
  Informationen und Resultate des Jahres 2005
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 = "96"; 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 2017 (18.10.2017)
Bezirksschiessen fuer Junioren 2017 (18.10.2017)
KantonalFinal Jugendliche 2017 (18.10.2017)
KantonalFinal Jugendliche 2017 (18.10.2017)
Präsidentencup (18.10.2017)
nächste Termine
Es liegen aktuell keine Termine vor!
Verfasst von : Thomas Schalch   Letzte Änderung: 02.05.2006                                   [ Impressum] nach oben