/** * Constructor * * @return void */ public function __construct() { $this->db = Centreon_Db_Manager::factory('centreon'); $res = $this->db->query("SELECT `value` FROM informations WHERE `key` = 'version'"); $row = $res->fetch(); $this->version = $row['value']; $this->params = array(); $this->insertParams = array(); $this->exportExcludedParams = array(); $this->action = ""; $this->delim = ";"; }
/** * check if user exists already in dbmail user table * * @param Tinebase_Model_FullUser $_user */ protected function _userExists(Tinebase_Model_FullUser $_user) { $userId = $_user->getId(); $select = $this->_getSelect(); $select->where($this->_db->quoteIdentifier($this->_propertyMapping['emailUserId']) . ' = ?', $this->_hasTine20Userid === true ? $userId : $this->_convertToInt($userId)); if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) { Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' ' . $select->__toString()); } // Perferom query - retrieve user from database $stmt = $this->_db->query($select); $queryResult = $stmt->fetch(); $stmt->closeCursor(); if (!$queryResult) { return false; } return true; }
/** * Runs the sql query * * @param string $sqlQuery */ public function runSetup($sqlQuery) { $this->dbAdapter->query($sqlQuery); }
/** * check if user exists already in dovecot user table * * @param Tinebase_Model_FullUser $_user */ protected function _userExists(Tinebase_Model_FullUser $_user) { $select = $this->_getSelect(); $select->where($this->_db->quoteIdentifier($this->_userTable . '.' . $this->_propertyMapping['emailUserId']) . ' = ?', $_user->getId()); #if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' ' . $select->__toString()); // Perferom query - retrieve user from database $stmt = $this->_db->query($select); $queryResult = $stmt->fetch(); $stmt->closeCursor(); if (!$queryResult) { return false; } return true; }