function secondary_user_groups_page_start() { global $CONFIG, $cpg_udb, $secondary_user_groups_user_groups; if (!$cpg_udb->can_join_tables) { return; } else { define('CAN_JOIN_TABLES', '1'); } $group_id_add = $CONFIG['bridge_enable'] ? 100 : 0; $result = cpg_db_query("SELECT {$cpg_udb->field['grouptbl_group_id']} AS group_id, {$cpg_udb->field['grouptbl_group_name']} AS group_name FROM {$cpg_udb->groupstable}"); while ($row = mysql_fetch_assoc($result)) { $group_names[$row['group_id'] + $group_id_add] = $row['group_name']; } mysql_free_result($result); $users = cpg_db_fetch_rowset(cpg_db_query("SELECT {$cpg_udb->field['user_id']} AS user_id FROM {$cpg_udb->usertable}")); foreach ($users as $user) { $group_ids = cpg_get_groups($user['user_id']); foreach ($group_ids as $group_id) { if ($group_names[$group_id]) { $secondary_user_groups_user_groups[$user['user_id']][] = $group_names[$group_id]; } } } }
function list_users($search = '') { global $CONFIG, $cpg_udb, $CPG_PHP_SELF, $LINEBREAK; //, $PHP_SELF; global $lang_usermgr_php, $lang_byte_units, $lang_date, $lang_common, $icon_array; global $lim_user, $number_of_columns, $template_tab_display; global $USER_DATA; $superCage = Inspekt::makeSuperCage(); list($timestamp, $form_token) = getFormToken(); $number_of_columns_minus_one = $number_of_columns - 1; $number_of_columns_minus_three = $number_of_columns - 3; $number_of_columns_minus_four = $number_of_columns - 4; $sort_codes = array('name_a' => 'user_name ASC', 'name_d' => 'user_name DESC', 'group_a' => 'group_name ASC', 'group_d' => 'group_name DESC', 'reg_a' => 'user_regdate ASC', 'reg_d' => 'user_regdate DESC', 'pic_a' => 'pic_count ASC', 'pic_d' => 'pic_count DESC', 'disku_a' => 'disk_usage ASC', 'disku_d' => 'disk_usage DESC', 'lv_a' => 'user_lastvisit ASC', 'lv_d' => 'user_lastvisit DESC'); $sort = 'reg_d'; if ($superCage->get->keyExists('sort') && ($matches = $superCage->get->getMatched('sort', '/^[a-z_]+$/'))) { if ($sort_codes[$matches[0]]) { $sort = $matches[0]; } } $makereadonly = $CONFIG['bridge_enable'] ? 'style="display:none;" disabled="disabled" ' : ''; $user_count = $cpg_udb->get_user_count(); if (!$user_count) { cpg_die(CRITICAL_ERROR, $lang_usermgr_php['err_no_users'], __FILE__, __LINE__); } $user_per_page = 25; $page = $superCage->get->testInt('page') ? $superCage->get->getInt('page') : 1; $lower_limit = ($page - 1) * $user_per_page; $lower_limit = ($page - 1) * $user_per_page; $username = ''; if ($search) { $username = '******' . $search; $users_search = $cpg_udb->get_users(array('users_per_page' => $user_count, 'lower_limit' => 0, 'search' => $search, 'sort' => $sort)); $user_count = count($users_search); } $tab_tmpl = $template_tab_display; $tab_tmpl['page_link'] = strtr($tab_tmpl['page_link'], array('{LINK}' => 'usermgr.php?sort=' . $sort . '&page=%d' . $username)); $tab_tmpl['left_text'] = strtr($tab_tmpl['left_text'], array('{LEFT_TEXT}' => $lang_usermgr_php['u_user_on_p_pages'])); $users = $cpg_udb->get_users(array('users_per_page' => $user_per_page, 'lower_limit' => $lower_limit, 'search' => $search, 'sort' => $sort)); $total_pages = ceil($user_count / $user_per_page); $tabs = create_tabs($user_count, $page, $total_pages, $tab_tmpl); $lb = '<span id="album_listbox_wrapper" style="display:none">'; $lb .= $lang_usermgr_php['sort_by'] . ': '; $lb .= "<select name=\"album_listbox\" id=\"album_listbox\" class=\"listbox\" onchange=\"if(this.options[this.selectedIndex].value) window.location.href='{$CPG_PHP_SELF}?page={$page}&sort='+this.options[this.selectedIndex].value;\">" . $LINEBREAK; foreach ($sort_codes as $key => $value) { $selected = $key == $sort ? 'selected="selected"' : ""; $lb .= ' <option value="' . $key . '" ' . $selected . '>' . $lang_usermgr_php[$key] . '</option>' . $LINEBREAK; } $lb .= '</select>' . $LINEBREAK; $lb .= '</span>' . $LINEBREAK; echo <<<EOT <script type="text/javascript" language="javascript"> <!-- function selectaction(d,box) { // check if an action has been selected var action = document.editForm.action.value; if (action == '') { return false; } // check if at least one user has been selected var checked_counter = 0; var checked_string = ''; var f = document.editForm; for (i = 0; i < f.length; i++) { if (f[i].type == "checkbox" && f[i].name.indexOf(box) >= 0) { if (f[i].checked) { checked_counter = checked_counter + 1; if (checked_string == '') { checked_string = f[i].name; } else { checked_string = checked_string + ',' + f[i].name; } } } } if (checked_counter == 0) { document.editForm.action.value = ''; alert('{$lang_usermgr_php['alert_no_selection']}'); return false; } document.editForm.id.value = checked_string; document.editForm.new_password.style.display = "none"; document.editForm.group.style.display = "none"; document.editForm.go.style.display = "none"; document.editForm.delete_files.style.display = "none"; document.editForm.delete_comments.style.display = "none"; switch(document.editForm.action.value) { case "delete": document.editForm.delete_files.style.display = "inline"; document.editForm.delete_comments.style.display = "inline"; document.editForm.go.style.display = "inline"; break; case "reset_password": document.editForm.new_password.style.display = "inline"; document.editForm.go.style.display = "inline"; break; case "change_group": document.editForm.new_password.value = ''; document.editForm.group.style.display = "inline"; if (document.editForm.group.value != '') { document.editForm.submit(); } break; case "add_group": document.editForm.new_password.value = ''; document.editForm.group.style.display = "inline"; if (document.editForm.group.value != '') { document.editForm.submit(); } break; default: document.editForm.new_password.value = ''; document.editForm.submit(); break; } } addonload("show_section('album_listbox_wrapper')"); addonload("show_section('checkAll')"); addonload("show_section('checkAll2')"); addonload("show_section('action')"); --> </script> EOT; echo '<form method="get" action="delete.php" name="editForm" id="cpgform">'; if ($superCage->post->keyExists('username')) { $search_filter = '<td align="center">' . $lang_usermgr_php['search_result'] . $superCage->post->getEscaped('username') . '</td>'; } else { $search_filter = ''; } $help = ' ' . cpg_display_help('f=users.htm&as=user_cp&ae=user_cp_end&top=1', '650', '500'); $usermgr_table_header = <<<EOT <input type="hidden" name="id" value="" /> <table border="0" cellspacing="0" cellpadding="0" width="100%"> <tr> <td> EOT; if (!$lim_user) { $usermgr_table_header .= cpg_fetch_icon('user_mgr', 2) . $lang_usermgr_php['user_manager'] . $help; } else { $usermgr_table_header .= cpg_fetch_icon('user_mgr', 2) . $lang_usermgr_php['memberlist']; } $usermgr_table_header .= <<<EOT </td> {$search_filter} <td class="sortorder_options" align="right"> {$lb} </td> </tr> </table> EOT; starttable('100%', $usermgr_table_header, $number_of_columns); // Accept header addons echo CPGPluginAPI::filter('usermgr_header', ''); if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_header = ''; } else { $pictures_quota_header = <<<EOT <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['pictures']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=pic_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['pic_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=pic_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['pic_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['disk_space_used']}/{$lang_usermgr_php['disk_space_quota']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=disku_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['disku_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=disku_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['disku_d']}" /></a> </td> EOT; } if (!$lim_user) { echo <<<EOT <tr> <td class="tableh1" align="center"> <input type="checkbox" {$makereadonly}name="checkAll" id="checkAll" onclick="selectAll('cpgform');" class="checkbox" title="{$lang_common['check_uncheck_all']}" style="display:none" /> </td> <td class="tableh1" colspan="2"> <span class="statlink">{$lang_usermgr_php['name']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['status']}</span> </td> <td class="tableh1"> <span class="statlink"><a href="groupmgr.php" class="statlink">{$lang_usermgr_php['group']}</a></span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['registered_on']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['last_visit']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['comments']}</span> </td> {$pictures_quota_header} </tr> EOT; } else { echo <<<EOT <tr> <td class="tableh1" colspan="2"> <span class="statlink">{$lang_usermgr_php['name']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['status']}</span> </td> <td class="tableh1"><span class="statlink">{$lang_usermgr_php['group']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['registered_on']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['last_visit']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['comments']}</span> </td> {$pictures_quota_header} </tr> EOT; } $loop_counter = 0; // query total number of files uploaded $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} LIMIT 1"); $tempPicCount = mysql_fetch_array($result); $totalPictureCount = $tempPicCount[0]; $totalPictureCount_fmt = cpg_float2decimal($totalPictureCount); mysql_free_result($result); unset($tempPicCount); // query total space used $result = cpg_db_query("SELECT SUM(total_filesize) FROM {$CONFIG['TABLE_PICTURES']} LIMIT 1"); $tempSpaceCount = mysql_fetch_array($result); $totalSpaceCount = $tempSpaceCount[0]; $totalSpaceCount_fmt = cpg_format_bytes($totalSpaceCount); mysql_free_result($result); unset($tempSpaceCount); // query total number of comments posted $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} LIMIT 1"); $tempCommentCount = mysql_fetch_array($result); $totalCommentCount = $tempCommentCount[0]; $totalCommentCount_fmt = cpg_float2decimal($totalCommentCount); mysql_free_result($result); unset($tempCommentCount); foreach ($users as $user) { if ($loop_counter == 0) { $row_style_class = 'tableb'; } else { $row_style_class = 'tableb tableb_alternate'; } $loop_counter++; if ($loop_counter > 1) { $loop_counter = 0; } if ($user['disk_usage'] == '') { $user['disk_usage'] = 0; } $group_quota_separator = '/'; // Determine actual quota if user belongs to more than one user group if ($user_groups = cpg_get_groups($user['user_id'])) { $quota = mysql_fetch_assoc(cpg_db_query("SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_quota >= 0 AND group_id IN (" . implode(", ", $user_groups) . ")")); $user['group_quota'] = $quota["disk_min"] ? $quota["disk_max"] : 0; } if ($user['group_quota']) { $disk_usage_output = theme_display_bar($user['disk_usage'], $user['group_quota'], 150, '', '', $group_quota_separator . $user['group_quota'] . ' ' . $lang_byte_units[1], 'red', 'green'); } else { $disk_usage_output = theme_display_bar($user['disk_usage'], $user['group_quota'], 150, '', '', ' ' . $lang_byte_units[1], 'green', 'green'); } if ($user['user_active'] == 'NO') { //$user['group_name'] = '<i>' . $lang_usermgr_php['inactive'] . '</i>'; $user['status'] = cpg_fetch_icon('offline', 0, $lang_usermgr_php['status_inactive']); $action = 'activate'; } else { $user['status'] = cpg_fetch_icon('online', 0, $lang_usermgr_php['status_active']); $action = 'deactivate'; } if (!$lim_user) { $user['status'] = '<a href="delete.php?id=u' . $user['user_id'] . '&album_listbox=' . $sort . '&action=' . $action . '&what=user&form_token=' . $form_token . '&timestamp=' . $timestamp . '" title="">' . $user['status'] . '</a>'; } $user['user_regdate'] = localised_date($user['user_regdate'], $lang_date['register']); if ($user['user_lastvisit']) { $user['user_lastvisit'] = localised_date($user['user_lastvisit'], $lang_date['register']); } else { $user['user_lastvisit'] = $lang_usermgr_php['never']; } $view_profile = '<a href="profile.php?uid=' . $user['user_id'] . '">' . cpg_fetch_icon('my_profile', 0, $lang_usermgr_php['view_profile']) . '</a>'; if ($user['pic_count']) { $last_uploads = '<a href="thumbnails.php?album=lastupby&uid=' . $user['user_id'] . '">' . cpg_fetch_icon('last_uploads', 0, $lang_usermgr_php['latest_upload']) . '</a>'; } else { if ($lim_user == 0) { $last_uploads = cpg_fetch_icon('last_uploads_disabled', 0, $lang_usermgr_php['no_latest_upload']); } else { $last_uploads = cpg_fetch_icon('blank', 0); } } // fetch number of comments and add link to comments if applicable if ($lim_user == 0) { $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE author_id = {$user['user_id']}"); // display all comments for the admin } else { $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE author_id = {$user['user_id']} AND approval = 'YES' "); // only display approved comments for non-admin } $commentCount = mysql_fetch_array($result); $user['comment_num'] = $commentCount[0]; mysql_free_result($result); if ($user['comment_num'] > 0) { $user_comment_link = '<a href="thumbnails.php?album=lastcomby&uid=' . $user['user_id'] . '">' . cpg_fetch_icon('comment', 0, $lang_usermgr_php['last_comments'] . '(' . $user['comment_num'] . ')') . '</a>'; } else { $user_comment_link = cpg_fetch_icon('blank', 0, $lang_usermgr_php['no_last_comments']); } // create comments bar $comment_quota_output = theme_display_bar($user['comment_num'], $totalCommentCount, 60, '', '', '', 'red', ''); // create files bar $file_quota_output = theme_display_bar($user['pic_count'], $totalPictureCount, 60, '', '', '', 'red', ''); // Look up banned table if (mysql_num_rows(cpg_db_query("SELECT user_name FROM {$CONFIG['TABLE_BANNED']} WHERE user_name = '" . addslashes($user['user_name']) . "' AND brute_force=0 LIMIT 1"))) { $ban_user_link = '<a href="banning.php">' . cpg_fetch_icon('ban_user_disabled', 0, $lang_usermgr_php['user_is_banned']) . '</a>'; $ban_memberlist = cpg_fetch_icon('ban_user_disabled', 0, $lang_usermgr_php['user_is_banned']); } else { $ban_user_link = '<a href="banning.php?ban_user='******'user_id'] . '">' . cpg_fetch_icon('ban_user', 0, $lang_usermgr_php['ban_user']) . '</a>'; $ban_memberlist = ''; } if (!$lim_user) { if ($user['user_id'] == $USER_DATA['user_id']) { $profile_link = 'profile.php?op=edit_profile'; $checkbox_html = ''; $ban_user_link = cpg_fetch_icon('blank', 0); } else { $profile_link = $CPG_PHP_SELF . '?op=edit&user_id=' . $user['user_id'] . '&form_token=' . $form_token . '&timestamp=' . $timestamp; $checkbox_html = '<input name="u' . $user['user_id'] . '" ' . $makereadonly . 'type="checkbox" value="" class="checkbox" />'; } $profile_link = '<a href="' . $profile_link . '">' . cpg_fetch_icon('edit', 0, $lang_usermgr_php['edit_profile']) . '</a>'; if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_data = ''; } else { $pictures_quota_data = <<<EOT <td class="{$row_style_class}" align="right">{$file_quota_output}</td> <td class="{$row_style_class}" align="center">{$disk_usage_output}</td> EOT; } echo <<<EOT <tr> <td class="{$row_style_class}" align="center">{$checkbox_html}</td> <td class="{$row_style_class}">{$user['user_name']}</td> <td class="{$row_style_class}" align="left"> {$view_profile} {$profile_link} {$last_uploads} {$ban_user_link} {$user_comment_link} </td> <td class="{$row_style_class}">{$user['status']}</td> <td class="{$row_style_class}">{$user['group_name']}</td> <td class="{$row_style_class}">{$user['user_regdate']}</td> <td class="{$row_style_class}">{$user['user_lastvisit']}</td> <td class="{$row_style_class}" align="right">{$comment_quota_output}</td> {$pictures_quota_data} </tr> EOT; } else { if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_data = ''; } else { $pictures_quota_data = <<<EOT <td class="{$row_style_class}" align="right">{$user['pic_count']}</td> <td class="{$row_style_class}" align="center">{$disk_usage_output}</td> EOT; } echo <<<EOT <tr> <td class="{$row_style_class}">{$user['user_name']}</td> <td class="{$row_style_class}">{$view_profile}{$last_uploads}{$user_comment_link}</td> <td class="{$row_style_class}">{$user['status']}{$ban_memberlist}</td> <td class="{$row_style_class}">{$user['group_name']}</td> <td class="{$row_style_class}">{$user['user_regdate']}</td> <td class="{$row_style_class}">{$user['user_lastvisit']}</td> <td class="{$row_style_class}" align="right">{$user['comment_num']}</td> {$pictures_quota_data} </tr> EOT; } } // while //mysql_free_result($result); if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_footer = ''; } else { $pictures_quota_footer = <<<EOT <td align="right" class="tablef">{$totalPictureCount_fmt}</td> <td align="right" class="tablef">{$totalSpaceCount_fmt}</td> EOT; } if (!$lim_user) { if ($search) { $search_string_default = 'value="' . $search . '"'; } else { $search_string_default = 'value="' . $lang_usermgr_php['search'] . '" onfocus="this.value=\'\'"'; } $help = cpg_display_help('f=users.htm&as=user_cp_search&ae=user_cp_search_end&top=1', '400', '150'); echo <<<EOT <tr> <td class="tablef" align="center"><input type="checkbox" name="checkAll2" id="checkAll2" {$makereadonly}onclick="selectAll('cpgform');" class="checkbox" title="{$lang_common['check_uncheck_all']}" style="display:none" /></td> <td colspan="{$number_of_columns_minus_four}" class="tablef"> <table cellpadding="0" cellspacing="0" width="100%" border="0"> <tr> <td align="left"> <select name="action" id="action" size="1" class="listbox" {$makereadonly}onchange="return selectaction(this,'u');" style="display:none"> <option value="" selected="selected">{$lang_usermgr_php['with_selected']}</option> <option value="delete">{$lang_common['delete']}</option> <option value="activate">{$lang_usermgr_php['activate']}</option> <option value="deactivate">{$lang_usermgr_php['deactivate']}</option> <option value="reset_password">{$lang_usermgr_php['reset_password']}</option> <option value="change_group">{$lang_usermgr_php['change_primary_membergroup']}</option> <option value="add_group">{$lang_usermgr_php['add_secondary_membergroup']}</option> </select> <input type="hidden" name="what" value="user"/> <input type="text" name="new_password" value="{$lang_usermgr_php['password']}" size="8" maxlength="25" class="textinput" onfocus="this.value='';" style="display:none" /> <select name="group" size="1" class="listbox" style="display:none" onchange="return selectaction(this,'u');"> <option value="">{$lang_usermgr_php['select_group']}</option> EOT; $sql = "SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} ORDER BY group_name"; $result = cpg_db_query($sql); $group_list = cpg_db_fetch_rowset($result); mysql_free_result($result); if (isset($element[1])) { $sel_group = $user_data[$element[1]]; } else { $sel_group = ''; } foreach ($group_list as $group) { if ($group['group_id'] != 3) { print ' <option value="' . $group['group_id'] . '"' . ($group['group_id'] == $sel_group ? ' selected' : '') . '>' . $group['group_name'] . '</option>' . $LINEBREAK; } } $help_create = ' ' . cpg_display_help('f=users.htm&as=user_cp_new&ae=user_cp_new_end', '600', '250'); $create_new_user_icon = cpg_fetch_icon('add_user', 2); list($timestamp, $form_token) = getFormToken(); echo <<<EOT </select> <select name="delete_files" size="1" class="listbox" style="display:none"> <option value="no">{$lang_usermgr_php['delete_files_no']}</option> <option value="yes">{$lang_usermgr_php['delete_files_yes']}</option> </select> <select name="delete_comments" size="1" class="listbox" style="display:none"> <option value="no">{$lang_usermgr_php['delete_comments_no']}</option> <option value="yes">{$lang_usermgr_php['delete_comments_yes']}</option> </select> <button type="submit" class="button" name="go" value="{$lang_usermgr_php['submit']}" style="display:none">{$icon_array['ok']}{$lang_usermgr_php['submit']}</button> </td> </tr> </table> <input type="hidden" name="form_token" value="{$form_token}" /> <input type="hidden" name="timestamp" value="{$timestamp}" /> </td> <td align="right" class="tablef">{$totalCommentCount_fmt}</td> {$pictures_quota_footer} </tr> EOT; endtable(); echo '</form>'; starttable('100%'); echo <<<EOT <tr> <td colspan="{$number_of_columns}" class="tablef" align="center" valign="middle"> <table border="0" cellspacing="0" cellpadding="0" width="100%"> <tr> <td class="tablef" align="center" valign="middle"> <form method="post" action="{$CPG_PHP_SELF}" name="searchUser" id="cpgform2"> <input type="text" name="username" class="textinput" {$search_string_default} /> <button type="submit" class="button" name="user_search" value="{$lang_usermgr_php['search_submit']}">{$icon_array['search']}{$lang_usermgr_php['search_submit']}</button> {$help} </form> </td> <td class="tablef" align="center" valign="middle"> <a href="{$CPG_PHP_SELF}?op=new_user&form_token={$form_token}&timestamp={$timestamp}" {$makereadonly}class="admin_menu">{$create_new_user_icon}{$lang_usermgr_php['create_new_user']}</a> {$help_create} </td> </tr> </table> </td> </tr> EOT; } else { echo <<<EOT <tr> <td colspan="{$number_of_columns_minus_three}" class="tablef" align="left" valign="middle"> {$lang_usermgr_php['total']} </td> <td class="tablef" align="right" valign="middle"> {$totalCommentCount_fmt} </td> {$pictures_quota_footer} </tr> EOT; } // Accept footer addons for the user manager echo CPGPluginAPI::filter('usermgr_footer', ''); if ($tabs) { echo <<<EOT <tr> <td colspan="{$number_of_columns}" style="padding: 0px;"> <table width="100%" cellspacing="0" cellpadding="0"> <tr> {$tabs} </tr> </table> </td> </tr> EOT; } endtable(); }