From 1d4d001cfda4bea9793a3c199743b9f3416a8ef4 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Mon, 30 Oct 2006 03:38:13 +0000
Subject: [PATCH] merged fix for MDL-7267, fixing keywords pivot

---
 mod/glossary/print.php |  2 +-
 mod/glossary/sql.php   | 12 ++++++------
 mod/glossary/view.php  |  2 +-
 3 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/mod/glossary/print.php b/mod/glossary/print.php
index ced3023567..c50038d9ed 100644
--- a/mod/glossary/print.php
+++ b/mod/glossary/print.php
@@ -152,7 +152,7 @@
         foreach ($allentries as $entry) {
 
             // Setting the pivot for the current entry
-            $pivot = $entry->pivot;
+            $pivot = $entry->glossarypivot;
             $upperpivot = $textlib->strtoupper($pivot, current_charset());
             // Reduce pivot to 1cc if necessary
             if ( !$fullpivot ) {
diff --git a/mod/glossary/sql.php b/mod/glossary/sql.php
index 7b7db4f1b6..be4b2269b3 100644
--- a/mod/glossary/sql.php
+++ b/mod/glossary/sql.php
@@ -41,7 +41,7 @@
     case GLOSSARY_CATEGORY_VIEW:
         if ($hook == GLOSSARY_SHOW_ALL_CATEGORIES  ) { 
 
-            $sqlselect = "SELECT gec.id, ge.*, gec.entryid, gc.name $as pivot";
+            $sqlselect = "SELECT gec.id, ge.*, gec.entryid, gc.name $as glossarypivot";
             $sqlfrom   = "FROM {$CFG->prefix}glossary_entries ge,
                          {$CFG->prefix}glossary_entries_categories gec,
                          {$CFG->prefix}glossary_categories gc";
@@ -54,7 +54,7 @@
         } elseif ($hook == GLOSSARY_SHOW_NOT_CATEGORISED ) { 
 
             $printpivot = 0;
-            $sqlselect = "SELECT ge.*, concept $as pivot";
+            $sqlselect = "SELECT ge.*, concept $as glossarypivot";
             $sqlfrom   = "FROM {$CFG->prefix}glossary_entries ge LEFT JOIN {$CFG->prefix}glossary_entries_categories gec
                           ON ge.id = gec.entryid";
             $sqlwhere  = "WHERE (glossaryid = '$glossary->id' OR sourceglossaryid = '$glossary->id') AND
@@ -66,7 +66,7 @@
         } else {
 
             $printpivot = 0;
-            $sqlselect  = "SELECT ge.*, ce.entryid, c.name $as pivot";
+            $sqlselect  = "SELECT ge.*, ce.entryid, c.name $as glossarypivot";
             $sqlfrom    = "FROM {$CFG->prefix}glossary_entries ge, {$CFG->prefix}glossary_entries_categories ce, {$CFG->prefix}glossary_categories c";
             $sqlwhere   = "WHERE ge.id = ce.entryid AND ce.categoryid = '$hook' AND
                                  ce.categoryid = c.id AND ge.approved != 0 AND
@@ -103,7 +103,7 @@
             $where = '';
         }
 
-        $sqlselect  = "SELECT ge.id, $usernamefield $as pivot, u.id as uid, ge.*";
+        $sqlselect  = "SELECT ge.id, $usernamefield $as glossarypivot, u.id as uid, ge.*";
         $sqlfrom    = "FROM {$CFG->prefix}glossary_entries ge, {$CFG->prefix}user u";
         $sqlwhere   = "WHERE ge.userid = u.id  AND
                              (ge.approved != 0 $userid)
@@ -127,7 +127,7 @@
             }
         }
 
-        $sqlselect  = "SELECT ge.*, ge.concept $as pivot";
+        $sqlselect  = "SELECT ge.*, ge.concept $as glossarypivot";
         $sqlfrom    = "FROM {$CFG->prefix}glossary_entries ge";
         $sqlwhere   = "WHERE (ge.glossaryid = '$glossary->id' OR ge.sourceglossaryid = '$glossary->id') AND
                              ge.approved = 0 $where";
@@ -142,7 +142,7 @@
         $printpivot = 0;
     case GLOSSARY_STANDARD_VIEW:
     default:
-        $sqlselect  = "SELECT ge.*, ge.concept $as pivot";
+        $sqlselect  = "SELECT ge.*, ge.concept $as glossarypivot";
         $sqlfrom    = "FROM {$CFG->prefix}glossary_entries ge";
 
         $where = '';
diff --git a/mod/glossary/view.php b/mod/glossary/view.php
index 604c13df3b..be84f4341b 100644
--- a/mod/glossary/view.php
+++ b/mod/glossary/view.php
@@ -335,7 +335,7 @@
         foreach ($allentries as $entry) {
 
             // Setting the pivot for the current entry
-            $pivot = $entry->pivot;
+            $pivot = $entry->glossarypivot;
             $upperpivot = $textlib->strtoupper($pivot, current_charset());
             // Reduce pivot to 1cc if necessary
             if ( !$fullpivot ) {
-- 
2.39.5