<?php
// $Id: lid.php,v 1.1 2004/07/11 10:28:52 Farsus Exp $
// -------------------------------------------------------------------------//
//			       RUNCMS                                                   //
//                                                                          //
//	 reliable - Unique - Nocost &  Simplicity & ease off use                //
//                       < http://www.runcms.org >                          //
// -------------------------------------------------------------------------//
// Original Author: Half-Dead
// Author Website : http://www.e-xoops.com
// License Type   : Proprietary: See /manual/LICENSES/E-Xoops.txt
// ------------------------------------------------------------------------- //

// Single Files
function get_meta($id, $limit) {
global $db;

$SQL =  "
	SELECT
	".$db->prefix("mydownloads_cat.title").",
	".$db->prefix("mydownloads_downloads.title").",
	".$db->prefix("mydownloads_downloads.description")."
	FROM
	".$db->prefix("mydownloads_cat").",
	".$db->prefix("mydownloads_downloads")."
	WHERE
	(".$db->prefix("mydownloads_downloads.lid")."=$id
	AND
	".$db->prefix("mydownloads_cat.cid")."=".$db->prefix("mydownloads_downloads.cid").")";

$query  = $db->query($SQL, $limit);
list($cat_title, $link_title, $description) = $db->fetch_row($query);
	$result["title"]    = $link_title .", ". $cat_title;
	$result["keywords"] = $link_title ." ". $cat_title ." ". $description;

return $result;
}
?>
