public function getUser($username) { $user = null; if ($this->dbObj != null) { $query = "SELECT * FROM users u LEFT JOIN roles r ON u.user_role = r.role_id WHERE user_name='{$username}'"; $results = $this->dbObj->ExecuteTableQuery($query); if (!empty($results)) { $user = $results[0]; } } else { if (isset($this->config['users'][$username])) { $user = $this->config['users'][$username]; $user['user_name'] = $username; } } return $user; }
public function getUser($username) { $userData = null; if ($this->dbObj == null) { $users = $this->loadedConfig['users']; if (isset($users[$username])) { $userData = $users[$username]; $userData['user_name'] = $username; } } else { $sql = "SELECT * FROM users WHERE user_name='{$username}'"; $results = $this->dbObj->ExecuteTableQuery($sql); if (!empty($results)) { $userData = $results[0]; } } return $userData; }
/** * Loads configuration from the DB. * * @param DB $dbObj Database connection object * @return array Loaded configuration */ private function loadConfigurationFromDb($dbObj, $configPhpFileDir, $alreadyLoadedConfig, $configFileMapping) { $loadedConfig = $this->loadConfigurationFromPhpFile($configPhpFileDir, $alreadyLoadedConfig, $configFileMapping); $getRolesQry = "SELECT * FROM roles"; $results = $dbObj->ExecuteTableQuery($getRolesQry); foreach ($results as $row) { $loadedConfig['roles'][] = $row['role_name']; } return $loadedConfig; }