From c4b654bc3c9bb57b5d64ea209ed1ae3ebd11ee5c Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Tue, 23 Jan 2007 16:09:00 +0000
Subject: [PATCH] WHERE '1' is not cross-db. MDL-8280

---
 user/edit.php      | 2 +-
 user/edit_form.php | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/user/edit.php b/user/edit.php
index c70147ca68..53abc59c42 100644
--- a/user/edit.php
+++ b/user/edit.php
@@ -216,7 +216,7 @@
             }
 
             /// Update the custom user fields
-            if ($categories = get_records_select('user_info_category', '1', 'sortorder ASC')) {
+            if ($categories = get_records_select('user_info_category', '', 'sortorder ASC')) {
                 foreach ($categories as $category) {
 
                     if ($fields = get_records_select('user_info_field', "categoryid=$category->id", 'sortorder ASC')) {
diff --git a/user/edit_form.php b/user/edit_form.php
index b91dc68d9a..4c4591ab48 100644
--- a/user/edit_form.php
+++ b/user/edit_form.php
@@ -319,7 +319,7 @@ class user_edit_form extends moodleform {
         $mform->hardFreeze($freezefields);
 
         /// Next the customisable categories
-        if ($categories = get_records_select('user_info_category', '1', 'sortorder ASC')) {
+        if ($categories = get_records_select('user_info_category', '', 'sortorder ASC')) {
             foreach ($categories as $category) {
                 if ($fields = get_records_select('user_info_field', "categoryid=$category->id", 'sortorder ASC')) {
 
@@ -395,7 +395,7 @@ class user_edit_form extends moodleform {
 
         /// And now we validate the custom data fields
 
-        if ($categories = get_records_select('user_info_category', '1', 'sortorder ASC')) {
+        if ($categories = get_records_select('user_info_category', '', 'sortorder ASC')) {
             foreach ($categories as $category) {
 
                 if ($fields = get_records_select('user_info_field', "categoryid=$category->id", 'sortorder ASC')) {
-- 
2.39.5