$division_link = "division.php?date=" . $params[0] . "&number=" . $params[1] . "&house=" . $params[2]; print "<p><a href=\"{$division_link}\">View division</a> | <a href=\"{$edit_link}\">Edit description</a>"; } else { print "<p>Recent changes made to description and title of any division."; } print "<table class=\"edits\">\n"; print "<tr class=\"headings\">\n <td>Change</td>\n <td>Division Description Changes</td>\n </tr>"; // Find initial values $query = "select division_date, division_number, house, \n motion, division_name from pw_division "; if ($params) { $query .= "where " . get_wiki_where_fragment($type, $params); } $db->query($query); $previous = array(); while ($row = $db->fetch_row_assoc()) { $previous[$row['division_date'] . "-" . $row['division_number'] . "-" . $row['house']] = add_motion_missing_wrappers($row['motion'], $row['division_name']); } // And loop through later ones $query = "select " . get_wiki_table($type) . ".*, user_name, pw_dyn_user.user_id as user_id, edit_date \n from " . get_wiki_table($type) . ", pw_dyn_user\n where " . get_wiki_table($type) . ".user_id = pw_dyn_user.user_id "; if ($params) { $query .= " and " . get_wiki_where_fragment($type, $params); } $query .= "order by edit_date"; $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']; }
$db->query("select * from pw_division where division_date = '{$params['0']}' \n and division_number = '{$params['1']}' and house = '{$params['2']}'"); $division_details = $db->fetch_row_assoc(); $prettydate = date("j M Y", strtotime($params[0])); $title = "Edit division description - " . $division_details['division_name'] . " - {$prettydate} - Division No. {$params['1']}"; $debate_gid = str_replace("uk.org.publicwhip/debate/", "", $division_details['debate_gid']); $debate_gid = str_replace("uk.org.publicwhip/lords/", "", $debate_gid); if ($type == "motion") { $motion_data = get_wiki_current_value($db, "motion", array($params[0], $params[1], $params[2])); $prev_name = extract_title_from_wiki_text($motion_data['text_body']); $prev_description = extract_motion_text_from_wiki_text($motion_data['text_body']); $prev_description_editable = extract_motion_text_from_wiki_text_for_edit($motion_data['text_body']); } if ($submit && !$just_logged_in) { if ($submit == "Save") { if ($type == 'motion') { $newtext = add_motion_missing_wrappers($newdescription, $newtitle); $curr_name = extract_title_from_wiki_text($newtext); $curr_description = extract_motion_text_from_wiki_text($newtext); $name_diff = format_linediff(trim($prev_name), trim($curr_name), false); # always have link $description_diff = format_linediff(trim($prev_description), trim($curr_description), true); # forum escapes <, > and the like already $description_diff = html_entity_decode(html_entity_decode($description_diff, ENT_QUOTES), ENT_QUOTES); $name_diff = html_entity_decode(html_entity_decode($name_diff, ENT_QUOTES), ENT_QUOTES); global $domain_name; divisionvote_post_forum_action($db, $params[0], $params[1], $params[2], "Changed title and/or description of division.\n\n[b]Title:[/b] " . "[url=http://{$domain_name}/division.php?date=" . $division_details['division_date'] . "&number=" . $division_details['division_number'] . "&house=" . $division_details['house'] . "]" . $name_diff . "[/url]\n[b]Description:[/b] " . $description_diff); } $db->query_errcheck("insert into pw_dyn_wiki_motion\n (division_date, division_number, house, text_body, user_id, edit_date) values\n ('{$params['0']}', '{$params['1']}', '{$params['2']}', '" . mysql_real_escape_string($newtext) . "', '" . user_getid() . "', now())"); audit_log("Edited {$type} wiki text {$params['0']} {$params['1']} {$params['2']}"); if ($type == 'motion') { notify_motion_updated($db, $params[0], $params[1], $params[2]);