<?PHP
//Filename : brother_home.php
//Description :  Homepage of all logins, displays links to all other sections
//Author :  darc, Marty
//Last modified :  2006.12.20

    include ('../includes/auth.php');
	include ('../includes/vars.php');
	
//edit for page title
	$title = "Local Brotherhood Services";
?>

<?php include ('../includes/header.php'); ?>
<center><img src="../images/ks_bs.gif" width="458" height="466"></center>
<br>
<h1 align="center" class="body"><font size="6">Welcome, <?php echo $_SESSION['current_user'];?>!</font></h1>
<p align="center" class="body"><?php
$sql = "SELECT * FROM messages INNER JOIN brothers ON brothers.pin_num = messages.from_pin WHERE to_pin = '$_SESSION[pin_num]' AND messages.read = \"false\"";
$result = mysql_query($sql,$connection) or die(mysql_error());
$num = mysql_num_rows($result);
if ($num > 0)
echo("You have $num new messages!");
?></p>
<br />
<?php include ('../includes/footer.php'); ?>