# Mantis - a php based bugtracking system

# Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org

# Copyright (C) 2002 - 2007  Mantis Team   - mantisbt-dev@lists.sourceforge.net

# Mantis is free software: you can redistribute it and/or modify

# it under the terms of the GNU General Public License as published by

# the Free Software Foundation, either version 2 of the License, or

# (at your option) any later version.

#

# Mantis is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with Mantis.  If not, see <http://www.gnu.org/licenses/>.

	#------------------------------

	#   $Revision: 2643 $

	#     $Author: al $    

	#       $Date: 2009-06-18 19:06:27 -0400 (Thu, 18 Jun 2009) $  

	#------------------------------

	$t_core_dir = dirname( __FILE__ ).DIRECTORY_SEPARATOR;

	require_once( $t_core_dir . 'ajax_api.php' );

	require_once( $t_core_dir . 'current_user_api.php' );

	require_once( $t_core_dir . 'string_api.php' );

	require_once( $t_core_dir . 'prepare_api.php' );

	require_once( $t_core_dir . 'profile_api.php' );

	require_once( $t_core_dir . 'last_visited_api.php' );

	### Print API ###

	# this file handles printing functions

	# --------------------

	# Print the headers to cause the page to redirect to $p_url

	# If $p_die is true (default), terminate the execution of the script

	#  immediately

	# If we have handled any errors on this page and the 'stop_on_errors' config

	#  option is turned on, return false and don't redirect.

	# $p_sanitize - true/false - true in the case where the URL is extracted from GET/POST or untrusted source.

	# This would be false if the URL is trusted (e.g. read from config_inc.php).

	function print_header_redirect( $p_url, $p_die = true, $p_sanitize = false ) {

		$t_use_iis = config_get( 'use_iis');

		if ( ON == config_get( 'stop_on_errors' ) && error_handled() ) {

			return false;

		}

		# validate the url as part of this site before continuing

		$t_url = $p_sanitize ? string_sanitize_url( $p_url ) : $p_url;

		# don't send more headers if they have already been sent (guideweb)

		if ( ! headers_sent() ) {

			header( 'Content-Type: text/html; charset=' . lang_get( 'charset' ) );

			if ( ON == $t_use_iis ) {

				header( "Refresh: 0;url=$t_url" );

			} else {

				header( "Location: $t_url" );

			}

		} else {

			trigger_error( ERROR_PAGE_REDIRECTION, ERROR );

			return false;

		}

		if ( $p_die ) {

			die; # additional output can cause problems so let's just stop output here

		}

		return true;

	}

	# --------------------

	# Print a redirect header to view a bug

	function print_header_redirect_view( $p_bug_id ) {

		print_header_redirect( string_get_bug_view_url( $p_bug_id ) );

	}

	# --------------------

	# Get a view URL for the bug id based on the user's preference and

	#  call print_successful_redirect() with that URL

	function print_successful_redirect_to_bug( $p_bug_id ) {

		$t_url = string_get_bug_view_url( $p_bug_id, auth_get_current_user_id() );

		print_successful_redirect( $t_url );

	}

	# --------------------

	# If the show query count is ON, print success and redirect after the

	#  configured system wait time.

	# If the show query count is OFF, redirect right away.

	function print_successful_redirect( $p_redirect_to ) {

		if ( helper_show_queries() ) {

			html_meta_redirect( $p_redirect_to );

			html_page_top1();

			html_page_top2();

			PRINT '
';

			PRINT '
' . lang_get( 'operation_successful' ) . '
';

			print_bracket_link( $p_redirect_to, lang_get( 'proceed' ) );

			PRINT '';

			html_page_bottom1();

		} else {

			print_header_redirect( $p_redirect_to );

		}

	}

	# --------------------

	# Print a redirect header to update a bug

	function print_header_redirect_update( $p_bug_id ) {

		print_header_redirect( string_get_bug_update_url( $p_bug_id ) );

	}

	# --------------------

	# Print a redirect header to update a bug

	function print_header_redirect_report() {

		print_header_redirect( string_get_bug_report_url() );

	}

	# Print avatar image for the given user ID

	function print_avatar( $p_user_id ) {

		if ( !user_exists( $p_user_id ) ) {

			return;

		}

		if ( access_has_project_level( config_get( 'show_avatar_threshold' ), null, $p_user_id ) ) {

			$t_avatar = user_get_avatar( $p_user_id );

			if ( false !== $t_avatar ) {

				$t_avatar_url = $t_avatar[0];

				$t_width = $t_avatar[1];

				$t_height = $t_avatar[2];

				echo '' .

					'

					' width="' . $t_width . '" height="' . $t_height . '" />';

			}

		}

	}

	# --------------------

	# prints the name of the user given the id.  also makes it an email link.

	function print_user( $p_user_id ) {

	    echo prepare_user_name( $p_user_id );

	}

	# --------------------

	# same as print_user() but fills in the subject with the bug summary

	function print_user_with_subject( $p_user_id, $p_bug_id ) {

		$c_user_id = db_prepare_int( $p_user_id );

		if ( NO_USER == $p_user_id ) {

			return;

		}

		$t_username = user_get_name( $p_user_id );

		if ( user_exists( $p_user_id ) && user_get_field( $p_user_id, 'enabled' ) ) {

			$t_email = user_get_field( $p_user_id, 'email' );

			print_email_link_with_subject( $t_email, $t_username, $p_bug_id );

		} else {

			echo '<font STYLE="text-decoration: line-through">';

			echo $t_username;

			echo '</font>';

		}

	}

	# --------------------

	function print_duplicate_id( $p_duplicate_id ) {

		if ( $p_duplicate_id != 0 ) {

			PRINT string_get_bug_view_link( $p_duplicate_id );

		}

	}

	# --------------------

	# print out an email editing input

	function print_email_input( $p_field_name, $p_email ) {

		$t_limit_email_domain = config_get( 'limit_email_domain' );

		if ( $t_limit_email_domain ) {

			# remove the domain part

			$p_email = eregi_replace( "@$t_limit_email_domain$", '', $p_email );

			PRINT '<input type="text" name="'.$p_field_name.'" size="20" maxlength="64" value="'.$p_email.'" />@'.$t_limit_email_domain;

		} else {

			PRINT '<input type="text" name="'.$p_field_name.'" size="32" maxlength="64" value="'.$p_email.'" />';

		}

	}

	# --------------------

	# print out an email editing input

	function print_captcha_input( $p_field_name ) {

		echo '<input type="text" name="'.$p_field_name.'" size="5" maxlength="5" value="" />';

	}

	###########################################################################

	# Option List Printing API

	###########################################################################

	# --------------------

	# sorts the array by the first element of the array element

	# @@@ might not be used

	function cmp( $p_var1, $p_var2 ) {

		if ( $p_var1[0][0] == $p_var2[0][0] ) {

			return 0;

		}

		if ( $p_var1[0][0] < $p_var2[0][0] ) {

			return -1;

		} else {

			return 1;

		}

	}

	# --------------------

	# This populates an option list with the appropriate users by access level

	#

	# @@@ from print_reporter_option_list

	function print_user_option_list( $p_user_id, $p_project_id = null, $p_access = ANYBODY ) {

		$t_users = array();

		if ( null === $p_project_id ) {

			$p_project_id = helper_get_current_project();

		}

		$t_users = project_get_all_user_rows( $p_project_id, $p_access ); # handles ALL_PROJECTS case

		$t_display = array();

		$t_sort = array();

		$t_show_realname = ( ON == config_get( 'show_realname' ) );

		$t_sort_by_last_name = ( ON == config_get( 'sort_by_last_name' ) );

		foreach ( $t_users as $t_user ) {

			$t_user_name = string_attribute( $t_user['username'] );

			$t_sort_name = strtolower( $t_user_name );

			if ( $t_show_realname && ( $t_user['realname'] <> "" ) ){

				$t_user_name = string_attribute( $t_user['realname'] );

				if ( $t_sort_by_last_name ) {

					$t_sort_name_bits = split( ' ', strtolower( $t_user_name ), 2 );

					$t_sort_name = ( isset( $t_sort_name_bits[1] ) ? $t_sort_name_bits[1] . ', ' : '' ) . $t_sort_name_bits[0];

				} else {

					$t_sort_name = strtolower( $t_user_name );

				}

			}

			$t_display[] = $t_user_name;

			$t_sort[] = $t_sort_name;

		}

		array_multisort( $t_sort, SORT_ASC, SORT_STRING, $t_users, $t_display );

		for ($i = 0; $i < count( $t_sort ); $i++ ) {

			$t_row = $t_users[$i];

			PRINT '

			check_selected( $p_user_id, $t_row['id'] );

			PRINT '>' . $t_display[$i] . '</option>';

		}

	}

	# --------------------

	# ugly functions  need to be refactored

	# This populates the reporter option list with the appropriate users

	#

	# @@@ This function really ought to print out all the users, I think.

	#  I just encountered a situation where a project used to be public and

	#  was made private, so now I can't filter on any of the reporters who

	#  actually reported the bugs at the time. Maybe we could get all user

	#  who are listed as the reporter in any bug?  It would probably be a

	#  faster query actually.

	function print_reporter_option_list( $p_user_id, $p_project_id = null ) {

		print_user_option_list( $p_user_id, $p_project_id, config_get( 'report_bug_threshold' ) );

	}

	# --------------------

	function print_duplicate_id_option_list() {

	    $query = "SELECT id

	    		FROM " . config_get ( 'mantis_bug_table' ) . "

	    		ORDER BY id ASC";

	    $result = db_query( $query );

	    $duplicate_id_count = db_num_rows( $result );

	    PRINT '<option value="0"></option>';

	    for ($i=0;$i<$duplicate_id_count;$i++) {

	    	$row = db_fetch_array( $result );

	    	$t_duplicate_id	= $row['id'];

			PRINT "<option value=\"$t_duplicate_id\">".$t_duplicate_id."</option>";

		}

	}

	/**

	 * Print the entire form for attaching a tag to a bug.

	 * @param integer Bug ID

	 * @param string Default contents of the input box

	 */

	function print_tag_attach_form( $p_bug_id, $p_string="" ) {

		?>

		<small></small> 

		<form method="post" action="tag_attach.php">

		<input type="hidden" name="bug_id" value="<?php echo $p_bug_id ?>" />

			print_tag_input( $p_bug_id, $p_string );

		?>

		<input type="submit" value="<?php echo lang_get( 'tag_attach' ) ?>" class="button" />

		</form>

		return true;

	}

	/**

	 * Print the separator comment, input box, and existing tag dropdown menu.

	 * @param integer Bug ID

	 * @param string Default contents of the input box

	 */

	function print_tag_input( $p_bug_id = 0, $p_string="" ) {

		?>

		<input type="hidden" id="tag_separator" value="<?php echo config_get( 'tag_separator' ) ?>" />

		<input type="text" name="tag_string" id="tag_string" size="40" value="<?php echo string_attribute( $p_string ) ?>" />

		<select <?php echo helper_get_tab_index() ?> name="tag_select" id="tag_select">

		</select>

		return true;

	}

	/**

	 * Print the dropdown combo-box of existing tags.

	 * When passed a bug ID, the option list will not contain any tags attached to the given bug.

	 * @param integer Bug ID

	 */

	function print_tag_option_list( $p_bug_id = 0 ) {

		$t_tag_table = config_get( 'mantis_tag_table' );

		$query = "SELECT id, name FROM $t_tag_table ";

		if ( 0 != $p_bug_id ) {

			$c_bug_id = db_prepare_int( $p_bug_id );

			$t_bug_tag_table = config_get( 'mantis_bug_tag_table' );

			$query .= "	WHERE id NOT IN ( 

						SELECT tag_id FROM $t_bug_tag_table WHERE bug_id='$c_bug_id' ) ";

		}

		$query .= " ORDER BY name ASC ";

		$result = db_query( $query );

		echo '<option value="0">',lang_get( 'tag_existing' ),'</option>';

		while ( $row = db_fetch_array( $result ) ) {

			echo '<option value="',$row['id'],'" onclick="tag_string_append(\'',$row['name'],'\')">',$row['name'],'</option>';

		}

	}

	# --------------------

	# Get current headlines and id  prefix with v_

	function print_news_item_option_list() {

		$t_mantis_news_table = config_get( 'mantis_news_table' );

		$t_project_id = helper_get_current_project();

		if ( access_has_project_level( ADMINISTRATOR ) ) {

			$query = "SELECT id, headline, announcement, view_state

				FROM $t_mantis_news_table

				ORDER BY date_posted DESC";

		} else {

			$query = "SELECT id, headline, announcement, view_state

				FROM $t_mantis_news_table

				WHERE project_id='$t_project_id'

				ORDER BY date_posted DESC";

		}

	    $result = db_query( $query );

	    $news_count = db_num_rows( $result );

		for ($i=0;$i<$news_count;$i++) {

			$row = db_fetch_array( $result );

			extract( $row, EXTR_PREFIX_ALL, 'v' );

			$v_headline = string_display( $v_headline );

			$t_notes = array();

			$t_note_string = '';

			if ( 1 == $v_announcement ) {

				array_push( $t_notes, lang_get( 'announcement' ) );

			}

			if ( VS_PRIVATE == $v_view_state ) {

				array_push( $t_notes, lang_get( 'private' ) );

			}

			if ( sizeof( $t_notes ) > 0 ) {

				$t_note_string = ' ['.implode( ' ', $t_notes ).']';

			}

			PRINT "<option value=\"$v_id\">$v_headline$t_note_string</option>";

		}

	}

	#---------------

	# Constructs the string for one news entry given the row retrieved from the news table.

	function print_news_entry( $p_headline, $p_body, $p_poster_id, $p_view_state, $p_announcement, $p_date_posted ) {

		$t_headline = string_display_links( $p_headline );

		$t_body = string_display_links( $p_body );

		$t_date_posted = date( config_get( 'normal_date_format' ), $p_date_posted );

		if ( VS_PRIVATE == $p_view_state ) {

			$t_news_css = 'news-heading-private';

		} else {

			$t_news_css = 'news-heading-public';

		}

		$output .= '
' . $t_headline . '
';

		$output .= '
';

		$output .= '
';

		$output .= $t_date_posted . ' - ';

		echo $output;

		# @@@ eventually we should replace print's with methods to construct the

		#     strings.

		print_user( $p_poster_id );

		$output = '';

		if ( 1 == $p_announcement ) {

			$output .= ' - [' . lang_get( 'announcement' ) . ']';

		}

		if ( VS_PRIVATE == $p_view_state ) {

			$output .= ' - [' . lang_get( 'private' ) . ']';

		}

		$output .= '
';

		$output .= '
' . $t_body . '
';

		$output .= '';

		echo $output;

	}

	# --------------------

	# print a news item given a row in the news table.

        function print_news_entry_from_row( $p_news_row ) {

		extract( $p_news_row, EXTR_PREFIX_ALL, 'v' );

		print_news_entry( $v_headline, $v_body, $v_poster_id, $v_view_state, $v_announcement, $v_date_posted );

	}

	# --------------------

	# print a news item

	function print_news_string_by_news_id( $p_news_id ) {

		$row = news_get_row( $p_news_id );

		# only show VS_PRIVATE posts to configured threshold and above

		if ( ( VS_PRIVATE == $row['view_state'] ) &&

			 !access_has_project_level( config_get( 'private_news_threshold' ) ) ) {

			return;

		}

		print_news_entry_from_row( $row );

	}

	# --------------------

	# Used for update pages

	function print_field_option_list( $p_list, $p_item='' ) {

		$t_mantis_bug_table = config_get( 'mantis_bug_table' );

		$t_category_string = get_enum_string( $t_mantis_bug_table, $p_list );

	    $t_arr = explode_enum_string( $t_category_string );

		$entry_count = count( $t_arr );

		for ($i=0;$i<$entry_count;$i++) {

			$t_s = str_replace( '\'', '', $t_arr[$i] );

			PRINT "

			check_selected( $p_item, $t_s );

			PRINT ">$t_s</option>";

		} # end for

	}

	# --------------------

	function print_assign_to_option_list( $p_user_id='', $p_project_id = null, $p_threshold = null ) {

		if ( null === $p_threshold ) {

			$p_threshold = config_get( 'handle_bug_threshold' );

		}

		print_user_option_list( $p_user_id, $p_project_id, $p_threshold );

	}

	# --------------------

	# List projects that the current user has access to

	function print_project_option_list( $p_project_id = null, $p_include_all_projects = true, $p_filter_project_id = null, $p_trace = false ) {

		project_cache_all();

		$t_project_ids = current_user_get_accessible_projects();

		if ( $p_include_all_projects ) {

			PRINT '

			check_selected( $p_project_id, ALL_PROJECTS );

			PRINT '>' . lang_get( 'all_projects' ) . '</option>' . "\n";

		}

		$t_project_count = count( $t_project_ids );

		for ($i=0;$i<$t_project_count;$i++) {

			$t_id = $t_project_ids[$i];

			if ( $t_id != $p_filter_project_id ) {

				PRINT "

				check_selected( $p_project_id, $t_id );

				PRINT '>' . string_display( project_get_field( $t_id, 'name' ) ) . '</option>' . "\n";

				print_subproject_option_list( $t_id, $p_project_id, $p_filter_project_id, $p_trace );

			}

		}

	}

	# --------------------

	# List projects that the current user has access to

	function print_subproject_option_list( $p_parent_id, $p_project_id = null, $p_filter_project_id = null, $p_trace = false, $p_parents = Array() ) {

		array_push( $p_parents, $p_parent_id );

		$t_project_ids = current_user_get_accessible_subprojects( $p_parent_id );

		$t_project_count = count( $t_project_ids );

		for ($i=0;$i<$t_project_count;$i++) {

			$t_full_id = $t_id = $t_project_ids[$i];

			if ( $t_id != $p_filter_project_id ) {

				PRINT "

				if ( $p_trace ) {

				  $t_full_id = join( $p_parents, ";") . ';' . $t_id;

				}

				PRINT "$t_full_id\"";

				check_selected( $p_project_id, $t_full_id );

				PRINT '>' . str_repeat( ' ', count( $p_parents ) ) . str_repeat( '»', count( $p_parents ) ) . ' ' . string_display( project_get_field( $t_id, 'name' ) ) . '</option>' . "\n";

				print_subproject_option_list( $t_id, $p_project_id, $p_filter_project_id, $p_trace, $p_parents );

			}

		}

	}

	# --------------------

	# Print extended project browser

	function print_extended_project_browser( $p_trace=Array() ) {

		project_cache_all();

		$t_project_ids = current_user_get_accessible_projects();

		echo '<script type="text/javascript" language="JavaScript">' . "\n";

		echo "

		echo "var subprojects = new Object();\n";

		$t_projects = Array();

		$t_project_count = count( $t_project_ids );

		for ($i=0;$i<$t_project_count;$i++) {

			$t_id = $t_project_ids[$i];

			echo 'subprojects[\'' . $t_id . '\'] = new Object();' . "\n";

			$t_name = project_get_field( $t_id, 'name' );

			$c_name = addslashes( $t_name );

			echo 'subprojects[\'' . $t_id . '\'][\'' . $t_id . '\'] = \'' . $c_name . '\';' . "\n";

			$t_projects[$t_id] = $t_name;

			print_extended_project_browser_subproject_javascript( $t_id );

		}

		echo "\n";

		echo 'function setProject(projectVal) {' . "\n";

		echo "\t" . 'var spInput = document.form_set_project.project_id;' . "\n";

		echo "\t" . 'spInput.options.length = 0' . "\n";

		echo "\t" . 'if (projectVal == "' . ALL_PROJECTS . '") {' . "\n";

		echo "\t\t" . 'spInput.options[0] = new Option(\'--- All Projects ---\', \'' . ALL_PROJECTS . '\');' . "\n";

		echo "\t" . '} else {' . "\n";

		echo "\t\t" . 'var i = 0;' . "\n";

		echo "\t\t" . 'var project = subprojects[ projectVal ];' . "\n";

		echo "\t\t" . 'for ( var sp in project ) {' . "\n";

		echo "\t\t\t" . 'spInput.options[ i++ ] = new Option( project[sp], sp );' . "\n";

		echo "\t\t" . '}' . "\n";

		echo "\t" . '}' . "\n";

		echo '}' . "\n";

		echo '// --></script>' . "\n";

		echo '<select name="top_id" onChange="setProject(this.value); document.form_set_project.submit()" class="small">' . "\n";

		echo '

		echo check_selected( $p_project_id, ALL_PROJECTS );

		echo '>' . lang_get('all_projects') . '</option>' . "\n";

		foreach ( $t_projects as $t_id => $t_name ) {

			$c_name = string_display( $t_name );

			echo '

			echo check_selected( $p_project_id, $t_id );

		        echo '>' . $c_name . '</option>' . "\n";

		}

		echo '</select>' . "\n";

		if ( 0 === count( $p_trace ) ) {

			$t_top_id = ALL_PROJECTS;

		} else {

			$t_top_id = $p_trace[0];

			$t_trace_str = join( ';', $p_trace );

		}

		echo '<select name="project_id" onChange="document.form_set_project.submit()" class="small-subprojects"></select>' . "\n";

		echo '<script type="text/javascript" language="JavaScript">' . "\n";

		echo '

		echo 'document.form_set_project.top_id.value = \'' . $t_top_id . '\';'. "\n";

		echo 'setProject(' . $t_top_id . ');' . "\n";

		echo 'document.form_set_project.project_id.value = \'' . $t_trace_str . '\';' . "\n";

		echo '// --></script>' . "\n";

	}

	# --------------------

	# print the subproject javascript for the extended project browser

	function print_extended_project_browser_subproject_javascript( $p_trace ) {

		$t_trace_projects = split( ';', $p_trace);

		$t_top_id = $t_trace_projects[0];

		$t_level = count( $t_trace_projects );

		$t_parent_id = $t_trace_projects[ $t_level - 1 ];

		$t_project_ids = current_user_get_accessible_subprojects( $t_parent_id );

		$t_project_count = count( $t_project_ids );

		for ($i=0;$i<$t_project_count;$i++) {

			$t_id = $t_project_ids[$i];

			$t_nbsp = chr( 160 );

			$t_name = addslashes( str_repeat( $t_nbsp , $t_level ) . str_repeat( '»', $t_level ) . ' ' . project_get_field( $t_id, 'name' ) );

			echo 'subprojects[\'' . $t_top_id . '\'][\'' . $p_trace . ';' . $t_id . '\'] = \'' . $t_name . '\';' . "\n";

			print_extended_project_browser_subproject_javascript( $p_trace . ';' . $t_id );

		}

	}

	# --------------------

	# prints the profiles given the user id

	function print_profile_option_list( $p_user_id, $p_select_id='', $p_profiles = null ) {

		if ( '' === $p_select_id ) {

			$p_select_id = profile_get_default( $p_user_id );

		}

		if ( $p_profiles != null ) {

			$t_profiles = $p_profiles;

		} else {

			$t_profiles = profile_get_all_for_user( $p_user_id );

		}

		print_profile_option_list_from_profiles( $t_profiles, $p_select_id );

	}

	# --------------------

	# prints the profiles used in a certain project

	function print_profile_option_list_for_project( $p_project_id, $p_select_id='', $p_profiles = null) {

		if ( '' === $p_select_id ) {

			$p_select_id = profile_get_default( $p_user_id );

		}

		if ( $p_profiles != null ) {

			$t_profiles = $p_profiles;

		} else {

			$t_profiles = profile_get_all_for_project( $p_project_id );

		}

		print_profile_option_list_from_profiles( $t_profiles, $p_select_id );

	}

	# --------------------

	# print the profile option list from profiles array

	function print_profile_option_list_from_profiles ( $p_profiles, $p_select_id) {

		echo '<option value=""></option>';

		foreach ( $p_profiles as $t_profile ) {

			extract( $t_profile, EXTR_PREFIX_ALL, 'v' );

			$v_platform	= string_display( $v_platform );

			$v_os		= string_display( $v_os );

			$v_os_build	= string_display( $v_os_build );

			echo '

			check_selected( $p_select_id, $v_id );

			echo '>' . $v_platform . ' ' . $v_os . ' ' . $v_os_build . '</option>';

		}

	}

	# --------------------

	function print_news_project_option_list( $p_project_id ) {

		$t_mantis_project_table = config_get( 'mantis_project_table' );

		$t_mantis_project_user_list_table = config_get( 'mantis_project_user_list_table' );

		if ( access_has_project_level( ADMINISTRATOR ) ) {

			$query = "SELECT *

					FROM $t_mantis_project_table

					ORDER BY name";

		} else {

			$t_user_id = auth_get_current_user_id();

			$query = "SELECT p.id, p.name

					FROM $t_mantis_project_table p, $t_mantis_project_user_list_table m

					WHERE 	p.id=m.project_id AND

							m.user_id='$t_user_id' AND

							p.enabled='1'";

		}

		$result = db_query( $query );

		$project_count = db_num_rows( $result );

		for ($i=0;$i<$project_count;$i++) {

			$row = db_fetch_array( $result );

			extract( $row, EXTR_PREFIX_ALL, 'v' );

			PRINT "

			check_selected( $v_id, $p_project_id );

			PRINT ">$v_name</option>";

		} # end for

	}

	# --------------------

	# Since categories can be orphaned we need to grab all unique instances of category

	# We check in the project category table and in the bug table

	# We put them all in one array and make sure the entries are unique

	function print_category_option_list( $p_category='', $p_project_id = null ) {

		$t_mantis_project_category_table = config_get( 'mantis_project_category_table' );

		if ( null === $p_project_id ) {

			$c_project_id = helper_get_current_project();

		} else {

			$c_project_id = db_prepare_int( $p_project_id );

		}

		$t_project_where = helper_project_specific_where( $c_project_id );

		# grab all categories in the project category table

		$cat_arr = array();

		$query = "SELECT DISTINCT category

				FROM $t_mantis_project_category_table

				WHERE $t_project_where

				ORDER BY category";

		$result = db_query( $query );

		$category_count = db_num_rows( $result );

		for ($i=0;$i<$category_count;$i++) {

			$row = db_fetch_array( $result );

			$cat_arr[] = string_attribute( $row['category'] );

		}

		# Add the default option if not in the list retrieved from DB		

		# This is useful for default categories and when updating an

		# issue with a deleted category.

		if ( !is_blank( $p_category ) && !in_array( $p_category, $cat_arr ) ) {

			$cat_arr[] = $p_category;

		}

		sort( $cat_arr );

		$cat_arr = array_unique( $cat_arr );

		foreach( $cat_arr as $t_category ) {

			PRINT "

			check_selected( $t_category, $p_category );

			PRINT ">$t_category</option>";

		}

	}

	# --------------------

	# Since categories can be orphaned we need to grab all unique instances of category

	# We check in the project category table and in the bug table

	# We put them all in one array and make sure the entries are unique