$db->query($query); $rows = array(); while ($row = $db->fetch_row_assoc()) { // print "<p><pre>";print_r($previous);print "</pre></p>"; $row['previous'] = $previous[$row['division_date'] . "-" . $row['division_number'] . "-" . $row['house']]; array_unshift($rows, $row); $previous[$row['division_date'] . "-" . $row['division_number'] . "-" . $row['house']] = $row['text_body']; } // print "<p><pre>";print_r($previous);print "</pre></p>"; $prettyrow = 0; foreach ($rows as $row) { $prettyrow = pretty_row_start($prettyrow); print "<td valign=\"top\" width=\"16%\">"; if ($type == 'motion') { print "<a href=\"division.php?date=" . $row['division_date'] . "&number=" . $row['division_number'] . "&house=" . $row['house'] . "\">" . $row['house'] . " vote " . $row['division_date'] . "#" . $row['division_number'] . "</a>"; } else { print "wikiid" . $row['wiki_id']; } print "<p>Edited by " . pretty_user_name($db, html_scrub($row['user_name'])); print "<p>on " . $row['edit_date'] . "\n"; print "</td>"; $marked_text_diff = format_linediff(extract_motion_text_from_wiki_text($row['previous']), extract_motion_text_from_wiki_text($row['text_body']), true); $marked_title_diff = format_linediff(extract_title_from_wiki_text($row['previous']), extract_title_from_wiki_text($row['text_body']), false); print "<td>" . "<b>" . $marked_title_diff . "</b><br>" . $marked_text_diff . "</td>"; print "</td></tr>"; } print "</table>\n"; ?> <?php pw_footer();
$newsletter = ""; } print '<P><span class="ptitle">User name:</span> ' . $user_name . ' <br><span class="ptitle">Real name:</span> ' . user_getrealname() . ' <br><span class="ptitle">Email:</span> ' . user_getemail() . ' (<a href="changeemail.php">change email</a>) <br><span class="ptitle">Password:</span> (<a href="changepass.php">change password</a>) <FORM ACTION="' . $PHP_SELF . '" METHOD="POST"> <h2>Newsletter subscription</h2> <INPUT TYPE="checkbox" NAME="newsletter" ' . $newsletter . '>Email newsletter (at most once a month) <INPUT TYPE="SUBMIT" NAME="submit" VALUE="Update"> </FORM> <P>'; print '<h2>Forum profile</h2>'; print '<p>'; print pretty_user_name($db, $user_name, 'View your forum profile, including posts you\'ve made'); print "<h2>Policies which you made</h2>"; $query = "select dream_id, name, description, private from pw_dyn_dreammp where user_id = '" . user_getid() . "' order by private, name"; $db->query($query); $rowarray = $db->fetch_rows_assoc(); foreach ($rowarray as $row) { print '<br><a href="../policy.php?id=' . $row['dream_id'] . '">' . html_scrub($row['name']) . "</a>\n"; if ($row['private'] == 0) { print " (public)"; } if ($row['private'] == 1) { print " (legacy Dream MP)"; } if ($row['private'] == 2) { print " (provisional)"; }