Ejemplo n.º 1
0
 /**
  * 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);
     }
 }