core_news_API.php

<?php
	# Mantis - a php based bugtracking system
	# Copyright (C) 2000, 2001  Kenzaburo Ito - kenito@300baud.org
	# This program is distributed under the terms and conditions of the GPL
	# See the files README and LICENSE for details

	###########################################################################
	# News API
	###########################################################################

	# function news_add   ( $p_project_id, $p_poster_id, $p_headline, $p_body );
	# function news_delete( $p_id );
	# function news_update( $p_id, $p_headline, $p_body );
	# function news_select( $p_id );

	# --------------------
	function news_add_query( $p_project_id, $p_poster_id, $p_headline, $p_body ) {
		global $g_mantis_news_table;

		# " character poses problem when editting so let's just convert them
		$p_headline	= string_prepare_text( $p_headline );
		$p_body		= string_prepare_textarea( $p_body );

		# Add item
		$query = "INSERT
				INTO $g_mantis_news_table
	    		( id, project_id, poster_id, date_posted, last_modified, headline, body )
				VALUES
				( null, '$p_project_id', '$p_poster_id', NOW(), NOW(), '$p_headline', '$p_body' )";
	    return db_query( $query );
	}
	# --------------------
	# Delete the news entry
	function news_delete_query( $p_id ) {
		global $g_mantis_news_table;

		$query = "DELETE
				FROM $g_mantis_news_table
	    		WHERE id='$p_id'";
	    return db_query( $query );
	}
	# --------------------
	# Update news item
	function news_update_query( $p_id, $p_headline, $p_body, $p_project_id ) {
		global $g_mantis_news_table;

		# " character poses problem when editting so let's just convert them to '
		$p_headline	= string_prepare_text( $p_headline );
		$p_body		= string_prepare_textarea( $p_body );

		# Update entry
		$query = "UPDATE $g_mantis_news_table
				SET headline='$p_headline', body='$p_body',
					project_id='$p_project_id', last_modified=NOW()
	    		WHERE id='$p_id'";
	    return db_query( $query );
	}
	# --------------------
	# Selects the news item associated with the specified id
	function news_select_query( $p_id ) {
		global $g_mantis_news_table;

		$query = "SELECT *
			FROM $g_mantis_news_table
			WHERE id='$p_id'";
	    $result = db_query( $query );
		return db_fetch_array( $result );
	}
	# --------------------
	# get news count (selected project plus sitewide posts)
	function news_count_query( $p_project_id ) {
		global $g_mantis_news_table;

		$query = "SELECT COUNT(*)
				FROM $g_mantis_news_table
				WHERE project_id='$p_project_id' OR project_id='0000000'";
		$result = db_query( $query );
	    return db_result( $result, 0, 0 );
	}
	# --------------------
?>