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("Error checking for submissions ".mysql_errno()); if (($rnum=mysql_num_rows($r)) == 0) { print 'We did not find any submissions where the contact author\'s email is ' . $_POST['email'] . '.

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

'; printFooter(); exit; } } else { print "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 '

Email:

'; printFooter(); ?>