$sort_item = 'username';
}
for ($i = 97; $i <= 122; $i++) {
$proof .= " AND u.username NOT LIKE '" . chr($i) . "%' ";
}
$alpha_where = $alphanum == '0' ? $proof : ($alphanum != '' ? "AND u.username LIKE '" . $db->sql_escape($alphanum) . "%'" : '');
$user_where = !empty($user_search) ? " AND u.username LIKE ('" . $db->sql_escape($user_search) . "'%)" : '';
$per_page = $config['topics_per_page'];
if ($sort_item == 'user_modules') {
$sql = "SELECT u.username, u.user_id, u.user_active, u.user_color, u.user_rank, u.user_allow_pm, u.user_allowavatar\n\t\t\tFROM " . USERS_TABLE . " u, " . JR_ADMIN_TABLE . " j\n\t\t\tWHERE u.user_id <> " . ANONYMOUS . "\n\t\t\t{$alpha_where}\n\t\t\t{$user_where}\n\t\t\t\tAND j.user_id = u.user_id\n\t\t\tORDER BY u.username ASC\n\t\t\tLIMIT {$start}, {$per_page}";
} else {
$sql = "SELECT u.username, u.user_id, u.user_active, u.user_color, u.user_rank, u.user_allow_pm, u.user_allowavatar\n\t\t\tFROM " . USERS_TABLE . " u\n\t\t\tWHERE u.user_id <> " . ANONYMOUS . "\n\t\t\t{$alpha_where}\n\t\t\t{$user_where}\n\t\t\tORDER BY u." . $sort_item . " " . $order . "\n\t\t\tLIMIT {$start}, {$per_page}";
}
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$jr_admin_row = jr_admin_get_user_info($row['user_id']);
$module_count = !empty($jr_admin_row['user_jr_admin']) ? sizeof(explode(EXPLODE_SEPARATOR_CHAR, $jr_admin_row['user_jr_admin'])) : 0;
$block_text = 'userrow';
$template->assign_block_vars($block_text, array('USERNAME_FULL' => colorize_username($row['user_id'], $row['username'], $row['user_color'], $row['user_active']), 'NAME' => $row['username'], 'ID' => $row['user_id'], 'ALLOW_PM' => $row['user_allow_pm'] ? 'checked="checked"' : '', 'ALLOW_AVATAR' => $row['user_allowavatar'] ? 'checked="checked"' : '', 'ACTIVE' => $row['user_active'] ? 'checked="checked"' : '', 'ROW_CLASS' => $i++ % 2 ? 'row1' : 'row2', 'RANK_LIST' => jr_admin_make_rank_list($row['user_id'], $row['user_rank']), 'BOOKMARK' => !$assigned_current_letter_link ? '<a name="' . $current_letter . '">' : '', 'BOOKMARK_END' => !$assigned_current_letter_link ? '</a>' : '', 'MODULES' => $module_count != 0 ? sprintf($lang['Modules_Owned'], $module_count) : ' ', 'MODULE_COUNT' => $module_count != 0 ? sprintf($lang['Modules_Owned'], $module_count) : ''));
//We 'know' we assigned it if it wasn't already now
$assigned_current_letter_link = true;
}
if ($sort_item == 'user_modules') {
$sql = "SELECT u.user_id\n\t\t\tFROM " . USERS_TABLE . " u, " . JR_ADMIN_TABLE . " j\n\t\t\tWHERE u.user_id <> " . ANONYMOUS . "\n\t\t\t{$alpha_where}\n\t\t\t{$user_where}\n\t\t\t\tAND j.user_id = u.user_id";
} else {
$sql = "SELECT u.user_id\n\t\t\tFROM " . USERS_TABLE . " u\n\t\t\tWHERE u.user_id <> " . ANONYMOUS . "\n\t\t\t{$alpha_where}\n\t\t\t{$user_where}";
}
$result = $db->sql_query($sql);
$row = $db->sql_numrows($result);
$total_users_count = $row;
$template->assign_vars(array('PAGINATION' => generate_pagination('admin_jr_admin.' . PHP_EXT . '?sort_item=' . $sort_item . '&order=' . $order . '&alphanum=' . $alphanum, $total_users_count, $per_page, $start), 'PAGE_NUMBER' => sprintf($lang['Page_of'], floor($start / $per_page) + 1, ceil($total_users_count / $per_page))));
function jr_admin_make_admin_link()
{
global $lang, $userdata, $phpEx;
if ($userdata['user_level'] == ADMIN) {
return '<a href="admin/index.' . $phpEx . '?sid=' . $userdata['session_id'] . '">' . $lang['Admin_panel'] . '</a><br /><br />';
} elseif ($userdata['user_id'] == ANONYMOUS) {
return '';
} else {
$jr_admin_userdata = jr_admin_get_user_info($userdata['user_id']);
if (!empty($jr_admin_userdata['user_jr_admin'])) {
return '<a href="admin/index.' . $phpEx . '?sid=' . $userdata['session_id'] . '">' . $lang['Admin_panel'] . '</a><br /><br />';
} else {
return '';
}
}
}
//
if (isset($HTTP_GET_VARS['pane']) && $HTTP_GET_VARS['pane'] == 'left') {
/* Orginal phpBB
$dir = @opendir(".");
$setmodules = 1;
while(($file = readdir($dir)) !== false)
{
if( preg_match("/^admin_.*?\." . $phpEx . "$/", $file) )
{
include($file);
}
}
@closedir($dir);
*/
$jr_admin_userdata = jr_admin_get_user_info($userdata['user_id']);
$module = jr_admin_get_module_list($jr_admin_userdata['user_jr_admin']);
//reset($mvModules);
//foreach ($mvModules as $name => $value)
//{
// if ($value['state'] != 1 && $value['state'] != 5)
// continue;
// reset($value['admin']);
// foreach ($value['admin'] as $n => $file)
// {
// include($phpbb_root_path . 'modules/' . $name . '/admin/' . $file);
// }
//}
//unset($setmodules);
include './page_header_admin.' . $phpEx;
$template->set_filenames(array("body" => "index_navigate.tpl"));
function jr_admin_make_admin_link()
{
global $user, $lang;
if (!$user->data['session_logged_in']) {
return ' ';
}
$full_server_url = create_server_url();
if ($user->data['user_level'] == ADMIN) {
return '<a href="' . $full_server_url . ADM . '/index.' . PHP_EXT . '?sid=' . $user->data['session_id'] . '">' . $lang['Admin_panel'] . '</a>';
}
$jr_admin_userdata = jr_admin_get_user_info($user->data['user_id']);
if (!empty($jr_admin_userdata['user_jr_admin'])) {
return '<a href="' . $full_server_url . ADM . '/index.' . PHP_EXT . '?sid=' . $user->data['session_id'] . '">' . $lang['Admin_panel'] . '</a>';
} else {
return ' ';
}
}