prefix."people"); echo "\n"; } function people_list_ajax() { global $wpdb; $result = mysql_query("SELECT * FROM ".$wpdb->prefix."people ORDER BY last_name"); echo "\n"; } function people_get_random_bio() { global $wpdb; $row = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS count FROM ".$wpdb->prefix."bios")); $count = $row[count]; $rid = rand(1,$count); people_get_bio_by_id($rid); } function people_get_bio_by_id($id) { global $wpdb; $result = mysql_fetch_array(mysql_query("SELECT id, uid, text FROM ".$wpdb->prefix."bios WHERE uid='$id'")); $presult = mysql_fetch_array(mysql_query("SELECT * FROM ".$wpdb->prefix."people WHERE id='$id'")); echo "

$presult[first_name] $presult[last_name]

\n"; $sections = explode("{more}",$result[text]); echo "
\n\t\n\t
$sections[0]"; if (count($sections) > 1) { echo "More"; echo "\n\t"; } echo "\n\t
\n
\n"; } function people_get_bio_by_slug($slug) { global $wpdb; $result = mysql_fetch_array(mysql_query("SELECT id FROM ".$wpdb->prefix."people WHERE slug='$slug'")); people_get_bio_by_id($result['id']); } function people_confirm_delete($id) { global $wpdb; $result = mysql_query("SELECT ".$wpdb->prefix."people.first_name AS first_name, ".$wpdb->prefix."people.last_name AS last_name, ".$wpdb->prefix."people.id AS id, ".$wpdb->prefix."people.slug AS slug, ".$wpdb->prefix."bios.id AS bid, ".$wpdb->prefix."bios.text AS text FROM ".$wpdb->prefix."people, ".$wpdb->prefix."bios WHERE ".$wpdb->prefix."people.id='$id' AND ".$wpdb->prefix."people.id=".$wpdb->prefix."bios.uid"); $row = mysql_fetch_array($result); echo "
\n"; echo ""; echo ""; echo "

Are you sure you want to delete $row[first_name] $row[last_name]?

\n"; echo "

Once you have deleted a profile it cannot be recovered

\n"; echo "
\n"; echo "
 
\n"; echo "

\n"; } ?>