$value){
if($key == "but" || $key == "contrib_num")
$value = '';
else
$value = addslashes($data[$key]);
if(!empty($value))
$suf .= $key . "='" . $value . "', ";
if(empty($value) && $key != "contrib_num" && $key != "but")
$suf .= $key . "=NULL, ";
} // foreach($data as $key => $value)
$suf = substr($suf, 0, -2); //cuts the last ", " off
$tbname = TABLE_PAPERS_PURG;
$primary = "contrib_num";
$query = "SELECT $primary FROM $tbname WHERE $primary=$id";
$result = $db->sql_query($query);
$num = $db->sql_numrows($result);
if($num == 1){
$query = "UPDATE $tbname SET $suf WHERE contrib_num=$id";
//echo $query;
$result = $db->sql_query($query);
if(!$result){
$indication = "unknown error please try again";
}
else{
$indication = get_paper_title($data['title']) . ' Update Submitted!
';
$message = 'An update to the paper "' . get_paper_title($data['title']) . '" has been submitted:' .
"\n\nhttp://www.usglobec.org/admin/paper_approve.php?ind=" . $data['contrib_num'];
//echo $message;
mail(PAPER_ADMIN,"Paper Update",$message,FROM);
$success = true;
}
} // if($num == 1)
else{
if(empty($id)){
$id = get_next_free_contrib_num();
$type = ' Request ';
$message = 'A contribution number request for "';
}
else{
$type = ' Update ';
$message = 'An update for "';
}
$suf .= ", contrib_num=$id";
$query = "INSERT INTO $tbname SET $suf";
//echo $query;
$result = $db->sql_query($query);
if(!$result){
$indication = "unknown error please try again";
}
else{
$indication = get_paper_title($data['title']) . $type . 'Submitted!
';
$message .= get_paper_title($data['title']) . '" has been submitted:' .
"\n\nhttp://www.usglobec.org/admin/paper_approve.php?ind=" . $id;
mail(PAPER_ADMIN,"Paper" . $type,$message,FROM);
$success = true;
}
} // else
} // if($_POST[but] == "Submit")
$primary="contrib_num";
$id = (!empty($_GET['ind'])) ? $_GET['ind'] : '';
if(!empty($indication) && $indication != "unknown error please try again"){
$query = "SELECT * FROM " . TABLE_PAPERS_PURG . " WHERE $primary=" . $id;
}
else{
$query = "SELECT * FROM " . TABLE_PAPERS . " WHERE $primary=" . $id;
}
if(!empty($_POST)){
$row = $_POST;
}
else{
$result = $db->sql_query($query);
$row = $db->sql_fetchrow($result);
}
//echo $query;
include HEAD;
?>
' . $indication . '';
if($success){
echo '