' . 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 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(); ?>