function version_add($p_project_id, $p_version, $p_released = VERSION_RELEASED, $p_description = '', $p_date_order = null)
{
$c_project_id = db_prepare_int($p_project_id);
$c_released = db_prepare_int($p_released);
$c_version = db_prepare_string($p_version);
$c_description = db_prepare_string($p_description);
if (null === $p_date_order) {
$c_date_order = db_now();
} else {
$c_date_order = db_timestamp($p_date_order);
}
version_ensure_unique($p_version, $p_project_id);
$t_project_version_table = config_get('mantis_project_version_table');
$query = "INSERT INTO {$t_project_version_table}\r\n\t\t\t\t\t( project_id, version, date_order, description, released )\r\n\t\t\t\t VALUES\r\n\t\t\t\t\t( '{$c_project_id}', '{$c_version}', " . $c_date_order . ", '{$c_description}', '{$c_released}' )";
db_query($query);
# db_query() errors on failure so:
return true;
}
/**
* Add a version to the project
* @param int $p_project_id
* @param string $p_version
* @param int $p_released
* @param string $p_description
* @param int $p_date_order
* @param bool $p_obsolete
* @return int
*/
function version_add($p_project_id, $p_version, $p_released = VERSION_FUTURE, $p_description = '', $p_date_order = null, $p_obsolete = false)
{
$c_project_id = db_prepare_int($p_project_id);
$c_released = db_prepare_int($p_released);
$c_obsolete = db_prepare_bool($p_obsolete);
if (null === $p_date_order) {
$c_date_order = db_now();
} else {
$c_date_order = $p_date_order;
}
version_ensure_unique($p_version, $p_project_id);
$t_project_version_table = db_get_table('project_version');
$query = "INSERT INTO {$t_project_version_table}\n\t\t\t\t\t( project_id, version, date_order, description, released, obsolete )\n\t\t\t\t VALUES\n\t\t\t\t\t(" . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ' )';
db_query_bound($query, array($c_project_id, $p_version, $c_date_order, $p_description, $c_released, $c_obsolete));
# db_query errors on failure so:
return db_insert_id($t_project_version_table);
}
/**
* Add a version to the project
* @param integer $p_project_id A valid project id.
* @param string $p_version Name of a version to add.
* @param integer $p_released Release status of the version.
* @param string $p_description Description of the version.
* @param integer $p_date_order Date Order.
* @param boolean $p_obsolete Obsolete status of the version.
* @return integer
*/
function version_add( $p_project_id, $p_version, $p_released = VERSION_FUTURE, $p_description = '', $p_date_order = null, $p_obsolete = false ) {
$c_project_id = (int)$p_project_id ;
$c_released = (bool)$p_released;
$c_obsolete = (bool)$p_obsolete;
if( null === $p_date_order ) {
$c_date_order = db_now();
} else {
$c_date_order = $p_date_order;
}
version_ensure_unique( $p_version, $p_project_id );
$t_query = 'INSERT INTO {project_version}
( project_id, version, date_order, description, released, obsolete )
VALUES
(' . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ' )';
db_query( $t_query, array( $c_project_id, $p_version, $c_date_order, $p_description, $c_released, $c_obsolete ) );
$t_version_id = db_insert_id( db_get_table( 'project_version' ) );
event_signal( 'EVENT_MANAGE_VERSION_CREATE', array( $t_version_id ) );
return $t_version_id;
}
