Changeset 4421

Show
Ignore:
Timestamp:
Wed Feb 1 23:01:19 2006
Author:
paul
Message:

Added the ChangeSystemPreferences? permission.

Files:

Legend:

Unmodified
Added
Removed
Modified

  • trunk/campsite/implementation/database/upgrade/2.4.x/upgrade_user_perms.php

    r4419 r4421  
    26 26 // Add new permissions for each user.  
    27 27 //  
    28   if (!($res = mysql_query("SELECT DISTINCT(fk_user_id) FROM UserConfig"))) {  
      28 if (!($res = mysql_query("SELECT DISTINCT(fk_user_id) FROM UserConfig WHERE fk_user_id!=0"))) {  
    28 28     die("Unable to read from the database.\n");  
    29 29 }  
    …… 
    63 63     mysql_query($sql);  
    64 64      
      65     // Set the new "ChangeSystemPreferences" permission to have the same value as the  
      66     // "InitializeTemplateEngine" permission.  
      67     $sql = "SELECT value FROM UserConfig WHERE fk_user_id=".$row['fk_user_id']." AND varname='InitializeTemplateEngine'";  
      68     $result = mysql_query($sql);  
      69     $row2 = mysql_fetch_array($result, MYSQL_ASSOC);  
      70      
      71     // Add the "ChangeSystemPreferences" permission.  
      72     $sql = "INSERT INTO UserConfig(fk_user_id, varname, value) "  
      73             ." VALUES (".$row['fk_user_id'].", 'ChangeSystemPreferences', '".$row2['value']."')";  
      74     mysql_query($sql);  
      75      
    65 76     // Add the "AttachTopicToArticle" permission.  
    66 77     $sql = "INSERT INTO UserConfig(fk_user_id, varname, value) "  
    124 135     mysql_query($sql);  
    125 136      
      137     // Set the new "ChangeSystemPreferences" permission to have the same value as the  
      138     // "InitializeTemplateEngine" permission.  
      139     $sql = "SELECT value FROM UserTypes WHERE user_type_name='$userTypeName' AND varname='InitializeTemplateEngine'";  
      140     $result = mysql_query($sql);  
      141     $row2 = mysql_fetch_array($result, MYSQL_ASSOC);  
      142  
      143     // Add the "ChangeSystemPreferences" permission.  
      144     $sql = "INSERT INTO UserTypes(user_type_name, varname, value) "  
      145             ." VALUES ('$userTypeName', 'ChangeSystemPreferences', '".$row2['value']."')";  
      146     mysql_query($sql);  
      147      
    126 148     // Add the "AttachTopicToArticle" permission.  
    127 149     $sql = "INSERT INTO UserTypes(user_type_name, varname, value) "