require("common/_header_nocache.inc");
?>
require("common/_header.inc");
require("common/_style.inc");
require("../data/vars_main.inc");
require("common/_language_global.inc");
require("common/_language_news.inc");
if($la==""){$la="0";}
function oDateTimeToDatum($datetime,$showtime,$trenner,$language)
{
if($language == 0) // de
{
if($showtime)
{return(substr($datetime,8,2).".".substr($datetime,5,2).".".substr($datetime,0,4).$trenner.substr($datetime,11,8));}
else
{return(substr($datetime,8,2).".".substr($datetime,5,2).".".substr($datetime,0,4));}
}
else
{
if($showtime)
{return(substr($datetime,5,2)."/".substr($datetime,8,2)."/".substr($datetime,0,4).$trenner.substr($datetime,11,8));}
else
{return(substr($datetime,5,2)."/".substr($datetime,8,2)."/".substr($datetime,0,4));}
}
}
/*
* NEWS AUSLESEN
*/
$sock = mysql_connect($host,$user,$pass);
if(!$sock)
{echo(mysql_error());exit;}
if(!mysql_select_db($database,$sock))
{echo(mysql_error());mysql_close($sock);exit;}
$newsquery[0] = "SELECT newsid,newsdatumonline,newsheadlinede,newstextde,newsautor,newslink1,newslink2,newslink3,newsurl1,newsurl2,newsurl3 FROM news WHERE newsdatumonline <= '$datumakt[99]' ORDER BY newsdatumonline DESC";
$newsquery[1] = "SELECT newsid,newsdatumonline,newsheadlineen,newstexten,newsautor,newslink1,newslink2,newslink3,newsurl1,newsurl2,newsurl3 FROM news WHERE newsdatumonline <= '$datumakt[99]' ORDER BY newsdatumonline DESC";
//echo "bla ".$newsquery[1]."
blo ".$newsquery[0];
if(!($resnews=mysql_query($newsquery[$la],$sock)))
{echo(mysql_error());mysql_close($sock);exit;}
$anznews = mysql_num_rows($resnews);
$tz=0;
while ($newsrow = mysql_fetch_array ($resnews))
{
$newsid[$tz] = $newsrow["newsid"];
if($la == "0")
{
$newsheadline[$tz] = strtolower($newsrow["newsheadlinede"]);
if($newsheadline[$tz] == "")
{
$newsheadline[$tz] = "...noch nicht übersetzt...";
}
$newstext[$tz] = strtolower($newsrow["newstextde"]);
if($newstext[$tz] == "")
{
$newstext[$tz] = "diese news ist noch nicht ins deutsche übersetzt... bis es soweit is, hilft dir evtl. die englische seite weiter";
}
}
else
{
$newsheadline[$tz] = strtolower($newsrow["newsheadlineen"]);
if($newsheadline[$tz] == "")
{
$newsheadline[$tz] = "...not translatet yet...";
}
$newstext[$tz] = strtolower($newsrow["newstexten"]);
if($newstext[$tz] == "")
{
$newstext[$tz] = "this news isnīt translatet in english till now... maybe you wanna look at the german news untill we are ready...";
}
}
$newsdatum[$tz] = $newsrow["newsdatumonline"];
$newsdatum[$tz] = oDateTimeToDatum($newsdatum[$tz],0,".",$la);
$newsautor[$tz] = $newsrow["newsautor"];
$newslink1[$tz] = $newsrow["newslink1"];
$newslink2[$tz] = $newsrow["newslink2"];
$newslink3[$tz] = $newsrow["newslink3"];
$newsurl1[$tz] = $newsrow["newsurl1"];
$newsurl2[$tz] = $newsrow["newsurl2"];
$newsurl3[$tz] = $newsrow["newsurl3"];
$tz++;
}
?>
if($js!=1)
{
include "common/_nojava.inc";
}
?>
require("common/logo.inc");
?>
|
require("common/menustatus.inc");
?>
|
|
echo strtolower($la_news_header[$la]);
?>
|
|
|
require("common/menuleft.inc");
?>
|
 |
echo "\n";
$tz = 0;
while($tz < count($newsid))
{
if($tz % 2)
{$col="#404040";}
else
{$col="#707070";}
echo " \n";
echo " | $newsdatum[$tz] | \n";
echo " $newsheadline[$tz] | \n";
echo " \n";
echo " \n";
echo " | | \n";
echo " $newstext[$tz] - $newsautor[$tz] \n";
if($newslink1[$tz] != "" || $newslink2[$tz] != "" || $newslink3[$tz] != "")
{echo "»links: ";}
if($newslink1[$tz] != "")echo " »$newslink1[$tz]« ";
if($newslink2[$tz] != "")echo " »$newslink2[$tz]« ";
if($newslink3[$tz] != "")echo " »$newslink3[$tz]«";
echo " \n";
echo " | \n";
echo " \n";
$tz++;
}
echo " \n";
//echo strtolower($la_news_main[$la])." \n";
?>
|
|
|