"; } }//END FOR LOOP echo"

"; if ($_SESSION["ALPHA"] == ""){ echo" Alpha: Password: "; } else{ echo" Welcome A$_SESSION[ALPHA] [ Alumni Info ] [ Logout ] "; } echo"

> NOT REGISTERED? > TROUBLE LOGGING IN? > FORGET YOUR PASSWORD?

"; } if ($tbldat[25] == "Y"){ echo" "; } if ($tbldat[61] == "Y"){ echo" "; } if ($tbldat[20] == "Y"){ echo" "; if ($tbldat[19] != "0" AND $tbldat[19] != ""){ $query_country = "SELECT country_name FROM countries WHERE country_id = '$tbldat[19]'"; $res_country = mysql_query($query_country); $num_country = mysql_numrows($res_country); $records_country[0] = array("country_name"); for ($i_country=0;$i_country<$num_country;$i_country++) { $rec_country = array(mysql_result($res_country,$i_country,"country_name") ); $records_country[$i_country+1] = $rec_country; } //END FOR LOOP for ($row_country=1;$row_country<2;$row_country++) { $tbldat_country = $records_country[$row_country]; echo""; } } if ($tbldat[19] == "0" OR $tbldat[19] == ""){ echo""; } echo" "; } if ($tbldat[44] == "Y"){ echo" "; if ($tbldat[42] == "Y"){ echo" "; } echo" "; if ($tbldat[40] != "0" AND $tbldat[40] != ""){ $query_country = "SELECT country_name FROM countries WHERE country_id = '$tbldat[40]'"; $res_country = mysql_query($query_country); $num_country = mysql_numrows($res_country); $records_country[0] = array("country_name"); for ($i_country=0;$i_country<$num_country;$i_country++) { $rec_country = array(mysql_result($res_country,$i_country,"country_name") ); $records_country[$i_country+1] = $rec_country; } //END FOR LOOP for ($row_country=1;$row_country<2;$row_country++) { $tbldat_country = $records_country[$row_country]; echo""; } } if ($tbldat[40] == "0" OR $tbldat[40] == ""){ echo""; } echo" "; } if ($tbldat[58] == "Y"){ echo" "; } echo" "; $query = "SELECT * FROM brothers, big_brothers, addresses, phone_numbers, email_addresses, employers, degrees, im_names, comments WHERE brothers.brother_id = '$brother_id' AND big_brothers.brother_id = '$brother_id' AND addresses.brother_id = '$brother_id' AND phone_numbers.brother_id = '$brother_id' AND email_addresses.brother_id = '$brother_id' AND employers.brother_id = '$brother_id' AND degrees.brother_id = '$brother_id' AND im_names.brother_id = '$brother_id' AND comments.brother_id = '$brother_id'"; $res = mysql_query($query); $num = mysql_numrows($res); $records[0] = array("brother_tx_num","brother_prefix","brother_first_name","brother_nickname","brother_middle_name","brother_last_name","brother_suffix","birth_date","death_date","initiation_date","brother_url","last_updated","big_brother_id","street_1","street_2","city","state_region","region","postal_code","country_id","addresses_public","deleted","addresses_updated","home_number","cell_number","phone_public","phone_updated","email_address","email_address_2","email_public","email_updated","employer","employer_url","title","business_street_1","business_street_2","business_city","business_state_region","business_region","business_postal_code","business_country_id","business_phone","retired","retirement_date","employers_public","employers_updated","degree_1","major_1","school_1","year_1","degree_2","major_2","school_2","year_2","degree_3","major_3","University_3","year_3","degrees_public","aim","yahoo","im_public","spouse","comments","biography","date_posted"); for ($i=0;$i<$num;$i++) { $rec = array( mysql_result($res,$i,"brother_tx_num"), // alpha number mysql_result($res,$i,"brother_prefix"), // first prefix mysql_result($res,$i,"brother_first_name"), // first name mysql_result($res,$i,"brother_nickname"), // first name mysql_result($res,$i,"brother_middle_name"), // middle name mysql_result($res,$i,"brother_last_name"), // last name mysql_result($res,$i,"brother_suffix"), // suffix mysql_result($res,$i,"birth_date"), // birth date mysql_result($res,$i,"death_date"), // death date mysql_result($res,$i,"initiation_date"), // initiation date mysql_result($res,$i,"brother_url"), // url mysql_result($res,$i,"last_updated"), // last updated mysql_result($res,$i,"big_brother_id"), // big brother mysql_result($res,$i,"street_1"), // home address line 1 mysql_result($res,$i,"street_2"), // home address line 2 mysql_result($res,$i,"city"), // city mysql_result($res,$i,"state_region"), // state mysql_result($res,$i,"region"), // region mysql_result($res,$i,"postal_code"), // postal code mysql_result($res,$i,"country_id"), // country mysql_result($res,$i,"addresses_public"), // street public mysql_result($res,$i,"deleted"), // brother deleted mysql_result($res,$i,"addresses_updated"), // address last updated mysql_result($res,$i,"home_number"), // home phone mysql_result($res,$i,"cell_number"), // cell phone mysql_result($res,$i,"phone_public"), // phone public mysql_result($res,$i,"phone_updated"), // phone last updated mysql_result($res,$i,"email_address"), // primary email mysql_result($res,$i,"email_address_2"), // alternative email mysql_result($res,$i,"email_public"), // email public mysql_result($res,$i,"email_updated"), // email last updated mysql_result($res,$i,"employer"), // suffix mysql_result($res,$i,"employer_url"), // url mysql_result($res,$i,"title"), // last updated mysql_result($res,$i,"business_street_1"), // alpha number mysql_result($res,$i,"business_street_2"), // first name mysql_result($res,$i,"business_city"), // first name mysql_result($res,$i,"business_state_region"), // middle name mysql_result($res,$i,"business_region"), // region mysql_result($res,$i,"business_postal_code"), // last name mysql_result($res,$i,"business_country_id"), // country id mysql_result($res,$i,"business_phone"), // last name mysql_result($res,$i,"retired"), // retired mysql_result($res,$i,"retirement_date"), // retirement date mysql_result($res,$i,"employers_public"), // last updated mysql_result($res,$i,"employers_updated"), // last updated mysql_result($res,$i,"degree_1"), // last updated mysql_result($res,$i,"major_1"), // alpha number mysql_result($res,$i,"school_1"), // first name mysql_result($res,$i,"year_1"), // first name mysql_result($res,$i,"degree_2"), // middle name mysql_result($res,$i,"major_2"), // last name mysql_result($res,$i,"school_2"), // last name mysql_result($res,$i,"year_2"), // last updated mysql_result($res,$i,"degree_3"), // third degree type mysql_result($res,$i,"major_3"), // third major mysql_result($res,$i,"school_3"), // third University mysql_result($res,$i,"year_3"), // third degree year mysql_result($res,$i,"degrees_public"), // degrees public mysql_result($res,$i,"aim"), // middle name mysql_result($res,$i,"yahoo"), // last name mysql_result($res,$i,"im_public"), // im public mysql_result($res,$i,"spouse"), // last name mysql_result($res,$i,"comments"), // last updated mysql_result($res,$i,"biography"), // biography mysql_result($res,$i,"date_posted") // last updated ); $records[$i+1] = $rec; } //END FOR LOOP for ($row=1;$row<2;$row++) { $tbldat = $records[$row]; echo" "; if ($deceased == "Y"){ echo" BROTHER DATABASE To search for a Brother enter their name (partials allowed) or Alpha number below: **NEW** LOCATE BROTHERS BY ADDRESS Welcome A$_SESSION[ALPHA]     Change password     Update your information     Upload file or photo E-MAIL SITE ADMINISTRATOR FIRST << $brother_prev_tx_num $brother_prev_first_name $brother_prev_middle_name $brother_prev_last_name $brother_prev_suffix $brother_next_tx_num $brother_next_first_name $brother_next_middle_name $brother_next_last_name $brother_next_suffix >> LAST Brother Information "; } echo" "; $last_updated = strtotime($tbldat[11]); $addresses_updated = strtotime($tbldat[22]); $tx_status_updated_time = strtotime($tx_status_updated); $tx_mail_updated_time = strtotime($tx_mail_updated); $phone_updated = strtotime($tbldat[26]); $email_updated = strtotime($tbldat[30]); $employers_updated = strtotime($tbldat[45]); if (($last_updated >= $addresses_updated) && ($last_updated >= $tx_status_updated_time) && ($last_updated >= $tx_mail_updated_time) && ($last_updated >= $phone_updated) && ($last_updated >= $email_updated) && ($last_updated >= $employers_updated)) echo" "; else if (($addresses_updated >= $last_updated) && ($addresses_updated >= $tx_status_updated_time) && ($addresses_updated >= $tx_mail_updated_time) && ($addresses_updated >= $phone_updated) && ($addresses_updated >= $email_updated) && ($addresses_updated >= $employers_updated)) echo" "; else if (($tx_status_updated_time >= $last_updated) && ($tx_status_updated_time >= $addresses_updated) && ($tx_status_updated_time >= $tx_mail_updated_time) && ($tx_status_updated_time >= $phone_updated) && ($tx_status_updated_time >= $email_updated) && ($tx_status_updated_time >= $employers_updated)) echo" "; else if (($tx_mail_updated_time >= $last_updated) && ($tx_mail_updated_time >= $addresses_updated) && ($tx_mail_updated_time >= $tx_status_updated_time) && ($tx_mail_updated_time >= $phone_updated) && ($tx_mail_updated_time >= $email_updated) && ($tx_mail_updated_time >= $employers_updated)) echo" "; else if (($phone_updated >= $last_updated) && ($phone_updated >= $addresses_updated) && ($phone_updated >= $tx_status_updated_time) && ($phone_updated >= $tx_mail_updated_time) && ($phone_updated >= $email_updated) && ($phone_updated >= $employers_updated)) echo" "; else if (($email_updated >= $last_updated) && ($email_updated >= $addresses_updated) && ($email_updated >= $tx_status_updated_time) && ($email_updated >= $tx_mail_updated_time) && ($email_updated >= $phone_updated) && ($email_updated >= $employers_updated)) echo" "; else if (($employers_updated >= $last_updated) && ($employers_updated >= $addresses_updated) && ($employers_updated >= $tx_status_updated_time) && ($employers_updated >= $tx_mail_updated_time) && ($employers_updated >= $phone_updated) && ($employers_updated >= $email_updated)) echo" "; echo" "; if ($suspended == "YR"){ echo" Last Updated: $tbldat[11] Last Updated: $tbldat[22] Last Updated: $tx_status_updated Last Updated: $tx_mail_updated Last Updated: $tbldat[26] Last Updated: $tbldat[30] Last Updated: $tbldat[45] Alpha: $tbldat[0]"; if ($o_tx_affil == "Y"){ $query_affil = "SELECT * FROM tx_other_tx_affiliation WHERE brother_id = '$brother_id'"; $res_affil = mysql_query($query_affil); $num_affil = mysql_numrows($res_affil); $records_affil[0] = array("other_tx_affiliation"); for ($i_affil=0;$i_affil<$num_affil;$i_affil++) { $rec_affil = array( mysql_result($res_affil,$i_affil,"other_tx_affiliation") ); $records_affil[$i_affil+1] = $rec_affil; } //END FOR LOOP for ($row_affil=1;$row_affil, $tbldat_affil[0]"; } } if ($deceased == "Y"){echo" ";} if ($suspended == "YR"){echo" ";} //SEE IF BROTHER HAS 25 YEARS OF MEMBERSHIP $years_25_query = "SELECT DATE_ADD('$tbldat[9]', INTERVAL 25 YEAR)"; $years_25_result = mysql_query($years_25_query); $years_25 = mysql_result($years_25_result, 0, 0); // Free the result mysql_free_result($years_25_result); $years_25 = strtotime($years_25); if ($deceased != "Y" && ($tbldat[8] == 0000-00-00 || $tbldat[8] == "")){ if ($years_25 <= $date_unix){echo" ";} } else if ($deceased == "Y" && $tbldat[8] != 0000-00-00){ $death_date = strtotime($tbldat[8]); if (($years_25 <= $death_date) && ($years_25 <= $date_unix)){echo" ";} } //SEE IF BROTHER HAS 50 YEARS OF MEMBERSHIP $years_50_query = "SELECT DATE_ADD('$tbldat[9]', INTERVAL 50 YEAR)"; $years_50_result = mysql_query($years_50_query); $years_50 = mysql_result($years_50_result, 0, 0); // Free the result mysql_free_result($years_50_result); $years_50 = strtotime($years_50); if ($deceased != "Y" && ($tbldat[8] == 0000-00-00 || $tbldat[8] == "") && ($brother_id < 1304)){ if ($years_50 <= $date_unix){echo" ";} } else if ($deceased == "Y" && $tbldat[8] != 0000-00-00){ $death_date = strtotime($tbldat[8]); if (($years_50 <= $death_date) && ($years_50 <= $date_unix)){echo" ";} } if ($honorary == "Y"){echo" ";} if ($alumni_initiate == "Y"){echo" ";} if ($trans_to_RPI == "Y"){echo" ";} if ($order_unicorn == "Y"){echo" ";} if ($trustee == "Y"){echo" ";} if ($RPI_hall_fame == "Y"){echo" ";} if ($lost == "L"){echo" LOST";} echo" Name: $tbldat[1] $tbldat[2] $tbldat[4] $tbldat[5] $tbldat[6] Nickname: $tbldat[3] Initiation Date: $tbldat[9] Big Brother: "; $query_big = "SELECT brother_first_name, brother_last_name FROM brothers WHERE brother_id = '$tbldat[12]'"; $res_big = mysql_query($query_big); $num_big = mysql_numrows($res_big); $records_big[0] = array("brother_first_name, brother_last_name"); for ($i_big=0;$i_big<$num_big;$i_big++) { $rec_big = array(mysql_result($res_big,$i_big,"brother_first_name"), // alpha number mysql_result($res_big,$i_big,"brother_last_name"), // alpha number ); $records_big[$i_big+1] = $rec_big; } //END FOR LOOP for ($row_big=1;$row_bigA$tbldat[12] $tbldat_big[0] $tbldat_big[1] "; } } echo" Little Brothers: "; $query_little = "SELECT brother_id FROM big_brothers WHERE big_brother_id = '$brother_id'"; $res_little = mysql_query($query_little); $num_little = mysql_numrows($res_little); $records_little[0] = array("brother_id"); for ($i2=0;$i2<$num_little;$i2++) { $rec_little = array( mysql_result($res_little,$i2,"brother_id"), // alpha number ); $records_little[$i2+1] = $rec_little; } //END FOR LOOP for ($row2=1;$row2A$tbldat2[0] $tbldat3[0] $tbldat3[1] "; } } echo" "; exit; } if ($deceased == "Y"){ echo" Birth Date: $tbldat[7] Death Date: $tbldat[8] Biography $tbldat[64] "; return true; } if ($deceased != "Y" && ($suspended == "N" || $suspended == "Y")){ if ($tbldat[29] == "Y"){ echo" E-mail Addresses E-mail Address 1: $tbldat[27] E-mail Address 2: $tbldat[28] Phone Numbers Home Phone: $tbldat[23] Cell Phone: $tbldat[24] Instant Messengers AIM: $tbldat[59] Yahoo!: $tbldat[60] Current Home Address Address Line 1: $tbldat[13] Address Line 2: $tbldat[14] City: $tbldat[15] State: $tbldat[16] Region: $tbldat[17] Postal Code: $tbldat[18] Country: $tbldat_country[0] Country: United States Spouse: $tbldat[62] Employment Retired: Yes     Date: $tbldat[43] Employer: $tbldat[31] URL: $tbldat[32] Job Title: $tbldat[33] Address Line 1: $tbldat[34] Address Line 2: $tbldat[35] City: $tbldat[36] State: $tbldat[37] Region: $tbldat[38] Country: $tbldat_country[0] Country: United States Postal Code: $tbldat[39] Business Phone: $tbldat[41] Education Degree(s): $tbldat[49] / $tbldat[46] / $tbldat[47] / $tbldat[48] Second Degree: $tbldat[53] / $tbldat[50] / $tbldat[51] / $tbldat[52] Third Degree: $tbldat[57] / $tbldat[54] / $tbldat[55] / $tbldat[56] Updates Posted: $tbldat[65] $tbldat[63]

[ TOP ]

ALL CONTENT COPYRIGHT © 2006-07 THETA XI FRATERNITY.
SITE DESIGN BY VIGCRAFT ARTS; COPYRIGHT © 2006-07 VIGCRAFT ARTS, INC. "; ?>