public function checkLoggedUser() { if ($_SESSION['session']) { $user = cDb::select(array('core_authentications', array('user', '=', 'core_users.id', 'LEFT'), 'core_users', array('role', '=', 'core_roles.id', 'LEFT'), 'core_roles'), array('core_users.*', 'session', 'core_roles.name as rolename'), array(array('session', '=', $_SESSION['session']), 'AND', array('ip', '=', $_SERVER['REMOTE_ADDR']), 'AND', array('core_users.active', '=', 1)), null, 1); if (count($user)) { return $user[0]; } } return false; }
public function setUserAccount() { $result = cDb::select('useraccount', '*', array('user', '=', self::getUserData('id'))); cCfg::$aUserData['account'] = array(); if (is_array($result) && count($result)) { //cCfg::$idActiveUseraccount = $result[0]['id']; cCfg::$aUserData['account'] = $result[0]; } $aDod = cDb::select('dodavatele', '*', array('useracc', '=', $result[0]['id'])); cCfg::$aUserData['dodavatele'] = array(); foreach ($aDod as $dod) { cCfg::$aUserData['dodavatele'][$dod['id']] = $dod; if (is_null(cCfg::$idActiveUseraccount)) { cCfg::$idActiveUseraccount = $dod['id']; } } cCfg::$logs->addLog(cCfg::$aUserData, 'aUserData'); }
/** * get all data from DB about the page * @param mixed $paramValue - can be number or string; value of column to be selected from DB * @param string $paramName[optional][default 'name'] - name of column in table core_pages; the query is based on it; * <p><strong>allowed: id, name</strong></p> * @return array - if no record about this pageName, returns empty array otherwise return the first record */ public function getPageData($paramValue, $paramName = 'name') { $paramValue = get_magic_quotes_gpc() ? $paramValue : addslashes($paramValue); if (in_array($paramName, array("id", "name"))) { $aPageVal = array($paramName, '=', $paramValue); } else { return array(); } $result = cDb::select('core_pages', '*', array($aPageVal)); if (is_array($result) && count($result)) { return $result[0]; } else { return array(); } }
function admin_getAllCapabWithRights() { $aData = cDb::select(array('core_capabilities as c', array('c.id', '=', 'capability', 'LEFT'), 'core_role_capability as rc'), array('rc.id', 'rc.role as roleid', 'c.id as capid', 'c.name', 'description')); if (is_array($aData)) { return admin_parseCapabData($aData); } return array(); }
/** * Funkce vrati data odberatele dle ID a v pripade zadani druheho parametru * i v zavislosti na ID uzivatelskeho uctu. Pokud takoveho odberatele nenalezne, vrati prazdne pole. * Pokud je $id null a je nastaven druhy parametr, vrati odberatele pro dany uz. ucet. * Pokud jsou oba parametry NULL, vrati vsechny odberatele v db. * @param int $id[optional][default null] - id odberatele * @param int $userAccountId[optional][default null] - id uzivatelskeho uctu, pod kterym je odberatel ulozen * @return array */ public function getOdberatel($id = null, $userAccountId = null) { if (is_null($userAccountId) && is_null($id)) { return cDb::select('odberatele', '*'); } else { if (is_null($userAccountId)) { $where = array('id', '=', trim($id)); } else { if (is_null($id)) { $where = array('useracc', '=', trim($userAccountId)); } else { $where = array(array('id', '=', trim($id)), 'AND', array('useracc', '=', trim($userAccountId))); } } } return cDb::select('odberatele', '*', $where); }