From 2ff0fb1205e3a6305edc49be1526eb626f4e8bbf Mon Sep 17 00:00:00 2001
From: martinlanghoff <martinlanghoff>
Date: Tue, 4 Dec 2007 06:25:25 +0000
Subject: [PATCH] accesslib: build_context_path() remove $temptable for Oracle
 too

The removal of $temptable was incomplete - and so build_context_path()
was broken on Oracle. MDL-11347
---
 lib/accesslib.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/lib/accesslib.php b/lib/accesslib.php
index 1f95fa74f6..6be26882ca 100755
--- a/lib/accesslib.php
+++ b/lib/accesslib.php
@@ -4720,10 +4720,10 @@ function build_context_path($force=false, $feedback=false) {
         $updatesql = "UPDATE {$CFG->prefix}context ct
                          SET (ct.path, ct.depth) =
                              (SELECT temp.path, temp.depth
-                                FROM {$CFG->prefix}$temptable temp
+                                FROM {$CFG->prefix}context_temp temp
                                WHERE temp.id=ct.id)
                        WHERE EXISTS (SELECT 'x'
-                                       FROM {$CFG->prefix}$temptable temp
+                                       FROM {$CFG->prefix}context_temp temp
                                        WHERE temp.id = ct.id)";
     } else {
         $updatesql = "UPDATE {$CFG->prefix}context
-- 
2.39.5