Error retrieving National Users from database.
". "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) {
session_register("userid");
session_register("email");
session_register("firstname");
session_register("lastname");
session_register("homestate");
session_register("homestateproper");
session_register("pageset");
$pageset = "state";
$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("
Error retrieving State Users from database.
". "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) {
session_register("userid");
session_register("email");
session_register("firstname");
session_register("lastname");
session_register("homestate");
session_register("homestateproper");
session_register("homedistrictid");
session_register("homedistrictname");
session_register("pageset");
$pageset = "district";
// 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("
Error retrieving District Users from database.
". "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) {
session_register("userid");
session_register("email");
session_register("firstname");
session_register("lastname");
session_register("homestate");
session_register("homestateproper");
session_register("homedistrictid");
session_register("homedistrictname");
session_register("homeschoolid");
session_register("homeschoolname");
session_register("pageset");
$pageset = "school";
$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("
Error retrieving School Users from database.
". "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) {
session_register("userid");
session_register("email");
session_register("firstname");
session_register("lastname");
session_register("homestate");
session_register("homestateproper");
session_register("homedistrictid");
session_register("homedistrictname");
session_register("homeschoolid");
session_register("homeschoolname");
session_register("pageset");
$pageset = "schooluser";
$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("
Error retrieving School Users from database.
". "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;
}
*/
?>
Error retrieving State from database.
". "Error: " . mysql_error()); exit(); }
$num_states = mysql_num_rows($sql_state);
if ($num_states == 0) { $homestate = ""; }
while ($results_state = mysql_fetch_array($sql_state)) {
$state = $results_state["State"];
$state_leader = $results_state["Leader"];
$stateid = $results_state["StateID"];
//echo("$state - $state_leader - $stateid
");
// If they're a leader, add to this array
if ($state_leader == 0) { array_push($stateidArray, $stateid); array_push($stateArray, $state);}
if ($state_leader == 1) { array_push($stateidleaderArray, $stateid); array_push($stateidArray, $stateid); array_push($stateArray, $state); array_push($stateleaderArray, $state);}
array_push($stateidmemberArray, $stateid);
array_push($statememberArray, $state);
$homestate = $results_state["State"];
}
/* while (list($key,$statename) = each($stateArray)) {
include("lookup_statename.inc");
echo "$statename";
// Lookup to see if they're a leader and add an * if they are
if (in_array($statename, $stateleaderArray)) { echo "*"; }
echo "
";
}
*/
session_register("districtArray");
session_register("districtleaderArray");
session_register("districtmemberArray");
// Pull up Home Districts(s)
$districtArray = array();
$districtleaderArray = array();
$districtmemberArray = array();
$sql_district = mysql_query("SELECT DistrictID, Leader FROM DistrictsUsers WHERE UserID = $userid");
if (!$sql_district) { echo("
Error retrieving District from database.
". "Error: " . mysql_error()); exit(); }
while ($results_district = mysql_fetch_array($sql_district)) {
$list_homedistrictid = $results_district["DistrictID"];
$district_leader = $results_district["Leader"];
// If they're a leader, add to this array
if ($district_leader == 0) { array_push($districtArray, $list_homedistrictid); }
if ($district_leader == 1) { array_push($districtleaderArray, $list_homedistrictid); array_push($districtArray, $list_homedistrictid);}
array_push($districtmemberArray, $list_homedistrictid);
}
/* while (list($key,$leaid) = each($districtArray)) {
include("lookup_districtname.inc");
echo "$districtname";
// Lookup to see if they're a leader and add an * if they are
if (in_array($list_homedistrictid, $districtleaderArray)) { echo "*"; }
echo "
";
}
*/
session_register("schoolArray");
session_register("schoolleaderArray");
session_register("schoolmemberArray");
// Pull up Home Schools(s)
$schoolArray = array();
$schoolleaderArray = array();
$schoolmemberArray = array();
$sql_school = mysql_query("SELECT SchoolID, Leader FROM SchoolsUsers WHERE UserID = $userid");
if (!$sql_school) { echo("
Error retrieving School from database.
". "Error: " . mysql_error()); exit(); }
while ($results_school = mysql_fetch_array($sql_school)) {
$list_homeschoolid = $results_school["SchoolID"];
$school_leader = $results_school["Leader"];
// If they're a leader, add to this array
if ($school_leader == 0) { array_push($schoolArray, $list_homeschoolid); }
if ($school_leader == 1) { array_push($schoolleaderArray, $list_homeschoolid); array_push($schoolArray, $list_homeschoolid);}
array_push($schoolmemberArray, $list_homeschoolid);
}
/* while (list($key,$schid) = each($schoolArray)) {
include("lookup_schoolname.inc");
echo "$schoolname";
// Lookup to see if they're a leader and add an * if they are
if (in_array($list_homeschoolid, $schoolleaderArray)) { echo "*";}
echo "
";
}
*/
session_register("groupArray");
session_register("groupleaderArray");
session_register("groupmemberArray");
// Pull up Groups
$groupArray = array();
$groupleaderArray = array();
$groupmemberArray = array();
$sql_group = mysql_query("SELECT GroupID, Leader FROM GroupsUsers WHERE UserID = $userid");
if (!$sql_group) { echo("
Error retrieving Groups from database.
". "Error: " . mysql_error()); exit(); }
while ($results_group = mysql_fetch_array($sql_group)) {
$list_groupid = $results_group["GroupID"];
$group_leader = $results_group["Leader"];
// If they're a leader, add to this array
if ($group_leader == 0) { array_push($groupArray, $list_groupid); }
if ($group_leader == 1) { array_push($groupleaderArray, $list_groupid); }
array_push($groupmemberArray, $list_groupid);
}
/* while (list($key,$gid) = each($groupArray)) {
include("lookup_groupname2.inc");
echo "$groupname";
// Lookup to see if they're a leader and add an * if they are
if (in_array($list_groupid, $groupleaderArray)) { echo "*"; }
echo "
";
}
*/
?>