| 1 | <?php
 | 
  
    | 2 | /**
 | 
  
    | 3 |  *
 | 
  
    | 4 |  * @category        admin
 | 
  
    | 5 |  * @package         users
 | 
  
    | 6 |  * @author          WebsiteBaker Project
 | 
  
    | 7 |  * @copyright       Ryan Djurovich
 | 
  
    | 8 |  * @copyright       WebsiteBaker Org. e.V.
 | 
  
    | 9 |  * @link            http://websitebaker.org/
 | 
  
    | 10 |  * @license         http://www.gnu.org/licenses/gpl.html
 | 
  
    | 11 |  * @platform        WebsiteBaker 2.8.3
 | 
  
    | 12 |  * @requirements    PHP 5.3.6 and higher
 | 
  
    | 13 |  * @version         $Id: users.php 2 2017-07-02 15:14:29Z Manuela $
 | 
  
    | 14 |  * @filesource      $HeadURL: svn://isteam.dynxs.de/wb/2.10.x/trunk/admin/users/users.php $
 | 
  
    | 15 |  * @lastmodified    $Date: 2017-07-02 17:14:29 +0200 (Sun, 02 Jul 2017) $
 | 
  
    | 16 |  *
 | 
  
    | 17 |  */
 | 
  
    | 18 | 
 | 
  
    | 19 |  // Include config file and admin class file
 | 
  
    | 20 | if ( !defined( 'WB_PATH' ) ){ require( dirname(dirname((__DIR__))).'/config.php' ); }
 | 
  
    | 21 | if ( !class_exists('admin', false) ) { require(WB_PATH.'/framework/class.admin.php'); }
 | 
  
    | 22 | 
 | 
  
    | 23 | $action = 'cancel';
 | 
  
    | 24 | // Set parameter 'action' as alternative to javascript mechanism
 | 
  
    | 25 | $action = (isset($_POST['modify']) ? 'modify' : $action );
 | 
  
    | 26 | $action = (isset($_POST['delete']) ? 'delete' : $action );
 | 
  
    | 27 | 
 | 
  
    | 28 | $oTrans = Translate::getInstance();
 | 
  
    | 29 | $oTrans->enableAddon(ADMIN_DIRECTORY.'\\users');
 | 
  
    | 30 | /*
 | 
  
    | 31 | print '<pre  class="mod-pre rounded">function <span>'.__FUNCTION__.'( '.''.' );</span>  filename: <span>'.basename(__FILE__).'</span>  line: '.__LINE__.' -> <br />';
 | 
  
    | 32 | print_r( $oTrans ); print '</pre>'; flush (); //  ob_flush();;sleep(10); die();
 | 
  
    | 33 | */
 | 
  
    | 34 | 
 | 
  
    | 35 | switch ($action):
 | 
  
    | 36 |     case 'modify' :
 | 
  
    | 37 |             // Print header
 | 
  
    | 38 |             $admin = new admin('Access', 'users_modify');
 | 
  
    | 39 |             $user_id = intval($admin->checkIDKEY('user_id', 0, $_SERVER['REQUEST_METHOD']));
 | 
  
    | 40 |             // Check if user id is a valid number and doesnt equal 1
 | 
  
    | 41 |             if($user_id == 0){
 | 
  
    | 42 |             $admin->print_error($oTrans->MESSAGE_GENERIC_FORGOT_OPTIONS );
 | 
  
    | 43 |             }
 | 
  
    | 44 |             if( ($user_id < 2 ) )
 | 
  
    | 45 |             {
 | 
  
    | 46 |                 // if($admin_header) { $admin->print_header(); }
 | 
  
    | 47 |                 $admin->print_error($oTrans->MESSAGE_GENERIC_SECURITY_ACCESS, ADMIN_URL );
 | 
  
    | 48 |             }
 | 
  
    | 49 |             // Get existing values
 | 
  
    | 50 | 
 | 
  
    | 51 |             $sql  = 'SELECT * FROM `'.TABLE_PREFIX.'users` ' ;
 | 
  
    | 52 |             $sql .= 'WHERE user_id != 1 ';
 | 
  
    | 53 |             $sql .=   'AND user_id = '.$user_id.' ';
 | 
  
    | 54 | 
 | 
  
    | 55 |             $results = $database->query($sql);
 | 
  
    | 56 | 
 | 
  
    | 57 |             $user = $results->fetchRow(MYSQLI_ASSOC);
 | 
  
    | 58 |             // Setup template object, parse vars to it, then parse it
 | 
  
    | 59 |             // Create new template object
 | 
  
    | 60 |             $template = new Template(dirname($admin->correct_theme_source('users_form.htt')), 'remove');
 | 
  
    | 61 |             // $template->debug = true;
 | 
  
    | 62 |             $template->set_file('page', 'users_form.htt');
 | 
  
    | 63 |             $template->set_block('page', 'main_block', 'main');
 | 
  
    | 64 |             $template->set_block('main_block', 'user_add_block', 'user_add');
 | 
  
    | 65 | 
 | 
  
    | 66 |             $template->set_var(array(
 | 
  
    | 67 |                                 'ACTION_URL' => ADMIN_URL.'/users/save.php',
 | 
  
    | 68 |                                 'SUBMIT_TITLE' => $oTrans->TEXT_SAVE,
 | 
  
    | 69 |                                 'USER_ID' => $user['user_id'],
 | 
  
    | 70 |                                 'USERNAME' => $user['username'],
 | 
  
    | 71 |                                 'DISPLAY_NAME' => $user['display_name'],
 | 
  
    | 72 |                                 'EMAIL' => $user['email'],
 | 
  
    | 73 |                                 'ADMIN_URL' => ADMIN_URL,
 | 
  
    | 74 |                                 'WB_URL' => WB_URL,
 | 
  
    | 75 |                                 'THEME_URL' => THEME_URL
 | 
  
    | 76 |                                 )
 | 
  
    | 77 |                         );
 | 
  
    | 78 | 
 | 
  
    | 79 |             $template->set_var('FTAN', $admin->getFTAN());
 | 
  
    | 80 |             $template->set_var('READONLY', 'readonly="readonly"' );
 | 
  
    | 81 |             if($user['active'] == 1) {
 | 
  
    | 82 |                 $template->set_var('ACTIVE_CHECKED', ' checked="checked"');
 | 
  
    | 83 |             } else {
 | 
  
    | 84 |                 $template->set_var('DISABLED_CHECKED', ' checked="checked"');
 | 
  
    | 85 |             }
 | 
  
    | 86 |             // Add groups to list
 | 
  
    | 87 |             $template->set_block('main_block', 'group_list_block', 'group_list');
 | 
  
    | 88 |             $sql  = 'SELECT `group_id`, `name` FROM `'.TABLE_PREFIX.'groups` '
 | 
  
    | 89 |                   . 'WHERE `group_id` != 1 '
 | 
  
    | 90 |                   . 'ORDER BY `name`';
 | 
  
    | 91 |             $results = $database->query($sql);
 | 
  
    | 92 |             if ($database->query($sql))
 | 
  
    | 93 |             {
 | 
  
    | 94 |                 $template->set_var('ID', '');
 | 
  
    | 95 |                 $template->set_var('NAME', $oTrans->TEXT_PLEASE_SELECT.'...');
 | 
  
    | 96 |                 $template->set_var('SELECTED', '');
 | 
  
    | 97 |                 $template->parse('group_list', 'group_list_block', true);
 | 
  
    | 98 |                 while($group = $results->fetchRow(MYSQLI_ASSOC))
 | 
  
    | 99 |                 {
 | 
  
    | 100 |                     $template->set_var('ID', $group['group_id']);
 | 
  
    | 101 |                     $template->set_var('NAME', $group['name']);
 | 
  
    | 102 |                     $template->set_var('SELECTED', '');
 | 
  
    | 103 |                     if ($admin->is_group_match($group['group_id'], $user['groups_id']))
 | 
  
    | 104 |                     {
 | 
  
    | 105 |                         $template->set_var('SELECTED', ' selected="selected"');
 | 
  
    | 106 |                     }
 | 
  
    | 107 |                     $template->parse('group_list', 'group_list_block', true);
 | 
  
    | 108 |                 }
 | 
  
    | 109 |             }
 | 
  
    | 110 | 
 | 
  
    | 111 |             // Only allow the user to add a user to the Administrators group if they belong to it
 | 
  
    | 112 |             if ($admin->ami_group_member('1'))
 | 
  
    | 113 |             {
 | 
  
    | 114 |                 $template->set_var('ID', '1');
 | 
  
    | 115 |                 $users_groups = $admin->get_groups_name();
 | 
  
    | 116 |                 $template->set_var('NAME', $users_groups[1]);
 | 
  
    | 117 |                 if ($admin->is_group_match('1', $user['groups_id']))
 | 
  
    | 118 |                 {
 | 
  
    | 119 |                     $template->set_var('SELECTED', ' selected="selected"');
 | 
  
    | 120 |                 } else {
 | 
  
    | 121 |                     $template->set_var('SELECTED', '');
 | 
  
    | 122 |                 }
 | 
  
    | 123 |                 $template->parse('group_list', 'group_list_block', true);
 | 
  
    | 124 |             } else {
 | 
  
    | 125 |                 if($results->numRows() == 0)
 | 
  
    | 126 |                 {
 | 
  
    | 127 |                     $template->set_var('ID', '');
 | 
  
    | 128 |                     $template->set_var('NAME', $oTrans->TEXT_NONE_FOUND);
 | 
  
    | 129 |                     $template->set_var('SELECTED', ' selected="selected"');
 | 
  
    | 130 |                     $template->parse('group_list', 'group_list_block', true);
 | 
  
    | 131 |                 }
 | 
  
    | 132 |             }
 | 
  
    | 133 | 
 | 
  
    | 134 |             // Generate username field name
 | 
  
    | 135 |             $username_fieldname = 'username_';
 | 
  
    | 136 |             $salt = "abchefghjkmnpqrstuvwxyz0123456789";
 | 
  
    | 137 |             srand((double)microtime()*1000000);
 | 
  
    | 138 |             $i = 0;
 | 
  
    | 139 |             while ($i <= 7) {
 | 
  
    | 140 |                 $num = rand() % 33;
 | 
  
    | 141 |                 $tmp = substr($salt, $num, 1);
 | 
  
    | 142 |                 $username_fieldname = $username_fieldname . $tmp;
 | 
  
    | 143 |                 $i++;
 | 
  
    | 144 |             }
 | 
  
    | 145 | 
 | 
  
    | 146 |             // Work-out if home folder should be shown
 | 
  
    | 147 |             if(!HOME_FOLDERS) {
 | 
  
    | 148 |                 $template->set_var('DISPLAY_HOME_FOLDERS', 'display:none;');
 | 
  
    | 149 |             }
 | 
  
    | 150 | 
 | 
  
    | 151 |             // Include the WB functions file
 | 
  
    | 152 |             require_once(WB_PATH.'/framework/functions.php');
 | 
  
    | 153 | 
 | 
  
    | 154 |             // Add media folders to home folder list
 | 
  
    | 155 |             $template->set_block('main_block', 'folder_list_block', 'folder_list');
 | 
  
    | 156 |             foreach(directory_list(WB_PATH.MEDIA_DIRECTORY) AS $name)
 | 
  
    | 157 |             {
 | 
  
    | 158 |                 $template->set_var('NAME', str_replace(WB_PATH, '', $name));
 | 
  
    | 159 |                 $template->set_var('FOLDER', str_replace(WB_PATH.MEDIA_DIRECTORY, '', $name));
 | 
  
    | 160 |                 if($user['home_folder'] == str_replace(WB_PATH.MEDIA_DIRECTORY, '', $name)) {
 | 
  
    | 161 |                     $template->set_var('SELECTED', ' selected="selected"');
 | 
  
    | 162 |                 } else {
 | 
  
    | 163 |                     $template->set_var('SELECTED', ' ');
 | 
  
    | 164 |                 }
 | 
  
    | 165 |                 $template->parse('folder_list', 'folder_list_block', true);
 | 
  
    | 166 |             }
 | 
  
    | 167 | 
 | 
  
    | 168 |             // Insert language text and messages
 | 
  
    | 169 |             $template->set_var(array(
 | 
  
    | 170 |                                 'TEXT_RESET' => $oTrans->TEXT_RESET,
 | 
  
    | 171 |                                 'TEXT_CANCEL' => $oTrans->TEXT_CANCEL,
 | 
  
    | 172 |                                 'TEXT_ACTIVE' => $oTrans->TEXT_ACTIVE,
 | 
  
    | 173 |                                 'TEXT_DISABLED' => $oTrans->TEXT_DISABLED,
 | 
  
    | 174 |                                 'TEXT_PLEASE_SELECT' => $oTrans->TEXT_PLEASE_SELECT,
 | 
  
    | 175 |                                 'TEXT_USERNAME' => $oTrans->TEXT_USERNAME,
 | 
  
    | 176 |                                 'TEXT_PASSWORD' => $oTrans->TEXT_PASSWORD,
 | 
  
    | 177 |                                 'TEXT_RETYPE_PASSWORD' => $oTrans->TEXT_RETYPE_PASSWORD,
 | 
  
    | 178 |                                 'TEXT_DISPLAY_NAME' => $oTrans->TEXT_DISPLAY_NAME,
 | 
  
    | 179 |                                 'TEXT_EMAIL' => $oTrans->TEXT_EMAIL,
 | 
  
    | 180 |                                 'TEXT_GROUP' => $oTrans->TEXT_GROUP,
 | 
  
    | 181 |                                 'TEXT_NONE' => $oTrans->TEXT_NONE,
 | 
  
    | 182 |                                 'TEXT_HOME_FOLDER' => $oTrans->TEXT_HOME_FOLDER,
 | 
  
    | 183 |                                 'USERNAME_FIELDNAME' => $username_fieldname,
 | 
  
    | 184 |                                 'CHANGING_PASSWORD' => $oTrans->MESSAGE_USERS_CHANGING_PASSWORD,
 | 
  
    | 185 |                                 'HEADING_MODIFY_USER' => $oTrans->HEADING_MODIFY_USER,
 | 
  
    | 186 |                                 'CANCEL_LINK' => ADMIN_URL.'/users/index.php',
 | 
  
    | 187 |                                 )
 | 
  
    | 188 |                         );
 | 
  
    | 189 | 
 | 
  
    | 190 |             $template->set_block( 'user_add_block', '');
 | 
  
    | 191 |             // Parse template object
 | 
  
    | 192 |             $template->parse('main', 'main_block', false);
 | 
  
    | 193 |             $template->pparse('output', 'page');
 | 
  
    | 194 |             // Print admin footer
 | 
  
    | 195 |             $admin->print_footer();
 | 
  
    | 196 |             break;
 | 
  
    | 197 |         case 'delete' :
 | 
  
    | 198 |             // Print header
 | 
  
    | 199 |             $admin = new admin('Access', 'users_delete');
 | 
  
    | 200 |             $user_id = intval($admin->checkIDKEY('user_id', 0, $_SERVER['REQUEST_METHOD']));
 | 
  
    | 201 |             // Check if user id is a valid number and doesnt equal 1
 | 
  
    | 202 |             if($user_id == 0){
 | 
  
    | 203 |             $admin->print_error($oTrans->MESSAGE_GENERIC_FORGOT_OPTIONS );
 | 
  
    | 204 |             }
 | 
  
    | 205 |             if( ($user_id < 2 ) )
 | 
  
    | 206 |             {
 | 
  
    | 207 |                 // if($admin_header) { $admin->print_header(); }
 | 
  
    | 208 |                 $admin->print_error($oTrans->MESSAGE_GENERIC_SECURITY_ACCESS, ADMIN_URL  );
 | 
  
    | 209 |             }
 | 
  
    | 210 |             $sql  = 'SELECT `active` FROM `'.TABLE_PREFIX.'users` ';
 | 
  
    | 211 |             $sql .= 'WHERE `user_id` = '.$user_id.'';
 | 
  
    | 212 |             if( ($iDeleteUser = $database->get_one($sql)) == 1 ) {
 | 
  
    | 213 |                 $sMessage = $oTrans->MESSAGE_USERS_DEACTIVATED;
 | 
  
    | 214 |                 // Delete the user
 | 
  
    | 215 |                 $database->query("UPDATE `".TABLE_PREFIX."users` SET `active` = 0 WHERE `user_id` = '".$user_id."' ");
 | 
  
    | 216 |             } else {
 | 
  
    | 217 |                 $sMessage = $oTrans->MESSAGE_USERS_DELETED;
 | 
  
    | 218 |                 $database->query("DELETE FROM `".TABLE_PREFIX."users` WHERE `user_id` = ".$user_id);
 | 
  
    | 219 |             }
 | 
  
    | 220 | 
 | 
  
    | 221 |             if($database->is_error()) {
 | 
  
    | 222 |                 $admin->print_error($database->get_error());
 | 
  
    | 223 |             } else {
 | 
  
    | 224 |                 $admin->print_success($sMessage);
 | 
  
    | 225 |             }
 | 
  
    | 226 |             // Print admin footer
 | 
  
    | 227 |             $admin->print_footer();
 | 
  
    | 228 |             break;
 | 
  
    | 229 |     default:
 | 
  
    | 230 |             break;
 | 
  
    | 231 | endswitch;
 |