/**
* Get an array with minimalistic attachment meta data
*
* @param integer $start Listing start
* @param integer $limit Listing end
*
* @return array
*/
public function getBreadcrumbs($start = 0, $limit = 0)
{
$retval = array();
$query = sprintf("\n SELECT\n fa.id,\n fa.record_id,\n fa.record_lang,\n fa.filename,\n fa.filesize,\n fa.mime_type,\n fd.thema\n FROM\n %s fa\n JOIN\n %s fd\n ON\n fa.record_id = fd.id", SQLPREFIX . 'faqattachment', SQLPREFIX . 'faqdata');
$result = $this->db->query($query);
if ($result) {
$retval = $this->db->fetchAll($result);
}
return $retval;
}
/**
* Get an array with minimalistic attachment meta data
*
* @param integer $start Listing start
* @param integer $limit Listing end
*
* @return array
*/
public function getBreadcrumbs($start = 0, $limit = 0)
{
$retval = array();
$sql = str_replace(array('_t1_', '_t2_'), array(SQLPREFIX . "faqattachment", SQLPREFIX . "faqdata"), "SELECT\n\t\t\t _t1_.id,\n _t1_.record_id, _t1_.record_lang,\n _t1_.filename, _t1_.filesize, _t1_.mime_type,\n _t2_.thema\n FROM\n _t1_\n JOIN _t2_ ON _t1_.record_id = _t2_.id");
$result = $this->db->query($sql);
if ($result) {
$retval = $this->db->fetchAll($result);
}
return $retval;
}
