$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]);
