From 0be16c1d8c74fcf46e5bc2447bf4082448a8d3db Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Fri, 1 Sep 2006 18:24:09 +0000
Subject: [PATCH] mssql doesn't support aliases nor position numbers in the
 GROUP BY clause. Just columns and expressions.

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

diff --git a/lib/accesslib.php b/lib/accesslib.php
index 107d5af9e6..55296a1a6f 100755
--- a/lib/accesslib.php
+++ b/lib/accesslib.php
@@ -458,7 +458,7 @@ function load_user_capability($capability='', $context ='', $userid='') {
                      rc.contextid=$siteinstance->id 
                      $capsearch
               GROUP BY
-                     rc.capability,aggrlevel,c1.id
+                     rc.capability, (c1.aggregatelevel * 100), c1.id
                      HAVING
                      SUM(rc.permission) != 0
               UNION
@@ -481,7 +481,7 @@ function load_user_capability($capability='', $context ='', $userid='') {
                      $capsearch
                   
               GROUP BY
-                     rc.capability, aggrlevel, c1.id
+                     rc.capability, (c1.aggregatelevel * 100 + c2.aggregatelevel), c1.id
                      HAVING
                      SUM(rc.permission) != 0
               ORDER BY
-- 
2.39.5