// tohle mam v registraci

$db = new Oracle ();
        $db->connect();
        if ($db->insert('INSERT INTO WWW_USERS(USERNAME, PASSWORD, FIRSTNAME, SURNAME, EMAIL) VALUES(\'' . $username . '\', \'' . $password . '\', \'' . $firstname . '\', \'' . $surname . '\', \'' . $email . '\')')) {
            $db->close();
            header('Location:' . $_SERVER['SCRIPT_NAME'] . '?co=registered');
        } else {
            $db->close();
            header('Location:' . $_SERVER['SCRIPT_NAME'] . '?co=fail');
        }

// v loginu se vyuziva trida Auth.php

$db = new Oracle ();
        $db->connect();
        $r = $db->select('SELECT * FROM www_users where USERNAME =\'' . $username . '\' and PASSWORD = \'' . $password . '\'');
        $db->close();
        if ($r != false) {
            if (count($r) > 0) {
                $profil = array('username' => $r['USERNAME'], 'email' => $r['EMAIL'], 'firstname' => $r['FIRSTNAME'], 'surname' => $r['SURNAME']);
                $_SESSION['identity'] = $profil;
                self::$identity = $profil;
                if($r['ROLE'] == 0) {
                    $_SESSION['role'] = 'admin';
                } else {
                    $_SESSION['role'] = 'user';
                }
                return true;
            } else {
                self::$identity = NULL;
                return false;
            }
        } else {
            return false;
        }

// nejakej update

$db = new Oracle ();
        $db->connect();
        if ($db->doSql('UPDATE WWW_USERS SET PASSWORD =\'' . $new_password . '\' WHERE USERNAME = \'' . $_SESSION['identity']['username'] . '\'')) {
            $db->close();
            header('Location:' . $_SERVER['SCRIPT_NAME'] . '?co=heslo-zmeneno');
        } else {
            $db->close();
            header('Location:' . $_SERVER['SCRIPT_NAME'] . '?co=fail');
        }