<?php
require_once("config.php");
require_once("fg.php");

function existUser($conn, $user){
	$sql = "select user from users where user=\"$user\"";
	$res = mysqli_query($conn, $sql);	
	$row = mysqli_fetch_assoc($res);
	if($row['user'] == $user){
		return true;
	} else {
		return false;	
	}
}

function authUser($conn, $data){
	$cryptedPass = scrypt($data['pass']);
	$sql = "select user from users where pass=\"$cryptedPass\"";
	$res = mysqli_query($conn, $sql);	
	if(mysqli_num_rows($res) > 0){
		return true;
	} else {
		return false;	
	}
}

function connect(){
	global $db;	
	$conn = mysqli_connect($db["host"], $db["user"], 
		$db["pass"], $db["name"]);		
	mysqli_set_charset($conn, $db["charset"]);	
	if(mysqli_connect_errno()){
		slog("Nem tudok kapcsolódni az adatbázishoz!");
		die("Nem tudok kapcsolódni az adatbázishoz!" . mysql_error());
	}	
	return $conn;
}

function addUser($conn, $data){
	$cryptedPass = scrypt($data['pass']);
	$sql = "insert into users (fullname, user, pass) 
	values (\"{$data['fullname']}\", \"{$data['user']}\", \"$cryptedPass\")";
	$res = mysqli_query($conn, $sql);
	//slog($res);
	if($res == "1"){
		return true;
	} else {
		return false;
	}
}

function close($conn){
	mysqli_close($conn);
}