my $path = "../../"; my $title = "General Conference Evaluation"; !> #include ../../header.iphtml #include ../../checkuser.iphtml
You will be able to complete the '.$title.' on '.$open_txt.'
'; print 'If you have any questions, please contact:
Kim Battle
Association Manager
804-282-9780
kim@societyhq.com.
; } } } sub gen_send_results { my $active = shift; return unless $active; my %cookie_in = $main::cgi->cookie("SPAID"); my $cookie_uid = $cookie_in{"id"}; my $userID = $cookie_uid; my $SQL; @fields = param(); $main::cgi->import_names('q'); my $missing = ''; my $rows; $missing .= "
ERROR - Please answer ALL of the following questions:
'; print "| \n";
# if ($member_no) {
$cursor = $main::dbh->prepare ("SELECT sessionID FROM meeting_evaluated WHERE memberID=$userID AND meetingID=$meeting_no AND sessionID=0");
$cursor->execute() || die "Couldn't execut query: $DBI::errstr\n";
@ary = $cursor->fetchrow_array();
$cursor->finish;
if (!@ary) {
my $insertSQL = "INSERT INTO general_mtg_evaluation (";
foreach(@fields) {
if ($_ eq "Submit" || $_ eq "certification") {
} else {
$insertSQL .= $_ . ", ";
}
}
$insertSQL =~ s/, $/,meetingid) VALUES (/;
foreach(@fields) {
if ($_ eq "Submit" || $_ eq "certification") {
} else {
$insertSQL .= $main::dbh->quote(param($_)) . ", ";
}
}
$insertSQL =~ s/, $/,$meeting_no)/;
#print " $insertSQL "; $main::dbh->do(qq{LOCK TABLES general_mtg_evaluation, meeting_evaluated WRITE}); $rows = $main::dbh->do(qq{$insertSQL}); if (!$rows) { print "Sorry, unable to save your response. \n"; } else { $SQL = "INSERT INTO meeting_evaluated (meetingID,memberID,sessionID) VALUES ($meeting_no,$userID,0)"; $rows = $main::dbh->do(qq{$SQL}) || die "INSERT failed $DBI::errstr\n"; my @prof_cert = param('certification'); foreach(@prof_cert) { $main::dbh->do(qq{UPDATE 2008_winter_eval_certification SET votes = votes + 1 WHERE id = $_}); } print p(strong('General meeting evaluation submitted successfully!')); print p('Thank you for your time in completing the evaluation form. Please make sure you also evaluate each individual topic that you attended.'); } $main::dbh->do(qq{UNLOCK TABLES}); } else { print "Sorry, our records show you having already completed the general evaluation. You may only evaluate the general meeting once. "; } # } else { # print "Sorry, but our records show you are not registered for this meeting. If you think you reached this page in error, please contact the administrative office at (804) 282-9780 or email spa\@societyhq.com. "; # } print " |