// text fields $roundColumns = array(); foreach ($Round_for_round_id_ as $round) { $roundColumns[] = $round->user_column_name; $roundColumns[] = $round->time_column_name; } $roundColumns = implode(", ", $roundColumns); // cycle through all pages, creating rows as we go $res = mysql_query("SELECT image, state, {$roundColumns} FROM {$projectid} ORDER BY image ASC") or die(mysql_error()); while ($result = mysql_fetch_assoc($res)) { $page = $result["image"]; echo "<tr>"; echo "<td>" . recycle_window_link("displayimage.php?project={$projectid}&imagefile={$page}", $page, "pageView") . "</td>"; echo "<td>" . $result["state"] . "</td>"; // get the current round for the page $currentRound = get_Round_for_page_state($result["state"]); // foreach round print out the available info foreach ($Round_for_round_id_ as $round) { $roundID = $round->id; // the ' + 0' forces timesChecked to be numeric $timesChecked = @$wordcheck_usage[$page][$roundID] + 0; $lastProofer = $result[$round->user_column_name]; $timeProofed = $result[$round->time_column_name]; // determine if the page has been marked 'Done' in $round. // If one of the following is true, it's done: // * $round is prior to the page's current round, or // * $round is the page's current round and the page is in that round's done state. $pageIsDoneInRound = $currentRound->round_number > $round->round_number || $round->page_save_state == $result["state"]; if (!empty($lastProofer)) { $lastProoferLink = private_message_link($lastProofer); }
if (!count($_FILES)) { show_image_update_form($projectid, $image); $show_resolution_form = FALSE; } else { update_image($projectid, $image); } } if ($show_resolution_form) { show_resolution_form($projectid, $image, $state, $prev_round_num, $is_a_bad_page, $b_User, $b_Code); } } else { //Get variables passed from form $state = get_enumerated_param($_POST, 'state', null, $PAGE_STATES_IN_ORDER); //If the PM fixed the problem or stated the report was invalid update the database to reflect if ($resolution == "fixed" || $resolution == "invalid") { $round = get_Round_for_page_state($state); Page_eraseBadMark($projectid, $image, $round, $pguser); } //Redirect the user back to the project detail page. header("Location: {$code_url}/tools/project_manager/page_detail.php?project={$projectid}"); } #---------------------------------------------------------------------------- function show_resolution_form($projectid, $image, $state, $prev_round_num, $is_a_bad_page, $b_user, $b_code) { global $code_url, $PAGE_BADNESS_REASONS; if ($is_a_bad_page) { echo "<h2>" . _("Resolve bad page") . "</h2>"; echo "<p>" . _("This page has been marked bad by the following user.") . "</p>"; echo "<p>"; if (!empty($b_user)) { $contact_url = get_url_to_compose_message_to_user($b_user);