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 setUser($userData, $update = false)
{
if ($this->dbObj == null) {
$users = $this->get('users');
$users[$userData['user_name']]['user_password'] = $userData['user_password'];
$users[$userData['user_name']]['role_name'] = $userData['role_name'];
$this->set('users', $users);
} else {
$sql = "";
if (!$update) {
$sql = "INSERT INTO users (user_name, user_password, user_role) VALUES ";
$sql .= "('{$userData['user_name']}'";
$sql .= ", '{$userData['user_password']}'";
$sql .= ", '{$userData['user_role']}')";
} else {
$sql = "UPDATE users SET ";
$sql .= "user_password='******'user_password']}'";
$sql .= ", user_role='{$userData['user_role']}'";
$sql .= " WHERE user_name='{$userData['user_name']}'";
}
$this->dbObj->ExecuteNonQuery($sql);
}
}
/**
* 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;
}