& /designobservercomp/header.comp, site=>1, adcols=>2 &>
<& /designobservercomp/nav_designobserver.comp &>
Edit Nomination
<& /designobservercomp/adDOG_2col.comp &>
<& /designobservercomp/footer.comp &>
<%args>
$nomination =>""
%args>
<%init>
use RubyCore::ObjectInit;
use designobserver::Config();
my $rso = new RubyCore::ObjectInit { %designobserver::Config::c };
$rso->dbconnect();
my $cookie_header = $r->headers_in->get('Cookie');
my @cookies = split (";",$cookie_header);
my ($key,$value,$sessid);
my ($sql, $sth, $url, $nomid);
my @nomination;
foreach my $cookie (@cookies){
($key,$value) = split("=",$cookie);
if ($key eq "DO" || $key eq " DO"){
$sessid = $value;
}
}
if ($sessid){
$sql = "SELECT book, cover, title, author, publisher, artdirector, designer, designfirm, othercredits, IF(ISBN10,ISBN10,ISBN13) FROM 5050_2012 WHERE id='$nomination'";
$sth = $rso->dosql($sql);
@nomination = $sth -> fetchrow_array();
} else {
$url = "nominate.html";
$m->redirect($url);
}
%init>