<?php
function change_password($u_id, $password) {
	$u_id = (int) $u_id;
	$password = md5($password);
	
	mysql_query("UPDATE `vts_users` SET `u_password` = '$password' WHERE `u_id` = $u_id");
}

function register_user_ORIG($register_data){
	array_walk($register_data, 'array_sanitize');
	$register_data['password'] = md5($register_data['password']);
	
	$fields = '`' . implode('`, `', array_keys($register_data)) . '`';
	$data = '\'' . implode('\', \'', $register_data) . '\'';
	mysql_query("INSERT INTO `vts_users`($fields) VALUES ($data)");
	sendemail($register_data['email'], 'Activate your account', "Hello " . $register_data['u_fname'] .  ",\n\nYou need to activate your account, so use the link  below \n\n http://localhost/lr/activate.php?email=" . $register_data['$email'] . "$email_code=" . $register_data['email_code'] . "\n\n - AEE");
	}

function register_user($register_data){
	//array_walk($register_data, 'array_sanitize');
	$register_data['password'] = md5($register_data['password']);
	//$fields = '`' . implode('`, `', array_keys($register_data)) . '`';
	//$data = '\'' . implode('\', \'', $register_data) . '\'';
	mysql_query("INSERT INTO `vts_users` (`u_id`,`username`,`password`,`u_fname`,`u_lname`,`email`,`active`, `email_code`,`user_dealer`, `user_company`,`access_dept`) VALUES ()");
	sendemail($register_data['email'], 'Activate your account', "Hello " . $register_data['u_fname'] .  ",\n\nYou need to activate your account, so use the link  below \n\n http://localhost/lr/activate.php?email=" . $register_data['$email'] . "$email_code=" . $register_data['email_code'] . "\n\n - AEE");
	}
	
function user_count(){
return mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `active` = 1"), 0);
}

//get details of users information
function user_data($u_id){
	$data = array();
	$u_id =  (int)$u_id;
	
	$func_num_args = func_num_args(); 
	$func_get_args = func_get_args(); 

	if ($func_num_args > 1) {
		unset($func_get_args[0]);
		$fields = '`' . implode('` ,`', $func_get_args) . '`';
		$data = mysql_fetch_assoc(mysql_query("SELECT $fields FROM `vts_users` WHERE `u_id` = $u_id"));
		return $data;
	}
}

function logged_in() {
return (isset($_SESSION['u_id'])) ? true : false;
}
function user_exists($username) {
$username = sanitize($username);
return (mysql_result(mysql_query("SELECT COUNT(`u_id`) FROM `vts_users` WHERE `u_name` = '$username'"), 0) ==1) ? true : false;
}
function email_exists($email) {
$email = sanitize($email);
return (mysql_result(mysql_query("SELECT COUNT(`u_id`) FROM `vts_users` WHERE `email` = '$email'"), 0) ==1) ? true : false;
}
function user_active($username) {
$username = sanitize($username);
return (mysql_result(mysql_query("SELECT COUNT(`u_id`) FROM `vts_users` WHERE `u_name` = '$username' AND `u_status` = 1"), 0) ==1) ? true : false;
}
function user_banned($u_id) {
$u_id = sanitize($u_id);
return (mysql_result(mysql_query("SELECT COUNT(`u_id`) FROM `vts_users` WHERE `active` = '0' "), 0) ==1) ? true : false;
}

function u_id_from_username($username) {
$username = sanitize($username);
return mysql_result(mysql_query("SELECT `u_id` FROM `vts_users` WHERE `u_name` = '$username'"), 0, 'u_id');
print_r(u_id_from_username($username));
}
function login($username, $password) {
$u_id = u_id_from_username($username);
$username = sanitize($username);
$password = md5($password);
return (mysql_result(mysql_query("SELECT COUNT(`u_id`) FROM `vts_users` WHERE `u_name` = '$username' AND `u_password` = '$password'"), 0) == 1) ? $u_id : false;
}
?>