//Letzte Beiträge

		opentable($locale['magazin_001a']);

		$rows = dbcount("(magazin_id)", DB_MAGAZIN);

		if ($rows != 0) {

		//$result = dbquery("SELECT magazin_id, magazin_user, magazin_cat, magazin_name, magazin_description, magazin_datestamp, magazin_count, magazin_allow_ratings FROM ".DB_MAGAZIN." LEFT JOIN ".DB_MAGAZIN_CATS." ON magazin_cat_name ORDER BY magazin_id DESC LIMIT 0,30");

		$result = dbquery("SELECT * FROM ".DB_MAGAZIN." LEFT JOIN ".DB_MAGAZIN_CATS." ON magazin_cat=magazin_cat_id WHERE ".groupaccess('magazin_cat_access')." AND magazin_cat_id=".$cat_id." ORDER BY magazin_cat_name");

		$numrows = dbrows($result); $i = 1;

		echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl-border'><tr>";

		echo "<td class='tbl2' width='5%' align='center'></td>";

		echo "<td class='tbl2' width='70%' align='left'><b>".$locale['magazin_153']."</b></td>";

		echo "<td class='tbl2' width='25%' align='left'><b>".$locale['magazin_155']."</b></td>";;

		echo "</tr>";

		while ($data = dbarray($result)) {

		$str = stripslashes($data['magazin_description']);

		$description = preg_replace('#\[[^\]]+\]#', '', $str);

		if ($data['magazin_datestamp']+172800 > time()+($settings['timeoffset']*3600)) {

		$new = "<img src='".INFUSIONS."magazin_system/images/pagenew.png'>";

		} else {

		$new = "<img src='".INFUSIONS."magazin_system/images/page.png'>";

		}

		echo "<tr>";

		echo "<td class='tbl1' width='5%' align='center'>$new</td>";

		echo "<td class='tbl1' width='70%' align='left'>".$data['magazin_cat_name']."<a href='".FUSION_SELF."?cat_id=".$data['magazin_cat']."&amp;magazin_id=".$data['magazin_id']."'>".$data['magazin_name']."</a></span></td>";

		echo "<td class='tbl1' width='25%' align='left'>".showdate("shortdate", $data['magazin_datestamp'])."</td>";

		}

		echo "</tr></table>";

		closetable();