From 203d964a4a39a6c3770bbe3f2ba30348eaadf534 Mon Sep 17 00:00:00 2001 From: skodak Date: Wed, 19 Sep 2007 19:20:18 +0000 Subject: [PATCH] MDL-11347 yet more beautification proposed by Eloy --- lib/accesslib.php | 1 + 1 file changed, 1 insertion(+) diff --git a/lib/accesslib.php b/lib/accesslib.php index 6846b2d90d..a65449030a 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -4451,6 +4451,7 @@ function build_context_path($force=false) { $emptyclause = ''; } + // TODO: following could be improved with WHERE + $emptyclause, but there should be a better way $upathsql = "UPDATE {$CFG->prefix}context SET path = COALESCE((SELECT ct.path FROM {$CFG->prefix}$temptable ct WHERE {$CFG->prefix}context.id=ct.id), {$CFG->prefix}context.path)"; -- 2.39.5