/**
* 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;
}
/**
* Check if a table is filled with data
*
* @param string $tableName Table name
*
* @return boolean true, if table is empty, otherwise false
*/
public static function checkOnEmptyTable($tableName)
{
if (self::$instance->num_rows(self::$instance->query('SELECT * FROM ' . SQLPREFIX . $tableName)) < 1) {
return true;
} else {
return false;
}
}
/**
* Check if a table is filled with data
*
* @param string $tableName Table name
*
* @return boolean true, if table is empty, otherwise false
*/
public static function checkOnEmptyTable($tableName)
{
if (self::$instance->numRows(self::$instance->query('SELECT * FROM ' . PMF_Db::getTablePrefix() . $tableName)) < 1) {
return true;
} else {
return false;
}
}
/**
* Add new entry into faqlinkverifyrules table
*
* @param string $type
* @param string $url
* @param string $reason
* @return void
* @access public
* @author Thorsten Rinne <*****@*****.**>
*/
function addVerifyRule($type = '', $url = '', $reason = '')
{
if ($type != '' && $url != '') {
$query = sprintf("INSERT INTO\n %sfaqlinkverifyrules\n (id, type, url, reason, enabled, locked, owner, dtInsertDate, dtUpdateDate)\n VALUES\n (%d, '%s', '%s', '%s', 'y', 'n', '%s', '%s', '%s')", SQLPREFIX, $this->db->nextID(SQLPREFIX . "faqlinkverifyrules", "id"), $this->db->escapeString($type), $this->db->escapeString($url), $this->db->escapeString($reason), $this->db->escapeString($this->user->getLogin()), $this->db->escapeString(date('YmdHis')), $this->db->escapeString(date('YmdHis')));
$this->db->query($query);
}
}
/**
* Remove meta data from the db
*
* @return null
*/
protected function deleteMeta()
{
$sql = sprintf("DELETE FROM\n %sfaqattachment\n WHERE id = %d", SQLPREFIX, $this->id);
$this->db->query($sql);
}
/**
* Remove meta data from the db
*
* @return null
*/
protected function deleteMeta()
{
$sql = sprintf("DELETE FROM %sfaqattachment WHERE id = %d", PMF_Db::getTablePrefix(), $this->id);
$this->db->query($sql);
}
