added active state for the reviewer, redirection for compulsary profile form before test

1 files changed, 22 insertions, 2 deletions

diff --git a/tbc_external_review.module b/tbc_external_review.module
index 9bceeec..3666eac 100755
--- a/tbc_external_review.module
+++ b/tbc_external_review.module
@@ -272,7 +272,10 @@
         global $user;
         $form = array();
         /* populating the form with previous entry details if exists */
-        $query = "select * from {external_review_profile} where uid = %d";
+        $query = "
+            SELECT * FROM {external_review_profile} 
+            WHERE uid = %d
+        ";
         $result = db_query($query, $user->uid);
         $row = db_fetch_array($result);
         
@@ -414,7 +417,10 @@
 
     function tbc_external_review_view_reviewers_all() {
         $page_content = "";
-        $query = "select * from {external_review_profile}";
+        $query = "
+            SELECT * FROM {external_review_profile}
+            WHERE active = 1
+        ";
         $result = db_query($query);
         
         $page_content .= "<ul>";
@@ -1750,6 +1756,7 @@
         $minutes_remaining = 25;
         $seconds_remaining = 0;
         
+        /* checking if a valid question */
         if ($question_id > 5 || $question_id < 0) {
             drupal_set_message("Wrong question number.", "error");
             drupal_goto("tbc_external_review/eligibility_test/question/1");
@@ -1823,6 +1830,19 @@
             $result = db_query($query);
             drupal_set_message("Eligibility Test completed successfully. We will get back to you soon.", "status");
         } else {
+            /* checking if the user has filled the profile form */
+            $query = "
+                SELECT uid FROM external_review_profile
+                WHERE uid = %d
+            ";
+            $result = db_query($query, $user->uid);
+            $num_rows = mysql_num_rows($result);
+            if(!$num_rows) {
+                drupal_set_message("Please fill  the profile form before you can attend the test.", "error");
+                drupal_goto("tbc_external_review/profile");
+            }
+            
+            /* showing the test details before starting the test */
             $page_content .= "<p>You are about to give a test based on which you will be selected as a reviewer for the Scilab Textbook Companions.</p>";
             $page_content .= "<ul>";
                 $page_content .= "<li>The test consists of 5 code review questions that are mandatory.</li>";