nuBuilder Forum

Code: Select all

function nuStringContains($needle, $haystack): bool {

Code: Select all

//Check for Standlone User login
function nuCheckUserLoginRequest() {

	$sql = "
				SELECT IF (sus_expires_on < CURDATE() AND NOT sus_expires_on IS NULL, 1, 0) AS expired, 
				zzzzsys_user_id AS user_id, sus_login_name AS login_name, sus_name AS user_name
				FROM zzzzsys_user JOIN zzzzsys_access ON zzzzsys_access_id = sus_zzzzsys_access_id 
				WHERE sus_login_name = ? AND sus_login_password = ?
			";

	$rs = nuRunQuery($sql, array(
		$_POST['nuSTATE']['username'],
		md5($_POST['nuSTATE']['password'])
	));

	nuLog('nuCheckUserLoginRequest: username '. $_POST['nuSTATE']['username']);
	nuLog('nuCheckUserLoginRequest: password '. $_POST['nuSTATE']['password']);
	
	$oneRow = db_num_rows($rs) == 1;

	if ($oneRow) {
		$r = db_fetch_object($rs);
		$result = $r->expired == "1" ? "-1" : "1";
	} else {
		$result = "0";
	}

	return array('result' => $result, 'user_id' => ($oneRow ? $r->user_id : ''), 'login_name' => ($oneRow ? $r->login_name : ''), 'user_name' => ($oneRow ? $r->user_name : ''));

}