goIfInvalid("../index.php"); $Me -> goIfNotChair('../index.php'); $Conf -> connect(); ?> header("Modify Paper #$paperId for $Conf->shortName") ?> errorMsg("You didn't specify a paper to modify."); exit; } // // Process any updates // if (IsSet($submit)) { if (!IsSet($title) || !IsSet($abstract) || !IsSet($authorInfo) ) { $Conf->errorMsg("One or more of the required fields is not set. " . "Please press BACK and correct this. "); } else { if (!IsSet($finalized)) { $finalized = 0; } if (!IsSet($withdrawn)) { $withdrawn = 0; } $title = addslashes($title); $abstract = addslashes($abstract); $authorInfo = addslashes($authorInfo); $authorsResponse = addslashes($authorsResponse); $query="UPDATE Paper SET " . "contactId='$contactId', " . "title='$title', " . "abstract='$abstract', " . "acknowledged='$finalized', " . "withdrawn='$withdrawn', " . "authorsResponse='$authorsResponse', " . "authorInformation='$authorInfo' " . "WHERE paperId=$paperId "; ; $result = $Conf->q($query); if (DB::isError($result)) { $Conf->errorMsg("Update failed: " . $result->getMessage()); exit; } else { $Conf->infoMsg("Updated information for #$paperId"); $Conf->log("Updated paper information for $paperId", $Me); if ( ! IsSet($uploadedFile) || $uploadedFile == "none" ) { $Conf->errorMsg("Did NOT change the paper itself"); } else { $Conf->errorMsg("Paper #$paperId being updated"); $fn = fopen($uploadedFile, "r"); if ( ! $fn ) { $Conf->errorMsg("There was an error opening the file to store your paper." . "Please press BACK and try again."); } else { $result = $Conf->q("DELETE FROM PaperStorage " . " WHERE ( PaperStorage.paperId='$paperId' )"); if (! $result) { $Conf->errorMsg("Could not delete the paper, may be necessary for replacing."); } else { $result = $Conf -> storePaper($uploadedFile, $uploadedFile_type, $paperId); if (DB::isError($result)) { $Conf->errorMsg("There was an error opening the file to store your paper." . "Please press BACK and try again."); $Conf->errorMsg("msg is " . $result->getMessage()); } else { $Conf->infoMsg("Looks like paper #$paperId was updated, but confirm it"); $Conf->log("Replace paper $paperId", $Me); } } } } $query="DELETE FROM PaperTopic WHERE paperId=$paperId"; $Conf->qe($query); // // Now, update the paper topics.. // for ($i = 0; $i < sizeof($topics); $i++) { $thistopic=$topics[$i]; $query="INSERT into PaperTopic SET " . " topicId='$thistopic', " . " paperId='$paperId' " ; $resultTopic=$Conf->qe($query); if (DB::isError($resultTopic)) { $Conf->errorMsg("I was unable to associate one of your topics " . "with your paper due to a database error. " . "The message was " . $resultTopic->getMessage() ); } } } } } $query = "SELECT title, abstract, authorInformation, " . " acknowledged, withdrawn, contactId, authorsResponse " . " FROM Paper " . " WHERE Paper.paperId=$paperId"; $result = $Conf->q($query); if (DB::isError($result) ) { $Conf->errorMsg("Unable to read information about paper: " . $result->getMessage()); exit; } $row = $result->fetchRow(); $title=$row[0]; $abstract=$row[1]; $authorInfo=$row[2]; $finalized=$row[3]; $withdrawn=$row[4]; $contactId=$row[5]; $authorsResponse=$row[6]; ?>

Modify any of the following information, and then hit "Update Paper" at the top or bottom of the page.

textButton("Click here to go back to viewing the paper", "../PC/PCAllAnonReviewsForPaper.php", $Conf->mkHiddenVar('paperId', $paperId) ); print ""; $Conf->textButton("Click here to go to the paper list", "../Assistant/AssistantListPapers.php"); ?>
q($query); $topics=array(); if ( DB::isError($result)) { $Conf->errorMsg("Error in query " . $result->getMessage()); } else if ($result->numRows() > 0) { while($row=$result->fetchRow()) { $topic=$row[0]; $topics[$topic] = 1; } } $query="SELECT TopicArea.topicAreaId, TopicArea.topicName FROM TopicArea "; $result = $Conf->q($query); if ( DB::isError($result)) { $Conf->errorMsg("Error in query " . $result->getMessage()); } else if ($result->numRows() > 0) { ?>
Contact Email
Title
Abstract
Finalized? Yes
Withdrawn? Yes
Author Information
(list all authors in order of appearance)
Author Review Response
Location of PDF or PostScript File
Topic (select any that apply) fetchRow()) { $id = $row[0]; $topic = $row[1]; if (IsSet($topics[$id])) { $checked = " CHECKED "; } else { $checked =""; } print " $topic
"; } ?>

footer() ?>