<?php require_once(realpath(dirname(__FILE__)).'/config.php'); require_once(PATH_PHP.'database.php'); require_once(PATH_PHP.'security.php'); $mysqli = $GLOBALS['mysqli']; function addUser($username,$password,$email){ global $mysqli; $salt = $mysqli->escape_string(salt()); $email = $mysqli->escape_string($email); $username = $mysqli->escape_string($username); $hash = $mysqli->escape_string(saltedHash($password,$salt)); return query("INSERT INTO `users` (email,name,password,salt) VALUES ('%s','%s','%s','%s')",Array($email,$username,$hash,$salt)); } function isUser($name){ if(query("SELECT id FROM `users` WHERE name='%s'",Array($name))){ return true; }else{ return false; } } function userId($name){ if($user = query("SELECT id FROM `users` WHERE name='%s'",Array($name))){ $user = $user->fetch_assoc(); return $user['id']; }else{ return false; } } function userObj($id){ if(is_string($id)){ $id = userId($id); } if($result = query("SELECT * FROM `users` WHERE id='%d'",Array($id))){ return $result->fetch_assoc(); }else{ return false; } } ?>