From f8b0d22a5e2163f375439347e30da1854a17ad1e Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Thu, 21 Sep 2006 16:48:46 +0000
Subject: [PATCH] Fixes to make registering work ;-)

---
 admin/register.php | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/admin/register.php b/admin/register.php
index 33bf0837ee..e0948698dd 100644
--- a/admin/register.php
+++ b/admin/register.php
@@ -117,30 +117,30 @@
     echo "<input type=\"hidden\" name=\"courses\" value=\"$count\">\n";
     echo '<br />';
 
-    $count = count_records('user')-1;
+    $count = count_records('user', 'deleted', 0);
     echo get_string("users").": ".$count;
     echo "<input type=\"hidden\" name=\"users\" value=\"$count\">\n";
     echo '<br />';
 
     // total number of role assignments
     $count = count_records('role_assignments'); 
-    echo get_string("roleassignments").": ".$count;
+    echo get_string('roleassignments', 'role').": ".$count;
     echo "<input type=\"hidden\" name=\"roleassignments\" value=\"$count\">\n";
     echo '<br />';
 
     // first find all distinct roles with mod/course:update
     // please change the name and strings to something appropriate to reflect the new data collected
-    $sql = "SLECT COUNT(DISTINCT u.id)
+    $sql = "SELECT COUNT(DISTINCT u.id)
             FROM {$CFG->prefix}role_capabilities rc, 
                  {$CFG->prefix}role_assignments ra,
                  {$CFG->prefix}user u
-            WHERE (rc.capability = 'mod/course:update' or rc.capability='moodle/site:doanything')
+            WHERE (rc.capability = 'moodle/course:update' or rc.capability='moodle/site:doanything')
                    AND rc.roleid = ra.roleid
                    AND u.id = ra.userid";
     
     $count = count_records_sql($sql);
-    echo get_string("courseupdates").": ".$count;
-    echo "<input type=\"hidden\" name=\"courseupdates\" value=\"$count\">\n";
+    echo get_string("teachers").": ".$count;
+    echo "<input type=\"hidden\" name=\"courseupdaters\" value=\"$count\">\n";
     echo '<br />';
 
     $count = count_records('forum_posts');
-- 
2.39.5