bug fixes and speed up runs

1 files changed, 19 insertions, 1 deletions

diff --git a/src/fcontest.php b/src/fcontest.php
index 96576a6..045f28e 100644
--- a/src/fcontest.php
+++ b/src/fcontest.php
@@ -15,7 +15,7 @@
 //    You should have received a copy of the GNU General Public License
 //    along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ////////////////////////////////////////////////////////////////////////////////
-//Last updated 26/jul/2017 by cassio@ime.usp.br
+//Last updated 29/aug/2017 by cassio@ime.usp.br
 //
 function DBDropContestTable() {
 	 $c = DBConnect();
@@ -201,6 +201,24 @@ function DBFakeContest() {
            "'t', '$pass', NULL, NULL, '', NULL, NULL)", "DBFakeContest(insert system user)");
 	DBExec($c, "commit work");
 }
+function DBAllUserNames($contest,$site=-1) {
+	$sql = "select * from usertable where contestnumber=$contest ";
+	if($site > 0) $sql .= "and usersitenumber=$site ";
+	$c = DBConnect();
+	$r = DBExec ($c, $sql, "DBAllUserNames(get users)");
+	$n = DBnlines($r);
+	if ($n == 0) {
+		LOGError("Unable to find users in the database. SQL=(" . $sql . ")");
+		MSGError("Unable to find users in the database!");
+	}
+
+	$a = array();
+	for ($i=0;$i<$n;$i++) {
+	  $tmp = DBRow($r,$i);
+	  $a[$tmp['usersitenumber'] . '-' . $tmp['usernumber']] = $tmp['username'];
+	}
+	return $a;
+}
 function DBAllUserInfo($contest,$site=-1) {
 	$sql = "select * from usertable where contestnumber=$contest ";
 	if($site > 0) $sql .= "and usersitenumber=$site ";