|
$hostname = "10.10.1.252";
$username = "gonet";
$password = "dada66";
$dbName = "goodnet";
/* make connection to database */
MYSQL_CONNECT($hostname, $username, $password) OR
DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to selectdatabase");
$query = "SELECT * from ds_main where nr=$nr";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result);
$datum = mysql_result($result,0,"datum");
$rubriknr = mysql_result($result,0,"rubriknr");
$titel = mysql_result($result,0,"titel");
$foto_pfad0 = mysql_result($result,0,"foto_pfad0");
$tn_pfad0 = mysql_result($result,0,"tn_pfad0");
$titeltext = mysql_result($result,0,"titeltext");
$zus_text_oben = mysql_result($result,0,"zus_text_oben");
$untertitel1 = mysql_result($result,0,"untertitel1");
$text1 = mysql_result($result,0,"text1");
$foto_pfad1 = mysql_result($result,0,"foto_pfad1");
$tn_pfad1 = mysql_result($result,0,"tn_pfad1");
$untertitel2 = mysql_result($result,0,"untertitel2");
$text2 = mysql_result($result,0,"text2");
$foto_pfad2 = mysql_result($result,0,"foto_pfad2");
$tn_pfad2 = mysql_result($result,0,"tn_pfad2");
$untertitel3 = mysql_result($result,0,"untertitel3");
$text3 = mysql_result($result,0,"text3");
$foto_pfad3 = mysql_result($result,0,"foto_pfad3");
$tn_pfad3 = mysql_result($result,0,"tn_pfad3");
$untertitel4 = mysql_result($result,0,"untertitel4");
$text4 = mysql_result($result,0,"text4");
$foto_pfad4 = mysql_result($result,0,"foto_pfad4");
$tn_pfad4 = mysql_result($result,0,"tn_pfad4");
$zus_nav_r = mysql_result($result,0,"zus_nav_r");
$autor = mysql_result($result,0,"autor");
$linktext = mysql_result($result,0,"linktext");
$linkurl = mysql_result($result,0,"linkurl");
// Regulieren der Thumbnail- und Ausgabe-Bildgrösse
$maxgrtn=180;
$maxgrim=1000;
/**** Beginn Bild und Thumbnail-Produktion ****/
$file = $tn_pfad0;
$file1=$foto_pfad0;
include('texttnprod.php3');
/******* Schluss Thumbnail Produktion *********/
if($fileexistiert=="J"){print "";}else{}
if($titel!=""){print "$titel";}else{}
if($autor!=""){$autor="/".$autor;}else{}
$tag=substr($datum,8,2);
$monat=substr($datum,5,2);
$jahr=substr($datum,2,2);
if($rubriknr!=2){
print "$tag.$monat.$jahr$autor";
if($titeltext!=""){print " $titeltext ";}else{print "";}
}else{
if($titeltext!=""){print "$titeltext";}else{}
}
if($zus_text_oben!=""){print "$zus_text_oben ";}else{}
if($untertitel1!=""){print "$untertitel1";}else{}
/**** Beginn Bild und Thumbnail-Produktion ****/
$file = $tn_pfad1;
$file1=$foto_pfad1;
include('texttnprod.php3');
/******* Schluss Thumbnail Produktion *********/
if($fileexistiert=="J"){print "";}else{}
if($text1!=""){print "$text1 ";}else{}
if($untertitel2!=""){print "$untertitel2";}else{}
/**** Beginn Bild und Thumbnail-Produktion ****/
$file = $tn_pfad2;
$file1=$foto_pfad2;
include('texttnprod.php3');
/******* Schluss Thumbnail Produktion *********/
if($fileexistiert=="J"){print "";}else{}
if($text2!=""){print "$text2 ";}else{}
if($untertitel3!=""){print "$untertitel3";}else{}
/**** Beginn Bild und Thumbnail-Produktion ****/
$file = $tn_pfad3;
$file1=$foto_pfad3;
include('texttnprod.php3');
/******* Schluss Thumbnail Produktion *********/
if($fileexistiert=="J"){print "";}else{}
if($text3!=""){print "$text3 ";}else{}
if($untertitel4!=""){print "$untertitel4";}else{}
/**** Beginn Bild und Thumbnail-Produktion ****/
$file = $tn_pfad4;
$file1=$foto_pfad4;
include('texttnprod.php3');
/******* Schluss Thumbnail Produktion *********/
if($fileexistiert=="J"){print "";}else{}
if($text4!=""){print "$text4 ";}else{}
if($linktext!=""){
if($linkurl!=""){
if(strtolower(substr($linkurl,0,7))=="http://"){$linkurl="$linkurl";}else{$linkurl="http://".$linkurl;}
print "$linktext ";
}else{print "$linktext ";}
}else{}
if($rubriknr==2){print "$tag.$monat.$jahr$autor ";}else{}
?>
|