/** * Adds a new news entry * * @param array $data Array with news data * * @return boolean */ function addNewsEntry($data) { $query = sprintf("\n INSERT INTO\n %sfaqnews\n (id, datum, lang, header, artikel, author_name, author_email, date_start, date_end, active, comment,\n link, linktitel, target)\n VALUES\n (%d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", SQLPREFIX, $this->db->nextID(SQLPREFIX . 'faqnews', 'id'), $data['date'], $data['lang'], $data['header'], $data['content'], $data['authorName'], $data['authorEmail'], $data['dateStart'], $data['dateEnd'], $data['active'], $data['comment'], $data['link'], $data['linkTitle'], $data['target']); if (!$this->db->query($query)) { return false; } return true; }
/** * Inserts an item and definition into the database * * @param string $item Item * @param string $definition Definition * @return boolean */ public function addGlossaryItem($item, $definition) { $this->item = $this->db->escape_string($item); $this->definition = $this->db->escape_string($definition); $query = sprintf("\n INSERT INTO\n %sfaqglossary\n (id, lang, item, definition)\n VALUES\n (%d, '%s', '%s', '%s')", SQLPREFIX, $this->db->nextID(SQLPREFIX . 'faqglossary', 'id'), $this->language, $this->db->escape_string($this->item), $this->db->escape_string($this->definition)); if ($this->db->query($query)) { return true; } return false; }