// News v.1.2.1 function pheed($newsid){ GLOBAL $PHP_SELF,$prev,$newsid,$month,$year; include "ini.php"; $conid=dbconnect ($dbname,$username,$password); ?>
" valign="center"> |
">
if (!isset($newsid)){
if (!isset($prev)){
if (isset($month)){
$sql="SELECT id,date,title FROM $dbtable WHERE (MONTH(date)=$month AND YEAR(date)=$year) ORDER BY date DESC";
}else{
$sql="SELECT id,date,title FROM $dbtable ORDER BY date DESC LIMIT 10";
};
$result=dbquery($conid,$sql);
while (list($id,$date,$title)=dbfetch($result)){
$date=substr($date,0,10);
$dat=explode("-",$date);
$date="$dat[2]-$dat[1]-$dat[0]";
?>
print $date ?> print $title ?> -»
};
print "";
} else{
?>
print $lang["allnews"]?> $result = dbquery($conid, "SELECT DISTINCT(MONTH(date)) as month, year(date) as year FROM $dbtable ORDER BY year DESC, month DESC"); while (list($month,$year)=dbfetch($result)){ print "[$mtext[$month] $year] "; }; print "$result = dbquery($conid, "SELECT max(id) as maxid FROM $dbtable WHERE (id<'$newsid') LIMIT 1 "); list($tmp)=dbfetch($result); if ($tmp!=""){ ?> «- }; $result = dbquery($conid, "SELECT min(id) as minid FROM $dbtable WHERE (id>'$newsid') LIMIT 1 "); list($tmp)=dbfetch($result); if ($tmp!=""){ ?> -» }; ?> print $title ?> $caption"; }; if ($URL!=""){ print ""; }; ?> $result = dbquery($conid, "SELECT id,date,title FROM $dbtable WHERE id<$newsid ORDER BY date DESC LIMIT 5"); while (list ($newsid,$date,$title)=dbfetch($result)){ $date=substr($date,0,10); ?> print $date ?> print $title ?> -» }; }; dbfree($result); ?> |