<?php
require(&#039;connect.php&#039;);
session_start():

$error = mysql_error();

// check if a user is online, returns true or false.
function is_online($username) {

	// grab the value of the field logged_in
	$select_query = mysql_query("SELECT * FROM users WHERE username=&#039;$username&#039;");

	if ($select_query){
		while($entry = mysql_fetch_assoc($select_query)) {
			$logged_in = $entry[&#039;logged_in&#039;];
		}

		// return the number of rows from select_query
		return $logged_in;
	} else {
		die($error);
	}
}

function check_user($username){
	$check_query = mysql_query("SELECT * FROM users WHERE username=&#039;$username&#039;");
	$username_exists = mysql_num_rows($check_query);

	return $username_exists;
}

function check_email($email){
	$check_query = mysql_query("SELECT * FROM users WHERE email=&#039;$email&#039;");
	$username_exists = mysql_num_rows($check_query);

	return $email_exists;
}

function register_user($username, $pwd, $email, $fname, $lname, $town, $dob, $lvl, $about, $interests, $xp, $avatar) {
	// add the data to the database
	$add_to_db = mysql_query("INSERT INTO users values(&#039;&#039;,&#039;$username&#039;,&#039;$pwd&#039;,&#039;$email&#039;,&#039;$fname&#039;,&#039;$lname&#039;,&#039;$town&#039;,&#039;$dob&#039;,&#039;$lvl&#039;,&#039;$about&#039;,&#039;$interests&#039;,&#039;$xp&#039;,&#039;$avatar&#039;)");

	if (!$add_to_db) {
		die($error);
	} else {
		// return true or false
		return $add_to_db;
	}
}

function login($username, $pwd) {
	// encryption
	$hashedpwd = crypt(crypt(sha1(md5($pwd)),md5(sha1($pwd))), md5($pwd));

	// Query to select the username and password, and if it exists, log in
	$check_db_login_data = mysql_query("SELECT * FROM users WHERE username=&#039;$username&#039; AND password=&#039;$hashedpwd&#039;");



}


function generate_avatar_link($filename){

	// take the filename and add random numbers at the end.
	$scrambled_filename = $filename . mt_rand();

	// then MD5 it(for fun)
	$md5ed = md5($scrambled_filename);

	// then add the extension, making it a 36 char long filename.
	$newfilename = $md5ed + ".png";

	// then return it back from where it came!
	return $newfilename;
}







?>