http://www.atutor.ca/atutor/mantis/view.php?id=2637
authorjoel kronenberg <joel.kronenberg@utoronto.ca>
Mon, 17 Jul 2006 15:15:55 +0000 (15:15 -0000)
committerjoel kronenberg <joel.kronenberg@utoronto.ca>
Mon, 17 Jul 2006 15:15:55 +0000 (15:15 -0000)
docs/admin/edit_user.php

index dd07707..2dbfdc3 100644 (file)
@@ -30,7 +30,7 @@ if (isset($_POST['submit'])) {
 \r
        //check if student id (public field) is already being used\r
        if (!$_POST['overwrite'] && !empty($_POST['student_id'])) {\r
-               $result = mysql_query("SELECT * FROM ".TABLE_PREFIX."master_list WHERE public_field='$_POST[student_id]' && member_id<>0",$db);\r
+               $result = mysql_query("SELECT public_field FROM ".TABLE_PREFIX."master_list WHERE public_field='$_POST[student_id]' AND member_id<>0 AND member_id<>$id",$db);\r
                if (mysql_num_rows($result) != 0) {\r
                        $msg->addError('CREATE_MASTER_USED');\r
                }\r