/application/system/account.php

<?

function add_user($firstname, $lastname, $email, $password)
{
	$sql = "insert into users (firstname, lastname, email, password) values('$firstname', '$lastname', '$email', '$password')";
	$result = mysql_query($sql);
}

function authenticate($email, $password)
{
	$sql = "select * from users where email='$email'";
	$result = mysql_query($sql);
	$row = mysql_fetch_array ($result);

	if ($row['email'] == $email)
	{
		// setup session variables
		$_SESSION['user_id'] = $row['id'];
		$_SESSION['name'] = $row['firstname'] . " " . $row['lastname'];
		$_SESSION['email'] = $row['email'];
		// redirect to home
		redirect('index.php?a=profile&id=' . $_SESSION['user_id']);
	}
	else
	{
		// destroy existing sessions
		// session_destroy();
		// redirect to failure
		redirect('index.php?a=login_error');
	}
}

function update_profile_img($id, $img1, $img2)
{
	$sql = "update users set profile_img='$img1', profile_img_thumb='$img2' where id=$id";
	$result = mysql_query($sql);	
}

function get_large_profile_img($id)
{
	$sql = "select profile_img from users where id=$id";
	$result = mysql_query($sql);
	$row = mysql_fetch_array ($result);	
	return "<img id=\"profile_pic\" src=\"images/profile/" . $id . "/" . $row['profile_img'] . "\">";
}

function get_name_by_id($id)
{
	$sql = "select * from users where id=$id";
	$results = mysql_query($sql);
	$row = mysql_fetch_array ( $results );
	return $row['firstname'] . " " . $row['lastname'];
}

function get_firstname_by_id($id)
{
	$sql = "select * from users where id=$id";
	$results = mysql_query($sql);
	$row = mysql_fetch_array ( $results );
	return $row['firstname'];
}

function get_small_profile_img($id)
{
	$sql = "select profile_img_thumb from users where id=$id";
	$result = mysql_query($sql);
	$row = mysql_fetch_array ($result);	
	$html .= "<div id=\"profile_pic_small_wrapper\"><img id=\"profile_pic_small\" src=\"images/profile/" . $id . "/" . $row['profile_img_thumb'] . "\">";
	$html .= "<img id=\"profile_matting_thumb\" src=\"images/thumb_matting.gif\" /></div>";
	return $html;
}

function get_namelink_by_id($id)
{
	$sql = "select * from users where id=$id";
	$results = mysql_query($sql);
	$row = mysql_fetch_array ( $results );
	return "<span class=\"post_message_person_link\"><a href=\"index.php?a=profile&id=$id\">" . $row['firstname'] . " " . $row['lastname'] . "</a></span>";
}

function find_friend($keyword)
{
	$sql = "select * from users where firstname like '%$keyword%' or lastname like '%$keyword%' or email like '%$keyword%'";
	$results = mysql_query($sql);
	while ($row=mysql_fetch_array($results))
	{
		$array[]=$row;
	}
	return $array;
}

// notification types:
// 1 - friend request

function request_friend($from,$to)
{
	$sql = "insert into notifications (from_id, to_id, notification_type) values($from, $to, 1)";
	$result = mysql_query($sql);
}

function get_notifications($id)
{
	$sql = "select * from notifications where to_id=$id";
	$results = mysql_query($sql);
	if (count($results) > 0)
	{
		while ($row=mysql_fetch_array($results))
		{
			$array[]=$row;
		}
		return $array;
	}
}

function update_status($id,$message)
{
	$sql = "update users set status='$message' where id=$id";
	$result = mysql_query($sql);
}

function update_settings($id,$fb_email,$fb_pass,$twitter_login, $twitter_pass)
{
	$sql = "update users set fb_login='$fb_email', fb_pass='$fb_pass', twitter_login='$twitter_login', twitter_pass='$twitter_pass' where id=$id";
	$result = mysql_query($sql);
}


function get_connector_credentials($id)
{
	$sql = "select fb_login, fb_pass, twitter_login, twitter_pass from users where id=$id";
	$result = mysql_query($sql);
	$row = mysql_fetch_array ($result);	
	return $row;
}

function get_status($id)
{
	$sql = "select status from users where id=$id";
	$results = mysql_query($sql);
	$row = mysql_fetch_array ( $results );
	return $row['status'];
}



?>