</title> </head> <body> <div id="header"> <div id="banner"> <a href="http://xcache.lighttpd.net/" rel="external"><img src="../common/xcache.png" id="logo" alt="XCache logo" width="175" height="51" /> <?php echo $xcache_version; ?> - <?php echo ucfirst($GLOBALS['module']); ?> </a> </div> <div id="nav"> <div id="mainnav"> <?php echo mainnav(); ?> </div> <div id="subnav" class="switcher"> <?php echo subnav(); ?> </div> </div> </div> <div id="headerbase"> </div> <div id="main">
#include_once INCLUDESPATH . 'easyparliament/people.php';
$this_page = 'admin_mpurls';
$db = new ParlDB();
$scriptpath = '../../../scripts';
$PAGE->page_start();
$PAGE->stripe_start();
$out = '';
if (get_http_var('editperson') && get_http_var('action') === 'SaveURL') {
$out = update_url();
}
if (get_http_var('editperson')) {
$out .= edit_member_form();
} else {
$out .= list_members();
}
$subnav = subnav();
print '<div id="adminbody">';
print $subnav;
print $out;
print '</div>';
function edit_member_form()
{
global $db;
$personid = get_http_var('editperson');
# XXX This is stupid, it fetches all memberships and then displays the last
$query = "SELECT member.person_id, house, title, given_name, family_name, lordofname, constituency, data_value\n AS mp_website\n FROM person_names pn, member\n LEFT JOIN personinfo ON member.person_id = personinfo.person_id AND data_key = 'mp_website'\n WHERE member.person_id = :person_id\n AND member.person_id = pn.person_id AND pn.type='name'\n AND pn.end_date = (SELECT MAX(end_date) FROM person_names WHERE person_id=:person_id AND type='name')";
$q = $db->query($query, array(':person_id' => $personid));
for ($row = 0; $row < $q->rows(); $row++) {
$name = member_full_name($q->field($row, 'house'), $q->field($row, 'title'), $q->field($row, 'given_name'), $q->field($row, 'family_name'), $q->field($row, 'lordofname'));
$out = "<h3>Edit person: {$name}</h3>\n";
$out .= '<form action="websites.php?editperson=' . $q->field($row, 'person_id') . '" method="post">';
