.
/**
* @package MantisBT
* @copyright Copyright (C) 2002 - 2009 MantisBT Team - mantisbt-dev@lists.sourceforge.net
* @link http://www.mantisbt.org
*/
/**
* MantisBT Core API's
*/
require_once( 'core.php' );
/**
* requires tag_api
*/
require_once( 'tag_api.php' );
require_once( 'user_pref_api.php' );
require_once( 'form_api.php' );
access_ensure_global_level( config_get( 'tag_view_threshold' ) );
compress_enable();
html_page_top( lang_get( 'manage_tags_link' ) );
print_manage_menu( 'manage_tags_page.php' );
$t_can_edit = access_has_global_level( config_get( 'tag_edit_threshold' ) );
$f_filter = utf8_strtoupper( gpc_get_string( 'filter', config_get( 'default_manage_tag_prefix' ) ) );
$f_page_number = gpc_get_int( 'page_number', 1 );
$t_tag_table = db_get_table( 'mantis_tag_table' );
# Start Index Menu
$t_prefix_array = array( 'ALL' );
for ( $i = 'A'; $i != 'AA'; $i++ ) {
$t_prefix_array[] = $i;
}
for ( $i = 0; $i <= 9; $i++ ) {
$t_prefix_array[] = "$i";
}
echo '
';
foreach ( $t_prefix_array as $t_prefix ) {
if ( $t_prefix === 'ALL' ) {
$t_caption = lang_get( 'show_all_tags' );
} else {
$t_caption = $t_prefix;
}
if ( $t_prefix == $f_filter ) {
$t_link = "$t_caption";
} else {
$t_link = '' . $t_caption . '';
}
echo '| ' . $t_link . ' | ';
}
echo '
';
$t_where_params = array();
if ( $f_filter === 'ALL' ) {
$t_where = '';
} else {
$t_where_params[] = $f_filter . '%';
$t_where = 'WHERE ' . db_helper_like( 'name' );
}
# Set the number of Tags per page.
$t_per_page = 20;
$t_offset = (( $f_page_number - 1 ) * $t_per_page );
# Determine number of tags in tag table
$t_total_tag_count = 0;
$t_result = '';
$t_query = "SELECT count(*)
FROM $t_tag_table
$t_where";
$t_result = db_query_bound( $t_query, $t_where_params );
$t_row = db_fetch_array( $t_result );
$t_total_tag_count = (int)db_result( $t_result );
#Number of pages from result
$t_page_count = ceil( $t_total_tag_count / $t_per_page );
if ( $t_page_count < 1 ) {
$t_page_count = 1;
}
# Make sure $p_page_number isn't past the last page.
if ( $f_page_number > $t_page_count ) {
$f_page_number = $t_page_count;
}
# Make sure $p_page_number isn't before the first page
if ( $f_page_number < 1 ) {
$f_page_number = 1;
}
# Retrive Tags from tag table
$t_query = "SELECT *
FROM $t_tag_table
$t_where ORDER BY name";
$t_result = db_query_bound( $t_query, $t_where_params, $t_per_page, $t_offset );
?>