From 351d5250c011704589f561c7f2956ea8b532a871 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Tue, 9 Dec 2008 22:15:03 +0000
Subject: [PATCH] MDL12333 fixed code to use new DML syntax

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

diff --git a/user/profile/lib.php b/user/profile/lib.php
index 16656aeadc..6642d0c12c 100644
--- a/user/profile/lib.php
+++ b/user/profile/lib.php
@@ -402,8 +402,8 @@ function profile_signup_fields(&$mform) {
      //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
+                FROM {user_info_field} uf
+                JOIN {user_info_category} ic
                 ON uf.categoryid = ic.id AND uf.signup = 1
                 ORDER BY ic.sortorder ASC, uf.sortorder ASC";
 
-- 
2.39.5