Manage People

'; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-add-button-form'); $output .= ' Student or Alum Faculty Staff

'; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-search-button-form'); $output .= '

'; if($wpdb->blogid != 45) { $output .= "

People Waiting To Be Approved

"; $output .= "

Only fifty (50) people are shown. Approve or delete these and more will be shown.

"; $sql = "SELECT * FROM " . $table_name . " WHERE approved = 'N' ORDER BY gradYear DESC, lname ASC LIMIT 50"; $approvals = $wpdb->get_results($sql); if($approvals) { $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; foreach($approvals as $approve) { $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ' '; $output .= ' '; $output .= ""; } $output .= '

First Name	Last Name	Type	Major	Graduation Year
" . stripslashes($approve->fname) . "	" . stripslashes($approve->lname) . "	" . stripslashes($approve->type) . "	" . stripslashes($approve->major) . "	" . stripslashes($approve->gradYear) . "	'; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-approve-button-form'); $output .= '	'; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-delete-button-form'); $output .= '

'; } else { $output .= "

No approvals required

"; } } $sql = "SELECT * FROM " . $table_name . " WHERE approved = 'Y' ORDER BY gradYear DESC, lname ASC LIMIT 50"; $results = $wpdb->get_results($sql); $output .= "

People In Your Database

"; $output .= "

Only fifty (50) people are shown. Use the search bar to find more.

"; if($results) { if($wpdb->blogid == "45") { $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; foreach($results as $person) { $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ''; $output .= ""; } $output .= '

First Name	Last Name	Telephone	Location
" . stripslashes($person->fname) . "	" . stripslashes($person->lname) . "	" . stripslashes($person->telephone) . "	" . stripslashes($person->office) . "	'; $output .= ' '; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-edit'); if( $person->type == "Faculty" ) $editType = 'faculty'; else if( $person->type == "staff" ) $editType = 'staff'; else $editType = 'student'; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ' '; $output .= '

'; } else { $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; foreach($results as $person) { $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ''; $output .= ""; } $output .= '

First Name	Last Name	Type	Major	Graduation Year
" . stripslashes($person->fname) . "	" . stripslashes($person->lname) . "	" . stripslashes($person->type) . "	" . stripslashes($person->major) . "	" . stripslashes($person->gradYear) . "	'; $output .= ' '; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-edit'); if( $person->type == "Faculty" ) $editType = 'faculty'; else if( $person->type == "staff" ) $editType = 'staff'; else $editType = 'student'; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ' '; $output .= '

'; } } else { $output .= "

There are no people in your database.

"; } $output .= '

Add Faculty

'; $output .= '' . trim($temp[$x]) . ''; } $output .= ''; } $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= '

Your Graduation Year:
Your E-Mail Address:
Your Web site URL:
A URL To Your Photograph*:
Anything else you would like to share with other alumni?
Would you like to share your information with other alumni?		Yes No

*Please upload your photograph to Flickr or another image storage Web site. You will be given a URL from that Web site to use here.

'; $output .= '

Add Staff

'; $output .= 'prefix . "people"; if(!$wpdb->insert($table_name, $array_about_person)) // make sure we inserted into the database. return "The person was not inserted in the database. Please contact your support professional."; else return "The person was successfully inserted in the database."; } function delete_person($id) { global $wpdb; $table_name = $wpdb->prefix . "people"; $sql = "DELETE FROM " . $table_name . " WHERE id = " . $id; if(!$wpdb->query($sql)) return "Could not delete the person selected."; else return "Selected person has been deleted from the database."; } function update_person($array_about_person, $the_id) { global $wpdb; $table_name = $wpdb->prefix . "people"; if(!$wpdb->update($table_name, $array_about_person, $the_id)) return "The person was not updated in the database. Please contact your support professional."; else return "The person was successfully update in the database."; } function edit_person($personID, $personType) { global $wpdb; $table_name = $wpdb->prefix . "people"; $sql = "SELECT * FROM " . $table_name . " WHERE id = " . $personID; $result = $wpdb->get_row($sql); $output = ''; if( $personType == "faculty") { $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ' '; $output .= ''; $output .= ''; $output .= ''; $output .= '

First Name:
Last Name:
A URL To Your Photograph*:
Your E-Mail Address:
Your Web site URL:
Office Telephone Number:
Office Building and Room Number:
Your Degrees (Limit 75 Words):		' . $result->major . '
Keywords About You and Your Research (separate each keyword with a comma):
Write A Paragraph About Yourself (Limit 150 Words):		' . stripslashes($result->about) . '
Write A Paragraph About Your Research Areas (Limit 150 Words):		' . stripslashes($result->research) . '

*Please upload your photograph to Flickr or another image storage Web site. You will be given a URL from that Web site to use here.

'; $output .= ''; $output .= '

Add Person

'; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-update'); $output .= ''; $output .= ''; $output .= ''; $aSelect = ''; $uSelect = ''; $gSelect = ''; if($result->type == "Alum") { $aSelect = "SELECTED"; } else if($result->type == "Undergraduate Student") { $uSelect = "SELECTED"; } else if($result->type == "Graduate Student") { $gSelect = "SELECTED"; } $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= '

First Name:
Last Name:
Are you:		An Alumnus An Undergraduate Student A Graduate Student
Your Major:		'; $peopleManagerOpts = unserialize(get_option('people-manager-options')); $allowedMajors = $peopleManagerOpts['allowedMajors']; if(empty($allowedMajors)) { $output .= ''; } else { $temp = explode(',', $allowedMajors); $output .= ''; $output .= ''; for($x = 0; $x < count($temp); $x++) { if($result->major == trim($temp[$x])) $output .= '' . trim($temp[$x]) . ''; else $output .= '' . trim($temp[$x]) . ''; } $output .= ''; } $output .= '
Your Graduation Year:
Your E-Mail Address:
Your Web site URL:
A URL To Your Photograph*:
Anything else you would like to share with other alumni?		' . stripslashes($result->about) . '
Would you like to share your information with other alumni?		'; if( $result->visible == "Y" ) { $output .= 'Yes'; $output .= 'No'; } else if( $result->visible == "N" ) { $output .= 'Yes'; $output .= 'No'; } $output .= '

*Please upload your photograph to Flickr or another image storage Web site. You will be given a URL from that Web site to use here.

'; $output .= ''; $output .= '

Edit Staff

'; // add a nonce for security if( function_exists('wp_nonce_field') ) wp_nonce_field('people-manager-action-update'); $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= '

First Name:
Last Name:
A URL To Your Photograph*:
Your E-Mail Address:
Your Web site URL:
Office Telephone Number:
Office Building and Room Number:
Write A Paragraph About Yourself (Limit 150 Words):		' . stripslashes($result->about) . '

*Please upload your photograph to Flickr or another image storage Web site. You will be given a URL from that Web site to use here.

'; $output .= ''; $output .= '