first stab at 0.2

[sql-web.git] / lib / security.lib.php

<?php

require_once('mitsql.lib.php');

class Login {
    var $info;
    function Login($u, $p=null) {
        $opt = is_null($p)?'':sprintf(" AND Password='%s' ", mysql_escape_string(base64_encode($p)));
        $sql = sprintf("SELECT UserId, Username, Name, Email, UL, bEnabled
                        FROM User
                        WHERE Username = '%s'
                        $opt",
                        mysql_escape_string($u));
        $r = fetchRows(DBSelect($sql),'UserId');
        $this->info = count($r)?array_shift($r):null;
    }
    function exists() {
        return !is_null($this->info);
    }
    function isValid() {
        return $this->isEnabled() && $this->getUL()>0;
    }
    function isEnabled() {
        return $this->exists() && $this->info['bEnabled']==1;
    }
    function getUserId() {
        return $this->exists() && $this->info['UserId'];
    }
    function getUsername() {
        return $this->exists() && $this->info['Username'];
    }
    function getName() {
        return $this->exists() && $this->info['Name'];
    }
    function getEmail() {
        return $this->exists() && $this->info['Email'];
    }
    function getUL() {
        return $this->exists() && $this->info['UL'];
    }
    function expire() {
        $this->info = null;
    }
    function refresh() {
        $this->Login($this->getUsername());
    }
    function update($name=null,$email=null) {
        if (!$this->exists()) return;
        $arr = array();
        is_null($name) || $arr['Name'] = $name;
        is_null($email) || $arr['Email'] = $email;
        $sql = sprintf("UPDATE User %s WHERE UserId = '%s'",
                        buildSQLSet($arr), mysql_escape_string($this->getUserId()));
        DBUpdate($sql);
    }
}


function isLoggedIn($aLogin=null) {
    if (is_null($aLogin)) {
        global $Login;
        $aLogin = $Login;
    }
    return !empty($aLogin) && is_a($aLogin, 'Login') && $aLogin->isValid();
}

function isSSL() {
	return $_SERVER['SERVER_PORT'] == 443;
}

function getSSLCert() {
    if (DEVEL && file_exists('.forceauth')) {
        $fu = explode('|',file_get_contents('.forceauth'));
        $name = $fu[0];
        $email = $fu[1];
    } else {
        $name = isset($_SERVER['SSL_CLIENT_S_DN_CN'])?$_SERVER['SSL_CLIENT_S_DN_CN']:null;
        $email = isset($_SERVER['SSL_CLIENT_S_DN_Email'])?$_SERVER['SSL_CLIENT_S_DN_Email']:null;
    }
    if (!is_null($email)) {
        $user = explode('@',$email);
		$user = $user[0];
        return array('Username'=>$user, 'Name'=>$name, 'Email'=>$email);
	} else {
		return null;
	}
}

## 302 REDIRECTS

function redirect($target=NULL) {
    $base = (is_null($target)||substr($target,0,1)=='?')?$_SERVER['REDIRECT_URL']:(dirname($_SERVER['REDIRECT_URL']).'/');
    redirectFull(is_null($target)?$base:($base.$target));
}
function redirectFull($target) {
	redirect2((isSSL()?'https://':'http://').$_SERVER['SERVER_NAME'].$target);
}
function redirect2($target) {
	header('Location: '.$target);
	exit;
}

## USER SCRIPTS

function addUser($sslCredentials) {
    global $_NEW_USER;
    $arr = array_merge($sslCredentials, $_NEW_USER);
    $sql = sprintf("INSERT INTO User %s",
                    buildSQLInsert($arr));
    return DBInsert($sql);
}

?>