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