/**
* Save attachment meta data
*
* @return integer saved attachment id
*
* @todo implement update case
*/
public function saveMeta()
{
$faqattTableName = sprintf('%sfaqattachment', SQLPREFIX);
if (null == $this->id) {
$this->id = $this->db->nextID($faqattTableName, 'id');
$sql = sprintf("\n INSERT INTO \n %s\n (id, record_id, record_lang, real_hash, virtual_hash,\n password_hash, filename, filesize, encrypted, mime_type)\n VALUES\n (%d, %d, '%s', '%s', '%s', '%s', '%s', %d, %d, '%s')", $faqattTableName, $this->id, $this->recordId, $this->recordLang, $this->realHash, $this->virtualHash, $this->passwordHash, $this->filename, $this->filesize, $this->encrypted ? 1 : 0, $this->mimeType);
$result = $this->db->query($sql);
} else {
// do update here
}
return $this->id;
}
/**
* 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);
}
}
