' . oc_('Email address entered is invalid') . '

'; printFooter(); exit; } $q = "SELECT `" . OCC_TABLE_PAPER . "`.`paperid`, `" . OCC_TABLE_PAPER . "`.`title` FROM `" . OCC_TABLE_PAPER . "`, `" . OCC_TABLE_AUTHOR . "` WHERE `" . OCC_TABLE_AUTHOR . "`.`email`='" . safeSQLstr(oc_strtolower($_POST['email'])) . "' AND `" . OCC_TABLE_AUTHOR . "`.`paperid`=`" . OCC_TABLE_PAPER . "`.`paperid` AND `" . OCC_TABLE_AUTHOR . "`.`position`=`" . OCC_TABLE_PAPER . "`.`contactid` ORDER BY `" . OCC_TABLE_PAPER . "`.`paperid`"; $r = ocsql_query($q) or err(oc_('Error checking for submissions')); if (($rnum=mysql_num_rows($r)) == 0) { print '

' . sprintf(oc_("We did not find any submissions where the contact author's email is %s"), $_POST['email']) . '.

'; printFooter(); exit; } else { $msg = "\n" . sprintf(oc_('Per your request, here is a list of submissions made to the %s OpenConf system with you listed as the contact:'), $OC_configAR['OC_confName']) . "\n"; while ($e = mysql_fetch_array($r)) { $msg .= ' ID: ' . $e['paperid'] . ' Title: ' . $e['title'] . ' '; } sendEmail($_POST['email'], oc_('List of submissions made'), $msg, $OC_configAR['OC_notifyAuthorEmailPapers']); print oc_('We have emailed the list of submissions for which you are the contact author.'); printFooter(); exit; } } else { print '

' . oc_('Please enter your email address below and click on Email Submissions. We will then email you a list of submissions for which you are the contact author.') . "

\n"; } print '
' . oc_('Email') . ':

'; printFooter(); ?>