From 416afdbb662ee87c887eadb3c2ee600ce2247ea2 Mon Sep 17 00:00:00 2001
From: jerome <jerome>
Date: Mon, 18 Aug 2008 08:26:41 +0000
Subject: [PATCH] MDL-12333:  display custom field in categories box on the
 signup page

---
 user/profile/lib.php | 19 ++++++++++++++++---
 1 file changed, 16 insertions(+), 3 deletions(-)

diff --git a/user/profile/lib.php b/user/profile/lib.php
index 6a9f57322c..445155192f 100644
--- a/user/profile/lib.php
+++ b/user/profile/lib.php
@@ -387,12 +387,25 @@ function profile_display_fields($userid) {
  */
 function profile_signup_fields(&$mform) {
     global $CFG, $DB;
-    
-    if ($fields = $DB->get_records('user_info_field', array('signup'=>1), 'sortorder ASC')) {
+
+     //only retrieve required custom fields (with category information)
+    //results are sort by categories, then by fields
+    $sql = "SELECT uf.id as fieldid, ic.id as categoryid, ic.name as categoryname, uf.datatype
+                FROM ".$CFG->prefix."user_info_field uf
+                JOIN ".$CFG->prefix."user_info_category ic
+                ON uf.categoryid = ic.id AND uf.signup = 1
+                ORDER BY ic.sortorder ASC, uf.sortorder ASC";
+
+    if ( $fields = $DB->get_records_sql($sql)) {
         foreach ($fields as $field) {
+            //check if we change the categories
+            if (!isset($currentcat) || $currentcat != $field->categoryid) {
+                 $currentcat = $field->categoryid;
+                 $mform->addElement('header', 'category_'.$field->categoryid, format_string($field->categoryname));
+            }
             require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php');
             $newfield = 'profile_field_'.$field->datatype;
-            $formfield = new $newfield($field->id);
+            $formfield = new $newfield($field->fieldid);
             $formfield->edit_field($mform);
         }
     }
-- 
2.39.5