<?php echo list_members();
<?php include 'core/init.php'; protect_page(); //redirect to protected.php if not logged in include 'includes/overall/headder.php'; ?> <div id="topbar"> <div id="logo"><img src="images/icons/people.png" /></div> </div><!-- topbar ens here--> <div id="people"> <!----------------------------------------------------------> <div id="council-members"> <h1>MCA Council Members</h1><br /> <?php list_council(); ?> </div> <div id="members"> <h1>MCA Registered Users</h1><br /> <?php list_members(); ?> </div> </div><!--People ends here--> <?php include 'includes/overall/footer.php';
#include_once INCLUDESPATH . 'easyparliament/searchengine.php'; include_once INCLUDESPATH . 'easyparliament/member.php'; #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'));