<?php

// National Leader
if ($privid == 6) {


		$sql = mysql_query("SELECT Users.UserID, Email, UsersPrivs.PrivID, FirstName, LastName, State, Username, Password FROM Users INNER JOIN UsersPrivs ON Users.UserID = UsersPrivs.UserID WHERE Users.Username = '$username' AND Users.Password = '$password'");
		if (!$sql) { echo("<P>Error retrieving National Users from database.<BR>". "Error: " . mysql_error()); exit(); }

		$s_results = mysql_fetch_array($sql);
		$userid = $s_results["UserID"];
		$email = $s_results["Email"];
		$firstname = $s_results["FirstName"];
		$lastname = $s_results["LastName"];

}



// State Leader
if ($privid == 3) {



		$sql = mysql_query("SELECT Users.UserID, Email, UsersPrivs.PrivID, FirstName, LastName, State, Username, Password FROM Users INNER JOIN UsersPrivs ON Users.UserID = UsersPrivs.UserID WHERE Users.Username = '$username' AND Users.Password = '$password'");
		if (!$sql) { echo("<P>Error retrieving State Users from database.<BR>". "Error: " . mysql_error()); exit(); }

		$s_results = mysql_fetch_array($sql);
		$userid = $s_results["UserID"];
		$email = $s_results["Email"];
		$firstname = $s_results["FirstName"];
		$lastname = $s_results["LastName"];
		$homestate = $s_results["State"];

		$state = $homestate;
		include("lookup_stateproper.inc");
		$homestateproper = $stateproper;

}





// District Leader
if ($privid == 2) {



		// Pull up District Users
		$sql2 = mysql_query("SELECT Users.UserID, Email, FirstName, LastName, NCES_Districts.NAME, NCES_Districts.LSTATE, DistrictsUsers.DistrictID, UsersPrivs.PrivID, Username, Password FROM ((Users INNER JOIN UsersPrivs ON Users.UserID = UsersPrivs.UserID) INNER JOIN DistrictsUsers ON UsersPrivs.UserID = DistrictsUsers.UserID) INNER JOIN NCES_Districts ON DistrictsUsers.DistrictID = NCES_Districts.LEAID WHERE Users.Username = '$username' AND Users.Password = '$password'");
		//$sql2 = mysql_query("SELECT Users.UserID, FirstName, LastName, State FROM Users INNER JOIN UsersPrivs ON Users.UserID = UsersPrivs.UserID WHERE UsersPrivs.PrivID = $privid");
		if (!$sql2) { echo("<P>Error retrieving District Users from database.<BR>". "Error: " . mysql_error()); exit(); }

		$s_results = mysql_fetch_array($sql2);
		$userid = $s_results["UserID"];
		$email = $s_results["Email"];
		$firstname = $s_results["FirstName"];
		$lastname = $s_results["LastName"];
		$homestate = $s_results["LSTATE"];
		$homedistrictid = $s_results["DistrictID"];
		$homedistrictname = $s_results["NAME"];

		$state = $homestate;
		include("lookup_stateproper.inc");
		$homestateproper = $stateproper;
}








// School Leader
if ($privid == 1) {


		$sql1 = mysql_query("SELECT Users.UserID, Email, FirstName, LastName, NCES_Schools.LSTATE, SchoolsUsers.SchoolID, Username, Password, UsersPrivs.PrivID, NCES_Schools.LEAID, NCES_Schools.SCHNAME, NCES_Districts.NAME FROM (((Users INNER JOIN UsersPrivs ON Users.UserID = UsersPrivs.UserID) INNER JOIN SchoolsUsers ON UsersPrivs.UserID = SchoolsUsers.UserID) INNER JOIN NCES_Schools ON SchoolsUsers.SchoolID = NCES_Schools.NCESSCH) INNER JOIN NCES_Districts ON NCES_Schools.LEAID = NCES_Districts.LEAID WHERE Users.Username = '$username' AND Users.Password = '$password'");
		if (!$sql1) { echo("<P>Error retrieving School Users from database.<BR>". "Error: " . mysql_error()); exit(); }

		$s_results = mysql_fetch_array($sql1);
		$userid = $s_results["UserID"];
		$email = $s_results["Email"];
		$firstname = $s_results["FirstName"];
		$lastname = $s_results["LastName"];
		$homestate = $s_results["LSTATE"];
		$homeschoolid = $s_results["SchoolID"];
		$homeschoolname = $s_results["SCHNAME"];
		$homedistrictid = $s_results["LEAID"];
		$homedistrictname = $s_results["NAME"];

		$state = $homestate;
		include("lookup_stateproper.inc");
		$homestateproper = $stateproper;
}


// School User
if ($privid == 5) {


		$sql1 = mysql_query("SELECT Users.UserID, Email, FirstName, LastName, NCES_Schools.LSTATE, SchoolsUsers.SchoolID, Username, Password, UsersPrivs.PrivID, NCES_Schools.LEAID, NCES_Schools.SCHNAME, NCES_Districts.NAME FROM (((Users INNER JOIN UsersPrivs ON Users.UserID = UsersPrivs.UserID) INNER JOIN SchoolsUsers ON UsersPrivs.UserID = SchoolsUsers.UserID) INNER JOIN NCES_Schools ON SchoolsUsers.SchoolID = NCES_Schools.NCESSCH) INNER JOIN NCES_Districts ON NCES_Schools.LEAID = NCES_Districts.LEAID WHERE Users.Username = '$username' AND Users.Password = '$password'");
		if (!$sql1) { echo("<P>Error retrieving School Users from database.<BR>". "Error: " . mysql_error()); exit(); }

		$s_results = mysql_fetch_array($sql1);
		$userid = $s_results["UserID"];
		$email = $s_results["Email"];
		$firstname = $s_results["FirstName"];
		$lastname = $s_results["LastName"];
		$homestate = $s_results["LSTATE"];
		$homeschoolid = $s_results["SchoolID"];
		$homeschoolname = $s_results["SCHNAME"];
		$homedistrictid = $s_results["LEAID"];
		$homedistrictname = $s_results["NAME"];

		$state = $homestate;
		include("lookup_stateproper.inc");
		$homestateproper = $stateproper;
}
?>