", $template[$it] ) ) {
echo "MozillaZine News Archives";
$replace = 1;
}
if (ereg( "", $template[$it] ) ) {
include("./shtml/top_nav.html");
$replace = 1;
}
if (ereg( "", $template[$it] ) ) {
include("./shtml/ad_top.html");
$replace = 1;
}
if (ereg( "", $template[$it] ) ) {
include("./shtml/ad_bottom.html");
$replace = 1;
}
if ( ereg( "", $template[$it] ) ) {
require "../login.php";
$table= "mozine_articles";
@mysql_pconnect( "$dbhost", "$dbuser", "$dbpass") or die( "Unable to connect to SQL server");
@mysql_select_db( "$dbname") or die( "Unable to select database");
$result = @mysql_query( "select * from $table WHERE article_active = 'active' order by article_date desc");
$rows=@mysql_num_rows($result);
echo"MozillaZine News Archives
\n";
echo"See the MozillaZine front page for current news.
\n";
echo "\n";
for ($i = 20; $i < $rows; $i++) {
$title=mysql_result($result, $i, article_title);
$id_tag = @mysql_result($result, $i, id_tag);
$article_date=@mysql_result($result, $i, article_date);
$article_text=@mysql_result($result, $i, article_text);
$article_subgroup=@mysql_result($result, $i, article_subgroup);
$date = @mysql_query( "select date_format('$article_date', '%W %M %D, %Y')");
$article_date=@mysql_result($date, 0,0);
echo "- $title";
$response_result = @mysql_query( "select * from responses WHERE article_id = '$id_tag'");
$response_rows = @mysql_num_rows($response_result);
if ($response_rows) {
echo " ($response_rows)";
}
$article_result = @mysql_query( "select * from mozine_articles WHERE id_tag ='$id_tag'");
if (@mysql_result($article_result,0, article_longtext)) {
echo "
![\"Full](\"./image/article_icon.gif\" "\\"Full")
";
}
echo " \n";
echo "- $article_date
\n";
}
echo "
\n";
}
if ($replace != 1){
echo "$template[$it]";
} else {
$replace = 0;
}
}
?>