function __destruct() { cLogsDb::$count_glob--; parent::__destruct(); if (cLogsDb::$count_glob == 0 && DB_DEBUG) { //cLogs::$aLogsAll[] = array("DB_QUERIES",cLogsDb::$aDbFileLogs); cLogsDb::writeLogsToFile(); } }
$aErrors[] = admin_getErrorToPrint($k, $error); } } else { try { $aVals = array(); $aVals[] = array('name', $_POST['name']); $aVals[] = array('description', $_POST['description']); /// insert values /// if (!$DB->insert('core_capabilities', $aVals)) { throw new cException("Some error during insert operation!"); } $aAlerts[] = "New capability waw added."; } catch (cException $e) { $msg = $e->getDbMessageError(__METHOD__ . '(line:' . __LINE__ . ')', $query); $aErrors[] = $msg; cLogsDb::addFileLog($msg); } } } /// end of POST data sent /// ########################################################################################### ##################################### code to print ####################################### foreach ($aErrors as $error) { print "<div class='error'>{$error}</div>"; } foreach ($aAlerts as $alert) { print "<div class='alert'>{$alert}</div>"; } ?> <h3>Add new capability</h3> <form action="" name="fc_capabilities" method="post">
/** * drop table * @param string $tablename - name of table */ public function dropTable($tablename) { $class = cDb::$logClass; $msg = __CLASS__ . ": " . __FUNCTION__; if (is_object($this)) { $msg = get_class($this) . ": " . $msg; } try { $query = "DROP TABLE {$tablename}"; if (!mysql_query($query)) { throw new cException("Table {$tablename} couldn't be droped!"); } cLogsDb::addFileLog($query); if (is_object($this) && is_object($this->logs)) { $this->logs->addLog($query, $msg, "_dbLog"); } else { cDb::$logs->addLog($query, $msg, $class); } return true; } catch (cException $e) { $query = $e->getDbMessageError(__METHOD__ . '(line:' . __LINE__ . ')', $query); cLogsDb::addFileLog($query); cDb::$logs->addLog($query, $msg, $class . " _error"); return false; } }
function _updateCapabilities() { global $DB; global $_aErrors; global $_aAlerts; $Check = new cCheckForm(); $colsToDb = array(array('capability', false), array('role', false)); $dataToDb = array(); foreach ($_POST as $k => $v) { $_POST[$k] = get_magic_quotes_gpc() ? trim($v) : trim(addslashes($v)); $aDat = explode('_', $k, 3); /// post data with values for core_role_capability /// if ($aDat[0] == "caprole" && count($aDat) == 3) { $Check->check('cap', 'is_numeric($test)', 'The id of capability is in wrong type', $aDat[1]); $Check->check('role', 'is_numeric($test)', 'The id of role is in wrong type', $aDat[2]); $dataToDb[] = array($aDat[1], $aDat[2]); } } //$Logs->addLog($Check->isValid(), 'valid'); try { if (!$Check->isValid()) { foreach ($Check->getErrors() as $k => $error) { $_aErrors[] = implode("(<strong>{$k}</strong>)<br />", $error['msg']) . "(<strong>{$k}</strong>)"; } throw new cException("Form is not valid!"); } /// make backup of original table /// if (!$DB->createCopyOfTable('core_role_capability', 'core_role_capability_back')) { throw new cException("Some error during backup operation of old data!"); } /// empty original table /// if (!$DB->truncateTable('core_role_capability')) { /// drop backup table /// $DB->dropTable('core_role_capability_back'); throw new cException("Some error during insert operation!"); } /// insert new values to original table /// if (!$DB->insertMore('core_role_capability', $colsToDb, $dataToDb)) { /// copy data from backup to original table /// $DB->createCopyOfTable('core_role_capability_bak', 'core_role_capability'); throw new cException("Some error during insert operation!"); } /// empty backup table /// $DB->dropTable('core_role_capability_back'); $_aAlerts[] = "Capabilities were updated."; } catch (cException $e) { $msg = $e->getDbMessageError(__METHOD__ . '(line:' . __LINE__ . ')', $query); $_aErrors[] = $msg; cLogsDb::addFileLog($msg); } }
/** * Ulozeni noveho odberatele, pokud je uzivatel prihlasen, ulozi ho pod jeho useraccount * @return int/false - ID odberatele in DB nebo vrati false, pokud se nezdarila operace */ private function saveOdberatel() { /// prihlaseny uzivatel /// if (!is_null($this->CFG->getUseraccountId())) { $this->aOdbToDb[] = array('useracc', $this->CFG->getUseraccountId(), false); } $this->aOdbToDb[] = array('nazev', $this->aPost['odb_nazev']); $this->aOdbToDb[] = array('ulice', $this->aPost['odb_ulice']); $this->aOdbToDb[] = array('mesto', $this->aPost['odb_mesto']); $this->aOdbToDb[] = array('psc', $this->aPost['odb_psc']); if ($this->aPost['odb_ico'] != "") { $this->aOdbToDb[] = array('ico', (int) $this->aPost['odb_ico'], false); } if ($this->aPost['odb_dic'] != "") { $this->aOdbToDb[] = array('dic', $this->aPost['odb_dic']); } if ($this->aPost['odb_email'] != "") { $this->aOdbToDb[] = array('email', $this->aPost['odb_email']); } if ($this->aPost['odb_tel'] != "") { $this->aOdbToDb[] = array('tel', $this->aPost['odb_tel']); } try { if (!$this->db->insert('odberatele', $this->aOdbToDb)) { throw new cException(getString("Neočekávaná chyba během ukládání odběratele!", 'faktura')); } //$this->aAlerts[] = getString("Byl přidán nový odběratel.",'faktura'); } catch (cException $e) { $this->aErrors[] = $e->getMessage(); cLogsDb::addFileLog($e->getDbMessageError(__METHOD__ . '(line:' . __LINE__ . ')')); return false; } return $this->db->getLastId(); }