From d256515fba93f0183062f8d02a5a3b4762a6bc9f Mon Sep 17 00:00:00 2001
From: martinlanghoff <martinlanghoff>
Date: Mon, 15 Jan 2007 19:57:12 +0000
Subject: [PATCH] enrol/database: fix fields not read from external database
 MDL-7712

---
 enrol/database/enrol.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/enrol/database/enrol.php b/enrol/database/enrol.php
index 6021490a6f..aa77a886ea 100644
--- a/enrol/database/enrol.php
+++ b/enrol/database/enrol.php
@@ -61,7 +61,7 @@ function setup_enrolments(&$user) {
             error_log('[ENROL_DB] Using config default for roles: '.$role->shortname);
         }*/
         
-        if ($rs = $enroldb->Execute("SELECT {$CFG->enrol_remotecoursefield}
+        if ($rs = $enroldb->Execute("SELECT {$CFG->enrol_remotecoursefield} as enrolremotecoursefield
                                        FROM {$CFG->enrol_dbtable}
                                       WHERE {$CFG->enrol_remoteuserfield} = " . $useridfield .
                                         (isset($remote_role_name, $remote_role_value) ? ' AND '.$remote_role_name.' = '.$remote_role_value : ''))) {
@@ -84,7 +84,7 @@ function setup_enrolments(&$user) {
 
                 $courselist = array();
                 while (!$rs->EOF) {         // Make a nice little array of courses to process
-                    $courselist[] = $rs->fields[0];
+                    $courselist[] = $rs->fields['enrolremotecoursefield'];
                     $rs->MoveNext();
                 }
                 $rs->Close();
-- 
2.39.5