@@ -1,9 +1,9 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | if( ! defined('IN_MANAGER_MODE') || IN_MANAGER_MODE !== true) { |
| 3 | - die("<b>INCLUDE_ORDERING_ERROR</b><br /><br />Please use the EVO Content Manager instead of accessing this file directly."); |
|
| 3 | + die("<b>INCLUDE_ORDERING_ERROR</b><br /><br />Please use the EVO Content Manager instead of accessing this file directly."); |
|
| 4 | 4 | } |
| 5 | 5 | if(!$modx->hasPermission('edit_user')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | // initialize page view state - the $_PAGE object |
@@ -11,12 +11,12 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | // get and save search string |
| 13 | 13 | if($_REQUEST['op'] == 'reset') { |
| 14 | - $query = ''; |
|
| 15 | - $_PAGE['vs']['search'] = ''; |
|
| 14 | + $query = ''; |
|
| 15 | + $_PAGE['vs']['search'] = ''; |
|
| 16 | 16 | } else { |
| 17 | - $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | - $sqlQuery = $modx->db->escape($query); |
|
| 19 | - $_PAGE['vs']['search'] = $query; |
|
| 17 | + $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | + $sqlQuery = $modx->db->escape($query); |
|
| 19 | + $_PAGE['vs']['search'] = $query; |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | // get & save listmode |
@@ -120,55 +120,55 @@ discard block |
||
| 120 | 120 | <div class="row"> |
| 121 | 121 | <div class="table-responsive"> |
| 122 | 122 | <?php |
| 123 | - $where = ""; |
|
| 124 | - if(!$modx->hasPermission('save_role')) { |
|
| 125 | - $where .= (empty($where) ? "" : " AND ") . "mua.role != 1"; |
|
| 126 | - } |
|
| 127 | - if(!empty($sqlQuery)) { |
|
| 128 | - $where .= (empty($where) ? "" : " AND ") . "((mu.username LIKE '{$sqlQuery}%') OR (mua.fullname LIKE '%{$sqlQuery}%') OR (mua.email LIKE '{$sqlQuery}%'))"; |
|
| 129 | - } |
|
| 130 | - $ds = $modx->db->select("mu.id, mu.username, rname.name AS role, mua.fullname, mua.email, IF(mua.blocked,'{$_lang['yes']}','-') as blocked, mua.thislogin, mua.logincount", $modx->getFullTableName('manager_users') . " AS mu |
|
| 123 | + $where = ""; |
|
| 124 | + if(!$modx->hasPermission('save_role')) { |
|
| 125 | + $where .= (empty($where) ? "" : " AND ") . "mua.role != 1"; |
|
| 126 | + } |
|
| 127 | + if(!empty($sqlQuery)) { |
|
| 128 | + $where .= (empty($where) ? "" : " AND ") . "((mu.username LIKE '{$sqlQuery}%') OR (mua.fullname LIKE '%{$sqlQuery}%') OR (mua.email LIKE '{$sqlQuery}%'))"; |
|
| 129 | + } |
|
| 130 | + $ds = $modx->db->select("mu.id, mu.username, rname.name AS role, mua.fullname, mua.email, IF(mua.blocked,'{$_lang['yes']}','-') as blocked, mua.thislogin, mua.logincount", $modx->getFullTableName('manager_users') . " AS mu |
|
| 131 | 131 | INNER JOIN " . $modx->getFullTableName('user_attributes') . " AS mua ON mua.internalKey=mu.id |
| 132 | 132 | LEFT JOIN " . $modx->getFullTableName('user_roles') . " AS rname ON mua.role=rname.id", $where, 'mua.blocked ASC, mua.thislogin DESC'); |
| 133 | - include_once MODX_MANAGER_PATH . "includes/controls/datagrid.class.php"; |
|
| 134 | - $grd = new DataGrid('', $ds, $modx->config['number_of_results']); // set page size to 0 t show all items |
|
| 135 | - $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 136 | - $grd->cssClass = "table data"; |
|
| 137 | - $grd->columnHeaderClass = "tableHeader"; |
|
| 138 | - $grd->itemClass = "tableItem"; |
|
| 139 | - $grd->altItemClass = "tableAltItem"; |
|
| 140 | - $grd->fields = "id,username,fullname,role,email,thislogin,logincount,blocked"; |
|
| 141 | - $grd->columns = implode(',', array( |
|
| 142 | - $_lang["icon"], |
|
| 143 | - $_lang["name"], |
|
| 144 | - $_lang["user_full_name"], |
|
| 145 | - $_lang['role'], |
|
| 146 | - $_lang["email"], |
|
| 147 | - $_lang["user_prevlogin"], |
|
| 148 | - $_lang["user_logincount"], |
|
| 149 | - $_lang["user_block"] |
|
| 150 | - )); |
|
| 151 | - $grd->colWidths = "1%,,,,,1%,1%,1%"; |
|
| 152 | - $grd->colAligns = "center,,,,,right' nowrap='nowrap,right,center"; |
|
| 153 | - $grd->colTypes = implode('||', array( |
|
| 154 | - 'template:<a class="gridRowIcon" href="javascript:;" onclick="return showContentMenu([+id+],event);" title="' . $_lang['click_to_context'] . '"><i class="' . $_style['icons_user'] . '"></i></a>', |
|
| 155 | - 'template:<a href="index.php?a=12&id=[+id+]" title="' . $_lang['click_to_edit_title'] . '">[+value+]</a>', |
|
| 156 | - 'template:[+fullname+]', |
|
| 157 | - 'template:[+role+]', |
|
| 158 | - 'template:[+email+]', |
|
| 159 | - 'date: ' . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . ' %H:%M', |
|
| 160 | - 'template:[+logincount+]', |
|
| 161 | - 'template:[+blocked+]' |
|
| 162 | - )); |
|
| 163 | - if($listmode == '1') { |
|
| 164 | - $grd->pageSize = 0; |
|
| 165 | - } |
|
| 166 | - if($_REQUEST['op'] == 'reset') { |
|
| 167 | - $grd->pageNumber = 1; |
|
| 168 | - } |
|
| 169 | - // render grid |
|
| 170 | - echo $grd->render(); |
|
| 171 | - ?> |
|
| 133 | + include_once MODX_MANAGER_PATH . "includes/controls/datagrid.class.php"; |
|
| 134 | + $grd = new DataGrid('', $ds, $modx->config['number_of_results']); // set page size to 0 t show all items |
|
| 135 | + $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 136 | + $grd->cssClass = "table data"; |
|
| 137 | + $grd->columnHeaderClass = "tableHeader"; |
|
| 138 | + $grd->itemClass = "tableItem"; |
|
| 139 | + $grd->altItemClass = "tableAltItem"; |
|
| 140 | + $grd->fields = "id,username,fullname,role,email,thislogin,logincount,blocked"; |
|
| 141 | + $grd->columns = implode(',', array( |
|
| 142 | + $_lang["icon"], |
|
| 143 | + $_lang["name"], |
|
| 144 | + $_lang["user_full_name"], |
|
| 145 | + $_lang['role'], |
|
| 146 | + $_lang["email"], |
|
| 147 | + $_lang["user_prevlogin"], |
|
| 148 | + $_lang["user_logincount"], |
|
| 149 | + $_lang["user_block"] |
|
| 150 | + )); |
|
| 151 | + $grd->colWidths = "1%,,,,,1%,1%,1%"; |
|
| 152 | + $grd->colAligns = "center,,,,,right' nowrap='nowrap,right,center"; |
|
| 153 | + $grd->colTypes = implode('||', array( |
|
| 154 | + 'template:<a class="gridRowIcon" href="javascript:;" onclick="return showContentMenu([+id+],event);" title="' . $_lang['click_to_context'] . '"><i class="' . $_style['icons_user'] . '"></i></a>', |
|
| 155 | + 'template:<a href="index.php?a=12&id=[+id+]" title="' . $_lang['click_to_edit_title'] . '">[+value+]</a>', |
|
| 156 | + 'template:[+fullname+]', |
|
| 157 | + 'template:[+role+]', |
|
| 158 | + 'template:[+email+]', |
|
| 159 | + 'date: ' . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . ' %H:%M', |
|
| 160 | + 'template:[+logincount+]', |
|
| 161 | + 'template:[+blocked+]' |
|
| 162 | + )); |
|
| 163 | + if($listmode == '1') { |
|
| 164 | + $grd->pageSize = 0; |
|
| 165 | + } |
|
| 166 | + if($_REQUEST['op'] == 'reset') { |
|
| 167 | + $grd->pageNumber = 1; |
|
| 168 | + } |
|
| 169 | + // render grid |
|
| 170 | + echo $grd->render(); |
|
| 171 | + ?> |
|
| 172 | 172 | </div> |
| 173 | 173 | </div> |
| 174 | 174 | </div> |
@@ -1,9 +1,9 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | if( ! defined('IN_MANAGER_MODE') || IN_MANAGER_MODE !== true) { |
| 3 | - die("<b>INCLUDE_ORDERING_ERROR</b><br /><br />Please use the EVO Content Manager instead of accessing this file directly."); |
|
| 3 | + die("<b>INCLUDE_ORDERING_ERROR</b><br /><br />Please use the EVO Content Manager instead of accessing this file directly."); |
|
| 4 | 4 | } |
| 5 | 5 | if(!$modx->hasPermission('edit_web_user')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | // initialize page view state - the $_PAGE object |
@@ -11,12 +11,12 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | // get and save search string |
| 13 | 13 | if($_REQUEST['op'] == 'reset') { |
| 14 | - $query = ''; |
|
| 15 | - $_PAGE['vs']['search'] = ''; |
|
| 14 | + $query = ''; |
|
| 15 | + $_PAGE['vs']['search'] = ''; |
|
| 16 | 16 | } else { |
| 17 | - $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | - $sqlQuery = $modx->db->escape($query); |
|
| 19 | - $_PAGE['vs']['search'] = $query; |
|
| 17 | + $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | + $sqlQuery = $modx->db->escape($query); |
|
| 19 | + $_PAGE['vs']['search'] = $query; |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | // get & save listmode |
@@ -120,30 +120,30 @@ discard block |
||
| 120 | 120 | <div class="row"> |
| 121 | 121 | <div class="table-responsive"> |
| 122 | 122 | <?php |
| 123 | - $ds = $modx->db->select("wu.id, wu.username, wua.fullname, wua.email, wua.lastlogin, wua.logincount, IF(wua.blocked,'{$_lang['yes']}','-') as 'blocked'", $modx->getFullTableName("web_users") . " wu |
|
| 123 | + $ds = $modx->db->select("wu.id, wu.username, wua.fullname, wua.email, wua.lastlogin, wua.logincount, IF(wua.blocked,'{$_lang['yes']}','-') as 'blocked'", $modx->getFullTableName("web_users") . " wu |
|
| 124 | 124 | INNER JOIN " . $modx->getFullTableName("web_user_attributes") . " wua ON wua.internalKey=wu.id", ($sqlQuery ? "(wu.username LIKE '{$sqlQuery}%') OR (wua.fullname LIKE '%{$sqlQuery}%') OR (wua.email LIKE '%{$sqlQuery}%')" : ""), 'username'); |
| 125 | - include_once MODX_MANAGER_PATH . "includes/controls/datagrid.class.php"; |
|
| 126 | - $grd = new DataGrid('', $ds, $number_of_results); // set page size to 0 t show all items |
|
| 127 | - $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 128 | - $grd->cssClass = "table data"; |
|
| 129 | - $grd->columnHeaderClass = "tableHeader"; |
|
| 130 | - $grd->itemClass = "tableItem"; |
|
| 131 | - $grd->altItemClass = "tableAltItem"; |
|
| 132 | - $grd->fields = "id,username,fullname,email,lastlogin,logincount,blocked"; |
|
| 133 | - $grd->columns = $_lang["icon"] . " ," . $_lang["name"] . " ," . $_lang["user_full_name"] . " ," . $_lang["email"] . " ," . $_lang["user_prevlogin"] . " ," . $_lang["user_logincount"] . " ," . $_lang["user_block"]; |
|
| 134 | - $grd->colWidths = "1%,,,,1%,1%,1%"; |
|
| 135 | - $grd->colAligns = "center,,,,right' nowrap='nowrap,right,center"; |
|
| 136 | - $grd->colTypes = "template:<a class='gridRowIcon' href='javascript:;' onclick='return showContentMenu([+id+],event);' title='" . $_lang["click_to_context"] . "'><i class='" . $_style["icons_user"] . "'></i></a>||template:<a href='index.php?a=88&id=[+id+]' title='" . $_lang["click_to_edit_title"] . "'>[+value+]</a>||template:[+fullname+]||template:[+email+]||date: " . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . |
|
| 137 | - " %H:%M"; |
|
| 138 | - if($listmode == '1') { |
|
| 139 | - $grd->pageSize = 0; |
|
| 140 | - } |
|
| 141 | - if($_REQUEST['op'] == 'reset') { |
|
| 142 | - $grd->pageNumber = 1; |
|
| 143 | - } |
|
| 144 | - // render grid |
|
| 145 | - echo $grd->render(); |
|
| 146 | - ?> |
|
| 125 | + include_once MODX_MANAGER_PATH . "includes/controls/datagrid.class.php"; |
|
| 126 | + $grd = new DataGrid('', $ds, $number_of_results); // set page size to 0 t show all items |
|
| 127 | + $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 128 | + $grd->cssClass = "table data"; |
|
| 129 | + $grd->columnHeaderClass = "tableHeader"; |
|
| 130 | + $grd->itemClass = "tableItem"; |
|
| 131 | + $grd->altItemClass = "tableAltItem"; |
|
| 132 | + $grd->fields = "id,username,fullname,email,lastlogin,logincount,blocked"; |
|
| 133 | + $grd->columns = $_lang["icon"] . " ," . $_lang["name"] . " ," . $_lang["user_full_name"] . " ," . $_lang["email"] . " ," . $_lang["user_prevlogin"] . " ," . $_lang["user_logincount"] . " ," . $_lang["user_block"]; |
|
| 134 | + $grd->colWidths = "1%,,,,1%,1%,1%"; |
|
| 135 | + $grd->colAligns = "center,,,,right' nowrap='nowrap,right,center"; |
|
| 136 | + $grd->colTypes = "template:<a class='gridRowIcon' href='javascript:;' onclick='return showContentMenu([+id+],event);' title='" . $_lang["click_to_context"] . "'><i class='" . $_style["icons_user"] . "'></i></a>||template:<a href='index.php?a=88&id=[+id+]' title='" . $_lang["click_to_edit_title"] . "'>[+value+]</a>||template:[+fullname+]||template:[+email+]||date: " . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . |
|
| 137 | + " %H:%M"; |
|
| 138 | + if($listmode == '1') { |
|
| 139 | + $grd->pageSize = 0; |
|
| 140 | + } |
|
| 141 | + if($_REQUEST['op'] == 'reset') { |
|
| 142 | + $grd->pageNumber = 1; |
|
| 143 | + } |
|
| 144 | + // render grid |
|
| 145 | + echo $grd->render(); |
|
| 146 | + ?> |
|
| 147 | 147 | </div> |
| 148 | 148 | </div> |
| 149 | 149 | </div> |