 . 'protected.gif){kind=small}
';
$c_filter = '';
# Clean up the form variables
if ( !db_field_exists( $f_sort, $t_user_table ) ) {
$c_sort = 'username';
} else {
$c_sort = addslashes($f_sort);
}
if ($f_dir == 'ASC') {
$c_dir = 'ASC';
} else {
$c_dir = 'DESC';
}
if ($f_hide == 0) { # a 0 will turn it off
$c_hide = 0;
} else { # anything else (including 'on') will turn it on
$c_hide = 1;
}
$t_hide_filter = '&hide=' . $c_hide;
# set cookie values for hide, sort by, and dir
if ( $f_save ) {
$t_manage_string = $c_hide.':'.$c_sort.':'.$c_dir;
gpc_set_cookie( $t_cookie_name, $t_manage_string, true );
} else if ( !is_blank( gpc_get_cookie( $t_cookie_name, '' ) ) ) {
$t_manage_arr = explode( ':', gpc_get_cookie( $t_cookie_name ) );
$f_hide = $t_manage_arr[0];
if ( isset( $t_manage_arr[1] ) ) {
$f_sort = $t_manage_arr[1];
} else {
$f_sort = 'username';
}
if ( isset( $t_manage_arr[2] ) ) {
$f_dir = $t_manage_arr[2];
} else {
$f_dir = 'DESC';
}
}
html_page_top( lang_get( 'manage_users_link' ) );
print_manage_menu( 'manage_user_page.php' );
# New Accounts Form BEGIN
$days_old = 7 * SECONDS_PER_DAY;
$query = "SELECT *
FROM $t_user_table
WHERE ".db_helper_compare_days("" . db_now() . "","date_created","<= $days_old")."
ORDER BY date_created DESC";
$result = db_query_bound( $query );
$g_db->debug=false;
$new_user_count = db_num_rows( $result);
# Never Logged In Form BEGIN
$query = "SELECT *
FROM $t_user_table
WHERE ( login_count = 0 ) AND ( date_created = last_visit )
ORDER BY date_created DESC";
$result = db_query_bound( $query );
$unused_user_count = db_num_rows( $result );
# Manage Form BEGIN
$t_prefix_array = array();
$t_prefix_array['ALL'] = lang_get( 'show_all_users' );
for ( $i = 'A'; $i != 'AA'; $i++ ) {
$t_prefix_array[$i] = $i;
}
for ( $i = 0; $i <= 9; $i++ ) {
$t_prefix_array["$i"] = "$i";
}
$t_prefix_array['UNUSED'] = lang_get( 'users_unused' );
$t_prefix_array['NEW'] = lang_get( 'users_new' );
echo '| '; if ( $t_prefix === $f_filter ) { $c_filter = $f_filter; echo "$t_caption"; } else { print_link( "manage_user_page.php?sort=$c_sort&dir=$c_dir&save=1$t_hide_filter&filter=$t_prefix", $t_caption ); } if ( $t_prefix === 'UNUSED' ) { echo ' [' . $unused_user_count . '] (' . lang_get( 'never_logged_in_title' ) . ')'; } else if ( $t_prefix === 'NEW' ) { echo ' [' . $new_user_count . '] (' . lang_get( '1_week_title' ) . ')'; } echo ' | '; } echo '
| [] | |||||||