// ==========================================================
require_once("/pcmdi_web/include/header.php");
session_start();
if (!isset($_SESSION['username']))
{
$url = $_SESSION['url'] = $_SERVER['REQUEST_URI'];
header("Location: ../login.php");
exit();
}
$ipcc_publication_id = '';
$ipcc_subproject_id = '';
$button = '';
$authors = '';
$pub_title = '';
$abstract = '';
$status = '';
$journal = '';
$year = '';
$volume = '';
$pages = '';
$doi_id = '';
$url = '';
if (isset($_REQUEST['ipcc_publication_id']))
$ipcc_publication_id = $_REQUEST['ipcc_publication_id'];
if (isset($_REQUEST['ipcc_subproject_id']))
$ipcc_subproject_id = $_REQUEST['ipcc_subproject_id'];
if (isset($_REQUEST['button']))
$button = $_REQUEST['button'];
$errors = array();
if ($ipcc_publication_id == '')
{
$error = 'ERROR: IPCC Publication ID not specified.
';
$error .= 'Please return to the IPCC Subprojects page, select a project, and edit a publication from within that project.';
$errors[] = $error;
}
else if ($ipcc_subproject_id == '')
{
$error = 'ERROR: IPCC Subproject ID not specified.
';
$error .= 'Please return to the IPCC Subprojects page.';
$errors[] = $error;
}
if ($button == 'Cancel')
{
header('Location: project_detail.php?ipcc_subproject_id=' . $ipcc_subproject_id);
exit();
}
else if ($button == 'Save')
{
if (isset($_REQUEST['authors']))
$authors = $_REQUEST['authors'];
if (isset($_REQUEST['title']))
$pub_title = $_REQUEST['title'];
if (isset($_REQUEST['abstract']))
$abstract = $_REQUEST['abstract'];
if (isset($_REQUEST['status']))
$status = $_REQUEST['status'];
if (isset($_REQUEST['journal']))
$journal = $_REQUEST['journal'];
if (isset($_REQUEST['year']))
$year = $_REQUEST['year'];
if (isset($_REQUEST['volume']))
$volume = $_REQUEST['volume'];
if (isset($_REQUEST['pages']))
$pages = $_REQUEST['pages'];
if (isset($_REQUEST['doi_id']))
$doi_id = $_REQUEST['doi_id'];
if (isset($_REQUEST['url']))
$url = $_REQUEST['url'];
if ($url == 'http://')
{
$url = '';
}
// validate fields
if ($authors == '')
{
$errors[] = 'You must enter an author.';
}
if ($pub_title == '')
{
$errors[] = 'You must enter a title.';
}
if ($abstract == '')
{
$errors[] = 'You must enter an abstract.';
}
if ($status == '')
{
$errors[] = 'You must select a status.';
}
// update database
if (count($errors) == 0)
{
$sql = "UPDATE pcmdi_web.ipcc_publications SET ";
$sql .= "authors='" . $authors . "', ";
$sql .= "title='" . $pub_title . "', ";
$sql .= "abstract='" . $abstract . "', ";
$sql .= "status='" . $status . "', ";
$sql .= "journal='" . $journal . "', ";
$sql .= "year='" . $year . "', ";
$sql .= "volume='" . $volume . "', ";
$sql .= "pages='" . $pages . "', ";
$sql .= "doi_id='" . $doi_id . "', ";
$sql .= "url='" . $url . "', ";
$sql .= "modified_datetime=NOW(), ";
$sql .= "modified_by='" . $_SESSION['username'] . "' ";
$sql .= "WHERE ipcc_publication_id='" . $ipcc_publication_id . "'";
//print $sql . '
';
$db->query($sql);
// send back to project page
header('Location: project_detail.php?ipcc_subproject_id=' . $ipcc_subproject_id);
exit();
}
}
else
{
$sql = "SELECT * FROM pcmdi_web.ipcc_publications ";
$sql .= "WHERE ipcc_publication_id='" . mysql_real_escape_string($ipcc_publication_id) . "'";
//print $sql . '
';
$pub = $db->getRow($sql);
$authors = $pub['authors'];
$pub_title = $pub['title'];
$abstract = $pub['abstract'];
$status = $pub['status'];
$journal = $pub['journal'];
$year = $pub['year'];
$volume = $pub['volume'];
$pages = $pub['pages'];
$doi_id = $pub['doi_id'];
}
$title = "PCMDI > WCRP CMIP3 Model Output > WCRP CMIP3 Sub-Project Publications";
$header_image = "http://www-pcmdi.llnl.gov/images/banner_ipcc.jpg";
$welcome_image = "http://www-pcmdi.llnl.gov/images/headers/ipcc_subproject_publications.jpg";
require ("http://www-pcmdi.llnl.gov/header.inc");
?>