<?php

////////////////////////////////////////
// archiv.php
//-------------------------------------
// Einstiegsseite zur �bersicht
// 
// ------------------------------------
// 28.08.2006
// Ralph Lanfermann
///////////////////////////////////////

$dat_bild  = "io_bilder";		// Datenbanktabelle
$dat_kate  = "io_bkateg";	

// Datenbank �ffnen
require("../dbadm/dbionl.php");

include("./rss10.inc.php");

$sqlz = "SELECT * FROM $dat_bild ORDER BY binsert DESC LIMIT 0,15";
$ergz = mysql_query($sqlz,$conn);

$rss=new RSSWriter("http://www.irgendwas-online.de/", "Photogalerie", 
	"Photos und Bilder.", 
		array("dc:publisher" => "www.irgendwas-online.de", 
		"dc:creator" => "www.irgendwas-online.de <info@irgendwas-online.de>"));

while($eez= mysql_fetch_array($ergz))
		{
		$link = "http://www.irgendwas-online.de/photos/index.php?akat=$eez[bcat]&bild=$eez[bidx]";
		
		$sqk = "SELECT bkname FROM $dat_kate WHERE bkidx='$eez[bcat]'";
		$erk = mysql_query($sqk,$conn);
		$eek = mysql_fetch_array($erk);
		
		$info = "Kategorie ".$eek[bkname]." mit neuem Bild.";
		$rss->addItem($link,$info);
		}
	$rss->serialize();

?>